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_START_DATE, CONTENT_ID, EFFECTIVE_END_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    

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