DW_LM_COURSE_ALL_D (Preview)

This table requires activation of Learning Management functional area. Table stores Course information along with Learning Item details

Details

Module: Work Life

Key Columns

EFFECTIVE_END_DATE, COURSE_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
COURSE_ID NUMBER 38 0 True Course 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    
LEARNING_ITEM_ID NUMBER 38 0   Learning Item Id    
COURSE_NUMBER VARCHAR2 999     Course number    
START_DATE DATE       Course Start Date    
END_DATE DATE       Course End Date    
STATUS_CODE VARCHAR2 32     Course status code    
ATTRIBUTION_PERSON_ID NUMBER 38 0   Person who published the Course    
MAXIMUM_ATTENDEES NUMBER       Maximum Attendees    
MAXIMUM_INTERNAL_ATTENDEES NUMBER       Maximum Internal Attendees    
MINIMUM_ATTENDEES NUMBER       Minimum Attendees    
EFFORT VARCHAR2 128     Effort    
EFFORT_UOM VARCHAR2 128     Effort UOM    
ENTERPRISE_ID NUMBER 38 0   Identifier of Enterprise    
MINIMUM_TRAINING_HOURS NUMBER       Minimum Training Hours    
MAXIMUM_TRAINING_HOURS NUMBER       Maximum Training Hours    

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