v_nfirs_ems_treatment

v_nfirs_ems_treatment

Purpose

  1. 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 through provider




Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

nfirs_ems_id

integer

EMS record reference

ems_treatment_code

varchar(50)

Treatment code

performed_date

date

Treatment date

performed_time

time

Treatment time

performed_code

varchar(10)

Performance code

provider

integer

Provider reference

number_of_attempts

integer

Attempt count

attempts_code

varchar(10)

Attempts code

successful_code

varchar(10)

Success code

created_by

integer

Creator reference

created_at

timestamp

Creation time

updated_at

timestamp

Update time





    • Related Articles

    • v_nfirs_ems

      Purpose 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 ...
    • 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 ...