Check the user curriculum status.

Table-Specific Information

Select

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

• CurriculumID supports the = and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
• UserID supports the = and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
• PersonGUID supports the = and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.

SELECT queries must include a filter on one of the following columns:

• UserID
• PersonGUID

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

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

SELECT [Admin].[Curriculum_Service].[UserCurriculumStatuses].* FROM [Admin].[Curriculum_Service].[UserCurriculumStatuses] WHERE [PersonGuid] = '5358074DD8EF4821B7267937D552F4C3'
SELECT [Admin].[Curriculum_Service].[UserCurriculumStatuses].* FROM [Admin].[Curriculum_Service].[UserCurriculumStatuses] WHERE [UserId] = 'sabadi'

Columns

Name	Type	References	Required for Select	Description
CurriculumID [KEY]	String			The Unique ID of a curriculum in the system.
RootCurriculaID [KEY]	String			The unique ID of the curriclum at the root of the curriculum structure. Curricula can be subcurriclua and have parent curricula. This is the ID of the curriculum at the top of the hierarchy.
UserID [KEY]	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.
AssignmentDate	Datetime			The assignment date of the curriculum.
CurriculumStatus	String			The user's status in the curricula. The value can be complete or incomplete. Complete means that the user has completed the curriculum. Incomplete means that the user has at least one more requirement to complete.
ExpirationDate	Datetime			The expiration date of the curriculum.
NextActionDate	Datetime			The next action date of the curriculum.
PersonGUID	String			An internally generated, immutable identifier for one person across all of SuccessFactors HCM Suite. This is different from an LMS user ID (often called STUDENT ID). The student ID is used only within the Learning Management System (LMS). It is also different from the PERSON ID, which is used throughout SAP SuccessFactors HCM Suite but is mutable. In most cases, you use the person ID when you want to call a single user throughout the suite.
RemainingDays	Long			The remaining days of the curriculum.
TotalCount	Long			The total number of records found for this request.