v_epcr_vital

v_epcr_vital

Purpose

  1. Patient vital signs records.

Relationships

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

    • Many vitals link to one EPCR

    • Referenced through epcr_id

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

    • Many vitals taken by one provider

    • Referenced through vital_provider



Table



Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

taken_at

timestamp

Assessment time

pta_code

varchar(20)

PTA code

cardiac_rhythm_codes

varchar(20)[]

Rhythm codes

ecg_type_code

varchar(20)

ECG type

systolic_blood_pressure

integer

Systolic BP

diastolic_blood_pressure

varchar

Diastolic BP

heart_rate

integer

Heart rate

pulse_oximetry

integer

O2 saturation

respiratory_rate

integer

Resp rate

end_tidal_carbon_dioxide

double precision

ETCO2

blood_glucose_level

varchar(5)

Glucose level

temperature

double precision

Temperature

total_glasgow_coma_score

integer

GCS total

vital_provider

integer

Provider ID





    • Related Articles

    • v_epcr_exam

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

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

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

    • Completing an ePCR - Response

      Completing an ePCR - Response Purpose Statement To explain how to complete the Response section of an ePCR (electronic Patient Care Record) in First Due. This section captures critical incident response data including crew information, dispatch ...

    • ePCR Release Notes: July 2025

      Video <br> New Features 1. AI-Powered Attachment Data Extraction in ePCR This feature introduces AI-powered image analysis within the ePCR attachment modal, allowing users to automatically extract structured patient data (e.g., name, DOB, ...