v_nfirs_firefighter_casualty
Table Name: v_nfirs_firefighter_casualty
Last Updated: June 01, 2026 at 01:22 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| client_code | character | Yes | - |
| incident_report_id | integer | Yes | - |
| casualty_id | integer | Yes | - |
| first_name | character | Yes | - |
| last_name | character | Yes | - |
| injury_date_time | timestamp | Yes | - |
| activity_at_time_of_injury | character | Yes | - |
| where_injury_occurred | character | Yes | - |
| firefighter_casualty_severity | character | Yes | - |
| note | text | Yes | - |
| taken_to | character | Yes | - |
| physical_condition_just_prior_to_injury | character | Yes | - |
| number_of_responses_during_past_24_hours | integer | Yes | - |
| object_involved_in_injury | character | Yes | - |
| story_where_injury_occurred | integer | Yes | - |
| specific_location_where_injury_occurred | character | Yes | - |
| vehicle_type | character | Yes | - |
| protective_equipment_failed_or_contributed_to_injury | boolean | Yes | - |
| factor_contributing_to_injury | character | Yes | - |
| firefighter_casualty_cause_of_injury | character | Yes | - |
| firefighter_casualty_primary_apparent_symptom | character | Yes | - |
| primary_area_of_body_injured | character | Yes | - |
| body_site_injured | character | Yes | - |
| created_by | integer | Yes | - |
| created_at | timestamp | Yes | - |
| updated_at | timestamp | Yes | - |
| rescue_type | text | Yes | - |
| rescue_primary_mode | text | Yes | - |
| rescue_actions | text[] | Yes | - |
| rescue_impediment_type | text[] | Yes | - |
| rescue_mayday_relative_time | text | Yes | - |
| rescue_rit_activated | boolean | Yes | - |
| rescue_room_type | text | Yes | - |
| rescue_elevation_type | text | Yes | - |
| rescue_gas_isolation | boolean | Yes | - |
| rescue_removal_path_type | text | Yes | - |
| rescue_fire_relative_date | date | Yes | - |
| rescue_fire_relative_time | time | Yes | - |
| rescue_mayday | boolean | Yes | - |
| job_classification_type | text | Yes | - |
| casualty_type | text | Yes | - |
| casualty_cause | text | Yes | - |
| unit_type | text | Yes | - |
| duty_type | text | Yes | - |
| incident_stage | text | Yes | - |
| casualty_action | text | Yes | - |
| casualty_rank | text | Yes | - |
| casualty_service | double | Yes | - |
| ppe | text[] | Yes | - |
| has_company_continuity | boolean | Yes | - |
| was_incident_command_established | boolean | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.