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 |