v_epcr_consumable

v_epcr_consumable

Purpose

  1. Tracks consumable items used during patient care.

Relationships


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

    • Many consumables link to one EPCR

    • Referenced through epcr_id

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

    • Many consumables link to one inventory item

    • Referenced through name matching


Table


Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

name

varchar(255)

Item name

quantity

integer

Quantity used

created_at

timestamp

Creation timestamp

patient_first_name

varchar(50)

Patient first name

patient_last_name

varchar(60)

Patient last name






    • Related Articles

    • AI- assisted ePCR Documentation Guide

      Purpose To provide useful information when using AI for ePCR Documentation. Featured Article For full guide select on the Attachment at bottom of the page. FirstDue AI-Powered ePCR Documentation FAQs General Information Q: What is the AI-assisted ...

    • v_epcr_exam

      Purpose Patient examination records. Relationships f_epcr: Many-to-One (N:1) Many exams link to one EPCR Referenced through epcr_id v_epcr_vital: One-to-Many (1:N) One exam can have many vital sign records Referenced through timeline relationship ...

    • v_epcr_disposition_team

      Purpose Patient care team disposition records. Relationships f_epcr: Many-to-One (N:1) Many dispositions link to one EPCR Referenced through epcr_id v_personnel: Many-to-Many (N:M) Many dispositions can involve many personnel Referenced through team ...

    • v_epcr_history_medication

      Purpose Patient medication history records. Relationships f_epcr: Many-to-One (N:1) Many medication histories link to one EPCR Referenced through epcr_id v_epcr_history: Many-to-One (N:1) Many medications link to one history record Referenced through ...

    • v_epcr_history

      Purpose Patient medical history records. Relationships f_epcr: Many-to-One (N:1) Many history records link to one EPCR Referenced through epcr_id v_epcr_history_medication: One-to-Many (1:N) One history record can have many medication records ...