Dimensional Warehouse Model Data Model

Entity

Entity NHSN Hemovigilance Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to NHSN Hemovigilance. The key areas examined are Adverse Events, Adverse Reactions, Incidents and Near Misses.

Attributes
Acute Hemolytic Transfusion Reactions (AHTR) Ind
Acute Hemolytic Transfusion Reactions (AHTR) Ts
Adverse Reactions Associated with Incidents Ind
Adverse Reactions Associated with Incidents Ts
Allergic Adverse Reactions Ind
Allergic Adverse Reactions Ts
Blood Product Administration Incident Ind
Blood Product Administration Incident Ts
Blood Product Checkin Related Incident Ind
Blood Product Checkin Related Incident Ts
Blood Product Inventory Management Incident Ind
Blood Product Inventory Management Incident Ts
Blood Product Issue Incident Ind
Blood Product Issue Incident Ts
Blood Product Manipulation Or Processing Or Testing Incident Ind
Blood Product Manipulation Or Processing Or Testing Incident Ts
Blood Product Or Test Order Entry Incident Ind
Blood Product Or Test Order Entry Incident Ts
Blood Product Or Test Request Incident Ind
Blood Product Or Test Request Incident Ts
Blood Product Related Incident Ind
Blood Product Related Incident Ts
Blood Product Request for Pickup Incident Ind
Blood Product Request for Pickup Incident Ts
Blood Product Satellite Storage Incident Ind
Blood Product Satellite Storage Incident Ts
Blood Product Storage Incident Ind
Blood Product Storage Incident Ts
Blood Sample Collected Ind
Blood Sample Collection Incident Ind
Blood Sample Collection Incident Ts
Blood Sample Collection Ts
Blood Sample Handling Incident Ind
Blood Sample Handling Incident Ts
Blood Sample Receipt Incident Ind
Blood Sample Receipt Incident Ts
Blood Sample Testing Incident Ind
Blood Sample Testing Incident Ts
Calendar Dk
Delayed Hemolytic Transfusion Reactions (DHTR) Ind
Delayed Hemolytic Transfusion Reactions (DHTR) Ts
Delayed Serologic Transfusion Reactions (DSTR) Ind
Delayed Serologic Transfusion Reactions (DSTR) Ts
Encounter Dk
Febrile Non-Hemolytic Transfusion Reactions (FNHTR) Ind
Febrile Non-Hemolytic Transfusion Reactions (FNHTR) Ts
Hypotensive Transfusion Adverse Reactions Ind
Hypotensive Transfusion Adverse Reactions Ts
Load Info Sk
Near Miss Ind
Near Miss Ts
Organization Dk
Other Adverse Reactions Ind
Other Adverse Reactions Ts
Other Blood Product Related Incident Ind
Other Blood Product Related Incident Ts
Patient Dk
Point Of Care Location Dk
Post Transfusion Purpura (PTP) Adverse Reactions Ind
Post Transfusion Purpura (PTP) Adverse Reactions Ts
Practitioner Dk
Provider Dk
Tenant Sk
Transfused Apheresis Platelets Ind
Transfused Apheresis Platelets Ts
Transfused Apheresis Red Blood Cells Ind
Transfused Apheresis Red Blood Cells Ts
Transfused Cryoprecipitate Ind
Transfused Cryoprecipitate Ts
Transfused Irradiated and Leukocyte Reduced Apheresis Platelets Ind
Transfused Irradiated and Leukocyte Reduced Apheresis Platelets Ts
Transfused Irradiated and Leukocyte Reduced Apheresis Red Blood Cells Ind
Transfused Irradiated and Leukocyte Reduced Apheresis Red Blood Cells Ts
Transfused Irradiated and Leukocyte Reduced Whole Blood Derived Platelets Ind
Transfused Irradiated and Leukocyte Reduced Whole Blood Derived Platelets Ts
Transfused Irradiated and Leukocyte Reduced Whole Blood Derived Red Blood Cells Ind
Transfused Irradiated and Leukocyte Reduced Whole Blood Derived Red Blood Cells Ts
Transfused Irradiated Apheresis Platelets Ind
Transfused Irradiated Apheresis Platelets Ts
Transfused Irradiated Apheresis Red Blood Cells Ind
Transfused Irradiated Apheresis Red Blood Cells Ts
Transfused Irradiated Whole Blood Derived Platelets Ind
Transfused Irradiated Whole Blood Derived Platelets Ts
Transfused Irradiated Whole Blood Derived Red Blood Cells Ind
Transfused Irradiated Whole Blood Derived Red Blood Cells Ts
Transfused Leukocyte reduced Apheresis Platelets Ind
Transfused Leukocyte reduced Apheresis Platelets Ts
Transfused Leukocyte reduced Apheresis Red Blood Cells Ind
Transfused Leukocyte reduced Apheresis Red Blood Cells Ts
Transfused Leukocyte reduced Whole Blood Derived Platelets Ind
Transfused Leukocyte reduced Whole Blood Derived Platelets Ts
Transfused Leukocyte Reduced Whole Blood Derived Red Blood Cells Ind
Transfused Leukocyte Reduced Whole Blood Derived Red Blood Cells Ts
Transfused Non Irradiated and Leukocyte Reduced Apheresis Platelets Ind
Transfused Non Irradiated and Leukocyte Reduced Apheresis Platelets Ts
Transfused Non Irradiated and Leukocyte Reduced Apheresis Red Blood Cells Ind
Transfused Non Irradiated and Leukocyte Reduced Apheresis Red Blood Cells Ts
Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived Platelets Ind
Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived Platelets Ts
Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived Red Blood Cells Ind
Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived Red Blood Cells Ts
Transfused Total Apheresis Plasma Ind
Transfused Total Apheresis Plasma Ts
Transfused Total Whole Blood Derived Plasma Ind
Transfused Total Whole Blood Derived Plasma Ts
Transfused Whole Blood Derived Platelets Ind
Transfused Whole Blood Derived Platelets Ts
Transfused Whole Blood Derived Red Blood Cells Ind
Transfused Whole Blood Derived Red Blood Cells Ts
Transfused Whole Blood Unit Ind
Transfused Whole Blood Unit Ts
Transfusion Associated Circulatory Overload (TACO) Adverse Reaction Ind
Transfusion Associated Circulatory Overload (TACO) Adverse Reaction Ts
Transfusion Associated Dyspnea (TAD) Adverse Reaction Ind
Transfusion Associated Dyspnea (TAD) Adverse Reaction Ts
Transfusion Associated Graft VS. Host Disease (TAGVHD) Adverse Reactions Ind
Transfusion Associated Graft VS. Host Disease (TAGVHD) Adverse Reactions Ts
Transfusion Ind
Transfusion Related Acute Lung Injury (TRALI) Adverse Reaction Ind
Transfusion Related Acute Lung Injury (TRALI) Adverse Reaction Ts
Transfusion Related Adverse Reaction Ind
Transfusion Related Adverse Reaction Ts
Transfusion Transmitted Infection (TTI) Adverse Reactions Ind
Transfusion Transmitted Infection (TTI) Adverse Reactions Ts
Transfusion Ts
Unfavorable Event Dimension Dk

