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 The purpose of this article is to help navigate the General subsection for the EMS Setup. Video Directions 1. Navigate to the Incident Documentation module and select on EMS Setup. 2. Select on the General section and navigate to the General ...