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 |