Work Orders
The Work Orders dataset lists Work Orders with their counts, hours and costs, for tracking workload, completion and spend.
At a glance
| Item | Value |
|---|---|
| Picker heading | Data Tables |
| One row is | One Work Order in Detail, or one group in Consolidated |
| Presentations | All |
| Default presentation | Table |
| Default period | Last 30 Days on Scheduled At |
| Date basis options | Scheduled At, Started At, Completed At, Created At |
| Default columns | Work Order Number, Title, Task Type, Asset Number, Started At, Completed At, Asset Description |
| Group Modes | Detail and Consolidated, for tables and charts |
| Drill-through | Select a chart value to open its Work Orders, on all charts except Chart shows Measures |
Measures
| Measure | Unit | Aggregation | Definition |
|---|---|---|---|
| Work Order Count | Work Orders | Count | Number of Work Orders. |
| Open Work Orders | Work Orders | Count | Work Orders with status Open. |
| In Progress Work Orders | Work Orders | Count | Work Orders with status In Progress. |
| Complete Work Orders (Last 30 Days) | Work Orders | Count | Status Complete and completed in the 30 days before now. |
| Cancelled Work Orders (Last 30 Days) | Work Orders | Count | Status Cancelled and completed in the 30 days before now. |
| Work Orders (Status Summary) | Work Orders | Count | The four counts above added together. |
| Total Expected Duration Hours | Hours | Sum | Sum of each Work Order's Expected Duration Hours. |
| Total Expected Labour Hours | Hours | Sum | Sum of expected labour hours on cost items. |
| Total Actual Labour Hours | Hours | Sum | Sum of actual labour hours on cost items. |
| Total Expected Parts Cost | Cost | Sum | Sum of expected parts cost on cost items. |
| Total Expected Labour Cost | Cost | Sum | Sum of expected labour cost on cost items. |
| Total Expected Services Cost | Cost | Sum | Sum of expected services cost on cost items. |
| Total Expected Cost | Cost | Sum | Expected parts, labour and services cost added together. |
| Total Actual Parts Cost | Cost | Sum | Sum of actual parts cost on cost items. |
| Total Actual Labour Cost | Cost | Sum | Sum of actual labour cost on cost items. |
| Total Actual Services Cost | Cost | Sum | Sum of actual services cost on cost items. |
| Total Actual Cost | Cost | Sum | Actual parts, labour and services cost added together. |
These measures are also the Consolidated table columns, along with Group. The status counts are not shown until you add them.
Columns
These columns are available in Detail tables and View records.
| Column | Type | Description |
|---|---|---|
| Work Order Number | Text | The Work Order's number. |
| Work Order Numeric | Number | The numeric part of the Work Order number. |
| Title | Text | The Work Order's title. |
| Description | Text | The Work Order's description. |
| External Work Order Number | Text | The number from an external system. |
| Parent Work Order | Text | The parent Work Order's number. |
| Status | Text | The Work Order's status. |
| Custom Status | Text | The tenant's custom status. Your tenancy may use a different label. |
| Priority | Text | The Work Order's priority. |
| Work Type | Text | The type of work. |
| Task Type | Text | The type of the linked Task. |
| Task Code | Text | The Task code. |
| Task | Text | The linked Task's name. |
| Modifier Code | Text | The modifier code. |
| Source | Text | Where the defect was identified. |
| Source Type | Text | How the Work Order was created. |
| Failure | Text | The failure code. |
| Cause | Text | The cause code. |
| Symptom | Text | The recorded symptom. |
| Notes | Text | Work Order notes. |
| Breakdown | Yes/No | Whether this is breakdown work. |
| Statutory, Compliance Task | Yes/No | Whether this is compliance work. Both columns read the same value. |
| Linked Tasks | Yes/No | Whether the Work Order comes from a Task. |
| Linked Work Request | Yes/No | Whether a Work Request is linked. |
| Overdue | Yes/No | Open or In Progress with a Due Date in the past. |
| System Generated | Yes/No | Whether the system created the Work Order. |
| Is Modified | Yes/No | Whether the Work Order was modified. |
| Locked | Yes/No | Whether the Work Order is locked. |
| Potential Warranty | Yes/No | Whether a warranty claim may apply. |
| Confirm Completion | Yes/No | Whether completion must be confirmed. |
| Job Ready | Yes/No | Whether the job is ready. |
| Job Ready By, Job Ready Date, Job Ready Notes | Mixed | Who marked it ready, when, and any notes. |
| Asset Number, Asset Description | Text | The Work Order's Asset. |
| Asset Class, Asset Group, Asset Type, Manufacturer | Text | The Asset's classification. |
| Asset Planning Type, Asset Status, Criticality, Hire Status | Text | The Asset's planning and operating details. |
| Asset Department | Text | The Asset's department. |
| Project, Customer | Text | The Asset's Project and Customer. |
| Department | Text | The Work Order's own department. |
| Area | Text | The Work Order's area. |
| Organisation | Text | The organisation. |
| Cost Responsibility | Text | Who is responsible for the cost. |
| Team, Crew | Text | The assigned team and crew members. |
| Contractor Name | Text | The contractor. |
| Reporting To, Meeting Point | Text | Site arrangements for the job. |
| Location Address, GPS Coordinates | Text | Where the work takes place. |
| Completed By, Created By, Updated By | Text | The people who completed, created and last updated it. |
| Scheduled At, Started At, Completed At, Due Date | Date | The Work Order's key dates. |
| Created At, Updated At | Date | When the record was created and last updated. |
| Generated From Date | Date | The date the Work Order was generated from. |
| Event, Event Start, Event End | Mixed | The linked Event and its dates. |
| Expected Duration Hours | Number | The planned duration. |
| Expected Labour Hours, Actual Labour Hours | Number | Labour hours from cost items. |
| Expected Parts Cost, Expected Labour Cost, Expected Services Cost, Expected Total Cost | Number | Expected cost from cost items. |
| Actual Parts Cost, Actual Labour Cost, Actual Services Cost, Actual Total Cost | Number | Actual cost from cost items. |
| Purchase Order Numbers | Text | Purchase Orders linked through parts. |
| Cycle Group Order | Number | The order within a Task cycle group. |
| Ignore Component Life | Yes/No | Whether component life is ignored. |
| Component Start Value | Number | The component's start value. |
| Removed Component Serial Number, Fitted Component Serial Number, Fitted Component Start Usage | Mixed | Component changes. Shown only when component serial tracking is on. |
Filters
| Filter | Choice | Behaviour |
|---|---|---|
| Site or Department | Multiple | The Asset's department, or else the Area's, or else the Work Order's own. |
| Asset Department | Multiple | The Asset's department. |
| Asset Number | Multiple | The Work Order's Asset. |
| Asset Class, Asset 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. |
| Task Type, Task Code | Multiple | The linked Task's type and code. |
| Team | Multiple | The assigned team. |
| Crew Member | Multiple | Assigned crew. Can follow the person viewing the Dashboard. |
| Work Order Status | Multiple | Includes these statuses. |
| Exclude Work Order Status | Multiple | Leaves out these statuses. |
| Custom Status | Multiple | Needs permission to view Custom Status. |
| Priority, Source, Area | Multiple | The Work Order's values. |
| Scheduled Within | One choice | Next 24 Hours to Next 180 Days, or a Custom Date Range on Scheduled At. |
| Actual Within | One choice | Work Orders active in the range: started by its end and not completed before its start. |
| Created Within | One choice | Created in the last 24 Hours to 180 Days, or a Custom Date Range. |
| Created At | One choice | Age filter: created at least 7, 30, 60 or a custom number of days ago. |
| Linked Tasks | Both, Linked, Not Linked | Whether the Work Order comes from a Task. |
| Compliance Task, Recurring, Overdue | Yes, No, All | Limits to Work Orders with or without the flag. |
| Linked Work Request, Job Ready, Confirm Completion | Yes, No, All | Limits to Work Orders with or without the flag. |
| Removed Component Serial Number, Fitted Component Serial Number | Text | Shown only when component serial tracking is on. |
| Fitted Component Start Usage | Number | Shown only when component serial tracking is on. |
Group By
| Group By | Groups by |
|---|---|
| By Asset | The Work Order's Asset Number. |
| By Work Order Number | Each Work Order. |
| By Status, By Priority, By Work Type, By Task Type | The Work Order's values. |
| By Breakdown, By Job Ready | Yes or No. |
| By Site or Department | The Work Order's own department. |
| By Asset Department | The Asset's department. |
| By Cost Responsibility, By Event | The Work Order's values. |
| 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. |
Records with no value appear under Unknown. Series by offers the same list on stacked charts.
Chart notes
- Compare offers Expected versus actual labour hours, and Expected versus actual cost.
- Compare with on a Line or Area chart plots the total over time, so Group By is not available. Over Time charts allow Compare with and Group By together.
- Compare with mixes units only on Column, Line, Area and Over Time charts.
- Group Mode set to Detail draws one bar per Work Order, grouped by your Group By choice.
Business rules
- Dates differ from the Reports page. A widget applies its Period to one Date basis. The Reports page matches a Work Order if Started At, Scheduled At or Completed At falls in the range, so its totals can differ.
- The 30-day status counts ignore the Period. Complete and Cancelled always look back 30 days from now, and the widget's Period still applies as well.
- Empty values add nothing. A Work Order with no duration or cost adds 0 to a sum, and a period with no records shows 0.
- A Metric Tile is one total. It ignores Group By and Group Mode.
- Consolidated tables need a Group By. With no grouping, the table uses Detail.
- Consolidated Pie, Donut and Treemap charts are not limited to 5,000 records. They read group totals directly.
For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.