You're looking at an older version of Totara Learn.

Please see Totara 15 help for the latest version.

All pages





Search

 Following are the default report sources and the data that they include grouped by category. 

A category may contain different fields between two different sources.

All enrolled users are included in reports containing Course information, including those with non-gradable roles such as Trainer.

Unenrolled users are not included in Course level reports (they are in activity level reports).

If a user is running a report with columns which include custom profile fields, report builder will hide these columns from the output unless the user has the totara/core:viewhiddenusercustomfielddata capability or the field is set to visible to everyone.

Source Name:

Appraisal detail

Description:

Performance management appraisal details including the questions and responses provided by each appraisal user.

Columns:

User: All user profile fields including name, email address, custom user fields, organisation, and position for the user the appraisal was completed for.

User's Appraisal: User's appraisal completion date, previous stage completion date appraisal status, current stage, and due date.

Appraisal: Appraisal name, status, start, and finish dates.

Appraisal Answers: Answer, rating and score for all users completing the appraisal.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.


↑Back to top

Source Name:

Appraisal status

Description:

Performance Management appraisal status details including stage information and completion status.

Columns:

User: All user profile fields including name, email address, custom user fields, organisation, and position for the user the appraisal was completed for.

User's Appraisal: User's appraisal completion date, previous stage completion date appraisal status, current stage, and due date.

Appraisal: Appraisal name, status, start, and finish dates.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.


↑Back to top 

Source Name:

Assignment submissions

Description:

Assignment activity submission information by user.

Columns:

Grade: Grade scale values, submission grade, submission comment, last modified, last marked, maximum grade, minimum grade.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category, and the ID.


↑Back to top 

Source Name:

Assignment submissions summary

Description:

Assignment activity submission information by assignment.

Columns:

Assignment: Name, intro, type, submission grade, sum grade, avg grade, min/max grade.

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category, and the ID.


↑Back to top 

Source Name:

Audience Members

Description:

Audience information including information on users who are members of the audience.

Columns:

Audience: Name, ID, link to audience, start/end date, status.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.


↑Back to top 

Source Name:

Audience: Enrolled Learning

Description:

Courses and programs that audiences are enrolled in including completion rules.

Columns:

Audience: Audience name and ID.

Associations: Course/Program name, type, action (allows administrators to delete a course/program assignment), completion.


↑Back to top 

Source Name:

Audience: Visible Learning

Description:

Course and program listing with the audience name and audience(s) visibility setting displayed.

Columns:

Audience: Audience name and ID.

Associations: Course/Program name, type, action (allows administrators to delete a course/program assignment), completion.


↑Back to top 

Source Name:

Audiences

Description:

Audience information and user profile details of those who are members of the audience.

Columns:

Audience: Name, ID, link to audience, start/end date, status.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Tags: Topics or interests that the audience was marked with.


↑Back to top 

Source Name:

Audiences Orphaned Users

Description:

View users who are not a part of an audience.

Columns:

User: Profile information.

Statistics: User's achievements in courses and competencies.


↑Back to top 

Source Name:

Badges issued

Description:

View users who have been issued a badge.

Columns:

Badges: Badge issued, date, type, status, image, issuer, notification.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Category: Course category name, a link to the category and the ID.


↑Back to top 

Source Name:

Certification Completion

Description:

Show users details and progress for users who are assigned to a certification.

Columns:

Certification Completion: Date assigned, date completed , position and organisation when completed, Status (Certified, In progress, Expired), Due date. Note Status values are Not Certified, Certified, Expired, In Progress.

 User: All user profile fields including name, email address, custom user fields, organisation, and position.

Category: Course category name, a link to the category and the ID.

Certification: Certification name details, Availability dates, Visibility, active and window period.


↑Back to top 

Source Name:

Certification Membership

Description:

Show users details and progress for users who are assigned to a certification

Columns:

Certification membership: status, is currently certified, is currently assigned, edit completion records link.

Certification: recertification method, active period, window period.

User: All user profile fields.


↑Back to top 

Source Name:

Certification Overview

Description:

Show users details and progress for users who are assigned to a certification and details of courses.

Columns:

Certification Completion: date Assigned, date completed , position and organisation when completed, Status (Certified, In progress, Expired), Due date. Note Status values are Not Certified, Certified, Expired, In Progress.

 User: All user profile fields including name, email address, custom user fields, organisation and position.

Category: Course category name, a link to the category and the ID.

