A scheduled offering is a course that has been scheduled to take place at a particular time and place. For example, if you schedule an orientation course every month, then the single orientation course has twelve scheduled offerings per year. It is offered in January, February, March, and so on.

Table-Specific Information

Select

The driver uses the SAPSuccessFactorsLMS API to process WHERE clause conditions that are built with the following columns and operators:

• ScheduleID supports the = comparison operator.

The driver processes other filters client-side within the driver.

Columns

Name	Type	References	Required for Select	Description
ScheduleID [KEY]	Long		True	The unique ID of a scheduled offering. A scheduled offering is an instance of a learning item (a course, usually) that is scheduled to take place at a given date and time. Therefore, although the learning item ID is the same for its January and February scheduled offerings (for example), the scheduled offering ID of the January instance is different from the February instance.
ActivityOrComponentID	String			The unique ID of a learning item.
AvailableSeatCount	Long			The number of available seats left in the scheduled offering (the number of users who can still enroll in the scheduled offering).
Comments	String			This are the comments provided by the user in the comments field for each section.
ComponentTypeID	String			Item type IDs are a critical categorization in because they determine how users are marked complete for a learning item. One item type can have completion statuses of pass and fail while another might have completion statuses of pass, fail and incomplete.
Contact	String			The person or group who can be contacted about this entity. For example, someone to call about details for a scheduled offering.
Description	String			A description of the entity. In most cases, the description is available to users to tell them about the entity.
DisplayInScheduleTimeZone	Bool			If this value is true, then the times of the entity are in the scheduled offering time zone. If this value is false, then the times are in the users' time zones.
EmailAddress	String			The email address of a person or group (distribution list) who can be contacted about this entity. For example, a distribution list of people who know about a scheduled offering.
EnrolledCount	Long			The number of users who are currently enrolled.
EnrollmentComments	String			These are comments about the enrollment for the user. They could explain, for example, why an administrator made an exception for enrolling a particular user.
EnrollmentCutoffDate	Datetime			The date after which users are no longer allowed to enroll into the entity. Cut off dates give instructors time to look at a class roster and decide how to structure the course for that roster and give administrators some time to set things up before the course starts.
EnrollmentSeatID	Long			If this user is already enrolled in this scheduled offering, this value is the unique ID of the seat that the user occupies. If this user is not enrolled in this scheduled offering, then this value is null.
FaxNo	String			The fax number for a person or group who can be contacted about this entity. For example, your company might set up a fax number if you need to fax release forms to a department.
Instructors	String			A list of the instructors associated with this entity.
LastUpdateTimestamp	Datetime			The last time that the entity was updated. Returned in Unix Epoch.
LastUpdateUser	String			The user who most recently updated the entity.
MaximumEnrollment	Long			The maximum amount of users who can enroll into the course.
MinimumEnrollment	Long			The minimum amount of users who must enroll into the course for the course to take place.
NotActive	Bool			If the value is false then the user is active. If the value is true, then the user is inactive.
PhoneNo	String			The telephone number for a person or group (answering service) who can be contacted about this entity. For example, the phone number of a department that can answer questions about a scheduled offering.
RevisionDate	Datetime			The revision date of this entity. Learning items often have revision dates that correspond to a regulator's revision of compliance measures. Each later revision date is a later iteration of a learning item.
RevisionNo	String			The revision number of this entity. Each revision date has a revision number. Users sometimes know the revision number of training instead of the revision date. For example, they might know that they want revision 2 of a training, regardless of the date that it was revised.
ScheduleDesc	String			A description of the entity. In most cases, the description is available to users to tell them about the entity.
ScheduleEnrollStatus	String			A description of the number of seats available, the seats filled, and the number of waitlisted users.
SelfEnrollment	Bool			If this value is true, then users can enroll themselves into this entity. If false, then they cannot enroll themselves. Enrollment is not necessarily automatic when this value is true. There could be an approval process attached to enrollment.
StudentEnrollmentStatus	String			The registration status for this user in this entity.
StudentEnrollmentStatusType	String			The registration type that has been assigned to the user.
StudentEnrollmentStatusTypeLabelID	String			The registration status for this entity, with the key you need to translate it to this user's language.
TimeZoneID	String			The time zone of the entity.
TimeZoneLabelValue	String			The time zone of the entity, in a human readable format.
TitleLabelKey	String			The ID that the LMS uses to look up the title of the entity and return a value that is translated to this users' language/locale.
TypeComponent	String			Item type IDs are a critical categorization in because they determine how users are marked complete for a learning item. One item type can have completion statuses of pass and fail while another might have completion statuses of pass, fail and incomplete.
UserCanWaitlist	Bool			If this value is true, then the user can get on the wait list for the course. If someone withdraws from the course, the system picks users in the order that they went onto the wait list. In a literal sense, this user can move himself/herself to the registration status of Waitlisted.