# DW_CMP_CWB_HRCHY_DH

This dimension captures the Compensation Hierarchy details

## Details

Module: Compensation

## Key Columns

MGR_PERSON_EVENT_ID, LVL_NUM, EMP_PERSON_EVENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
MGR_PERSON_EVENT_ID | NUMBER | 38 | 0 | True | Manager Person Event Id | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
EMP_PERSON_EVENT_ID | NUMBER | 38 | 0 | True | Employee Person Event Id | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
LVL_NUM | NUMBER | 38 | 0 | True | Hierarchy Level Number |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source Record Identifier |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group Identifier |  |
MGR_PERSON_ID | NUMBER | 38 | 0 |  | Manager Person Identifier | DW_PERSON_NAME_D | PERSON_ID
MGR_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Manager Assignment Identifier |  |
EMP_PERSON_ID | NUMBER | 38 | 0 |  | Employee Person Identifier | DW_PERSON_NAME_D | PERSON_ID
EMP_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Employee Assignment Identifier |  |
HRCHY_PLAN_ID | NUMBER | 38 | 0 |  | Hierarchy Plan Identifier |  |
HRCHY_PERIOD_ID | NUMBER | 38 | 0 |  | Hierarchy Period Identifier | DW_CMP_PLAN_PERIOD_D | PERIOD_ID

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