Dimensional Warehouse Model Data Model

Entity

Entity NHSN Hemovigilance

Description

A set of measures based on NHSN's defined dataset for hemovigilance. The dataset focuses on multiple areas such as:
Adverse events, Adverse reactions, Blood product related incidents and near misses.

Attributes
Calendar Dk
Encounter Dk
Number Adverse Reactions Associated with Incidents
Number of Acute Hemolytic Transfusion Reactions (AHTR)
Number of Allergic Adverse Reactions (where severity = severe, life threatening, or death)
Number of Blood Product/Test Order Entry Incidents
Number of Blood Product/Test Request Incidents
Number of Blood Product Administration
Number of Blood Product Check-in Related Incidents
Number of Blood Product Inventory Management Incidents
Number of Blood Product Issue Incidents
Number of Blood Product Manipulation/Processing/Testing Incidents
Number of Blood Product Related Incidents
Number of Blood Product Storage Incidents
Number of Blood Sample Collection Incidents
Number of Blood Sample Handling Incidents
Number of Blood Sample Receipt Incidents
Number of Blood Samples Collected
Number of Blood Sample Testing Incidents
Number of Delayed Hemolytic Transfusion Reactions (DHTR)
Number of Delayed Serologic Transfusion Reactions (DSTR)
Number of Febrile Non-Hemolytic Transfusion Reactions (FNHTR)
Number of Hypotensive Transfusion Adverse Reactions
Number of Near Misses
Number of Other Adverse Reactions
Number of Other Hemovigilance Incidents
Number of Patients Transfused
Number of Post-Transfusion Purpura (PTP) Adverse Reactions
Number of Request for Pick-up Incidents
Number of Satellite Storage Incidents
Number of Transfused Apheresis Platelets
Number of Transfused Apheresis Red Blood Cells
Number of Transfused Cryoprecipitate
Number of Transfused Irradiated and Leukocyte Reduced Apheresis Platelets
Number of Transfused Irradiated and Leukocyte Reduced Whole Blood Derived (WBD) Platelets
Number of Transfused Irradiated and Leukocyte Reduced Whole Blood Derived (WBD) Red Blood Cells (RBCs)
Number of Transfused Irradiated Apheresis Platelets
Number of Transfused Irradiated Apheresis Red Blood Cells (RBC)
Number of Transfused Irradiated Whole Blood Derived (WBD) Platelets
Number of Transfused Irradiated Whole Blood Derived (WBD) Red Blood Cells (RBCs)
Number of Transfused Leukocyte reduced Apheresis Platelets
Number of Transfused Leukocyte reduced Apheresis Red Blood Cells (RBC)
Number of Transfused Leukocyte reduced Whole Blood Derived (WBD) Platelets
Number of Transfused Leukocyte Reduced Whole Blood Derived (WBD) Red Blood Cells (RBCs)
Number of Transfused Non Irradiated and Leukocyte Reduced Apheresis Platelets
Number of Transfused Non Irradiated and Leukocyte Reduced Apheresis Red Blood Cells (RBC)
Number of Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived (WBD) Platelets
Number of Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived (WBD) Red Blood Cells (RBCs)
Number of Transfused Total Apheresis Plasma
Number of Transfused Total Whole Blood Derived (WBD) Plasma
Number of Transfused Whole Blood Derived (WBD) Platelets
Number of Transfused Whole Blood Derived (WBD) Red Blood Cells (RBCs)
Number of Transfused Whole Blood Units
Number of Transfusion - Associated Circulatory Overload (TACO) Adverse Reactions
Number of Transfusion-Associated Dyspnea (TAD) Adverse Reactions
Number of Transfusion-Associated Graft VS. Host Disease (TAGVHD) Adverse Reactions
Number of Transfusion-Related Acute Lung Injury (TRALI) Adverse Reactions
Number of Transfusion Related Adverse Events
Number of Transfusion Related Adverse Reactions
Number of Transfusion-Transmitted Infection (TTI) Adverse Reactions
Organization Dk
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Unfavorable Event Dimension Dk

Relationship
NHSN Hemovigilance_Organization Dimension_FK
NHSN Hemovigilance_Patient Dimension_FK
NHSN Hemovigilance_Practitioner Dimension_FK
NHSN Hemovigilance_Encounter Dimension_FK
NHSN Hemovigilance_Provider Dimension_FK
NHSN Hemovigilance_Point Of Care Location Dimension_FK
NHSN Hemovigilance_Calendar Dimension_FK
NHSN Hemovigilance_Unfavorable Event Dimension_FK

Primary Key
NHSN Hemovigilance 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

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

Number Adverse Reactions Associated with Incidents

