DW_CMP_COMPONENT_USAGE_D_TL (Preview)

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

Details

Module: Compensation

Key Columns

COMPONENT_USAGE_CODE, COMPONENT_USAGE_CODE_TYPE, LANGUAGE

Columns

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

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