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

ACTIVITY_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_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    

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