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