xpms.v_sheet_run_of_show
Vista
The Playbook Run of Show 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. |
| organization | text | Sí | ORGANIZATION (column B), field. |
| project_id | text | Sí | PROJECT ID (column C), field. |
| schedule_record_id | text | Sí | SCHEDULE RECORD ID (column D), field. |
| cue_id | text | Sí | CUE ID (column E), field. |
| act | text | Sí | ACT (column F), field. |
| scene | text | Sí | SCENE (column G), field. |
| description | text | Sí | DESCRIPTION (column H), field. |
| start_time | text | Sí | START TIME (column I), field. |
| end_time | text | Sí | END TIME (column J), field. |
| duration_min | text | Sí | DURATION (MIN) (column K), field. |
| location_id | text | Sí | LOCATION ID (column L), field. |
| personnel_id | text | Sí | PERSONNEL ID (column M), field. |
| audio_cue | text | Sí | AUDIO CUE (column N), field. |
| lighting_cue | text | Sí | LIGHTING CUE (column O), field. |
| video_cue | text | Sí | VIDEO CUE (column P), field. |
| sfx_cue | text | Sí | SFX CUE (column Q), field. |
| stage_cue | text | Sí | STAGE CUE (column R), field. |
| status | text | Sí | STATUS (column S), field. |
| flag | text | Sí | FLAG (column T), field. |
| notes | text | Sí | NOTES (column U), field. |
| created_by | text | Sí | CREATED BY (column V), field. |
| created_at | text | Sí | CREATED AT (column W), field. |
| updated_at | text | Sí | UPDATED AT (column X), field. |