This dimension captures the flattened Compensation Hierarchy details
Module: Compensation
TOP_PLAN_ID, TOP_MGR_PERSON_EVENT_ID, LEVEL15_PERSON_EVENT_ID, TOP_PERIOD_ID
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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.