Workday · Time Tracking
Time Tracking
Worked hours are operational, paid hours are financial, and the module keeps the two honest: overtime extracted as calculated, cost from the payroll fact, and a control that catches unapproved time before the deadline.
◆Reports
Overtime & HoursLive
Configured thresholds, multi-position allocation, the approval gap, and paid-hours cost that matches payroll.
Reported vs Paid ReconciliationLive
The four-bucket gap, unapproved, comp in lieu, rounding, late approvals, closing exactly every period.
◆The model
| Table | Grain | Role |
|---|---|---|
| fct_payroll_result | One row per committed result line, hours on earning lines. | Paid hours and overtime cost. See Payroll Result. |
| stg_time_entries | One row per entered time block with approval status. | Operational: the pre-deadline unapproved-time control. Staged, not a star. |
| dim_pay_component | One row per code, with is_overtime and carries_hours flags. | The classification that makes the queries one-liners. |
Want hours and overtime that match payroll?
The paid-hours model and the pre-deadline control, reconciled against Workday, and you own every line.