DW_GRADE_RATE_D

It stores the Rate definitions for a specific Grade.

Details

Module: Global Human Resources

Key Columns

RATE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATE_ID NUMBER 38 0 True System generated primary key column DW_GRADE_RATE_D_TL RATE_ID
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_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, 2022, Oracle and/or its affiliates.