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

    • v_nfirs_firefighter_casualty

      Purpose Firefighter casualty records for NFIRS reporting. Relationships v_incident_report: Many-to-One (N:1) Many casualties link to one incident Referenced through incident_report_id v_nfirs_firefighter_casualty_equipment: One-to-Many (1:N) One ...