Description	The number of adverse reactions associated with each reported incident code.
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 Acute Hemolytic Transfusion Reactions (AHTR)

Description	The number of adverse reactions which are defined by a new onset of any of he following signs/symptoms within 24 hours of cessation of transfusion: • Back/flank pain • Chills/rigors • Disseminated intravascular coagulation (DIC) • Epistaxis • Fever • Hematuria (gross visual hemolysis) • Hypotension • Oliguria/anuria • Pain and/or oozing at IV site • Renal failure AND 2 or more of the following: • Decreased fibrinogen • Decreased haptoglobin • Elevated bilirubin • Elevated LDH • Hemoglobinemia • Hemoglobinuria • Plasma discoloration c/w hemolysis • Spherocytes on blood film AND EITHER (IMMUNE-MEDIATED) Positive direct antiglobulin test (DAT) for anti-IgG or anti-C3 AND Positive elution test with alloantibody present on the transfused red blood cells OR (NON-IMMUNE MEDIATED) Serologic testing is negative, and physical cause (e.g., thermal, osmotic, mechanical, chemical) is confirmed.
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 Allergic Adverse Reactions (where severity = severe, life threatening, or death)

Description	The number of allergic reactions where 2 or more of the following occur during or within 4 hours of cessation of transfusion: • Conjunctival edema • Edema of lips, tongue and uvula • Erythema and edema of the periorbital area • Generalized flushing • Hypotension • Localized angioedema • Maculopapular rash • Pruritus (itching) • Respiratory distress; bronchospasm • Urticaria (hives) Probable: ANY 1 of the following occurring during or within 4 hours of cessation of transfusion: • Conjunctival edema • Edema of lips, tongue and uvula • Erythema and edema of the periorbital area • Localized angioedema • Maculopapular rash • Pruritus (itching) • Urticaria (hives)
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 Product/Test Order Entry Incidents

Description	The number of incidents that occur when the transfusion service receives a patient order. This process may be excluded if clinical service uses online ordering.
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 Product/Test Request Incidents

Description	The number of incidents that occur when the clinical service orders patient tests or blood products for transfusion.
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 Product Administration

Description	The number of incidents that occur during the administration of blood products.
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 Product Check-in Related Incidents

Description	The number of incidents that occur during the shipment and receipt of blood products into the transfusion service from the supplier, another hospital site, satellite storage, or clinical area.
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 Product Inventory Management Incidents

Description	The number of incidents that involve quality management of the blood product inventory.
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 Product Issue Incidents

Description	The number of incidents that occur when the transfusion service issues blood product to the clinical service.
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 Product Manipulation/Processing/Testing Incidents

Description	The number of incidents that occur while testing, manipulating (e.g., pooling, washing, aliquoting, irradiating), processing, or labeling blood products.
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 Product Related Incidents

Description	The number of incidents which are errors or accidents that could affect the quality or efficacy of blood, blood components, or patient transfusions. It may or may not result in an adverse reaction in a transfusion recipient.
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 Product Storage Incidents

Description	The number of incidents that occur during blood product storage by the transfusion service.
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 Sample Collection Incidents

Description	The number of incidents that occur during patient sample collection.
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 Sample Handling Incidents

Description	The number of incidents that occur when a patient sample is sent for testing.
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 Sample Receipt Incidents

Description	The number of incidents that occur when a sample is received by the transfusion service.
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 Samples Collected

Description	The number of blood samples (not patients) collected during the month for type and screen and/or crossmatch.
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 Sample Testing Incidents

Description	The number of incidents that occur during patient sample testing by the transfusion service.
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 Delayed Hemolytic Transfusion Reactions (DHTR)

Description	The number of adverse reactions which are defined by a positive direct antiglobulin test (DAT) for antibodies developed between 24 hours and 28 days after cessation of transfusion AND EITHER Positive elution test with alloantibody present on the transfused red blood cells OR Newly-identified red blood cell alloantibody in recipient serum AND EITHER Inadequate rise of post-transfusion hemoglobin level or rapid fall in hemoglobin back to pre-transfusion levels OR Otherwise unexplained appearance of spherocytes.
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 Delayed Serologic Transfusion Reactions (DSTR)

Description	The number of adverse reactions which are defined by an absence of clinical signs of hemolysis AND Demonstration of new, clinically-significant antibodies against red blood cells BY EITHER Positive direct antiglobulin test (DAT) OR Positive antibody screen with newly identified RBC alloantibody.
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 Febrile Non-Hemolytic Transfusion Reactions (FNHTR)

Description	The number of adverse reactions where a fever (greater than or equal to 38°C/100.4°F oral and a change of at least 1°C/1.8°F) from pre-transfusion value) occurs during or within 4 hours of cessation of transfusion or chills/rigors are 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 Hypotensive Transfusion Adverse Reactions

