Report sources
  • 29 Jan 2024
  • 93 minutes to read

Report sources


Article Summary

Within Totara the report source 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. 

When creating a new report you will be provided with a summary of the default columns when you select the report source. Full instructions can be found on the View report default columns page. 

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. 

Notes

For some report sources you may want to use either the User last login column or the User last login (Relative) column, which are similar, but could be useful for different reports. User last login displays the absolute date, e.g. 8 Sep 2022. User last login (Relative) shows a natural language string, depending on how long ago the point of time is. Here are some examples of possible strings:

  •  Within the last five minutes
  •  Within the last hour
  •  Yesterday at 11:14 AM
  •  23 days ago
  •  A month ago
  •  2 years ago

All available report sources

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

Activity completion

Activity completion status records including user details, activity details and completion status.

Available columns

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

Column typeAvailable columns
Activity completion
  • Activity completion date
  • Activity grade
  • Activity complete
Activity
  • Activity name
  • Activity type
  • Activity completion is enabled
  • Is criteria for course completion
Course completion
  • Completion status
  • Is complete? (any method)
  • Is not complete?
  • Is complete? (not via RPL)
  • Is complete? (via RPL)
  • RPL note
  • Is in progress?
  • Is not yet started?
  • The completion date
  • Date started
  • Date enrolled
  • Enrolment types
  • Time taken to complete (since start date)
  • Time taken to complete (since enrolment date)
  • Completion organisation ID
  • Completion organisation name
  • Completion position ID
  • Completion position name
  • Grade
  • Pass grade
  • Grade and required grade
  • Progress
  • Progress (%)
  • Due 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
Course
  • Course name
  • Course name (linked to course page)
  • Course name (expanding details)
  • Course name (linked to course page with icon)
  • Course visible
  • Audience visibility (not applicable)
  • Course icon
  • Course shortname
  • Course ID number
  • Course ID
  • Course date created
  • Course start date
  • Course end date
  • Course name and summary
  • Course summary
  • Type
  • Course type
  • Course language
  • Course mobile compatibility
Category
  • Course category
  • Course category (linked to category)
  • Course category ID number
  • Course category ID

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)
Tags
  • Tags
  • Tagged '[tag name]'

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 detail (legacy)

Performance management appraisal details, including the questions and responses provided by each 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)

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

Submission information for induvial 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
  • Assignment name (linked to activity)
  • 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 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 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

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

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

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

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

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 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

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

Certification user assignment

  • Exception 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

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

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

Competencies

The competencies report mimics the content available in the competency export, in a human readable form.

Available columns

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

Column typeAvailable columns

Competency

  • Last modified
  • Description
  • Name
  • ID number

Framework

  • Framework ID number

Parent competency

  • Parent ID number
  • Parent competency

Competency type

  • Type
  • Type ID number

Scale

  • Scale

Assignment availability

  • Assignment availability

Competency assignments

Show users who are assigned to competencies.

This report source has two available competency name filters: Competency name and Competency name (multi-choice). The multi-choice filter allows you to select multiple competencies at once in a report, and is the default for new reports using this report source.

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 ratings

Show manual ratings for users on their assigned competencies.

This report source has two available competency name filters: Competency name and Competency name (multi-choice). The multi-choice filter allows you to select multiple competencies at once in a report, and is the default for new reports using this report source.

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)

Competency

  • Type
  • Competency
  • Competency ID number

Framework

  • Framework
  • Framework ID number

Scale

  • Scale

Rating

  • Rating value
  • Rating role
  • Time rated
  • Rating numerical value

Rating 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

Rating 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)

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)

 


Competency status

Learners progress on their assigned competencies.

This report source has two available competency name filters: Competency name and Competency name (multi-choice). The multi-choice filter allows you to select multiple competencies at once in a report, and is the default for new reports using this report source.

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 type

Deprecated 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)

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 type

Available 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 type

Deprecated 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

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 type

Available 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

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 type

Available 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 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 type

Available 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 type

Deprecated 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 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 type

Available 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

  • Grade based on current course
  • Is current record
  • Grade at time of completion
  • Date completed

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 type

Deprecated 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 details grouped by organisation.

Available columns

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

Column type

Available 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

