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

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