v_nfirs_ems_signature

v_nfirs_ems_signature

Purpose

  1. Electronic signature records for EMS reports.


Relationships

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

    • Many signatures link to one EMS record

    • Referenced through nfirs_ems_id

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

    • Many signatures created by one provider

    • Referenced through provider




Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

nfirs_ems_id

integer

EMS record reference

performed_date

date

Signature date

performed_time

time

Signature time

person_type_code

varchar(10)

Signer type

representative_type_code

varchar(10)

Representative type

provider

integer

Provider reference

signing_reason_codes

jsonb

Reason codes

first_name

varchar(50)

Signer first name

mid_name

varchar(50)

Signer middle name

last_name

varchar(50)

Signer last name

ems_signature_status_code

varchar(10)

Status code

no_signature_reason

varchar(10)

Missing reason

signature_data

text

Signature data

created_by

integer

Creator reference

created_at

timestamp

Creation time

updated_at

timestamp

Update time




    • Related Articles

    • v_nfirs_ems

      Purpose EMS incident details for NFIRS reporting. Relationships v_incident_report_people: Many-to-One (N:1) Many EMS records link to one person Referenced through incident_report_people_id v_nfirs_ems_medication: One-to-Many (1:N) One EMS record can ...
    • v_nfirs_ems_medication

      Purpose EMS medication administration records for NFIRS. Relationships v_nfirs_ems: Many-to-One (N:1) Many medications link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many medications administered by one provider ...
    • v_nfirs_ems_treatment

      Purpose EMS treatment records for NFIRS reporting. Relationships v_nfirs_ems: Many-to-One (N:1) Many treatments link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many treatments performed by one provider Referenced ...
    • v_nfirs_ems_vital_sign

      Purpose EMS vital signs records for NFIRS reporting. Relationships v_nfirs_ems: Many-to-One (N:1) Many vital signs link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many vital signs taken by one provider Referenced ...
    • EMS Setup - Signature Setup

      Purpose: To demonstrate the process of configuring Signature Blocks and Form Language for use within an ePCR. Video: Information Related Article: Completing an ePCR - Obtaining Signatures What is a Signature Block? A signature block represents a ...