DW_CMP_SALARY_FREQUENCY_D_TL (Preview)

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

Details

Module: Compensation

Key Columns

SALARY_BASIS_CODE, LANGUAGE, SALARY_BASIS_CODE_TYPE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALARY_BASIS_CODE_TYPE VARCHAR2 128   True Code type. It is specific to functionality.    
SALARY_BASIS_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.    
SALARY_BASIS_NAME VARCHAR2 128     Business name or value of the code.    
SALARY_BASIS_DESCRIPTION VARCHAR2 256     Code description.    

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