tbl_updateattendance_history

-1 rows


Description

Module: Attendance
Purpose: Stores historical records of employee attendance updates.
Data: One row is created for each attendance update for a specific employee and date.
Process Usage:
- Tracks when an employee’s attendance is updated or reverted.
- Maintains flags for effect removal to indicate whether the update was later reverted.
Key Points:
- Provides an audit trail of attendance changes.
- Useful for compliance, payroll verification, and reporting.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each attendance update record.
employeeid varchar 255 null

Meaning: References the employee whose attendance was updated.
Usage: Links the attendance update record to a specific employee.
date date 13 null

Meaning: The date for which attendance was updated.
Usage: Identifies the specific day affected by the update.
forceupdate varchar 50 √ null

Status: Currently unused in code.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
updatedhours int4 10 √ null

Status: Currently unused in code.
effectremoved bool 1 √ null

Meaning: Indicates whether the effect of the attendance update was reverted.
Usage: True if the update was undone, otherwise false.

Indexes

Constraint Name Type Sort Column(s)
tbl_updateattendance_history_pk_tbl_updateattendance_history Primary key Asc id

Relationships

Close relationships within degrees of separation