v_epcr_exam

v_epcr_exam

Purpose

  1. Patient examination records.

Relationships

  • f_epcr: Many-to-One (N:1)

    • Many exams link to one EPCR

    • Referenced through epcr_id

  • v_epcr_vital: One-to-Many (1:N)

    • One exam can have many vital sign records

    • Referenced through timeline relationship



Table


Column

Type

Description

id

integer

Primary key

assessment_obtained_at

timestamp

Assessment time

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

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

    • ePCR Release Notes : June 2025

      Video New Features 1. ePatient.25 Patient's Sex This critical patch implements NEMSIS 3.5.0 compliance requirements by introducing the new ePatient.25 - Patient's Sex field in response to federal regulatory changes. Due to a Presidential Executive ...

    • Setting up the ePCR - Validation

      Purpose To explain how to enter the data into the Validation 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 - Devices ...

    • ePCR: Create and Document without Internet Connection

      Purpose Statement To explain how users can create, document, and sync an ePCR when an internet connection is unavailable. This capability supports continuous EMS documentation in remote areas or during connectivity interruptions, ensuring no data is ...

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