Data Model: Timesheets

Timesheet Owner—The user to whom the timesheet belongs.
Start Date—The start date for the timesheet.
Timesheet Start Date Groups
Date group query items are useful for reporting trends over time. If you include a date group item and pivot your report on that item, you can see how something is trending over time.
- Timesheet Start Week—
- Timesheet Start Month—
- Timesheet Start Quarter—
End Date—The end date for the timesheet.
Timesheet Period—The period of the timesheet.
Comments—The timesheet comments.
Timesheet Status—The status of the timesheet. Options are Open and Closed.
Approval Status—The approval status of the timesheet. Options are Pending, Approved, Declined, Not Required, Overridden, Request and Action.
Note: If you want to limit your report to timesheets with a particular approval status, see the Timesheets Filters for predefined filters based on approval status.
Timesheet Count—The total count of timesheets in the report. This also provides subtotals for any groupings of timesheets you include in the report. This value can change as you add or remove items that impact the number of timesheets in the report.
Note: Timesheet Count counts the unique GUID values for timesheets. This means that if you have 2 timesheets with identical names, Timesheet Count will be 2 even though your report shows a single timesheet.
Approval Type—The state of the approval. Options include Request and Action.
Created On—The date on which the timesheet was created.
Timesheet Owner Information
- Email—The email address of the timesheet owner.
- Phone—The phone number of the timesheet owner.
- Supervisor—The name of the supervisor of the timesheet owner.
- Resource Manager—The name of the resource manager of the timesheet owner.
- Department Name—The department to which the timesheet owner is assigned.
- Parent Department Name—The parent department for the department to which the timesheet owner is assigned (if applicable).
IDs
Note: IDs are included in the data model so you can join to other queries. Also, grouping on an ID can help separate different items with identical names.
- TimesheetID
- EnterpriseID
- OwnerID
UTC Dates
Note: UTC dates are shown in Coordinated Universal Time format. UTC is also known as Greenwich Meridian Time (GMT).
- Created On (UTC)—The date the timesheet was created.