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

    • 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 - Novemeber 2025

      New Features OneDose - Integration and consumption of data for OneDose What - This feature introduces integration with OneDose, a medication dosing calculator platform that enables ePCR to import patient-specific medication dosing calculations and ...

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

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

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