Details about course members. This report is used to show users in the completion editor, displaying users who:

  • Are enrolled in the course
  • Have completion records
  • Have the course assigned via a learning plan

Available columns

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

Column type

Available 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

  • Currently enrolled?
  • 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 type

Deprecated 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

Details about all the courses.

Available columns

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

Column type

Available 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

Details about deleted users including their purge type.

Available columns

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

Column type

Available 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 type

Deprecated 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)

 


Delivery log

Logs of details and status of how notifications were delivered.

Available columns

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

Column type

Available columns

Delivery log

  • Delivery channel
  • Has error
  • Status

Sent notifications

  • Notification
Recipient user
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's email
  • User's email (ignoring user display setting)
  • Timezone
  • User last login
  • User last login (relative)
  • User first access
  • User first access (relative)
  • User's preferred language
  • User first name
  • User first name - phonetic
  • User middle name
  • User last name
  • User last name - phonetic
  • User alternate name
  • Username
  • User's phone number
  • User's mobile phone number
  • User's institution
  • User's department
  • User's address
  • User's city
  • User ID number
  • User ID
  • User's country
  • User's authentication method
  • User status
  • User creation time
  • User last modified
  • HR Import
  • Tenant
  • Tenant member
Notification events
  • Event time
  • Event Name
  • Schedule
Subject user
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's email
  • User's email (ignoring user display setting)
  • Timezone
  • User last login
  • User last login (relative)
  • User first access
  • User first access (relative)
  • User's preferred language
  • User first name
  • User first name - phonetic
  • User middle name
  • User last name
  • User last name - phonetic
  • User alternate name
  • Username
  • User's phone number
  • User's mobile phone number
  • User's institution
  • User's department
  • User's address
  • User's city
  • User ID number
  • User ID
  • User's country
  • User's authentication method
  • User status
  • User creation time
  • User last modified
  • HR Import
  • Tenant
  • Tenant member

Deprecated columns

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

Column type

Deprecated columns

User

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

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 type

Available 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

Evidence custom fields

  • Any custom fields you have

Deprecated columns

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

Column type

Deprecated 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

Show details and configuration of evidence types.

Available columns

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

Column type

Available columns

Evidence type

  • Actions
  • Creation date
  • Creator
  • Custom fields
  • Description
  • For use in
  • In use
  • Last modified date
  • Last modifier
  • Location
  • Status
  • Type ID number
  • Type name

Evidence custom fields

  • Any custom fields you have

 


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 type

Available 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 type

Deprecated 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

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 type

Available 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 type

Deprecated 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

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 type

Available 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 type

Deprecated 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

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 type

Available 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 type

Deprecated 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

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 type

Available columns

Company goal type

  • Goal type

Goal

  • Goal name
  • Goal name with link
  • Number of users assigned
  • Scale count columns

 


HR import log

Logging of HR import activity.

Available columns

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

Column type

Available columns

HR import log

  • Action
  • Date/time
  • Element
  • Info
  • Log type
  • Run ID
  • ID

 


Inappropriate content

Content that has been reported as inappropriate

Available columns

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

Column type

Available 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 type

Deprecated 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

List job assignments.

Available columns

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

Column type

Available 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 type

Deprecated 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

List of known trusted SCORM packages.

Available columns

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

Column type

Available 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 type

Deprecated 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

Shows customisations to the language pack.

Available columns

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

Column type

Available columns

Component

  • Component
  • Component version

Customisation

  • Customised
  • Language
  • Local
  • Original
  • String ID

 


Learning plans

Learning plan information by user.

Available columns

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

Column type

Available 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 type

Deprecated 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

Site-wide user activity logging.

Available columns

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

Column type

Available 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 type

Deprecated 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

List of all local packages used in SCORM activities.

Available columns

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

Column type

Available 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 type

Deprecated 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

Alerts and notifications sent by the system.

Note that this report does not include notifications in the centralised notifications system.

Available columns

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

Column type

Available 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 type

Deprecated 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)



Notification events

Triggered events with associated notifications.

Available columns

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

Column type

Available columns

Notification events
  • Status
  • Event has error
  • Descendant has error
  • Action
  • Event time
  • Event name
  • Schedule
