DW_XLA_EVENT_TYPES_LKP_TL

Stores Event Types Name and Description

Details

Module:

Key Columns

ENTITY_CODE, EVENT_TYPE_CODE, EVENT_CLASS_CODE, APPLICATION_ID, LANGUAGE

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.