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     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          

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