DW_CXS_ACTIVITY_SUBTYPE_D_TL

This table stores Activity Subtype Details

Details

Module:

Key Columns

ACTIVITY_SUBTYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACTIVITY_SUBTYPE_ID NUMBER 38 0 True The unique identifier for the activity.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System
ACTIVITY_SUBTYPE_CODE VARCHAR2 64 ACTIVITY_SUBTYPE_CODE
ACTIVITY_TYPE_CODE VARCHAR2 32 ACTIVITY_TYPE_CODE
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
DEFAULT_FLAG VARCHAR2 32 DEFAULT_FLAG
ENABLED_FLAG VARCHAR2 32 ENABLED_FLAG
END_DATE_ACTIVE DATE END_DATE_ACTIVE
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
START_DATE_ACTIVE DATE START_DATE_ACTIVE
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
ACTVYS_TYPE_TL_LANGUAGE VARCHAR2 32
ACTVYS_TYPE_TL_MEANING VARCHAR2 128
ACTVYS_TYPE_TL_SOURCE_LANG VARCHAR2 32