Patient Procedures Fact

The Patient Procedures Fact table includes columns related to the facts on the procedures performed in Oracle Health Immunization Management.

Details
Module: Oracle Health Immunization Management

Table 3-22 Patient Procedures Fact Columns

Name Description
# of Procedures Total number of procedure records entered into the system (including Administered, Unable to Administer, Administered with Wastage and Self Reported)
# of Procedures By Self Reported Total number of manually processed procedures with procedure outcome of Self-Reported (for example, Proof of Prior Vaccination)
# of Distinct Slots Number of slots
# of Distinct Vaccines Number of distinct vaccines administered
# of Procedures Administered Total number of procedure records entered in the system with procedure outcome as Administered
# of Procedures Externally Administered Total number of records processed with a procedure outcome of Self-Reported (for example, through a Proof of Prior Vaccination application such as CommonPass). Healthcare workers can manually enter the Self-Reported outcome when processing an appointment or the system obtained this outcome through Patient Portal, walk-in patient appointments, or bulk uploaded procedure data
# of Procedures Administered with Wastage Total number of procedure records entered in the system with procedure outcome as Administered with Wastage
# of Procedures Unable to Administer Total number of procedure records entered in the system with procedure outcome as Unable to Administer
# Administered (All) Total number of procedure records entered in the system with procedure outcome as Administered and Administered with Wastage
# Administered (Dose 1) Total number of Dose 1 procedures
# Administered (Dose 2) Total number of Dose 2 procedures
# of Procedures By Appointment Total number of procedure records entered in the system through Appointment
# of Procedures By Bulk Load Total number of procedure records entered in the system through Bulk Load
# of Procedures By External System Total number of procedure records entered in the system through External System
# of Procedures By Self Reported App Total number of procedure records entered in the system through Self Reported App
# of Procedures By Walk In Total number of procedure records entered in the system through Walk In
Cumulative Procedures Cumulative sum of the number of procedures