Timesheet

Timesheet is the main component in the Time & Attendance module. Timesheet collection enables analysis of timesheet data such as work hours, clock punches, and overrides.


Fact table	Description	Source table
Work Fact	Tracks the details of all the work such as the number of minutes worked, time code, hour type, which employee worked, and calc group	Work Detail
Work Adjust Fact	Tracks the retroactive submissions of the timesheet such as changes to the pay rate and hours	Work Detail Adjust
Override Fact	Tracks the overrides related to the timesheet	Override
Employee Balance Fact	Stores the current snapshot of each employee’s leave or time-off balances. Unlike the log, which is transactional, this table is typically summary-level and used for real-time reporting.	Employee Balance
Employee Balance Log Fact	Stores transaction-level changes to an employee’s leave or time-off balance over time. The table helps track how balances such as leave, vacation, or sick are earned, adjusted, and used.	Employee Balance Log
Time Off Day Fact	Stores day-level details of approved, pending, or taken time-off requests. The table breaks down each time-off request into individual calendar days, making it useful for day-wise reporting and analysis.	Time Off Day
AcViolation Log Fact		Violation Log