DW_LM_ELEARNING_ALL_D (Preview)

This table requires activation of Learning Management functional area. This table storea Elearning items information along with Learning Item details

Details

Module: Work Life

Key Columns

ELEARNING_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ELEARNING_ID NUMBER 38 0 True System generated unique 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
ELEARNING_NUMBER VARCHAR2 999 Elearning number
STATUS_CODE VARCHAR2 32 Elearning status code
ATTRIBUTION_PERSON_ID NUMBER 38 0 Person who published the Elearning
ELEARNING_TYPE VARCHAR2 512 This column is used to represents different elearning item types
LEARNING_ITEM_ID NUMBER 38 0 This column behaves as foriegn key and refers to parent table column
ENTERPRISE_ID NUMBER 38 0 Identifier of Enterprise
RELATED_CONTENT_ID NUMBER 38 0 This column holds value of content learning item identifier of ORA_CONTENT_ROOT learning item type