tbl_employee_attendance_policy

-1 rows


Description

Module: HRMS Attendance & Timekeeping
Purpose: This is a mapping table that assigns a specific attendance policy to an individual employee.
Data: Each row represents a single, explicit link between one employee and one attendance policy.
Process Usage:
- Used when an employee requires a policy different from the default (e.g., a default policy might apply to their Grade or Location, but this table overrides it).
- When the daily attendance process runs, it checks this table first for an employee. If a record exists, it uses the “policyid” found here.
- If no record exists, the system falls back to the default policy.
- Populated by an HR Admin via an “Assign Policy to Employee” screen.
Business Impact: Provides granular, per-employee control over attendance rules. Essential for managing exceptions (e.g., special rules for part-timers, senior management, or specific roles).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_employee_attendance_policy_id_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single employee-to-policy assignment.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid (or similar employee master table)
Meaning: The employee who is being assigned this specific policy.
Dependency: Links this rule to a single employee record.
policyid int8 19 null

FK: public.tbl_attendance_policy_master.id (or similar policy master table)
Meaning: The specific attendance policy being assigned to this employee.
Dependency: Links to the master record that defines the actual rules (e.g., late marks, half-day, minimum hours).
createdby varchar 50 √ null

FK: public.tbl_userlogin.id (or similar user table)
Meaning: The user (e.g., HR Admin) who created this policy assignment.
Usage: Audit trail.
createddate timestamp 29,6 √ null

Timestamp of when the assignment was created.
Stored as: UTC
Usage: Audit trail.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id (or similar user table)
Meaning: The last user to make a change to this record (e.g., changing the policy for this employee).
Usage: Audit trail.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification.
Stored as: UTC
Usage: Audit trail.

Indexes

Constraint Name Type Sort Column(s)
tbl_employee_attendance_policy_pk_tbl_employee_attendance_polic Primary key Asc id
tbl_employee_attendance_policy_idx_employee_tbl_employee_attend Performance Asc employeeid
tbl_employee_attendance_policy_idx_policyid_tbl_employee_attend Performance Asc policyid

Relationships

Close relationships within degrees of separation