Atomic Warehouse Model Data Model

Entity

Entity Blood Product Administration Detail

Description

The act of giving the patient a blood transfusion using the blood or derivative product of blood that was ordered and dispensed.

Attributes
Blood Component Donation Num
Blood Component Type Code Sk
Blood Group Code Sk
Blood Product Administration Sk
Blood Product Amt Qty
Blood Product Qty
Blood Product Type Code Sk
Blood Product UOM Code Sk
Blood Transfusion Sequence Num
Commercial Blood Product Code Sk
Commercial Blood Product Lot Num
Commercial Blood Product Manufacturer Nm
Commercial Blood Product Nm
Effective From Dt
Effective To Dt
Load Info Sk
Observation Status Code Sk
Source Code Sk
Tenant Sk
Transfusion End Ts
Transfusion Interruption Reason Code Sk
Transfusion Start Ts
Transfusion Status Code Sk
Valid From Ts
Valid To Ts

Relationship
Blood Product Administration Detail_Blood Product Administration_FK

Primary Key
Blood Product Administration Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Blood Component Donation Num

Description	A unique identification number assigned to a blood donation.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Component Type Code Sk

Description	Indicates which derivative part of whole blood. For Example: Red Blood Cells Washed Red Blood Cells Plasma Platelets If using the ISBT 128 labeling standard, the product code will consist of an 8-character alphanumeric code which includes the blood component class.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Group Code Sk

Description	Indicates the ABO/Rh blood group status of the blood product. For Example: A+ A- B+ B- O+ O- AB+ AB-
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Product Administration Sk

Description	Surrogate key for this anchor and associative entity for the Blood Product Administration data.
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

Blood Product Amt Qty

Description	Indicates the volume of blood product ordered, dispensed, or transfused.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Product Qty

Description	The number of blood products ordered, dispensed, or used in the transfusion. For Example: 3 Units
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Product Type Code Sk

Description	An indicator to differentiate between Blood Component or Commercial Product.
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

Blood Product UOM Code Sk

Description	The units of measure in which the ordered, dispensed, or transfused blood product amount is expressed. For example: Milliliters International Units
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Transfusion Sequence Num

Description	An integer number starting at 1 and incrementing by one to provide uniqueness for each occurrence of Blood transfusion/disposition transmitted. For Example: 2nd of 4 units of whole blood.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Commercial Blood Product Code Sk

Description	Indicates the code to identify a commercial product. Examples of commercial products are blood derivatives such as Rh Immune Globulin and Factor VIII concentrate, Leukoreduction filters, and blood administration sets.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Commercial Blood Product Lot Num

Description	Identifies the lot number for blood derivatives or commercially supplied items used as transfusion accessories.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Commercial Blood Product Manufacturer Nm

Description	Text description of a commercial blood product manufacturer. The manufacturer may be different to the supplier of the commercial blood product.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Commercial Blood Product Nm

Description	Text description of a commercial blood product. For Example: Red Blood Cells Platelets Factor VIII
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
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

Observation Status Code Sk

Description	The most commonly used message status values will be preliminary and final. A status is considered preliminary until a blood product has reached a final disposition for the patient. The status of a blood product can continue to change and the previous status should be overwritten until it reaches a final status. Refer to HL7 BTX. For example: When the product is first cross-matched and a status message is sent, it would be considered preliminary. When the product is dispensed to the patient, that status would also be considered preliminary. Once the product is transfused, the status would be considered final.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
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

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

Transfusion End Ts

Description	The date and time the transfusion of the blood component or commercial product was completed or stopped.
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 Interruption Reason Code Sk

Description	The reason that the transfusion of the blood product was interrupted.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transfusion Start Ts

Description	The date and time the administrator started the transfusion of the blood component or commercial product.
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 Status Code Sk

Description	Indicates the current status of the specified blood product transfusion. For Example: RA Returned unused/no longer needed RL Returned unused/keep linked to patient for possible use later WA Wasted (product no longer viable) TX Transfused TR Transfused with adverse reaction
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Blood Product Administration Detail_Blood Product Administration_FK

Is Identifying Relationship	true
Child Table	Blood Product Administration Detail
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	Blood Product Administration
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Blood Product Administration Detail PK

Key Attribute	Blood Product Administration Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model