Dimensional Warehouse Model Data Model

Entity

Entity NHSN Dialysis Events

Description

A set of measures based on NHSN's defined dataset for dialysis related events. The dataset focuses on multiple events types such as:
IV antimicrobial start; positive blood culture and pus, redness, or increased swelling at the vascular access site.

Attributes
Calendar Dk
Diagnosis Code Dk
Encounter Dk
IV Antimicrobial Start Rate
Medication Dk
Number of Access Related Blood (ARB) Stream Infection Events
Number of Access-Related Bloodstream (ARB) infection Dialysis Events
Number of Blood Stream Infections (BSI) Events
Number of Contamination Related Positive Blood Culture Dialysis Events
Number of Cultured Source Related Positive Blood Culture Dialysis Events
Number of Dialysis Events
Number of Hemodialysis Patients
Number of Hemodialysis Patients With A Fistula
Number of Hemodialysis Patients With A Graft
Number of Hemodialysis Patients With A Non Tunneled Central Line
Number of Hemodialysis Patients With Another Access Device
Number of Hemodialysis Patients With A Tunneled Central Line
Number of Hemodialysis Patients With Fistula Who Receive Button Hole Cannulation
Number of IV Antimicrobial Start Dialysis Events
Number of Local Access Site Infection (LASI) Events
Number of Non Cultured Source Related Positive Blood Culture Dialysis Events
Number of Positive Blood Culture Dialysis Events
Number of Pus, Redness or Increased Swelling At Vascular Access Site Events
Number of Uncertain Positive Blood Culture Dialysis Events
Number of Vascular Access Infection (VAI) Dialysis Events
Number of Vascular Access Related Positive Blood Culture Dialysis Events
Number of Vascular Access Site Dialysis Events
Organization Dk
Patient Dk
Percentage of Contamination Related Positive Blood Culture Dialysis Events
Percentage of Cultured Source Related Positive Blood Culture Dialysis Events
Percentage of Non Cultured Source Related Positive Blood Culture Dialysis Events
Percentage of Uncertain Source Related Positive Blood Culture Dialysis Events
Percentage of Vascular Access Related Positive Blood Culture Dialysis Events
Point Of Care Location Dk
Positive Blood Culture Rate
Practitioner Dk
Procedure Code Dk
Provider Dk
Pus, Redness or Increased Swelling At Vascular Access Site Events Rate
Report Catalog Dk

Relationship
NHSN Dialysis Events_Practitioner Dimension_FK
NHSN Dialysis Events_Medication Dimension_FK
NHSN Dialysis Events_Calendar Dimension_FK
NHSN Dialysis Events_Point Of Care Location Dimension_FK
NHSN Dialysis Events_Organization Dimension_FK
NHSN Dialysis Events_Patient Dimension_FK
NHSN Dialysis Events_Report Catalog Dimension_FK
NHSN Dialysis Events_Encounter Dimension_FK
NHSN Dialysis Events_Diagnosis Code Dimension_FK
NHSN Dialysis Events_Procedure Code Dimension_FK
NHSN Dialysis Events_Provider Dimension_FK

Primary Key
NHSN Dialysis Events 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

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

IV Antimicrobial Start Rate

