Parent-child relationship tables for Hierarchies - Modern UX
search cancel

Parent-child relationship tables for Hierarchies - Modern UX

book

Article ID: 259760

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Parent child relationship tables seem to be missing for Hierarchies of the Modern UX. We understand that ODF_HIERARCHIES and ODF_HIERARCHY_NODES are the two tables that contain data related to this functionality. But how to determine the various levels at which investments / projects are placed?

Environment

Version: 16.1.0.

Resolution

Parent-child relationship can be established with data present in the odf_hierarchy_nodes table itself.

  • Investments belonging to a hierarchy are represented by 'hierarchy_id' column
  • 'sequence' column represents the sequence in which an investment appears
  • 'parent_sequence' column represents the parent investment to a child investment. If this column holds -1, then it means that this investment does not have a parent
  • 'lvl' column provides the level of an investment within the hierarchy
  • If there are multiple branches, then 'nnb_sequence' provides the sequence number of an investment that diverges from the current branch

The column descriptions on this table provide further details.