Work Order Details
The Work Order Details dataset shows the full record of selected Work Orders, with their costs, parts, labour, services, resources, forms and documents.
At a glance
| Item | Value |
|---|---|
| Picker heading | Data Tables |
| One row is | One detail line of a Work Order, such as a part or a labour entry |
| Presentations | Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Grouped Line |
| Default presentation | Table |
| Default period | Last 30 Days. Time charts start on Last Month. |
| Date basis | Started At, Scheduled At or Completed At. A Work Order matches when any falls in the Period. |
| Default columns | The main Header, Costs, Part, Labour and Service columns |
| Group Modes | Detail tables. Charts are Consolidated. |
| Drill-through | Not available |
Measures
| Measure | Unit | Aggregation | Definition |
|---|---|---|---|
| Work Order count | Work Orders | Count | Number of Work Orders, not detail lines. |
Columns
Column labels start with their section, such as Header or Part.
| Section | Columns | Description |
|---|---|---|
| Header | Work Order Number, Title, Description, Status, Custom Status, Priority, Work Type | The Work Order. |
| Header | Task Type, Task Code, Task | The linked Task. |
| Header | Asset Number, Asset Description, Site or Department, Area, Location Address | Where the work is. |
| Header | Team, Crew, Contractor, Reporting To | Who does the work. |
| Header | Scheduled At, Due Date, Started At, Completed At, Completed By | When the work happens. |
| Header | Source, Failure, Cause, Breakdown, Compliance Task | Why the work is needed. |
| Header | Cost Responsibility, Purchase Order Numbers, Notes, Created By, Created At | Other Work Order details. |
| Costs | Cost Type, Expected Cost, Actual Cost, Variance, Expected Labour Hours, Actual Labour Hours | One line per cost type. |
| Part | Part Number, OEM Number, Description, Source, Status, Supplier | The part. |
| Part | Quantity, Unit Cost, Total Cost, Optional, Received, Used, PO Number | The part's quantities and cost. |
| Labour | Type, Trade, Technician, Date, Quantity, Hours, Rate, Cost, Notes | One line per labour entry. |
| Service | Description, Supplier, Source, Status, Quantity, Unit Cost, Total Cost, PO Number, Notes | One line per service. |
| Resource | Name, Quantity, Notes | One line per resource. |
| Form | Name, Status, Assigned To, Scheduled At, Completed By, Duration | One line per Form. |
| Document | File Name | One line per document. |
| Asset | Class, Group, Asset Type, Manufacturer, Asset Department | The Asset's classification and department. |
| Asset | Asset Status, Criticality, Planning Type, Hire Status, Project, Customer | The Asset's details. |
Filters
| Filter | Choice | Behaviour |
|---|---|---|
| Work Order | Multiple | Specific Work Orders. |
| Status, Priority | Multiple | The Work Order's values. |
| Team | Multiple | The assigned team. |
| Task Type, Task Code | Multiple | The linked Task's type and code. |
| Cost Responsibility | Multiple | Who is responsible for the cost. |
| 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 | Multiple | The Work Order's Asset. |
| 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. |
| Breakdown, Compliance Task, Linked to Task, Overdue | All, Yes, No | Limits to Work Orders with or without the flag. |
Group By
| Group By | Groups by |
|---|---|
| Work Order | Each Work Order. |
| 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
- Charts count Work Orders. They do not read the detail lines, so they stay fast and each Work Order counts once.
- Series by, Compare and Compare with are not available.
Business rules
- Use it for selected Work Orders. This dataset is built for reviewing a small set in full. For totals across many Work Orders, use the Work Orders dataset.
- At least one filter is needed. With No Date Range and no filters, the report asks you to choose one.
- A row holds one section's values. A Part line has no Labour values, so columns from other sections are blank on that row.
- Do not add up Header values. Header values repeat across a Work Order's detail lines.
For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.