A document is information that goes with a learning item. Usually, it is written. For example, a document could be a Standard Operating Procedure (SOP) that goes with the training. Or it could be a handbook that goes with the course. Not all companies track documents in the LMS.

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].[LearningItemDocuments].* FROM [User].[LearningPlan_Service].[LearningItemDocuments] 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.
DocumentID	String			The unique ID of the document record. Documents are managed as separate objects in the system and then associated with learning item.
DocumentLocation	String			A brief description of where the document is located. For example, if it is stored at a URL on a content server, it might be that URL.
DocumentTitle	String			The title of the document. The title is something that users recognize.
ItemID	String		True	The unique ID of the learning item.
ItemTypeID	String		True	The type ID of the learning item.
ReviewFlag	Bool			If the value of this is true, then the document should be reviewed for accuracy. Reviews are triggered when the document is revised. The review flag is set on the learning item or curricula, not on the document, because it is within the context of the learning item or curriculum that the document must be reviewed. Review to answer the question: does this new revision of the document fit with the current revision of the learning item or curriculum.
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.