Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Patient Safety Analysis

Description

Pharmacists and infection preventionists review historical lab data in order to monitor organism and resistance trends within the facility. This data from these reports can be used to determine metrics for stewardship and targeted prevention activities, provide information for internal administrative reporting, and monitor organism trends in the patient population.

Attributes

Acquisition Rt

Antibiotic Minutes Prior To Incision

Calendar Dk

Encounter Dk

Hours Prior To Specimen Collection

Lab Result Dk

Lab Test Dk

Length Of Stay

Medical Errors Per 1000 Admissions

Medical Errors Per 1000 Procedures

Medical Errors Per Licensed Bed

Medication Dk

Mortalities Attributable To Patient Safety Incidents Per 1000 Admissions

Number Of Admissions

Number Of Licensed Beds

Number Of Medical Errors

Number Of Mortalities Attributable To Patient Safety Incidents

Number Of Patient Safety Incidents

Number Of Procedures

Number Of Procedures Performed

On Time Antibiotic Administration Ind

Organism Dk

Organism Per Test Per Medication Frequency

Organism Rate Per 100 Patient Days

Pathway Dk

Patient Dk

Patient Safety Incidents Per 1000 Admissions

Patient Safety Incidents Per 1000 Procedures

Patient Safety Incidents Per Licensed Bed

Percent Compliant

Percent Positive Tests

Percent Susceptible Isolates

Point Of Care Location Dk

Practitioner Dk

Provider Dk

Service Line Dk

Specimen Dk

Total Number Of Isolates

Total Number Of Tests

Relationship

Patient Safety Analysis_Patient_FK

Patient Safety Analysis_Provider_FK

Patient Safety Analysis_Encounter_FK

Patient Safety Analysis_Practitioner_FK

Patient Safety Analysis_Calendar_FK

Patient Safety Analysis_Point Of Care Location_FK

Patient Safety Analysis_Lab Test_FK

Patient Safety Analysis_Specimen_FK

Patient Safety Analysis_Medication_FK

Patient Safety Analysis_Organism_FK

Patient Safety Analysis_Lab Result_FK

Patient Safety Analysis_Pathway Dimension_FK

Patient Safety Analysis_Service Line Dimension_FK

Primary Key

Patient Safety Analysis PK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Acquisition Rt

Description	(Number of isolates collected greater than X number of hours i.e. acquired/Total number of patient days)*1000. The value for X hours needs to be defined or user entered.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Antibiotic Minutes Prior To Incision

Description	The number of minutes elapsed between the administration of the pre-surgery antibiotic and the time of the first incision.
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

---

 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

---

 Hours Prior To Specimen Collection

Description	Specimen collection date time - Admit date time, in hours.
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

---

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

---

 Length Of Stay

Description	Number of full days patient has stayed at the location. Formula: (Discharge Dt - Admit Dt +1)
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

---

 Medical Errors Per 1000 Admissions

Description	The number of medical errors per 1000 admissions. Formula: [(A/B)*1000] (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

---

 Medical Errors Per 1000 Procedures

Description	The number of medical errors per 1000 procedures. Formula: [(A/B)*1000] (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

---

 Medical Errors Per Licensed Bed

Description	The number of medical errors per licensed bed. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Medication 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

---

 Mortalities Attributable To Patient Safety Incidents Per 1000 Admissions

Description	Mortalities attributable to patient safety incidents per 1000 admissions. Formula: [(A/B)*1000] (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 Admissions

Description	The total number of patient admissions.
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 Licensed Beds

Description	The number of beds that are officially licensed in a medical 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 Medical Errors

Description	Number of medical errors during the measurement 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 Mortalities Attributable To Patient Safety Incidents

Description	Number of mortalities that are attributable to patient safety incidents.
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 Safety Incidents

Description	Number of patient safety incidents that occurred.
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 Procedures

Description	Number of procedures performed.
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 Procedures Performed

Description	The count of the number of surgical procedures performed.
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

---

 On Time Antibiotic Administration Ind

Description	A flag that indicates that the antibiotic administration prior to surgery was compliant with the appropriate national standard for that Surgical Procedure.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organism 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

---

 Organism Per Test Per Medication Frequency

Description	The number of organisms found per test and medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Organism Rate Per 100 Patient Days

Description	(Sum(Organisms Isolated)/Sum(Patient Days))*1000
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Pathway 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

---

 Patient Safety Incidents Per 1000 Admissions

Description	The number of patient safety incidents per 1000 admissions. Formula: [(A/B)*1000] (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

---

 Patient Safety Incidents Per 1000 Procedures

Description	Patient safety incidents per 1000 procedures. Formula: [(A/B)*1000] (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

---

 Patient Safety Incidents Per Licensed Bed

Description	Patient safety incidents per licensed bed. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Percent Compliant

Description	(Number of tests collected within X hours/Number of admissions into unit)*100
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Percent Positive Tests

Description	(Sum(Positive Tests)/Sum(Tests Performed))*100
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

---

 Percent Susceptible Isolates

Description	(Sum(Susceptible Isolates)/ Sum(Isolates) )*100
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
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 Line 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	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Total Number Of Isolates

Description	The number of organism colonies isolated from a Specimen for drug susceptibility study.
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

---

 Total Number Of Tests

Description	The total number of tests performed.
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

 Patient Safety Analysis_Patient_FK

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

---

 Patient Safety Analysis_Provider_FK

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

---

 Patient Safety Analysis_Encounter_FK

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

---

 Patient Safety Analysis_Practitioner_FK

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

---

 Patient Safety Analysis_Calendar_FK

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

---

 Patient Safety Analysis_Point Of Care Location_FK

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

---

 Patient Safety Analysis_Lab Test_FK

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

---

 Patient Safety Analysis_Specimen_FK

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

---

 Patient Safety Analysis_Medication_FK

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

---

 Patient Safety Analysis_Organism_FK

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

---

 Patient Safety Analysis_Lab Result_FK

Is Identifying Relationship	true
Child Table	Patient Safety 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 Result Fact
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Patient Safety Analysis_Pathway Dimension_FK

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

---

 Patient Safety Analysis_Service Line Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Safety 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 Line 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

 Patient Safety Analysis PK

Key Attribute	Patient Dk
Key Attribute	Encounter Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Practitioner Dk
Key Attribute	Pathway Dk
Key Attribute	Lab Test Dk
Key Attribute	Specimen Dk
Key Attribute	Medication Dk
Key Attribute	Organism Dk
Key Attribute	Lab Result Dk
Key Attribute	Calendar Dk
Key Attribute	Service Line Dk
Key Attribute	Provider Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model