DW_SALARY_BASIS_D

It establishes the period of time for which an employee's salary is quoted.

Details

Module: Global Human Resources

Key Columns

SALARY_BASIS_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALARY_BASIS_ID NUMBER 38 0 True Primary Key sequence for Salary basis in Fusion Source.For translation refer table DW_SALARY_BASIS_D_TL joining with this id. DW_SALARY_BASIS_D_TL SALARY_BASIS_ID
SOURCE_RECORD_ID VARCHAR2 64     Unique Source Record Identifier This column contains SALARY_BASIS_ID.    
ANNUALIZED_HOURS NUMBER       Annualized Hours    
ELEMENT_TYPE_ID NUMBER 38 0   Element Type    
GRADE_RATE_ID NUMBER 38 0   Grade Rate Identifier. #1 DW_GRADE_RATE_D RATE_ID
SALARY_BASIS_CODE VARCHAR2 32     Salary Basis Code DW_CMP_SALARY_FREQUENCY_D_TL SALARY_BASIS_CODE
SALARY_ANNUALIZATION_FACTOR NUMBER       Salary Annualization factor    
SALARY_BASIS_TYPE VARCHAR2 32     Type of Salary Basis DW_CMP_SAL_BASIS_DET_METHOD_D_TL SAL_BASIS_DET_CODE
SALARY_BASIS_OBJECT_CODE VARCHAR2 128     Salary basis Object Code    
COMPONENT_USAGE VARCHAR2 32     Components Display behavior DW_CMP_COMPONENT_USAGE_D_TL COMPONENT_USAGE_CODE
STATUS VARCHAR2 32     Active/Inactive    
LEGISLATIVE_DATA_GROUP_ID NUMBER 38 0   Legislative data Group DW_LEGISLATIVE_DATA_GROUP_D LEGISLATIVE_DATA_GROUP_ID
RANGE_DIFF_ID NUMBER 38 0   Salary Range Differential identifier DW_CMP_RANGE_DIFF_D RANGE_DIFF_ID

Notes

#1 DW_GRADE_RATE_VALUE_D is date effective.