v_epcr_other_crew

v_epcr_other_crew

Purpose

  1. Additional crew member records for patient care.

Relationships

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

    • Many crew records link to one EPCR

    • Referenced through epcr_id

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

    • Many crew records link to one personnel

    • Referenced through state_licensure_id_number



Table



Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

protective_equipment_codes

varchar(20)[]

Equipment codes

state_licensure_id_number

varchar(50)

License number

injury_exposure_type_codes

varchar(20)[]

Exposure codes

state_ems_certification_licensure_level_code

varchar(20)

Certification level

suspected_ems_work_code

text

Work code

created_at

timestamp

Creation timestamp





    • Related Articles

    • f_epcr_crew

      Purpose Tracks crew members associated with electronic patient care reports. Relationships f_epcr: Many-to-One (N:1) Many crew members can be associated with one EPCR Referenced through epcr_id v_personnel: Many-to-One (N:1) Many crew entries can ...

    • v_epcr_procedure

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

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

    • Resolving QA/QI comments - Crew Members

      Purpose Statement This article demonstrates the process for resolving QA/QI comments from the perspective of the ePCR report author, ensuring proper response to reviewer feedback and maintaining quality documentation standards. Background Information ...

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