This dimension captures Worksheet Approval Details
Module: Compensation
APPROVAL_HISTORY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| APPROVAL_HISTORY_ID | NUMBER | 38 | 0 | True | Approval History Identifier | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Source Record Identifier | |||
| BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business Unit Identifier | |||
| MGR_PERSON_EVENT_ID | NUMBER | 38 | 0 | Manager Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID | |
| EMP_PERSON_EVENT_ID | NUMBER | 38 | 0 | Employee Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID | |
| MGR_ASSIGNMENT_ID | NUMBER | 38 | 0 | Manager Assignment Identifier | |||
| POOL_ID | NUMBER | 38 | 0 | Pool Identifier | DW_CMP_BUDGET_POOL_D | BUDGET_POOL_ID | |
| ACTION_CODE | VARCHAR2 | 32 | Action Code | DW_CMP_WORKSHEET_STATUS_D_TL | WORKSHEET_STATUS_CODE | ||
| ACTION_DATE | TIMESTAMP | Action Date |
Copyright © 2019, 2025, Oracle and/or its affiliates.