PER_POS_HRCHY_DESCENDANTS_GT
Descendants Global Temp Table for storing the Descendants of a Position Hierarchy Node
Details
-
Schema: FUSION
-
Object owner: PER
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Precision | Comments |
|---|---|---|---|
| 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 |