Time Clock Report — Column Reference
This page explains every column available in the Time Clock Report. This report shows both timesheets and expense records in a single view, with the timesheet rows including a full day-by-day breakdown of hours. Each row is either a Timesheet or an Expense — the ItemType column tells you which.
Direct Link to Report: https://reports.simplevms.com/Report/12/Time-Clock-Master
Grouping Columns
|
Column |
What it shows |
|---|---|
|
Site_Group |
Same as Site — used as a grouping key |
|
Vendor_Group |
Same as Vendor — used as a grouping key |
Worker & Assignment Information
|
Column |
What it shows |
|---|---|
|
Site |
Name of the site the worker is assigned to |
|
Worker |
Worker's full display name |
|
WorkerID |
SimpleVMS internal ID for the worker |
|
TeamName |
Worker's team |
|
Vendor |
Staffing vendor supplying this worker |
|
Department |
Worker's department |
|
StartDate |
Start date of the timesheet work week (Sunday) or expense period |
|
EndDate |
End date of the timesheet work week (Saturday) or expense period |
Record Type & Status
|
Column |
What it shows |
|---|---|
|
ItemType |
Whether this row is a Timesheet or an Expense |
|
ItemID |
Internal ID of the timesheet or expense record |
|
Status |
Workflow status: Created, Submitted, Approved, or Rejected |
|
CreatedDate |
When the timesheet or expense was created |
|
SubmittedDate |
When the record was submitted for approval |
|
ApprovedDate |
When the record was approved |
|
Notes |
Notes attached to the timesheet or expense record |
Summary Hours & Totals
These columns summarize the full week. For expenses, all hour columns are blank and only Total is populated.
|
Column |
What it shows |
|---|---|
|
RegHours |
Total regular hours for the week |
|
OTHours |
Total overtime hours for the week |
|
DTHours |
Total double-time hours for the week |
|
Hours |
Total hours (Reg + OT + DT) for the week |
|
RegTotal |
Billed amount for regular hours |
|
OTTotal |
Billed amount for overtime hours |
|
DTTotal |
Billed amount for double-time hours |
|
Total |
Grand total billed. For expenses: sum of all expense line items. |
Daily Hour Breakdown (Timesheets Only)
These columns show hours entered per day of the work week. Day 1 = Sunday, Day 7 = Saturday.
|
Column |
What it shows |
|---|---|
|
BillableHoursDay1–7 |
Regular hours entered for each day of the week |
|
OvertimeHoursDay1–7 |
Overtime hours entered for each day of the week |
|
DoubletimeHoursDay1–7 |
Double-time hours entered for each day of the week |
Rates
|
Column |
What it shows |
|---|---|
|
BillableRate |
Worker's hourly bill rate |
|
OvertimeFactor |
Overtime multiplier (e.g., 1.5) |
|
DoubletimeFactor |
Double-time multiplier (e.g., 2.0) |