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 This column is for Oracle Internal use only. 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