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 | 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 |