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

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

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

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

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

      Purpose Patient medical history records. Relationships f_epcr: Many-to-One (N:1) Many history records link to one EPCR Referenced through epcr_id v_epcr_history_medication: One-to-Many (1:N) One history record can have many medication records ...