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 This column is for Oracle Internal use only. 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.