FH Medic and NEMSIS mapping table

NEMSIS element	Field in FH Medic	Mapping and Notes
E01_02		Software creator. Value is hard-coded in FH Medic.
E01_03		Software name. Value is hard-coded in FH Medic.
E01_04		Software version. Value is hard-coded in FH Medic.
E02_01		Database mapping to your EMS agency ID.
E01_01		Ticket ID plus ticket incident number
E02_04		Value is hard-coded to `30 - Scene Response`.
E02_12		Unit description
E02_05		Value is hard-coded to `75 - Transport`.
E04_03		Database mapping to certification description
E08_11	Response → Incident Information → Location → Address
E08_12	Response → Incident Information → Location → City
E08_15	Response → Incident Information → Location → Zip
E08_13		Uses the value in Response → Incident Information → Location → City and Response → Incident Information → Location → State to look up FIPS code
E02_06		Value is hard-coded to `-10 - Not known`.
E02_07		Logic to compare Response → Call Times → Dispatched and Response → Call Times → At Scene. If greater than 20 minutes, the value is set to `155 - Other`. If less than 20 minutes, the value is set to `150 - None`. If the outcome is canceled, the value is set to `-25`.
E02_08		Logic to compare Response → Call Times → At Scene and Response → Call Times → Depart Scene. If greater than 30 minutes, the value is set to `230 - Other`. If less than 30 minutes, the value is set to `225 - None`. If the outcome is canceled, the value is set to `-25`.
E02_09		Logic to compare Response → Call Times → Depart Scene and Response → Call Times → Arrive Destination. If greater than 30 minutes, the value is set to `295 - Other`. If less than 30 minutes, the value is set to `290 - None`. If the outcome is canceled, the value is set to `-25`.
E02_10		Value is hard-coded to `360 - None`. If the outcome is canceled, the value is set to `-25`.
E02_20		Value is hard-coded to `390 - Lights and Sirens`.
E03_01	Response → Incident Information → Incident → Dispatch Complaint
E03_02		Value is hard-coded to `-10 - Not Known`.
E05_02	Response → Call Times → Dispatched
E05_04	Response → Call Times → Dispatched
E05_05	Response → Call Times → En Route
E05_06	Response → Call Times → At Scene
E05_07	Response → Call Times → At Patient
E05_09	Response → Call Times → Depart Scene
E05_10	Response → Call Times → Arrive Destination
E05_11	Response → Call Times → Unit Clear
E05_13	Response → Call Times → At Home
E06_08	Patient → Demographics → Home Address → Zip
E06_11	Patient → Demographics → Personal Info → Sex
E06_12	Patient → Demographics → Personal Info → Race
E06_13		Value is hard-coded to `-10 - Not Known`.
E06_16	Patient → Demographics → Personal Info → DOB
E07_01	Patient → Insurance → Medicare Patient → Insurance → Medicaid Patient → Insurance → Private Insurance Patient → Insurance → Other Payer or Self Pay
E07_34	Response → Incident Information → Incident → Transport Type
E07_35		Value is hard-coded to `-25 - Not Applicable`.
E08_05		Value is hard-coded to `-25 - Not Applicable`.
E08_06		Value is hard-coded to `0 - No`.
E08_07	Response → Incident Information → Location → Location Type
E09_01		Value is hard-coded to `-10 - Unknown if Prior Aid was provided`.
E09_02		Value is hard-coded to an empty string.
E09_03		Value is hard-coded to an empty string.
E09_04		Use logic with a selection from Events → Treatments and Situation → Chief Complaint → Primary Impression to determine the value.
E09_11		Use logic with Situation → Chief Complaint → Primary Impression to determine the value.
E09_12		Use logic with Situation → Chief Complaint → Primary Impression to determine the value.
E09_13		Use logic with Situation → Chief Complaint → Primary Impression to determine the value.
E09_14		Value is hard-coded to `-25 - Not Applicable`.
E09_15	Situation → Chief Complaint → Primary Impression
E09_16		Value is hard-coded to `1816 - None`. If the outcome is canceled, the value is set to `-25 - Not Available`.
E10_01		Value is hard-coded to `-10 - Not Known`. If the outcome is canceled, the value is set to `-25 - Not Available`.
E10_03		Value is hard-coded to `-25 - No Injury Present`, unless E09_04 = 1, then the outcome is set to `2045 - Other`.
E10_08		Value is hard-coded to `-10 - Not Known`. If the outcome is canceled, the value is set to `-25 - Not Available`.
E10_09		Value is hard-coded to `-10 - Not Known`. If the outcome is canceled, the value is set to `-25 - Not Available`.
E11_01		Value is hard-coded to `-25 - Not Applicable`, unless E19_03 = `CPR` or `Defib`, then the value is set to `2240 - Yes, Prior to EMS Arrival`.
E11_02		Value is hard-coded to `-25 - Not Applicable`, unless E19_03 = `CPR` or `Defib`, then the value is set to `2275 - Other`.
E11_03		Value is hard-coded to `-25 - Not Applicable`, unless E19_03 = `CPR`, then the value is set to `2280 - Attempted Defibrillation`.
E12_01		Value is hard-coded to `2615 - None`. If the outcome is canceled, the value is set to `-25 - Not Available`.
E12_19		Value is hard-coded to `-10 - Not Known`. If the outcome is canceled, the value is set to `-25 - Not Available`.
E14_04	Events → Vitals → Vitals → BP Sys
E14_05	Events → Vitals → BP Dia
E14_07	Events → Vitals →Vitals → HR (BPM)
E14_11	Events → Vitals → Vitals → RR (BPM)
E14_15	Events → Vitals → Glascow Coma Score → Eye Response
E14_16	Events → Vitals → Glascow Coma Score → Verbal Response
E14_17	Events → Vitals → Glascow Coma Score → Motor Response
E18_03	Events → Treatments → Medication Administration Events → Treatments → Cardioversion / Defribrillation
E18_08		Value is hard-coded to `4390 - None`.
E19_03	Selection from Events → Treatments
E19_01	Selection from Events → Treatments
E19_05		Value is hard-coded to `1`. Note: Some treatments have an input sub to show attempts, and we can get the value from there, but if there is no input sub, then it defaults to `1`.
E19_06		If the procedure is present, the value is hard-coded to `1`. Note: Some treatments have an input sub to show success, and we can get the value from there, but if there is no input sub, then it defaults to `1`.
E19_07		Value is hard-coded to `4500 - None`.
E12_07		Value is hard-coded to an empty string.
E20_02	Summary → Disposition → Details → Destination
E20_10	Summary → Disposition → Details → Outcome
E20_14		Value is hard-coded to `-25 - Not Applicable`.
E20_16	Summary → Disposition → Details → Location Choice
E23_09		Value is hard-coded to `-10 - Not Known`.
E20_17		Value is hard-coded to the type of hospital indicated by the department in the FH Medic data import template → Locations worksheet → Location Type column.
E22_01		Value is hard-coded to `-25 - Unknown`, unless outcome is transported, then `5350 - Not Applicable` (Transported to L&D or OR).
E22_02		Value is hard-coded to `-25 - Not Applicable`.

