v_work_shift_request
Table Name: v_work_shift_request
Last Updated: June 01, 2026 at 01:23 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| client_code | character | Yes | - |
| work_shift_request_status_code | character | Yes | - |
| requesting_user_id | integer | Yes | - |
| requesting_user_name | character | Yes | - |
| assignment_id | integer | Yes | - |
| assignment_name | character | Yes | - |
| work_type_id | integer | Yes | - |
| work_type_shortcode | character | Yes | - |
| work_date | date | Yes | - |
| start_at_local | timestamp | Yes | - |
| end_at_local | timestamp | Yes | - |
| assignment_qualifier_id | integer | Yes | - |
| assignment_qualifier_name | character | Yes | - |
| assignment_riding_position_id | integer | Yes | - |
| assignment_riding_position_name | character | Yes | - |
| fire_station_id | integer | Yes | - |
| fire_station_name | character | Yes | - |
| is_vacancy | boolean | Yes | - |
| is_off_roster | boolean | Yes | - |
| notes | text | Yes | - |
| responded_at | timestamp | Yes | - |
| responded_by_id | integer | Yes | - |
| responded_by_name | character | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.