Entity Blood Product Order Dispense Detail

DescriptionThe act of issuing the ordered blood or derivative product of blood from the blood bank or blood product supplier.

Attributes
Blood Component Donation NumBlood Component Donation Num
Blood Component Donation Type Code SkBlood Component Donation Type Code Sk
Blood Component Type Code SkBlood Component Type Code Sk
Blood Group Code SkBlood Group Code Sk
Blood Product Amt QtyBlood Product Amt Qty
Blood Product Expiration TsBlood Product Expiration Ts
Blood Product Order Dispense SkBlood Product Order Dispense Sk
Blood Product QtyBlood Product Qty
Blood Product Type Code SkBlood Product Type Code Sk
Blood Product Unique NumBlood Product Unique Num
Blood Product UOM Code SkBlood Product UOM Code Sk
Commercial Blood Product Code SkCommercial Blood Product Code Sk
Commercial Blood Product Lot NumCommercial Blood Product Lot Num
Commercial Blood Product Manufacturer NmCommercial Blood Product Manufacturer Nm
Commercial Blood Product NmCommercial Blood Product Nm
Dispense Status Code SkDispense Status Code Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Load Info SkLoad Info Sk
Observation Status Code SkObservation Status Code Sk
Source Code SkSource Code Sk
Tenant SkTenant Sk
Valid From TsValid From Ts
Valid To TsValid To Ts

Relationship
Blood Product Order Dispense Detail_Blood Product Order Dispense_FKBlood Product Order Dispense Detail_Blood Product Order Dispense_FK

Primary Key
Blood Product Order Dispense Detail PKBlood Product Order Dispense Detail PK

Dependencies
 

Reverse Dependencies
 

Attribute Details

 Blood Component Donation Num
DescriptionA unique identification number assigned to a blood donation.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Component Donation Type Code Sk
DescriptionIndicates which type or derivative of blood is donated.

For Example:
Platelets
Red cells
Plasma
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Component Type Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Group Code Sk
DescriptionIndicates the ABO/Rh blood group status of the blood product.

For Example:
A+
A-
B+
B-
O+
O-
AB+
AB-
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Amt Qty
DescriptionIndicates the volume of blood product ordered, dispensed, or transfused.
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Expiration Ts
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Order Dispense Sk
DescriptionSurrogate key for this anchor and associative entity for the Blood Product Order Dispensed data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Qty
DescriptionThe number of blood products ordered, dispensed, or used in the transfusion.

For Example:
3 Units
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Type Code Sk
DescriptionAn indicator to differentiate between Blood Component or Commercial Product.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Unique Num
DescriptionA unique system-generated number assigned to the blood product.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product UOM Code Sk
DescriptionThe units of measure in which the ordered, dispensed, or transfused blood product amount is expressed.

For example:
Milliliters
International Units
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Commercial Blood Product Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Commercial Blood Product Lot Num
DescriptionIdentifies the lot number for blood derivatives or commercially supplied items used as transfusion accessories.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Commercial Blood Product Manufacturer Nm
DescriptionText description of a commercial blood product manufacturer. The manufacturer may be different to the supplier of the commercial blood product.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Commercial Blood Product Nm
DescriptionText description of a commercial blood product.

For Example:
Red Blood Cells
Platelets
Factor VIII
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Dispense Status Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Observation Status Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Blood Product Order Dispense Detail_Blood Product Order Dispense_FK
Is Identifying Relationshiptrue
Child TableBlood Product Order Dispense Detail
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableBlood Product Order Dispense
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Blood Product Order Dispense Detail PK
Key AttributeBlood Product Order Dispense Sk
Key AttributeValid From Ts