Dimensional Warehouse Model Data Model

Entity

Entity NHSN Device Associated Infections Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to NHSN statistics around infections related to central lines, catheters and ventilators.

Attributes
Admission Ts
Asymptomatic Bacteremic Urinary Tract Infection (ABUTI) diagnosis Ts
Asymptomatic Bacteremic Urinary Tract Infection (ABUTI) Ind
Calendar Dk
Catheter Associated Urinary Tract Infection (CAUTI) diagnosis Ts
Catheter Associated Urinary Tract Infection (CAUTI) Ind
Central Line Associated Blood Stream Infection (CLABSI) diagnosis Ts
Central Line Associated Blood Stream Infection (CLABSI) Ind
Central Line Ind
Central Line Inserted Ts
Central Line Removed Ts
Clinically Defined Pneumonia (PNU1) diagnosis Ts
Clinically Defined Pneumonia (PNU1) Ind
Condition Dk
Discharge Ts
Geographic Area Dk
Inpatient Ind
Laboratory Confirmed Bloodstream Infections (LCBI) diagnosis Ts
Laboratory Confirmed Bloodstream Infections (LCBI) Ind
Laboratory Confirmed Bloodstream Infections Criterion (LCBI 1) 1 diagnosis Ts
Laboratory Confirmed Bloodstream Infections Criterion (LCBI 1) 1 Ind
Laboratory Confirmed Bloodstream Infections Criterion (LCBI 2) 2 diagnosis Ts
Laboratory Confirmed Bloodstream Infections Criterion (LCBI 2) 2 Ind
Laboratory Confirmed Bloodstream Infections Criterion (LCBI 3) 3 diagonsis Ts
Laboratory Confirmed Bloodstream Infections Criterion (LCBI 3) 3 Ind
Load Info Sk
Patient Dk
Permanent Central Line Associated Blood Stream Infection (PCLABSI) diagnosis Ts
Permanent Central Line Associated Blood Stream Infection (PCLABSI) Ind
Permanent Central Line Ind
Permanent Central Line Inserted Ts
Permanent Central Line Removed Ts
Pneumonia in Immunocompromised Patients (PNU3) diagnosis Ts
Pneumonia in Immunocompromised Patients (PNU3) Ind
Pneumonia With Specific Laboratory Findings (PNU2) diagnosis Ts
Pneumonia With Specific Laboratory Findings (PNU2) Ind
Practitioner Dk
Provider Dk
Symptomatic Urinary Tract Infection (SUTI) diagonsis Ts
Symptomatic Urinary Tract Infection (SUTI) Ind
Temporary Central Line Associated Blood Stream Infection (TCLABSI) diagnosis Ts
Temporary Central Line Associated Blood Stream Infection (TCLABSI) Ind
Temporary Central Line Ind
Temporary Central Line Inserted Ts
Temporary Central Line Removed Ts
Tenant Sk
Urinary Catheter Ind
Urinary Catheter Inserted Ts
Urinary Catheter Removed Ts
Urinary Tract Infection Diagnosis Ts
Urinary Tract Infection Ind
Ventilator Associated Pneumonia (VAP) Ind
Ventilator Associated Pneumonia (VAP) Ts
Ventilator Use Ended Ts
Ventilator Use Ind
Ventilator Use Started Ts

Relationship
NHSN Device Associated Infections Snapshot_Patient Dimension_FK
NHSN Device Associated Infections Snapshot_Provider Dimension_FK
NHSN Device Associated Infections Snapshot_Condition Dimension_FK
NHSN Device Associated Infections Snapshot_Geographic Area Dimension_FK
NHSN Device Associated Infections Snapshot_Practitioner Dimension_FK
NHSN Device Associated Infections Snapshot_Calendar Dimension_FK

Primary Key
NHSN Device Associated Infections Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Admission Ts

