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

EFFECTIVE_END_DATE, RANGE_DIFF_ID, EFFECTIVE_START_DATE, LANGUAGE

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