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

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