Dimensional Warehouse Model Data Model

Entity

Entity NHSN Device Associated Infections

Description

A set of measures based on NHSN's defined dataset for device associated infections. The dataset focuses on multiple devices such as: Central Lines, Ventilators and Catheters.

Attributes
Calendar Dk
Central Line Associated Blood Stream Infections (CLABSI) Rate
Central Line Utilization Ratio
Medical Equipment Dk
Number of Asymptomatic Bacteremic Urinary Tract Infection (ABUTI)
Number of Catheter Associated Urinary Tract Infection (CAUTI)
Number of Central Line Associated Blood Stream Infection (CLABSI)
Number of Central Line Days
Number of Clinically Defined Pneumonia (PNU1)
Number of Laboratory Confirmed Bloodstream Infections (LCBI)
Number of Laboratory Confirmed Bloodstream Infections Criterion (LCBI 1)
Number of Laboratory Confirmed Bloodstream Infections Criterion (LCBI 2)
Number of Laboratory Confirmed Bloodstream Infections Criterion (LCBI 3)
Number of Patient Days
Number of Permanent Central Line-Associated Blood Stream Infection (PCLABSI)
Number of Permanent Central Line Days
Number of Pneumonia in Immunocompromised Patients (PNU3)
Number of Pneumonia With Specific Laboratory Findings (PNU2)
Number of Symptomatic Urinary Tract Infection (SUTI)
Number of Temporary Central Line-Associated Blood Stream Infection (TCLABSI)
Number of Temporary Central Line Days
Number of Urinary Catheter Days
Number of Urinary Tract Infections
Number of Ventilator Associated Pneumonia (VAP)
Number of Ventilator Days
Organization Dk
Patient Dk
Percentage of Asymptomatic Bacteremic Urinary Tract Infections (ABUTI)
Percentage of Clinically Defined Pneumonia (PNU1)
Percentage of Laboratory Confirmed Bloodstream Infection (LCBI 1) Criterion 1
Percentage of Laboratory Confirmed Bloodstream Infection (LCBI 2) Criterion 2
Percentage of Laboratory Confirmed Bloodstream Infection (LCBI 3) Criterion 3
Percentage of Pneumonia in Immunocompromised Patients (PNU3)
Percentage of Pneumonia With Specific Laboratory Findings (PNU2)
Percentage of Symptomatic Urinary Tract Infection (SUTI)
Permanent Central Line Associated Blood Stream Infections (PCLABSI) Rate
Permanent Central Line Utilization Ratio
Point Of Care Location Dk
Provider Dk
Report Catalog Dk
Temporary Central Line Associated Blood Stream Infections (TCLABSI) Rate
Temporary Central Line Utilization Ratio
Urinary Catheter Associated Urinary Tract Infection (UTI) Rate
Urinary Catheter Utilization Ratio
Ventilator-associated PNEU Rate
Ventilator utilization Ratio

Relationship
NHSN Device Associated Infections_Calendar Dimension_FK
NHSN Device Associated Infections_Report Dimension_FK
NHSN Device Associated Infections_Point Of Care Location Dimension_FK
NHSN Device Associated Infections_Organization Dimension_FK
NHSN Device Associated Infections_Patient Dimension_FK
NHSN Device Associated Infections_Provider Dimension_FK
NHSN Device Associated Infections_Medical Equipment Dimension_FK

Primary Key
NHSN Device Associated Infections PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

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

Central Line Associated Blood Stream Infections (CLABSI) Rate

