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