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 Statement The AI-Powered ePCR Documentation feature streamlines the creation of Patient Care Reports by allowing EMS providers to record patient care details verbally through medical-grade speech transcription combined with AI processing. ...
    • 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 ...
    • 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 ...