Timesheet Details
The Timesheet Details dataset lists timesheets and their entries, for tracking hours by person, Work Order or Asset.
At a glance
| Item | Value |
|---|---|
| Picker heading | Data Tables |
| One row is | One timesheet entry, with its timesheet's header values |
| Presentations | Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Heatmap, Grouped Line, Column Chart Over Time, Line Chart Over Time, Area Chart Over Time |
| Default presentation | Table |
| Default period | Last 30 Days. Time charts start on Last Month. |
| Date basis | Timesheet Date, the only option. Both boundary dates are included. |
| Default columns | Header: Timesheet ID, Timesheet Date, Person Type, Person Name, Timesheet Status. Entries: Work Order / Category, Asset Number, Start Time, End Time, Entry Hours |
| Group Modes | Detail tables. Charts can use Detail or Consolidated. |
| Drill-through | Column Chart and Over Time charts |
Measures
| Measure | Unit | Aggregation | Definition |
|---|---|---|---|
| Timesheet count | Timesheets | Count | Number of timesheets. |
| Timesheet entry count | Entries | Count | Number of entries. This replaces Timesheet count when grouped by Work Order or an Asset field. |
| Entries: Entry Hours | Hours | Sum | Hours on each entry, added together. |
Columns
Column labels start with Header for timesheet values, or Entries for entry values.
| Section | Columns | Description |
|---|---|---|
| Header | Timesheet ID, Timesheet Date, Timesheet Status | The timesheet. |
| Header | Person Type, Person Name, Employee ID, Contractor ID | The person. Person Type is Employee or Contractor. |
| Header | Timesheet Hours, Timesheet Work Order Hours, Timesheet Category Hours | The timesheet's total hours and their split. |
| Header | Submitted At, Submitted By, Submitted By ID | Who submitted it, and when. |
| Header | Approved At, Approved By, Approved By ID | Who approved it, and when. |
| Header | Rejected At, Rejected By, Rejected By ID, Rejection Reason | Who rejected it, when and why. |
| Header | Notes, Created At, Updated At | Other timesheet details. |
| Entries | Entry ID, Entry Type, Work Order / Category | The entry. Entry Type is Work Order or Category. |
| Entries | Start Time, End Time, Entry Hours | The time on the entry. |
| Entries | Work Order ID, Work Order Number, Work Order Title | The entry's Work Order. |
| Entries | Category ID, Category Name, Category Description, Category Paid, Category Active, Category Sort Order | The entry's category. |
| Entries | Asset ID, Asset Number, Asset Description | The entry's Asset. |
| Entries | Notes, Created At, Updated At | Other entry details. |
| Asset | Asset Department, Class, Group, Asset Type, Manufacturer | The Asset's classification and department. |
| Asset | Asset Status, Criticality, Planning Type, Hire Status, Project, Customer | The Asset's details. |
Filters
| Filter | Choice | Behaviour |
|---|---|---|
| Employee, Contractor | Multiple | The person on the timesheet. |
| Timesheet Status | Multiple | Draft, Submitted, Approved or Rejected. |
| Site or Department | Multiple | The timesheet's department scope. |
| Entry Type | One choice | Work Order or Category. |
| Category | Multiple | The entry's category. |
| Work Order Number | Multiple | The entry's Work Order. |
| Asset Number | Multiple | The entry's Asset. |
| Asset Department | Multiple | The Asset's department. |
| Class, Group, Asset Type, Manufacturer | Multiple | The Asset's classification. |
| Asset Status, Criticality, Planning Type | Multiple | The Asset's details. |
| Hire Status | Yes, No, All | Whether the Asset is on hire. |
| Project, Customer | Multiple | The Asset's Project and Customer. |
Group By
| Group By | Groups by |
|---|---|
| By Timesheet | Each timesheet. |
| By Person Type | Employee or Contractor. |
| By Person Name | The person on the timesheet. |
| By Approved By | The approver. Timesheets with none appear under Not Approved. |
| By Work Order | The entry's Work Order. Entries with none appear under No Work Order. |
| By Asset | The entry's Asset. Entries with none appear under No Asset. |
| By Asset Department | The Asset's department. |
| By Class, By Group, By Asset Type, By Manufacturer | The Asset's classification. |
| By Planning Type, By Asset Status, By Criticality | The Asset's details. |
| By Hire Status | On Hire or Off Hire. |
| By Project, By Customer | The Asset's Project and Customer. |
Chart notes
- Group Mode set to Detail on an Entry Hours chart draws one bar per entry.
- Series by and Compare are not available. Compare with is available on Over Time charts only.
Business rules
- The count depends on the Group By. Grouping by Work Order or an Asset field counts entries. Other groupings count timesheets.
- An entry's Asset can come from its Work Order. An entry with no Asset of its own uses its Work Order's Asset.
- Entry hours are rounded per entry. Each entry is read to the minute and rounded to two decimals before adding up.
- Tables are limited, charts are not. A Table lists up to 100 timesheets, while charts count every match.
For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.