E01_02

Software creator. Value is hard-coded in FH Medic.

E01_03

Software name. Value is hard-coded in FH Medic.

E01_04

Software version. Value is hard-coded in FH Medic.

E02_01

Database mapping to your EMS agency ID.

E01_01

Ticket ID plus ticket incident number

E02_04

Value is hard-coded to 30 - Scene Response.

E02_12

Unit description

E02_05

Value is hard-coded to 75 - Transport.

E04_03

Database mapping to certification description

E08_11

Response → Incident Information → Location → Address

E08_12

Response → Incident Information → Location → City

E08_15

Response → Incident Information → Location → Zip

E08_13

Uses the value in Response → Incident Information → Location → City and Response → Incident Information → Location → State to look up FIPS code

E02_06

Value is hard-coded to -10 - Not known.

E02_07

Logic to compare Response → Call Times → Dispatched and Response → Call Times → At Scene. If greater than 20 minutes, the value is set to 155 - Other. If less than 20 minutes, the value is set to 150 - None. If the outcome is canceled, the value is set to -25.

E02_08

Logic to compare Response → Call Times → At Scene and Response → Call Times → Depart Scene. If greater than 30 minutes, the value is set to 230 - Other. If less than 30 minutes, the value is set to 225 - None. If the outcome is canceled, the value is set to -25.

E02_09

Logic to compare Response → Call Times → Depart Scene and Response → Call Times → Arrive Destination. If greater than 30 minutes, the value is set to 295 - Other. If less than 30 minutes, the value is set to 290 - None. If the outcome is canceled, the value is set to -25.

E02_10

Value is hard-coded to 360 - None. If the outcome is canceled, the value is set to -25.

E02_20

Value is hard-coded to 390 - Lights and Sirens.

E03_01

Response → Incident Information → Incident → Dispatch
Complaint

E03_02

Value is hard-coded to -10 - Not Known.

E05_02

Response → Call Times → Dispatched

E05_04

Response → Call Times → Dispatched

E05_05

Response → Call Times → En Route

E05_06

Response → Call Times → At Scene

E05_07

Response → Call Times → At Patient

E05_09

Response → Call Times → Depart Scene

E05_10

