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