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

CLASS_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_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 999 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