Dimensional Warehouse Model Data Model

Entity

Entity Inpatient Operational Performance Analysis

Description

Providers need to monitor and understand the operational efficiency of inpatient care facilities. This includes key metrics such as the number of admissions and the type of these admissions as well as length of stay and the overall utilization of beds in the facility. A high utilization rate suggests a efficiently managed inpatient facility but, if very high, it may also indicate a potential problem whereby the facility has no free capacity to deal with unplanned admissions such as those that may come though the emergency department. The analysis includes a measure relating to outpatient surgeries that may appear out of place but it is a useful metric for the hospital management team when considering if some of the surgical inpatient workload could be more efficiently performed using outpatient surgical care.

Attributes
Aggregate Patient Census
Average Daily Census
Average Length Of Stay
Calendar Dk
Condition Dk
Diagnosis Related Group Dk
Encounter Dk
Hospitalization Rate
Number Of Admissions
Number Of Admissions Due To Fall
Number Of Admissions To ICU
Number Of ALC Patients
Number Of Available Bed Days
Number Of Beds
Number Of Closed Beds
Number Of Discharges
Number Of Inpatient Surgeries
Number Of Off Service Admissions
Number Of Outpatient Surgeries
Number Of Overnight PACU Patients
Number Of Patient Days
Number Of Reporting Period Days
Patient Dk
Percentage Bed Utilization
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Service Dk

Relationship
Inpatient Operational Performance Analysis_Calendar_FK
Inpatient Operational Performance Analysis_Point Of Care Location_FK
Inpatient Operational Performance Analysis_Provider_FK
Inpatient Operational Performance Analysis_Patient_FK
Inpatient Operational Performance Analysis_Encounter_FK
Inpatient Operational Performance Analysis_Practitioner_FK
Inpatient Operational Performance Analysis_Service Dimension_FK
Inpatient Operational Performance Analysis_Condition Dimension_FK
Inpatient Operational Performance Analysis_Diagnosis Related Group_FK

Primary Key
Inpatient Operational Performance Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Aggregate Patient Census

Description	The total of the number of patients present at the census time point, typically midnight, for each day of the reporting period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Daily Census

Description	The average number of patients in the facility each day over the reporting period based on a patient census, typically a count of patients present at midnight. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Length Of Stay

Description	The average number of whole days a patient was admitted to the facility. This is based on total patient days divided by the number of admissions. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Condition Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Diagnosis Related Group Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Encounter Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Hospitalization Rate

Description	The rate of admissions to inpatient care in the facility. This is based on the number of admissions during the reporting period divided by the number of days covered by the reporting period giving an average number of patients admitted per day. This could be modified, for example, to give a weekly rate or a 4 weekly rate my multiplying the result by 7 or 28. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Admissions

Description	A count of inpatient admissions to an acute hospital or other healthcare facility.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Admissions Due To Fall

Description	A count of inpatient admissions that were due to an incident where the patient fell causing actual or suspected injury or where there is an assessed risk of the patient being injure in a subsequent fall.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Admissions To ICU

Description	A count of patients admitted to the Intensive Care Unit.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of ALC Patients

Description	A count of patients located in the Alternative Care Unit (at midnight).
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Available Bed Days

Description	A count of the beds that were available for patient use during the reporting period. If a unit had 5 beds and the reporting period was 1 week (7 days) that would represent 35 bed days. The calculation of available bed days should take into account beds that cannot be used such as beds in a unit that is closed due to contamination, or beds closed due to lack of staff availability. Formula: [(A-B)*C)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Beds

Description	Total number of beds during the reporting period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Closed Beds

Description	A count of beds that are not able to be assigned to a patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Discharges

Description	A count of patients discharged from the healthcare facility during the reporting period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Inpatient Surgeries

Description	Number of surgeries performed in an inpatient setting.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Off Service Admissions

Description	Count of admissions where service is not Emergency.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Outpatient Surgeries

Description	A count of surgeries performed in an outpatient setting.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Overnight PACU Patients

Description	Number of patients located in the Post Anesthesia Care Unit,
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Patient Days

Description	The aggregate number of days patients were in the facility as inpatients during the reporting period. This is based on the Discharge date – Admit date + 1 (in whole days).
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Reporting Period Days

Description	A count of the number of whole days included in the reporting period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Percentage Bed Utilization

Description	The rate of bed use in a healthcare facility based on the overnight bed occupancy or patient census. This is the number of patients in the facility at midnight expressed as a percentage of the available beds. The calculation is based on numbers of patients and available beds over the reporting period. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Point Of Care Location Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Provider Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Service Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relationship Details

Inpatient Operational Performance Analysis_Calendar_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Operational Performance Analysis_Point Of Care Location_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Operational Performance Analysis_Provider_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Operational Performance Analysis_Patient_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Operational Performance Analysis_Encounter_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Operational Performance Analysis_Practitioner_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Operational Performance Analysis_Service Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Service Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Operational Performance Analysis_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Condition Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Operational Performance Analysis_Diagnosis Related Group_FK

Is Identifying Relationship	true
Child Table	Inpatient Operational Performance Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Diagnosis Related Group Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Inpatient Operational Performance Analysis PK

Key Attribute	Patient Dk
Key Attribute	Provider Dk
Key Attribute	Encounter Dk
Key Attribute	Practitioner Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Calendar Dk
Key Attribute	Service Dk
Key Attribute	Condition Dk
Key Attribute	Diagnosis Related Group Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model