This dimension captures the Compensation Hierarchy details
Module: Compensation
LVL_NUM, MGR_PERSON_EVENT_ID, EMP_PERSON_EVENT_ID
| 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.