DW_CMP_PLAN_COMPONENT_D

This dimension captures the Compensation Plan Component Information

Details

Module: Compensation

Key Columns

COMPONENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
COMPONENT_ID NUMBER 38 0 True Component Identifier    
SOURCE_RECORD_ID NUMBER 38 0   Source Record Identifier    
PLAN_ID NUMBER 38 0   Plan Identifier DW_CMP_PLAN_D PLAN_ID
PERIOD_ID NUMBER 38 0   Plan Period Identifier DW_CMP_PLAN_PERIOD_D PERIOD_ID
POOL_ID NUMBER 38 0   Budget Pool Identifier DW_CMP_BUDGET_POOL_D BUDGET_POOL_ID
CURRENCY_DETERMINATION_CODE VARCHAR2 32     Currency Determination Code DW_CMP_CURR_DETERMINATION_D_TL CURR_DETERMINATION_CODE
POST_AS_SALARY_FLAG VARCHAR2 16     Indicates whether the component is to be posted as salary    
SALARY_COMPONENT VARCHAR2 32     Salary Component    
COMP_TYPE VARCHAR2 32     Compensation Type    
NON_MONETARY_UOM VARCHAR2 32     Non Monetary Unit of Measure DW_CMP_NONMONETARY_UOM_D_TL NONMONETARY_UOM_CODE