Relationship
NHSN Hemovigilance Snapshot_Calendar Dimension_FK
NHSN Hemovigilance Snapshot_Point Of Care Location Dimension_FK
NHSN Hemovigilance Snapshot_Provider Dimension_FK
NHSN Hemovigilance Snapshot_Encounter Dimension_FK
NHSN Hemovigilance Snapshot_Practitioner Dimension_FK
NHSN Hemovigilance Snapshot_Patient Dimension_FK
NHSN Hemovigilance Snapshot_Organization Dimension_FK
NHSN Hemovigilance Snapshot_Unfavorable Event Dimension_FK

Primary Key
NHSN Hemovigilance Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Acute Hemolytic Transfusion Reactions (AHTR) Ind

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Acute Hemolytic Transfusion Reactions (AHTR) Ts

Description	Timestamp representing Acute Hemolytic Transfusion Reactions (AHTR)
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

Adverse Reactions Associated with Incidents Ind

Description	The number of adverse reactions associated with each reported incident code.
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

Adverse Reactions Associated with Incidents Ts

Description	Timestamp representing Adverse Reactions Associated with Incidents
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

Allergic Adverse Reactions Ind

Description	The number of allergic reactions (where severity = severe, life threatening, or death) 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Allergic Adverse Reactions Ts

Description	Timestamp representing Allergic Adverse Reactions (where severity = severe, life threatening, or death)
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

Blood Product Administration Incident Ind

Description	Indicator that identifies blood product related incidents that occur during the administration of blood products.
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

Blood Product Administration Incident Ts

Description	Timestamp representing when the blood product administration incident occurred.
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

Blood Product Checkin Related Incident Ind

Description	Indicator that identifies 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Product Checkin Related Incident Ts

Description	Timestamp representing when the blood product check-in related incident occurred.
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

Blood Product Inventory Management Incident Ind

