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