DW_CMP_SALARY_COMPONENT_D (Preview)

This table requires activation of Salary Basis functional area. Holds Salary by Components

Details

Module: Compensation

Key Columns

SALARY_COMPONENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALARY_COMPONENT_ID NUMBER 38 0 True Primary Key for Salary Components in Fusion Source.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier
SALARY_ID NUMBER 38 0 Salary Identifier
CHANGE_AMOUNT NUMBER Component Amount change
CHANGE_PERCENTAGE NUMBER Component % change
COMPONENT_REASON_CODE VARCHAR2 32 Component code DW_CMP_SALARY_COMPONENTS_D_TL SALARY_COMPONENTS_CODE