DW_LM_CLASS_ALL_D (Preview)

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

Details

Module: Work Life

Key Columns

EFFECTIVE_START_DATE, CLASS_ID, EFFECTIVE_END_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CLASS_ID NUMBER 38 0 True Class 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 Identifier of class    
CLASS_NUMBER VARCHAR2 32     Class number    
START_DATE DATE       Class Start Date    
END_DATE DATE       Class End Date    
STATUS_CODE VARCHAR2 32     Class status code    
ATTRIBUTION_PERSON_ID NUMBER 38 0   Person who published the Class    
ATTRIBUTION_TYPE VARCHAR2 32     Attribution type either Person or Specialist    
DURATION NUMBER       Estimated duration of the offering    
DURATION_UOM VARCHAR2 32     UOM of the Duration    
COORDINATOR_ID NUMBER 38 0   Coordinator Identifier    
PRIMARY_INSTRUCTOR_ID NUMBER 38 0   This column represents primary instructor for an offering    
REMAINING_SEATS NUMBER       Remaining Seats    
WAITLIST_MGMT_MODE VARCHAR2 256     Mode for managing waitlisted assignments    
ENABLE_WAITLIST VARCHAR2 16     Enable waitlist mode for learning assignments    
ENABLE_CAPACITY VARCHAR2 16     Enable capacity for learning item    
ENTERPRISE_ID NUMBER 38 0   Identifier of Enterprise    
RELATED_CONTENT_ID NUMBER 38 0   Related content id    
DELIVERY_MODE VARCHAR2 128     Delivery mode    
LOCATION_ID NUMBER 38 0   Location Id    
MINIMUM_ATTENDEES NUMBER       Minimum Attendees    
MAXIMUM_INTERNAL_ATTENDEES NUMBER       Maximum Internal Attendees    
MAXIMUM_ATTENDEES NUMBER       Maximum Attendees    

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