# DW_CMP_CWB_HRCHY_CF_DN

This dimension captures the flattened Compensation Hierarchy details

## Details

Module: Compensation

## Key Columns

TOP_PLAN_ID, TOP_MGR_PERSON_EVENT_ID, TOP_PERIOD_ID, LEVEL15_PERSON_EVENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
TOP_MGR_PERSON_EVENT_ID | NUMBER | 38 | 0 | True | Top Manager Person Event Id | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
TOP_PLAN_ID | NUMBER | 38 | 0 | True | Top Manager Plan Id | DW_CMP_PLAN_D | PLAN_ID
TOP_PERIOD_ID | NUMBER | 38 | 0 | True | Top Manager Period Id | DW_CMP_PLAN_PERIOD_D | PERIOD_ID
LEVEL15_PERSON_EVENT_ID | NUMBER | 38 | 0 | True | Identifies Level 15 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source Record Identifier |  |
TOP_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Top Manager Person Id | DW_PERSON_NAME_D | PERSON_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier |  |
LEVEL1_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 1 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL1_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 1 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL2_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 2 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL2_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 2 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL3_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 3 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL3_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 3 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL4_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 4 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL4_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 4 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL5_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 5 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL5_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 5 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL6_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 6 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL6_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 6 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL7_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 7 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL7_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 7 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL8_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 8 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL8_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 8 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL9_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 9 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL9_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 9 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL10_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 10 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL10_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 10 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL11_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 11 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL11_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 11 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL12_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 12 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL12_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 12 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL13_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 13 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL13_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 13 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL14_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Identifies Level 14 Manager's Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LEVEL14_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 14 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID
LEVEL15_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Identifies Level 15 Manager's Person Identifier | DW_PERSON_NAME_D | PERSON_ID

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