v_epcr_history_medication

v_epcr_history_medication

Purpose

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




Table



Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

ems_medication_name

text

Medication name

created_at

timestamp

Creation timestamp

patient_first_name

varchar(50)

Patient first name

patient_last_name

varchar(60)

Patient last name





    • Related Articles

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

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