| Database Fields |
|
| uuid |
The unit’s CAD identifier – this is unique for every unit in the client agency. Unit id’s across different agencies may be the same, but are unique with each agency. |
| agency_unit_record_id |
The agency identifier that links the unit record number. |
| agency_unit_id |
The agency identifier sent from CAD. |
| unit_type |
The general unit type classification. |
| unit_description |
A general unit description used for extended Info Panel information. |
| ems_category |
The unit’s EMS or life support capability at the time of the incident. |
| agency_dispatch_station_id |
The number that identifies the home station which the agency was dispatched from. |
| agency_home_station_id |
The number that identifies the agency home station. |
| mutual_aid_code |
The NFIRS 901 mutual aid classification code for the incident. |
| shift |
The on-duty shift identifier when the incident occurred. |
| staffing |
The number of personnel that responded to the incident with the unit used for ERF staffing calculations. |
| dispatched_on |
The datetime a unit was first dispatched to the incident. |
| enroute_on |
The earliest datetime a unit assigned to the incident left its station en route to the incident. |
| arrived_on |
The datetime a unit assigned to the incident first arrived at the incident. |
| at_patient_side_on |
The datetime a unit assigned to the incident first made contact with the patient. If the timestamp is not included in the update, this field is ignored. |
| enroute_facility_on |
The datetime a unit assigned to the incident first left the scene of the incident to transport a patient to a treatment facility. |
| arrived_facility_on |
The datetime a unit assigned to the incident arrived at the facility. |
| cleared_on |
The datetime the last unit assigned to the incident cleared or was cancelled from the incident. |
| enroute_response_priority_code |
The unit’s enroute priority code indicating the unit response’s initial criticality and emergent status when the unit first responded to the incident. |
| enroute_response_priority_description |
The unit’s enroute response priority description. |
| arrived_response_priority_code |
The unit’s response priority status code indicating the criticality and emergent status at the time the unit arrived at the incident. |
| arrived_response_priority_description |
The unit’s arrival response priority description. |
| db_created_on |
The datetime stamp that the incident record was last modified in the RMS database. |
| sys_last_modified_on |
The datetime the last unit assigned to the incident cleared or was cancelled from the incident. |
| agency_incident_id |
The number which represents which agency is tied to the incident. |
| nfirs_actions_taken_codes |
Actual situation that emergency personnel found on the scene when they arrived. |
|
|
| Map Tip Fields |
|
| tool__name |
The identifier which contins the unit id_id, cad_code and datetime . |
| tool_agency |
The agency name for the agency owning the referenced unit. |
| tool_incident |
The classification for what kind of incident occurred. |
| tool_incidentType |
The cad_code and cad_descrption . |
| tool_address |
A location where the incident occurred. |
| tool_unit |
The associated vehicle. |
| tool_shift |
The on-duty shift identifier when the incident occurred. If not provided in the incident data update, the field is ignored. |
| tool_turnoutDuration |
Caclulated from the enroute datetime minus the dispatch datetime |
| tool_travelDuration |
Caclulated from arrive datetime minus enroute datetime. |
| tool_dispatchStation |
The station from where the unit was sent from. |
| tool_homeStation |
The station from where the unit normally resides. |
| tool_jurisdiction1 |
The territory over which authrotiy is exercised. |
| tool_alarmOn |
The timeframe between the receipt of the 911 call to the dispatch of the first responding unit. |
| tool_dispatchedOn |
The datetime the unit is dispatched. |
| tool_enrouteOn |
The incident’s earliest en route (response) date and time. |
| tool_arrivedOn |
The incidents earliest arrived (response) date and time. |
| tool_atPatientSideOn |
The inial time a first responder makes contact with patient. |
| tool_enrouteFacilityOn |
An indictor if enrouteFacility is turned on. |
| tool_arrivedFacilityOn |
An indictor if arrivedFacility is turned on. |
| tool_clearedOn |
The datetime the incident completed. |
| tool_priorityEnroute |
A unit that Is more important than another heading to an incident. |
| tool_priorityArrived |
A unit that Is more important than another which arrived . |
| tool_alarmProcess |
Calculated from ‘dispatchPickupDatetime - dispatchDatetime’. |
| tool_responseDuration |
The amount of time it takes for unit to arrive at the scene. |
| tool_transportDuration |
The amount of time it takes for a unit to transport . |
| tool_totalDuration |
This value is calculated from adding the responseDuration and transportDuration. |
| tool_nfirsType |
The NFIRS 5.0 description for any specific intial action taken by the unit. |
| tool_unitNarrative |
A written account of the unit actions. |
| tool_fmz |
Fuel Modification Zone. |
| tool_reportStatus |
Is closed or open. |
| tool__turnoutTime |
The prepatory timeframe between when the unit is dispatched and when the unit goes enroute (physically departing the location) |
| tool__travelTime |
The timeframe between when units go en route until arrival on scene. |
| tool__standardCategory |
The type of incident that occurred (ex/ Fire, Hazmat..). |
| tool__nfirsCategory |
The nfirs categorization of the incident along with the associated nfirs code. |
| tool__emsCategory |
The nfirs specific number that correlates to the incident. |
| tool__latitude |
The Y axis coordinate . |
| tool__longitude |
The X axis coordinate. |
| tool__stationId |
The unique identifier that represents the station. |
| tool__agencyId |
The unique identifier that represents the agency. |
| tool__isEmergent |
An incident where lights and sirens occur. |
| tool__isCancel |
An indicator if the incident was ‘completed’ or ‘cancelled’. |
|
|
|
|
|
|
| Incident Performance |
|
| uuid |
The unit’s CAD identifier. |
| agency_uuid |
The CAD agency identifier for the agency owning the referenced unit. |
| agency_incident_id |
The CAD incident identifier. |
| agency_alternate_id |
The CAD alterate identifier. |
| agency_station_id |
The CAD station identifier. |
| cad_code_initial |
The incident’s initially coded CAD incident type code used to show an initial CAD code assigned to the incident (if it is different from the final CAD code). |
| cad_description_initial |
The incident’s initially coded CAD incident type description. |
| cad_code_final |
The incident’s final CAD incident type code, that is the offically recorded CAD incident code assigned to the incident. |
| cad_description_final |
The incident’s final coded CAD incident type description. |
| response_priority_code_initial |
The incident’s initial, or en route, CAD response priority code to indicate the response’s criticality and emergent status at the start of the incident. |
| response_priority_description_initial |
The incident’s CAD initial response priority description. |
| response_priority_code_final |
The incident’s final response priority code indicating the final, or arrival, response criticality and emergent status. |
| response_priority_description_final |
The incident’s final, or arrival, CAD response priority description. |
| nfirs_code_initial |
The incident’s initial NFIRS classification, if available. |
| nfirs_description_initial |
The initial NFIRS classification code’s description, if provided. |
| nfirs_code_final |
The incident’s final NFIRS classification. This is the reference value used to classify the incident for all reporting calculations. |
| nfirs_description_final |
The final NFIRS classification code’s description. |
| mutual_aid_code |
The NFIRS 901 standard’s mutual aid classification code for the unit’s response. |
| shift |
The on-duty shift identifier when the incident occurred. |
| fire_management_zone |
The Fire Management Zone in which the incident occurred. |
| response_zone |
The response zone identifier for SoC reporting. |
| response_class |
The response class identifier for SoC reporting. |
| risk_category |
The incident risk category identifier for SoC reporting. If not provided with the incident update, the field is ignored. |
| full_address |
Incident street address as formatted and provided by the client. |
| supplemental_address_info |
Additional supplemental address information like business name, office suite number, etc. as provided by the client. |
| city |
The city or sub-division in which the incident is located. |
| county |
The county or area in which the incident is located. |
| zip_code |
The zip code area in which the incident is located. |
| occurred_on |
The datetime the incident began. |
| call_received_at_psap_on |
The datetime the reporting party (RP) first connected to the PSAP to report the incident. |
| psap_to_dispatch_transfer_on |
The datetime that the PSAP transferred the RP’s call to the Dispatch Center. |
| dispatch_pickup_on |
The datetime that a dispatcher first became involved in the processing of the incident. |
| cad_entry_on |
The official time the incident was created in CAD. |
| dispatched_on |
The datetime a unit was first dispatched to the incident. |
| enroute_on |
The earliest datetime a unit assigned to the incident left its station en route to the incident. |
| arrived_on |
The CAD status update datetime the unit arrived at the incident. |
| at_patient_side_on |
The datetime a unit assigned to the incident first made contact with the patient. |
| enroute_facility_on |
The datetime a unit assigned to the incident first left the scene of the incident to transport a patient to a treatment facility. |
| arrived_facility_on |
The datetime the transporting unit arrived at its destination. |
| controlled_on |
The datetime an incident was first reported to be under control. |
| cleared_on |
The datetime the unit cleared from the incident this field is used to calculate the total unit incident duration value. |
| closed_on |
The time the incident was officially closed out in the RMS system. |
| native_x |
An incident location’s geo-coded state plane X Coordinate where WGS84 coordinates are not available. |
| native_y |
An incident location’s geo-coded state plane Y Coordinate where WGS84 coordinates are not available. |
| latitude |
The official geo-coded WGS84 latitude of the incident location. |
| longitude |
The official geo-coded WGS84 longitude of the incident location. |
| sys_last_modified_on |
The datetime where the system was last changed |
| narrative |
The CAD/RMS narrative entered by the unit’s crew responding to the incident. |
| standard_category |
The type of incident that occurred (ex/ Fire, Hazmat..) |
| erf_category |
Differentiates risk from low, medium and high. |
| jurisdictions |
The area where the incident occurred. |
| risk_level |
Is closed or open. |
| tool__name |
The identifier which contins the unit id_id, cad_code and datetime. |
| tool_agency |
The agency name for the agency owning the referenced unit. |
| tool_incidentType |
The cad_code and cad_descrption. |
| tool_assignedUnits |
The units at the corresponding incident. |
| tool_firstArrivalUnit |
The first unit that arrives on scene. |
| tool_alarmProcessing |
Calculated from ‘dispatchPickupDatetime - dispatchDatetime’. |
| tool_firstUnitTurnout |
Caclulated from the ‘enrouteDatetime’ minus the ‘dispatchDatetime’. |
| tool_firstUnitTravel |
Caclulated from the arrive datetime minus enroute datetime. |
| tool_firstUnitTotalResponse |
Calculated from the ‘travel’ plus ‘turnout’. |
| tool_responsePriority |
Either emergent or non-emergent. |
| tool_address |
A location where the incident occurred. |
| tool_stationName |
The name of the station. |
| tool_shift |
The group of personnel involved. |
| tool_jurisdiction1 |
The territory over which authrotiy is exercised. |
| tool_alarm |
The incidents Alarm start date and time. |
| tool_dispatch |
The datetime of when the unit was dispatched. |
| tool_enroute |
The datetime of when the unit is enroute. |
| tool_arrival |
The datetime of when the unit arrived. |
| tool_atPatientSide |
The datetime a unit assigned to the incident first made contact with the patient. |
| tool_enrouteFacility |
An indictor if enrouteFacility is turned on. |
| tool_arrivedFacility |
An indictor if arrivedFacility is turned on. |
| tool_cleared |
The datetime the incident completed. |
| tool_closed |
The datetime the incident is officailly closed. |
| tool_enroutePriority |
Represented with a code. |
| tool_arrivedPriority |
Represented with a code. |
| tool_narrative |
A written account of the unit actions. |
| tool_reportStatus |
Is closed or open. |
| tool__nfirsCategory |
The nfirs categorization of the incident along with the associated nfirs code. |
| tool__standardCategory |
The type of incident that occurred (ex/ Fire, Hazmat..) |
| tool__totalResponseSeconds |
Calculated from the ‘travel’ plus ‘turnout’. |
| tool__alarmProcessingSeconds |
The amount of time in seconds it took to process the alarm. |
| tool__firstUnitTurnoutSeconds |
Caclulated from the enroute datetime minus the dispatch datetime. |
| tool__firstUnitTravelSeconds |
The time in seconds the unit took to get from the station to the incident. |
| tool__firstUnitResponseSeconds |
The time in seconds the unit took to respond to the incident |
| tool__latitude |
The Y axis coordinate . |
| tool__longitude |
The X axis coordinate. |
| tool__stationId |
The unique identifier that represents the station. |
|
|
|
|
|
|
| Incident Metrics |
|
| uuid |
The unit’s CAD identifier – THIS VALUE MUST BE UNIQUE for every unit in the client agency. |
| agency_uuid |
The CAD agency identifier for the agency owning the referenced unit. |
| agency_incident_id |
The CAD incident identifier for the agency owning the referenced unit. |
| agency_alternate_id |
The CAD incident identifier that is used as an alternate . |
| agency_station_id |
The unique number that identifies the station. |
| cad_code_initial |
The incident’s initially coded CAD incident type code used to show an initial CAD code assigned to the incident (if it is different from the final CAD code). |
| cad_description_initial |
The incident’s initially coded CAD incident type description. |
| cad_code_final |
The incident’s final CAD incident type code that is the offically recorded CAD incident code assigned to the incident. |
| cad_description_final |
The incident’s final coded CAD incident type description. |
| response_priority_code_initial |
The incident’s initial, or en route, CAD response priority code to indicate the response’s criticality and emergent status at the start of the incident. |
| response_priority_description_initial |
The incident’s CAD initial response priority description. |
| response_priority_code_final |
The incident’s final response priority code indicating the final, or arrival, response criticality and emergent status. |
| response_priority_description_final |
The incident’s final, or arrival, CAD response priority description. |
| nfirs_code_initial |
The incident’s initial NFIRS classification. |
| nfirs_description_initial |
The initial NFIRS classification code’s description, if provided. |
| nfirs_code_final |
The incident’s final NFIRS classification. This is the reference value used to classify the incident for all reporting calculations. |
| nfirs_description_final |
The final NFIRS classification code’s description. |
| mutual_aid_code |
The NFIRS 901 mutual aid classification code for the incident. |
| shift |
The on-duty shift identifier when the incident occurred. |
| fire_management_zone |
The Fire Management Zone in which the incident occurred. |
| response_zone |
The response zone identifier for SoC reporting. |
| response_class |
The response class identifier for SoC reporting. |
| risk_category |
The incident risk category identifier for SoC reporting. |
| full_address |
Incident street address as formatted and provided by the client. |
| supplemental_address_info |
Additional supplemental address information like business name, office suite number, etc. as provided by the client. |
| city |
The city or sub-division in which the incident is located. |
| county |
The county or area in which the incident is located. |
| zip_code |
The zip code area in which the incident is located. |
| occurred_on |
The datetime which the incident occurred on. |
| call_received_at_psap_on |
The datetime the reporting party (RP) first connected to the PSAP to report the incident. |
| psap_to_dispatch_transfer_on |
The datetime that the PSAP transferred the RP’s call to the Dispatch Center. |
| dispatch_pickup_on |
The datetime that a dispatcher first became involved in the processing of the incident. |
| cad_entry_on |
The official time the incident was created in CAD. |
| dispatched_on |
The datetime a unit was first dispatched to the incident. |
| enroute_on |
The earliest datetime a unit assigned to the incident left its station en route to the incident. |
| arrived_on |
The datetime a unit assigned to the incident first arrived at the incident. |
| at_patient_side_on |
The datetime a unit assigned to the incident first made contact with the patient. |
| enroute_facility_on |
The datetime a unit assigned to the incident first left the scene of the incident to transport a patient to a treatment facility. |
| arrived_facility_on |
The datetime a unit assigned to the incident and transporting a patient first arrived at a treatment facility. |
| controlled_on |
The datetime an incident was first reported to be under control. |
| cleared_on |
The datetime the last unit assigned to the incident cleared or was cancelled from the incident. |
| closed_on |
The time the incident was officially closed out in the RMS system. |
| native_x |
An incident location’s geo-coded state plane X Coordinate where WGS84 coordinates are not available. |
| native_y |
An incident location’s geo-coded state plane Y Coordinate where WGS84 coordinates are not available. |
| latitude |
The official geo-coded WGS84 latitude of the incident location. |
| longitude |
The official geo-coded WGS84 longitude of the incident location. |
| sys_last_modified_on |
The datetime stamp that the incident record was last modified in the RMS database. |
| narrative |
A written account of the unit actions. |
| standard_category |
Determines how the incident is displayed on the map. |
| erf_category |
Differentiates risk from low, medium and high. |
| jurisdictions |
The area where the incident occurred. |
| risk_level |
|
|
|
| Map Tip |
|
| tool__name |
The identifier which contins the unit id_id, cad_code and datetime |
| tool_agency |
The agency name for the agency owning the referenced unit. |
| tool_alarmProcessing |
Calculated from ‘dispatchPickupDatetime - dispatchDatetime’ |
| tool_turnout |
Caclulated from the enroute datetime minus the dispatch datetime |
| tool_travel |
Caclulated from arrive datetime minus enroute datetime |
| tool_totalResponse |
Calculated from the ‘travel’ plus ‘turnout’ |
| tool_totalIncidentDuration |
The total amount of time the incident took from start to close |
| tool_incidentType |
The classification for what kind of incident occurred |
| tool_responsePriority |
Either emergent or non-emergent. |
| tool_assignedUnits |
The units at the corresponding incident |
| tool_firstUnitName |
The name of the first unit to respond |
| tool_nfirsType |
The NFIRS 5.0 description for any specific intial action taken by the unit |
| tool_responseClass |
The type of responder (ex/ EMS , Rescue…) |
| tool_riskCategory |
The level of risk (ex/ Low, Moderate..) |
| tool_responseZone |
The type of incident that occurred (ex/ Fire, Hazmat..) |
| tool_address |
The address where the incident occurred |
| tool_city |
The city where the incident occurred |
| tool_jurisdiction1 |
The jurisdiction1 where the incident occurred |
| tool_stationName |
The name of the station |
| tool_shift |
The shift where the incident occurred |
| tool_dispatchPickupOn |
The datetime the dispatcher picked up the initial call |
| tool_dispatchedOn |
The datetime the unit is dispatched |
| tool_enrouteOn |
The datetime the unit left the station |
| tool_arrivedOn |
The datetime the unit arrived at the scene |
| tool_atPatientSideOn |
The datetime a unit assigned to the incident first made contact with the patient. |
| tool_enrouteFacilityOn |
The datetime the enroute |
| tool_arrivedFacilityOn |
The datetime the arriveder picked ity the initial call |
| tool_clearedOn |
The datetime the incident cleared |
| tool_closedOn |
The date time the incident closed |
| tool_canceled |
The canceled where the incident occurred |
| tool_enroutePriority |
Represented with a code |
| tool_arrivedPriority |
Represented with a code |
| tool_reportStatus |
|
| tool_incidentNarrative |
A written account of the incident actions |
| tool_firstUnitNarrative |
A written account of the first unit actions |
| tool__nfirsCategory |
|
| tool__standardCategory |
The type of geographic area where the standard occurs (Ex/Urban ..) |
| tool__dayOfWeekLocal |
The day of the week |
| tool__hourOfDayLocal |
The Hour of the day |
| tool__totalResponseSeconds |
Calculated from the ‘travel’ plus ‘turnout’ |
| tool__alarmProcessingSeconds |
Calculated from ‘dispatchPickupDatetime - dispatchDatetime’ |
| tool__firstUnitTurnoutSeconds |
The first unit the turnout |
| tool__firstUnitTravelSeconds |
The first unit the travel |
| tool__firstUnitResponseSeconds |
The first unit the response |
| tool__latitude |
The Y axis coordinate |
| tool__longitude |
The X axis coordinate |
| tool__stationId |
The unique identifier that represents the station |
| tool__juris1 |
The juris1 where the incident occurred |
| tool__juris2 |
The juris2 where the incident occurred |
