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

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

    • Setting up the ePCR - Devices

      Purpose To explain how to enter the data elements of the Devices section of your EMS Setup. Related Articles Setting up the ePCR - Demographics Setting up the ePCR - EMS Contacts Setting up the ePCR - Vendor Directory Setting up the ePCR - Protocols ...

    • Completing an ePCR - 2. Information

      Purpose To explain how to complete the Information section of an ePCR. Related Articles Completing an ePCR - 1. Response Completing an ePCR - 2. Information (This Article) Completing an ePCR - 3. Assessment Completing an ePCR - General Assessment ...