Context CodeContext SkEffective From DtEffective To DtException SkException Value TxtInformation TxtLoad Info SkRelationship Type Code SkSource Code SkSub Context CodeTenant SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | An identified circumstance or parameter that a validity state process will run against. The intent is that it will only identify exceptions, not try to define behaviors and uses for them. The application component running checks for these exceptions will need to define these attributes of the exceptions. |
| Relationship | |
 Data Exception_Exception_FK |
|
| Primary Key | |
 Data Exception PK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Context Code
| Description | Eg: Encntr; Ptnt |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Context Sk
| Description | Surrogate key for a context. |
| 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 |
Exception Sk
| Description | Surrogate key for the anchor entity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Small [SHORT] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Exception Value Txt
| Description | A textual representation of the data exception value. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Information Txt
| Description | Further information about the exception. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| 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 |
Relationship Type Code Sk
| Description | Identifies the type of the relationship as defined in the business data model. |
| 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 |
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 |
Sub Context Code
| Description | Eg:Invalid Employee Number. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 |
Data Exception_Exception_FK
| Is Identifying Relationship | true |
| Child Table | Data Exception |
| 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 | Exception |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Data Exception PK
| Key Attribute | Context Sk |
| Key Attribute | Valid From Ts |
| Key Attribute | Exception Sk |
| Key Attribute | Relationship Type Code Sk |
| Atomic Warehouse Model Data Model |