It stores current records for Grade Rate values.
Module: Global Human Resources
RATE_VALUE_ID
| 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.