# DW_MANAGER_REPORTEES_CF_DN_DH

Manager Reportees Hierarchy Column Flattened Denormalized Dimension

## Details

Module: Global Human Resources

## Key Columns

MANAGER_TYPE, MANAGER_ASSIGNMENT_ID, LEVEL20_REPORTEE_ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

## 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 |  |  | This column is for Oracle Internal use only. 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. |  |

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