Certification: Certification name details, Availability dates, Visibility, active and window period.

Course: Category details, course progress and enrolment details.


↑Back to top 

Source Name:

Certifications

Description:

 Details of the Certifications setup.

Columns:

Certification: Certification name details, Availability dates, Visibility, active and window period. 

Category: Course category name, a link to the category and the ID.


↑Back to top 

Source Name:

Competency Status

Description:

Learners progress on their assigned competencies.

Columns:

User: All user profile fields including name, email address, custom user fields, organisation and position.

Competency: Competency details including, name and ID.

Competency status: User competency completion details including proficiency level, date, organisation and position when proficiency level was marked.


↑Back to top 

Source Name:

Competency Status History

Description:

Details competency progress including timestamps of when competencies were assigned and each time the status was modified, as well as the name of the user who modified the status.

Columns:

User: All user profile fields including name, email address, custom user fields, organisation and position.

Competency: Competency details including, name and ID.

Competency status: User competency completion details including proficiency level, date, organisation and position when proficiency level was marked.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.

Competency custom fields: Custom type fields added to the competency hierarchy.


↑Back to top 

Source Name:

Completion Import: Certification Status

Description:

Log details from the import of certification records through a CSV file.

Columns:

Import: Log ID number, line number, errors, imported as evidence, certification name, certification ID, username, completion date.

Import User: Full name and username of the user who imported the file.


↑Back to top 

Source Name:

Completion Import: Course Status

Description:

Log details from the import of course completion records through a CSV file.

Columns:

