DW_CMP_RANGE_DIFF_D_TL (Preview)

This table requires activation of Salary Basis functional area. Stores Salary range differential profiles transalated names

Details

Module: Compensation

Key Columns

LANGUAGE, 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    
LANGUAGE VARCHAR2 16   True Translation language    
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    
NAME VARCHAR2 256     Name of Salary Range Differential Profile    
DESCRIPTION VARCHAR2 512     Description of Salary Range Differential Profile    

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