Entity Definition

Logical Name : AssociatedLocationHierarchyGroup
Physical Name : ST_ASCTN_LCN_HRC_GP

Associates two LocationHierarchyGroups together as paraent and child pairings to create a hierarchy.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AssociatedLocationHierarchyGroupID (PK) Token ID for this association instance. ID_ASCTN_LCN_HRC_GP Identity integer
HierarchyLevelNumber (FK) Whole number value to indicate relative position of a level within the hierarchy. In ARTS LEVEL 0 is the root. Level 1 is the next lower level, etc. As the value increases it indicates that the levels are getting deeper towards the leaf level which has the highest value. IC_HRC_LV_NMB LineNumber smallint LocationHierarchyLevel(CO_LCN_HRC_LV)
LocationHierarchyID (FK) A token ID for a LocationHierarchy. It is to guarantee uniqueness ID_LCN_HRC Identity integer LocationHierarchyLevel(CO_LCN_HRC_LV)
Nested (FK) Token ID for a LocationHierarchyGroup. ID_CHLD_LCN_HRC_GP Identity integer LocationHierarchyGroup(CO_LCN_HRC_GP)
Parent (FK) Token ID for a LocationHierarchyGroup. ID_PRNT_LCN_HRC_GP Identity integer LocationHierarchyGroup(CO_LCN_HRC_GP)
EffectiveDate Date this association is effective. DT_EF EffectiveDate date
ExpirationDate Date this association is no longer effective DT_EP ExpirationDate date
StatusCode A code that indicates if this associationis ACTIVE or INACTIVE. Valid values are A and I. CD_STS Code2Status char(2)


Parent Entity Verb Phrase Child Entity
LocationHierarchyLevel defines level of AssociatedLocationHierarchyGroup
LocationHierarchyGroup contains AssociatedLocationHierarchyGroup
LocationHierarchyGroup is nested in AssociatedLocationHierarchyGroup

Logical Views containing AssociatedLocationHierarchyGroup

Logical View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View