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

    • AI- assisted ePCR Documentation Guide

      Purpose To provide useful information when using AI for ePCR Documentation. Featured Article For full guide select on the Attachment at bottom of the page. FirstDue AI-Powered ePCR Documentation FAQs General Information Q: What is the AI-assisted ...

    • Release Notes - ePCR

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

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