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?
Parent-child relationship can be established with data present in the odf_hierarchy_nodes table itself.
The column descriptions on this table provide further details.