Description	The proportion of IV Antimicrobial Start Dialysis Events per 100 patient months Formula: [(A/B)*100] (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

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

Number of Access Related Blood (ARB) Stream Infection Events

Description	Number of hemodialysis outpatients with a positive blood culture and the suspected source reported as the vascular access or uncertain. Formula = (A + B) (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Access-Related Bloodstream (ARB) infection Dialysis Events

Description	Number of hemodialysis outpatients with positive blood cultures with the suspected source reported as the vascular access or uncertain.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Blood Stream Infections (BSI) Events

Description	Number of hemodialysis outpatients with positive blood cultures.
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 Contamination Related Positive Blood Culture Dialysis Events

Description	Number of Positive Blood Cultures for hemodialysis outpatients whereby it is thought that the organism isolated 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Cultured Source Related Positive Blood Culture Dialysis Events

Description	Number of Positive Blood Cultures for hemodialysis outpatients whereby a source other than a vascular access is thought to be the source of the positive blood culture. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Dialysis Events

Description	There are three types of dialysis events: IV antimicrobial start; positive blood culture; and pus, redness, or increased swelling at the vascular access site. An additional four types of dialysis events are generated from the reported data: bloodstream infection (BSI), local access site infection (LASI), access-related bloodstream infection (ARB), and vascular access infection (VAI). The numbers of the different dialysis event types are used as the numerator for the calculation of dialysis event rates. Formula = (A + B + C) (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 Hemodialysis Patients

Description	The number of patients who received maintenance hemodialysis at this location on the first two working days of the month, including transient patients regardless of access type.
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 Hemodialysis Patients With A Fistula

Description	The number of 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Hemodialysis Patients With A Graft

Description	The number of patients with a graft which is a connected vein to an artery using a tube.
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 Hemodialysis Patients With A Non Tunneled Central Line

Description	The number of 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Hemodialysis Patients With Another Access Device

Description	The number of 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Hemodialysis Patients With A Tunneled Central Line

Description	The number of 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Hemodialysis Patients With Fistula Who Receive Button Hole Cannulation

Description	The number of patients who access their fistula using the button hole technique which is inserting the needles into exactly the same site at exactly the same angle.
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 IV Antimicrobial Start Dialysis Events

Description	Number of IntraVenous (IV) antimicrobial starts for hemodialysis outpatients. This is the number of occurrences where IV antibiotics or antifungals are administered in an outpatient setting, regardless of the reason for administration (i.e., include IV antimicrobial starts unrelated to vascular access problems) and regardless of the duration of treatment. This includes all IV antibiotic administrations, not just vancomycin. IV antiviral starts are not included in this figure. Report outpatient starts that are continuations of inpatient treatment. A 21 day rule applies where there must be 21 or more days from the end of the first IV antimicrobial course that was started in an outpatient setting to the beginning of a second IV antimicrobial start in an outpatient setting for two starts to be reported as separate dialysis events, even if different antimicrobials are used. If IV antimicrobials are stopped for less than 21 days and then restarted, the second start is NOT considered a new dialysis event and therefore, not reported. For outpatient IV antimicrobial starts that are continuations of inpatient treatment, consider the start day to be the first day of outpatient administration.
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 Local Access Site Infection (LASI) Events

Description	Number of hemodialysis outpatients with pus, redness or swelling of the vascular access site and access-related bloodstream infection is not present.
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 Non Cultured Source Related Positive Blood Culture Dialysis Events

Description	Number of Positive Blood Cultures for hemodialysis outpatients whereby 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Positive Blood Culture Dialysis Events

Description	Number of Positive Blood Cultures for hemodialysis outpatients. This number includes all positive blood cultures from specimens collected as an outpatient or collected within one calendar day after a hospital admission, regardless of whether or not the patient received treatment. The date of a blood culture result is based on the date the blood specimen was collected, not the date the laboratory reported the result. A 21 day rule applies where there must be 21 or more days between positive blood cultures for each positive blood culture to be considered a separate dialysis event, even if organisms are different. If positive blood cultures occur less than 21 days apart, the second positive blood culture(s) is NOT considered a new dialysis event and therefore, is not reported. However, if different organisms grow from these subsequent positive blood cultures, add the new organisms to the first report. Formula = (A + B + C + D + E) (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 Pus, Redness or Increased Swelling At Vascular Access Site Events

Description	Number of hemodialysis outpatients episodes where the patient has 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.A 21 day rule applies where there must be 21 or more days between the onset of a first episode and the onset of a second episode of pus, redness, or increased swelling at a vascular access site to be considered separate dialysis events. If an episode of pus, redness, or increased swelling at a vascular access site resolves and then recurs within 21 days of the first onset, the recurrence is NOT considered a new dialysis event and therefore, is not reported.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Uncertain Positive Blood Culture Dialysis Events

Description	Number of Positive Blood Cultures for hemodialysis outpatients whereby there is insufficient evidence to decide if the positive blood culture results are vascular access related, other source related or contamination related.
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 Vascular Access Infection (VAI) Dialysis Events

Description	Number of hemodialysis outpatients who have either a Local Access Site Infection (LASI) or an Access-Related Bloodstream (ARB) infection.
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 Vascular Access Related Positive Blood Culture Dialysis Events

Description	Number of Positive Blood Cultures for hemodialysis outpatients whereby the suspected source is the patient's vascular access.
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 Vascular Access Site Dialysis Events

Description	Number of vascular access related events for hemodialysis outpatients episode where the outpatient has 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/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 Contamination Related Positive Blood Culture Dialysis Events

Description	The count of hemodialysis outpatients whereby it is thought that the organism isolated is a contaminant expressed as a percentage of positive blood culture dialysis events. 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 Cultured Source Related Positive Blood Culture Dialysis Events

Description	The count of hemodialysis outpatients whereby a source other than a vascular access is thought to be the source of the positive blood culture expressed as a percentage of positive blood culture dialysis events. 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 Non Cultured Source Related Positive Blood Culture Dialysis Events

Description	The count of hemodialysis outpatients whereby 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 expressed as a percentage of positive blood culture dialysis events. 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 Uncertain Source Related Positive Blood Culture Dialysis Events

Description	The count of hemodialysis outpatients with an uncertain source related positive blood culture events expressed as a percentage of positive blood culture dialysis events. 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 Vascular Access Related Positive Blood Culture Dialysis Events

Description	The count of hemodialysis outpatients with a vascular access related positive blood culture events expressed as a percentage of positive blood culture dialysis events. 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

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 Rate

Description	The proportion of Positive Blood Culture Dialysis Events per 100 patient months. Formula: [(A/B)*100] (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

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 Events Rate

Description	The proportion of Pus, Redness or Increase Swelling At Vascular Access Site Dialysis Events per 100 patient months. Formula: [(A/B)*100] (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

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

Relationship Details

NHSN Dialysis Events_Practitioner Dimension_FK

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

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

Is Identifying Relationship	true
Child Table	NHSN Dialysis Events
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_Point Of Care Location Dimension_FK

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

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

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

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

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

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

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

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

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model