Description	The proportion of Central Line Associated Blood Stream Infections (CLABSI) per 1000 Central Line Days. Formula: [(A/B)*1000] (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

Central Line Utilization Ratio

Description	The number of central line days compared to the total number of days that patients are in the location during the selected time period. 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

Medical Equipment 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 Asymptomatic Bacteremic Urinary Tract Infection (ABUTI)

Description	Number of Asymptomatic Bacteremic Urinary Tract Infections (ABUTI). The number of patients diagnosed with a urinary tract infection (UTI) with or without an indwelling urinary catheter and have no signs or symptoms.
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 Catheter Associated Urinary Tract Infection (CAUTI)

Description	Number of Catheter Associated Urinary Tract Infections (CAUTI). A CAUTI is a urinary tract infection where an indwelling urinary catheter was in place for 2 calendar days on the date of event, with the day of device placement being Day 1, and an indwelling urinary catheter was in place on the date of event or the day before. If an indwelling urinary catheter was in place for 2 calendar days and then removed, the UTI criteria must be fully met on the day of discontinuation or the next day. The date of event is defined as the date when the last element used to meet the UTI infection criterion 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 Central Line Associated Blood Stream Infection (CLABSI)

Description	Number of Central Line Associated Blood Stream Infections (CLABSI). These are laboratory-confirmed bloodstream infection (LCBI) where a central line (CL) or an umbilical catheter (UC) was in place for 2 calendar days on the date of event, with day of device placement being Day 1, and a CL or UC was in place on the date of event or the day before. The date of event is defined as the date when the last element used to meet the laboratory-confirmed bloodstream infection (LCBI) criterion 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 Central Line Days

Description	The total number of days exposed to the central line by all of the patients in the selected population during the selected time period. Example: Five patients on the first day of the month had one or more central lines in place; five on day 2; two on day 3. Adding the number of patients with central lines on days 1 through 3, we would have 5+5+2 = 12 central line-days for the 3 days. A central line is an intravascular catheter that terminates at or close to the heart or in one of the great vessels which is used for infusion, withdrawal of blood, or hemodynamic monitoring.
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 Clinically Defined Pneumonia (PNU1)

Description	Number of clinically-defined pneumonia (PNU1). For any ventilated patient, at least one of the following: • Fever (38°C or 100.4°F) • Leukopenia (4000 WBC/mm3) or leukocytosis (=12,000 WBC/mm3) • For adults =70 years old, altered mental status with no other recognized cause and at least two of the following: • New onset of purulent sputum, or change in character of sputum, or increased respiratory secretions, or increased suctioning requirements • New onset or worsening cough, or dyspnea, or tachypnea • Rales or bronchial breath sounds • Worsening gas exchange (e.g., O2 desaturations (e.g., PaO2/FiO2 =240)7, increased oxygen requirements, or increased ventilator demand)
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 Laboratory Confirmed Bloodstream Infections (LCBI)

Description	Number of Laboratory-confirmed bloodstream infections (LCBI) that are not secondary to an infection at another body site.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Laboratory Confirmed Bloodstream Infections Criterion (LCBI 1)

Description	Number of Laboratory Confirmed Bloodstream Infections (LCBI 1). Patient has a recognized pathogen cultured from one or more blood cultures and organism cultured from blood is not related to an infection at another body site.
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 Laboratory Confirmed Bloodstream Infections Criterion (LCBI 2)

Description	Number of Laboratory Confirmed Bloodstream Infections (LCBI) 2. Patient has at least one of the following signs or symptoms: fever (38C), chills, or hypotension and positive laboratory results are not related to an infection at another body site and the same common commensal (i.e., diphtheroids [Corynebacterium spp. not C. diphtheriae], Bacillus spp. [not B. anthracis], Propionibacterium spp., coagulase-negative staphylococci [including S. epidermidis], viridans group streptococci, Aerococcus spp., and Micrococcus spp.) is cultured from two or more blood cultures drawn on separate occasions. Criterion elements must occur within a timeframe that does not exceed a gap of 1 calendar day between two adjacent elements.
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 Laboratory Confirmed Bloodstream Infections Criterion (LCBI 3)

Description	Number of Laboratory Confirmed Bloodstream Infections (LCBI) 3. Patient = 1 year of age has at least one of the following signs or symptoms: fever (38C core), hypothermia (36C core), apnea, or bradycardia and positive laboratory results are not related to an infection at another body site and the same common commensal (i.e., diphtheroids [Corynebacterium spp. not C. diphtheriae], Bacillus spp. [not B. anthracis], Propionibacterium spp., coagulase-negative staphylococci [including S. epidermidis], viridans group streptococci, Aerococcus spp., Micrococcus spp.) is cultured from two or more blood cultures drawn on the same or consecutive days and separate occasions. Criterion elements must occur within a timeframe that does not exceed a gap of 1 calendar day between two adjacent elements.
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 total number of days that patients are in the location during the selected time period. Example: Ten patients were in the unit on the first day of the month; 12 on day 2; 11 on day 3. If we counted the patients in the unit from days 1 through 3, we would add 10 + 12 + 11 for a total of 33 patient-days for the the three 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 Permanent Central Line-Associated Blood Stream Infection (PCLABSI)

Description	Number of Permanent Central Line-Associated Blood Stream Infections (PCLABSI). A permanent central line is an intravascular tunneled catheter (including certain dialysis catheters) or implanted catheter (including ports) that terminates at or close to the heart or in one of the great vessels and is used for infusion, withdrawal of blood, or hemodynamic monitoring.
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 Permanent Central Line Days

Description	The total number of days exposed to the permanent central line by all of the patients in the selected population during the selected time period. Example: Five patients on the first day of the month had one or more permanent central lines in place; five on day 2; two on day 3. Adding the number of patients with central lines on days 1 through 3, we would have 5+5+2 = 12 permanent central line-days for the 3 days. A permanent central line is an intravascular tunneled catheter (including certain dialysis catheters) or implanted catheter (including ports) that terminates at or close to the heart or in one of the great vessels and is used for infusion, withdrawal of blood, or hemodynamic monitoring.
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 Pneumonia in Immunocompromised Patients (PNU3)

Description	Number of pneumonia in immunocompromised ventilated patients (PNU3). An immunocompromised patient's immune system is weakened or absent which means their ability to battle infections is reduced.
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 Pneumonia With Specific Laboratory Findings (PNU2)

Description	Number of pneumonia with specific laboratory findings (PNU2). This pneumonia in ventilated patients is linked to common bacteria, filamentous fungal pathogens, virus and legionella and other specific laboratory findings.
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 Symptomatic Urinary Tract Infection (SUTI)

Description	Number of Symptomatic Urinary Tract Infection (SUTI). A Urinary Tract Infection (UTI) is an infection that affects part of the urinary tract. Symptomatic means the person may experience a number of signs and symptoms such as: fever, urgency; frequency; dysuria; suprapubic tenderness; costovertebral angle pain or tenderness.
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 Temporary Central Line-Associated Blood Stream Infection (TCLABSI)

Description	Number of Temporary Central Line-Associated Blood Stream Infections (TCLABSI). A temporary central line is non-tunneled, non-implanted intravascular catheter that terminates at or close to the heart or in one of the great vessels which is used for infusion, withdrawal of blood, or hemodynamic monitoring.
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 Temporary Central Line Days

Description	The total number of days exposed to the temporary central line by all of the patients in the selected population during the selected time period. Example: Five patients on the first day of the month had one or more temporary central lines in place; five on day 2; two on day 3. Adding the number of patients with central lines on days 1 through 3, we would have 5+5+2 = 12 temporary central line-days for the 3 days. A temporary central line is non-tunneled, non-implanted intravascular catheter catheter that terminates at or close to the heart or in one of the great vessels which is used for infusion, withdrawal of blood, or hemodynamic monitoring.
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 Urinary Catheter Days

Description	The total number of days exposed to the indwelling urinary catheter by all of the patients in the selected population during the selected time period. An indwelling urinary catheter is a drainage tube that is inserted into the urinary bladder through the urethra, is left in place, and is connected to a drainage bag. These devices are also called Foley catheters. Condom or straight in-and-out catheters are not included nor are nephrostomy tubes or suprapubic catheters unless a Foley catheter is also present. Example: Five patients on the first day of the month had one or more indwelling urinary catheters in place; five on day 2; two on day 3. Adding the number of patients with indwelling urinary catheters on days 1 through 3, we would have 5+5+2 = 12 urinary catheter days for the 3 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 Urinary Tract Infections

Description	Urinary tract infection (UTI) is an infection that affects part of the urinary tract.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Ventilator Associated Pneumonia (VAP)

Description	Number of Ventilator Associated Pneumonia (VAP). A pneumonia where the patient is on mechanical ventilation for 2 calendar days on the date of event, with day of ventilator placement being Day 1, and the ventilator was in place on the date of event or the day before. If the patient is admitted or transferred into a facility on a ventilator, the day of admission is considered Day1. The date of event is defined as the date when the last element used to meet the Pneumonia (PNEU) criteria 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 Ventilator Days

Description	The total number of days exposed to a ventilator by all of the patients in the selected population during the selected time period. A ventilator is a device to assist or control respiration continuously, inclusive of the weaning period, through a tracheostomy or by endotracheal intubation. Example: Five patients on the first day of the month are ventilated; five on day 2; two on day 3. Adding the number of ventilated patients on days 1 through 3, we would have 5+5+2 = 12 ventilated patients for the 3 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

Organization 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 Asymptomatic Bacteremic Urinary Tract Infections (ABUTI)

Description	The count of patients with an Asymptomatic Bacteremic Urinary Tract Infection (ABUTI) expressed as a percentage of the number of Urinary Tract Infections. 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 Clinically Defined Pneumonia (PNU1)

Description	The count of ventilated patients for whom clinically defined pneumonia (PNU1) has been made expressed as a percentage of the Ventilator Associated Pneumoniae. 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 Laboratory Confirmed Bloodstream Infection (LCBI 1) Criterion 1

Description	The count of patients with a Laboratory Confirmed Bloodstream Infection (LCBI) Criterion 1 expressed as a percentage of Laboratory Confirmed Bloodstream Infections. 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 Laboratory Confirmed Bloodstream Infection (LCBI 2) Criterion 2

Description	The count of patients with a Laboratory Confirmed Bloodstream Infection (LCBI) Criterion 2 expressed as a percentage of Laboratory Confirmed Bloodstream Infections. 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 Laboratory Confirmed Bloodstream Infection (LCBI 3) Criterion 3

Description	The count of patients with a Laboratory Confirmed Bloodstream Infection (LCBI) Criterion 3 expressed as a percentage of Laboratory Confirmed Bloodstream Infections. 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 Pneumonia in Immunocompromised Patients (PNU3)

Description	The count of ventilated immunocompromised patients for whom pneumonia (PNU3) has been made expressed as a percentage of the Ventilator Associated Pneumoniae 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 Pneumonia With Specific Laboratory Findings (PNU2)

Description	The count of ventilated patients for whom pneumonia with specific laboratory findings (PNU2) has been made expressed as a percentage of the Ventilator Associated Pneumoniae. 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 Symptomatic Urinary Tract Infection (SUTI)

Description	The count of patients with a Symptomatic Urinary Tract Infection (SUTI) expressed as a percentage of the number of Urinary Tract Infections. 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

Permanent Central Line Associated Blood Stream Infections (PCLABSI) Rate

Description	The proportion of Permanent Central Line Associated Blood Stream Infections (PCLABSI) per 1000 Central Line Days. Formula: [(A/B)*1000] (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

Permanent Central Line Utilization Ratio

Description	The number of Permanent Central Line Days compared to the total number of days that patients are in the location during the selected time period. 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

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

Report Catalog 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

Temporary Central Line Associated Blood Stream Infections (TCLABSI) Rate

Description	The proportion of Temporary Central Line Associated Blood Stream Infections (TCLABSI) per 1000 Central Line Days. Formula: [(A/B)*1000] (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

Temporary Central Line Utilization Ratio

Description	The number of Temporary Central Line Days compared to the total number of days that patients are in the location during the selected time period. 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

Urinary Catheter Associated Urinary Tract Infection (UTI) Rate

Description	The proportion of Urinary Catheter Associated Infections (UTIs) per 1000 Urinary Catheter Days. Formula: [(A/B)*1000] (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

Urinary Catheter Utilization Ratio

Description	The number of Urinary Catheter Days compared to the total number of days that patients are in the location during the selected time period. 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

Ventilator-associated PNEU Rate

Description	The proportion of Ventilator Associated Pneumonia per Number Of Ventilator Days. Formula: [(A/B)*1000] (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

Ventilator utilization Ratio

Description	The number of Ventilator Days compared to the total number of days that patients are in the location during the selected time period. 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

Relationship Details

NHSN Device Associated Infections_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Device Associated Infections
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

NHSN Device Associated Infections_Report Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Device Associated Infections
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	Report Catalog Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHSN Device Associated Infections_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Device Associated Infections
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

NHSN Device Associated Infections_Organization Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Device Associated Infections
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	Organization Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHSN Device Associated Infections_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Device Associated Infections
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

NHSN Device Associated Infections_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Device Associated Infections
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

NHSN Device Associated Infections_Medical Equipment Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Device Associated Infections
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	Medical Equipment 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

NHSN Device Associated Infections PK

Key Attribute	Organization Dk
Key Attribute	Patient Dk
Key Attribute	Provider Dk
Key Attribute	Medical Equipment Dk
Key Attribute	Report Catalog Dk
Key Attribute	Calendar Dk
Key Attribute	Point Of Care Location Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model