# 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.

Copyright © 2019, 2025, Oracle and/or its affiliates.