DW_SALARY_BASES_COMPONENT_D (Preview)

This table requires activation of Salary Basis functional area. Stores Components associated to the Salary Bases

Details

Module: Compensation

Key Columns

SALARY_BASES_COMPONENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALARY_BASES_COMPONENT_ID NUMBER 38 0 True Primary Key sequence for Salary bases Component in Fusion Source.    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Unique Source Record Identifier This column contains SALARY_BASIS_ID.    
SALARY_BASIS_ID NUMBER 38 0   Salary Basis ID DW_SALARY_BASIS_D SALARY_BASIS_ID
COMPONENT_CODE VARCHAR2 32     Component CODE    
ORDER_NUM NUMBER       Component display order in a salary basis    

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