v_epcr_medication

v_epcr_medication

Purpose

  1. Current medication administration records.

Relationships

  • f_epcr: Many-to-One (N:1)

    • Many medications link to one EPCR

    • Referenced through epcr_id

  • v_personnel: Many-to-One (N:1)

    • Many medications administered by one personnel

    • Referenced through state_licensure_id_number



Table


Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

administrated_at

timestamp

Administration time

administrated_at_code

varchar(20)

Time code

pta_code

varchar(20)

PTA code

medication_code

varchar

Medication code

medication_administrated_route_code

varchar(20)

Route code

medication_dosage

double precision

Dosage amount

medication_dosage_units_code

varchar(20)

Units code

medication_response_code

varchar(20)

Response code

medication_complication_codes

varchar(20)[]

Complication codes

state_licensure_id_number

varchar(50)

License number

created_at

timestamp

Creation timestamp



    • Related Articles

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

    • v_epcr_history

      Purpose Patient medical history records. Relationships f_epcr: Many-to-One (N:1) Many history records link to one EPCR Referenced through epcr_id v_epcr_history_medication: One-to-Many (1:N) One history record can have many medication records ...

    • Documenting Medication Usage

      Purpose To explain how to document medication usage in the medication module. Video Directions 1. Begin by navigating to the Medications module then selecting either Med Kits or Dashboard. 2. If documenting from the Med Kits, select on a kit from ...

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

    • Completing an ePCR - Information

      Purpose Statement To explain how to complete the Information section of an ePCR, including patient demographics, medical history, insurance information, and utilizing advanced features like driver's license scanning and patient search functionality ...