DW_GRADE_RATE_CURRENT_D

It stores current records for Rate definitions.

Details

Module: Global Human Resources

Key Columns

RATE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATE_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_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
RATE_TYPE VARCHAR2 64 Stores rate type, whether it's Salary/Bonus
RATE_OBJECT_TYPE VARCHAR2 64 Stores type "GRADE"
RATE_UOM VARCHAR2 64 Unit of Measure for the rate. Defaulting with M(Money)
RATE_FREQUENCY VARCHAR2 64 Frequency of the rate : Annual/Monthly/Hourly
CURRENCY_CODE VARCHAR2 16 Currency Code for the rate
LEGISLATION_CODE VARCHAR2 64 Legislation code
ACTIVE_STATUS VARCHAR2 64 Status of the rate : Active/InActive
ANNUALIZATION_FACTOR NUMBER Annualization Factor value Eg : 1 for Annual, 12 for monthly, 2080 for hourly, manually provided value in the UI for Payroll period