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_START_DATE, TOP_LEVEL_POSITION_ID, EFFECTIVE_END_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    
TOP_LEVEL_POSITION_ID NUMBER 38 0 True Top child position at the hierarchy level    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. Unique source Identifer    
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    

Copyright © 2019, 2024, Oracle and/or its affiliates.