User Curriculum Item Status

You use the fields of user curriculum item status to report on users and their status of their curricula items.

The Columns of this Table
The data in these columns means the following:
  • Cell Name: The name of the data cell that you see in Online Report Designer. The cell name is a label in SAP SuccessFactors Learning, so if you changed the names of fields in SAP SuccessFactors Learning, you see different fields than you see in this table.

  • Data Type: The data type of the data in the cell. Most types are self-explanatory except for ReverseBoolean. A reverse boolean is, for example, "Not Active." If the value is Y, then the user is not active, which is the reverse of what you would expect.

  • Subdomain Schema: The group that the cell belongs to in Online Report Designer.

  • Filterable: If true, then the cell can be used to filter the results that the report returns.

  • Description: A description of the cell and why you want to use it.

Table 1: Product Features

Cell Name

Data Type

Subdomain Schema

Filterable

Description

Cell Name

Data Type

Subdomain Schema

Filterable

Description

ID (User) String User true A user's unique ID, as stored in SuccessFactors Learning. If you are using other SuccessFactors solutions, the ID should also match the HCM user ID.
First Name (User) String User false The given name of the user as stored in SuccessFactors Learning.
Last Name (User) String User false The family name of the user as stored in SuccessFactors Learning.
Middle Initial (User) String User false The middle initial of the user as stored in SuccessFactors Learning.
Emp Status String User true The user’s employment status such as full-time, part-time, and on leave.
Emp Type String User true The user's employment type such as contractor, consultant, salaried, or part-time.
Job Location (User) String User true An enumerated list of work locations that are unique to your company (for example, Seattle, Canada, or District 3 Plant).
Job Code (User) String User true A unique job title in your organization. For example, you might create a job code for "accounts receivable clerk," "cashier," and "quality control engineer."
Job Title String User false A job title can be more specific than a job code. For example, a user’s job code might be “Mechanic” and the job title might be “Transmission Specialist.”
Organization (User) String User true A branch of your company's organization chart (org chart) as recorded in SuccessFactors Learning. Users are tied to organizations in SuccessFactors Learning to assign appropriate courses to different parts of the company.
Region String User true An enumerated list of geographic regions. These regions help you segment where users work and where training takes place. For example, you can create the regions like U.S.-MidAtlantic or U.S.-Pacific Coast.
Active (User) ReverseBoolean User true Whether a user is active in the system or has been inactivated (has left the company, for example).
Address String User true A user's street address.
City String User true A user's city.
State/Province String User true A user's state or province.
Postal Code String User false A user's postal code.
Country String User true A user's country.
Primary Supervisor String User true A user's supervisor, who is the person who is directly above the user in the company org chart. Supervisors are often responsible for approving enrollment and assigning learning.
Hired Date User false The date that the user was hired.
Terminated Date User false The date that the user was terminated.
Email Address (User) String User false A user's email address.
Resume String User false A link to the user's resume.
Comments (User) String User false A learning administrator's comments on the user.
Shipping Name (User) String User false The name of a person who can receive shipments for the user.
Shipping Contact Name (User) String User false The name of a person who can be contacted about the shipment.
Shipping Address 1 (User) String User false The street address, line 1, of the user's receiving address.
Shipping Address 2 (User) String User false The street address, line 2, of the user's receiving address.
Shipping City (User) String User false The city in the user's receiving address.
Shipping State/Province (User) String User false The state or province of a user's receiving address.
Shipping Postal Code (User) String User false The postal code of a user's receiving address.
Shipping Country (User) String User true The country of a user's receiving address.
Shipping Contact Telephone (User) String User false A contact phone number to be used when shipping materials to the user.
Shipping Fax (User) String User false A fax number to be used when shipping materials to the user.
Shipping Email (User) String User false An email address to be used when shipping materials to the user.
Billing Name (User) String User false A person's name to be used when billing for training for a user.
Billing Contact Name (User) String User false A person's name who can be contacted about billing issues for this user.
Billing Address 1 (User) String User false The street address, line 1, of the user's billing address.
Billing Address 2 (User) String User false The street address, line 2, of the user's billing address.
Billing City (User) String User false The city in the user's billing address.
Billing State/Province (User) String User false The state or province of a user's billing address.
Billing Postal Code (User) String User false The postal code of a user's billing address.
Billing Country (User) String User true The country of a user's billing address.
Billing Contact Telephone (User) String User false A contact phone number to be used when billing materials to the user.
Billing Fax (User) String User false A fax number to be used when billing materials to the user.
Billing Email (User) String User false An email address to be used when billing materials to the user.
Self Enrollment (User) Boolean User true Whether a user has self-enrolled or not.
Self-Registration Date DateTime User true The date that the user has self-registered.
User can use Org Accounts Boolean User false Users can use organization accounts for commerce.
Locked Boolean User false A locked user cannot log in to the system, usually because of a security violation. For example, the system locks users who type a wrong password too many times.
Role String User true A users' role is his or her security role.
Gender String User false The user's gender (male or female).
Prior Years of Service Double User false The amount of years the user has served the company.
Job Grade ID String User false The unique ID of the user's job grade.
Is Full-Time Boolean User true Whether or not a user is a full time employee.
Regular/Temp String User true Whether the user is a regular employee or a temporary employee.
Native Deeplink User Boolean User false Whether the user has deeplinks constructed in a native way or whether the deeplink relies on the SuccessFactors Suite. This is often an indication of whether the user is part of an integrated environment or a stand-alone Learning environment.
ID (Curriculum) String Curriculum true The unique ID of a curriculum.
Parent Curriculum ID String Curriculum true The parent of the current curriculum, assuming that the current curriculum is a subcurriculum.
Title (Curriculum) String Curriculum true The title of the curriculum is the public name of the curriculum.
Assignment Date Date Curriculum false The date that the learning item has been assigned to the user.
Curriculum Type String Curriculum true The system categorizes the curriculum with other curricula of the same type for reporting (for example, Automotive, Health and Safety, Product Training, or Communication Skills).
Active (Curriculum) ReverseBoolean Curriculum false An active curriculum can be assigned to users. An inactive curriculum cannot be assigned but remains in the system for reporting.
Creation Date (Curriculum) Date Curriculum false The date that the curriculum was created.
Description (Curriculum) String Curriculum true The description of the curriculum is public-facing to help users understand the purpose of the curriculum.
Force Incomplete Boolean Curriculum false When Force Incomplete is true, the system calculates whether the status of the curriculum should be “Complete” or “Incomplete” based on a user’s most recent attempt at completing any one item in the curriculum. If the user fails his or her most recent attempt at completing the item, then the system sets the status of the entire curriculum as “Incomplete”. If it is false, then the system sets the status of the curriculum to “Complete” if users complete any “For Credit” items within the required time frame.
Basis Date Date Curriculum false If the Initial or Retraining Basis is Calendar, then the system uses the basis date to calculate the periods and, therefore, the item's required dates. If Initial or Retraining Basis is Event, then the system does not use the value in the Basis Date box; instead, the system uses the event date to calculate only the next period and, therefore, the item's next required date. If another "event" occurs, then the system uses that event date to calculate the subsequent period and, therefore, the item's next required date.
Enable Electronic Signature (Curriculum) Boolean Curriculum false If you enable electronic signatures for a curriculum, then the system requires an e-signature validation for any item in the curriculum when recording learning for a user who is assigned to the curriculum.
Item Type String Item true An item type is a categorization of learning items.
ID (Item) String Item true A learning item ID is the unique ID of a learning item.
Revision Date DateTime Item false The revision date of a learning item distinguishes iterations of a single learning item.
Title (Item) String Item true The title of a learning item is the public-facing name of the learning item.
Completion Date DateTime Item false The date that a learning event was completed by a user.
Completion Status ID String Item true The unique ID of a completion status, which can matter for certifications.
Completion Status String Item true The public-facing name of a completion status, often like "pass," "fail," or "incomplete."
Required Date Date Item false The date that the learning event is required.
Assignment Type (Item) String Item true A reason why a learning event or course has been assigned to a user.
Delivery Method String Item true How a course was delivered; for example in person by an instructor or online.
Source String Item true The source of a course's content.
Active (Item) ReverseBoolean Item false When a learning item is active, it can be assigned to users. Inactive learning items remain in the system for historic reasons.
Safety Related Boolean Item false When a course is safety related, companies often must treat the course in a special way.
Creation Date (Item) Date Item false The date that a learning item was created.
Revision Number String Item false The revision number of a learning item distinguishes iterations of a single learning item.
Reviser String Item false The administrator who revised the learning item.
Approver String Item false The approver is a person, usually a supervisor, who approves users' enrollment into courses
Approved Boolean Item false When true, the user is approved to enroll in a course.
Approval Date Date Item false The date that a user was approved to enroll into a course.
Minimum Registration (Item) Long Item false The amount of users who must register for a course before the course can take place. A minimum registration avoids holding classes that do not make sense economically.
Maximum Registration (Item) Long Item false The cap on the amount of users who can enroll into a course. A maximum registration avoids classes that are too large for an instructor to handle.
Length Double Item false The length of time of a course.
Prep Time Double Item false The amount of time that a company expects an instructor to prepare for a course. Prep time is often calculated into instructors' resource usage.
Lesson String Item false A lesson plan (in the form of URL) for administrators or trainers to consult for the learning item. This information is for administrative purposes only and cannot be viewed in the user interface.
Contact's Email (Item) String Item false An email that people can use to contact someone about a course.
Credit Hours (Item) Double Item false 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 equal 45; however, the college grants 3 credit hours for this class.
CPE Hours (Item) Double Item false CPE is an abbreviation for “Continuing Professional Education” and refers to learning activities that users perform to maintain and expand the skills that their profession demands. Therefore, CPE hours are very much like credit hours. 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 equal 45; however, the college grants 3 credit hours for this class. The accumulation of CPE hours often leads to a professional certification.
Contact Hours (Item) Double Item false Contacts 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 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.
User Materials String Item false Courses often have handouts, books, videos or other materials associated with them. If the materials are intended for the user, they are "user materials."
Instructor Materials String Item false Courses often have notes, demonstrations, or other materials associated with them. If the materials are intended for the instructor, they are "instructor materials."
Description (Item) String Item true The description of the learning item is public-facing to help users understand the purpose of the course.
Comments (Item) String Item false Comments about a learning item are private to administrators and are intended to help other administrators understand the purpose of the course.
Grade Option Long Item false A grade option is how a course is graded (for example numeric or letter).
Registration Threshold Days Long Item false The number of days that the user is not allowed to register again in another scheduled offering of the selected learning item. For example: User A registers for a scheduled offering ‘CPR’ which is scheduled for every day of the week for the next 14 days. Setting the Registration Threshold Days to 14 prevents users from enrolling in more than one scheduled offering of the selected learning item within the 14 day period other scheduled offerings of the same learning item are being offered.
Shipping Required Boolean Item false If true, a course has some materials that need to be shipped to the training site.
Auto Fill Registration (Item) Boolean Item false If true, a course will automatically fill its registration from the waitlist when a space in enrollment opens.
Do Auto Competency Boolean Item false If the learning item is associated with a competency and that competency has a default rating, and if this is set to true, then the system records that default rating on the user’s record for that competency when a successful learning event is recorded.
Classification String Item true The course classification describes how a user accesses the course. The set of classifications is fixed in the system: Blended (some online sections and some instructor-led sections), Online (the entire course can be accessed online at any time), External-Course (online and a part of the Open Content Network), Other (the course is delivered through a physical thing, like a document), or Instructor-Led (classroom training with an instructor).
Chargeback Method (Item) String Item true The method that reconciles training costs between two organizations in a company.
Scheduled Offering can Override Price Boolean Item false If false, then the cost of a course is set at the learning item. If true, the cost of the scheduled offering can be different from its parent learning item.
Production Ready Boolean Item false If true, then the content of the course can be assigned. If false, the content is still being tested by administrators.
User can Record Learning Events Boolean Item false If true, then users can record their own participation in a course.
Supervisors can Record Learning Events Boolean Item false If true, then supervisors can record their employees' participation in a course.
Approval Process (Item) String Item true The approval process for users to enroll into courses.
Approval Required (Item) Boolean Item false If true, then users must follow the approval process associated with enrollment into the course.
Initial Period String Item true The initial period is the time unit that the system uses in conjunction with the initial number to determine the first time a user is required to complete a curriculum. Examples: Days, Months, Years.
Initial Number Long Item false The initial number is the number of time units (set in Initial Period) that the system uses determine the first time a user is required to complete a curriculum. Examples: 1, 12, 360 (all numbers can be a year, depending on the initial period - Years, Months, Days).
Initial Basis String Item true Can be "event" or "calendar." If Event, then the system gives every user the same amount of time to complete the training, regardless of when the item is assigned. If Calendar, then the system gives every user the same required date in each period to complete the training.
Retraining Period String Item true The retraining period is the time unit that the system uses in conjunction with the retraining number to determine the cadence that a user must retrain on a curriculum. Examples: Days, Months, Years.
Retraining Number Long Item false The retraining number is the number of time units (set in Retraining Period) that the system uses determine the cadence that a user must retrain on a curriculum. Examples: 1, 12, 360 (all numbers can be a year, depending on the initial period - Years, Months, Days).
Retraining Basis String Item true Can be "event" or "calendar." If Event, then the system gives every user the same amount of time to complete the training, regardless of when the item is assigned. If Calendar, then the system gives every user the same required date in each period to complete the training.
Course Rating Long Item false This is an administrator’s definition of the complexity of a learning item. The complexity can range from 0.50 to 5.00.
Self Registration (Item) Boolean Item false If true, users can self-register for the course.
Enable User Requests Boolean Item false If true, users can request that a course be scheduled for a time and location that suits them better than what is currently offered.
Enable Users to Waitlist (Item) Boolean Item false If true, users can put themselves on the waitlist for a course.
User can access online content without being registered in a scheduled offering Boolean Item false If true, users can view the online portion of blended courses without registering for the instructor portion of the course.
Enable Electronic Signature (Item) Boolean Item false If true, users must use their e-signature (PIN) to verify their identity when performing some actions, like recording learning events.
Threshold Long Item false If the initial basis is set to Calendar, then you can also set a threshold for the initial assignment to complete training. The purpose of the threshold is to allow you to break the first "rule" of calendar-based item assignments. The first "rule" is that a user must have a full period by which to complete any assignment (the required date is at the end of the next full period from the assignment).
Enable Orders Boolean Item false If true, then users can use orders to pay for the course.
Check Instructor Authorization Boolean Item false If true, then only authorized instructors can teach the course.
Enable User Ratings Boolean Item false If true, then users can rate the course (give it a number of stars out of five stars).
Include User Ratings from Previous Revision Boolean Item false If true, ratings from previous revisions of a learning item carry over into the next revision. If false, each revision starts with clean rating information.
Checklist Enabled Boolean Item false If true, then the course has a task checklist associated with it and the checklist is enabled. An observer uses a task checklist to watch a user perform a task and verify that the user has performed individual steps to complete the task.
Checklist Completion Status ID String Item true The unique ID of the completion status that users receive when an observer uses a task checklist to report the users' successful completion of a process or task. For example, "Pass."
Checklist Failure Status ID String Item true The unique ID of the completion status that users receive when an observer uses a task checklist to report the users' unsuccessful completion of a process or task. For example, "Fail."
Initial Required Date Basis String Item false The "starting line" event of the initial requirement period for a curriculum. For example, if it is Assignment Date, then the system calculates all of the completion statuses and next assignment dates starting from when the curriculum was assigned to a user. If it is Hire Date, then the system calculates all of the completion statuses and next assignment dates starting from when the assigned user was hired. If the date changes, the system recalculates the deadlines.
Retraining Required Date Basis String Item false The "starting line" event of the retraining requirement period for a curriculum. For example, if it is Assignment Date, then the system calculates all of the completion statuses and next assignment dates starting from when the curriculum was assigned to a user. If it is Hire Date, then the system calculates all of the completion statuses and next assignment dates starting from when the assigned user was hired. If the date changes, the system recalculates the deadlines.
Curriculum Complete Boolean Curriculum true If true, then the user has completed the curriculum.
Days Remaining Long Item false The number of days remaining on a required assignment.
Expiration Date (Curriculum) Date Curriculum false The date that a curriculum expires.
Add User Name String Item false The user who added the object.
Add Reason String Item false The reason supplied for adding the learning object.
ID (Requirement) String Requirement true The unique ID of a learning requirement. A learning requirement is something that a user is required to know or demonstrate.
Requirement Title String Requirement true The title of the requirement. A learning requirement is something that a user is required to know or demonstrate.
Requirement Assignment Date Date Requirement false The date that the requirement was assigned to a user. A learning requirement is something that a user is required to know or demonstrate.
Requirement Completion Date Date Requirement false The date that the user completed the requiement. A learning requirement is something that a user is required to know or demonstrate.
Initial Required Date Basis String Requirement false The "starting line" event of the initial requirement period for a curriculum. For example, if it is Assignment Date, then the system calculates all of the completion statuses and next assignment dates starting from when the curriculum was assigned to a user. If it is Hire Date, then the system calculates all of the completion statuses and next assignment dates starting from when the assigned user was hired. If the date changes, the system recalculates the deadlines.
Initial Period String Requirement false The initial period is the time unit that the system uses in conjunction with the initial number to determine the first time a user is required to complete a curriculum. Examples: Days, Months, Years.
Initial Number Long Requirement false The initial number is the number of time units (set in Initial Period) that the system uses determine the first time a user is required to complete a curriculum. Examples: 1, 12, 360 (all numbers can be a year, depending on the initial period - Years, Months, Days).
Initial Basis String Requirement false Can be "event" or "calendar." If Event, then the system gives every user the same amount of time to complete the training, regardless of when the item is assigned. If Calendar, then the system gives every user the same required date in each period to complete the training.
Threshold Long Requirement false If the initial basis is set to Calendar, then you can also set a threshold for the initial assignment to complete training. The purpose of the threshold is to allow you to break the first "rule" of calendar-based item assignments. The first "rule" is that a user must have a full period by which to complete any assignment (the required date is at the end of the next full period from the assignment).
Retraining Period String Requirement false The retraining period is the time unit that the system uses in conjunction with the retraining number to determine the cadence that a user must retrain on a curriculum. Examples: Days, Months, Years.
Retraining Number Long Requirement false The retraining number is the number of time units (set in Retraining Period) that the system uses determine the cadence that a user must retrain on a curriculum. Examples: 1, 12, 360 (all numbers can be a year, depending on the initial period - Years, Months, Days).
Retraining Basis String Requirement false Can be "event" or "calendar." If Event, then the system gives every user the same amount of time to complete the training, regardless of when the item is assigned. If Calendar, then the system gives every user the same required date in each period to complete the training.
Effective Date Date Requirement false The date that an assignment is effective.
Basis Date Date Requirement false If the Initial or Retraining Basis is Calendar, then the system uses the basis date to calculate the periods and, therefore, the item's required dates. If Initial or Retraining Basis is Event, then the system does not use the value in the Basis Date box; instead, the system uses the event date to calculate only the next period and, therefore, the item's next required date. If another "event" occurs, then the system uses that event date to calculate the subsequent period and, therefore, the item's next required date.
Curriculum Requirement Completed Boolean Requirement true If true, then the requirement is complete.
Threshold Long Curriculum false If the initial basis is set to Calendar, then you can also set a threshold for the initial assignment to complete training. The purpose of the threshold is to allow you to break the first "rule" of calendar-based item assignments. The first "rule" is that a user must have a full period by which to complete any assignment (the required date is at the end of the next full period from the assignment).
Effective Date Date Curriculum false The date that an assignment is effective.
Requirement Criteria String Requirement false The criteria that must be met for the requirement to be met.
Domain (Curriculum) String Curriculum true You can associate a record with an access domain to control the administrators who can access the record. What an administrator can access and do for a record depends on how you configured the entity, function, and workflow domain restrictions of the role ID that is associated with the administrator.
Domain Description (Curriculum) String Curriculum false A description of the domain. Because the content of this box does not appear in the user interface or any reports, it can fully explain to other administrators the purpose for the domain.
Domain (Item) String Item true You can associate a record with an access domain to control the administrators who can access the record. What an administrator can access and do for a record depends on how you configured the entity, function, and workflow domain restrictions of the role ID that is associated with the administrator.
Domain Description (Item) String Item false A description of the domain. Because the content of this box does not appear in the user interface or any reports, it can fully explain to other administrators the purpose for the domain.
Domain (User) String User true You can associate a record with an access domain to control the administrators who can access the record. What an administrator can access and do for a record depends on how you configured the entity, function, and workflow domain restrictions of the role ID that is associated with the administrator.
Domain Description (User) String User false A description of the domain. Because the content of this box does not appear in the user interface or any reports, it can fully explain to other administrators the purpose for the domain.
Employee Status Description String User false An employee status identifies users' standing in the company (for example, full-time, on leave, or suspended). This is the description of the employee status.
Employee Type Description String User false An employee type identifies users' contract type (for example, contractor, consultant, salaried, or part-time). This is the description of the employee type.
Job Location Description (User) String User false Learning administrators set job locations so that SAP SuccessFactors Learning can assign courses to the users based on their location. This is the description of the job location.
Job Code Description (User) String User false In most cases, each position is an instance of a job code and each position is occupied by one user. This is the description of the job postions.
Organization Description (User) String User false An organization is a group of employees on an organization chart. This is the description of the organization.
Region Description String User false An region is a geographic location where users are located. This is the description of the regions.
Country Description String User false This is the country where users are located. This is the description of the country.
Role Description String User false Users' role is their security role in SAP SuccessFactors Learning. This is the description of the role.
Job Grade Description String User false Job grade as a way to manage users' positions within your organization. This is the description of the job grade.
First Name (Supervisor) String User false This is the first name of the users' supervisors.
Last Name (Supervisor) String User false This is the last name of the users' supervisors.
Email Address (Supervisor) String User false This is the email address of the users' supervisors.
Organization ID (Supervisor) String User false An organization is a group of employees on an organization chart. This is the supervisors' organization ID.
Organization Description (Supervisor) String User false An organization is a group of employees on an organization chart. This is the description of the supervisors' organization.
Job Code ID (Supervisor ) String User false In most cases, each position is an instance of a job code and each position is occupied by one user. This is the supervisors' job position.
Job Code Description (Supervisor) String User false In most cases, each position is an instance of a job code and each position is occupied by one user. This is the description of supervisors' job position.
Job Location ID (Supervisor) String User false Learning administrators set job locations so that SAP SuccessFactors Learning can assign courses to the users based on their location. This is the supervisors' job location ID.
Job Location Description (Supervisor) String User false Learning administrators set job locations so that SAP SuccessFactors Learning can assign courses to the users based on their location. This is the description of the supervisors' job location.