Organization Hierarchy 
(Search and Analytics Model) Search and Analytics Model: 0GFN_OU_HIER
This search and analytics model is used to get the organization hierarchy attributes.
Technical Data
Model Usage | Application Model |
Software Component for Search and Analytics | GRCFND_A |
Root Node: Hierarchy header
Technical Name | HIERARCHY_HEADER |
DataSource | 0GFN_OU_GFNH_HIER |
Node Relationship: Hierarchy nodes
Node | HIERARCHY_ELEMENT |
Association | |
Cardinality | Arbitrary |
Reverse Cardinality | Exactly One |
Sub-query | Yes |
Foreign Key
Attribute of Parent Node | Value | Attribute of Child Node | Value | Join-Operator |
HEADERID | HEADERID | Equal |
Node Relationship: Node texts
Node | HIERARCHY_FOLDERTEXT |
Association | |
Cardinality | Arbitrary |
Reverse Cardinality | Exactly One |
Sub-query | No |
Foreign Key
Attribute of Parent Node | Value | Attribute of Child Node | Value | Join-Operator |
|---|---|---|---|---|
FOLDERNAME | FOLDERNAME | Equal | ||
HEADERID | HEADERID | Equal |
Node Relationship: GRC Organization Attributes
Node | 0GFN_OU.0GFN_OU_ATTR |
Association | HIERARCHY_ELEMENT20GFN_OU_ATTR |
Cardinality | Up to One |
Reverse Cardinality | Arbitrary |
Sub-query | No |
Foreign Key
Attribute of Parent Node | Value | Attribute of Child Node | Value | Join-Operator |
|---|---|---|---|---|
OBJID | OBJID | Equal | ||
TF_YEAR | TF_YEAR | Equal | ||
TIMEFRAME | TIMEFRAME | Equal |
Node Relationship: Header texts
Node | HIERARCHY_HEADERTEXT |
Association | |
Cardinality | Arbitrary |
Reverse Cardinality | Exactly One |
Sub-query | No |
Foreign Key
Attribute of Parent Node | Value | Attribute of Child Node | Value | Join-Operator |
|---|---|---|---|---|
HEADERID | HEADERID | Equal |