PER_POS_HRCHY_ANCESTORS_GT
Ancestors Global Temp Table for storing the Ancestors of a Position Hierarchy Node
Details
-
Schema: FUSION
-
Object owner: PER
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| ROW_ID | VARCHAR2 | 30 | Row ID | |
| POSITION_ID | NUMBER | 18 | Position ID | |
| EFFECTIVE_START_DATE | DATE | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| NODE_LEVEL | NUMBER | 3 | Node :Level |