# DW_CMP_SALARY_SIMPLE_COMPONENT_D

Captures salary data using Simple Components

## Details

Module: Compensation

## Key Columns

SIMPLE_SALARY_COMPONENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SIMPLE_SALARY_COMPONENT_ID | NUMBER | 38 | 0 | True | Simple Salary Component identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier |  |
SALARY_ID | NUMBER | 38 | 0 |  | Salary Identifier |  |
SALARY_BASIS_ID | NUMBER | 38 | 0 |  | Salary Basis Identifier |  |
DATE_FROM | DATE |  |  |  | Salary effective from |  |
DATE_TO | DATE |  |  |  | Salary Effective to |  |
SALARY_BASES_SIMPLE_COMPONENT_ID | NUMBER | 38 | 0 |  | Salary Basis Simple Component Identifier | DW_CMP_SALARY_BASES_SIMPLE_COMPONENT_SETUP_D | SIMPLE_SALARY_COMPONENT_SETUP_ID
AMOUNT | NUMBER |  |  |  | Simple Component Amount |  |
ANNUAL_AMOUNT | NUMBER |  |  |  | Annual Amount |  |
ANNUAL_FT_AMOUNT | NUMBER |  |  |  | Annualzied Ful Time Salary amount |  |
ADJUSTMENT_AMOUNT | NUMBER |  |  |  | Component Adjustment amount |  |
PREV_AMOUNT | NUMBER |  |  |  | Previous Component Amount |  |
PREV_ADJUSTMENT_AMOUNT | NUMBER |  |  |  | Previous Adjustment amount |  |
CURRENCY_CODE | VARCHAR2 | 32 |  |  | Currency |  |
FREQUENCY_CODE | VARCHAR2 | 32 |  |  | Frequency |  |
PERCENTAGE | NUMBER |  |  |  | Simple Component Percentage |  |
ADJUSTMENT_PERCENTAGE | NUMBER |  |  |  | Component Adjustment Percentage |  |
PREV_ADJUSTMENT_PERCENT | NUMBER |  |  |  | Previous Adjustment percentage |  |

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