Subject user
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's email
  • User's email (ignoring user display setting)
  • Timezone
  • User last login
  • User last login (relative)
  • User first access
  • User first access (relative)
  • User's preferred language
  • User first name
  • User first name - phonetic
  • User middle name
  • User last name
  • User last name - phonetic
  • User alternate name
  • Username
  • User's phone number
  • User's mobile phone number
  • User's institution
  • User's department
  • User's address
  • User's city
  • User ID number
  • User ID
  • User's country
  • User's authentication method
  • User status
  • User creation time
  • User last modified
  • HR Import
  • Tenant
  • Tenant member

Deprecated columns

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

Column type

Deprecated columns

User

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



OAuth 2 linked logins

View OAuth 2 linked logins.

Available columns

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

Column type

Available columns

Linked login

  • Actions
  • Confirmed
  • Created
  • External issuer email
  • External issuer username
  • Modified

OAuth 2 issuer

  • Enabled
  • OAuth 2 service
  • Show on login page

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 type

Deprecated 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)

 


Organisations

Organisation structure details.

Available columns

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

Column type

Available 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

Participant progress in performance activities.

Available columns

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

Column type

Available 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 type

Deprecated 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

Section progress in performance activities.

Available columns

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

Column type

Available 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 type

Deprecated 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

Questions from performance activities.

Available columns

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

Column type

Available 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

Subject progress in performance activities.

Available columns

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

Column type

Available 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 type

Deprecated 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

User-generated content summary.

Available columns

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

Column type

Available 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 type

Deprecated 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

Position structure details.

Available columns

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

Column type

Available 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 information and program details.

Available columns

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

Column type

Available 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 type

Deprecated 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 information and program details.

Available columns

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

Column type

Available 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 type

Deprecated 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

All program assignment details.

Available columns

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

Column type

Available 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
  • Exception status

Program user assignment

  • Exception 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 type

Deprecated 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 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 type

Available 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 type

Deprecated 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

Details about the programs and course category.

Available columns

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

Column type

Available 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

Certification assignment and course completion information.

Available columns

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

Column type

Available 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 type

Deprecated 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

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 type

Available 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 type

Deprecated 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

Objective assignment and completion information.

Available columns

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

Column type

Available 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 type

Deprecated 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

Certification assignment and course completion information including previous certifications.

Available columns

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

Column type

Available 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 type

Deprecated 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

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 type

Available 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

  • Grade based on current course
  • 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 type

Deprecated 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

Program assignment and completion information.

Available columns

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

Column type

Available 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 type

Deprecated 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

Historic program assignment and completion information.

Available columns

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

Column type

Available 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 type

Deprecated 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

Lists all report sources available.

Available columns

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

Column type

Available 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

Content Engagement summary.

Available columns

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

Column type

Available 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 type

Deprecated 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 activity completion details and settings collected across all courses.

Available columns

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

Column type

Available 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 type

Deprecated 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

List all saved report searches in the system.

Available columns

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

Column type

Available 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 type

Deprecated 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

Information about the scheduled reports in the system.

Available columns

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

Column type

Available 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 type

Deprecated 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

Details of pending self-registration requests.

Available columns

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

Column type

Available 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 type

Deprecated 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

Upcoming events using assets.

Available columns

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

Column type

Available 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 type

Deprecated columns

Seminar

  • Event ID

 


Seminar assets

List of seminar assets.

Available columns

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

Column type

Available columns

Assets

  • Actions
  • Allow booking conflicts
  • Description
  • ID
  • Name
  • Name (linked to asset details page)
  • Sitewide
  • Visible

 


Seminar events

Lists all seminar events.

Available columns

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

Column type

Available 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 type

Deprecated columns

Seminar

  • Event ID

 


Seminar facilitators

List of seminar facilitators.

Available columns

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

Column type

Available columns

Facilitator

  • Actions
  • Allow booking conflicts
  • Bio
  • ID
  • Name
  • Name (linked to facilitator details page)
  • Sitewide
  • User ID
  • Visible

 


Seminar facilitators assignments

Upcoming events using facilitators.

Available columns

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

Column type

Available 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 type

Deprecated columns

Seminar

  • Event ID

 


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 type

Available 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 type

Deprecated 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

Upcoming events using rooms.

Available columns

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

Column type

Available 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 type

Deprecated columns

Seminar

  • Event ID

 


Seminar rooms

List of seminar rooms.

Available columns

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

Column type

Available columns

Room

  • Actions
  • Allow booking conflicts
  • Building
  • Capacity
  • Description
  • ID
  • Link
  • Location
  • Name
  • Name (linked to room details page)
  • Sitewide
  • Visible

 


Seminar sessions

Details on all seminar sessions.

Available columns

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

Column type

Available 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 type

Deprecated columns

Seminar

  • Event ID

 


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 type

Available 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 type

Deprecated 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

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 type

Available 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
  • List of assets

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
  • List of facilitators

Room

  • Building
  • Location
  • List of 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

  • Seminar name
  • Seminar name (linked to event page)

Seminar tags

  • Tags
Session
  • Session attendance

Signup custom fields

  • All sign up custom fields
  • Requests for session organiser

Status

  • Actioned by
  • Archived
  • Date/time of sign-up
  • Event grade
  • Signup 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 type

Deprecated 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)

 


Sent notifications

Details about notifications that have been sent.

Available columns

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

Column type

Available columns

Sent notifications

  • Notification has error
  • Status
  • Action
  • Notification
Recipient user
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's email
  • User's email (ignoring user display setting)
  • Timezone
  • User last login
  • User last login (relative)
  • User first access
  • User first access (relative)
  • User's preferred language
  • User first name
  • User first name - phonetic
  • User middle name
  • User last name
  • User last name - phonetic
  • User alternate name
  • Username
  • User's phone number
  • User's mobile phone number
  • User's institution
  • User's department
  • User's address
  • User's city
  • User ID number
  • User ID
  • User's country
  • User's authentication method
  • User status
  • User creation time
  • User last modified
  • HR Import
  • Tenant
  • Tenant member
Notification events
  • Event time
  • Event Name
  • Schedule
Subject user
  • User's fullname
  • User's fullname (linked to profile with icon)
  • User's fullname (linked to profile)
  • User's email
  • User's email (ignoring user display setting)
  • Timezone
  • User last login
  • User last login (relative)
  • User first access
  • User first access (relative)
  • User's preferred language
  • User first name
  • User first name - phonetic
  • User middle name
  • User last name
  • User last name - phonetic
  • User alternate name
  • Username
  • User's phone number
  • User's mobile phone number
  • User's institution
  • User's department
  • User's address
  • User's city
  • User ID number
  • User ID
  • User's country
  • User's authentication method
  • User status
  • User creation time
  • User last modified
  • HR Import
  • Tenant
  • Tenant member

Deprecated columns

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

Column type

Deprecated columns

User

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



Server upgrade history

Provides information about upgrade history of this site.

Available columns

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

Column type

Available 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 type

Deprecated 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-wide user activity logging.

Available columns

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

Column type

Available 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 type

Deprecated 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

All site policies and how users have responded.

Available columns

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

Column type

Available 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 type

Deprecated 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

Show all Totara tenants.

Available columns

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

Column type

Available 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 type

Deprecated 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

Topics in the system.

Available columns

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

Column type

Available columns

Topic

  • Actions
  • Modified at
  • Topic

Topic usage

Show all the usage of the topic in the system.

Available columns

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

Column type

Available columns

Topic

  • Modified at
  • Topic

Usage

  • Component
  • Total usage

 


Totara goals status

Totara 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
  • Goal ID number
  • Goal start date
  • Goal target date
  • Goal closed date
  • Goal name
  • Goal status
  • Progress

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

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)

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)



User

User profile data and completion statistics.

Available columns

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

Column type

Available 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 type

Deprecated 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 summary.

Available columns

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

Column type

Available 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 type

Deprecated 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

All of the user export items.

Available columns

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

Column type

Available 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 type

Deprecated 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

All of the types of export items.

Available columns

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

Column type

Available 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

All of the user data export types.

Available columns

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

Column type

Available 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 profile data and completion statistics.

Available columns

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

Column type

Available 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 type

Deprecated 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

All of the user purge items.

Available columns

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

Column type

Available 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 type

Deprecated 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

All of the types of purge items.

Available columns

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

Column type

Available 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

All of the data purge types.

Available columns

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

Column type

Available 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

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

Available columns

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

Column type

Available 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 typedeprected 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 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

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)

© Copyright 2024 Totara Learning Solutions. All rights reserved.


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.