xpms.v_sheet_production_tasks
Vista
The Playbook Production Tasks 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. |
| task_id | text | Sí | TASK ID (column A), field. |
| project_id | text | Sí | PROJECT ID (column B), field. |
| activity_id | text | Sí | ACTIVITY ID (column C), field. |
| wbs_code | text | Sí | WBS CODE (column D), field. |
| task_name | text | Sí | TASK NAME (column E), field. |
| description | text | Sí | DESCRIPTION (column F), field. |
| record_kind | text | Sí | RECORD KIND (column G), field. |
| record_subtype | text | Sí | RECORD SUBTYPE (column H), field. |
| team_code | text | Sí | TEAM CODE (column I), field. |
| location_id | text | Sí | LOCATION ID (column J), field. |
| personnel_id | text | Sí | PERSONNEL ID (column K), field. |
| assignee_name | text | Sí | ASSIGNEE NAME (column L), field. |
| start_date | text | Sí | START DATE (column M), field. |
| end_date | text | Sí | END DATE (column N), field. |
| duration_days | text | Sí | DURATION (DAYS) (column O), field. |
| predecessors | text | Sí | PREDECESSORS (column P), field. |
| priority | text | Sí | PRIORITY (column Q), field. |
| deliverable | text | Sí | DELIVERABLE (column R), field. |
| linked_work_order_id | text | Sí | LINKED WORK ORDER ID (column S), field. |
| sop_id | text | Sí | SOP ID (column T), field. |
| progress_pct | text | Sí | PROGRESS (%) (column U), field. |
| status | text | Sí | STATUS (column V), field. |
| flag | text | Sí | FLAG (column W), field. |
| notes | text | Sí | NOTES (column X), field. |