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

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

    • v_epcr_history_medication

      Purpose Patient medication history records. Relationships f_epcr: Many-to-One (N:1) Many medication histories link to one EPCR Referenced through epcr_id v_epcr_history: Many-to-One (N:1) Many medications link to one history record Referenced through ...

    • v_epcr_disposition_team

      Purpose Patient care team disposition records. Relationships f_epcr: Many-to-One (N:1) Many dispositions link to one EPCR Referenced through epcr_id v_personnel: Many-to-Many (N:M) Many dispositions can involve many personnel Referenced through team ...