v_incident_report_apparatus
Table Name: v_incident_report_apparatus
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 | - |
| apparatus_id | integer | Yes | - |
| apparatus_call_sign | character | Yes | - |
| name | character | Yes | - |
| aid | boolean | Yes | - |
| type_of_apparatus_or_resource | character | Yes | - |
| use | character | Yes | - |
| number_of_people | integer | Yes | - |
| location_flag | boolean | Yes | - |
| location_by | integer | Yes | - |
| address | character | Yes | - |
| unit | character | Yes | - |
| city | character | Yes | - |
| b_state | character | Yes | - |
| zip | character | Yes | - |
| latitude | numeric(9 | Yes | - |
| longitude | numeric(10 | Yes | - |
| response_mode_code | integer | Yes | - |
| apparatus_actions_taken | text[] | Yes | - |
| dispatch_time | time | Yes | - |
| arrive_time | time | Yes | - |
| dispatch_acknowledged_time | time | Yes | - |
| enroute_time | time | Yes | - |
| clear_time | time | Yes | - |
| back_in_service_time | time | Yes | - |
| patient_arrived_time | time | Yes | - |
| patient_transferred_time | time | Yes | - |
| dispatch_at | timestamp | Yes | - |
| arrive_at | timestamp | Yes | - |
| dispatch_acknowledged_at | timestamp | Yes | - |
| enroute_at | timestamp | Yes | - |
| patient_arrived_at | timestamp | Yes | - |
| patient_transferred_at | timestamp | Yes | - |
| patient_left_scene_at | timestamp | Yes | - |
| patient_left_scene_time | time | Yes | - |
| patient_arrived_destination_at | timestamp | Yes | - |
| patient_arrived_destination_time | time | Yes | - |
| clear_at | timestamp | Yes | - |
| back_in_service_at | timestamp | Yes | - |
| dispatch_to_enroute | interval | Yes | - |
| dispatch_to_enroute_in_seconds | bigint | Yes | - |
| enroute_to_scene | interval | Yes | - |
| enroute_to_scene_in_seconds | bigint | Yes | - |
| scene_to_clear | interval | Yes | - |
| scene_to_clear_in_seconds | bigint | Yes | - |
| dispatch_to_clear | interval | Yes | - |
| dispatch_to_clear_in_seconds | bigint | Yes | - |
| dispatch_to_scene | interval | Yes | - |
| dispatch_to_scene_in_seconds | bigint | Yes | - |
| created_by | integer | Yes | - |
| created_at | timestamp | Yes | - |
| department_name | character | Yes | - |
| canceled_date | date | Yes | - |
| is_canceled | boolean | Yes | - |
| canceled_stage_code | character | Yes | - |
| xref_id | character | Yes | - |
| is_first_arriving_unit | boolean | Yes | - |
| is_first_arriving_suppression_unit | boolean | Yes | - |
| canceled_at | timestamp | Yes | - |
| canceled_time | time | Yes | - |
| alarm_at | timestamp | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.