v_epcr_history

v_epcr_history

Purpose

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

    • Referenced through historical relationship



Table


Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

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

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

    • v_personnel_employment_history

      Purpose Personnel employment history records. Relationships v_personnel: Many-to-One (N:1) Many history records link to one personnel Referenced through user_id v_fire_dept_user: Many-to-One (N:1) Many history records created by one user Referenced ...

    • v_preplan_hazmat_history

      Purpose Historical hazardous materials records. Relationships v_preplan_hazmat: Many-to-One (N:1) Many history records link to one current hazmat record Referenced through matching attributes v_occupancy: Many-to-One (N:1) Many hazmat histories link ...

    • v_preplan_unit_history

      Purpose Historical pre-plan unit information. Relationships v_preplan_unit: Many-to-One (N:1) Many history records link to one current unit Referenced through matching attributes Table Column Type Description id integer Primary key ...