Program Data

You use the fields of program data to report on learning programs.

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 true The given name of the user as stored in SuccessFactors Learning.
Last Name (User) String User true 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 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.”
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 false A user's street address.
City String User false A user's city.
State / Province String User false The state (like Idaho) or province (like Quebec).
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 true 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 false Whether a user has self-enrolled or not.
Self-Registration Date DateTime User false 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 false 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 false Whether or not a user is a full time employee.
Regular/Temp String User false 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.
Program ID String Program true The unique ID of a learning program. A learning program is a syllabus of courses that a user enrolls into.
Program Title String Program true The title of a learning program. A learning program title is the user friendly name for the syllabus of courses. A learning program is a syllabus of courses that a user enrolls into.
Program Description String Program false The description of a learning program. A learning program description helps users understand whether or not they want to enroll into the program. A learning program is a syllabus of courses that a user enrolls into.
Program Types String Program true A program type is a category of programs. Companies devise their own types because each company has different categories of programs.
Program Duration Type String Program false A program duration type defines how the learning program (syllabus of learning) progresses. For example, a scheduled program type has fixed start and end dates.
Start Date DateTime Program true The start date of a scheduled offering (a course).
End Date DateTime Program true The end date of a scheduled offering (a course).
Added by String Program false The person who added the learning object.
Item Type String Program true An item type is a categorization of learning items.
ID (Item) String Program true A learning item ID is the unique ID of a learning item.
Revision Date DateTime Program false The revision date of a learning item distinguishes iterations of a single learning item.
Assigned By String Program false The user who assigned the course. The user can be, for example, a supervisor or the system itself.
Completion Status Description String Program true The user friendly description of a learning object.
Completion Date/Time DateTime Program true The date and time that a user completed an assignment.
Assign Date DateTime Program true When the learning object was assigned to users.
Completed Boolean Program true When the user completed the learning object.
Duration String Program true The length of time of a course.
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."
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.
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.
Section Title String Section true A program's section title appears with the group of learning objects to describe them as a group.
Section Start Date DateTime Section true The date that a program section is scheduled to start.
Section End Date DateTime Section true The date that a program section is scheduled to end.
Section Duration String Section true The duration of a program section.
Section Duration Type String Section true A section has a duration type, which describes how the users work through the program section.
Sequence Order String Section false The order of sections in a program.
Activity Title String Activity true The name of a learning activity in a program section.
Activity Description String Activity true A description of a learning activity in a program section. Activity descriptions help users understand the purpose of the activity.
Discriminator String Activity true A discriminator describes what is in a section. For example online items or blended learning items.
Previous completion Threshold String Activity false Previous completion threshold is the amount of days in the past starting at program assignment that the system should look to see if users have already completed an assignment in the program. If the user has completed it within the amount of days, then the user gets credit for having completed the learning item in the program as well.
Item ID String Activity true The unique ID of a learning item
Item Type String Activity true An item type is a categorization of learning items.
Item Revision Date DateTime Activity true The date that a learning item was revised.
Scheduled Offering ID String Activity true The uniqe ID of a scheduled offering.
Scheduled Offering Segment number String Activity false The unique ID of a scheduled offering's segment. A segment is a division of a class. For example, if a class is held for five days, each day can be a segment. The Scheduled offering has five segments.
Scheduled Offering Start Date String Activity true The date that the scheduled offering begins.
Scheduled Offering End Date String Activity true The date that the scheduled offering ends.
Activity Sequence Order String Activity false The sequence of the activities in a section of a program.
Activity Required String Activity true A flag to show if the activity is required or if it is optional.
Section Link String Activity true If a section links to a URL, the URL that it links to.
Is Complete String Completion true A flag to indicate if the section has been completed.
Completion Status String Completion true The public-facing name of a completion status, often like "pass," "fail," or "incomplete."
Completion Date DateTime Completion true The date that a learning event was completed by a user.
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.