v_fire_dept_user: One-to-One (1:1)
One personnel links to one user account
Referenced through id/personnel_id
f_all_schedule: One-to-Many (1:N)
One personnel can have many schedules
Referenced through personnel_id
v_personnel_pay_rate: One-to-Many (1:N)
One personnel can have many pay rates
Referenced through personnel_id
| Column | Type | Description |
| personnel_iaff_local_number | varchar(20) | IAFF Local Number |
| personnel_ems_provider_level | integer | EMS Provider Level Code |
| personnel_crew_service_provider | boolean | Crew Service Provider |
| personnel_payroll_id | varchar(20) | Payroll Id |
| personnel_fema_id | varchar(20) | FEMA Id |
| personnel_firefighter_id | varchar(255) | Firefighter Id |
| personnel_address | varchar(255) | Address |
| personnel_unit | varchar(80) | Address Unit |
| personnel_city | varchar(255) | Address City |
| personnel_district | varchar(50) | District |
| personnel_district_id | integer | District Id |
| personnel_zip | varchar(15) | Zip Code |
| personnel_is_active | boolean | Is Active |
| personnel_secondary_start_date | date | Secondary Start Date |
| personnel_start_date_ranking | integer | Start Date Ranking |
| personnel_marital_status | varchar(25) | Marital Status |
| personnel_end_of_service_date | date | End of Service Date |
| personnel_driver_license_expiration_date | date | Driver License Expiration Date |
| personnel_lunch_period_code | varchar(6) | Lunch Period Code |
| personnel_days_scheduled_code | varchar(6) | Days Scheduled Code |
| personnel_hours_scheduled_code | varchar(32) | Hours Scheduled Code |
| personnel_rank_id | integer | Rank Id |
| personnel_division_id | integer | Division Id |
| personnel_shift_id | integer | Shift Id |
| personnel_driver_license | varchar(40) | Driver License |
| personnel_drivers_license_class | varchar(50) | Driver License Class |
| personnel_drivers_license_status | varchar(50) | Driver License Status |
| personnel_driver_license_state | varchar(2) | Driver License State |
| personnel_dod_id | varchar(15) | DOD Id |
| personnel_race | varchar(15) | Race |
| personnel_inspector_number | varchar(30) | Inspector Number |
| personnel_inspector_designator | varchar(30) | Inspector Designator |
| personnel_investigator_number | varchar(64) | Investigator Number |
| personnel_station_num | varchar(64) | Station Number |
| personnel_division | varchar(256) | Division |
| personnel_position | varchar(256) | Position |
| personnel_shift | varchar(256) | Shift |
| personnel_rank | varchar(100) | Rank |
| personnel_apparatus_id | integer | Apparatus Id |
| admin_account_first_name | varchar(64) | First Name |
| admin_account_middle_name | varchar(64) | Middle Name |
| admin_account_last_name | varchar(64) | Last Name |
| admin_account_name_suffix | varchar(8) | Name Suffix |
| personnel_last_first_name | text | Last Name, First Name |
| personnel_full_name | text | Personnel Full Name |
| admin_account_ff_title | varchar(128) | Firefighter Title |
| admin_account_phone | varchar(20) | Phone Number |
| user_type_code | varchar(20) | User Type Code |
| admin_account_email | varchar(225) | |
| personnel_state_code | varchar(225) | Personnel State Code |
| personnel_qualifier_ids | integer[] | Qualifier Ids |
| personnel_group_ids | integer[] | Group Ids |
| personnel_home_address | text | Home Address |
| personnel_mailing_address | text | Mailing Address |
| personnel_home_phone | varchar(25) | Home Phone Number |