DW_GRADE_RATE_VALUE_CURRENT_D

It stores current records for Grade Rate values.

Details

Module: Global Human Resources

Key Columns

RATE_VALUE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATE_VALUE_ID NUMBER 38 0 True System generated primary key column
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier This column contains RATE_VALUE_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
RATE_ID NUMBER 38 0 Rate definition identifier
RATE_OBJECT_TYPE VARCHAR2 32 Stores type "GRADE"
RATE_OBJECT_ID NUMBER 38 0 Stores grade_id for grade rate value. DW_PAY_GRADE_CURRENT_D GRADE_ID
MINIMUM VARCHAR2 32 Stores minimum value for a grade rate
MAXIMUM VARCHAR2 32 Stores maximum value for a grade rate
MID_VALUE VARCHAR2 32 Stores mid value(a value between minimum and maximum) for a grade rate
LEGISLATION_CODE VARCHAR2 64 Legislation code