Description	The admit date/time. It is to be used if the event date/time is different than the admit date and time, i.e., a retroactive update. This field is also used to reflect the date/time of an out-patient/emergency patient registration.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Asymptomatic Bacteremic Urinary Tract Infection (ABUTI) diagnosis Ts

Description	Asymptomatic Bacteremic Urinary Tract Infection (ABUTI) diagnosis timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Asymptomatic Bacteremic Urinary Tract Infection (ABUTI) Ind

Description	Indicator to identify if the patient is diagnosed with an Asymptomatic Bacteremic Urinary Tract Infection (ABUTI).
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

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

Catheter Associated Urinary Tract Infection (CAUTI) diagnosis Ts

Description	Catheter Associated Urinary Tract Infection (CAUTI) diagnosis timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Catheter Associated Urinary Tract Infection (CAUTI) Ind

Description	Indicator to identify if the patient is diagnosed with an Catheter Associated Urinary Tract Infection (CAUTI).
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

Central Line Associated Blood Stream Infection (CLABSI) diagnosis Ts

Description	Central Line Associated Blood Stream Infection (CLABSI) timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Central Line Associated Blood Stream Infection (CLABSI) Ind

Description	Indicator to identify if the patient is diagnosed with an Central Line Associated Blood Stream Infection (CLABSI).
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

Central Line Ind

Description	Indicator to identify if the patient has or had a central line inserted.
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

Central Line Inserted Ts

Description	Central line inserted timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Central Line Removed Ts

Description	Central line removed timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Clinically Defined Pneumonia (PNU1) diagnosis Ts

Description	Clinically Defined Pneumonia (PNU1) timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Clinically Defined Pneumonia (PNU1) Ind

Description	Indicator to identify if the patient is diagnosed with an 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
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

Discharge Ts

Description	The discharge date/time. It is to be used if the event date/time is different than the discharge date and time, that is, a retroactive update. This field is also used to reflect the date/time of an outpatient/emergency patient discharge.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Geographic Area 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

Inpatient Ind

Description	An Indicator to Identify an Inpatient. Inpatient is a type of encounter in which the patient visits the healthcare facility and stays overnight and is assigned a bed. An encounter groups a number of healthcare events, typically commencing with an admission or transfer into the healthcare facility and ends with a discharge or transfer out.
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

Laboratory Confirmed Bloodstream Infections (LCBI) diagnosis Ts

Description	Laboratory Confirmed Bloodstream Infections (LCBI) timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Laboratory Confirmed Bloodstream Infections (LCBI) Ind

Description	Indicator to identify if the patient is diagnosed with an Laboratory Confirmed Bloodstream Infections (LCBI).
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

Laboratory Confirmed Bloodstream Infections Criterion (LCBI 1) 1 diagnosis Ts

Description	Laboratory Confirmed Bloodstream Infections Criterion (LCBI) 1 timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Laboratory Confirmed Bloodstream Infections Criterion (LCBI 1) 1 Ind

Description	Indicator to identify if the patient is diagnosed with an Laboratory Confirmed Bloodstream Infections Criterion (LCBI) 1.
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

Laboratory Confirmed Bloodstream Infections Criterion (LCBI 2) 2 diagnosis Ts

Description	Laboratory Confirmed Bloodstream Infections Criterion (LCBI) 2 timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Laboratory Confirmed Bloodstream Infections Criterion (LCBI 2) 2 Ind

