Current Manager Reportees Hierarchy Column Flattened Denormalized Dimension
Module: Global Human Resources
MANAGER_ASSIGNMENT_ID, MANAGER_TYPE, LEVEL20_REPORTEE_ASSIGNMENT_ID
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 | ||
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 |