DW_XLA_EVENT_TYPES_LKP_TL

Stores Event Types Name and Description

Details

Module:

Key Columns

ENTITY_CODE, LANGUAGE, EVENT_TYPE_CODE, EVENT_CLASS_CODE, APPLICATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
APPLICATION_ID NUMBER 38 0 True Functional area within a software suite of products.    
EVENT_TYPE_CODE VARCHAR2 32   True Unique abbreviated name assigned to an event type.    
ENTITY_CODE VARCHAR2 32   True Unique abbreviated name assigned to an entity.    
LANGUAGE VARCHAR2 16   True Indicates the code of the language into which the contents of the translatable columns are translated.    
EVENT_CLASS_CODE VARCHAR2 32   True Unique abbreviated name assigned to an event class.    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Source Record Identifier . It is a unique combination of EVENT_TYPE_CODE, EVENT_CLASS_CODE, ENTITY_CODE, LANGUAGE    
EVENT_TYPE_NAME VARCHAR2 128     Classification of events that determines the revenue and invoice effect of an event. Typical event types include Milestones, Scheduled Payments, and Write-Offs.    
EVENT_TYPE_DESCRIPTION VARCHAR2 256     Additional information associated with the classification of events that determines the revenue and invoice effect of an event. Typical event types include Milestones, Scheduled Payments, and Write-Offs.    

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