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

    • Release Notes - ePCR

      In order to provide you with more detailed information on our updates we have broken the Release Notes down by module. Video New Features 1. Transfers What: This feature introduces a streamlined workflow for transferring electronic Patient Care ...

    • ePCR Release Notes : June 2025

      Video New Features 1. ePatient.25 Patient's Sex This critical patch implements NEMSIS 3.5.0 compliance requirements by introducing the new ePatient.25 - Patient's Sex field in response to federal regulatory changes. Due to a Presidential Executive ...

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