You use the fields of program data to report on learning programs.
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.
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. |