Description	Indicator that identifies blood product related incidents that involve quality management of the blood product inventory.
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

Blood Product Inventory Management Incident Ts

Description	Timestamp representing when the blood product inventory management incident occurred.
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

Blood Product Issue Incident Ind

Description	Indicator that identifies blood product related incidents that occur when the transfusion service issues blood product to the clinical service.
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

Blood Product Issue Incident Ts

Description	Timestamp representing when the blood product issue incident occurred.
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

Blood Product Manipulation Or Processing Or Testing Incident Ind

Description	Indicator that identifies blood product related 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Product Manipulation Or Processing Or Testing Incident Ts

Description	Timestamp representing when the blood product manipulation/processing/testing incident occurred.
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

Blood Product Or Test Order Entry Incident Ind

Description	Indicator that identifies blood product related 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Product Or Test Order Entry Incident Ts

Description	Timestamp representing when the blood product/test order entry incident occurred.
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

Blood Product Or Test Request Incident Ind

Description	Indicator that identifies blood product related incidents that occur when the clinical service orders patient tests or blood products for transfusion.
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

Blood Product Or Test Request Incident Ts

Description	Timestamp representing when the blood product/test request incident occurred.
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

Blood Product Related Incident Ind

Description	Indicator that identifies blod product related errors or accidents that could affect the quality or efficacy of blood, blood components, or patient transfusions.
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

Blood Product Related Incident Ts

Description	Timestamp representing when the blood product related incident occurred.
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

Blood Product Request for Pickup Incident Ind

Description	Indicator that identifies blood product related 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Product Request for Pickup Incident Ts

Description	Timestamp representing when the blood product request for pick-up incident occurred.
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

Blood Product Satellite Storage Incident Ind

Description	Indicator that identifies blood product related incidents that occur while a blood product is stored and handled by the clinical service.
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

Blood Product Satellite Storage Incident Ts

Description	Timestamp representing when the blood product satellite storage incident occurred.
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

Blood Product Storage Incident Ind

Description	Indicator that identifies blood product related incidents that occur during blood product storage by the transfusion service.
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

Blood Product Storage Incident Ts

Description	Timestamp representing when the blood product storage incident occurred.
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

Blood Sample Collected Ind

Description	Indicator that identifies blood samples collected from patients for type and screen and/or crossmatch.
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

Blood Sample Collection Incident Ind

Description	Indicator that identifies blood product related incidents that occur during patient sample collection.
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

Blood Sample Collection Incident Ts

Description	Timestamp representing when the blood sample collection incident occurred.
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

Blood Sample Collection Ts

Description	Timestamp representing when the blood sample for type and screen and/or crossmatch was taken from the patient.
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

Blood Sample Handling Incident Ind

Description	Indicator that identifies blood product related incidents that occur when a patient sample is sent for testing.
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

Blood Sample Handling Incident Ts

Description	Timestamp representing when the blood sample handling incident occurred.
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

Blood Sample Receipt Incident Ind

Description	Indicator that identifies blood product related incidents that occur when a sample is received by the transfusion service.
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

Blood Sample Receipt Incident Ts

Description	Timestamp representing when the blood sample receipt incident occurred.
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

Blood Sample Testing Incident Ind

Description	Indicator that identifies incidents blood product related that occur during patient sample testing by the transfusion service.
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

Blood Sample Testing Incident Ts

Description	Timestamp representing when the blood sample testing incident occurred.
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

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

Delayed Hemolytic Transfusion Reactions (DHTR) Ind

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Delayed Hemolytic Transfusion Reactions (DHTR) Ts

Description	Timestamp representing Delayed Hemolytic Transfusion Reactions (DHTR)
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

Delayed Serologic Transfusion Reactions (DSTR) Ind

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Delayed Serologic Transfusion Reactions (DSTR) Ts

Description	Timestamp representing Delayed Serologic Transfusion Reactions (DSTR)
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

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

Febrile Non-Hemolytic Transfusion Reactions (FNHTR) Ind

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Febrile Non-Hemolytic Transfusion Reactions (FNHTR) Ts

Description	Timestamp representing Febrile Non-Hemolytic Transfusion Reactions (FNHTR)
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

Hypotensive Transfusion Adverse Reactions Ind

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Hypotensive Transfusion Adverse Reactions Ts

Description	Timestampe representing Hypotensive Transfusion Adverse Reactions
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

Near Miss Ind

Description	A subset of indicators 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Near Miss Ts

Description	Timestamp representing when the near miss occurred.
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

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

Other Adverse Reactions Ind

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

Other Adverse Reactions Ts

