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