--- title: "Report sources" slug: "report-sources" tags: ["Totara Platform"] updated: 2026-08-13T16:01:37Z published: 2026-08-13T16:01:37Z canonical: "totara.help/report-sources" --- > ## Documentation Index > Fetch the complete documentation index at: https://totara.help/llms.txt > Use this file to discover all available pages before exploring further. # Report sources 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](/totara-20/docs/view-report-default-columns) page. ## Embedded report Although there is no quick way to view all of the default columns included in an embedded report you can go into the report and edit it to customise the included columns. ## Notes For some report sources you may want to use either the **User last login** column or the **User last login (Relative)** column, which are similar, but could be useful for different reports. **User last login** displays the absolute date, e.g. 8 Sep 2022. **User last login (Relative)** shows a natural language string, depending on how long ago the point of time is. Here are some examples of possible strings: - Within the last five minutes - Within the last hour - Yesterday at 11:14 AM - 23 days ago - A month ago - 2 years ago ## All available report sources Use the list below to expand a report source and see details of its available and deprecated columns. ### Activity completion Activity completion status records including user details, activity details and completion status. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Activity completion** | - Activity completion date - Activity grade - Activity complete | | **Activity** | - Activity name - Activity type - Activity completion is enabled - Is criteria for course completion | | **Course completion** | - Completion status - Is complete? (any method) - Is not complete? - Is complete? (not via RPL) - Is complete? (via RPL) - RPL note - Is in progress? - Is not yet started? - The completion date - Date started - Date enrolled - Enrolment types - Time taken to complete (since start date) - Time taken to complete (since enrolment date) - Completion organisation ID - Completion organisation name - Completion position ID - Completion position name - Grade - Pass grade - Grade and required grade - Progress - Progress (%) - Due date | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Course** | - Course name - Course name (linked to course page) - Course name (expanding details) - Course name (linked to course page with icon) - Course visible - Audience visibility (not applicable) - Course icon - Course shortname - Course ID number - Course ID - Course date created - Course start date - Course end date - Course name and summary - Course summary - Type - Course type - Course language - Course mobile compatibility | | **Category** | - Course category - Course category (linked to category) - Course category ID number - Course category ID | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager email(s) - User's manager email(s) (ignoring user display setting) - User's manager ID number(s) - User's manager ID(s) - User's manager name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s)competency - User's position ID(s) - User's position name(s) - User's position type(s) | | **Tags** | - Tags - Tagged '[tag name]' | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | --- ### AI interaction logs Generate reports of AI interaction activity. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **AI** | - Created at - Configuration - Feature - Plugin - Response - Request - AI interaction | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | --- ### Appraisal detail (legacy) Performance management appraisal details, including the questions and responses provided by each appraisal user. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager email(s) - User's manager email(s) (ignoring user display setting) - User's manager ID number(s) - User's manager ID(s) - User's manager name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Appraisal** | - Active stage incomplete - Appraisal name - Appraisal status - Appraisal time finished - Appraisal time started | | **Appraisal answers** | - All roles' answers - All roles' rating answers - All roles' score - Appraiser's answers - Appraiser's rating answers - Appraiser's score - Learner's answers - Learner's rating answers - Learner's score - Manager's answers - Manager's manager answers - Manager's manager rating answers - Manager's manager score - Manager's rating answers - Manager's score | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **User's appraisal** | - Previous stage time completed - User's appraisal status - User's appraisal time completed - User's current stage - User's current stage due | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | ### --- ### Appraisal status (legacy) Performance management appraisal status details including stage information and completion status. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager email(s) - User's manager email(s) (ignoring user display setting) - User's manager ID number(s) - User's manager ID(s) - User's manager name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Appraisal** | - Active stage incomplete - Appraisal name - Appraisal status - Appraisal time finished - Appraisal time started | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **User's appraisal** | - Previous stage time completed - User's appraisal status - User's appraisal time completed - User's current stage - User's current stage due | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | --- ### Assignment submissions Submission information for induvial users for the Assignment activity. #### Available columns The following columns are currently available to use with the **Assignment submissions** report source. | **Column type** | **Available columns** | | --- | --- | | **Assignment** | - Assignment intro - Assignment name - Assignment name (linked to activity) - Submission status | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Grade** | - Feedback comment - Grade scale values - last modified (grade) - last modified (submission) - Max grade - Min grade - Submission grade | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status, user audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Assignment submissions summary Assignment activity submission information by assignment. #### Available columns The following columns are currently available to use with the **Assignment submissions summary** report source. | **Column type** | **Available columns** | | --- | --- | | **Assignment** | - Assignment intro - Assignment name - Average grade - Max grade - Max last marked - Max last modified - Maximum achievable grade - Min grade - Min last marked - Min last modified - Sum grade - User count | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | --- ### Audience members Audience information including information on users who are members of the audience. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position - Type(s) | | **Audience** | - Audience name - Audience name (with link) - End date - ID - Start date - Status - Type | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Audience: Enrolled learning Courses and programs that audiences are enrolled in including completion rules. #### Available columns The following columns are currently available to use with the **Audience: Enrolled learning** report source. | **Column type** | **Available columns** | | --- | --- | | **Associations** | - Actions - Actual due date - Assignment due date - name - name (with icon and link) - Type | | **Audience** | - Audience name - ID | --- ### Audiences Details from all the audiences in the system. #### Available columns The following columns are currently available to use with the **Audiences** report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Audience** | - Actions - Audience name - Audience name (with link) - End date - ID - No. of members - Start date - Status - Type | | **Category** | - Course category - Course category (linked to category) - Course category ID | | **Tags** | - Tags | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Audiences orphaned users Details on all users not in an audience. #### Available columns The following columns are currently available to use with the **Audience orphaned users** report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Deleted user purge type** | - Deleted purge type - ID | | **Statistics** | - Course completions as evidence - User's achieved skill count - User's courses completed count - User's courses started count | | **Suspended user purge type** | - ID - Suspended purge type | | **User** | - Extensions - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User fullname (with links to learning components) - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's My Learning icons - User's phone number - User's picture - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Badges issued View users who have been issued a badge. #### Available columns The following columns are currently available to use with the **Badges issued** report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Badge** | - Badge description - Badge image - Badge issuer contact - Badge issuer name - Badge name - Badge status - Badge type - Badge ID | | **Badge issue** | - Badge expiry date - Badge issue date - Badge issuer notified | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Tags** | - Tags | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Certification completion Show users details and progress for users who are assigned to a certification. #### Available columns The following columns are currently available to use with the **Certification completion** report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Certification** | - Active period - Audience visibility (not applicable) - Available from - Available until - Certification ID - Certification ID number - Certification name - Certification name (expanding details) - Certification name and linked Icon - Certification short name - Certification summary - Enrolled certification audience IDs - Program visible - Recertification method - Window period | | **Certification completion** | - Completion organisation - Completion organisation ID - Completion organisation ID - Completion organisation path - Completion position - Completion position ID - Completion position ID - Completion position path - Date assigned - Date completed - Date due - Date started - Has never certified - Is certified - Is in progress? - Is not certified - Is not started? - Is user assigned? - Progress - Progress (%) - Red-amber-green status - Status | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Certification exceptions Certification exceptions information and certification details. #### Available columns The following columns are currently available to use with the **Certification exemptions** report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Certification** | - Active period - Audience visibility (not applicable) - Available from - Available until - Certification ID - Certification ID number - Certification name - Certification name (expanding details) - Certification name and linked icon - Certification short name - Certification summary - Program visible - Recertification method - Window period | | **Exception information** | - Time logged - Type of exception | | **Program** | - Enrolled program audience IDs | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Certification membership Details of all certification memberships. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Certification** | - Active period - Audience visibility (not applicable) - Available from - Available until - Certification ID - Certification ID number - Certification name - Certification name (expanding details) - Certification name and linked icon - Certification short name - Certification summary - Program visible - Recertification method - Window period | | **Certification membership** | - Edit completion records - Is currently assigned - Is currently certified - Status | | **Certification user assignment** | - Exception status | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's dity - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Certification overview Show user and course details and progress for users who are assigned to a certification. #### Available columns The following columns are currently available to use with the **Certification overview** report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Certification** | - Active period - Audience visibility (not applicable) - Available from - Available until - Certification ID - Certification ID number - Certification name - Certification name (expanding details) - Certification name and linked icon - Certification short name - Certification summary - Program visible - Recertification method - Window period | | **Certification completion** | - Certification path - Completion organisation full name - Completion organisation short name - Completion organisation type - Completion position full name - Completion position ID - Completion position type - Completion date - Date assigned - Date started - Due date - Due date (extra info) - Expiration date - Progress - Progress (%) - Renewal status - Status - Window opens | | **Course** | - Course category - Course category (linked to category) - Course category ID - Course short name - Course status - Date completed - Date enrolled - Date started - Final grade - Grade pass | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Certifications Details of the certifications setup. #### Available columns The following columns are currently available to use with the **Certifications** report source. | **Column type** | **Available columns** | | --- | --- | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Certification** | - Active period - Audience visibility (not applicable) - Available from - Available until - Certification ID - Certification ID number - Certification name - Certification name (expanding details) - Certification name and linked icon - Certification short name - Certification summary - Enrolled certification audience IDs - Program visible - Recertification method - Window period | --- ### Completion import: Certification status Log details from the import of certification records through a CSV file. #### Available columns The following columns are currently available to use with the **Completion import: Certification status** report source. | **Column type** | **Available columns** | | --- | --- | | **Import** | - Certification ID number - Certification shortname - Completion date - Due date - Errors - ID - Imported as evidence? - Imported by user ID - Line number - Record processed - Time uploaded - Username to import | | **Imported by** | - Imported by - Imported by username | --- ### Completion import: Course status Log details from the import of course completion records through a CSV file. #### Available columns The following columns are currently available to use with the **Completion import: Course status** report source. | **Column type** | **Available columns** | | --- | --- | | **Import** | - Completion date - Course ID number - Course shortname - Errors - Grade - ID - Imported as evidence? - Imported by user ID - Line number - Record processed - Time uploaded - Username to import | | **Imported by** | - Imported by - Imported by username | --- ### Course completion Course completion status records including user details, course details and completion status. #### Available columns The following columns are currently available to use with the **Course completion** report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser's name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Course completion** | - Completion organisation ID - Completion organisation ID - Completion organisation name - Completion organisation path - Completion position ID - Completion position ID - Completion position name - Completion position path - Completion status - Date enrolled - Date started - Enrolment types - Grade - Grade and required grade - Is complete? (any method) - Is complete? (not via RPL) - Is complete? (via RPL) - Is in progress? - Is not complete? - Is not yet started? - Pass grade - Progress - Progress (%) - RPL note - The completion date - Time to complete (since enrol date) - Time to complete (since start date) | | **Tags** | - Tags | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser's name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Course completion including history Course completion status records including user details, course details for all courses. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Course completion** | - Grade based on current course - Is current record - Grade at time of completion - Date completed | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Course completion by organisation Course completion details grouped by organisation. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Course completion** | - Completion organisation ID - Completion organisation name - Completion organisation path (IDs) - Completion organisation path (text) - Earliest completion date - Latest completion date - Number completed - Number completed via RPL - Number in progress - Number not started - Number of records - Percentage completed - Percentage completed via RPL | | **User** | - All participants | --- ### Course membership Details about course members. This report is used to show users in the completion editor, displaying users who: - Are enrolled in the course - Have completion records - Have the course assigned via a learning plan #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Course membership** | - Currently enrolled? - Edit course completion | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Courses Details about all the courses. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Content - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Tags** | - Tags | --- ### Deleted user accounts Details about deleted users including their purge type. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Deleted user purge type** | - Deleted purge type - ID | | **Suspended user purge type** | - ID - Suspended purge type | | **User** | - Actions - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Delivery log Logs of details and status of how notifications were delivered. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Delivery log** | - Delivery channel - Has error - Status | | **Sent notifications** | - Notification | | **Recipient user** | - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's email - User's email (ignoring user display setting) - Timezone - User last login - User last login (relative) - User first access - User first access (relative) - User's preferred language - User first name - User first name - phonetic - User middle name - User last name - User last name - phonetic - User alternate name - Username - User's phone number - User's mobile phone number - User's institution - User's department - User's address - User's city - User ID number - User ID - User's country - User's authentication method - User status - User creation time - User last modified - HR Import - Tenant - Tenant member | | **Notification events** | - Event time - Event Name - Schedule | | **Subject user** | - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's email - User's email (ignoring user display setting) - Timezone - User last login - User last login (relative) - User first access - User first access (relative) - User's preferred language - User first name - User first name - phonetic - User middle name - User last name - User last name - phonetic - User alternate name - Username - User's phone number - User's mobile phone number - User's institution - User's department - User's address - User's city - User ID number - User ID - User's country - User's authentication method - User status - User creation time - User last modified - HR Import - Tenant - Tenant member | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's position name(s) - User's position ID number(s) - User's organisation name(s) - User's organisation ID number(s) - User's manager name(s) - User's appraiser name(s) - User's temporary manager name(s) | --- ### Evidence Shows evidence items, including details of their creator, owner, use and location. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Evidence item** | - Actions - Creation date - In use - Last modified date - Location - Name - Source | | **Evidence item creator** | - Creator - Creator's organisation - Creator's organisation ID number - Creator's organisation type - Creator's position - Creator's position ID number - Creator's position type | | **Evidence item last modified by** | - Last modifier - Last modifier's organisation - Last modifier's organisation ID number - Last modifier's organisation type - Last modifier's position - Last modifier's position ID number - Last modifier's position type | | **Evidence item subject user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Evidence type** | - Type - Type ID number - Type creation date - Type description - Type last modified date | | **Evidence custom fields** | - Any custom fields you have | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Evidence item subject user** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Evidence types Show details and configuration of evidence types. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Evidence type** | - Actions - Creation date - Creator - Custom fields - Description - For use in - In use - Last modified date - Last modifier - Location - Status - Type ID number - Type name | | **Evidence custom fields** | - Any custom fields you have | --- ### Feedback responses **Available from Totara v20.1** Show details on Feedback activity responses so administrators can analyse results across multiple courses in a single report #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Feedback** | - Feedback Activity - Label - Question - Answer | | **Course** | - 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 - Exclude from catalogue | | **Category** | - Course Category - Course Category (linked to category) - Course Category ID Number - Course Category ID | | **User** | - 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 - Tenant - User's Country - User's Authentication Method - User Status - User Creation Time - User Last Modified | | **HR Import** | - Tenant - Tenant member - User's Fullname (linked to profile) - User's Fullname (linked to profile with icon) | ### 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) | --- ### Feedback summary Learner responses to the feedback activity used to survey learners in a course. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Course tags** | - Tags | | **Feedback** | - Feedback activity | | **Feedback tags** | - Tags | | **Responses** | - Time completed | | **Trainer** | - Trainer full name - Trainer ID - Trainer organisation - Trainer organisation ID - Trainer position - Trainer position ID | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | ### --- ### Goal custom fields Company goals and users' current progress on their assigned goals. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Goals** | - All company goal custom fields - All personal goal custom fields - Goal description - Goal name - Goal type - Personal or company - Status - Target date | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Goal status Company goals and users' current progress on their assigned goals. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Goal** | - Goal framework name - Goal name - User's goal status - User's goal status history link | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Goal status history Company goals and user progress over time on their assigned goals. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Goal** | - Goal name - Goal type | | **Goal status history** | - User's goal status - User's status modifed by user - User's status time modified | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Goal summary Company goals with summary details including number of users assigned and number of users per status. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Company goal type** | - Goal type | | **Goal** | - Goal name - Goal name with link - Number of users assigned - Scale count columns | --- ### HR import log Logging of HR import activity. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **HR import log** | - Action - Date/time - Element - Info - Log type - Run ID - ID | --- ### Inappropriate content Content that has been reported as inappropriate #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Content creator** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Inappropriate content** | - Content - Date created - Date reported - Date reviewed - Link - Status | | **Reporter** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Reviewer** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Content creator** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | | **Reporter** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | | **Reviewer** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Job assignments List job assignments. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Appraiser** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Job assignment** | - End date - Full name - ID number - Short name - Start date | | **Manager** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Organisation** | - Framework - Framework ID number - ID number - Name - Short name - Type - Type ID number - Visible | | **Position** | - Framework - Framework ID number - ID number - Name - Short name - Type - Type ID number - Visible | | **Temporary manager** | - HR import - Temporary manager expiry date - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Appraiser** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | | **Manager** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | | **Temporary manager's** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Known trusted SCORM packages List of known trusted SCORM packages. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Package** | - Actions - File names - Package content hash - Usage count | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Language customisations Shows customisations to the language pack. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Component** | - Component - Component version | | **Customisation** | - Customised - Language - Local - Original - String ID | --- ### Learning plans Learning plan information by user. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Plan** | - Completion date - Description - Plan end date - Plan name - Plan name (linked to plan page) - Plan start date - Plan status | | **Plan template** | - Plan template end date - Plan template name - Plan template start date | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | --- ### Legacy site logs Site-wide user activity logging. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Log** | - Action - Action (linked to URL) - CMID - IP address - Info - Module - Time - URL | | **Tags** | - Tags | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | --- ### Local SCORM packages List of all local packages used in SCORM activities. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Course tags** | - Tags | | **Package** | - Current package - Package content hash - Package file - Trusted package | | **SCORM** | - SCORM title | | **SCORM tags** | - Tags | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Messages Alerts and notifications sent by the system. Note that this report does not include notifications in the [centralised notifications system](/totara-20/docs/what-are-centralised-notifications). #### 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** | - Skills - Created - Description - Framework - Framework ID number - ID number - Member count - Member count (including child organisations) - Modified - Name - Parent ID number - Parent name - Short name - Type - Type ID number - Visible | --- ### Performance participant instance Participant progress in performance activities. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Participant instance** | - Availability - Date updated - Instance creation date - Overdue - Participant source - Participant's email - Participant's email (ignoring user display setting) - Participant's name - Progress - Relationship ID - Relationship name - Relationship sort order | | **Participant user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Performance activity** | - Activity type - Performance activity name | | **Subject instance** | - Activity job ID number - Activity job title - Availability - Date completed - Date updated - Due date - Instance creation date - Instance number - Overdue - Progress | | **Subject user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Participant user** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | | **Subject user** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | --- ### Performance participant section Section progress in performance activities. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Participant instance** | - Availability - Date updated - Instance creation date - Overdue - Participant source - Participant's email - Participant's email (ignoring user display setting) - Participant's name - Progress - Relationship ID - Relationship name - Relationship sort order | | **Participant section** | - Availability - Progress | | **Participant user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Performance activity** | - Activity type - Performance activity name | | **Section** | - Date updated - Instance creation date - Responding relationships - Section sort order - Section title | | **Subject instance** | - Activity job ID number - Activity job title - Availability - Date completed - Date updated - Due date - Instance creation date - Instance number - Overdue - Progress | | **Subject user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Participant user** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | | **Subject user** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Performance questions Questions from performance activities. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Element** | - Element type - Question text - Reporting ID - Required - Sort order | | **Performance activity** | - Activity type - Performance activity name | | **Section** | - Date updated - Instance creation date - Responding relationships - Section sort order - Section title | --- ### Performance subject instance Subject progress in performance activities. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Performance activity** | - Activity type - Performance activity name | | **Subject instance** | - Activity job ID number - Activity job title - Availability - Date completed - Date updated - Due date - Instance creation date - Instance number - Overdue - Participant count - Progress | | **Subject user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Subject user** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Playlist engagement User-generated content summary. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Playlists engagement** | - Comments - Created date - Number of resources - Playlist title - Rating - Shares - Topics - Updated date - Views - Visibility | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Positions Position structure details. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Position** | - Skills - Created - Description - Framework - Framework ID number - ID number - Member count - Member count (including child positions) - Modified - Name - Parent ID number - Parent name - Short name - Type - Type ID number - Visible | --- ### Program completion Program completion information and program details. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Program** | - Audience visibility (not applicable) - Available from - Available until - Enrolled program audience IDs - Program ID - Program ID number - Program name - Program name (expanding details) - Program name and linked icon - Program short name - Program summary - Program visible | | **Program completion** | - Completion organisation - Completion organisation ID - Completion organisation ID - Completion organisation path - Completion position - Completion position ID - Completion position ID - Completion position path - Date assigned - Date completed - Date due - Date started - Is complete? - Is in progress? - Is not complete? - Is not started? - Is user assigned? - Progress - Progress (%) - Status | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Program exceptions Program exceptions information and program details. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Exception Information** | - Time logged - Type of exception | | **Program** | - Audience visibility (not applicable) - Available from - Available until - Enrolled program audience IDs - Program ID - Program ID number - Program name - Program name (expanding details) - Program name and linked icon - Program short name - Program summary - Program visible | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Program membership All program assignment details. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Program** | - Audience visibility (not applicable) - Available from - Available until - Program ID - Program ID number - Program name - Program name (expanding details) - Program name and linked icon - Program short name - Program summary - Program visible | | **Program membership** | - Edit completion records - Is currently assigned - Status - Exception status | | **Program user assignment** | - Exception status | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Program overview Program details and status including information about the courses that are a part of the program content. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Course category - Course category (linked to category) - Course category ID - Course short name - Course status - Date completed - Date enrolled - Date started - Final grade - Grade pass | | **Program** | - Audience visibility (not applicable) - Available from - Available until - Program ID - Program ID number - Program name - Program name (expanding details) - Program name and linked icon - Program short name - Program summary - Program visible | | **Program completion** | - Completion organisation full name - Completion organisation short name - Completion organisation type - Completion position full name - Completion position ID - Completion position type - Date completed - Date assigned - Date started - Due date - Due date (extra info) - Program status - Progress - Progress (%) | | **User** | - HR import - Tenan - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Programs Details about the programs and course category. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Program** | - Audience visibility (not applicable) - Available from - Available until - Enrolled program audience IDs - Program ID - Program ID number - Program name - Program name (expanding details) - Program name and linked icon - Program short name - Program summary - Program visible | --- ### Record of learning: Certifications Certification assignment and course completion information. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Certification completion history** | - Previous completion count - Previous completions | | **Certification completions** | - Certification due date - Certification path - Completion date - Expiration date - Progress - Progress (%) - Renewal status - Status - Window opens | | **Programs** | - Certification ID - Certification name and linked icon - Certification name - Program ID number - Program short name | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Record of learning: Courses Course assignment and completion information, by default used to build the Record of Learning embedded report. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Course completion** | - Completion status - Course completion date - Enrolled - Grade - Grade and required grade - Pass grade - Progress (%) | | **Plan** | - Course due date - Course priority - Course progress - Course status - Plan end date - Plan name - Plan name (linked to plan page) - Plan start date - Plan status - Progress (and approval status) | | **Plan template** | - Plan template end date - Plan template name - Plan template start date | | **Previous course completions** | - Previous completion count - Previous completions | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Record of learning: Objectives Objective assignment and completion information. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Objective** | - Achieved objective? - Date created - Date updated - Description - Full name - Full name (linked to detail page) - Objective approved - Objective due date - Objective priority - Objective status - Objective status (and approval status) - Short name | | **Plan** | - Plan end date - Plan name - Plan name (linked to plan page) - Plan start date - Plan status | | **Plan template** | - Plan template end date - Plan template name - Plan template start date | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Record of learning: Previous certifications Certification assignment and course completion information including previous certifications. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Certification completion** | - Certification ID - Completion date - Current? - Expiration date - Progress - Progress (%) - Renewal status - Status | | **Program** | - Certification name - Certification name - Program ID number - Program short name | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Record of learning: Previous course completions Course completion status records including user details, course details for all courses. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Course completion history** | - Grade based on current course - Date completed - Grade at time of completion | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Record of learning: Programs Program assignment and completion information. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Program** | - Enrolled program audience IDs - Program ID - Program ID number - Program name - Program name and linked icon - Program short name - Program due date - Program mandatory - Program recurring | | **Program completion** | - Date assigned - Date completed - Date started - Progress - Progress (%) | | **Program completion history** | - Count of previous completions - Previous completions | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Record of learning: Recurring programs Historic program assignment and completion information. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Program** | - Program ID - Program ID number - Program name - Program name and linked icon - Program short name | | **Program completion history** | - Completion date - Course name - Due date - Status | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Reports Lists all report sources available. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Report** | - Abstract - Actions - Export format override? - Export formats - Global report restrictions - Is embedded report? - Is hidden on My reports? - Name (linked to edit report) - Name (linked to edit report) and view link - Name (linked to view report) - Number of columns - Number of filters - Number of saved searches - Number of scheduled reports - Report ID - Report name - Source | --- ### Resources engagement Content Engagement summary. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Content engagement** | - Comments - Created date - Likes - Playlists - Resource - Shares - Topics - Views - Visibility - Workspaces | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### SCORM SCORM activity completion details and settings collected across all courses. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Course tags** | - Tags | | **SCO** | - SCO attempt number - SCO max score - SCO min score - SCO score - SCO start time - SCO status - SCO status modified - SCO title - SCO total time | | **SCORM** | - SCORM title | | **SCORM tags** | - Tags | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Saved report searches List all saved report searches in the system. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Report** | - Abstract - Actions - Export format override? - Export formats - Global report restrictions - Is embedded report? - Is hidden on My reports? - Name (linked to edit report) - Name (linked to edit report) and view link - Name (linked to view report) - Number of columns - Number of filters - Number of saved searches - Number of scheduled reports - Report ID - Report name - Source | | **Saved search** | - Modified - Number of scheduled reports - Search name - Shared | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Scheduled reports Information about the scheduled reports in the system. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Report** | - Abstract - Actions - Export format override? - Export formats - Global report restrictions - Is embedded report? - Is hidden on My reports? - Name (linked to edit report) - Name (linked to edit report) and view link - Name (linked to view report) - Number of columns - Number of filters - Number of saved searches - Number of scheduled reports - Report ID - Report name - Source | | **Saved search** | - Saved search name | | **Schedule** | - Export destination - Format - Last modified by - Last modified time - Next schedule - Recipients (audiences) - Recipients (external) - Recipients (system users) - Schedule - Scheduler actions | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Self-registration requests Details of pending self-registration requests. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Created user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Organisation** | - Organisation - Organisation framework | | **Position** | - Position - Position framework | | **Request** | - Actions - Additional request data - Email confirmed - Manager's free text - Organisation free text - Position free text - Status - Time modified - Time requested - Time resolved - User first name - User last name - User's city - User's country - User's email - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Created user** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Seminar asset assignments Upcoming events using assets. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Assets** | - Asset allow booking conflicts - Asset description - Asset ID - Asset name - Asset name (linked to asset details page) - Asset sitewide - Asset visible | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Date** | - Local session finish date/time - Local session start date/time - Session finish date - Session finish date/time - Session finish date/time (linked to activity) - Session finish time - Session ID - Session start date - Session start date/time - Session start date/time (linked to activity) - Session start time | | **Events** | - Booking status - Event ID - Event maximum bookings - Event status - Number of attendees - Number of attendees (linked to attendee page) | | **Facilitators** | - Facilitator allow booking conflicts - Facilitator bio - Facilitator ID - Facilitator name - Facilitator name (linked to facilitator details page) - Facilitator sitewide - Facilitator user ID - Facilitator visible | | **Rooms** | - Room allow booking conflicts - Room capacity - Room description - Room ID - Room link - Room name - Room name (linked to room details page) - Room sitewide - Room visible | | **Seminar** | - Approval type - Seminar ID - Seminar name - Seminar name (linked to event page) | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Seminar** | - Event ID | --- ### Seminar assets List of seminar assets. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Assets** | - Actions - Allow booking conflicts - Description - ID - Name - Name (linked to asset details page) - Sitewide - Visible | --- ### Seminar events Lists all seminar events. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Event** | - Booking status - Event attendance - Event attendance (linked to take attendance page) - Event created - Event details - Event finish date/time - Event ID - Event maximum bookings - Event start date/time - Event status - Last updated - Last updated by - Number of attendees - Number of attendees (inc. waiting approval, approved and wait-listed) - Number of attendees (linked to attendee page) - Number of cancelled bookings - Number of declined attendees - Number of fully attended - Number of no shows - Number of partially attended - Number of unable to attend - Number of wait-listed - Overbooking allowed - Places available - Viewer's status | | **Seminar** | - Approval type - Discount cost - Minimum bookings - Normal cost - Seminar ID - Seminar name - Seminar name (linked to event page) | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Seminar** | - Event ID | --- ### Seminar facilitators List of seminar facilitators. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Facilitator** | - Actions - Allow booking conflicts - Bio - ID - Name - Name (linked to facilitator details page) - Sitewide - User ID - Visible | --- ### Seminar facilitators assignments Upcoming events using facilitators. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Assets** | - Asset allow booking conflicts - Asset description - Asset ID - Asset name - Asset name (linked to asset details page) - Asset sitewide - Asset visible | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Date** | - Local session finish date/time - Local session start date/time - Session finish date - Session finish date/time - Session finish date/time (linked to activity) - Session finish time - Session ID - Session start date - Session start date/time - Session start date/time (linked to activity) - Session start time | | **Events** | - Booking status - Event ID - Event maximum bookings - Event status - Number of attendees - Number of attendees (linked to attendee page) | | **Facilitators** | - Facilitator allow booking conflicts - Facilitator bio - Facilitator ID - Facilitator name - Facilitator name (linked to facilitator details page) - Facilitator sitewide - Facilitator user ID - Facilitator visible | | **Rooms** | - Room allow booking conflicts - Room capacity - Room description - Room ID - Room link - Room name - Room name (linked to room details page) - Room sitewide - Room visible | | **Seminar** | - Approval type - Seminar ID - Seminar name - Seminar name (linked to event page) | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Seminar** | - Event ID | --- ### Seminar interest Details on users who have declared interest in attending a seminar. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Seminar** | - Date of declared interest - Seminar name - Seminar name (linked to event page) - Stated reason for interest | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Seminar room assignments Upcoming events using rooms. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Assets** | - Asset allow booking conflicts - Asset description - Asset ID - Asset name - Asset name (linked to asset details page) - Asset sitewide - Asset visible | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Date** | - Local session finish date/time - Local session start date/time - Session finish date - Session finish date/time - Session finish date/time (linked to activity) - Session finish time - Session ID - Session start date - Session start date/time - Session start date/time (linked to activity) - Session start time | | **Events** | - Booking status - Event ID - Event maximum bookings - Event status - Number of attendees - Number of attendees (linked to attendee page) | | **Facilitators** | - Facilitator allow booking conflicts - Facilitator bio - Facilitator ID - Facilitator name - Facilitator name (linked to facilitator details page) - Facilitator sitewide - Facilitator user ID - Facilitator visible | | **Rooms** | - Building - Location - Room allow booking conflicts - Room capacity - Room description - Room ID - Room link - Room name - Room name (linked to room details page) - Room sitewide - Room visible | | **Seminar** | - Approval type - Seminar ID - Seminar name - Seminar name (linked to event page) | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Seminar** | - Event ID | --- ### Seminar rooms List of seminar rooms. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Room** | - Actions - Allow booking conflicts - Building - Capacity - Description - ID - Link - Location - Name - Name (linked to room details page) - Sitewide - Visible | --- ### Seminar sessions Details on all seminar sessions. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Asset** | - Asset allow booking conflicts - Asset description - Asset ID - Asset name - Asset name (linked to asset details page) - Asset sitewide - Asset visible | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Type | | **Date** | - Local session finish date/time - Local session start date/time - Session finish date - Session finish date/time - Session finish date/time (linked to activity) - Session finish time - Session ID - Session start date - Session start date/time - Session start date/time (linked to activity) - Session start time | | **Event** | - Booking status - Event created - Event details - Event ID - Event maximum bookings - Event status - Last updated - Last updated by - Number of attendees - Number of attendees (inc. waiting approval, approved and wait-listed) - Number of attendees (linked to attendee page) - Number of cancelled bookings - Number of declined attendees - Number of fully attended - Number of no shows - Number of partially attended - Number of unable to attend - Number of wait-listed - Overbooking allowed - Places available - Sign-up date/time period - Sign-up end date/time - Sign-up start date/time - Viewer's status | | **Facilitator** | - Facilitator allow booking conflicts - Facilitator bio - Facilitator ID - Facilitator name - Facilitator name (linked to facilitator details page) - Facilitator sitewide - Facilitator user ID - Facilitator visible | | **Room** | - Building - Location - Room allow booking conflicts - Room capacity - Room description - Room ID - Room link - Room name - Room name (linked to room details page) - Room sitewide - Room visible | | **Seminar** | - Approval type - Discount cost - Minimum bookings - Normal cost - Seminar ID - Seminar name - Seminar name (linked to event page) | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Seminar** | - Event ID | --- ### Seminar sign-in sheet A record of everyone who has signed into a seminar session. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Course tags** | - Tags | | **Event** | - Booked by - Discount code - Discount cost - Event details - Event finish date/time - Event ID - Event maximum bookings - Event start date/time - Normal cost - Number of attendees - Number of attendees (linked to attendee page) | | **Room** | - Room allow booking conflicts - Room capacity - Room description - Room ID - Room link - Room name - Room name (linked to room details page) - Room sitewide - Room visible | | **Seminar** | - Seminar name - Seminar name (linked to session page) | | **Seminar tags** | - Tags | | **Session date** | - Local session finish date/time - Local session start date/time - Session finish date - Session finish date/time - Session finish date/time (linked to activity) - Session finish time - Session ID - Session start date - Session start date/time - Session start date/time (linked to activity) - Session start time | | **Signup note custom fields** | - Requests for session organiser | | **Status** | - Status | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **User session signups** | - Signature | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Seminar** | - Event ID | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Seminar sign-ups Provides detailed information of seminar events and who has signed up for them. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Approver** | - Approval date/time - Approver email - Approver name | | **Asset** | - Asset allow booking conflicts - Asset description - Asset ID - Asset name - Asset name (linked to asset details page) - Asset sitewide - Asset visible - List of assets | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Course tags** | - Tags | | **Date** | - Local session finish date/time - Local session start date/time - Session finish date - Session finish date/time - Session finish date/time (linked to activity) - Session finish time - Session ID - Session start date - Session start date/time - Session start date/time (linked to activity) - Session start time | | **Event** | - Booked by - Cancellation date/time - Cancelled status - Discount code - Discount cost - Event details - Event ID - Event maximum bookings - Job assignment - Link to approval requests - Normal cost - Number of attendees - Number of attendees (linked to attendee page) - Position on sign up - Sign-up date/time period - Sign-up end date/time - Sign-up start date/time | | **Facilitator** | - Facilitator allow booking conflicts - Facilitator bio - Facilitator ID - Facilitator name - Facilitator name (linked to facilitator details page) - Facilitator sitewide - Facilitator user ID - Facilitator visible - List of facilitators | | **Room** | - Building - Location - List of rooms - Room allow booking conflicts - Room capacity - Room description - Room ID - Room link - Room name - Room name (linked to room details page) - Room sitewide - Room visible | | **Seminar** | - Seminar name - Seminar name (linked to event page) | | **Seminar tags** | - Tags | | **Session** | - Session attendance | | **Signup custom fields** | - All sign up custom fields - Requests for session organiser | | **Status** | - Actioned by - Archived - Date/time of sign-up - Event grade - Signup status | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **User cancellation** | - All cancellation custom fields - Cancellation note | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Seminar** | - Event ID | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Sent notifications Details about notifications that have been sent. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Sent notifications** | - Notification has error - Status - Action - Notification | | **Recipient user** | - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's email - User's email (ignoring user display setting) - Timezone - User last login - User last login (relative) - User first access - User first access (relative) - User's preferred language - User first name - User first name - phonetic - User middle name - User last name - User last name - phonetic - User alternate name - Username - User's phone number - User's mobile phone number - User's institution - User's department - User's address - User's city - User ID number - User ID - User's country - User's authentication method - User status - User creation time - User last modified - HR Import - Tenant - Tenant member | | **Notification events** | - Event time - Event Name - Schedule | | **Subject user** | - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's email - User's email (ignoring user display setting) - Timezone - User last login - User last login (relative) - User first access - User first access (relative) - User's preferred language - User first name - User first name - phonetic - User middle name - User last name - User last name - phonetic - User alternate name - Username - User's phone number - User's mobile phone number - User's institution - User's department - User's address - User's city - User ID number - User ID - User's country - User's authentication method - User status - User creation time - User last modified - HR Import - Tenant - Tenant member | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's position name(s) - User's position ID number(s) - User's organisation name(s) - User's organisation ID number(s) - User's manager name(s) - User's appraiser name(s) - User's temporary manager name(s) | --- ### Server upgrade history Provides information about upgrade history of this site. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Upgrade log** | - Backtrace - Component - Details - Info - Target version - Time - Type - Version | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Site logs Site-wide user activity logging. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **All user's job assignments** | - Number of job assignments - User's appraiser name(s) - User's job end date(s) - User's job start date(s) - User's job title(s) - User's manager's email(s) - User's manager's email(s) (ignoring user display setting) - User's manager's ID number(s) - User's manager's ID(s) - User's manager's name(s) - User's manager's first name(s) - User's manager's last name(s) - User's organisation framework ID number(s) - User's organisation framework ID(s) - User's organisation framework(s) - User's organisation ID number(s) - User's organisation ID(s) - User's organisation name(s) - User's organisation type(s) - User's position framework ID number(s) - User's position framework ID(s) - User's position framework(s) - User's position ID number(s) - User's position ID(s) - User's position name(s) - User's position type(s) | | **Category** | - Course category - Course category (linked to category) - Course category ID - Course category ID number | | **Course** | - Audience visibility (not applicable) - Course date created - Course end date - Course ID - Course ID number - Course icon - Course name - Course name (expanding details) - Course name (linked to course page with icon) - Course name (linked to course page) - Course name and summary - Course shortname - Course start date - Course summary - Course type - Course visible - Course language - Course mobile compatibility - Enrolled course audience IDs - Type | | **Log** | - Action - All events - CRUD - Component - Context - Description - Event class name - Event name - Event name (linked to event source) - IP address - Object ID - Object table - Origin - Other info - Target - Target & action - Time - User full name (including login on behalf of user) | | **Real user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Related user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Tags** | - Tags | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Real user** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's Temporary manager's name(s) | | **Related user** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's Temporary manager's name(s) | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's Temporary manager's name(s) | --- ### Site policy records All site policies and how users have responded. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Primary policy** | - Consent statement (primary) - Created by - Date created - Date published - Policy title - Published by - Response (primary) - Status - Version number | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **User response** | - Consent statement - Consented (Yes/No) - Date consented - Language consented in - Response | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Skills The skills report mimics the content available in the skill export, in a human readable form. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Skill** | - Last modified - Description - Name - ID number | | **Framework** | - Framework ID number | | **Parent skill** | - Parent ID number - Parent skill | | **Skill type** | - Type - Type ID number | | **Scale** | - Scale | | **Assignment availability** | - Assignment availability | --- ### Skill assignments Show users who are assigned to skills. This report source has two available skill name filters: **Skill name** and **Skill name (multi-choice)**. The multi-choice filter allows you to select multiple skills 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 **Skill 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 | | **Skill** | - Skill framework ID number - Skill framework name - Skill ID number - Skill name - Skill name (linked to skill page) - Skill 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) | --- ### Skill ratings Show manual ratings for users on their assigned skills. This report source has two available skill name filters: **Skill name** and **Skill name (multi-choice)**. The multi-choice filter allows you to select multiple skills 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) | | **Skill** | - Type - Skill - Skill ID number | | **Framework** | - Framework - Framework ID number | | **Scale** | - Scale | | **Rating** | - Rating value - Rating role - Time rated - Rating numerical value | | **Rating user** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Rating user** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | | **User** | - Job assignments - User's appraiser name(s) - User's manager name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager name(s) | --- ### Skill status Learners progress on their assigned skills. This report source has two available skill name filters: **Skill name** and **Skill name (multi-choice)**. The multi-choice filter allows you to select multiple skills 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 **Skill 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) | | **Skill** | - Skill ID - Skill ID number - Skill name - Date achievement level achieved - Minimum proficiency level | | **Skill assignment** | - Archived date - Assignment activity log link - Assignment status - Assignment type - Date assigned - User group | | **Skill status** | - Achievement level - Achievement level related ID (scale value ID number) - Proficiency status - Scale value numerical value | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### Skill status history (legacy) Learners' progress on their assigned skills. #### Available columns The following columns are currently available to use with the **Skill 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) | | **Skill** | - Skill ID - Skill name | | **Skill status history** | - Skill 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) | --- ### 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** | - Deleted purge type - ID | | **Statistics** | - Course completions as evidence - User's achieved skill count - User's courses completed count - User's courses started count | | **Suspended user purge type** | - ID - Suspended purge type | | **User** | - Actions - Extensions - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User fullname (with links to learning components) - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's My learning icons - User's phone number - User's picture - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### User engagement User engagement summary. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **User engagement** | - Private resources created - A member of workspaces - Comments under other contributions - Creator - Playlists created - Public resources created - Resource/playlists linked to workspaces - Resources created - Restricted resources created - Workspaces owned | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### User data export items All of the user export items. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Created by** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Export** | - Context - Created - Finished - ID - Origin - Result - Started | | **Item** | - Finished - ID - Internal item name - Item - Item component - Result - Started | | **Type** | - Actions - Changed - Created - Description - Full name - Full name (with link) - ID - ID number - Include files - New items - Permitted use | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Created by** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### User data export type items All of the types of export items. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Items** | - Export data - ID - Internal item name - Item - Item component | | **Type** | - Actions - Changed - Created - Description - Full name - Full name (with link) - ID - ID number - Include files - New items - Permitted use | --- ### User data export types All of the user data export types. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Export type** | - Actions - Changed - Created - Description - Full name - Full name (with link) - ID - ID number - Include files - New items - Permitted use | --- ### User data exports User profile data and completion statistics. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Created by** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Export** | - Context - Created - Finished - ID - Origin - Result - Started | | **Type** | - Actions - Changed - Created - Description - Full name - Full name (with link) - ID - ID number - Include files - New items - Permitted use | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Created by** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### User data purge items All of the user purge items. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Created by** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | | **Item** | - Finished - ID - Internal item name - Item - Item component - Result - Started | | **Purge** | - Actions - Context - Created - Finished - ID - Origin - Result - Started | | **Type** | - Actions - Available use - Changed - Created - Description - Full name - Full name (with link) - ID - ID number - New items - User status restriction | | **User** | - HR import - Tenant - Tenant member - Timezone - User alternate name - User creation time - User first access - User first access (relative) - User first name - User first name - phonetic - User ID - User ID number - User last login - User last login (relative) - User last modified - User last name - User last name - phonetic - User middle name - User status - User audience IDs - User's address - User's authentication method - User's city - User's country - User's department - User's email - User's email (ignoring user display setting) - User's fullname - User's fullname (linked to profile with icon) - User's fullname (linked to profile) - User's institution - User's mobile phone number - User's phone number - User's preferred language - Username | #### Deprecated columns The following columns have been deprecated and will be removed from a future version of Totara. | **Column type** | **Deprecated columns** | | --- | --- | | **Created by** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | | **User** | - Job assignments - User's appraiser name(s) - User's manager's name(s) - User's organisation ID number(s) - User's organisation name(s) - User's position ID number(s) - User's position name(s) - User's temporary manager's name(s) | --- ### User data purge type items All of the types of purge items. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Items** | - ID - Internal item name - Item - Item component - Purge data | | **Type** | - Actions - Available use - Changed - Created - Description - Full name - Full name (with link) - ID - ID number - New items - User status restriction | --- ### User data purge types All of the data purge types. #### Available columns The following columns are currently available to use with this report source. | **Column type** | **Available columns** | | --- | --- | | **Purge type** | - Actions - Available use - Changed - Created - Description - Full name - Full name (with link) - ID - ID number - New items - User status restriction | --- ### User data purges A record of all of the 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](https://totara.community/) for more resources to help you get the most out of Totara. © Copyright 2026 Totara Learning Solutions. All rights reserved.