DW_LM_ACTIVITY_D (Preview)

This table requires activation of Learning Management functional area. Table to store details of activities in a class

Details

Module: Work Life

Key Columns

EFFECTIVE_END_DATE, ACTIVITY_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACTIVITY_ID NUMBER 38 0 True Activity Identifier
EFFECTIVE_START_DATE DATE True Indicates the date at the beginning of the date range within which the row is effective
EFFECTIVE_END_DATE DATE True Indicates the date at the end of the date range within which the row is effective
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
LEARNING_ITEM_ID NUMBER 38 0 Learning Item Identifier
PARENT_LEARNING_ITEM_ID NUMBER 38 0 The learning item that this activity is the child of
RELATED_CONTENT_ID NUMBER 38 0 Related content identifier
COMPLETION_TYPE VARCHAR2 128 Indicate the completion type of this activity (Required, Optional)
DUE_TIMESTAMP TIMESTAMP Indicates the due date of the activity
ACTIVITY_TYPE VARCHAR2 128 Indicates what type of activity this is
CONTENT_TYPE VARCHAR2 128 Indicates what type of content
ENTERPRISE_ID NUMBER 38 0 Identifier of Enterprise
SELF_COMPLETE_FLAG VARCHAR2 16 Flag to indicate if the learner able to mark this activity complete
TIME_ZONE VARCHAR2 128 Activity Time zone