This is a collection for enrollments.

Table-Specific Information

Select

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

• ScheduleID supports the = comparison operator.

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

Columns

Name	Type	References	Required for Select	Description
ScheduleID	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.
EnrollSeatID	Long			The unique ID of the enrollment seat for the user in the current scheduled offering. The value is a number.
StudentID	String			The unique ID of a user in the Learning Management System (LMS). This is recognized within the LMS only. If you want an ID that is recognized throughout SAP SuccessFactors HCM suite, you want to get the Person GUID or Person External ID.
FirstName	String			The given name of a user.
MiddleInitial	String			The middle initial of a user.
LastName	String			The family name of a user.
EnrollSlotID	Long			The unique ID of the enrollment slot. A slot is a spot in a training course that a user can enroll into. For example, if a course (a scheduled offering) is limited to ten participants, it has ten slots. Each participant who enrolls is placed into a slot. If nine users enroll into the course, then nine of ten slots are occupied. Slots are important because you can reserve slots for users. You can, for example, say that a course has ten slots and five of them are reserved for users of a particular organization.
EnrollStatID	String			The registration status for this user in this entity.
EnrollDate	Datetime			The date of enrollment when the user was added to the entity.
Comments	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.
ShippingAddress	String			The street address used for shipping.
ShippingCity	String			The city used in the shipping address.
ShippingState	String			The state or province used in the shipping address.
ShippingPostal	String			The postal code used in the shipping address.
ShippingCountry	String			The country used in the shipping address.
ShippingPhoneNo	String			The phone number to contact someone at the shipping address for information about the shipment.
ShippingFaxNo	String			The fax number where documents can be sent at the shipping address, such as shipping labels.
ShippingEmailAddress	String			The email address to contact someone at the shipping address for information about the shipment.
LastUpdateUser	String			The user who most recently updated the entity.
LastUpdateTimestamp	Datetime			The last time the entity was updated.
AddUser	String			The user who added the entity.
CancelDate	Datetime			If the user cancels, this is the date of the cancellaton.
OrderItemID	Long			The order ID associated with the learning item.
PaymentOrderTicketNo	String			If this order is paid with a ticket, this is the number of the ticket.
TicketSequence	Long			The sequence number of the ticket.
Origin	String			The origin of the enrollment.
WithdrawPending	Bool			If the user is cancelling and that withdraw is pending, this is true.