xpms.v_sheet_projects
View
The Playbook Projects 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. |
| project_id | text | Yes | PROJECT ID (column A), field. |
| project_name | text | Yes | PROJECT NAME (column B), field. |
| client_name | text | Yes | CLIENT NAME (column C), field. |
| organization | text | Yes | ORGANIZATION (column D), field. |
| venue | text | Yes | VENUE (column E), field. |
| location | text | Yes | LOCATION (column F), field. |
| start_date | text | Yes | START DATE (column G), field. |
| end_date | text | Yes | END DATE (column H), field. |
| anchor_date | text | Yes | ANCHOR DATE (column I), field. |
| tier | text | Yes | TIER (column J), field. |
| budget_envelope | text | Yes | BUDGET ENVELOPE (column K), field. |
| operational_state | text | Yes | OPERATIONAL STATE (column P), field. |
| governing_gate | text | Yes | GOVERNING GATE (column Q), field. |
| executive_producer | text | Yes | EXECUTIVE PRODUCER (column R), field. |
| notes | text | Yes | NOTES (column S), field. |
| committed_amount | numeric | Yes | COMMITTED AMOUNT (column L), computed. |
| actual_spend | numeric | Yes | ACTUAL SPEND (column M), computed. |
| approved_change_orders | numeric | Yes | APPROVED CHANGE ORDERS (column N), computed. |
| production_tasks | bigint | Yes | PRODUCTION TASKS (column O), computed. |