DW_GRADE_RATE_VALUE_D

It stores the Grade Rate values for a specific Grade.

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, 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    
EFFECTIVE_START_DATE DATE     True Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective    
EFFECTIVE_END_DATE DATE     True Date Effective Entity: indicates the date at the end of the date range within which the row is effective.    
SOURCE_RECORD_ID VARCHAR2 128     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.#1 DW_PAY_GRADE_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    

Notes

#1 DW_PAY_GRADE_D is date effective. Along with GRADE_ID join on dates.

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