PJF_EPS_HIERARCHIES_CF
PJF_EPS_HIERARCHIES_CF defines a column-flattened representation of the value-based trees represented in the PJF_EPS_HIERARCHIES. This table contain keys of each column-flattened level. It will have 10 levels of eps HIERARCHIES level.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_EPS_HIERARCHIES_CF_PK |
LEVEL0_NODE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STRUCTURE_ID | NUMBER | 18 | Yes | STRUCTURE_ID | |
| LEVEL0_NODE_ID | NUMBER | 18 | Yes | LEVEL0_NODE_ID is the Value of the 1st compoment of the primary key of the data source of the current node. LEVEL0_NODE_ID is the root node. EPS will indicate to store node Id of the EPS HIERARCHIES. | |
| LEVEL1_NODE_ID | NUMBER | 18 | LEVEL1_NODE_ID Value of the 2nd compoment of the NODE_ID of each node in the tree. | ||
| LEVEL2_NODE_ID | NUMBER | 18 | LEVEL2_NODE_ID Value of the 3rd compoment of the NODE_ID of each node in the tree. | ||
| LEVEL3_NODE_ID | NUMBER | 18 | LEVEL3_NODE_ID Value of the 4th compoment of the NODE_ID of each node in the tree. | ||
| LEVEL4_NODE_ID | NUMBER | 18 | LEVEL4_NODE_ID Value of the 5th compoment of the NODE_ID of each node in the tree. | ||
| LEVEL5_NODE_ID | NUMBER | 18 | LEVEL5_NODE_ID Value of the 6th compoment of the NODE_ID of each node in the tree. | ||
| LEVEL6_NODE_ID | NUMBER | 18 | LEVEL6_NODE_ID Value of the 7th compoment of the NODE_ID of each node in the tree. | ||
| LEVEL7_NODE_ID | NUMBER | 18 | LEVEL7_NODE_ID Value of the 8th compoment of the NODE_ID of each node in the tree. | ||
| LEVEL8_NODE_ID | NUMBER | 18 | LEVEL8_NODE_ID Value of the 9th compoment of the NODE_ID of each node in the tree. | ||
| LEVEL9_NODE_ID | NUMBER | 18 | LEVEL9_NODE_ID Value of the 10th compoment of the NODE_ID of each node in the tree. | ||
| LEVEL10_NODE_ID | NUMBER | 18 | LEVEL10_NODE_ID Value of the 11th compoment of the NODE_ID of each node in the tree. | ||
| DISTANCE | NUMBER | 18 | DISTANCE Distance of the current node of the tree from its ancestral root node; equivalent to the Distance column in Table1. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_EPS_HIERARCHIES_CF_N1 | Non Unique | FUSION_TS_TX_IDX | LAST_UPDATE_DATE |
| PJF_EPS_HIERARCHIES_CF_U1 | Unique | FUSION_TS_TX_IDX | LEVEL0_NODE_ID |
| PJF_EPS_HIERARCHIES_CF_U2 | Unique | FUSION_TS_TX_IDX | STRUCTURE_ID, LEVEL0_NODE_ID |