xpms.v_sheet_crew_shifts
View
The Playbook Crew Shifts 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. |
| shift_id | text | Yes | SHIFT ID (column A), field. |
| project_id | text | Yes | PROJECT ID (column B), field. |
| shift_date | text | Yes | SHIFT DATE (column C), field. |
| department | text | Yes | DEPARTMENT (column D), field. |
| location_name | text | Yes | LOCATION NAME (column E), field. |
| personnel_id | text | Yes | PERSONNEL ID (column F), field. |
| role_code | text | Yes | ROLE CODE (column H), field. |
| rate_card_id | text | Yes | RATE CARD ID (column I), field. |
| scheduled_call_time | text | Yes | SCHEDULED CALL TIME (column K), field. |
| scheduled_wrap_time | text | Yes | SCHEDULED WRAP TIME (column L), field. |
| scheduled_meal_break_hrs | text | Yes | SCHEDULED MEAL BREAK (HRS) (column M), field. |
| status | text | Yes | STATUS (column S), field. |
| flag | text | Yes | FLAG (column T), field. |
| notes | text | Yes | NOTES (column U), field. |
| created_by | text | Yes | CREATED BY (column V), field. |
| created_at | text | Yes | CREATED AT (column W), field. |
| updated_at | text | Yes | UPDATED AT (column X), field. |
| crew_name | text | Yes | CREW NAME (column G), computed. |
| job_title | xpms.canon_text | Yes | JOB TITLE (column J), computed. |
| net_scheduled_hours | numeric | Yes | NET SCHEDULED HOURS (column N), computed. |
| pay_basis | text | Yes | PAY BASIS (column O), computed. |
| standard_rate | numeric | Yes | STANDARD RATE (column P), computed. |
| hourly_base_rate | numeric | Yes | HOURLY BASE RATE (column Q), computed. |
| scheduled_pay | numeric | Yes | SCHEDULED PAY (column R), computed. |