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

    • AI- assisted ePCR Documentation Guide

      Purpose To provide useful information when using AI for ePCR Documentation. Featured Article For full guide select on the Attachment at bottom of the page. FirstDue AI-Powered ePCR Documentation FAQs General Information Q: What is the AI-assisted ...
    • Setting up the ePCR - Protocols

      Purpose To explain how to enter the data elements of the Protocols section of your EMS Setup and to define those data elements. Video Related Articles Setting up the ePCR - Demographics Setting up the ePCR - EMS Contacts Setting up the ePCR - Vendor ...
    • Documenting an ePCR Utilizing A.I.

      Purpose The purpose of this article is to demonstrate how to use A.I. when completing an ePCR. Video To begin using AI-powered documentation, please reach out to your administrator. Directions 1. From within an ePCR select on the A.I. icon to begin. ...
    • 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 - Protocols ...
    • Setting up the ePCR - Statistics

      Purpose To explain how to enter the data elements of the Statistics 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 - ...