Base: Log ID number, line number, errors, imported as evidence (occurs when a matching course isn't found), username, course name, completion date, grade. 

Import User: Full name and username of the user who imported the file.


↑Back to top 

Source Name:

Course Completion

Description:

Course completion status records including user details, course details and completion status.

Columns:

Course completion: Learner course completion details including completion date, organisation, position and grade.

User: All user profile fields including name, email address, custom user fields, organisation and position.

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category and the ID.

Tags: Topics or interests that the audience was marked with.


↑Back to top 

Source Name:

Course Completion including history

Description:

Course completion status records including user details, course details for all courses.

Columns:

User: All user profile fields including name, email address, custom user fields, organisation and position.

 Course: Course settings including course name, ID, language, visibility, and a link to the course page.


↑Back to top 

Source Name:

Course Completion by Organisation

Description:

Course completion details grouped by organisation.

Columns:

User: All user profile fields including name, email address, custom user fields, organisation and position.

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category and the ID.

Tags: Topics or interests that the audience was marked with.


↑Back to top 

Source Name:

Courses

Description:

Details about the course and course category.

Columns:

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category and the ID.

Tags: Topics or interests that the audience was marked with.


↑Back to top 

Source Name:

Evidence

Description:

Details the evidence that a learner has submitted for course and competency equivalency.

Columns:

Evidence: User-provided information supporting their evidence.

User: All user profile fields including name, email address, and custom user fields.


↑Back to top 

Source Name:

Face-to-face Interest

Description:

Details of users that have registered their interest in a session.

Columns:

Face-to-face name: Name of the Face-to-face activity, link to the activity.

 User: All user profile fields including name, email address, custom user fields.

Course Data: Course-level fields such as the course name, link to the course, shortname, ID, summary.

Category: Course category information including name, a link to the category and ID.


↑Back to top 

Source Name:

Face-to-face sessions

Description:

Face-to-face activity information including session details, registration information, and attendance status.

Columns:

Session Data: Capacity, number of attendees, details, duration, discount code, normal cost, discount cost, cancellation date and reason.

Status: Learner's booking and attendance status (booked, wait-listed, cancelled, fully attended, partially attended, no show).

Face-to-face name: Name of the Face-to-face activity, link to the activity.

User Profile fields: All fields from the user profile, such as the learner's name, email address, position and organisation are available as well as any custom user profile fields.

Course Data: Course-level fields such as the course name, link to the course, shortname, ID, summary.

Category: Course category information including name, a link to the category and ID.

Tags: View the tags associated with the course by selecting specific tags or selecting 'Tags' which will include a list of all of the tags for this course.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.


↑Back to top 

Source Name:

Feedback Summary

Description:

Learner responses to the feedback activity used to survey learners in a course.

Columns:

Feedback: Name of the activity.

Responses: Date and time the feedback activity was completed.

Trainer: Trainer's name, position and organisation.

User: All user profile fields including name, email address, custom user fields, organisation and position.

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category and the ID.

Tags: Topics or interests that the audience was marked with.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.


↑Back to top 

Source Name:

Goal Custom Fields

Description:

Company goals and users' current progress on their assigned goals.

Columns:

Goal: Goal name, framework, user's status and all personal and company custom fields.

User: All user profile fields including name, email address, custom user fields, organisation and position.


↑Back to top 

Source Name:

Goal Status

Description:

Company goals and users' current progress on their assigned goals.

Columns:

Goal: Goal name, framework, user's status.

Goal Status History: Prior goal status values, time modified, modified by user name.

User: All user profile fields including name, email address, custom user fields, organisation and position.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.


↑Back to top 

Source Name:

Goal Status History

Description:

Company goals and user progress over time on their assigned goals.

Columns:

Goal: Goal name, framework, user's status, timestamp of goal status changes, user who updated status.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.


↑Back to top 

Source Name:

Goal Summary

Description:

Company goals with summary details including number of users assigned and number of users per status.

Columns:

Goal: Goal name, scale count, number of users assigned.


↑Back to top 

Source Name:

Language Customisation

Description:

Shows customisations to the language pack

Columns:

Language: language, component, string ID, original, local, customised, component version.


↑Back to top 
Source Name:

Legacy Site Logs

Description:

Site-wide user activity logging (pre old format without user information).

Columns:

Log: Module, ID, IP address, Action taken.

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category and the ID.

Tags: Topics or interests that the SCORM was marked with.


↑Back to top 

Source Name:

Learning Plans

Description:

Learning plan information by user.

Columns:

Plan: Individual user's plan details.

Plan Template: Plan template details.

User: All user profile fields including name, email address, and custom user fields.


↑Back to top 

Source Name:

Messages

Description:

Alerts and notifications sent by the system and users.

Columns:

Messages: Message details including subject, content, type, sent date.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.


↑Back to top 

Source Name:

Open Sesame course packages

Description:

Provides details of courses with Open Sesame course packages.

Columns:

Messages: Message details including subject, content, type, sent date.

Course: Name, course settings, licence details.


↑Back to top 

Source Name:

Organisations

Description:

Organisation structure details.

Columns:

Organisation: Organisation ID, name, description, type, competencies.

Organisation custom fields: Custom type fields added to the organisation hierarchy.


↑Back to top 

Source Name:

Positions

Description:

Position structure details.

Columns:

Position: Position ID, name, description, type, competencies.

Position custom fields: Custom type fields added to the Position hierarchy.


↑Back to top 

Source Name:

Program Completion

Description:

Program completion information and program details.

Columns:

Program Completion: Details of user completion of a program including dates, organisation, and position.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Category: Course category name, a link to the category and the ID.

Program: Program settings including name, ID, and availability.


↑Back to top 

Source Name:

Program Membership

Description:

Program membership information and user details.

Columns:

Program membership: Details of user membership of a program; is currently assigned, a link to edit completion records, status.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Program: Program settings including name, ID, and availability.


↑Back to top 

Source Name:

Program Overview

Description:

Program details and status including information about the courses that are a part of the program content.

Columns:

Program: Program settings including name, ID, and availability.

Program Completion: Details of user completion of a program including dates, organisation, and position.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Course: Course settings including course name, a link to the course page and learner enrolment and completion status details.

Category: Course category name, a link to the category and the ID.

Program: Program settings including name, ID, and availability.


↑Back to top 

Source Name:

Programs

Description:

Program details and settings.

Columns:

Program: Program settings including name, ID, and availability.

Category: Course category name, a link to the category and the ID.


↑Back to top 

Source Name:

Record of Learning: Certifications

Description:

Certification assignment and course completion information, by default used to build the Record of Learning embedded report.

Columns:

Programs: Certification details including name, program short name, program ID number, certification ID.

Program Completion: Certification due date.

Certification Completions: Certification path, status.

Certification completion history: Previous completion count.

Category: Category name, a link to the category and the ID.

Certif Completion: Renewal status, expiration date, window opens, completion date, progress.

Certif Completion History: Previous Completions link.


↑Back to top 

Source Name:

Record of Learning: Competencies

Description:

Competency assignment and completion information, by default used to build the Record of Learning embedded report.

Columns:

Plan: Learning plan details including plan name, link to plan, start and end date, status.

Plan Template: Settings of the learning plan template.

Competency: Assigned competency information including name, priority, due date, proficiency status.

User: All user profile fields including name, email address, custom user fields.


↑Back to top 

Source Name:

Record of Learning: Courses

Description:

Course assignment and completion information, by default used to build the Record of Learning embedded report.

Columns:

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Plan: Learning plan details including plan name, link to plan, start and end date, status.

Course completion: Learner course completion details including completion date, organisation, position, and grade.

User: All user profile fields including name, email address, custom user fields.

Plan Template: Settings of the learning plan template.


↑Back to top 
Source Name:

Record of Learning: Evidence

Description:

Evidence information, by default used to build the Record of Learning embedded report.

Columns:

Evidence: name, attachments, evidence link, institution, evidence type, in use?, actions, description, date completed.

User: All user profile fields including name, email address, custom user fields.


↑Back to top 

Source Name:

Record of Learning: Objectives

Description:

Objective assignment and completion information, by default used to build the Record of Learning embedded report.

Columns:

Plan: Learning plan details including plan name, link to plan, start and end date, status.

Plan Template: Settings of the learning plan template.

Competency: Assigned competency information including name, priority, due date, proficiency status.

User: All user profile fields including name, email address, custom user fields.


↑Back to top 

Source Name:

Record of Learning: Previous Certifications

Description:

Certification assignment and course completion information, by default used to build the Record of Learning embedded report that appears when the user clicks on 'Previous Completions' in the Record of Learning: Certifications report.

Columns:

Program: Certification details including name, program short name, program ID number, certification ID.

Certification Completion: Certification path, status.

User: All user profile fields including name, email address, custom user fields.

Category: Course category name, a link to the category and the ID.


↑Back to top 

Source Name:

Record of Learning: Previous Course Completions

Description:

Provides history of course completions for courses retaken as part of a certification program.

Columns:

User: All user profile fields including name, email address, custom user fields.

Course: Course settings including course name, ID, language, visibility, and a link to the course page, date last completed by the user and grade at time of completion.


↑Back to top 

Source Name:

Record of Learning: Programs

Description:

Program assignment and completion information, by default used to build the Record of Learning embedded report.

Columns:

Program: Program settings including name, ID, and availability.

Category: Course category name, a link to the category and the ID.


↑Back to top 

Source Name:

Record of Learning: Recurring Programs

Description:

Program assignment and completion information by default used to build the Record of Learning embedded report.

Columns:

Program: Program settings including name, ID, and availability.

Category: Course category name, a link to the category and the ID.


↑Back to top 

Source Name:

SCORM

Description:

SCORM activity completion details and settings collected across all courses.

Columns:

SCO: SCORM object settings, user completion information such as completion status and date.

User: All user profile fields including name, email address, custom user fields, organisation and position.

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category and the ID.

Tags: Topics or interests that the SCORM was marked with.

Organisation custom fields: Custom type fields added to the organisation hierarchy.

Position custom fields: Custom type fields added to the position hierarchy.

Unenrolled users and site admins are excluded from the activity level SCORM report however they will be included in the SCORM report source when using Report Builder.


↑Back to top 

Source Name:

Server upgrade history

Description:

Provides information of what, who and when Totara has been upgraded.

Columns:

User: All user profile fields including name, email address, custom user fields, organisation and position.

Upgrade: information of the component upgraded.


↑Back to top 

Source Name:

Site Logs

Description:

Site-wide user activity logging.

Columns:

Log: Module, ID, IP address, Action taken, event class name.

Course: Course settings including course name, ID, language, visibility, and a link to the course page.

Category: Course category name, a link to the category and the ID.

User: All user profile fields including name, email address, custom user fields, organisation, and position.

Related user: All user profile fields including name, email address, custom user fields, organisation and position of person the action affected.

 Tags: Topics or interests that the SCORM was marked with.


↑Back to top 

Source Name:

Totara Connect clients

Description:

Provides information about Sites that are connected with Totara Connect.

Columns:

Connect: Name and details of synchronised audiences and courses that are using Totara connect.


↑Back to top 

Source Name:

HR Import Log

Description:

Logging of Totara Sync activity.

Columns:

Totara Sync Log: Run ID, date/time of run, element, log type, action, info or errors encountered.


↑Back to top 

Source Name:

User

Description:

User profile data and completion statistics.

Columns:

User: All user profile fields including name, email address, custom user fields, organisation, and position.


↑Back to top 

Report sources



Provide feedback about this page using the link in the bottom right of this page. 

Still have questions? Why not post them in the forums of the Totara Community?

  • No labels