Overview Top Package Entity

Atomic Warehouse Model Data Model

---

Entity Group

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

Group Bk

Group Sk

Group Type Code Sk

Load Info Sk

Tenant Sk

Primary Key

Group PK

Dependencies

Reverse Dependencies

Attribute Details

 Group Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Group Sk

Description	Anchor surrogate key for the Group 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	true

---

 Group Type Code Sk

Description	This code identifies the specific category types - e.g. Patient Account.
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

---

 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

Primary Key Details

 Group PK

Key Attribute

Group Sk

---

Overview Top Package Entity

Atomic Warehouse Model Data Model