DW_CMP_RATE_DEFINITION_D_TL (Preview)

This table requires activation of Salary Basis functional area. Captures Rate Definition name and description

Details

Module: Compensation

Key Columns

EFFECTIVE_END_DATE, RATE_DEFINITION_ID, EFFECTIVE_START_DATE, LANGUAGE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATE_DEFINITION_ID NUMBER 38 0 True Rate definition Identifier
EFFECTIVE_START_DATE DATE True Effective Start date
EFFECTIVE_END_DATE DATE True Effective End date
LANGUAGE VARCHAR2 32 True Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
RATE_DEFINITION_NAME VARCHAR2 256 Rate Definition Name
RATE_DEFINITION_DESCRIPTION VARCHAR2 999 Rate Definition Code