DW_LM_LEARNING_ITEM_D (Preview)

This table requires activation of Learning Management functional area. This table stores the learning item information

Details

Module: Work Life

Key Columns

EFFECTIVE_END_DATE, LEARNING_ITEM_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEARNING_ITEM_ID NUMBER 38 0 True Learning Item Identifier
EFFECTIVE_START_DATE DATE True Effective start date
EFFECTIVE_END_DATE DATE True Effective end date
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique record identifier
ATTRIBUTION_ID NUMBER 38 0 Identifier of a person,community etc responsible for creating the learning item
ATTRIBUTION_PERSON_ID NUMBER 38 0 Populates when the attribution id is a person id
ATTRIBUTION_TYPE VARCHAR2 32 indicates the type of attribution such as person, community etc
ENTERPRISE_ID NUMBER 38 0 Identifier of Enterprise
LEARNING_ITEM_TYPE VARCHAR2 64 Type of learning item
LEARNING_ITEM_SUB_TYPE VARCHAR2 32 Learning Item sub type for the learning item type like ELearning. eg: Tutorial, Video etc.
LEARNING_ITEM_NUMBER VARCHAR2 999 Learning item number
STATUS VARCHAR2 32 Current status of the learning item
DURATION NUMBER Video section duration or description duration for non-video section.
DURATION_UOM VARCHAR2 32 Duration unit of measurement
START_DATE TIMESTAMP Start Date
END_DATE TIMESTAMP End Date