DW_LM_CONTENT_D (Preview)

This table requires activation of Learning Management functional area. Table stores learning item content details

Details

Module: Work Life

Key Columns

EFFECTIVE_END_DATE, CONTENT_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTENT_ID NUMBER 38 0 True Content Id
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 Id
TRACKING_TYPE VARCHAR2 128 Tracking Type
PRICE NUMBER Price
CURRENCY VARCHAR2 128 Currency
MASTERY_SCORE NUMBER Mastery Score
ENTERPRISE_ID NUMBER 38 0 Enterprise Id
COMPLETION_ON_OPEN VARCHAR2 16 Indicates whether content should be marked complete upon open
RELATED_CONTENT_ID NUMBER 38 0 Stores related content id, ie questionnaire id
TIME_LIMIT NUMBER Stores time limit to complete content
TIME_LIMIT_UOM VARCHAR2 128 Time limit unit of measure
MAX_ATTEMPTS NUMBER Max attempts to retry content ie assessments