Blood Product Order Dispense SkBlood Product Order SkDispense Status TsLoad Info SkTenant Sk
| Atomic Warehouse Model Data Model |
| Description | An association entity to join the blood product order with the practitioners for dispensed to and dispensing, dispensed to location, dispensed to address, blood component special testings, and dispensed to organization if any. |
| Attributes | |
| Blood Product Order Dispense Sk |
|
| Blood Product Order Sk |
|
| Dispense Status Ts |
|
| Load Info Sk |
|
| Tenant Sk |
|
| Relationship | |
 Blood Product Order Dispense_Blood Product Order_FK |
|
| Primary Key | |
 Blood Product Order Dispense PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
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 Order Sk
| Description | Anchor surrogate key for the Blood Product Order data. |
| 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 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 |
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 |
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 |
| Relationship Details |
Blood Product Order Dispense_Blood Product Order_FK
| Is Identifying Relationship | false |
| Child Table | Blood Product Order 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 |
| Primary Key Details |
Blood Product Order Dispense PK
| Key Attribute | Blood Product Order Dispense Sk |
| Atomic Warehouse Model Data Model |