f_all_schedule
Table Name: f_all_schedule
Last Updated: June 01, 2026 at 01:20 AM
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 | - |
| assignment_with_original_for_time_off | 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 | - |
| activity_type | character | Yes | - |
| is_off_roster | boolean | Yes | - |
| is_holdover | boolean | Yes | - |
| is_kelly_day | boolean | Yes | - |
| is_approved | boolean | Yes | - |
| status_code | character | Yes | - |
| approving_user_id | integer | Yes | - |
| responded_at | timestamp | Yes | - |
| recipient_type_code | character | Yes | - |
| is_approval_required | boolean | Yes | - |
| accepting_user_id | integer | Yes | - |
| accepting_user_public_name | character | Yes | - |
| accepting_user_first_name | character | Yes | - |
| accepting_user_middle_name | character | Yes | - |
| accepting_user_last_name | character | Yes | - |
| work_type_multiplier_factor | numeric | Yes | - |
| notes | character | Yes | - |
| off_roster_pay_amount | numeric | Yes | - |
| total_pay | numeric | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.