DW_CMP_PLAN_D

This dimension captures the Plan Details

Details

Module: Compensation

Key Columns

PLAN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_ID NUMBER 38 0 True Plan Identifier    
SOURCE_RECORD_ID NUMBER 38 0   Source Record Identifier    
STATUS_CODE VARCHAR2 32     Plan Status Code DW_CMP_PLAN_STATUS_D_TL PLAN_STATUS_CODE
ANNUALIZATION_FACTOR NUMBER       Plan Annualization Factor    
CORPORATE_CURRENCY VARCHAR2 16     Corporate Currency of the Plan    
BUSINESS_GROUP_ID NUMBER 38 0   Business Group Identifier    
APPROVAL_MODE VARCHAR2 32     Approval Mode of the Plan DW_CMP_APPROVAL_MODE_D_TL APPROVAL_MODE_CODE
SUBMIT_MODE VARCHAR2 32     Submit Mode of the Plan DW_CMP_SUBMIT_MODE_D_TL SUBMIT_MODE_CODE
COMP_TYPE VARCHAR2 32     Component Type of the Plan DW_CMP_COMP_TYPE_D_TL COMP_TYPE_CODE
FREQUENCY VARCHAR2 32     Frequency of the Plan DW_CMP_PLAN_FREQUENCY_D_TL PLAN_FREQUENCY_CODE