Description	Timestamp representing Other Adverse Reactions
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

Other Blood Product Related Incident Ind

Description	Indicator that identifies blood product related incidents that do not meet the critieria for all the other hemovigilance incident types.
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

Other Blood Product Related Incident Ts

Description	Timestamp representing when the other blood product related incident occurred.
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

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

Post Transfusion Purpura (PTP) Adverse Reactions Ind

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Post Transfusion Purpura (PTP) Adverse Reactions Ts

Description	Timestamp representing Post-Transfusion Purpura (PTP) Adverse Reactions
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

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

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

Transfused Apheresis Platelets Ind

Description	Indicator that identifies transfused units and aliquots of apheresis platelets 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfused Apheresis Platelets Ts

Description	Timestamp representing when the patient was transfused with apheresis platelets 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/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfused Apheresis Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of apheresis Red Blood Cells 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfused Apheresis Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Red Blood Cells 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/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfused Cryoprecipitate Ind

Description	Indicator that identifies transfused units of all types of cryoprecipitate.
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

Transfused Cryoprecipitate Ts

Description	Timestamp representing when the patient was transfused with units of all types of cryoprecipitate.
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

Transfused Irradiated and Leukocyte Reduced Apheresis Platelets Ind

Description	Indicator that identifies transfused units and aliquots of apheresis platelets that were both irradiated and leukocyte 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

Transfused Irradiated and Leukocyte Reduced Apheresis Platelets Ts

Description	Timestamp representing when the patient was transfused with apheresis platelets that were both irradiated and leukocyte reduced.
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

Transfused Irradiated and Leukocyte Reduced Apheresis Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Apheresis Red Blood Cells that were both irradiated and leukocyte 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

Transfused Irradiated and Leukocyte Reduced Apheresis Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Apheresis Red Blood Cells that were both irradiated and leukocyte reduced.
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

Transfused Irradiated and Leukocyte Reduced Whole Blood Derived Platelets Ind

Description	Indicator that identifies transfused units of Whole Blood Derived platelets that were both irradiated and leukocyte 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

Transfused Irradiated and Leukocyte Reduced Whole Blood Derived Platelets Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived platelets that were both irradiated and leukocyte reduced.
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

Transfused Irradiated and Leukocyte Reduced Whole Blood Derived Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Whole Blood Derived Red Blood Cells that were both irradiated and leukocyte 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

Transfused Irradiated and Leukocyte Reduced Whole Blood Derived Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived Red Blood Cells that were both irradiated and leukocyte reduced.
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

Transfused Irradiated Apheresis Platelets Ind

Description	Indicator that identifies transfused units and aliquots of apheresis platelets that were irradiated only.
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

Transfused Irradiated Apheresis Platelets Ts

Description	Timestamp representing when the patient was transfused with apheresis platelets that were irradiated only.
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

Transfused Irradiated Apheresis Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Apheresis Red Blood Cells that were irradiated only.
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

Transfused Irradiated Apheresis Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Apheresis Red Blood Cells that were irradiated only.
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

Transfused Irradiated Whole Blood Derived Platelets Ind

Description	Indicator that identifies transfused units of Whole Blood Derived platelets that were irradiated only.
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

Transfused Irradiated Whole Blood Derived Platelets Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived platelets that were irradiated only.
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

Transfused Irradiated Whole Blood Derived Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Whole Blood Derived Red Blood Cells that were irradiated only.
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

Transfused Irradiated Whole Blood Derived Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived Red Blood Cells that were irradiated only.
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

Transfused Leukocyte reduced Apheresis Platelets Ind

Description	Indicator that identifies transfused units and aliquots of apheresis platelets that were leukocyte reduced only.
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

Transfused Leukocyte reduced Apheresis Platelets Ts

Description	Timestamp representing when the patient was transfused with apheresis platelets that were leukocyte reduced only.
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

Transfused Leukocyte reduced Apheresis Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Apheresis Red Blood Cells that were leukocyte reduced only.
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

Transfused Leukocyte reduced Apheresis Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Apheresis Red Blood Cells that were leukocyte reduced only.
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

Transfused Leukocyte reduced Whole Blood Derived Platelets Ind

Description	Indicator that identifies transfused units of Whole Blood Derived platelets that were leukocyte reduced only.
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

Transfused Leukocyte reduced Whole Blood Derived Platelets Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived platelets that were leukocyte reduced only.
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

Transfused Leukocyte Reduced Whole Blood Derived Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Whole Blood Derived Red Blood Cells that were leukocyte reduced only.
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

Transfused Leukocyte Reduced Whole Blood Derived Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived Red Blood Cells that were leukocyte reduced only.
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

