This is a prerequisite for the learning item. A prerequisite is a course that must be taken before the user can enroll into the current learning item.

Table-Specific Information

Select

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

• ItemID supports the = comparison operator.
• ItemTypeID supports the = comparison operator.
• RevisionDate supports the = comparison operator.

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

For example, the following queries are processed server-side:

SELECT [User].[LearningPlan_Service].[LearningItemPrerequisites].* FROM [User].[LearningPlan_Service].[LearningItemPrerequisites] WHERE (([ItemId] = 'HR_300') AND ([ItemTypeId] = 'COURSE')) AND ([RevisionDate] = '2017-05-11 13:28:00')

Columns

Name	Type	References	Required for Select	Description
PkID [KEY]	String			The learning item's key. A learning item key is a concatenation of the learning item's unique ID, the learning item's type ID, and the learning item's revision date, separated by dashes. The key helps you uniquely identify one specific type and revision of a learning item.
ComponentID	String			The unique ID of a learning item.
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.
ItemID	String		True	The unique ID of the learning item.
ItemTypeID	String		True	The type ID of the learning item.
PrerequisitesGroupItem	String			A prerequisite is a learning item that must be complete before enrolling into this learning item. A group of prerequisites (prerequisite group) is an ordered list of prerequsites that users must complete in a given order. For example, to take a high level Physics course, you probably need to start with introduction to physics and work through a series of prerequisites before you are ready for the high level course. That series of courses is a prerequsite group.
RevisionDate	Datetime		True	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.