Response → Call Times → Arrive Destination

E05_11

Response → Call Times → Unit Clear

E05_13

Response → Call Times → At Home

E06_08

Patient → Demographics → Home Address → Zip

E06_11

Patient → Demographics → Personal Info → Sex

E06_12

Patient → Demographics → Personal Info → Race

E06_13

Value is hard-coded to -10 - Not Known.

E06_16

Patient → Demographics → Personal Info → DOB

E07_01

Patient → Insurance → Medicare

Patient → Insurance → Medicaid

Patient → Insurance → Private Insurance

Patient → Insurance → Other Payer or Self Pay

E07_34

Response → Incident Information → Incident → Transport Type

E07_35

Value is hard-coded to -25 - Not Applicable.

E08_05

Value is hard-coded to -25 - Not Applicable.

E08_06

Value is hard-coded to 0 - No.

E08_07

Response → Incident Information → Location → Location Type

E09_01

Value is hard-coded to -10 - Unknown if Prior Aid was provided.

E09_02

Value is hard-coded to an empty string.

E09_03

Value is hard-coded to an empty string.

E09_04

Use logic with a selection from Events → Treatments and Situation → Chief Complaint → Primary Impression to determine the value.

E09_11

Use logic with Situation → Chief Complaint → Primary Impression to determine the value.

E09_12

Use logic with Situation → Chief Complaint → Primary Impression to determine the value.

E09_13

Use logic with Situation → Chief Complaint → Primary Impression to determine the value.

E09_14

Value is hard-coded to -25 - Not Applicable.

E09_15

Situation → Chief Complaint → Primary Impression

E09_16

Value is hard-coded to 1816 - None. If the outcome is canceled, the value is set to -25 - Not Available.

E10_01

Value is hard-coded to -10 - Not Known. If the outcome is canceled, the value is set to -25 - Not Available.

E10_03

Value is hard-coded to -25 - No Injury Present, unless E09_04 = 1, then the outcome is set to 2045 - Other.

E10_08

Value is hard-coded to -10 - Not Known. If the outcome is canceled, the value is set to -25 - Not Available.

E10_09

Value is hard-coded to -10 - Not Known. If the outcome is canceled, the value is set to -25 - Not Available.

E11_01

Value is hard-coded to -25 - Not Applicable, unless E19_03 = CPR or Defib, then the value is set to 2240 - Yes, Prior to EMS Arrival.

E11_02

Value is hard-coded to -25 - Not Applicable, unless E19_03 = CPR or Defib, then the value is set to 2275 - Other.

E11_03

Value is hard-coded to -25 - Not Applicable, unless E19_03 = CPR, then the value is set to 2280 - Attempted Defibrillation.

E12_01

Value is hard-coded to 2615 - None. If the outcome is canceled, the value is set to -25 - Not Available.

E12_19

Value is hard-coded to -10 - Not Known. If the outcome is canceled, the value is set to -25 - Not Available.

E14_04

Events → Vitals → Vitals → BP Sys

E14_05

Events → Vitals → BP Dia

E14_07

Events → Vitals →Vitals → HR (BPM)

E14_11

Events → Vitals → Vitals → RR (BPM)

E14_15

Events → Vitals → Glascow Coma Score → Eye Response

E14_16

Events → Vitals → Glascow Coma Score → Verbal Response

E14_17

Events → Vitals → Glascow Coma Score → Motor Response

E18_03

Events → Treatments → Medication Administration

Events → Treatments → Cardioversion / Defribrillation

E18_08

Value is hard-coded to 4390 - None.

E19_03

Selection from Events → Treatments

E19_01

Selection from Events → Treatments

E19_05

Value is hard-coded to 1.

Note: Some treatments have an input sub to show attempts, and we can get the value from there, but if there is no input sub, then it defaults to 1.

E19_06

If the procedure is present, the value is hard-coded to 1.

Note: Some treatments have an input sub to show success, and we can get the value from there, but if there is no input sub, then it defaults to 1.

E19_07

Value is hard-coded to 4500 - None.

E12_07

Value is hard-coded to an empty string.

E20_02

Summary → Disposition → Details → Destination

E20_10

Summary → Disposition → Details → Outcome

E20_14

Value is hard-coded to -25 - Not Applicable.

E20_16

Summary → Disposition → Details → Location Choice

E23_09

Value is hard-coded to -10 - Not Known.

E20_17

Value is hard-coded to the type of hospital indicated by the department in the FH Medic data import template → Locations worksheet → Location Type column.

E22_01

Value is hard-coded to -25 - Unknown, unless outcome is transported, then 5350 - Not Applicable (Transported to L&D or OR).

E22_02

Value is hard-coded to -25 - Not Applicable.