Report sources

06 Aug 2024
94 minutes to read

Report sources

Updated on 06 Aug 2024
94 minutes to read

Article summary

Did you find this summary helpful?

Thank you for your feedback

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

AI interaction logs

Generate reports of AI interaction activity.

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
AI	Created at Configuration Feature Plugin Response Request AI interaction

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

Created at
Configuration
Feature
Plugin
Response
Request
AI interaction

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)

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

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

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

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

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

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

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

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

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

Certification membership

Details of all certification memberships.

Available columns

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

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

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

Certifications

Details of the certifications setup.

Available columns

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

Column type	Available 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 type	Available 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 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)
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 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 ratings

Show manual ratings for users on their assigned competencies.

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

Available columns

The following columns are currently available to use with the Competency status 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 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 type	Available 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 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)

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

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

Can't find what you're looking for? Contact us at documentation@totara.com. Alternatively, book a call to have a chat about your Totara platform with a dedicated Customer Success Manager.

© Copyright 2024 Totara Learning Solutions. All rights reserved.