f_schedule
Table Name: f_schedule
Last Updated: June 12, 2026 at 06:51 PM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| client_code | character | Yes | - |
| user_id | integer | Yes | - |
| public_name | character | Yes | - |
| first_name | character | Yes | - |
| middle_name | character | Yes | - |
| last_name | character | Yes | - |
| phone | character | Yes | - |
| personnel_id | integer | Yes | - |
| personnel_start_date | date | Yes | - |
| personnel_secondary_start_date | date | Yes | - |
| personnel_start_date_ranking | integer | Yes | - |
| personnel_agency_id | character | Yes | - |
| personnel_badge_number | character | Yes | - |
| personnel_payroll_id | character | Yes | - |
| personnel_fema_id | character | Yes | - |
| personnel_firefighter_id | character | Yes | - |
| personnel_career_volunteer | character | Yes | - |
| personnel_cad_id | character | Yes | - |
| personnel_days_scheduled_code | character | Yes | - |
| personnel_hours_scheduled_code | character | Yes | - |
| personnel_status_code | character | Yes | - |
| personnel_is_active | boolean | Yes | - |
| personnel_last_first_name | character | Yes | - |
| personnel_last_first_middle_name | character | Yes | - |
| personnel_last_first_mi_name | character | Yes | - |
| character | Yes | - | |
| personnel_rank | character | Yes | - |
| personnel_shift | character | Yes | - |
| personnel_apparatus | character | Yes | - |
| personnel_station_num | character | Yes | - |
| personnel_division | character | Yes | - |
| work_date | date | Yes | - |
| start_at_local | timestamp | Yes | - |
| end_at_local | timestamp | Yes | - |
| start_date | date | Yes | - |
| end_date | date | Yes | - |
| start_time | time | Yes | - |
| end_time | time | Yes | - |
| duration_hours | numeric | Yes | - |
| created_by | integer | Yes | - |
| created_at | timestamp | Yes | - |
| assignment_name | character | Yes | - |
| work_type_name | character | Yes | - |
| work_type_shortcode | character | Yes | - |
| work_subtype_name | character | Yes | - |
| work_subtype_shortcode | character | Yes | - |
| project_code_name | character | Yes | - |
| project_code_shortcode | character | Yes | - |
| qualifier_name | character | Yes | - |
| qualifier_shortcode | character | Yes | - |
| rotation_name | character | Yes | - |
| is_trade | boolean | Yes | - |
| pay_rate_start_date | date | Yes | - |
| pay_rate_end_date | date | Yes | - |
| pay_rate | numeric | Yes | - |
| work_type_multiplier_factor | numeric | Yes | - |
| notes | character | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.