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