DW_CMP_SAL_BASIS_DET_METHOD_D_TL (Preview)

This table requires activation of Salary Basis functional area. This table contains information about code, name, and description for the ORA_CMP_SAL_BASIS_DET_METHOD related codes

Details

Module: Compensation

Key Columns

SAL_BASIS_DET_CODE, SAL_BASIS_DET_CODE_TYPE, LANGUAGE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SAL_BASIS_DET_CODE_TYPE VARCHAR2 128 True Code type. It is specific to functionality.
SAL_BASIS_DET_CODE VARCHAR2 128 True Code.
LANGUAGE VARCHAR2 64 True Translation language.
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of code type and code.
SAL_BASIS_DET_NAME VARCHAR2 128 Business name or value of the code.
SAL_BASIS_DET_DESCRIPTION VARCHAR2 256 Code description.