Blood Product Order SkEffective From DtEffective To DtLoad Info SkProcessing Requirement Code SkProcessing Requirement SeqSource Code SkTenant SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | A list of instructions about how the blood product is to be treated before transfusion. This is usually specified by the ordering practitioner. For example: Irradiated Washed Thawed |
| Attributes | |
| Blood Product Order Sk |
|
| Effective From Dt |
|
| Effective To Dt |
|
| Load Info Sk |
|
| Processing Requirement Code Sk |
|
| Processing Requirement Seq |
|
| Source Code Sk |
|
| Tenant Sk |
|
| Valid From Ts |
|
| Valid To Ts |
|
| Relationship | |
 Blood Product Processing Requirement_Blood Product Order_FK |
|
| Primary Key | |
 Blood Product Processing Requirement PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
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 | true |
| 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 |
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 |
Processing Requirement Code Sk
| Description | Indicates the blood product treatment that must be completed before the product is transfused. This is usually specified by the healthcare practitioner and is based on the patient's medical condition. For Example: LR Leukoreduced IR Irradiated CS CMV Safe FR Fresh unit AU Autologous Unit DI Directed Unit HL HLA Matched CM CMV Negative HB Hemoglobin S Negative WA Washed IG IgA Deficient |
| 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 |
Processing Requirement Seq
| Description | For the first occurrence, the sequence number shall be 1; for the second it shall be 2; and so on. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | true |
| 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 | 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 Processing Requirement_Blood Product Order_FK
| Is Identifying Relationship | true |
| Child Table | Blood Product Processing Requirement |
| 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 Processing Requirement PK
| Key Attribute | Blood Product Order Sk |
| Key Attribute | Processing Requirement Seq |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |