Dimensional Warehouse Model Data Model

Entity

Entity Inpatient Service Performance Analysis

Description

Analysis of the performance and utilization of inpatient services of a healthcare organization including length of stay, bed utilization and patient discharge processing.

Dimensions (and sample axes of analysis):
- Calendar (Reporting Year)
- Encounter
- Patient (Age, Gender, Smoker Status, BMI)
- Point of Care Location
- Diagnosis Related Group
- Diagnosis
- Practitioner
- Provider
- Health Insurer
- Plan Member

Attributes
Average Bed Turnaround Time
Average Daily Discharges
Average Duration Between Discharge Order To Patient Discharge
Average Length Of Stay
Bed Turnaround Time
Calendar Dk
Diagnosis Code Dk
Diagnosis Related Group Dk
Duration Between Discharge Order To Patient Discharge
Encounter Dk
Healthcare Insurer Dk
Length Of Stay
Number Of Admissions
Number Of Admissions To ICU
Number Of Available Beds
Number Of Beds
Number Of Closed Beds
Number Of Discharges
Number Of Medical Admissions
Number Of Occupied Beds
Number Of Patients With Length Of Stay Overage
Number Of Surgical Admissions
Patient Dk
Percentage Of Admissions To ICU
Percentage Of Beds Available
Percentage Of Beds Closed
Percentage Of Beds Occupied
Percentage Of Medical Admissions
Percentage Of Patients With Length Of Stay Overage
Percentage Of Surgical Admissions
Plan Member Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Service Days

Relationship
Inpatient Service Performance Analysis_Practitioner Dimension_FK
Inpatient Service Performance Analysis_Plan Member Dimension_FK
Inpatient Service Performance Analysis_Provider Dimension_FK
Inpatient Service Performance Analysis_Calendar Dimension_FK
Inpatient Service Performance Analysis_Diagnosis Related Group Dimension_FK
Inpatient Service Performance Analysis_Diagnosis Dimension_FK
Inpatient Service Performance Analysis_Encounter Dimension_FK
Inpatient Service Performance Analysis_Healthcare Insurer Dimension_FK
Inpatient Service Performance Analysis_Point Of Care Location Dimension_FK
Inpatient Service Performance Analysis_Patient Dimension_FK

Primary Key
Inpatient Service Performance Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Bed Turnaround Time

Description	The average time (in minutes) it takes for a bed to become available for occupancy after the previous occupant has been discharged. 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 Daily Discharges

Description	Average number of discharges during the period of analysis. 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 Duration Between Discharge Order To Patient Discharge

Description	Average amount of time (in Minutes) from the discharge order to the actual discharge time for all patients within the period of analysis. 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 duration of an inpatient's stay. Average of (discharge date – admit date + 1) (in whole days). 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	true
Is Surrogate Key	false

Bed Turnaround Time

Description	Time (in minutes) it takes for a bed to become available for occupancy after the previous occupant has been discharged.
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

Diagnosis Code 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

Duration Between Discharge Order To Patient Discharge

Description	The total amount of time (in Minutes) from the discharge order to the actual discharge time for all patients within the period of analysis.
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

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

Healthcare Insurer 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

Length Of Stay

Description	The duration of an inpatient's stay. 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 Admissions

Description	Number of inpatients within a period of analysis.
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	Number of Inpatients admitted to ICU within a period of analysis.
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 Beds

Description	Total number of beds available during the period of analysis.
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 in the hospital including closed beds. 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

Number Of Closed Beds

Description	Total number of beds that are not able to be assigned to a patient due to either cost containment, contamination, capacity or staff shortages etc
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	Number of Inpatients discharged within a period of analysis.
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 Medical Admissions

Description	Number of Inpatients admitted for medical treatment within a period of analysis.
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 Occupied Beds

Description	Total number of beds occupied by patients during the period of analysis.
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 Patients With Length Of Stay Overage

Description	Number of patients where the actual length of stay is greater than the expected length of stay.
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 Surgical Admissions

Description	Number of Inpatients admitted for surgical procedures within a period of analysis.
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 Of Admissions To ICU

Description	Percentage of Inpatients admitted to ICU within a period of analysis. 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

Percentage Of Beds Available

Description	Percentage of total beds that are available to be assigned to the patients. 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

Percentage Of Beds Closed

Description	Percentage of total beds that are not able to be assigned to a patient due to either cost containment, contamination, capacity or staff shortages etc 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

Percentage Of Beds Occupied

Description	Number of Available Beds occupied by the patients expressed as a percentage of available beds excluding number of beds closed either for cost containment, capacity or staff shortages. Formula: [(A/B) * 100] (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

Percentage Of Medical Admissions

Description	Percentage of Inpatients admitted for medical treatment within a period of analysis. 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

Percentage Of Patients With Length Of Stay Overage

Description	Percentage of patients where the actual length of stay is greater than the expected length of stay. 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

Percentage Of Surgical Admissions

Description	Percentage of Inpatients admitted for surgical procedures within a period of analysis. 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

Plan Member 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

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 Days

Description	Total number of service days within a period of analysis.
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

Relationship Details

Inpatient Service Performance Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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 Service Performance Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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	Plan Member Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Service Performance Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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 Service Performance Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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 Service Performance Analysis_Diagnosis Related Group Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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

Inpatient Service Performance Analysis_Diagnosis Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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 Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Service Performance Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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 Service Performance Analysis_Healthcare Insurer Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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	Healthcare Insurer Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Inpatient Service Performance Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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 Service Performance Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Inpatient Service 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

Primary Key Details

Inpatient Service Performance Analysis PK

Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Plan Member Dk
Key Attribute	Provider Dk
Key Attribute	Diagnosis Related Group Dk
Key Attribute	Diagnosis Code Dk
Key Attribute	Encounter Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Healthcare Insurer Dk
Key Attribute	Calendar Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model