| Atomic Warehouse Model Data Model |
| Description | The act of issuing the ordered blood or derivative product of blood from the blood bank or blood product supplier. |
| Relationship | |
Blood Product Order Dispense Detail_Blood Product Order Dispense_FK |
|
| Primary Key | |
Blood Product Order Dispense 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 Donation Type Code Sk
| Description | Indicates which type or derivative of blood is donated. For Example: Platelets Red cells Plasma |
| 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 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 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 Expiration Ts
| Description | The date and time the blood product expires. The blood product is no longer considered acceptable once the expiration date has been reached unless cleared by the transfusion service medical staff. |
| 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 Order Dispense Sk
| Description | Surrogate key for this anchor and associative entity for the Blood Product Order Dispensed 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 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 | false |
| Is Derived | false |
| Is Surrogate Key | false |
Blood Product Unique Num
| Description | A unique system-generated number assigned to the 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 |
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 |
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 |
Dispense Status Code Sk
| Description | Indicates the current status of the ordered blood product as indicated by the filler or placer For Example: RI Received into inventory (for specified patient) RD Reserved and ready to dispense RS Reserved (ordered and product allocated for the patient) RE Released (no longer allocated for the patient) DS Dispensed to patient location RA Returned unused/no longer needed RL Returned unused/keep linked to patient for possible use later WA Wasted (product no longer viable) PT Presumed transfused (dispensed and not returned) CR Released into inventory for general availability RQ Request to dispense blood product |
| 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 |
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. 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. However, once the product is transfused, the status would be considered final. 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 BPX. Examples: C Record coming over is a correction and thus replaces a final status D Deletes the BPX record F Final status; Can only be changed with a corrected status O Order detail description only (no status) P Preliminary status W Post original as wrong, for example, transmitted for wrong patient |
| 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 |
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 Order Dispense Detail_Blood Product Order Dispense_FK
| Is Identifying Relationship | true |
| Child Table | Blood Product Order Dispense 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 Order Dispense |
| 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 Order Dispense Detail PK
| Key Attribute | Blood Product Order Dispense Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |