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

Please see Totara 14 help for the latest version.

On this page

Search

In the Totara report builder, the report source you use determines the columns that are available for use within that report. Some columns will be included by default in either embedded reports or when creating a new report (user reports), but these columns can always be edited (provided you have the right permissions) to adjust them to your needs. 

User report

There are currently over 90 report sources to choose from in Totara 13. 

When creating a new report it is very easy to see the default columns included in the report source: 

  1. On your Totara instance click Reports in the top navigation bar.
  2. Select the Create report button to create a new report.
  3. Using the left-hand filtering options (such as Search and the list of report sources) find the report source you want. 
  4. Once you have found the report source click on its tile to see the list of Default columns. 

You can then choose to Create and view that report (if you don't want to make changes) or Create and edit to add or remove columns to better suit your specific requirements. 

The pop-up window showing details of a report source.

Embedded report

Although there is no quick way to view all of the default columns included in an embedded report, you can go into the report and edit it to customise the included columns. 

See Managing reports for more information.

What's new?

Below you can see details on what has changed in regards to report sources. You will find all new report sources, any column changes and a list of deprecated reports. 

New report sources

There are 22 new report sources for Totara 13. Which of these are available on your site will depend on which Totara products you have.

New Totara report sources (not product specific)

  • Tenants: Show all Totara tenants (if you have multitenancy enabled)

New Totara Learn report sources

New Totara Perform report sources

New Totara Engage report sources

  • Inappropriate content: Content that has been reported as inappropriate
  • Playlist engagement: A summary of how users are engaging with playlists (see more on the Engagement reports page)
  • Resource engagement: A summary of how users are engaging with resources (see more on the Engagement reports page)
  • Topic: A list of all topics in the system
  • Topic usage: Show all the usage of the topic in the system
  • User engagement: A summary of engagement levels from individual users (see more on the Engagement reports page)
  • Workspace engagement: A summary of how users are engaging with workspaces on your site (see more on the Engagement reports page)

Other changes

  • Record of Learning: Competencies: Is marked as disabled if Totara Perform is enabled

  • Record of Learning: Evidence: Has been replaced with the new reports on evidence (see above)

  • Competency Status History: Has been renamed to Competency Status History (legacy) and now gets its data from the new competency achievement table

  • Appraisal Detail: Has been renamed to Appraisal Detail (legacy) and is only available if legacy appraisals are enabled

  • Appraisal Status: Has been renamed to Appraisal Status (legacy) and is only available if the legacy appraisals are enabled

All available report sources

Use the list below to expand a report source and see details of its available and deprecated columns. 

 Appraisal detail (legacy)

Appraisal detail (legacy)

Performance management appraisal details including the questions and responses provided byeach appraisal user 

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns

All user's job assignments

  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager email(s)
  • User's manager email(s) (ignoring user display setting)
  • User's manager ID number(s)
  • User's manager ID(s)
  • User's manager name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's  position name(s)
  • User's position type(s)
Appraisal
  • Active stage incomplete
  • Appraisal name
  • Appraisal status
  • Appraisal time finished
  • Appraisal time started
Appraisal answers
  • All roles' answers
  • All roles' rating answers
  • All roles' score
  • Appraiser's answers
  • Appraiser's rating answers
  • Appraiser's score
  • Learner's answers
  • Learner's rating answers
  • Learner's score
  • Manager's answers
  • Manager's manager answers
  • Manager's manager rating answers
  • Manager's manager score
  • Manager's rating answers
  • Manager's score
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
User's appraisal
  • Previous stage time completed
  • User's appraisal status
  • User's appraisal time completed
  • User's current stage
  • User's current stage due

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User 
  • Job assignments
  • User's appraiser name(s)
  • User's manager name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager name(s)
 Appraisal status (legacy)

Appraisal status (legacy)

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns

All user's job assignments

  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager email(s)
  • User's manager email(s) (ignoring user display setting)
  • User's manager ID number(s)
  • User's manager ID(s)
  • User's manager name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's  position name(s)
  • User's position type(s)
Appraisal
  • Active stage incomplete
  • Appraisal name
  • Appraisal status
  • Appraisal time finished
  • Appraisal time started
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
User's appraisal
  • Previous stage time completed
  • User's appraisal status
  • User's appraisal time completed
  • User's current stage
  • User's current stage due

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User 
  • Job assignments
  • User's appraiser name(s)
  • User's manager name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager name(s)
 Assignment submissions

Assignment submissions

Submission information for individual users for the Assignment activity. 

Available columns

The following columns are currently available to use with the Assignment submissions report source. 

Column typeAvailable columns
Assignment
  • Assignment intro
  • Assignment name
  • Submission status
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Grade
  • Feedback comment
  • Grade scale values
  • last modified (grade)
  • last modified (submission)
  • Max grade
  • Min grade
  • Submission grade
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status, user audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User 
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Assignment submissions summary

Assignment submissions summary

Assignment activity submission information by assignment.

Available columns

The following columns are currently available to use with the Assignment submissions summary report source. 

Column typeAvailable columns
Assignment
  • Assignment intro
  • Assignment name
  • Average grade
  • Max grade
  • Max last marked
  • Max last modified
  • Maximum achievable grade
  • Min grade
  • Min last marked
  • Min last modified
  • Sum grade
  • User count
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
 Audience members

Audience members

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position
  • Type(s)
Audience
  • Audience name
  • Audience name (with link)
  • End date
  • ID
  • Start date
  • Status
  • Type
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Audience: Enrolled learning

Audience: Enrolled learning

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

Available columns

The following columns are currently available to use with the Audience: Enrolled learning report source. 

Column typeAvailable columns
Associations
  • Actions
  • Actual due date
  • Assignment due date
  • name
  • name (with icon and link)
  • Type
Audience
  • Audience name
  • ID
 Audiences

Audiences

Details from all the audiences in the system.

Available columns

The following columns are currently available to use with the Audiences report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Audience
  • Actions
  • Audience name
  • Audience name (with link)
  • End date
  • ID
  • No. of members
  • Start date
  • Status
  • Type
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
Tags
  • Tags
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Audiences orphaned users

Audiences orphaned users

Details on all users not in an audience.

Available columns

The following columns are currently available to use with the Audience orphaned users report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Deleted user purge type
  • Deleted purge type
  • ID
Statistics
  • Course completions as evidence
  • User's achieved competency count
  • User's courses completed count
  • User's courses started count
Suspended user purge type
  • ID
  • Suspended purge type
User
  • Extensions
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User fullname (with links to learning components)
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's My Learning icons
  • User's phone number
  • User's picture
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Badges issued

Badges issued

View users who have been issued a badge.

Available columns

The following columns are currently available to use with the Badges issued report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Badge
  • Badge description
  • Badge image
  • Badge issuer contact
  • Badge issuer name
  • Badge name
  • Badge status
  • Badge type
  • Badge ID
Badge issue
  • Badge expiry date
  • Badge issue date
  • Badge issuer notified
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Tags
  • Tags
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Certification completion

Certification completion

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

Available columns

The following columns are currently available to use with the Certification completion report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Certification
  • Active period
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Certification ID
  • Certification ID number
  • Certification name
  • Certification name (expanding details)
  • Certification name and linked Icon
  • Certification short name
  • Certification summary
  • Enrolled certification audience IDs
  • Program visible
  • Recertification method
  • Window period
Certification completion
  • Completion organisation
  • Completion organisation ID
  • Completion organisation ID
  • Completion organisation path
  • Completion position
  • Completion position ID
  • Completion position ID
  • Completion position path
  • Date assigned
  • Date completed
  • Date due
  • Date started
  • Has never certified
  • Is certified
  • Is in progress?
  • Is not certified
  • Is not started?
  • Is user assigned?
  • Progress
  • Progress (%)
  • Red-amber-green status
  • Status
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Certification exceptions

Certification exceptions

Certification exceptions information and certification details.

Available columns

The following columns are currently available to use with the Certification exemptions report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Certification
  • Active period
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Certification ID
  • Certification ID number
  • Certification name
  • Certification name (expanding details)
  • Certification name and linked icon
  • Certification short name
  • Certification summary
  • Program visible
  • Recertification method
  • Window period
Exception information
  • Time logged
  • Type of exception
Program
  • Enrolled program audience IDs
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Certification membership

Certification membership

Details of all certification memberships.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Certification
  • Active period
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Certification ID
  • Certification ID number
  • Certification name
  • Certification name (expanding details)
  • Certification name and linked icon
  • Certification short name
  • Certification summary
  • Program visible
  • Recertification method
  • Window period
Certification membership
  • Edit completion records
  • Is currently assigned
  • Is currently certified
  • Status
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's dity
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Certification overview

Certification overview

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

Available columns

The following columns are currently available to use with the Certification overview report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Certification
  • Active period
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Certification ID
  • Certification ID number
  • Certification name
  • Certification name (expanding details)
  • Certification name and linked icon
  • Certification short name
  • Certification summary
  • Program visible
  • Recertification method
  • Window period
Certification completion
  • Certification path
  • Completion organisation full name
  • Completion organisation short name
  • Completion organisation type
  • Completion position full name
  • Completion position ID
  • Completion position type
  • Completion date
  • Date assigned
  • Date started
  • Due date
  • Due date (extra info)
  • Expiration date
  • Progress
  • Progress (%)
  • Renewal status
  • Status
  • Window opens
Course
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course short name
  • Course status
  • Date completed
  • Date enrolled
  • Date started
  • Final grade
  • Grade pass
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Certifications

Certifications

Details of the certifications setup.

Available columns

The following columns are currently available to use with the Certifications report source. 

Column typeAvailable columns
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Certification
  • Active period
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Certification ID
  • Certification ID number
  • Certification name
  • Certification name (expanding details)
  • Certification name and linked icon
  • Certification short name
  • Certification summary
  • Enrolled certification audience IDs
  • Program visible
  • Recertification method
  • Window period
 Competency assignments

Competency assignments

Show users who are assigned to competencies.

Available columns

The following columns are currently available to use with the Competency assignments report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Assignments
  • Assignment type
  • User group
  • User group type
  • When assigned
Audience
  • Audience ID number
  • Audience name
Competency
  • Competency framework ID number
  • Competency framework name
  • Competency ID number
  • Competency name
  • Competency name (linked to competency page)
  • Competency type
Organisation
  • Organisation ID number
  • Organisation name
  • Organisation type
Position
  • Position ID number
  • Position name
  • Position type
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Who assigned
  • User first name
  • User ID number
  • User last name
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Competency status

Competency status

Learners' progress on their assigned competencies.

Available columns

The following columns are currently available to use with the Competency status report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Competency
  • Competency ID
  • Competency ID number
  • Competency name
  • Date achievement level achieved
  • Minimum proficiency level
Competency assignment
  • Archived date
  • Assignment activity log link
  • Assignment status
  • Assignment type
  • Date assigned
  • User group
Competency status
  • Achievement level
  • Achievement level related ID (scale value ID number)
  • Proficiency status
  • Scale value numerical value
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Competency status history (legacy)

Competency status history (legacy)

Learners' progress on their assigned competencies.

Available columns

The following columns are currently available to use with the Competency status history (legacy) report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Competency
  • Competency ID
  • Competency name
Competency status history
  • Competency proficiency ID
  • Date proficiency achieved
  • Time when user achieved the value
  • User's goal status
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser's name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Completion import: Certification status

Completion import: Certification status

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

Available columns

The following columns are currently available to use with the Completion import: Certification status report source. 

Column typeAvailable columns
Import
  • Certification ID number
  • Certification shortname
  • Completion date
  • Due date
  • Errors
  • ID
  • Imported as evidence?
  • Imported by user ID
  • Line number
  • Record processed
  • Time uploaded
  • Username to import
Imported by
  • Imported by
  • Imported by username
 Completion import: Course status

Completion import: Course status

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

Available columns

The following columns are currently available to use with the Completion import: Course status report source. 

Column typeAvailable columns
Import
  • Completion date
  • Course ID number
  • Course shortname
  • Errors
  • Grade
  • ID
  • Imported as evidence?
  • Imported by user ID
  • Line number
  • Record processed
  • Time uploaded
  • Username to import
Imported by
  • Imported by
  • Imported by username
 Course completion

Course completion

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

Available columns

The following columns are currently available to use with the Course completion report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser's name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Course completion
  • Completion organisation ID
  • Completion organisation ID
  • Completion organisation name
  • Completion organisation path
  • Completion position ID
  • Completion position ID
  • Completion position name
  • Completion position path
  • Completion status
  • Date enrolled
  • Date started
  • Enrolment types
  • Grade
  • Grade and required grade
  • Is complete? (any method)
  • Is complete? (not via RPL)
  • Is complete? (via RPL)
  • Is in progress?
  • Is not complete?
  • Is not yet started?
  • Pass grade
  • Progress
  • Progress (%)
  • RPL note
  • The completion date
  • Time to complete (since enrol date)
  • Time to complete (since start date)
Tags
  • Tags
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser's name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
  Course completion including history

Course completion including history

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Course completion
  • Date completed
  • Grade at time of completion
  • Is current record
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Course completion by organisation

Course completion by organisation

Course completion details grouped by organisation.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Course completion
  • Completion organisation ID
  • Completion organisation name
  • Completion organisation path (IDs)
  • Completion organisation path (text)
  • Earliest completion date
  • Latest completion date
  • Number completed
  • Number completed via RPL
  • Number in progress
  • Number not started
  • Number of records
  • Percentage completed
  • Percentage completed via RPL
User
  • All participants
 Course membership

Course membership

Details about course members.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Course membership
  • Edit course completion
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Courses

Courses

Details about all the courses.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Content
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Tags
  • Tags
 Deleted user accounts

Deleted user accounts

Details about deleted users including their purge type.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Deleted user purge type
  • Deleted purge type
  • ID
Suspended user purge type
  • ID
  • Suspended purge type
User
  • Actions
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Evidence

Evidence

Shows evidence items, including details of their creator, owner, use and location.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Evidence item
  • Actions
  • Creation date
  • In use
  • Last modified date
  • Location
  • Name
  • Source
Evidence item creator
  • Creator
  • Creator's organisation
  • Creator's organisation ID number
  • Creator's organisation type
  • Creator's position
  • Creator's position ID number
  • Creator's position type
Evidence item last modified by
  • Last modifier
  • Last modifier's organisation
  • Last modifier's organisation ID number
  • Last modifier's organisation type
  • Last modifier's position
  • Last modifier's position ID number
  • Last modifier's position type
Evidence item subject user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Evidence type
  • Type
  • Type ID number
  • Type creation date
  • Type description
  • Type last modified date

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Evidence item subject user
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Evidence types

Evidence types

Show details and configuration of evidence types.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Evidence type
  • Actions
  • Creation date
  • Creator
  • Custom fields
  • Description
  • In use
  • Last modified date
  • Last modifier
  • Location
  • Status
  • Type ID number
  • Type name
 Feedback summary

Feedback summary

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Course tags
  • Tags
Feedback
  • Feedback activity
Feedback tags
  • Tags
Responses
  • Time completed
Trainer
  • Trainer full name
  • Trainer ID
  • Trainer organisation
  • Trainer organisation ID
  • Trainer position
  • Trainer position ID
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Goal custom fields

Goal custom fields

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Goals
  • All company goal custom fields
  • All personal goal custom fields
  • Goal description
  • Goal name
  • Goal type
  • Personal or company
  • Status
  • Target date
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Goal status

Goal status

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Goal
  • Goal framework name
  • Goal name
  • User's goal status
  • User's goal status history link
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Goal status history

Goal status history

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Goal
  • Goal name
  • Goal type
Goal status history
  • User's goal status
  • User's status modifed by user
  • User's status time modified
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Goal summary

Goal summary

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Company goal type
  • Goal type
Goal
  • Goal name
  • Goal name with link
  • Number of users assigned
  • Scale count columns
 HR import log

HR import log

Logging of HR import activity.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
HR import log
  • Action
  • Date/time
  • Element
  • Info
  • Log type
  • Run ID
  • ID
  Inappropriate content

Inappropriate content

Content that has been reported as inappropriate by users.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Content creator
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Inappropriate content
  • Content
  • Date created
  • Date reported
  • Date reviewed
  • Link
  • Status
Reporter
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Reviewer
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Content creator
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
Reporter
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
Reviewer
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Job assignments

Job assignments

List of job assignments.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Appraiser
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Job assignment
  • End date
  • Full name
  • ID number
  • Short name
  • Start date
Manager
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Organisation
  • Framework
  • Framework ID number
  • ID number
  • Name
  • Short name
  • Type
  • Type ID number
  • Visible
Position
  • Framework
  • Framework ID number
  • ID number
  • Name
  • Short name
  • Type
  • Type ID number
  • Visible
Temporary manager
  • HR import
  • Temporary manager expiry date
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Appraiser
  • Job assignments
  • User's appraiser name(s)
  • User's manager name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager name(s)
Manager
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
Temporary manager's
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Known trusted SCORM packages

Known trusted SCORM packages

List of known trusted SCORM packages.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Package
  • Actions
  • File names
  • Package content hash
  • Usage count
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Language customisations

Language customisations

Shows customisations to the language pack.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Component
  • Component
  • Component version
Customisation
  • Customised
  • Language
  • Local
  • Original
  • String ID
 Learning plans

Learning plans

Learning plan information by user.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Plan
  • Completion date
  • Description
  • Plan end date
  • Plan name
  • Plan name (linked to plan page)
  • Plan start date
  • Plan status
Plan template
  • Plan template end date
  • Plan template name
  • Plan template start date
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager name(s)
 Legacy site logs

Legacy site logs

Site-wide user activity logging.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Log
  • Action
  • Action (linked to URL)
  • CMID
  • IP address
  • Info
  • Module
  • Time
  • URL
Tags
  • Tags
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager name(s)
 Local SCORM packages

Local SCORM packages

List of all local packages used in SCORM activities.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Course tags
  • Tags
Package
  • Current package
  • Package content hash
  • Package file
  • Trusted package
SCORM
  • SCORM title
SCORM tags
  • Tags
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Messages

Messages

Alerts and notifications sent by the system.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Message values
  • Message category
  • Message content
  • Message type
  • Message type (text)
  • Message urgency
  • Message urgency (icon)
  • Select
  • Sent
  • Subject
Recipient user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Recipient user
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Organisations

Organisations

Organisation structure details.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Organisation
  • Competencies
  • Created
  • Description
  • Framework
  • Framework ID number
  • ID number
  • Member count
  • Member count (including child organisations)
  • Modified
  • Name
  • Parent ID number
  • Parent name
  • Short name
  • Type
  • Type ID number
  • Visible
 Performance participant instance

Performance participant instance

Participant progress in performance activities.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Participant instance
  • Availability
  • Date updated
  • Instance creation date
  • Overdue
  • Participant source
  • Participant's email
  • Participant's email (ignoring user display setting)
  • Participant's name
  • Progress
  • Relationship ID
  • Relationship name
  • Relationship sort order
Participant user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Performance activity
  • Activity type
  • Performance activity name
Subject instance
  • Activity job ID number
  • Activity job title
  • Availability
  • Date completed
  • Date updated
  • Due date
  • Instance creation date
  • Instance number
  • Overdue
  • Progress
Subject user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Participant user
  • Job assignments
  • User's appraiser name(s)
  • User's manager name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager name(s)
Subject user
  • Job assignments
  • User's appraiser name(s)
  • User's manager name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager name(s)
 Performance participant section

Performance participant section

Section progress in performance activities.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Participant instance
  • Availability
  • Date updated
  • Instance creation date
  • Overdue
  • Participant source
  • Participant's email
  • Participant's email (ignoring user display setting)
  • Participant's name
  • Progress
  • Relationship ID
  • Relationship name
  • Relationship sort order
Participant section
  • Availability
  • Progress
Participant user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Performance activity
  • Activity type
  • Performance activity name
Section
  • Date updated
  • Instance creation date
  • Responding relationships
  • Section sort order
  • Section title
Subject instance
  • Activity job ID number
  • Activity job title
  • Availability
  • Date completed
  • Date updated
  • Due date
  • Instance creation date
  • Instance number
  • Overdue
  • Progress
Subject user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Participant user
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
Subject user
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Performance questions

Performance questions

Questions from performance activities.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Element
  • Element type
  • Question text
  • Reporting ID
  • Required
  • Sort order
Performance activity
  • Activity type
  • Performance activity name
Section
  • Date updated
  • Instance creation date
  • Responding relationships
  • Section sort order
  • Section title
 Performance subject instance

Performance subject instance

Subject progress in performance activities.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Performance activity
  • Activity type
  • Performance activity name
Subject instance
  • Activity job ID number
  • Activity job title
  • Availability
  • Date completed
  • Date updated
  • Due date
  • Instance creation date
  • Instance number
  • Overdue
  • Participant count
  • Progress
Subject user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Subject user
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Playlist engagement

Playlist engagement

User-generated content summary.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Playlists engagement
  • Comments
  • Created date
  • Number of resources
  • Playlist title
  • Rating
  • Shares
  • Topics
  • Updated date
  • Views
  • Visibility
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Positions

Positions

Position structure details.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Position
  • Competencies
  • Created
  • Description
  • Framework
  • Framework ID number
  • ID number
  • Member count
  • Member count (including child positions)
  • Modified
  • Name
  • Parent ID number
  • Parent name
  • Short name
  • Type
  • Type ID number
  • Visible
 Program completion

Program completion

Program completion information and program details.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Program
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Enrolled program audience IDs
  • Program ID
  • Program ID number
  • Program name
  • Program name (expanding details)
  • Program name and linked icon
  • Program short name
  • Program summary
  • Program visible
Program completion
  • Completion organisation
  • Completion organisation ID
  • Completion organisation ID
  • Completion organisation path
  • Completion position
  • Completion position ID
  • Completion position ID
  • Completion position path
  • Date assigned
  • Date completed
  • Date due
  • Date started
  • Is complete?
  • Is in progress?
  • Is not complete?
  • Is not started?
  • Is user assigned?
  • Progress
  • Progress (%)
  • Status
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Program exceptions

Program exceptions

Program exceptions information and program details.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Exception Information
  • Time logged
  • Type of exception
Program
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Enrolled program audience IDs
  • Program ID
  • Program ID number
  • Program name
  • Program name (expanding details)
  • Program name and linked icon
  • Program short name
  • Program summary
  • Program visible
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Program membership

Program membership

All program assignment details.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Program
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Program ID
  • Program ID number
  • Program name
  • Program name (expanding details)
  • Program name and linked icon
  • Program short name
  • Program summary
  • Program visible
Program membership
  • Edit completion records
  • Is currently assigned
  • Status
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Program overview

Program overview

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course short name
  • Course status
  • Date completed
  • Date enrolled
  • Date started
  • Final grade
  • Grade pass
Program
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Program ID
  • Program ID number
  • Program name
  • Program name (expanding details)
  • Program name and linked icon
  • Program short name
  • Program summary
  • Program visible
Program completion
  • Completion organisation full name
  • Completion organisation short name
  • Completion organisation type
  • Completion position full name
  • Completion position ID
  • Completion position type
  • Date completed
  • Date assigned
  • Date started
  • Due date
  • Due date (extra info)
  • Program status
  • Progress
  • Progress (%)
User
  • HR import
  • Tenan
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Programs

Programs

Details about the programs and course category.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Program
  • Audience visibility (not applicable)
  • Available from
  • Available until
  • Enrolled program audience IDs
  • Program ID
  • Program ID number
  • Program name
  • Program name (expanding details)
  • Program name and linked icon
  • Program short name
  • Program summary
  • Program visible
 Record of learning: Certifications

Record of learning: Certifications

Certification assignment and course completion information.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Certification completion history
  • Previous completion count
  • Previous completions
Certification completions
  • Certification due date
  • Certification path
  • Completion date
  • Expiration date
  • Progress
  • Progress (%)
  • Renewal status
  • Status
  • Window opens
Programs
  • Certification ID
  • Certification name and linked icon
  • Certification name
  • Program ID number
  • Program short name
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Record of learning: Courses

Record of learning: Courses

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Course completion
  • Completion status
  • Course completion date
  • Enrolled
  • Grade
  • Grade and required grade
  • Pass grade
  • Progress (%)
Plan
  • Course due date
  • Course priority
  • Course progress
  • Course status
  • Plan end date
  • Plan name
  • Plan name (linked to plan page)
  • Plan start date
  • Plan status
  • Progress (and approval status)
Plan template
  • Plan template end date
  • Plan template name
  • Plan template start date
Previous course completions
  • Previous completion count
  • Previous completions
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Record of learning: Objectives

Record of learning: Objectives

Objective assignment and completion information.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Objective
  • Achieved objective?
  • Date created
  • Date updated
  • Description
  • Full name
  • Full name (linked to detail page)
  • Objective approved
  • Objective due date
  • Objective priority
  • Objective status
  • Objective status (and approval status)
  • Short name
Plan
  • Plan end date
  • Plan name
  • Plan name (linked to plan page)
  • Plan start date
  • Plan status
Plan template
  • Plan template end date
  • Plan template name
  • Plan template start date
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Record of learning: Previous certifications

Record of learning: Previous certifications

Certification assignment and course completion information including previous certifications.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Certification completion
  • Certification ID
  • Completion date
  • Current?
  • Expiration date
  • Progress
  • Progress (%)
  • Renewal status
  • Status
Program
  • Certification name
  • Certification name
  • Program ID number
  • Program short name
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Record of learning: Previous course completions

Record of learning: Previous course completions

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

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Course completion history
  • Date completed
  • Grade at time of completion
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Record of learning: Programs

Record of learning: Programs

Program assignment and completion information.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Program
  • Enrolled program audience IDs
  • Program ID
  • Program ID number
  • Program name
  • Program name and linked icon
  • Program short name
  • Program due date
  • Program mandatory
  • Program recurring
Program completion
  • Date assigned
  • Date completed
  • Date started
  • Progress
  • Progress (%)
Program completion history
  • Count of previous completions
  • Previous completions
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Record of learning: Recurring programs

Record of learning: Recurring programs

Historic program assignment and completion information.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Program
  • Program ID
  • Program ID number
  • Program name
  • Program name and linked icon
  • Program short name
Program completion history
  • Completion date
  • Course name
  • Due date
  • Status
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Reports

Reports

Lists all report sources available.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Report
  • Abstract
  • Actions
  • Export format override?
  • Export formats
  • Global report restrictions
  • Is embedded report?
  • Is hidden on My reports?
  • Name (linked to edit report)
  • Name (linked to edit report) and view link
  • Name (linked to view report)
  • Number of columns
  • Number of filters
  • Number of saved searches
  • Number of scheduled reports
  • Report ID
  • Report name
  • Source
 Resources engagement

Resources engagement

Content engagement summary.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Content engagement
  • Comments
  • Created date
  • Likes
  • Playlists
  • Resource
  • Shares
  • Topics
  • Views
  • Visibility
  • Workspaces
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 SCORM

SCORM

SCORM activity completion details and settings collected across all courses.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Course tags
  • Tags
SCO
  • SCO attempt number
  • SCO max score
  • SCO min score
  • SCO score
  • SCO start time
  • SCO status
  • SCO status modified
  • SCO title
  • SCO total time
SCORM
  • SCORM title
SCORM tags
  • Tags
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Saved report searches

Saved report searches

List all saved report searches in the system.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Report
  • Abstract
  • Actions
  • Export format override?
  • Export formats
  • Global report restrictions
  • Is embedded report?
  • Is hidden on My reports?
  • Name (linked to edit report)
  • Name (linked to edit report) and view link
  • Name (linked to view report)
  • Number of columns
  • Number of filters
  • Number of saved searches
  • Number of scheduled reports
  • Report ID
  • Report name
  • Source
Saved search
  • Modified
  • Number of scheduled reports
  • Search name
  • Shared
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Scheduled reports

Scheduled reports

Information about the scheduled reports in the system.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Report
  • Abstract
  • Actions
  • Export format override?
  • Export formats
  • Global report restrictions
  • Is embedded report?
  • Is hidden on My reports?
  • Name (linked to edit report)
  • Name (linked to edit report) and view link
  • Name (linked to view report)
  • Number of columns
  • Number of filters
  • Number of saved searches
  • Number of scheduled reports
  • Report ID
  • Report name
  • Source
Saved search
  • Saved search name
Schedule
  • Export destination
  • Format
  • Last modified by
  • Last modified time
  • Next schedule
  • Recipients (audiences)
  • Recipients (external)
  • Recipients (system users)
  • Schedule
  • Scheduler actions
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Self-registration requests

Self-registration requests

Details of pending self-registration requests.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Created user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Organisation
  • Organisation
  • Organisation framework
Position
  • Position
  • Position framework
Request
  • Actions
  • Additional request data
  • Email confirmed
  • Manager's free text
  • Organisation free text
  • Position free text
  • Status
  • Time modified
  • Time requested
  • Time resolved
  • User first name
  • User last name
  • User's city
  • User's country
  • User's email
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Created user
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Seminar asset assignments

Seminar asset assignments

Upcoming events using assets.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Assets
  • Asset allow booking conflicts
  • Asset description
  • Asset ID
  • Asset name
  • Asset name (linked to asset details page)
  • Asset sitewide
  • Asset visible
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Date
  • Local session finish date/time
  • Local session start date/time
  • Session finish date
  • Session finish date/time
  • Session finish date/time (linked to activity)
  • Session finish time
  • Session ID
  • Session start date
  • Session start date/time
  • Session start date/time (linked to activity)
  • Session start time
Events
  • Booking status
  • Event ID
  • Event maximum bookings
  • Event status
  • Number of attendees
  • Number of attendees (linked to attendee page)
Facilitators
  • Facilitator allow booking conflicts
  • Facilitator bio
  • Facilitator ID
  • Facilitator name
  • Facilitator name (linked to facilitator details page)
  • Facilitator sitewide
  • Facilitator user ID
  • Facilitator visible
Rooms
  • Room allow booking conflicts
  • Room capacity
  • Room description
  • Room ID
  • Room link
  • Room name
  • Room name (linked to room details page)
  • Room sitewide
  • Room visible
Seminar
  • Approval type
  • Seminar ID
  • Seminar name
  • Seminar name (linked to event page)

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Seminar
  • Event ID
 Seminar assets

Seminar assets

List of seminar assets.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Assets
  • Actions
  • Allow booking conflicts
  • Description
  • ID
  • Name
  • Name (linked to asset details page)
  • Sitewide
  • Visible
 Seminar events

Seminar events

Lists all seminar events.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Event
  • Booking status
  • Event attendance
  • Event attendance (linked to take attendance page)
  • Event created
  • Event details
  • Event finish date/time
  • Event ID
  • Event maximum bookings
  • Event start date/time
  • Event status
  • Last updated
  • Last updated by
  • Number of attendees
  • Number of attendees (inc. waiting approval, approved and wait-listed)
  • Number of attendees (linked to attendee page)
  • Number of cancelled bookings
  • Number of declined attendees
  • Number of fully attended
  • Number of no shows
  • Number of partially attended
  • Number of unable to attend
  • Number of wait-listed
  • Overbooking allowed
  • Places available
  • Viewer's status
Seminar
  • Approval type
  • Discount cost
  • Minimum bookings
  • Normal cost
  • Seminar ID
  • Seminar name
  • Seminar name (linked to event page)

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Seminar
  • Event ID
 Seminar facilitators

Seminar facilitators

List of seminar facilitators.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Facilitator
  • Actions
  • Allow booking conflicts
  • Bio
  • ID
  • Name
  • Name (linked to facilitator details page)
  • Sitewide
  • User ID
  • Visible
 Seminar facilitators assignments

Seminar facilitators assignments

Upcoming events using facilitators.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Assets
  • Asset allow booking conflicts
  • Asset description
  • Asset ID
  • Asset name
  • Asset name (linked to asset details page)
  • Asset sitewide
  • Asset visible
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Date
  • Local session finish date/time
  • Local session start date/time
  • Session finish date
  • Session finish date/time
  • Session finish date/time (linked to activity)
  • Session finish time
  • Session ID
  • Session start date
  • Session start date/time
  • Session start date/time (linked to activity)
  • Session start time
Events
  • Booking status
  • Event ID
  • Event maximum bookings
  • Event status
  • Number of attendees
  • Number of attendees (linked to attendee page)
Facilitators
  • Facilitator allow booking conflicts
  • Facilitator bio
  • Facilitator ID
  • Facilitator name
  • Facilitator name (linked to facilitator details page)
  • Facilitator sitewide
  • Facilitator user ID
  • Facilitator visible
Rooms
  • Room allow booking conflicts
  • Room capacity
  • Room description
  • Room ID
  • Room link
  • Room name
  • Room name (linked to room details page)
  • Room sitewide
  • Room visible
Seminar
  • Approval type
  • Seminar ID
  • Seminar name
  • Seminar name (linked to event page)

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Seminar
  • Event ID
 Seminar interest

Seminar interest

Details on users who have declared interest in attending a seminar.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Seminar
  • Date of declared interest
  • Seminar name
  • Seminar name (linked to event page)
  • Stated reason for interest
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Seminar room assignments

Seminar room assignments

Upcoming events using rooms.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Assets
  • Asset allow booking conflicts
  • Asset description
  • Asset ID
  • Asset name
  • Asset name (linked to asset details page)
  • Asset sitewide
  • Asset visible
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Date
  • Local session finish date/time
  • Local session start date/time
  • Session finish date
  • Session finish date/time
  • Session finish date/time (linked to activity)
  • Session finish time
  • Session ID
  • Session start date
  • Session start date/time
  • Session start date/time (linked to activity)
  • Session start time
Events
  • Booking status
  • Event ID
  • Event maximum bookings
  • Event status
  • Number of attendees
  • Number of attendees (linked to attendee page)
Facilitators
  • Facilitator allow booking conflicts
  • Facilitator bio
  • Facilitator ID
  • Facilitator name
  • Facilitator name (linked to facilitator details page)
  • Facilitator sitewide
  • Facilitator user ID
  • Facilitator visible
Rooms
  • Building
  • Location
  • Room allow booking conflicts
  • Room capacity
  • Room description
  • Room ID
  • Room link
  • Room name
  • Room name (linked to room details page)
  • Room sitewide
  • Room visible
Seminar
  • Approval type
  • Seminar ID
  • Seminar name
  • Seminar name (linked to event page)

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Seminar
  • Event ID
 Seminar rooms

Seminar rooms

List of seminar rooms.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Room
  • Actions
  • Allow booking conflicts
  • Building
  • Capacity
  • Description
  • ID
  • Link
  • Location
  • Name
  • Name (linked to room details page)
  • Sitewide
  • Visible
 Seminar sessions

Seminar sessions

Details on all seminar sessions.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Asset
  • Asset allow booking conflicts
  • Asset description
  • Asset ID
  • Asset name
  • Asset name (linked to asset details page)
  • Asset sitewide
  • Asset visible
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Type
Date
  • Local session finish date/time
  • Local session start date/time
  • Session finish date
  • Session finish date/time
  • Session finish date/time (linked to activity)
  • Session finish time
  • Session ID
  • Session start date
  • Session start date/time
  • Session start date/time (linked to activity)
  • Session start time
Event
  • Booking status
  • Event created
  • Event details
  • Event ID
  • Event maximum bookings
  • Event status
  • Last updated
  • Last updated by
  • Number of attendees
  • Number of attendees (inc. waiting approval, approved and wait-listed)
  • Number of attendees (linked to attendee page)
  • Number of cancelled bookings
  • Number of declined attendees
  • Number of fully attended
  • Number of no shows
  • Number of partially attended
  • Number of unable to attend
  • Number of wait-listed
  • Overbooking allowed
  • Places available
  • Sign-up date/time period
  • Sign-up end date/time
  • Sign-up start date/time
  • Viewer's status
Facilitator
  • Facilitator allow booking conflicts
  • Facilitator bio
  • Facilitator ID
  • Facilitator name
  • Facilitator name (linked to facilitator details page)
  • Facilitator sitewide
  • Facilitator user ID
  • Facilitator visible
Room
  • Building
  • Location
  • Room allow booking conflicts
  • Room capacity
  • Room description
  • Room ID
  • Room link
  • Room name
  • Room name (linked to room details page)
  • Room sitewide
  • Room visible
Seminar
  • Approval type
  • Discount cost
  • Minimum bookings
  • Normal cost
  • Seminar ID
  • Seminar name
  • Seminar name (linked to event page)

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Seminar
  • Event ID
 Seminar sign-in sheet

Seminar sign-in sheet

A record of everyone who has signed into a seminar session.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Course tags
  • Tags
Event
  • Booked by
  • Discount code
  • Discount cost
  • Event details
  • Event finish date/time
  • Event ID
  • Event maximum bookings
  • Event start date/time
  • Normal cost
  • Number of attendees
  • Number of attendees (linked to attendee page)
Room
  • Room allow booking conflicts
  • Room capacity
  • Room description
  • Room ID
  • Room link
  • Room name
  • Room name (linked to room details page)
  • Room sitewide
  • Room visible
Seminar
  • Seminar name
  • Seminar name (linked to session page)
Seminar tags
  • Tags
Session date
  • Local session finish date/time
  • Local session start date/time
  • Session finish date
  • Session finish date/time
  • Session finish date/time (linked to activity)
  • Session finish time
  • Session ID
  • Session start date
  • Session start date/time
  • Session start date/time (linked to activity)
  • Session start time
Signup note custom fields
  • Requests for session organiser
Status
  • Status
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
User session signups
  • Signature

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Seminar
  • Event ID
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Seminar sign-ups

Seminar sign-ups

Provides detailed information of seminar events and who has signed up for them.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Approver
  • Approval date/time
  • Approver email
  • Approver name
Asset
  • Asset allow booking conflicts
  • Asset description
  • Asset ID
  • Asset name
  • Asset name (linked to asset details page)
  • Asset sitewide
  • Asset visible
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Course tags
  • Tags
Date
  • Local session finish date/time
  • Local session start date/time
  • Session finish date
  • Session finish date/time
  • Session finish date/time (linked to activity)
  • Session finish time
  • Session ID
  • Session start date
  • Session start date/time
  • Session start date/time (linked to activity)
  • Session start time
Event
  • Booked by
  • Cancellation date/time
  • Cancelled status
  • Discount code
  • Discount cost
  • Event details
  • Event ID
  • Event maximum bookings
  • Job assignment
  • Link to approval requests
  • Normal cost
  • Number of attendees
  • Number of attendees (linked to attendee page)
  • Position on sign up
  • Sign-up date/time period
  • Sign-up end date/time
  • Sign-up start date/time
Facilitator
  • Facilitator allow booking conflicts
  • Facilitator bio
  • Facilitator ID
  • Facilitator name
  • Facilitator name (linked to facilitator details page)
  • Facilitator sitewide
  • Facilitator user ID
  • Facilitator visible
Room
  • Building
  • Location
  • Room allow booking conflicts
  • Room capacity
  • Room description
  • Room ID
  • Room link
  • Room name
  • Room name (linked to room details page)
  • Room sitewide
  • Room visible
Seminar
  • Seminar name
  • Seminar name (linked to event page)
Seminar tags
  • Tags
Signup custom fields
  • All sign up custom fields
  • Requests for session organiser
Status
  • Actioned by
  • Archived
  • Date/time of sign-up
  • Event grade
  • Status
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username 
User cancellation
  • All cancellation custom fields
  • Cancellation note

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Seminar
  • Event ID
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Server upgrade history

Server upgrade history

Provides information about the upgrade history of the site.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Upgrade log
  • Backtrace
  • Component
  • Details
  • Info
  • Target version
  • Time
  • Type
  • Version
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Site logs

Site logs

Site-wide user activity logging.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Category
  • Course category
  • Course category (linked to category)
  • Course category ID
  • Course category ID number
Course
  • Audience visibility (not applicable)
  • Course date created
  • Course end date
  • Course ID
  • Course ID number
  • Course icon
  • Course name
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course name (linked to course page)
  • Course name and summary
  • Course shortname
  • Course start date
  • Course summary
  • Course type
  • Course visible
  • Course language
  • Course mobile compatibility
  • Enrolled course audience IDs
  • Type
Log
  • Action
  • All events
  • CRUD
  • Component
  • Context
  • Description
  • Event class name
  • Event name
  • Event name (linked to event source)
  • IP address
  • Object ID
  • Object table
  • Origin
  • Other info
  • Target
  • Target & action
  • Time
  • User full name (including login on behalf of user)
Real user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Related user
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Tags
  • Tags
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Real user
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's Temporary manager's name(s)
Related user
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's Temporary manager's name(s)
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's Temporary manager's name(s)
 Site policy records

Site policy records

All site policies and how users have responded.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Primary policy
  • Consent statement (primary)
  • Created by
  • Date created
  • Date published
  • Policy title
  • Published by
  • Response (primary)
  • Status
  • Version number
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
User response
  • Consent statement
  • Consented (Yes/No)
  • Date consented
  • Language consented in
  • Response

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Tenants

Tenants

Show all Totara tenants.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Created by
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Tenant
  • Actions
  • Category
  • Created
  • Description
  • Domain manager's
  • ID
  • Name
  • Number of members
  • Number of participants
  • Suspended
  • Tenant
  • Tenant identifier
  • Tenant participants
  • Tennant login page
  • User manager's

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Created by
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Topic

Topic

Topics in the system.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Topic
  • Actions
  • Modified at
  • Topic
 Topic usage

Topic usage

Show the usage information for the topics in the system.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Topic
  • Modified at
  • Topic
Usage
  • Component
  • Total usage
 User

User

User profile data and completion statistics.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
All user's job assignments
  • Number of job assignments
  • User's appraiser name(s)
  • User's job end date(s)
  • User's job start date(s)
  • User's job title(s)
  • User's manager's email(s)
  • User's manager's email(s) (ignoring user display setting)
  • User's manager's ID number(s)
  • User's manager's ID(s)
  • User's manager's name(s)
  • User's manager's first name(s)
  • User's manager's last name(s)
  • User's organisation framework ID number(s)
  • User's organisation framework ID(s)
  • User's organisation framework(s)
  • User's organisation ID number(s)
  • User's organisation ID(s)
  • User's organisation name(s)
  • User's organisation type(s)
  • User's position framework ID number(s)
  • User's position framework ID(s)
  • User's position framework(s)
  • User's position ID number(s)
  • User's position ID(s)
  • User's position name(s)
  • User's position type(s)
Deleted user purge type
  • Deleted purge type
  • ID
Statistics
  • Course completions as evidence
  • User's achieved competency count
  • User's courses completed count
  • User's courses started count
Suspended user purge type
  • ID
  • Suspended purge type
User
  • Actions
  • Extensions
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User fullname (with links to learning components)
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's My learning icons
  • User's phone number
  • User's picture
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 User engagement

User engagement

User engagement summary.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
User engagement
  • Private resources created
  • A member of workspaces
  • Comments under other contributions
  • Creator
  • Playlists created
  • Public resources created
  • Resource/playlists linked to workspaces
  • Resources created
  • Restricted resources created
  • Workspaces owned

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 User data export items

User data export items

All of the user export items.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Created by
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Export
  • Context
  • Created
  • Finished
  • ID
  • Origin
  • Result
  • Started
Item
  • Finished
  • ID
  • Internal item name
  • Item
  • Item component
  • Result
  • Started
Type
  • Actions
  • Changed
  • Created
  • Description
  • Full name
  • Full name (with link)
  • ID
  • ID number
  • Include files
  • New items
  • Permitted use
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Created by
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 User data export type items

User data export type items

All of the types of export items.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Items
  • Export data
  • ID
  • Internal item name
  • Item
  • Item component
Type
  • Actions
  • Changed
  • Created
  • Description
  • Full name
  • Full name (with link)
  • ID
  • ID number
  • Include files
  • New items
  • Permitted use



 User data export types

User data export types

All of the user data export types.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Export type
  • Actions
  • Changed
  • Created
  • Description
  • Full name
  • Full name (with link)
  • ID
  • ID number
  • Include files
  • New items
  • Permitted use
 User data exports

User data exports

User profile data and completion statistics.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Created by
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Export
  • Context
  • Created
  • Finished
  • ID
  • Origin
  • Result
  • Started
Type
  • Actions
  • Changed
  • Created
  • Description
  • Full name
  • Full name (with link)
  • ID
  • ID number
  • Include files
  • New items
  • Permitted use
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Created by
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
  User data purge items

User data purge items

All of the user purge items.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Created by
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Item
  • Finished
  • ID
  • Internal item name
  • Item
  • Item component
  • Result
  • Started
Purge
  • Actions
  • Context
  • Created
  • Finished
  • ID
  • Origin
  • Result
  • Started
Type
  • Actions
  • Available use
  • Changed
  • Created
  • Description
  • Full name
  • Full name (with link)
  • ID
  • ID number
  • New items
  • User status restriction
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Created by
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 User data purge type items

User data purge type items

All of the types of purge items.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Items
  • ID
  • Internal item name
  • Item
  • Item component
  • Purge data
Type
  • Actions
  • Available use
  • Changed
  • Created
  • Description
  • Full name
  • Full name (with link)
  • ID
  • ID number
  • New items
  • User status restriction
 User data purge types

User data purge types

All of the data purge types.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Purge type
  • Actions
  • Available use
  • Changed
  • Created
  • Description
  • Full name
  • Full name (with link)
  • ID
  • ID number
  • New items
  • User status restriction
 User data purges

User data purges

A record of all of the purges that have been run.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
Created by
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Purge
  • Actions
  • Context
  • Created
  • Finished
  • ID
  • Origin
  • Result
  • Started
Type
  • Actions
  • Available use
  • Changed
  • Created
  • Description
  • Full name
  • Full name (with link)
  • ID
  • ID number
  • New items
  • User status restriction
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
Created by
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)
 Workspaces engagement

