# 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

Copyright © 2019, 2025, Oracle and/or its affiliates.