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

RANGE_DIFF_ID, LANGUAGE, EFFECTIVE_END_DATE, EFFECTIVE_START_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    
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     This column is for Oracle Internal use only. Unique Source Record Identifier    
NAME VARCHAR2 256     Name of Salary Range Differential Profile    
DESCRIPTION VARCHAR2 512     Description of Salary Range Differential Profile    

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