Description	Indicator to identify if the patient is diagnosed with an Laboratory Confirmed Bloodstream Infections Criterion (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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Laboratory Confirmed Bloodstream Infections Criterion (LCBI 3) 3 diagonsis Ts

Description	Laboratory Confirmed Bloodstream Infections Criterion (LCBI) 3 timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Laboratory Confirmed Bloodstream Infections Criterion (LCBI 3) 3 Ind

Description	Indicator to identify if the patient is diagnosed with an Laboratory Confirmed Bloodstream Infections Criterion (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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
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

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

Permanent Central Line Associated Blood Stream Infection (PCLABSI) diagnosis Ts

Description	Permanent Central Line-Associated Blood Stream Infection (PCLABSI) timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Permanent Central Line Associated Blood Stream Infection (PCLABSI) Ind

Description	Indicator to identify if the patient is diagnosed with an Permanent Central Line-Associated Blood Stream Infection (PCLABSI).
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

Permanent Central Line Ind

Description	Indicator to identify if the patient has or had a permanent central line inserted.
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

Permanent Central Line Inserted Ts

Description	Permanent central line inserted timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Permanent Central Line Removed Ts

Description	Permanent central line removed timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pneumonia in Immunocompromised Patients (PNU3) diagnosis Ts

Description	Pneumonia in Immunocompromised Patients (PNU3) timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pneumonia in Immunocompromised Patients (PNU3) Ind

Description	Indicator to identify if the patient is diagnosed with an Pneumonia in Immunocompromised 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pneumonia With Specific Laboratory Findings (PNU2) diagnosis Ts

Description	Pneumonia With Specific Laboratory Findings (PNU2) timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pneumonia With Specific Laboratory Findings (PNU2) Ind

Description	Indicator to identify if the patient is diagnosed with an 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
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

Symptomatic Urinary Tract Infection (SUTI) diagonsis Ts

Description	Symptomatic Urinary Tract Infection (SUTI) timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Symptomatic Urinary Tract Infection (SUTI) Ind

Description	Indicator to identify if the patient is diagnosed with an Symptomatic Urinary Tract Infection (SUTI).
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

Temporary Central Line Associated Blood Stream Infection (TCLABSI) diagnosis Ts

Description	Temporary Central Line-Associated Blood Stream Infection (TCLABSI) timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Temporary Central Line Associated Blood Stream Infection (TCLABSI) Ind

Description	Indicator to identify if the patient is diagnosed with an Temporary Central Line-Associated Blood Stream Infection (TCLABSI).
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

Temporary Central Line Ind

Description	Indicator to identify if the patient has or had a temporary central line inserted.
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

Temporary Central Line Inserted Ts

Description	Temporary central line inserted timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Temporary Central Line Removed Ts

Description	Temporary central line removed timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Urinary Catheter Ind

Description	Indicator to identify if the patient has/had a urinary catheter.
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

Urinary Catheter Inserted Ts

Description	Urinary Catheter inserted timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Urinary Catheter Removed Ts

Description	Urinary Catheter removed timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Urinary Tract Infection Diagnosis Ts

Description	Urinary Tract Infection (UTI) diagnosis timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Urinary Tract Infection Ind

Description	Indicator to identify if the patient is diagnosed with a Urinary Tract Infection (UTI).
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

Ventilator Associated Pneumonia (VAP) Ind

Description	Indicator to identify if the patient is diagnosed with an Ventilator Associated Pneumonia (VAP).
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

Ventilator Associated Pneumonia (VAP) Ts

Description	Ventilator Associated Pneumonia (VAP) Timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ventilator Use Ended Ts

Description	Timestamp representing when the patient stopped using a ventilator.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ventilator Use Ind

Description	Indicator to identify if the patient used a ventilator.
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

Ventilator Use Started Ts

Description	Timestamp representing when the patient started using a ventilator.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

NHSN Device Associated Infections Snapshot_Patient Dimension_FK

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

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

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

NHSN Device Associated Infections Snapshot_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Device Associated Infections Snapshot
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	Geographic Area 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 Snapshot_Practitioner Dimension_FK

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

NHSN Device Associated Infections Snapshot_Calendar Dimension_FK

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

Primary Key Details

NHSN Device Associated Infections Snapshot PK

Key Attribute	Patient Dk
Key Attribute	Provider Dk
Key Attribute	Calendar Dk
Key Attribute	Condition Dk
Key Attribute	Geographic Area Dk
Key Attribute	Practitioner Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model