Entity Item Master

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

Attributes
Item Master BkItem Master Bk
Item Master SkItem Master Sk
Load Info SkLoad Info Sk
Tenant SkTenant Sk

Primary Key
Item Master PKItem Master PK

Dependencies
 

Reverse Dependencies
 

Attribute Details

 Item Master Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Item Master Sk
DescriptionThe generated surrogate key of the Item Master anchor.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Primary Key Details

 Item Master PK
Key AttributeItem Master Sk