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

    • v_epcr_history_medication

      Purpose Patient medication history records. Relationships f_epcr: Many-to-One (N:1) Many medication histories link to one EPCR Referenced through epcr_id v_epcr_history: Many-to-One (N:1) Many medications link to one history record Referenced through ...