Text Size: A+ A- A  •   Text Only Site
Topics
  A-Z
Data &
 Statistics
Forms &
Publications
News &
Advisories
Licensing &
Certification
Rules &
Regulations
Public Health
Directory
Print this Article   Bookmark and Share
Proposed Database Datapoints 
Please read the following carefully. Below is the list of proposed datapoints for the Oregon Prehospital Database (PhD). This list is a public record working document, provided for review and comment by any party. The State of Oregon can change the contents of this page at any time, and is under no legal obligation to incorporate any of the elements in its final database.

The database must contain all of the listed datapoints, with the following exceptions.
- Latitude and longitude of the event.
- Either field_procedure_time or field_procedure_number may be omitted.
Scroll down the list to see the categories of datapoints.
- IDs and times
- Patient data
- Incident data
- Assessment and Interventions

Datapoint

Description

NHTSA Ref#

Other Specifications
IDs and times



incident id
unique number for each incident reported to dispatch

1


agency id
Number assigned by the Health Services that identifies the agency

24


unit number
number or alphanumeric combination that designates the specific unit within an agency and is assigned by the agency

24


data_entry_date
last date of data entry or change

Automatically entered
data_entry_by
person entering data

Automatically entered
service type
type of service requested

20


vehicle type
type of vehicle used by unit responding to incident

25

Would like to add "Non-Transport Ground"
crew1 id
the EMT number, assigned by OHS, of the person completing the patient care report

26


crew2 id
EMT number for crew member #2

27


crew1 level
certification level of person writing the PCR

29


crew2 level
certification level of crew member #2

30


highest certification
most advanced level of EMT or other certification provided by the reporting agency at the scene of the incident
Defined following NHTSA 29 & 30
incident date
date/time of the occurrence

6,7


received date & time
date/time the incident is first reported to the dispatcher of the responding unit

8,10


dispatched date & time
date/time response unit is notified by dispatch

11,12


dispatch day of week
day of the week of dispatch

code to scene
urgency of response en-route to the scene
Defined following NHTSA 19. Use values of Code 1, Code 3
code change to scene
upgraded or downgraded response to the scene
Upgraded, downgraded, no change
canceled
indicates if call canceled

canceled date & time
date/time responding unit is notified of cancellation by dispatch

arrival date & time
date/time response unit physically stops at the scene

14


extrication minutes
time required for extrication

departure date & time
date/time unit began motion from the scene to destination

16


code from scene
urgency of departure from the scene
Defined following NHTSA 46. Use values of Code 1, Code 3
code change from scene
upgraded or downgraded departure from the scene
Upgraded, downgraded, no change
destination category
type of facility or agency that received the patient from the agency providing this report

44

Would like to add "Nursing home / extended care facility"
destination code
4 digit code assigned by the Health Services which identifies the hospital or prehospital unit that received the patient

destination determination
the primary reason a transport destination was selected

45


destination date & time
date/time the patient arrives at the destination or point for transfer of care

17


in service time
time response unit back in service and available for response

18


incident_disposition
the end result of this agency's involvement in this incident

47






Patient



last_name
legal last name of the patient

32


first_name
legal first name of the patient

32


middle_initial
patient's middle initial

32


unidentified
Unidentified patient

yes/no
birth_date
patient's date of birth

40


age
patient's age calculated from injury date

46


age_unit
patient's estimated or stated age

Include options for N days, N months
gender
gender of the patient

42


ethnicity
race and ethnicity of the patient

43


ssn
patient's social security number

39


address
patient's home street address

28


city
patient's city of residence

34


county
patient's county of residence

35


state
patient's state of residence

36


zip
patient's home zip code

37


insurance company
patient's insurance company

prepare a list
insurance ID
patient's insurance policy ID number


DNR
was there evidence of a DNR





Incident



nature_of_call
nature of call

See Nature of Call list, Footnote 1 below
address
street address to which the unit responded (incident address)

1


city
city in which the incident occurred

2


county
county in which the incident occurred

3


state
state in which the incident occurred

4


zip
zip code at which the incident occurred

latitude
geographic location of the incident
For future use.
longitude
geographic location of the incident
For future use.
location_type
place where the injury occurred

5


site_condition
special factors affecting EMS response or delivery of care

56


patients_on_scene
number of persons requesting or consenting to examination by EMS providers

mps
multiple patient scene

mci
scene declared a mass casualty incident by EMS providers

injury_cause
external cause of injury

49


job_injury
identifies patients who were injured while at work

protective_equipment
protective equipment used by primary EMT

Gloves, Eye Protection, Mask, Gown, Other
clinical_impression
provider's clinical impression which led to the management given the patient

50


severity_assessment
EMT assessment of the severity of the patient's illness/injury


past_medical_history
pre-existing medical conditions known to the provider

51


symptom
signs or symptoms reported to or observed by provider

52

Would like to add "Pregnancy Related"
body_site
body site of injury

53a


injury_type
clinical description of injury

53b


etoh_suspected
provider suspects alcohol use by the patient

57


drugs_suspected
provider suspects illicit drug use by the patient

57


veh_restraint
safety equipment in use by patient at time of injury

55

