xpms.v_sheet_production_schedule
View
The Playbook Production Schedule 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. |
| activity_id | text | Yes | ACTIVITY ID (column A), field. |
| project_id | text | Yes | PROJECT ID (column B), field. |
| parent_activity_id | text | Yes | PARENT ACTIVITY ID (column C), field. |
| wbs_code | text | Yes | WBS CODE (column D), field. |
| phase_code | text | Yes | PHASE CODE (column E), field. |
| phase | text | Yes | PHASE (column F), field. |
| act | text | Yes | ACT (column G), field. |
| gate | text | Yes | GATE (column H), field. |
| activity_name | text | Yes | ACTIVITY NAME (column I), field. |
| activity_type | text | Yes | ACTIVITY TYPE (column J), field. |
| deliverable | text | Yes | DELIVERABLE (column K), field. |
| sop_id | text | Yes | SOP ID (column L), field. |
| owner_role | text | Yes | OWNER ROLE (column M), field. |
| personnel_id | text | Yes | PERSONNEL ID (column N), field. |
| start_date | text | Yes | START DATE (column O), field. |
| end_date | text | Yes | END DATE (column P), field. |
| duration_days | text | Yes | DURATION (DAYS) (column Q), field. |
| critical_path | text | Yes | CRITICAL PATH (column R), field. |
| status | text | Yes | STATUS (column V), field. |
| flag | text | Yes | FLAG (column W), field. |
| notes | text | Yes | NOTES (column X), field. |
| total_tasks | numeric | Yes | TOTAL TASKS (column S), computed. |
| completed_tasks | numeric | Yes | COMPLETED TASKS (column T), computed. |
| progress_pct | numeric | Yes | PROGRESS (%) (column U), computed. |