DW_CMP_SALARY_BASES_SIMPLE_COMPONENT_D (Preview)

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

Details

Module: Compensation

Key Columns

SALARY_BASES_SIMPLE_COMPONENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALARY_BASES_SIMPLE_COMPONENT_ID NUMBER 38 0 True Salary basis Simple Component identifier
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier
SALARY_BASIS_ID NUMBER 38 0 Salary Basis Identifier
SIMPLE_COMPONENT_CODE VARCHAR2 32 Simple Component Code
COMPONENT_TYPE VARCHAR2 32 Simple Component Type
OVERALL_SALARY_IMPACT VARCHAR2 32 Effect on Overall Salary
OPTIONAL_FLAG VARCHAR2 32 Mandatory / Optional
BASE_COMPONENT_CODE VARCHAR2 32 Base Component used to apply Percentage