# DW_CMP_CWB_APPROVAL_HISTORY_D

This dimension captures Worksheet Approval Details

## Details

Module: Compensation

## Key Columns

APPROVAL_HISTORY_ID

## Columns

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