v_epcr_procedure

v_epcr_procedure

Purpose

  1. Patient care procedure records.

Relationships

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

    • Many procedures link to one EPCR

    • Referenced through epcr_id

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

    • Many procedures performed by one personnel

    • Referenced through procedure_crew_member


Table



Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

performed_at

timestamp

Procedure time

pta_code

varchar(20)

PTA code

number_attempts

integer

Attempt count

treatment_code

varchar(20)

Treatment code

procedure_successful_code

varchar(20)

Success code

procedure_complication_codes

varchar(20)[]

Complication codes

procedure_response_code

varchar(20)

Response code

state_ems_certification_licensure_level_code

varchar(20)

Certification level

created_at

timestamp

Creation timestamp

procedure_crew_member

text

Crew member





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

    • Release Notes - ePCR Incident Documentation

      In order to provide you with more detailed information on our updates, we have broken the Release Notes down by module. Video Enhancements 1. QA/QI Notification Center What: Add the option for QA/QI automated emails to go to the Notification Center ...

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

    • Documenting an ePCR Utilizing A.I.

      Purpose Statement The purpose of this article is to demonstrate how to use A.I.-powered documentation tools when completing an EMS Patient Care Report (ePCR) in First Due. This feature enhances field documentation by allowing users to transcribe ...

    • ePCR Release Notes - October 2025

      New Features 1. CAD - Option to Import All Apparatus from CAD into ePCR What - Multi-unit CAD import functionality has been enabled with configurable primary and supporting unit logic, allowing users to select multiple apparatus and crew from CAD ...