DW_MANAGER_REPORTEES_CF_DN_NSR_DH

Manager Reportees Hierarchy Column Flattened Denormalized Dimension

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, MANAGER_TYPE, LEVEL20_REPORTEE_ASSIGNMENT_ID, EFFECTIVE_START_DATE, MANAGER_ASSIGNMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
MANAGER_ASSIGNMENT_ID NUMBER 38 0 True Manager Assignment identifier    
LEVEL20_REPORTEE_ASSIGNMENT_ID NUMBER 38 0 True Identifies Level 20 Reportee's Assignment record    
EFFECTIVE_START_DATE DATE     True Start date    
EFFECTIVE_END_DATE DATE     True End date    
MANAGER_TYPE VARCHAR2 32   True Type of Manager    
SOURCE_RECORD_ID VARCHAR2 256     Functional key of records    
MANAGER_ID NUMBER 38 0   Manager person identifier DW_PERSON_D PERSON_ID
LEVEL20_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 20 Reportee's Person record DW_PERSON_D PERSON_ID
MANAGER_DISTANCE NUMBER 38 0   Distance of manager from reportee    
LEVEL1_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 1 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL1_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 1 Reportee's Assignment record    
LEVEL2_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 2 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL2_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 2 Reportee's Assignment record    
LEVEL3_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 3 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL3_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 3 Reportee's Assignment record    
LEVEL4_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 4 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL4_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 4 Reportee's Assignment record    
LEVEL5_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 5 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL5_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 5 Reportee's Assignment record    
LEVEL6_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 6 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL6_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 6 Reportee's Assignment record    
LEVEL7_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 7 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL7_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 7 Reportee's Assignment record    
LEVEL8_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 8 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL8_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 8 Reportee's Assignment record    
LEVEL9_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 9 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL9_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 9 Reportee's Assignment record    
LEVEL10_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 10 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL10_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 10 Reportee's Assignment record    
LEVEL11_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 11 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL11_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 11 Reportee's Assignment record    
LEVEL12_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 12 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL12_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 12 Reportee's Assignment record    
LEVEL13_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 13 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL13_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 13 Reportee's Assignment record    
LEVEL14_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 14 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL14_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 14 Reportee's Assignment record    
LEVEL15_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 15 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL15_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 15 Reportee's Assignment record    
LEVEL16_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 16 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL16_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 16 Reportee's Assignment record    
LEVEL17_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 17 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL17_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 17 Reportee's Assignment record    
LEVEL18_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 18 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL18_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 18 Reportee's Assignment record    
LEVEL19_REPORTEE_PERSON_ID NUMBER 38 0   Identifies Level 19 Reportee's Person record DW_PERSON_D PERSON_ID
LEVEL19_REPORTEE_ASSIGNMENT_ID NUMBER 38 0   Identifies Level 19 Reportee's Assignment record    
DW_DATE_FROM DATE       Warehouse Effective From Date for the Assignment Event. If Initial extract date is greater than EFFECTIVE_FROM_DATE then Initial extract date is used.    
DW_DATE_TO DATE       Warehouse Effective To Date for the Assignment Event. This is equal to EFFECTIVE_END_DATE    
DW_INITIAL_RECORD_IND NUMBER 38 0   This indicates whether the record is the first event for the assignment to be brought into the warehouse based on initial extract date set by user.