xpms.v_sheet_work_orders
View
The Playbook Work Orders sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | Yes | Row number in the source sheet. |
| record_id | text | Yes | RECORD ID (column A), field. |
| department | text | Yes | DEPARTMENT (column C), field. |
| category | text | Yes | CATEGORY (column D), field. |
| sub_category | text | Yes | SUB CATEGORY (column E), field. |
| work_order_type | text | Yes | WORK ORDER TYPE (column F), field. |
| priority | text | Yes | PRIORITY (column G), field. |
| location_id | text | Yes | LOCATION ID (column H), field. |
| item_id | text | Yes | ITEM ID (column J), field. |
| team_code | text | Yes | TEAM CODE (column K), field. |
| personnel_id | text | Yes | PERSONNEL ID (column L), field. |
| task_title | text | Yes | TASK TITLE (column N), field. |
| description | text | Yes | DESCRIPTION (column O), field. |
| scope_of_work | text | Yes | SCOPE OF WORK (column P), field. |
| scheduled_start_date | text | Yes | SCHEDULED START DATE (column Q), field. |
| scheduled_end_date | text | Yes | SCHEDULED END DATE (column R), field. |
| actual_start_date | text | Yes | ACTUAL START DATE (column S), field. |
| actual_end_date | text | Yes | ACTUAL END DATE (column T), field. |
| estimated_hours | text | Yes | ESTIMATED HOURS (column U), field. |
| actual_hours | text | Yes | ACTUAL HOURS (column V), field. |
| labor_rate | text | Yes | LABOR RATE (column W), field. |
| safety_hazard_level | text | Yes | SAFETY HAZARD LEVEL (column Y), field. |
| completion_percentage | text | Yes | COMPLETION PERCENTAGE (column Z), field. |
| status | text | Yes | STATUS (column AA), field. |
| flag | text | Yes | FLAG (column AB), field. |
| resolution_notes | text | Yes | RESOLUTION NOTES (column AC), field. |
| notes | text | Yes | NOTES (column AD), field. |
| created_by | text | Yes | CREATED BY (column AE), field. |
| created_at | text | Yes | CREATED AT (column AF), field. |
| updated_at | text | Yes | UPDATED AT (column AG), field. |
| project_id | text | Yes | PROJECT ID (column B), computed. |
| location_name | text | Yes | LOCATION NAME (column I), computed. |
| lead_assignee_name | text | Yes | LEAD ASSIGNEE NAME (column M), computed. |
| total_labor_cost | numeric | Yes | TOTAL LABOR COST (column X), computed. |