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 This column is for Oracle Internal use only. 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