This table contains the details of node, its parent node and hierarchy level for each hierarchy version.
Module:
hierarchyversion, node
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| hierarchyversion | NUMBER | 38 | 0 | True | Hierarchy Version | DW_NS_MerchandiseHierarchyVersion_D | id |
| node | NUMBER | 38 | 0 | True | Merchandise Hierarchy Node | DW_NS_MerchandiseHierarchyNode_D | id |
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| parentnode | NUMBER | 38 | 0 | Parent Node | DW_NS_MerchandiseHierarchyNode_D | id | |
| hierarchylevel | NUMBER | 38 | 0 | Hierarchy Level | DW_NS_MerchandiseHierarchyLevel_D | id | |
| startdate | TIMESTAMP | Hierarchy Version Start Date | |||||
| enddate | TIMESTAMP | Hierarchy Version End Date | |||||
| path | VARCHAR2 | 999 | Path |
Copyright © 2019, 2026, Oracle and/or its affiliates.