DW_POSITION_CF_TD_DH (Preview)
This table requires activation of Position Management functional area. Position Hierarchy top down Column Flattened Dimension
Details
Module: Global Human Resources
Key Columns
EFFECTIVE_END_DATE, LEAF_POSITION_ID, EFFECTIVE_START_DATE, POSITION_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| POSITION_ID | NUMBER | 38 | 0 | True | Parent Position Identifier | ||
| EFFECTIVE_START_DATE | DATE | True | Start Date | ||||
| EFFECTIVE_END_DATE | DATE | True | End date | ||||
| LEAF_POSITION_ID | NUMBER | 38 | 0 | True | Last child position at the hierarchy level | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. Unique source Identifer | ||||
| TOP_LEVEL_POSITION_ID | NUMBER | 38 | 0 | Top child position at the hierarchy level | |||
| POSITION_DISTANCE | NUMBER | 38 | 0 | Position hierarchy level | |||
| LEVEL1_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 1 Position record | |||
| LEVEL2_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 2 Position record | |||
| LEVEL3_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 3 Position record | |||
| LEVEL4_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 4 Position record | |||
| LEVEL5_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 5 Position record | |||
| LEVEL6_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 6 Position record | |||
| LEVEL7_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 7 Position record | |||
| LEVEL8_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 8 Position record | |||
| LEVEL9_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 9 Position record | |||
| LEVEL10_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 10 Position record | |||
| LEVEL11_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 11 Position record | |||
| LEVEL12_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 12 Position record | |||
| LEVEL13_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 13 Position record | |||
| LEVEL14_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 14 Position record | |||
| LEVEL15_POSITION_ID | NUMBER | 38 | 0 | Identifies Level 15 Position record |