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

    • f_ecpr

      Purpose Electronic Patient Care Report fact table for documenting patient care incidents. Relationships f_epcr_crew: One-to-Many (1:N) One EPCR can have multiple crew members Referenced through epcr_id v_epcr_complaint: One-to-Many (1:N) One EPCR 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 ...