Transfused Non Irradiated and Leukocyte Reduced Apheresis Platelets Ind

Description	Indicator that identifies transfused units and aliquots of apheresis platelets that were not irradiated and leukocyte 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

Transfused Non Irradiated and Leukocyte Reduced Apheresis Platelets Ts

Description	Timestamp representing when the patient was transfused with apheresis platelets that were not irradiated and leukocyte reduced.
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

Transfused Non Irradiated and Leukocyte Reduced Apheresis Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Apheresis Red Blood Cells that were not irradiated and leukocyte 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

Transfused Non Irradiated and Leukocyte Reduced Apheresis Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Apheresis Red Blood Cells that were not irradiated and leukocyte reduced.
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

Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived Platelets Ind

Description	Indicator that identifies transfused units of Whole Blood Derived platelets that were not irradiated and leukocyte 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

Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived Platelets Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived platelets that were not irradiated and leukocyte reduced.
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

Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Whole Blood Derived Red Blood Cells that were not irradiated and leukocyte 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

Transfused Non Irradiated and Leukocyte Reduced Whole Blood Derived Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived Red Blood Cells that were not irradiated and leukocyte reduced.
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

Transfused Total Apheresis Plasma Ind

Description	Indicator that identifies transfused units and aliquots of all types (fresh frozen, thawed, etc.) of apheresis plasma.
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

Transfused Total Apheresis Plasma Ts

Description	Timestamp representing when the patient was transfused with all types (fresh frozen, thawed, etc.) of apheresis plasma.
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

Transfused Total Whole Blood Derived Plasma Ind

Description	Indicator that identifies transfused units and aliquots of all types (fresh frozen, thawed, etc.) of Whole Blood Derived plasma.
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

Transfused Total Whole Blood Derived Plasma Ts

Description	Timestamp representing when the patient was transfused with all types (fresh frozen, thawed, etc.) of Whole Blood Derived plasma.
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

Transfused Whole Blood Derived Platelets Ind

Description	Indicator that identifies transfused units of Whole Blood Derived platelets 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfused Whole Blood Derived Platelets Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived platelets 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/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfused Whole Blood Derived Red Blood Cells Ind

Description	Indicator that identifies transfused units and aliquots of Whole Blood Derived Red Blood Cells 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfused Whole Blood Derived Red Blood Cells Ts

Description	Timestamp representing when the patient was transfused with Whole Blood Derived Red Blood Cells 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/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfused Whole Blood Unit Ind

Description	Indicator that identifies transfused whole blood units and aliquots.
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

Transfused Whole Blood Unit Ts

Description	Timestamp representing when the patient was transfused with whole blood units and aliquots.
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

Transfusion Associated Circulatory Overload (TACO) Adverse Reaction Ind

Description	Indicator that identifies patients who experience 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfusion Associated Circulatory Overload (TACO) Adverse Reaction Ts

Description	Timestamp representing Transfusion - Associated Circulatory Overload (TACO) Adverse Reaction
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

Transfusion Associated Dyspnea (TAD) Adverse Reaction Ind

Description	Indicator that identifies patients who experience 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfusion Associated Dyspnea (TAD) Adverse Reaction Ts

Description	Timestamp representing Transfusion-Associated Dyspnea (TAD) Adverse Reaction
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

Transfusion Associated Graft VS. Host Disease (TAGVHD) Adverse Reactions Ind

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfusion Associated Graft VS. Host Disease (TAGVHD) Adverse Reactions Ts

Description	Timestamp representing Transfusion-Associated Graft VS. Host Disease (TAGVHD) Adverse Reactions
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

Transfusion Ind

Description	Indicator that identifies patients who received a blood product transfusion.
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

Description	Indicator that identifies patients who experience 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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Description	Timestamp representing Transfusion-Related Acute Lung Injury (TRALI) Adverse Reaction
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

Description	Indicator that identifies patients who experience an undesirable response or effect that is temporally associated with the administration of blood or blood components.
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

Transfusion Related Adverse Reaction Ts

Description	Timestamp representing Transfusion Related Adverse Reaction
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

Transfusion Transmitted Infection (TTI) Adverse Reactions Ind

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfusion Transmitted Infection (TTI) Adverse Reactions Ts

Description	Timestamp representing Transfusion-Transmitted Infection (TTI) Adverse Reactions
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

Transfusion 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

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 Snapshot_Calendar Dimension_FK

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

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

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

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

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

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

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

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

Key Attribute	Calendar Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Encounter Dk
Key Attribute	Organization 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