Dimensional Warehouse Model Data Model

Entity

Entity Laboratory Performance Analysis

Description

Analysis of the performance and utilization of clinical laboratory services for a healthcare organization.
Laboratory services are used to carry out tests on clinical specimen to obtain information about patient health. The lab results assist in the decision making process of diagnosis, treatment and prevention of the disease.

Dimensions (and sample axes of analysis):
- Calendar (Reporting Year)
- Encounter (Inpatient, outpatient settings)
- Patient (Age, Gender, Smoker Status, BMI)
- Point of Care Location
- Specimen (Type of Specimen)
- Lab Test (Type of test)
- Practitioner
- Provider

Attributes
Average Daily Lab Order Volumes
Average Daily Lab Result Volumes
Average Lab Turnaround Times
Average Lab Turnaround Times For Urgent Orders
Blood Products To Patients Ratio
Calendar Dk
Encounter Dk
Lab Test Dk
Number Of Blood Product Units Issued
Number Of Blood Product Unit Transfused
Number Of Critical Lab Results
Number Of Duplicate Lab Orders
Number Of Lab Orders
Number Of Lab Results Reported
Number Of Lab Retests
Number Of Lab Test Days
Number Of Pending Specimen for Lab Test
Number Of Unverified Lab Results
Number Of Urgent Lab Orders
Number Of Urgent Lab Results Reported
Ordering Practitioner Dk
Patient Dk
Percentage Of Critical Lab Results
Percentage Of Duplicate Lab Orders
Percentage Of Lab Results Reported
Percentage Of Lab Retests
Percentage Of Lab Specimens Pending
Percentage Of Unverified Lab Results
Percentage Of Urgent Lab Orders
Performing Practitioner Dk
Point Of Care Location Dk
Provider Dk
Reporting Practitioner Dk
Specimen Dk
Turn Around Time For Lab Orders Reported
Turn Around Time For Urgent Lab Orders Reported

Relationship
Laboratory Performance Analysis_Ordering Practitioner_FK
Laboratory Performance Analysis_Performing Practitioner_FK
Laboratory Performance Analysis_Reporting Practitioner_FK
Laboratory Performance Analysis_Provider Dimension_FK
Laboratory Performance Analysis_Point Of Care Location Dimension_FK
Laboratory Performance Analysis_Lab Test Dimension_FK
Laboratory Performance Analysis_Specimen Dimension_FK
Laboratory Performance Analysis_Calendar Dimension_FK
Laboratory Performance Analysis_Patient Dimension_FK
Laboratory Performance Analysis_Encounter Dimension_FK

Primary Key
Laboratory Performance Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Daily Lab Order Volumes

Description	The Average number of lab orders by day regardless of status (e.g resulted, pending, ordered etc). 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 Lab Result Volumes

Description	The Average number of lab results completed and verified by day. 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 Lab Turnaround Times

Description	The Average turnaround times represents the intra lab activity from when the specimen is received to when the specimen test is resulted and reported. 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 Lab Turnaround Times For Urgent Orders

Description	Average turnaround times for orders identified as urgent.This measure represents the intra lab activity from when the specimen is received to when the specimen test is resulted and reported. 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

Blood Products To Patients Ratio

Description	The number of blood product units transferred to the number of recipients. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
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

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

Lab Test 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

Number Of Blood Product Units Issued

Description	The number of blood product units which have been issued by the blood bank 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 Blood Product Unit Transfused

Description	The number of blood product units which have an associated transfused status.
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 Critical Lab Results

Description	Number of Lab test results which have an associated critical status defined ie the result is abnormally high or low
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 Duplicate Lab Orders

Description	Number of lab tests which have been ordered more then once for the same Service Requested Start time and date.
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 Lab Orders

Description	Total Number of Lab Test Orders received for a given 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 Lab Results Reported

Description	Total Number of Lab tests that have been completed, verified and reported
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 Lab Retests

Description	Number of Lab Tests that need to be performed again due to a suspected error in the result.
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 Lab Test Days

Description	The number of days the lab tests were carried out and the laboratory is operational.
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 Pending Specimen for Lab Test

Description	Number of Lab tests (blood bank, lab, microbiology etc) ordered where no specimen has been received for them.
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 Unverified Lab Results

Description	Total Number of lab tests that have been completed but the results have not been verified and reported.
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 Urgent Lab Orders

Description	Number of Lab test orders identified as urgent.
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 Urgent Lab Results Reported

Description	Total Number of Lab Orders marked as urgent and prioritized, that have been completed,verfied and reported.
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

Ordering 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

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 Critical Lab Results

Description	The percentage of Lab test results which have an associated critical status defined ie the result is abnormally high or low. 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 Duplicate Lab Orders

Description	The percentage of lab tests which have been ordered more then once for the same Service Requested Start time and date. 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 Lab Results Reported

Description	The percentage of lab tests orders that have been completed ,verified and reported. 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 Lab Retests

Description	The percentage of Lab Tests performed again due to a suspected error in the result. 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 Lab Specimens Pending

Description	The percentage of Lab tests (blood bank, lab, microbiology etc) ordered where no specimen has been received for them. 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 Unverified Lab Results

Description	The percentage of lab tests orders that have been completed but the results have not been verified and reported. 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 Urgent Lab Orders

Description	The percentage of Lab test orders identified as urgent. 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

Performing 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

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

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

Reporting 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

Specimen 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Turn Around Time For Lab Orders Reported

Description	Sum of the time intervals in minutes for all the Lab orders completed , verified and reported.
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

Turn Around Time For Urgent Lab Orders Reported

Description	Sum of the time intervals in minutes for all the Lab orders marked urgent and prioritized that have been completed , verified and reported.
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

Laboratory Performance Analysis_Ordering Practitioner_FK

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

Laboratory Performance Analysis_Performing Practitioner_FK

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

Laboratory Performance Analysis_Reporting Practitioner_FK

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

Laboratory Performance Analysis_Provider Dimension_FK

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

Laboratory Performance Analysis_Point Of Care Location Dimension_FK

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

Laboratory Performance Analysis_Lab Test Dimension_FK

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

Laboratory Performance Analysis_Specimen Dimension_FK

Is Identifying Relationship	false
Child Table	Laboratory 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	Specimen Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Laboratory Performance Analysis_Calendar Dimension_FK

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

Laboratory Performance Analysis_Patient Dimension_FK

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

Laboratory Performance Analysis_Encounter Dimension_FK

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

Primary Key Details

Laboratory Performance Analysis PK

Key Attribute	Patient Dk
Key Attribute	Ordering Practitioner Dk
Key Attribute	Performing Practitioner Dk
Key Attribute	Reporting Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Lab Test Dk
Key Attribute	Calendar Dk
Key Attribute	Encounter Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model