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:
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 | |
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 | |
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 | |
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
|
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 | |
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 | |
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 | |
Category | |
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 | |
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 | 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 | |
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 | |
Audience | |
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 | |
Category | |
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 | |
Statistics | Course completions as evidence User's achieved competency count User's courses completed count User's courses started count
|
Suspended user 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 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
Parent competency | Parent ID number Parent competency
|
Competency type | |
Scale | |
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.
This report source has two available competency name filters: Competency name and Competency name (multi-choice). The multi-choice filter allows you to select multiple competencies at once in a report, and is the default for new reports using this report source.
Available columns
The following columns are currently available to use with this report source.
Column 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 | |
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.
This report source has two available competency name filters: Competency name and Competency name (multi-choice). The multi-choice filter allows you to select multiple competencies at once in a report, and is the default for new reports using this report source.
Available columns
The following columns are currently available to use with the Competency status report source.
Column 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 assignment | |
Competency 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)
|
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 | 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 | |
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 | |
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 | |
Course membership
Details about course members. This report is used to show users in the completion editor, displaying users who:
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 | 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 | |
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 | |
Suspended user 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 | |
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 | |
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 | |
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 | 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 | |
Feedback | |
Feedback tags | |
Responses | |
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 | |
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 | |
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 status history | |
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 | 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 | |
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 | 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 | |
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 | |
Package | Current package Package content hash Package file Trusted package
|
SCORM | |
SCORM 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.
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 | |
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 | |
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 | |
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 | |
Participant section | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
Certification completion history | |
Certification completions | Certification due date Certification path Completion date Expiration date Progress Progress (%) Renewal status Status Window opens
|
Programs | |
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 | |
Plan template | Plan template end date Plan template name Plan template start date
|
Previous course 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 | |
Plan | |
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 | |
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 | |
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 | |
Program | |
Program completion | Date assigned Date completed Date started Progress Progress (%)
|
Program completion history | |
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 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 | 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 | |
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 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 | |
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 | |
Schedule | |
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 | |
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 | |
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 | |
Facilitators | |
Rooms | |
Seminar | |
Deprecated columns
The following columns have been deprecated and will be removed from a future version of Totara.
Column type | Deprecated columns |
Seminar | |
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 | |
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 | 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 | |
Deprecated columns
The following columns have been deprecated and will be removed from a future version of Totara.
Column type | Deprecated columns |
Seminar | |
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 | |
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 | |
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 | |
Facilitators | |
Rooms | |
Seminar | |
Deprecated columns
The following columns have been deprecated and will be removed from a future version of Totara.
Column type | Deprecated columns |
Seminar | |
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 | 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 | |
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 | |
Facilitators | |
Rooms | |
Seminar | |
Deprecated columns
The following columns have been deprecated and will be removed from a future version of Totara.
Column type | Deprecated columns |
Seminar | |
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 | |
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 | |
Category | |
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 | |
Room | |
Seminar | |
Deprecated columns
The following columns have been deprecated and will be removed from a future version of Totara.
Column type | Deprecated columns |
Seminar | |
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 | 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 | |
Event | |
Room | |
Seminar | |
Seminar 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 | |
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 | |
Deprecated columns
The following columns have been deprecated and will be removed from a future version of Totara.
Column type | Deprecated columns |
Seminar | |
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 | |
Category | |
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 | |
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 | |
Facilitator | |
Room | |
Seminar | |
Seminar tags | |
Session | |
Signup custom fields | |
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 | |
Deprecated columns
The following columns have been deprecated and will be removed from a future version of Totara.
Column type | Deprecated columns |
Seminar | |
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 | 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 | |
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 | |
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 | |
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)
|
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 | |
Statistics | Course completions as evidence User's achieved competency count User's courses completed count User's courses started count
|
Suspended user 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 purges 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 Owners 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)
|
Join the Totara Community for more resources to help you get the most out of Totara.
© Copyright 2026 Totara Learning Solutions. All rights reserved.