DW_LM_ACTIVITY_ALL_D (Preview)

This table requires activation of Learning Management functional area. Table to store Activities details along with Learning Item and Content details

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    
ACTIVITY_NUMBER VARCHAR2 999     Activity number    
DURATION NUMBER       Activity duration    
DURATION_UOM VARCHAR2 32     UOM of the activity duration    
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    
ACTIVITY_START_DATE_UTC TIMESTAMP       Activity Start Date in UTC Timezone    
ACTIVITY_END_DATE_UTC TIMESTAMP       Activity End Date in UTC Timezone    
TIME_ZONE VARCHAR2 128     Activity Time zone    
MASTERY_SCORE NUMBER       Mastery Score    

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