Effective From DtEffective To DtLoad Info SkSource Code SkSpecimen SkSpecimen Type Modifier Code SkTenant SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | A codified term that augments the description of specimen type. For example: If the specimen type is 'venous blood' then 'capillary' can be added as a modifier to augment the description of the specimen type. |
| Attributes | |
| Effective From Dt |
|
| Effective To Dt |
|
| Load Info Sk |
|
| Source Code Sk |
|
| Specimen Sk |
|
| Specimen Type Modifier Code Sk |
|
| Tenant Sk |
|
| Valid From Ts |
|
| Valid To Ts |
|
| Relationship | |
 Specimen Type Modifier _Specimen_FK |
|
| Primary Key | |
 Specimen Type Modifier PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
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 |
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 |
Specimen Sk
| Description | Anchor surrogate key for the Specimen 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 |
Specimen Type Modifier Code Sk
| Description | A term abbreviation or acronym used to modify or qualify descriptions about the collected specimen and its associated specimen type. This is useful when the specimen type is too limiting in its description or does not provide the precision to absolutely describe the specimen. For example: If the specimen type is 'venous blood' then 'capillary' can be added as a modifier to augment the description of the specimen type. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | true |
| 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 |
Specimen Type Modifier _Specimen_FK
| Is Identifying Relationship | true |
| Child Table | Specimen Type Modifier |
| 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 | Specimen |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Specimen Type Modifier PK
| Key Attribute | Specimen Sk |
| Key Attribute | Specimen Type Modifier Code Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |