v_nfirs_ems

v_nfirs_ems

Purpose

  1. EMS incident details for NFIRS reporting.


Relationships

  • v_incident_report_people: Many-to-One (N:1)

    • Many EMS records link to one person

    • Referenced through incident_report_people_id

  • v_nfirs_ems_medication: One-to-Many (1:N)

    • One EMS record can have many medications

    • Referenced through nfirs_ems_id

  • v_nfirs_ems_treatment: One-to-Many (1:N)

    • One EMS record can have many treatments

    • Referenced through nfirs_ems_id

  • v_nfirs_ems_vital_sign: One-to-Many (1:N)

    • One EMS record can have many vital signs

    • Referenced through nfirs_ems_id




Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

incident_report_people_id

integer

Person reference

patient_number

integer

Patient number

arrived_date

date

Arrival date

arrived_time

time

Arrival time

transfer_date

date

Transfer date

transfer_time

time

Transfer time

provider_impression_assessment

varchar(3)

Assessment code

date_of_birth

date

Birth date

race

varchar(2)

Race code

ethnicity

varchar(2)

Ethnicity code

human_factors_contributing_injury

varchar(2)[]

Contributing factors

is_patient_injured

boolean

Injury status

body_site_injury

varchar(2)[]

Injury sites

injury_type

varchar(3)[]

Injury types

cause_of_illness_injury

varchar(3)[]

Cause codes

safety_equipment

varchar(2)[]

Equipment codes

is_cardiac_arrest

boolean

Cardiac status

cardiac_arrest

varchar(2)

Arrest code

patient_status

varchar(2)

Status code

narrative

text

Incident narrative

created_by

integer

Creator reference

created_at

timestamp

Creation time

updated_at

timestamp

Update time

    • Related Articles

    • v_nfirs_ems_treatment

      Purpose EMS treatment records for NFIRS reporting. Relationships v_nfirs_ems: Many-to-One (N:1) Many treatments link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many treatments performed by one provider Referenced ...
    • v_nfirs_ems_medication

      Purpose EMS medication administration records for NFIRS. Relationships v_nfirs_ems: Many-to-One (N:1) Many medications link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many medications administered by one provider ...
    • v_nfirs_ems_signature

      Purpose Electronic signature records for EMS reports. Relationships v_nfirs_ems: Many-to-One (N:1) Many signatures link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many signatures created by one provider ...
    • v_nfirs_ems_vital_sign

      Purpose EMS vital signs records for NFIRS reporting. Relationships v_nfirs_ems: Many-to-One (N:1) Many vital signs link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many vital signs taken by one provider Referenced ...
    • EMS Setup - General - General subsection

      Purpose Statement This article provides step-by-step guidance on configuring EMS-related system settings within the Incident Documentation > EMS Setup area. These settings help agencies tailor ePCR behavior, CAD integration, and compliance-related ...