Description	The number of adverse reactions where hypotension occurs during or within 1 hour after cessation of transfusion. For Adults (18 years and older): Drop in systolic BP of greater than or equal to 30 mmHg and systolic BP less than or equal to 80 mmHg. Infants, children and adolescents (1 year to less than 18 years old): Greater than 25% drop in systolic BP from baseline (e.g., drop in systolic BP of 120mmHg to below 90mmHg). Neonates and small infants (less than 1 year old OR any age and less than 12 kg body weight): Greater than 25% drop in baseline value using whichever measurement is being recorded (e.g., mean BP).
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 Near Misses

Description	The number of incidents that are discovered before the start of a transfusion that could have led to a wrongful transfusion or an adverse reaction in a transfusion recipient.
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 Other Adverse Reactions

Description	The number of adverse reactions which do not meet all other adverse reaction criteria.
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 Other Hemovigilance Incidents

Description	The number of incidents that do not meet the criteria for all the other hemovigilance incident types.
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 Patients Transfused

Description	The number of patients who received a blood product transfusion.
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 Post-Transfusion Purpura (PTP) Adverse Reactions

Description	The number of adverse reactions which are defined by the presence of Alloantibodies in the patient directed against HPA or other platelet specific antigen detected at or after development of thrombocytopenia AND Thrombocytopenia (i.e., decrease in platelets to less than 20% of pre-transfusion count).
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 Request for Pick-up Incidents

Description	The number of incidents that occur when the clinical service requests pick-up of a blood product from the transfusion service.
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 Satellite Storage Incidents

Description	The number of incidents that occur while a blood product is stored and handled by the clinical service.
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 Transfused Apheresis Platelets

Description	The number of units and aliquots of apheresis platelets transfused during the month that were irradiated only, leukocyte reduced only, irradiated and leukocyte reduced, and not modified by any of these methods.
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 Transfused Apheresis Red Blood Cells

Description	The number of units and aliquots of apheresis RBCs transfused during the month that were irradiated only, leukocyte reduced only, irradiated and leukocyte reduced, and not modified by any of these methods.
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 Transfused Cryoprecipitate

Description	The number of units of all types of cryoprecipitate transfused during the month.
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 Transfused Irradiated and Leukocyte Reduced Apheresis Platelets

Description	The number of units and aliquots of apheresis platelets transfused during the month that were both irradiated and leukocyte 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 Transfused Irradiated and Leukocyte Reduced Whole Blood Derived (WBD) Platelets

Description	The number of units of WBD platelets transfused during the month that were both irradiated and leukocyte 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 Transfused Irradiated and Leukocyte Reduced Whole Blood Derived (WBD) Red Blood Cells (RBCs)

Description	The number of units and aliquots of WBD RBCs transfused during the month that were both irradiated and leukocyte 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 Transfused Irradiated Apheresis Platelets

Description	The number of units and aliquots of apheresis platelets transfused during the month that were irradiated only.
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 Transfused Irradiated Apheresis Red Blood Cells (RBC)

Description	The number of units and aliquots of apheresis RBCs transfused during the month that were irradiated only.
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 Transfused Irradiated Whole Blood Derived (WBD) Platelets

Description	The number of units of WBD platelets transfused during the month that were irradiated only.
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 Transfused Irradiated Whole Blood Derived (WBD) Red Blood Cells (RBCs)

Description	The number of units and aliquots of WBD RBCs transfused during the month that were irradiated only.
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 Transfused Leukocyte reduced Apheresis Platelets

Description	The number of units and aliquots of apheresis platelets transfused during the month that were leukocyte reduced only.
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 Transfused Leukocyte reduced Apheresis Red Blood Cells (RBC)

Description	The number of units and aliquots of apheresis RBCs transfused during the month that were leukocyte reduced only.
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 Transfused Leukocyte reduced Whole Blood Derived (WBD) Platelets

Description	The number of units of WBD platelets transfused during the month that were leukocyte reduced only.
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 Transfused Leukocyte Reduced Whole Blood Derived (WBD) Red Blood Cells (RBCs)

Description	The number of units and aliquots of WBD RBCs transfused during the month that were leukocyte reduced only.
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 Transfused Non Irradiated and Leukocyte Reduced Apheresis Platelets

Description	The number of units and aliquots of apheresis platelets transfused during the month that were not irradiated and leukocyte 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 Transfused Non Irradiated and Leukocyte Reduced Apheresis Red Blood Cells (RBC)

Description	The number of units and aliquots of apheresis RBCs transfused during the month that were not irradiated and leukocyte 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 Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived (WBD) Platelets

