DW_CMP_SALARY_RATE_COMPONENT_D (Preview)

This table requires activation of Salary Basis functional area. Captures salary data using Rate Components

Details

Module: Compensation

Key Columns

RATE_SALARY_COMPONENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATE_SALARY_COMPONENT_ID NUMBER 38 0 True Salary pay rate 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
RATE_DEFINITION_ID NUMBER 38 0 Rate Definition Identifier DW_CMP_RATE_DEFINITION_D RATE_DEFINITION_ID
RATE_AMOUNT NUMBER Rate Amount
RATE_ANNUAL_AMOUNT NUMBER Rate Annual Amount
RATE_ANNUAL_FT_AMOUNT NUMBER Rate Annualized Full Time Amount
RATE_CURRENCY_CODE VARCHAR2 32 Rate Currency
RATE_PERIODICITY_CODE VARCHAR2 32 Rate Frequency
RATE_FACTOR NUMBER Rate Percentage