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     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

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