This dimension captures the Compensation Plan Component Information
Module: Compensation
COMPONENT_ID
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 |