DW_CMP_SALARY_COMPONENTS_D_TL

This table contains information about code, name, and description for the CMP_SALARY_COMPONENTS related codes

Details

Module: Compensation

Key Columns

SALARY_COMPONENTS_CODE, LANGUAGE, SALARY_COMPONENTS_CODE_TYPE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALARY_COMPONENTS_CODE_TYPE VARCHAR2 128   True Code type. It is specific to functionality.    
SALARY_COMPONENTS_CODE VARCHAR2 128   True Code.    
LANGUAGE VARCHAR2 64   True Translation language.    
SOURCE_RECORD_ID VARCHAR2 512     Source record identifier. Value is derived from a combination of code type and code.    
SALARY_COMPONENTS_NAME VARCHAR2 2048     Business name or value of the code.    
SALARY_COMPONENTS_DESCRIPTION VARCHAR2 4000     Code description.