Seats available in a scheduled offering.

Table-Specific Information

Select

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

• ScheduleID supports the =, !=, >, >=, <, and <= comparison operators.

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

Columns

Name	Type	References	Required for Select	Description
ScheduleID [KEY]	Long			The unique identifier of the scheduled offering.
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).
Cancelled	Bool			If this value is true, then this is canceled.
CancelledDate	Datetime			If this is canceled, the date that it is canceled.
Closed	Bool			If this value is true, this is closed. A closed seat is not available.
ClosedDate	Datetime			If this is closed, then this is the date that it closed.
Comments	String			A comment about the entity.
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.
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.
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.
LastUpdateTimestamp	Datetime			The last time the entity was updated. Returned in Unix Epoch.
LastUpdateUser	String			The user who most recently updated the entity.
MaximumEnrollment	Long			The maximum number of users who can enroll into the course.
Messages	String			Messages related to the seat availability.
MinimumEnrollment	Long			The minimum number 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.
ScheduleDesc	String			A description of the scheduled offering.
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.
TimeZoneID	String			The time zone of the lastUpdateTimestamp.
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.