Dimensional Warehouse Model Data Model

Entity

Entity NHSN Dialysis Events Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to NHSN Dialysis Events - IV Antimicrobial Starts, Positive Blood Cultures and Pus, Redness or Increased Swelling At Vascular Access Sites.

Attributes
Button Hole Cannulation Ind
Calendar Dk
Diagnosis Code Dk
Encounter Dk
Hemodialysis Fistula Discontinued Ts
Hemodialysis Fitsula Creation Ts
Hemodialysis Fitsula Ind
Hemodialysis Graft Creation Ts
Hemodialysis Graft Discontinued Ts
Hemodialysis Graft Ind
Hemodialysis Ind
Hemodialysis Non Tunneled Central Line Ind
Hemodialysis Non Tunneled Central Line Removal Ts
Hemodialysis Other Access Device Ind
Hemodialysis Other Access Device insertion Ts
Hemodialysis Other Access Device Removal Ts
Hemodialysis Ts
Hemodialysis Tunneled Central Line Ind
Hemodialysis Tunneled Central Line Insertion Ts
IV Antimicrobial Ind
IV Antimicrobial Ts
Load Info Sk
Medication Dk
Non Tunneled Central Line Insertion Ts
Outpatient Ind
Patient Dk
Point Of Care Location Dk
Positive Blood Culture Contamination Source Ind
Positive Blood Culture Cultured Source Ind
Positive Blood Culture Ind
Positive Blood Culture Ts
Positive Blood Culture Uncertain Source Ind
Positive Blood Culture Vascular Source Ind
Positive Blood Non Culture Cultured Source Ind
Practitioner Dk
Procedure Code Dk
Provider Dk
Pus, Redness or Increased Swelling At Vascular Access Site Ind
Pus, Redness or Increased Swelling At Vascular Access Site Ts
Tenant Sk
Transient Ind
Tunneled Central Line Removal Ts

Relationship
NHSN Dialysis Events Snapshot_Patient Dimension_FK
NHSN Dialysis Events Snapshot_Practitioner Dimension_FK
NHSN Dialysis Events Snapshot_Encounter Dimension_FK
NHSN Dialysis Events Snapshot_Diagnosis Code Dimension_FK
NHSN Dialysis Events Snapshot_Point Of Care Location Dimension_FK
NHSN Dialysis Events Snapshot_Calendar Dimension_FK
NHSN Dialysis Events Snapshot_Medication Dimension_FK
NHSN Dialysis Events Snapshot_Procedure Code Dimension_FK
NHSN Dialysis Events Snapshot_Provider Dimension_FK

Primary Key
NHSN Dialysis Events Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Button Hole Cannulation Ind

Description	Indicator that identifies patients who use the button hole technique to access their fistula
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

Diagnosis Code Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

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

Hemodialysis Fistula Discontinued Ts

Description	Timestamp representing when the fistula was discontinued for use.
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

Hemodialysis Fitsula Creation Ts

Description	Timestamp representing when the fistula was created.
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

Hemodialysis Fitsula Ind

Description	Indicator that identifies patients with a fistula which is a joined vein and artery making the blood vessel larger and stronger.
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

Hemodialysis Graft Creation Ts

Description	Timestamp representing when the graft was created.
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

Hemodialysis Graft Discontinued Ts

Description	Timestamp representing when the graft was discontinued for use.
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

Hemodialysis Graft Ind

Description	Indicator that identifies patients with a graft which is a connected vein to an artery using a tube.
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

Hemodialysis Ind

Description	Indicator that identifies patients who received hemodialysis.
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

Hemodialysis Non Tunneled Central Line Ind

Description	Indicator that identifies patients with a non tunneled intravascular catheter that is fixed in place at the point of insertion and travels directly from the skin entry site to a vein and terminates close to the heart or one of the great vessels which is used for hemodialysis.
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

Hemodialysis Non Tunneled Central Line Removal Ts

Description	Timestamp representing when the non tunneled central line was removed.
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

Hemodialysis Other Access Device Ind

Description	Indicator that identifies patients with another access device used for hemodialysis e.g hybrid access. This excludes fistulas, grafts, tunneled and non-tunneled central lines.
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

