DW_CMP_RANGE_DIFF_VALUES_D (Preview)

This table requires activation of Salary Basis functional area. Stores multiplier that used to automatically adjust the person's salary metrics by location, business unit and zone

Details

Module: Compensation

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, RANGE_DIFF_VALUE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RANGE_DIFF_VALUE_ID NUMBER 38 0 True Salary Range Differential Profile Detail Identifier    
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    
RANGE_DIFF_ID NUMBER 38 0   Salary Range Differential Profile Identifier DW_CMP_RANGE_DIFF_D RANGE_DIFF_ID
LOCATION_ID NUMBER 38 0   Location identifier DW_WORKER_LOCATION_D LOCATION_ID
JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
BUSINESS_UNIT_ID NUMBER 38 0   Business Unit indentifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
GEOGRAPHY_ID NUMBER 38 0   Geography identifier DW_CMP_ZONE_D_TL GEOGRAPHY_ID
DIFFERENTIAL NUMBER       Differential value    
GRADE_RATE_ID NUMBER 38 0   Replacable Grade rate DW_GRADE_RATE_D RATE_ID
GRADE_RATE_MINIMUM_LIMIT NUMBER       Minium value for the grade rate    
FREQUENCY VARCHAR2 32     Frequency of that grade rate    
ANNUALIZATION_FACTOR NUMBER       Annualization factor value    

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