Description	The number of units of WBD platelets transfused during the month that were not irradiated and leukocyte 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 Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived (WBD) Red Blood Cells (RBCs)

Description	The number of units and aliquots of WBD RBCs transfused during the month that were not irradiated and leukocyte 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 Transfused Total Apheresis Plasma

Description	The number of units and aliquots of all types (fresh frozen, thawed, etc.) of apheresis plasma that were transfused during the month.
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 Transfused Total Whole Blood Derived (WBD) Plasma

Description	The number of units and aliquots of all types (fresh frozen, thawed, etc.) of WBD plasma that were transfused during the month.
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 Transfused Whole Blood Derived (WBD) Platelets

Description	The number of units of WBD platelets transfused during the month that were irradiated only, leukocyte reduced only, irradiated and leukocyte reduced, and not modified by any of these methods.
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 Transfused Whole Blood Derived (WBD) Red Blood Cells (RBCs)

Description	The number of units and aliquots of whole blood derived (WBD) red blood cells (RBCs) transfused during the month that were irradiated only, leukocyte reduced only, irradiated and leukocyte reduced, and not modified by any of these methods.
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 Transfused Whole Blood Units

Description	The number of whole blood units and aliquots of whole blood transfused.
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 Transfusion - Associated Circulatory Overload (TACO) Adverse Reactions

Description	The number of adverse reactions which are defined by a new onset or exacerbation of 3 or more of the following within 6 hours of cessation of transfusion: • Acute respiratory distress (dyspnea, orthopnea, cough) • Elevated brain natriuretic peptide (BNP) • Elevated central venous pressure (CVP) • Evidence of left heart failure • Evidence of positive fluid balance • Radiographic evidence of pulmonary edema.
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 Transfusion-Associated Dyspnea (TAD) Adverse Reactions

Description	The number of adverse reactions which are defined by a new onset of acute respiratory distress within 24 hours of cessation of transfusion AND Allergic reaction, TACO, and TRALI definitions are not applicable
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 Transfusion-Associated Graft VS. Host Disease (TAGVHD) Adverse Reactions

Description	The number of adverse reactions which are defined by a clinical syndrome occurring from 2 days to 6 weeks after cessation of transfusion characterized by: • Characteristic rash: erythematous, maculopapular eruption centrally that spreads to extremities and may, in severe cases, progress to generalized erythroderma and hemorrhagic bullous formation. • Diarrhea • Fever • Hepatomegaly • Liver dysfunction (i.e., elevated ALT, AST, Alkaline phosphatase, and bilirubin) • Marrow aplasia • Pancytopenia AND Characteristic histological appearance of skin or liver biopsy.
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 Transfusion-Related Acute Lung Injury (TRALI) Adverse Reactions

Description	The number of adverse reactions which are defined by a new onset of Acute Lung Injury (ALI) within 6 hours of cessation of transfusion AND no evidence of ALI prior to transfusion AND Hypoxemia defined by any of these methods: • PaO2/FiO2 less than or equal to 300 mm Hg • Oxygen saturation less than 90% on room air • Other clinical evidence AND Radiographic evidence of bilateral infiltrates AND No evidence of left atrial hypertension (i.e., circulatory overload)
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 Transfusion Related Adverse Events

Description	Number of unintended and undesirable occurrence before, during or after transfusion of blood or blood components. Adverse events include both incidents and adverse reactions. 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 Transfusion Related Adverse Reactions

Description	Number of reactions which are undesired responses or effects in a patient that are temporally associated with the administration of blood or blood components. It may or may not be the result of an incident.
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 Transfusion-Transmitted Infection (TTI) Adverse Reactions

Description	The number of adverse reactions which are defined by laboratory evidence of a pathogen in the transfusion recipient.
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	true

Point Of Care Location Dk

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

Practitioner Dk

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

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	true

Unfavorable Event Dimension 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 Hemovigilance_Organization Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Hemovigilance
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 Hemovigilance_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Hemovigilance
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 Hemovigilance_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Hemovigilance
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 Hemovigilance_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Hemovigilance
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 Hemovigilance_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Hemovigilance
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 Hemovigilance_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Hemovigilance
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 Hemovigilance_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Hemovigilance
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 Hemovigilance_Unfavorable Event Dimension_FK

Is Identifying Relationship	true
Child Table	NHSN Hemovigilance
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	Unfavorable Event 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 Hemovigilance PK

Key Attribute	Organization Dk
Key Attribute	Encounter Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Calendar Dk
Key Attribute	Unfavorable Event Dimension Dk
Key Attribute	Patient Dk
Key Attribute	Provider Dk
Key Attribute	Practitioner Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model