# DW_CMP_RANGE_DIFF_D

Stores Salary range differential criteria

## Details

Module: Compensation

## Key Columns

RANGE_DIFF_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
RANGE_DIFF_ID | NUMBER | 38 | 0 | True | Salary Range Differential Profile Identifier | DW_CMP_RANGE_DIFF_D_TL | RANGE_DIFF_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 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier |  |
RANGE_DIFF_CODE | VARCHAR2 | 128 |  |  | Salary Range Differential Profile Code |  |
CRITERIA | VARCHAR2 | 32 |  |  | Criteria - Location, Business Unit, Compensation Zone |  |
STATUS | VARCHAR2 | 32 |  |  | Status of the profile |  |
GEOGRAPHY_TYPE_ID | NUMBER | 38 | 0 |  | Zone type id | DW_CMP_ZONE_TYPE_D_TL | GEOGRAPHY_TYPE_ID
PROCESS_WFH_FLAG | VARCHAR2 | 16 |  |  | Work from home considertation |  |
ADDRESS_TYPE1 | VARCHAR2 | 32 |  |  | If WFH is yes, what type of address has to be considered |  |
ADDRESS_TYPE2 | VARCHAR2 | 32 |  |  | If WFH is yes, what type of address has to be considered |  |
ADDRESS_TYPE3 | VARCHAR2 | 32 |  |  | If WFH is yes, what type of address has to be considered |  |
RANGE_DIFF_TYPE | VARCHAR2 | 32 |  |  | Recalcualtion logic : Factor or Grade Rate |  |

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