tbl_dailyattendancenimporthistory

-1 rows


Description

Module: HRMS Attendance/Time Management - Daily Attendance and Import History
Purpose: Stores an immutable, detailed historical record of employee daily attendance entries, including the original imported/punched data and any subsequent corrections made by HR or the employee/manager.
Data: Captures the employee ID, the date, the recorded/corrected In and Out times, total hours worked, and flags indicating if the entry resulted from a bulk import or a subsequent change.
Process Usage:
- Auditing: Provides a transparent and auditable trail of attendance data, essential for compliance and resolving time discrepancies.
- Correction Tracking: Used to see the history of a specific daily attendance record in the master table (e.g., tracking the original punch vs. the manually corrected time).
Key Points:
- Data Integrity: Ensures that all attendance modifications are logged.
- The AbstractAuditingEntity parent class captures who made the change and when.
Business Impact: Critical for accurate payroll inputs and robust time management compliance.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific history log entry.
employeeid varchar 50 null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID associated with this attendance record.
date date 13 null

The calendar date (day) this attendance record is for.
shiftnextdayout bool 1 √ null

Boolean flag: Indicates if the punch-out time occurred on the following calendar day (e.g., for night shifts).
correctedintime timestamp 29,6 √ null

The final or corrected punch-in time recorded for the employee on the specific date.
correctedouttime timestamp 29,6 √ null

The final or corrected punch-out time recorded for the employee on the specific date.
createddate timestamp 29,6 √ null
createdby varchar 50 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
totalhours int4 10 √ null

The calculated total hours worked based on the CorrectedInTime and CorrectedOutTime.
isimport bool 1 false

Boolean flag: Indicates if this history record was created as part of a bulk data import process (TRUE) or a manual correction/punch (FALSE).

Indexes

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

Relationships

Close relationships within degrees of separation