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 ...
    • 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 ...
    • Release Notes - ePCR

      In order to provide you with more detailed information on our updates we have broken the Release Notes down by module. Video New Features 1. Transfers What: This feature introduces a streamlined workflow for transferring electronic Patient Care ...