Negotiable. May be changed to multiple-entry list.
veh_ptlocation
if vehicular: patient's location
Driver; passenger; pedestrian
veh_number1
if vehicular: type of patient's vehicle
Car; truck; bus; motorcycle; bicycle; stationary object; other
veh_number2
if vehicular: type of object that patient's vehicle was involved with
Car; truck; bus; motorcycle; bicycle; stationary object; other
trauma patient


trauma_id
six digit trauma id band number

trauma_system_entry_date & time
date/time the trauma hospital or MRH was contacted by EMS

triage_criteria
trauma triage criteria marked
See Triage Criteria list.




Assessment and Interventions


respiration_effort
patient's effort at respiration

69


perfusion
patient's skin perfusion

72


responsiveness
assessment of patient's level of consciousness
Alert, Verbal, Pain, Unconscious; alternative to GCS scores
airway_initial
type of airway management performed on the patient by the agency
Would like a variable indicating airway status at time of initial assessment, with the following values: Normal, Oral/Nasal, BVM, ET Intubation, PEAD, Cric, Trach, CombiTube, LMA, Other
paralytics_initial
was the patient chemically paralyzed
Would like a variable indicating paralyzed status at time of initial assessment
pulse_initial
patient's palpated or auscultated pulse rate expressed in number per minute

65


respiration_initial
unassisted respiratory rate expressed as number per minute

68


sbp_initial
patient's systolic blood pressure

70


gcs_eye_initial
patient's eye opening component of the Glasgow Coma Scale taken or acted upon by the agency providing this report

73


gcs_verbal_initial
patient's verbal response component of the Glasgow Coma Scale taken or acted upon by the agency providing this report

74


gcs_motor_initial
patient's motor response component of the Glasgow Coma Scale taken or acted upon by the agency providing this report

75


gcs_total_initial
patient's total Glasgow Coma Scale taken or acted upon by the agency providing this report

76


airway_final
type of airway management performed on the patient by the agency
Would like a variable indicating airway status at time of final assessment, with the following values: Normal, Oral/Nasal, BVM, ET Intubation, PEAD, Cric, Trach, CombiTube, LMA, Other
paralytics_final
was the patient chemically paralyzed
Would like a variable indicating paralyzed status at time of final assessment
pulse_final
patient's palpated or auscultated pulse rate expressed in number per minute

65


respiration_final
unassisted respiratory rate expressed as number per minute

68


sbp_final
patient's systolic blood pressure

70


gcs_eye_final
patient's eye opening component of the Glasgow Coma Scale taken or acted upon by the agency providing this report

73


gcs_verbal_final
patient's verbal response component of the Glasgow Coma Scale taken or acted upon by the agency providing this report

74


gcs_motor_final
patient's motor response component of the Glasgow Coma Scale taken or acted upon by the agency providing this report

75


gcs_total_final
patient's total Glasgow Coma Scale taken or acted upon by the agency providing this report

76


end tidal CO2 detection



ectopy



pulse_oximetry



first cpr
provider of first CPR

59


initial_ecg
initial monitored cardiac rhythm as interpreted by EMS personnel

66


destination_ecg
monitored cardiac rhythm upon arrival at destination

67


arrest witness
witness of cardiac arrest if one occurred

62


return of spontaneous circ
was a palpable pulse or blood pressure restored following cardiac arrest and resuscitation

64


return of spont circ. time



field_procedure_time
time of procedure


field_procedure_number
ordinal number of procedure

alternative to time of procedure
field_procedure
procedures performed on the patient by the agency completing this report

78


field_procedure_performed_by
EMT performing the procedure


number_of_attempts
time the procedure was attempted

79


successful
was the procedure successful


patient_response
patient response to procedure

Improved, No Change, Other
medication
medications administered to the patient

80


solution


amount


online_advice
communication with medical control attempted by EMS providers


online_advice_date & time











Footnote 1: Possible values for Nature of Call



Medical Causes

Trauma Causes

Cardiac arrest

Motor vehicle accident

Chest pain

Gunshot

Difficulty breathing

Stabbing

Seizure

Domestic violence

Diabetic

Other assault

Overdose

Other trauma

Neurologic



Maternity/obstetric

Other Causes

Behavioral/psychiatric

Fire/Standby

Other medical reason

Scheduled transport



Other




Footnote 2: Trauma System Criteria



Mandatory Entry

Discretionary Entry

SBP < 90 mm Hg

Fall > 20 feet

Respiratory distress; resp rate <10 or >29 or requiring management
Pedestrian hit at 20 mph or thrown 15 feet

GCS <= 12

Roolover

Penetrating injury to head, neck, torso, or groin

Motorcycle, ATV, bicycle crash

Amputation above wrist or ankle

Impact / significant intrusion

Spinal cord injury with limb paralysis

Age <5 or age > 55

Flail chest

Bleeding disorder, or on anticoagulants

Two or more obvious fractures of femur or humerus

Card / resp deisease, diabetes, cirrhosis, or morbid obesity

Death of same car occupant

Pregnancy

Patient ejected from enclosed vehicle

Immunosuppressed

Heavy extrication time (> 20 minutes)

Presence of intoxicants



Other





For further information please contact:
800 NE Oregon Street, Suite 465
Portland, OR 97213
971 673-0520

Web Editor Access