f_epcr_crew

f_epcr_crew

Purpose

  1. 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 link to one personnel

    • Referenced through crew member identification



Table


Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

crew_member_response_role_codes

varchar[]

Response roles

state_licensure_id_number

varchar

License number

state_licensure_name

varchar

License name

state_ems_certification_licensure_level_code

varchar

Certification level

client_code

varchar

Organization identifier

created_at

timestamp

Creation timestamp

patient_first_name

varchar

Patient first name

patient_last_name

varchar

Patient last name




    • Related Articles

    • v_epcr_other_crew

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

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

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

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