Dimensional Warehouse Model Data Model

Entity

Entity Blood Product Order Dispense Fact

Description

The act of issuing the ordered blood or derivative product of blood from the blood bank or blood product supplier to the recipient's point of care location or providing practitioner.

Attributes
AWM Load Info Sk
Blood Product Dk
Blood Product Order Dispense Fact Dk
Blood Product Order Dispense Sk
Current Ind
Dispensed By Practitioner Dk
Dispensed By Practitioner Sk
Dispensed Calendar Dk
Dispensed To Organization Dk
Dispensed To Organization Sk
Dispensed To Point Of Care Location Dk
Dispensed To Point Of Care Location Sk
Dispensed To Practitioner Dk
Dispensed To Practitioner Sk
Dispense Status Cd
Dispense Status Code Sk
Dispense Status Descr
Dispense Status Ts
DWM Load Info Sk
Effective From Dt
Effective To Dt
Observation Status Cd
Observation Status Code Sk
Observation Status Descr
Requested Dispense Amt Qty
Requested Dispense Qty
Requested Dispense UOM Cd
Requested Dispense UOM Code Sk
Requested Dispense UOM Descr
Source Cd
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Blood Product Order Dispense Fact_Practitioner Dimension_FK1
Blood Product Order Dispense Fact_Point Of Care Location Dimension_FK
Blood Product Order Dispense Fact_Organization Dimension_FK
Blood Product Order Dispense Fact_Blood Product Dimension_FK
Blood Product Order Dispense Fact_Calendar Dimension_FK
Blood Product Order Dispense Fact_Practitioner Dimension_FK

Primary Key
Blood Product Order Dispense Fact PK

Dependencies

Reverse Dependencies

Attribute Details

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

Blood Product 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Blood Product Order Dispense Fact 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	true

Blood Product Order Dispense Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dispensed By 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dispensed By Practitioner Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Dispensed 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dispensed To 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dispensed To Organization Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Dispensed To 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dispensed To Point Of Care Location Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Dispensed To 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Dispensed To Practitioner Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Dispense Status Cd

Description	Indicates the current status of the specified blood product as indicated by the filler or placer. For example, the first status change of a product that may trigger a Blood Product Dispense Status Message occurs when it first becomes linked to a patient and is ready to dispense. The placer system may use the Blood Product Dispense Status Message to request the transfusion service to dispense the product. When the blood product is delivered or issued to a patient, the status of the blood product would be changed to indicate that it has now been "dispensed." Examples: Value Description Comment RI Received into inventory (for specified patient) Status determined by Filler RD Reserved and ready to dispense Status determined by Filler RS Reserved (ordered and product allocated for the patient) Status determined by Filler RE Released (no longer allocated for the patient) Status determined by Placer or Filler DS Dispensed to patient location Status determined by Filler RA Returned unused/no longer needed Status determined by Filler RL Returned unused/keep linked to patient for possible use later Status determined by Filler WA Wasted (product no longer viable) Status determined by Filler PT Presumed transfused (dispensed and not returned) Status determined by Filler CR Released into inventory for general availability Status determined by Filler RQ Request to dispense blood product Status determined by Placer
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [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

Dispense Status Descr

Description	Indicates the current status of the specified blood product as indicated by the filler or placer. For example, the first status change of a product that may trigger a Blood Product Dispense Status Message occurs when it first becomes linked to a patient and is ready to dispense. The placer system may use the Blood Product Dispense Status Message to request the transfusion service to dispense the product. When the blood product is delivered or issued to a patient, the status of the blood product would be changed to indicate that it has now been "dispensed." Examples: Value Description Comment RI Received into inventory (for specified patient) Status determined by Filler RD Reserved and ready to dispense Status determined by Filler RS Reserved (ordered and product allocated for the patient) Status determined by Filler RE Released (no longer allocated for the patient) Status determined by Placer or Filler DS Dispensed to patient location Status determined by Filler RA Returned unused/no longer needed Status determined by Filler RL Returned unused/keep linked to patient for possible use later Status determined by Filler WA Wasted (product no longer viable) Status determined by Filler PT Presumed transfused (dispensed and not returned) Status determined by Filler CR Released into inventory for general availability Status determined by Filler RQ Request to dispense blood product Status determined by Placer
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
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

DWM 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

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

Observation Status Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
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. 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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Observation Status Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dispense 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

Requested Dispense 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

Requested Dispense UOM Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Dispense 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

Requested Dispense UOM Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
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	false
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 Fact_Practitioner Dimension_FK1

Is Identifying Relationship	false
Child Table	Blood Product Order Dispense Fact
Child Role Name	dispensed by
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

Blood Product Order Dispense Fact_Point Of Care Location Dimension_FK

Is Identifying Relationship	false
Child Table	Blood Product Order Dispense Fact
Child Role Name	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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Blood Product Order Dispense Fact_Organization Dimension_FK

Is Identifying Relationship	false
Child Table	Blood Product Order Dispense Fact
Child Role Name	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	Organization Dimension
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 Order Dispense Fact_Blood Product Dimension_FK

Is Identifying Relationship	false
Child Table	Blood Product Order Dispense Fact
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Blood Product Order Dispense Fact_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Blood Product Order Dispense Fact
Child Role Name	dispensed
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

Blood Product Order Dispense Fact_Practitioner Dimension_FK

Is Identifying Relationship	false
Child Table	Blood Product Order Dispense Fact
Child Role Name	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	Practitioner 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

Blood Product Order Dispense Fact PK

Key Attribute

Blood Product Order Dispense Fact Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model