v_nfirs_ems_medication

v_nfirs_ems_medication

Purpose

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

    • 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_medication_code

varchar(50)

Medication code

performed_date

date

Administration date

performed_time

time

Administration time

performed_code

varchar(10)

Performance code

provider

integer

Provider reference

route

varchar(20)

Administration route

dosage

double precision

Dosage amount

dosage_code

varchar(10)

Dosage code

dosage_unit_code

varchar(20)

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

    • Fire Incident Setup - EMS Module - Configuration Fields

      Purpose Statement The Configuration Fields section of the Fire Incident EMS Module allows administrators to customize treatment and medication options to align with local protocols and operational standards. This feature enables departments to: ...