DW_CMP_RANGE_DIFF_D (Preview)

This table requires activation of Salary Basis functional area. Stores Salary range differential criteria

Details

Module: Compensation

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, RANGE_DIFF_ID

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     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, 2022, Oracle and/or its affiliates.