AssociatedLocationHierarchyGroup

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)

Relationships

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