It establishes the period of time for which an employee's salary is quoted.
Module: Global Human Resources
SALARY_BASIS_ID
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 |
#1 DW_GRADE_RATE_VALUE_D is date effective.
Copyright © 2019, 2022, Oracle and/or its affiliates.