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 | 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.