LocationHierarchyLevel

Entity Definition

Logical Name : LocationHierarchyLevel
Physical Name : CO_LCN_HRC_LV

A designated level within a Location Hierarchy scheme. Level indicates the nesting of one location inside another. For example a FLOOR is a designated location level within a BUILDING. The assignment of location hierarchy levels is determined by the retailer

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
Parent (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)(PK) A token ID for a LocationHierarchy. It is to gurantee uniqueness ID_LCN_HRC Identity integer LocationHierarchy(CO_LCN_HRC)
HierarchyLevelNumber (PK) 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
Parent (FK) A token ID for a LocationHierarchy. It is to gurantee uniqueness ID_LCN_HRC_LV_PRNT Identity integer LocationHierarchyLevel(CO_LCN_HRC_LV)
LevelName Business name of this LocationHierarchyLevel. NM_HRC_LV DescriptionShort varchar(255)

Relationships

Parent Entity Verb Phrase Child Entity
LocationHierarchy defines hierarchy for LocationHierarchyLevel
LocationHierarchyLevel is nested in LocationHierarchyLevel
LocationHierarchyLevel defines level of AssociatedLocationHierarchyGroup
LocationHierarchyLevel is nested in LocationHierarchyLevel

Logical Views containing LocationHierarchyLevel

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