DW_CMP_CWB_HRCHY_DH

This dimension captures the Compensation Hierarchy details

Details

Module: Compensation

Key Columns

LVL_NUM, MGR_PERSON_EVENT_ID, 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     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