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

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