api_external.shifts
View
Shifts assigned to the caller's engagements, once published (Section 4.4.4 Crew and Staff: shifts and call times), while the operational area is open. Drafts never appear.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Shift. |
| engagement_id | uuid | Yes | Engagement the shift is worked under. |
| project_id | uuid | Yes | Project. |
| project_name | text | Yes | Project name. |
| scope_node_id | uuid | Yes | Scope node, such as the show. |
| scope_node_name | text | Yes | Scope node name. |
| role_code | text | Yes | Canon role. |
| job_title | xpms.canon_text | Yes | Job title from the Roles Library. |
| starts_at | timestamp with time zone | Yes | Call time. |
| ends_at | timestamp with time zone | Yes | End. |
| time_zone | text | Yes | IANA time zone of the shift. |
| shift_state | app.shift_state | Yes | Published, Accepted or Canceled. |