DW_CMP_SALARY_SIMPLE_COMPONENT_D (Preview)

This table requires activation of Salary Basis functional area. 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