Hemodialysis Other Access Device insertion Ts

Description	Timestamp representing when the other access device used for hemodialysis was created.
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

Hemodialysis Other Access Device Removal Ts

Description	Timestamp representing when the other access device used for hemodialysis was removed
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

Hemodialysis Ts

Description	Timestamp representing when the patient received hemodialysis.
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

Hemodialysis Tunneled Central Line Ind

Description	Indicator that identifies patients with a central venous catheter that travels a distance under the skin from the point of insertion before terminating at or close to the heart or one of the great vessels which is used for hemodialysis.
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

Hemodialysis Tunneled Central Line Insertion Ts

Description	Timestamp representing when the tunneled central line was inserted.
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

IV Antimicrobial Ind

Description	Indicator that identifies patients who were administered intravenous antibiotics or antifungals.
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

IV Antimicrobial Ts

Description	Timestamp representing when the patient received intravenous antibiotics or antifungals.
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

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

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

Non Tunneled Central Line Insertion Ts

Description	Timestamp representing when the non tunneled central line was inserted.
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

Outpatient Ind

Description	An indicator to identify an Outpatient. Outpatient is a type of encounter that takes place when the patient visits the healthcare facility but does not stay overnight and it is not assigned a bed.
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

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

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

Positive Blood Culture Contamination Source Ind

Description	Indicator that identifies patients where it is thought that the isolated organism found in the positive blood culture is a contaminant. Contamination is considered more likely if the organism is a common commensal and is isolated from only one blood culture.
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

Positive Blood Culture Cultured Source Ind

Description	Indicator that identifies patients where the suscpected source of their positive blood cultures(s) is thought to be a source other than vascular access. For example: A culture from another body site showing the same organism found in the blood culture.
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

Positive Blood Culture Ind

Description	Indicator that indentifies patients who have positive blood cultures.
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

Positive Blood Culture Ts

Description	Timestamp representing when the patient's blood specimen was collected, not the date the laboratory reported the result.
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

Positive Blood Culture Uncertain Source Ind

Description	Indicator that identifies patients where the suscpected source of their positive blood cultures(s) is uncertain.
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

Positive Blood Culture Vascular Source Ind

Description	Indicator that identifies patients whose vascular access is the suspected source of their positive blood culture(s).
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

Positive Blood Non Culture Cultured Source Ind

Description	Indicator that identifies patients where there is clinical evidence of infection at another site which is thought to be the source of the positive blood culture but the site was not sampled for culture.
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

Procedure Code Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

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

Pus, Redness or Increased Swelling At Vascular Access Site Ind

Description	Indicator that identifies patients who experience one or more symptoms of pus, greater than expected redness or greater than expected swelling at any vascular access site, regardless of whether the patient received treatment.
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

Pus, Redness or Increased Swelling At Vascular Access Site Ts

Description	Timestamp representing when the diagnosis of pus, greater than expected redness or greater than expected swelling at any vascular access site was determined.
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

Transient Ind

Description	A patient who was temporarily admitted for treatment for a short time (fewer than 30 days or 13 treatments) due to vacation, emergency, or other short-term displacement.
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

Tunneled Central Line Removal Ts

Description	Timestamp representing when the tunneled central line was removed.
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 Dialysis Events Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Dialysis Events 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 Dialysis Events Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Dialysis Events 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 Dialysis Events Snapshot_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Dialysis Events 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	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHSN Dialysis Events Snapshot_Diagnosis Code Dimension_FK

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

NHSN Dialysis Events Snapshot_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Dialysis Events 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	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 Dialysis Events Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Dialysis Events 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

NHSN Dialysis Events Snapshot_Medication Dimension_FK

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

NHSN Dialysis Events Snapshot_Procedure Code Dimension_FK

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

NHSN Dialysis Events Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Dialysis Events 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

Primary Key Details

NHSN Dialysis Events Snapshot PK

Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Encounter Dk
Key Attribute	Provider Dk
Key Attribute	Diagnosis Code Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Calendar Dk
Key Attribute	Medication Dk
Key Attribute	Procedure Code Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model