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