Workspaces engagement

Summary of engagement in workspaces.

Available columns

The following columns are currently available to use with this report source. 

Column typeAvailable columns
User
  • HR import
  • Tenant
  • Tenant member
  • Timezone
  • User alternate name
  • User creation time
  • User first access
  • User first access (relative)
  • User first name
  • User first name - phonetic
  • User ID
  • User ID number
  • User last login
  • User last login (relative)
  • User last modified
  • User last name
  • User last name - phonetic
  • User middle name
  • User status
  • User audience IDs
  • User's address
  • User's authentication method
  • User's city
  • User's country
  • User's department
  • User's email
  • User's email (ignoring user display setting)
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's institution
  • User's mobile phone number
  • User's phone number
  • User's preferred language
  • Username
Workspace engagement
  • Comments in discussions
  • Discussions
  • Files
  • Linked playlists
  • Linked resources
  • Members
  • Owner
  • Visibility
  • Workspace title

Deprecated columns

The following columns have been deprecated and will be removed from a future version of Totara. 

Column typeDeprecated columns
User
  • Job assignments
  • User's appraiser name(s)
  • User's manager's name(s)
  • User's organisation ID number(s)
  • User's organisation name(s)
  • User's position ID number(s)
  • User's position name(s)
  • User's temporary manager's name(s)


Totara Academy

The Totara Academy has a whole course dedicated to using Reports in Totara. Here you can learn more on how to use reports, see best practice, and give it a go yourself.

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 on the Totara Community?



  • No labels