This dimension captures the flattened Compensation Hierarchy details
Module: Compensation
LEVEL15_PERSON_EVENT_ID, TOP_MGR_PERSON_EVENT_ID, TOP_PLAN_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 | This column is for Oracle Internal use only. 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, 2025, Oracle and/or its affiliates.