UserTodoLearningItems
A learning item is a unit of learning that you can track in the Learning Management System (LMS). You can think of this as a university course catalog: each course, like Introduction to Wave Physics is a learning item. Those learning items can be tracked to see who has completed Introduction to Wave Physics. And Introduction to Wave Physics can be offered at multiple times to fit different student schedules. Each of those instances is a scheduled offering. In most cases, a learning item is a course, either online or in a classroom, but you can also use learning items to track books that employees are required to read or Standard Operating Procedures (SOPs) that they are required to sign-off on and understand.,A UserToDoLearningItem is a learning item on one user's learning plan. It is most useful as a collection: these are the learning items that appear on users' learning plans.
Table-Specific Information
Select
The connector uses the SAPSuccessFactorsLMS API to process WHERE clause conditions that are built with the following columns and operators:- ComponentTypeID supports the =, !=, and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
- QualItemsAndReqThresholdDays supports the = comparison operator.
- SourceID supports the = comparison operator.
- PersonGUID 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.
- RetrieveLinkedSchedules supports the =, !=, IS, and IS NOT comparison operators.
- IncludeDeeplink supports the =, !=, IS, and IS NOT comparison operators.
- IncludeVLSlink supports the =, !=, IS, and IS NOT comparison operators.
- IncludeSurveys supports the =, !=, IS, and IS NOT comparison operators.
- IncludeLearnerActions supports the =, !=, IS, and IS NOT comparison operators.
SELECT queries must include a filter on one of the following columns:
- ComponentTypeID
- UserID
The connector processes other filters client-side within the connector.
For example, the following queries are processed server-side:
SELECT [User].[LearningPlan_Service].[UserTodoLearningItems].* FROM [User].[LearningPlan_Service].[UserTodoLearningItems]
Columns
| Name | Type | References | Required for Select | Description |
| Sku [KEY] | String | A Stock Keeping Unit (SKU) is a unique ID of an object in learning, used for commercial tracking, inventory, and account balancing. | ||
| AddUser | String | The user type who added the learning item. A is an administrator and P is a user (for example, a supervisor). | ||
| AddUserName | String | The username of the user who added this course to this users's assignments. | ||
| AddUserTypeLabelID | String | The full name of the user type who added the learning item to the user. For example: Admin and User | ||
| AssignedDate | Datetime | The assignment date of the curriculum. | ||
| AvailableNewRevision | Bool | If the value of this is true, then the learning item has a newer revision then the revision assigned to the user. | ||
| CdpGoalID | String | The continuous development plan goal ID associated with this learning item. | ||
| ComponentID | String | The unique ID of a learning item. | ||
| ComponentKey | Long | The unique key for the item. It is used in some parts of application such as bookmarking where we need to save multiple entities' primary keys. It must be a long number. | ||
| ComponentLength | Double | The sum of the length of all segments, in hours. | ||
| ComponentTypeDesc | String | The descriptions of item types can help you determine how the item type assigns credit. | ||
| 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. | ||
| ContactHours | Double | Contact hours are the total number of hours that you expect a user to have contact with an instructor. For example, if you set up a blended learning item that has 8 total hours and, for 6 of those hours, you expect the user to be in an instructor-led segment, then the contact hours equals 6. | ||
| CourseDeeplink | String | If you requested a deep link in your search for learning items, and if this learning item contains online content, then this is populated with the link to the online content. Users click the link to go to the online content for this learning item. If they are not already authenticated to the system, they must authenticate before they can see the page. | ||
| CpeHours | Double | CPE is an abbreviation for | ||
| Cpnt_classification | String | The unique ID of the classification for a learning item. It can be: It can be one of the following values: BLENDED, CONTINUOUS ONLINE ACCESS, EXTERNAL-COURSE, PHYSICAL GOOD, or TIME-BASED. A learning item classification is a category of a course, one that explains - in general terms - how the course is offered. It used by the LMS for business rules. For example, users do not enroll into a physical good, but do enroll into a an instructor led course. You cannot change the set of values for classification (they are set by the LMS). It can be one of the following values: BLENDED: Blended items are partly led by an instructor and partly online computer based training. Often the online portion is self-paced. CONTINUOUS ONLINE ACCESS: Online courses are always available to users. EXTERNAL-COURSE: External Courses are courses that have come in through the Open Content Network (OCN). PHYSICAL GOOD: Other courses that are most often a physical material like a book or CD. TIME-BASED: Instructor-led courses are classroom based courses, but the classroom can be physical or virtual (a conference call). | ||
| CreditHours | Double | Credit hours are the number of hours that a user earns for completing a learning event. For example, in many U.S. colleges, students attend a single class for 15 weeks, 3 days each week, and 1 hour each day. In this case, the total hours equals 45; however, the college grants 3 CREDIT HOURS for this class. | ||
| QualItemsAndReqThresholdDays | Long | This column does not have a description. | ||
| SourceID | String | This column does not have a description. | ||
| DaysRemaining | Long | The days remaining until the user is required to complete the learning item. If it is a negative number, then it is the days that the user is overdue. | ||
| Description | String | A description of the entity. In most cases, the description is available to users to tell them about the entity. | ||
| EmbeddableDeeplink | String | A deep link that can be embedded in an iframe. When users access the link, they must authenticate to the system. Upon authentication, the course content displays in the content player, within the iframe. | ||
| HasOnlinePart | Bool | If this is true, then the entity has some online sections. | ||
| IsRequired | Bool | If the value of this is true, then the learning item is required to be completed by the user. | ||
| IsUserRequestsEnabled | Bool | If the value of this is true, then users can request to be enrolled. | ||
| ItemDetailsDeeplink | String | If you requested a deep link in your search for learning items, this is populated with the link to the learning item details page. Users click the link to see the details for this learning item. If they are not already authenticated to the system, they must authenticate before they can see the page. | ||
| ItemSurveyID | Long | A unique Item Survey ID to uniquely identify the mapping between Item and Survey. | ||
| LearnerActions | String | List of actions available to the learner for the learning item. | ||
| LinkedSchedules | String | A list of all the scheduled offerings for this learning item for which the user is enrolled. | ||
| OnlineLaunched | Bool | If the value of this is true, then the user has launched the online content at least once. | ||
| OrderItemID | Long | The order ID associated with the learning item. | ||
| OrderItemStatusTypeID | String | The unique type ID of the order's status. The order's status defines where it is in the process of being purchased. | ||
| Origin | String | How the learning item came to be on the users' learning plan. For example: Curriculum. | ||
| PersonExternalID | String | A mutable 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 GUID, which is used throughout SAP SuccessFactors HCM Suite but is immutable. In most cases, you use the person ID when you want to call a single user throughout the suite. | ||
| 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. | ||
| ProgramDeeplink | String | A deep link ot the program. If users click the link, they first must authenticate to the system and then they can look at the program details. | ||
| ProgramDuration | Long | If this is program has a duration (a time over which it should be completed) this is that duration. | ||
| ProgramDurationType | String | The duration type. | ||
| ProgramEndDate | Datetime | If this is program has a defined end date, this is that end date. | ||
| ProgramStartDate | Datetime | If this is program has a defined start date, this is that start date. | ||
| ProgramType | String | The program type, which defines how a user progresses through the program. It can be scheduled, duration-based, or open-ended. | ||
| QualificationID | String | The Unique ID of a curriculum in the system. In the context of this entity, this is the curriculum ID that put the learning item on the users' learning assignments. The learning item is part of the curriculum, the curriculum is assigned, therefore the learning item is assigned. | ||
| QualTitle | String | The title of a curriculum in the system. In the context of this entity, this is the title of the curriculum that put the learning item on the users' learning assignments. | ||
| RequiredDate | Datetime | The date that the user is required to complete this entity. | ||
| RequirementTypeDescription | String | The description of the requirement type. Requirement types define the conditions that users must meet to be considered complete in the requirement (for example, number of hours from a set of learning items). | ||
| RequirementTypeId | String | The ID of the requirement type. Requirement types define the conditions that users must meet to be considered complete in the requirement (for example, number of hours from a set of learning items). | ||
| RevisionDate | Datetime | 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. | ||
| RevisionNumber | String | The revision number of the learning item. | ||
| RootQualificationID | String | The unique ID of the curriculum at the root of the curriculum structure. Curricula can be subcurricula and have parent curricula. This is the ID of the curriculum at the top of the hierarchy. In the context of this entity, this is the root curriculum ID that put the learning item on the users' learning assignments. The learning item is part of a curriculum structure (with this curriculum at its root), the curriculum structure is assigned, therefore the learning item is assigned. | ||
| ScheduleID | Long | The unique ID of the scheduled offering. | ||
| SeqNumber | Long | The sequence number of the learning item. | ||
| ShowInCatalog | Bool | If the value of this is true, then this appears in the users' learning catalog. | ||
| Status | String | A comma separated list of status entries. The following are the positions in the list and what you can expect in those positions. First position: Are the prerequisites satisfied for this learning plan item? The values can be Y or N. Second position: What is the enrollment status of the user for this learning plan item? Possible values are E, W, P, or N. E means that the user is enrolled. W means that the user is waitlisted. The waitlist is a queue of users who are next in line if a user withdraws from a course. P means that the user is pending enrollment. Pending users are most often in the middle of an approval process to enroll. N means that the user is not enrolled. Third position: Is a Virtual Learning Service (VLS) segment in session? The values can be Y or N,Fourth Position: Is there a segment currently happening for this course? The values can be Y or N. Fifth position: The unique ID of the seat that the user is enrolled into. If the user is not currently enrolled into a pertinent scheduled offering, the value is -1. Sixth position: the online status of the learning item. Possible values are -1, -2, -3, -4, -5, or -6. -1 means that the online sections of the learning item are available to be launched by the user. -2 means that the online sections are available, but the user has been locked out of the online section for some reason and is not allowed to launch it. -3 means that the online sections are not available for some reason. -4 means that the user can launch the online sections, but only during the scheduled time. If the segment is in session, the user can launch it. -5 means that the user cannot launch the online content because there is a prerequisite that the user has not yet completed. The user must complete the prerequisite and then attempt again to launch the content. -6 means that the user has already launched the content and it is in progress. Seventh position: The status of any courses that are scheduled for this learning item (any scheduled offerings based on the learning item). Possible values are 10, 11, -1 or -3. 10 means that an offering exists and the user can enroll. 11 means that an offering exists, but the user cannot enroll. Instead, the user can waitlist and will be enrolled if an enrolled user withdraws. -1 means that no scheduled offerings are currently available. -3 means that the user has not met the prerequisites for enrollment so cannot enroll. Eighth position: This is a unique ID (a key) that represents the association between a learning item or learning object to student. It is used when a component is assigned to a user. The system generates this unique ID to track the progress of the user in the course. Returns -1 if no key exists. Ninth position: Has the scheduled offering for this learning item already started? The values can be Y or N. Tenth position: Does the user need to complete a questionnaire survey for the learning item? A questionnaire survey is a set of follow-up questions after the course is completed. The values can be Y or N. Eleventh position: Is task checklist enabled for this course? A task checklist is a standard operating procedure that someone - an observer - validates when watching a student complete a physical task. Students pass the task checklist when the observer sees the student do the tasks properly and in order. The values can be Y or N. Twelfth position: Are task checklist observers nominated for this course? This is a stage in the observation process. The values can be Y or N. Thirteenth position: Are task checklist observees present for this course? The values can be Y or N. Fourteenth position: Can users make a request that this course should be offered? The values can be Y or N. Fifteenth position: Are there any pending scheduled offering withdraw requests for the course? When users want to withdraw from the course, they can request that they be removed from the roster. The values can be Y or N. Sixteenth position: Are there any requests pending for the course by the user? The values can be Y or N. Seventeenth position: Can user request for task checklist observation for the course? The values can be Y or N. | ||
| StudentSurveyID | Long | A unique User Survey ID to uniquely identify the mapping between User and Survey. | ||
| SurveyDeepLink | String | A deep link of the Survey. If users click the link, they first must authenticate to the system and then they can look at the survey details. | ||
| SurveyDesc | String | The Survey Description | ||
| SurveyID | String | The unique ID of the Survey in the System | ||
| SurveyLevel | Long | The level of the Survey. The value of 1 indicates Item Evaluation Survey. The value of 3 indicates Follow up Evaluation Survey. | ||
| SurveyStatusID | String | The Status of the survey assigned to User. | ||
| Title | String | The title of the learning item in the language of the current user (the user calling the web service). Titles can be translated using a key/value pair, where the key uniquely identifies a particular learning item's title and the values are each language's translation of the title. If you need the key that matches this value, and if the web service supports it, look in TitleLabelKey. | ||
| UsedOrderTicketNumber | String | Used order ticket number | ||
| UsedOrderTicketSequence | Long | Used order ticket sequence | ||
| UserID | String | The unique ID of this user.
The default value is CURRENT_USER. | ||
| VlsLink | String | The VLS link that learners can use to join a virtual meeting room (like WebEx, Adobe Connect, or Skype) for training. The link is for registered learners and learning items with a current or future segment that is virtual. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| RetrieveLinkedSchedules | Bool | If set to true, then the service returns not only the learning items in the users' learning plans but also the classes that the users are enrolled into for those learning items. When true, the system runs a second query, which has a performance impact. Set to false for faster queries when you don't need the schedules. | |
| IncludeDeeplink | Bool | If this value is true, then the search returns a deep link to the entities it returns. | |
| IncludeVLSlink | Bool | The VLS link that learners can use to join a virtual meeting room (like WebEx, Adobe Connect, or Skype) for training. The link is for registered learners and learning items with a current or future time slot that is virtual. | |
| IncludeSurveys | Bool | If set to true, then the service returns the surveys associated with the users along the learning items assigned to him. | |
| IncludeLearnerActions | Bool | If set to true, the system returns actions available to the learner for each learning item in the results. If set to false, actions won't be included in results. Default is false. |