| Business Data Model Data Model |
| Description | The act of issuing the ordered blood or derivative product of blood from the blood bank or blood product supplier. |
| Dependencies | |
 NONE |
|
| 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
| Description | Indicates which type or derivative of blood is donated. For Example: Platelets Red cells Plasma |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Blood Component Type Code
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Blood Group
| 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/Enumeration [VARCHAR(20)] |
| 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 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
| Description | An indicator to differentiate between Blood Component or Commercial Product. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| 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
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Commercial Blood Product Code
| 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/Enumeration [VARCHAR(20)] |
| 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 Name
| 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 Name
| 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
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Dispense Status Ts
| Description | The date and time the specified blood product dispense status is defined. For Example: RD Reserved and ready to dispense at YYYY/DD/MM |
| 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 |
Observation Status
| 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. For example: 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Blood Product Dispense_Blood Product Order_FK
| Is Identifying Relationship | false |
| Child Table | Blood Product Dispense |
| 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 |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Blood Product Dispense_Address_FK
| Is Identifying Relationship | false |
| Child Table | Blood Product Dispense |
| Child Role Name | actual dispensed to |
| 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 | Address |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Blood Product Dispense_Practitioner_FK
| Is Identifying Relationship | false |
| Child Table | Blood Product Dispense |
| Child Role Name | receiver |
| 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 |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Blood Product Dispense_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Blood Product Dispense |
| 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 |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Blood Product Dispense_Practitioner_FK1
| Is Identifying Relationship | false |
| Child Table | Blood Product Dispense |
| Child Role Name | dispenser |
| 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 |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Blood Product Dispense_Point Of Care Location_FK
| Is Identifying Relationship | false |
| Child Table | Blood Product Dispense |
| Child Role Name | actual dispensed to |
| 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 |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |