Overview Top Package Entity

Atomic Warehouse Model Data Model

---

Entity Exception

Description

This is an anchor entity that anchors one or more detail entities. Relationships in AWM are created between anchor entities using associative entities.

Attributes

Context Code

Effective From Dt

Effective To Dt

Exception Code

Exception Descr

Exception Score Num

Exception Sk

In Force Ind

Load Info Sk

Sub Context Code

Tenant Sk

Valid From Ts

Valid To Ts

Primary Key

Exception PK

Dependencies

Reverse Dependencies

Attribute Details

 Context Code

Description	A code that indicates the context of the exception. For example: Encounter Patient
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

---

 Effective From Dt

Description	Business term establishing 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 Code

Description	Indicates the nature of the exception rule.
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

---

 Exception Descr

Description	A textual description that details the exception rule.
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

---

 Exception Score Num

Description	The numeric score that a failed exception process run for this exception rule is assigned. The score will indicate the type of exception, not necessarily its severity. The score should be a binary number (1, 2, 4, 8, and so on.)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
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

---

 In Force Ind

Description	Indicates if this exception is currently processed (in force) in the exception processing application.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
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

---

 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	A technical term establishing a period where a set of attributes are true in the source system. This would be populated with the transaction time stamp and would be used for 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

Primary Key Details

 Exception PK

Key Attribute

Exception Sk

---

Overview Top Package Entity

Atomic Warehouse Model Data Model