Following are all the details on the Embedded reports, which are available by default. Each record includes the report name, source, a description, and default columns. Below you will find details of all the potential columns for each report source, listed alphabetically, that you can use to customise any of the Embedded Reports or to create User generated reports.
It is helpful to note that:
- A category may contain different fields between two different sources.
- All enrolled users are included in reports containing course information, including those with ungraded roles such as 'Trainer'.
- Unenrolled users are not included in Course level reports (they are in activity level reports).
- If a user is running a report with columns which include custom profile fields, report builder will hide these columns from the output unless the user has the totara/core:viewhiddenusercustomfielddata capability or the field is set to visible to everyone.
Please note that some column options have been deprecated in this version and will be removed from the next major release of Totara Learn. It is advised that you use alternative column options as this will not only improve performance of your reports it will also prevent any problems with your reports when upgrading Totara Learn.
Any deprecated columns will be marked as deprecated when viewing the list of potential column whilst editing a report. There will also be a warning message on the columns tab when editing a report.
Embedded reports
| Name: | Alerts |
| Source: | Messages |
| Description: | Alerts and notifications sent by the system and users. |
| Default Columns: | Message Values: Message Type, Message Content, Sent. User: User's Fullname (linked to profile). |
| Name: | Appraisal Detail |
| Source: | Appraisal Detail |
| Description: | Appraisal details including the questions and responses provided by each appraisal user. |
| Default Columns: | User: User's Fullname (linked to profile). All User's Job Assignments: User's Manager Name(s). User's Appraisal: User's Appraisal Status. Appraisal Answers: All Roles' Answers. |
| Name: | Appraisal Status |
| Source: | Appraisal Status |
| Description: | Performance Management appraisal status details including stage information and completion status. |
| Default Columns: | User: User's Fullname (linked to profile). All User's Job Assignments: User's Position Name(s), User's Organisation Name(s), User's Manager Name(s). User's Appraisal: User's Current Stage, Previous Stage Time Completed, User's Appraisal Status. |
| Name: | Audience Admin Screen |
| Source: | Audiences |
| Description: | Information on every Audience in the system. |
| Default Columns: | Audience: Audience Name (with link), ID, No. of Members, Type, Start date, End date, Status, Actions. Category: Course category (linked to category). |
| Name: | Audiences Orphaned Users |
| Source: | Audiences Orphaned Users |
| Description: | View users who are not a part of an audience. |
| Default Columns: | User: User's Fullname (linked to profile with icon), User's ID Number, User's Email. |
| Name: | Audience members |
| Source: | Audience Members |
| Description: | Audience information including information on users who are members of the audience. |
| Default Columns: | User: User's Fullname (linked to profile). |
| Name: | Audience: Enrolled Learning |
| Source: | Audience: Enrolled Learning |
| Description: | Courses and programs that audiences are enrolled in including completion rules. |
| Default Columns: | Association: Name (with icon and link), Type, Assignment due date, Actual due date, Actions. |
| Name: | Browse list of users |
| Source: | User |
| Description: | View a list of all the users in the system. |
| Default Columns: | User: User's Fullname (linked to profile with icon), Username, User's Email (ignoring user display setting), User Status, User Last Login (Relative), Actions. |
| Name: | Competency Status History |
| Source: | Competency Status History |
| Description: | Learners progress on their assigned competencies. |
| Default Columns: | User: User's Fullname (linked to profile) Competency: Competency Name Competency status history: User's Goal Status, User's Status Time Modified, User's Status Modified By User. |
| Name: | Completion import: Certification status |
| Source: | Completion import: Certification status |
| Description: | Log details from the import of certification records through a CSV file. |
| Default Columns: | Import: ID, Line number, Errors, Imported as evidence?, Time uploaded, Username to import, Certification Shortname, Certification ID Number, Completion date, Due date. Imported By: Imported by. |
| Name: | Completion import: Course status |
| Source: | Completion import: Course status |
| Description: | Log details from the import of course completion records through a CSV file. |
| Default Columns: | Import: ID, Line number, Errors, Imported as evidence?, Time uploaded, Username to import, Course Shortname, Course ID Number, Completion date, Grade. Imported By: Imported by. |
| Name: | Course membership |
| Source: | Course Membership |
| Description: | A list of all course members. |
| Default Columns: | User: User's Fullname (linked to profile) Course membership: Edit course completion |
| Name: | Deleted user accounts |
| Source: | Deleted user accounts |
| Description: | A list of all user accounts that have been deleted. |
| Default Columns: | User: User ID, User's Fullname, Username, User ID Number, User's Email (ignoring user display settings), Actions. Suspended user purge type: Suspended purge type. Deleted user purge type: Deleted purge type. |
| Name: | Find courses |
| Source: | Courses |
| Description: | Details about the course and course category. |
| Default Columns: | Course: Course Name (linked to course page with icon), Course Start Date, Content. Category: Course category (linked to category). |
| Name: | Find programs |
| Source: | Programs |
| Description: | Details about the programs and course category. |
| Default Columns: | Program: Program Name and Linked Icon. Category: Course category (linked to category). |
| Name: | Goal Custom Fields |
| Source: | Goal Custom Fields |
| Description: | Company goals and users' current progress on their assigned goals. |
| Default Columns: | Goal: Goal Name, Personal or Company, Goal Type, All company goal custom fields, All personal goal custom fields, Target date, Status. |
| Name: | Goal Status |
| Source: | Goal Status |
| Description: | Company goals and users' current progress on their assigned goals. |
| Default Columns: | Goal: Goal Name, User's Goal Status. User: User's Fullname (linked to profile). |
| Name: | Goal Status History |
| Source: | Goal Status History |
| Description: | Company goals and user progress over time on their assigned goals. |
| Default Columns: | Goal: Goal Name. Goal status history: User's Goal Status, User's Status Time Modified, User's Status Modified By User. User: User's Fullname (linked to profile). |
| Name: | Goal Summary |
Source: | Goal Summary |
| Description: | Company goals with summary details including number of users assigned and number of users per status. |
| Default Columns: | Goal: Goal Name With Link, Number of Users Assigned, Scale Count Columns. |
| Name: | HR Import Log |
| Source: | HR Import Log |
| Description: | Logging of HR Import Log activity. |
| Default Columns: | HR Import Log: id, Run ID, Date/Time, Element, Log type, Action, Info. |
| Name: | Manage embedded reports |
| Source: | Reports |
| Description: | View a report on all embedded reports held in the system. |
| Default Columns: | Report: Name (linked to edit report) and view link, Source, Actions. |
| Name: | Manage scheduled reports |
| Source: | Scheduled reports |
| Description: | A list of all the scheduled reports. |
| Default Columns: | Report: Name (linked to view report). User: User's Fullname. Schedule: Format, Schedule, Next schedule, Last modified by, Last modified time, Scheduler actions. |
| Name: | Manage user reports |
| Source: | Reports |
| Description: | View a report on all user reports held in the system. |
| Default Columns: | Report: Name (linked to edit report) and view link, Source, Actions. |
| Name: | My Bookings |
| Source: | Seminar Sign-ups |
| Description: | Provides detailed information of Seminar, events and who has signed up for them |
| Default Columns: | Course: Course Name (linked to course page). Seminar: Seminar Name. Date: Session Start, Event Start Time, Event Finish Time. Status: Status. |
| Name: | My Current Courses |
| Source: | |
| Description: | Course assignment and completion information, by default used to build the Record of Learning embedded report. |
| Default Columns: | Course: Type, Course Name (linked to course page), Course Start Date. Course completion: Enrolled. Plan: Progress (and approval status) |
| Name: | My Past Bookings |
| Source: | Seminar Sign-ups |
| Description: | Provides detailed information of Seminar events that have already occurred. |
| Default Columns: | Course: Course Name (linked to course page). Seminar: Seminar Name. Date: Session Start Date/Time, Session Start Time, Session Finish Time. Status: Status. |
| Name: | Program assignment due dates |
| Source: | Program Completion |
| Description: | Program completion information and program details. |
| Default Columns: | User: User's Fullname. Program Completion: Date due, Is not complete? |
| Name: | Pending requests |
| Source: | Self-registration requests |
| Description: | All pending self-registration requests. |
| Default Columns: | Request: User First Name, User Last Name, Username, User's Email, Email confirmed, Time requested, Actions. |
| Name: | Record of Learning: Certifications |
| Source: | Record of Learning: Certifications |
| Description: | Certification assignment and course completion information, by default used to build the Record of Learning embedded report. |
| Default Columns: | Programs: Certification name and linked icon. Certification completion: Certification due date, Certification path, Status, Renewal status, Window opens, Expiration date, Completion date, Progress. Certification Completion History: Previous completions. |
| Name: | Record of Learning: Competencies |
| Source: | Record of Learning: Competencies |
| Description: | Competency assignment and completion information, by default used to build the Record of Learning embedded report. |
| Default columns: | Plan: Plan name (linked to plan page), Plan status. Competency: Competency name, Competency priority, Competency due date, Competency proficiency (and approval status). |
| Name: | Record of Learning: Courses |
| Source: | Record of Learning: Courses |
| Description: | Course assignment and completion information, by default used to build the Record of Learning embedded report. |
| Default Columns: | Course: Type, Course Name (linked to course page). Plan: Plan name (linked to plan page), Course due date. Previous Course Completions: Previous Completions. Plan: Progress status (and approval status). |
| Name: | Record of Learning: Course Completion History |
| Source: | Record of Learning: Previous Course Completions |
| Description: | Evidence information, by default used to build the Record of Learning embedded report. |
| Default Columns: | Course: Type, Course Name (linked to course page). Course Completion History: Date completed, Grade at time of completion. |
| Name: | Record of Learning: Evidence |
| Source: | Record of Learning: Evidence |
| Description: | Evidence information, by default used to build the Record of Learning embedded report. |
| Default Columns: | Evidence: Name (link), Evidence Type, In Use?, Actions. |
| Name: | Record of Learning: Objectives |
| Source: | Record of Learning: Objectives |
| Description: | Objective assignment and completion information, by default used to build the Record of Learning embedded report. |
| Default Columns: | Plan: Plan name (linked to plan page), Plan status. Objective: Full name (linked to detail page), Description, Objective priority, Objective due date, Objective status (and approval status). |
| Name: | Record of Learning: Previous Certifications |
| Source: | Record of Learning: Previous Certifications |
| Description: | Certification assignment and course completion information, by default used to build the Record of Learning embedded report that appears when the user clicks on 'Previous Completions' in the Record of Learning: Certifications report. |
| Default Columns: | Program: Certification name, Certification completion: Current?, Completion date, Expiration date. |
| Name: | Record of Learning: Programs |
| Source: | Record of Learning: Programs |
| Description: | Program assignment and completion information, by default used to build the Record of Learning embedded report. |
| Default Columns: | Program: Program Name and Linked Icon, Program mandatory, Program recurring, Program due date. Program Completion History: Previous completions. Program Completion: Progress, Date assigned, Date completed. |
| Name: | Record of Learning: Programs Completion History |
| Source: | Record of Learning: Recurring Programs |
| Description: | Historic program assignment and completion information, by default used to build the Record of Learning embedded report. |
| Default Columns: | Program: Program Name and Linked Icon. Program Completion History: Completion date, Due date. |
| Name: | Record of Learning: Recurring Programs |
| Source: | Record of Learning: Recurring Programs |
| Description: | Program assignment and completion information by default used to build the Record of Learning embedded report. |
| Default Columns: | Program Completion History: Course name, Status, Completion date. |
| Name: | Self-registration request details |
| Source: | Self-registration requests |
| Description: | Details of all self-registration requests. |
| Default Columns: | Request: User First Name, User Last Name, Username, User's Email, Email confirmed. |
| Name: | Seminar Declared interest |
| Source: | Seminar Interest |
| Description: | Details on users who have declared interest in attending a Seminar. |
| Default Columns: | Seminar: Date of declared interest, Stated reason for interest. User: User's Fullname (linked to profile), User's Email. |
| Name: | Seminars: Event attendees |
| Source: | Seminar Sign-ups |
| Description: | Provides detailed information of Seminar, events and who has signed up for them. |
| Columns: | User: User's Fullname (linked to profile). Status: Time of sign-up, Status. Event: Job assignment. Signup Custom Fields: All sign up custom fields. |
| Name: | Seminars: Event sign-in sheet |
| Source: | Seminar Sign-in Sheet |
| Description: | Details of users who have signed-in to a sessions. |
| Columns: | User Session Signups: Signature. User: User's Fullname (linked to profile). Signup note customfields: Request for session organiser. |
| Name: | Seminar: Event wait-list attendees |
| Source: | Seminar Sign-ups |
| Description: | All seminar attendees added to the waitlist. |
| Default Columns: | Users: User's Fullname (linked to profile). Status: Date/Time of sign-up, Status. Event: Normal cost, Discount code. Signup Custom Fields: All sign up custom fields. |
| Name: | Seminars: Manage assets |
| Source: | Seminar Assets |
| Description: | List of seminar assets. |
| Default Columns: | Asset: Asset Name, Asset Visible, Asset Allow Schedule Conflicts, Actions. |
| Name: | Seminars: Manage rooms |
| Source: | Seminar Rooms |
| Description: | List of seminar rooms. |
| Default Columns: | Room: Room Name, Room Visible, Room capacity, Actions, Building, Location. |
| Name: | Seminars: Upcoming events using asset |
| Source: | Seminar Asset Assignments |
| Description: | Details on all upcoming events using assets. |
| Default Columns: | Seminar: Seminar Name. Session: Number of Attendee (linked to attendee page), Event Maximum Bookings, Overall status, Booking Status. Date: Session Start Date/Time. |
| Name: | Seminars: Upcoming events using room |
| Source: | Seminar Room Assignments |
| Description: | Details on all upcoming events that are using rooms. |
| Default Columns: | Seminar: Seminar Name, Approval Type. Session: Event Maximum Bookings, Number of Attendees (linked to attendee page), Overall status, Booking Status. Date: Session Start Date/Time. |
| Source Name: | Seminars: View and manage events |
| Source: | Seminar Events |
| Description: | Used to view and manage events. |
| Default Columns: | Event: Event Maximum Bookings, Overbooking allowed, Number of Attendees (linked to attendee page), Booking Status. Seminar: Seminar Name (linked to event page). Course: Course Name (linked to course page). |
| Name: | Seminars: View and manage sessions |
| Source: | Seminar Sessions |
| Description: | Used to view and manage sessions. |
| Default Columns: | Event: Event Maximum Bookings, Overbooking allowed, Number of Attendees (linked to attendee page), Overall status, Booking Status. Seminar: Seminar Name (linked to event page). Date: Session Start Date/Time. Course: Course Name (linked to course page). |
| Name: | Site Policy Records |
| Source: | Site Policy Records |
| Description: | See all of the site policies and their responses from users. |
| Default Columns: | User: User's Fullname (linked to profile). Primary Policy: Policy Title, Version Number. User response: Consent Statement, Response, Consented (Yes/No), Language consented in, Date Consented. |
| Name: | Tasks |
| Source: | Messages |
| Description: | Notifications about tasks sent by the system. |
| Default Columns: | Message Values: Message Type, Message Content, Sent. User: User's Fullname (linked to profile). |
| Name: | Team Members |
| Source: | User |
| Description: | User profile data and completion statistics. |
| Default Columns: | User: User Fullname (with links to learning components), User Last Login, Extensions. Statistics: User's Achieved Competency Count, User's Courses Started Count, User's Courses Completed Count. |
| Name: | User data exports |
| Source: | User data exports |
| Description: | All the user data exports that have been generated. |
| Default Columns: | Export: Created, Finished, Result. User: User's Fullname (linked to profile). Type: Full name (with link) |
| Name: | User data export types |
| Source: | User data export types |
| Description: | All of the data export types in the system. |
| Default Columns: | Export type: Full name (with link), ID number, Includes files, Permitted use, Actions. |
| Name: | User data purges |
| Source: | |
| Description: | All of the data purged undertaken. |
| Default Columns: | Purge: Created, Origin, Finished, Result. User: User's Fullname (linked to profile). Type: Full name (with link), Actions. |
| Name: | User data purge types |
| Source: | User data purge types |
| Description: | All of the data purge types in the system. |
| Default Columns: | Purge type: Full name (with link), ID number, User status restriction, Available use, Actions. |
All sources (User generated reports)
Source: | Appraisal Detail | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Performance management appraisal details including the questions and responses provided by each appraisal user. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Appraisal Answers: Learner's Answers, Learner's Rating Answers, Learner's Score, Manager's Answers, Manager's Rating Answers, Manager's Score, Manager's Manager Answers, Manager's Manager Rating Answers, Manager's Manager Score, Appraiser's Answers, Appraiser's Rating Answers, Appraiser's Score, All roles' Answers, All roles' Rating Answers, All roles' Score. User's Appraisal: User's Appraisal Time Completed, Previous Time Completed, User's Appraisal Status, User's Appraisal Status, User's Current Stage, User's Current Stage Due. Appraisal: Appraisal Name, Appraisal Status, Appraisal Time Started, Appraisal Time Finished. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Appraisal Status | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Performance Management appraisal status details including stage information and completion status. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | User's Appraisal: User's Appraisal Time Completed, Previous Time Completed, User's Appraisal Status, User's Appraisal Status, User's Current Stage, User's Current Stage Due. Appraisal: Appraisal Name, Appraisal Status, Appraisal Time Started, Appraisal Time Finished. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Assignment submissions | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Assignment activity submission information by user. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Assignment: Assignment intro, Submission status, Assignment name. Grade: Grade scale values, Feedback comment, Last modified (submission), Last modified (grade), Min grade, Max grade, Submission grade. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authetication Method, User Status, User Creation Time, User Last Modified, HR Import. Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Assignment submissions summary | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Assignment activity submission information by assignment. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Assignment: Assignment intro, Submission status, Assignment name. Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Audiences | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details from all the audiences in the system. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Audience: Audience Name, Audience Name (with link), ID, Type, No. of Members, Actions, Start date, End date, Status. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Audiences Orphaned Users | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details on all users not in an audience. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Statistics: User's Achieved Competency Count, User's Courses Started Count, User's Courses Completed Count, Course Completion as Evidence. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Audience Members | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Audience information including information on users who are members of the audience. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Audience: Audience Name, Audience Name (with link), ID, Type, No. of Members, Actions, Start date, End date, Status. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Audience: Enrolled Learning | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Courses and programs that audiences are enrolled in including completion rules. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Association: Name, Type, Name (with icon and link), Actions, Assignment due date, Actual due date. Audience: Audience Name, ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Audience: Visible Learning | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Course and program listing with the audience name and audience(s) visibility setting displayed. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Learning: Name, Visibility, Type, Name (with icon and link), Actions, Completion. Audience: Audience Name, ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Badges issued | ||||||||||||||||||||||||||||||||||||||||||||
Description: | View users who have been issued a badge. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Badge Issue: Badge expiry date, Badge issuer notified, Badge issue date. Badge: Badge issuer name, Badge issuer contact, Badge name, Badge description, Badge image, Badge type, Badge status. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authetication Method, User Status, User Creation Time, User Last Modified, HR Import. Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Certifications | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details of the Certifications setup. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. Certification: Certification Name, Certification Short Name, Certification ID number, Certification ID, Certification Summary, Available From, Available Until, Certification Name and Linked Icon, Certification Name (expanding details), Certification Visible, Audience Visibility, Recertification method, Active Period, Window Period. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Certification Completion | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Show users details and progress for users who are assigned to a certification. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Certification Completion: Date assigned, Date completed, Date due, Completion organisation ID, Completion organisation, Completion position ID, Completion position, Status, Is certified, Is not certified, Is in progress?, Is not started?, Has never certified. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. Certification: Certification Name, Certification Short Name, Certification ID number, Certification ID, Certification Summary, Available From, Available Until, Certification Name and Linked Icon, Certification Name (expanding details), Certification Visible, Audience Visibility, Recertification method, Active Period, Window Period. If both the RAG (red-amber-green) status and certification status are included in the Certification Completion report then this information will be displayed as follows:
Expired or overdue certifications will display as red (indicating a problem), certifications that have been assigned with a due date or for which the window is open will display as amber (indicating an action is required), while valid certifications and certifications that have been assigned without a due date display as green (indicating that no action is required). | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | Certification Membership | ||||||||||||||||||||||||||||||||||||||||||||
| Description: | Details of all certification memberships. | ||||||||||||||||||||||||||||||||||||||||||||
| Potential columns: | User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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. Certification: Recertification method, Active Period, Window Period. Certification Membership: Status, Is currently certified, Is currently assigned, Edit completion records. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Certification Overview | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Show users details and progress for users who are assigned to a certification and details of courses. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Certification: Certification Name, Certification Short Name, Certification ID number, Certification ID, Certification Summary, Available From, Available Until, Certification Name and Linked Icon, Certification Name (expanding details), Certification Visible, Audience Visibility, Recertification method, Active Period, Window Period. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Certification Completion: Date started, Date assigned, Date Completed, Completion Organisation Short Name, Completion Organisation Full Name, Completion Organisation Type, Completion Position Full Name, Completion Position Type, Completion Position ID, Due Date (extra info), Status, Renewal status, Window opens, Expiration date, Completion date, Progress, Progress (%), Certification path, Due date. Course: Date enrolled, Date started, Date completed, Grade Pass, Course Category, Course Category (linked to category), Course Category ID, Course Short Name, Course Status, Final Grade. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Competency Status | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Learners progress on their assigned competencies. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Competency Status: Proficiency ID, Date Proficiency Achieved, Completion Organisation ID, Completion Organisation Path, Completion Organisation Name, Completion Position ID, Completion Position Path, Completion Position Name, Assesor Name, Assessor Orgnaisation, Proficiency, Last Modified. Competency: Competency Name, Competency Short Name, Competency ID, Competency Name (linked to competency page), Competency ID, Competency Path, User's Status Hoistory Link. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authentication Method, User Status, User Creation Time, User Last Modified, HR Import. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Competency Status History | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Learners progress on their assigned competencies. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Competency: Competency Name. Competency status history: User's Goal Status, User's Status Time Modified, User's Status Modified By User, Date proficiency achieved. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Completion import: Certification status | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Log details from the import of certification records through a CSV file. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Import: ID, Line number, Errors, Imported as evidence?, Imported by user id, Time uploaded, Username to import, Certification Shortname, Certification ID Number, Completion date, Due date. Imported By: Imported by, Imported by username. Evidence: Description, File attachments, Date completed. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Completion import: Course status | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Log details from the import of course completion records through a CSV file. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Import: ID, Line number, Errors, Imported as evidence?, Imported by user id, Time uploaded, Username to import, Course Shortname, Course ID Number, Completion date, Grade. Imported By: Imported by, Imported by username. Evidence: Description, File attachments, Date completed. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Courses | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details about all the courses. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course Date Created. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. Tags: Tags. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Course Completion | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Course completion status records including user details, course details and completion status. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Course completion: Is complete? (any method, Is not complete?, Is complete? (not via RPL), Is complete? (via RPL), Is not yet started?, Date Started, Date Enrolled, Enrolment Types, Time to complete (since start date), Time to complete (since enrol date), Completion Organisation ID, Completion Organisation Name, Completion Position ID, Grade, Pass Grade, Grade and required grade, Progress, Progress (%), Completion Position Name, Completion Status, The completion date, Is in progress? User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authentication Method, User Status, User Creation Time, User Last Modified, HR Import. Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Course Completion including history | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Course completion status records including user details, course details for all courses. | ||||||||||||||||||||||||||||||||||||||||||||
Columns: | User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authentication Method, User Status, User Creation Time, User Last Modified, HR Import. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Course Completion: Date completed, Grade at time of completion, Is current record. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Course Completion by Organisation | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Course completion details grouped by organisation. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Course Completion: Completion Organisation ID, Completion Organisation Path (IDs), Completion Organisation Path (text), Percentage Completed, Number Completed via RPL, Percentage Completed via RPL, Number in Progress, Number not Started, Completion Organisation Name, Number Completed, Number of Records, Earliest Completion Date, Latest Completion Date. User: All participants. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Course Membership | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details about course members. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Course Membership: Edit course completion. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User Status, User Creation Time, User Last Modified, 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), Job assignments. Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Deleted user accounts | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details about deletd users including their purge type. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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), Actions. Suspended users purge type: Suspended purge type, ID. Deleted users purge type: Deleted purge type, ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Feedback Summary | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Learner responses to the feedback activity used to survey learners in a course. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Trainer: Trainer ID, Trainer Full Name, Trainer Organisation ID, Trainer Organisation, Trainer Position. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authentication Method, User Status, User Creation Time, User Last Modified, HR Import. Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. Feedback: Feedback Activity. Responses: Time Completed. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Goal Custom Fields | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Company goals and users' current progress on their assigned goals. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Goal: Goal Name, Personal or Company, Goal Type, All personal goal custom fields, All company goal custom fields. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Goal Status | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Company goals and users' current progress on their assigned goals. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Goal: Goal Name, Goal Framework Name, User's Goal Status, User's Goal Status History Link. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Goal Status History | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Company goals and user progress over time on their assigned goals. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Goal: Goal Name, Goal Type. Goal status history: User's Goal Status, User's Status Time Modified, User's Status Modified By User. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Goal Summary | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Company goals with summary details including number of users assigned and number of users per status. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Goal: Goal Name, Goal Name With Link, Number of Users Assigned, Scale Count Columns. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | HR Import Log | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Logging of HR Import activity. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | HR Import Log: id, Run ID, Date/Time, Element, Log type, Action, Info. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Job assignments | ||||||||||||||||||||||||||||||||||||||||||||
Description: | List job assignments. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Job assignment: Short name, ID Number, Start date, End date. User: User's Fullname, User's Fullname (linked to profile), User's Email, User's Email, User's Email (ignoring user display setting), 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 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, 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). Position: ID number, Name, Shortname, Type, Type ID Number, Framework, Framework ID number, Visible. Organisation: ID number, Name, Short name, Type, Type ID number, Framework, Framework ID number, Visible. Manager: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). Appraiser: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). Temporary Manager: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | Language Customisation | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Shows customisations to the language pack | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Customisation: Customised, Language, String ID, Original, Local. Component: Component version, Component. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Learning Plans | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Learning plan information by user. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Plan: Plan name, Description, Completion date, Plan, Plan start date, Plan end date, Plan status. Plan Template: Plan template start date, Plan template end date, Plan template. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authentication Method, User Status, User Creation Time, User Last Modified, HR Import. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s) | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | Legacy Site Logs | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Site-wide user activity logging (pre old format without user information). | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Log: Time, Module, CMID, Action, URL, IP address, Action, Info. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authentication Method, User Status, User Creation Time, User Last Modified, HR Import. Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Messages | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Alerts and notifications sent by the system and users. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Message Values: Subject, Message Content, Message Urgency (icon), Message Urgency, Message Type, Message Type (text), Message Category, Sent, Select, Message ID. Recipient User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User Status, User Creation Time, User Last Modified. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Organisations | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Position structure details. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Organisation: Short name, Description, Type, Type ID number, Framework ID number, Visible, Parent name, Created, Modified, Member count, Member count (including child organisations), ID number, Name, Framework, Parent ID number, Competencies. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Positions | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Position structure details. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Position: Short name, Description, Type, Type ID number, Framework ID number, Visible, Parent name, Created, Modified, Member count, Member count (including child positions), ID number, Name, Framework, Parent ID number, Competencies. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Programs | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details about the programs and course category. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Program: Program Name, Program Short Name, Program ID number, Program ID, Program Summary, Available From, Available Until, Program Name and Linked Icon, Program Name (expanding details), Program Visible, Audience Visibility. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Program Completion | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Program completion information and program details. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Program Completion: Status, Date assigned, Is complete?, Is not complete?, Is in progress?, Is not started?, Date completed, Due date, Completion organisation ID, Completion organisation, Completion position ID, Completion position. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. Program: Program Name, Program Short Name, Program ID number, Program ID, Program Summary, Available From, Available Until, Program Name and Linked Icon, Program Name (expanding details), Program Visible, Audience Visibility. | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | Program Membership | ||||||||||||||||||||||||||||||||||||||||||||
| Description: | All program membership details. | ||||||||||||||||||||||||||||||||||||||||||||
| Potential columns: | User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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. Program: Program Name, Program Short Name, Program ID number, Program ID, Program Summary, Available From, Available Until, Program Name and Linked Icon, Program Name (expanding details), Program Visible, Audience Visibility, Level. Program Membership: Status, Is currently assigned, Edit completion records. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Program Overview | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Program details and status including information about the courses that are a part of the program content. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Program: Program Name, Program Short Name, Program ID number, Program ID, Program Summary, Available From, Available Until, Program Name and Linked Icon, Program Name (expanding details), Program Visible, Audience Visibility. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User Status, User Creation Time, User Last Modified, 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), Job assignments. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Program Completion: Due Date (extra info), Date started, Date assigned, Date Completed, Progress (%), Completion Organisation Short Name, Completion Organisation Full Name, Completion Organisation Type, Completion Position Full Name, Completion Position Type, Completion Position ID, Due Date, Progress Status, Progress. Course: Date enrolled, Date started, Date completed, Grade Pass, Course Category, Course Category (linked to category), Course Category ID, Course Short Name, Course Status, Final Grade. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Certifications | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Certification assignment and course completion information. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Programs: Certification name, Program Short Name, Program ID number, Certification ID. Certification completion: Certification due date, Certification path, Status, Renewal status, Window opens, Expiration date, Completion date, Progress. Certification Completion History: Previous completions, Previous completion count. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Competencies | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Competency assignment and completion information. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Plan: Plan name, Plan name (linked to plan page), Plan start date, Plan end date, Plan status. Plan Template: Plan template name, Plan template start date, Plan template end date. Competency: Competency name, Competency due date, Competency priority, Competency status, Competency edit status (link), Competency type, Competency type ID, Competency proficiency, Proficient at Competency?, Competency proficiency (and approval status), Courses, User's Status History Link. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Courses | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Course assignment and completion information, by default used to build the Record of Learning embedded report. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course status, Course Date Created. Plan: Plan name, Plan name (linked to plan page), Plan start date, Plan end date, Plan status, Course due date, Course priority. Course completion: Course completion date, Completion status, Enrolled, Completion status (and approval status), Grade, Pass Grade, Grade and required grade. Plan Template: Plan template name, Plan template start date, Plan template end date. Previous Course Completion: Previous Completion, Previous Completion count. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Evidence | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Evidence information. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Evidence: Name, Name (link), Time Created, Time Modified, View evidence link, Evidence Type, In Use?, Actions, Description, File attachments, Date completed. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Objectives | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Objective assignment and completion information. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Plan: Plan name, Plan name (linked to plan page), Plan start date, Plan end date, Plan status. Plan Template: Plan template name, Plan template start date, Plan template end date. Objective: Full name, Full name (linked to detail page), Short name, Description, Objective due date, Objective priority, Objective approved, Objective status, Achieved Objective?, Objective status (and approval status). User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Previous Certifications | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Certification assignment and course completion information. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Program: Certification name, Program Short Name, Program ID number. Certification completion: Current?, Certification ID, Completion dare, Expiration date. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Previous Course Completions | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Evidence information, by default used to build the Record of Learning embedded report. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Course Completion History: Date completed, Grade at time of completion. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course Date Created. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Programs | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Program assignment and completion information. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Program: Program Name, Program Short Name, Program ID number, Program ID, Program Name and Linked Icon, Program due date, Program mandatory, Program recurring. Program Completion: Completion status, Time assigned, Time started, Date completed. Program Completion History: Previous completion, Count of previous completions. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Record of Learning: Recurring Programs | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Historic program assignment and completion information. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Program: Program Name, Program Name and Linked Icon, Program Short Name, Program ID number, Program ID. Program Completion History: Course name, Status, Completion date, Due date. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Report | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Lists all the reports in Report builder. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Report: Report Name, Name (linked to edit report), Name (linked to view report), Name (linked to edit report) and view link, Report ID, Is embedded report?, Is hidden on My Reports?, Source, Action, Number of columns, Number of filters, Number of scheduled reports, Number of saved searches, Global report restrictions. | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | SCORM | ||||||||||||||||||||||||||||||||||||||||||||
| Description: | SCORM activity completion details and settings collected across all courses. | ||||||||||||||||||||||||||||||||||||||||||||
| Potential columns: | SCO: SCO Status Modified, SCO Min Score, SCO Max Score, SCO Title, SCO Attempt Number, SCO Start Time, SCO Total Time, SCO Status, SCO Score. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authetication Method, User Status, User Creation Time, User Last Modified, HR Import. 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. SCORM: Scorm Title. Unenrolled users and site admins are excluded from the activity level SCORM report however they will be included in the SCORM report source when using Report Builder. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Scheduled reports | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Information about the scheduled reports in the system. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Schedule: Format, Next schedule, Schedule, Scheduler actions, Export destination, Recipients (audiences), Recipients (system users), Recipients (external), Last modified by, Last modified time. Saved search: Saved search name. Report: Report Name, Name (linked to edit report), Name (linked to view report), Name (linked to edit report) and view link, Report ID, Is embedded report?, Is hidden on My Reports?, Source, Action, Number of columns, Number of filters, Number of scheduled reports, Number of saved searches, Global report restrictions. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Self-registration request | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details of pending self-registration requests. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Request: Status, User First Name, User Last Name, Username, User's Email, User's City, User's Country, User's Preferred Language, Email confirmed, Organisation free text, Position free text, Manager, Manger free text, Time requested, Time modified, Time resolved, Actions. Organisation: Organisation framework, Organisation. Position: Position framework, Position. Created user: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display setting), 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User's Authetication Method, User Status, User Creation Time, User Last Modified, HR Import, 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). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Assets | ||||||||||||||||||||||||||||||||||||||||||||
Description: | List of seminar assets. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Asset: Asset ID, Asset Name, Asset Name (linked to asset details page), Asset Published, Asset Description, Asset Visible, Asset Allow Schedule Conflicts, Actions. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Asset Assignments | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Upcoming events using assets. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course Date Created. Seminar: Assets: Asset ID, Asset Name, Asset Name (linked to asset details page), Asset Published, Asset Description, Asset Visible, Asset Allow Schedule Conflicts. Session: Event Capacity, Number of Attendees, Number of Attendee (linked to attendee page), Overall status, Booking Status. Date: Session Start Date/Time, Session Finish Date/Time. Room: Room ID, Room Name, Room Name (linked to room details page), Room Published, Room Description, Room Visible, Room Maximum Bookings, Room Allow Schedule Conflicts, Building, Location. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Events | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Lists all seminar events. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Event: Number of Attendees (inc Waiting Approval, Approved and Wait-listed), Number of wait-listed, Places available, Number of cancelled bookings. Number fully attended, Number partially attended, Number of no shows, Number of declined attendees, Event Details, Overbooking allowed, Event Capacity, Number of Attendees, Number of Attendees (linked to attendee page), Overall status, Booking Status. Seminar: Minimum bookings, Normal cost, Discount cost, Session ID, Seminar ID, Seminar Name, Seminar Name (linked to event page), Approval Type. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course Date Created. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Interest | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details on users who have declared interest in attending a Seminar. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Seminar: Seminar Name, Seminar Name (linked to event page), Date of declared interest, Stated reason for interest. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course Date Created. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Rooms | ||||||||||||||||||||||||||||||||||||||||||||
Description: | List of seminar rooms. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Room: Room ID, Room Name, Room Name (linked to room details page), Room Published, Room Description, Room Visible, Room Maximum Bookings, Room Allow Schedule Conflicts, Actions, Building, Location. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Room Assignments | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Upcoming events using rooms. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Seminar: Seminar ID, Seminar Name, Seminar Name (linked to event page), Approval Type, Session ID. Asset: Asset Name. Session: Event Capacity, Number of Attendees, Number of Attendees (linked to attendee page), Overall status, Booking Status. Date: Session Start Date/Time, Session Finish Date/Time. Room: Room ID, Room Name, Room Name (linked to room details page), Room Published, Room Description, Room Visible, Room Maximum Bookings, Room Allow Schedule Conflicts, Building, Location. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Sessions | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Details on all seminar sessions. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Event: Number of Attendees (inc Waiting Approval, Approved and Wait-listed), Number of wait-listed, Places available, Number of cancelled bookings. Number fully attended, Number partially attended, Number of no shows, Number of declined attendees, Event Details, Overbooking allowed, Sign-up Period, Sign-up Start Date, Sign-up End Date, Event Capacity, Number of Attendees, Number of Attendees (linked to attendee page), Overall status, Booking Status. Seminar: Minimum bookings, Normal cost, Discount cost, Session ID, Seminar ID, Seminar Name, Seminar Name (linked to event page), Approval Type. Date: Session Start Date/Time (linked to attendees page), Session Start Date/Time, Session Finish Date/Time. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course Date Created. Asset: Asset ID, Asset Name, Asset Name (linked to asset details page), Asset Published, Asset Description, Asset Visible, Asset Allow Schedule Conflicts. Room: Room ID, Room Name, Room Name (linked to room details page), Room Published, Room Description, Room Visible, Room Maximum Bookings, Room Allow Schedule Conflicts, Building, Location. Link to Approval requests: Manage approval (linked to manager approvals page) | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Sign-in Sheet | ||||||||||||||||||||||||||||||||||||||||||||
Description: | A record of everyone who has signed into a seminar session. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Session: Session Capacity, Number of Attendees, Session Details, Booked by, Normal cost, Discount cost, Discount code. Status: Status. Seminar: Seminar Name, Seminar Name (linked to session page). Session Date: Session Start Date, Session Start Date (linked to activity), Session Finish Date, Session Start Time, Session Finish Time. User Session Signups: Signature. Room: Room ID, Room Name, Room Name (linked to room details page), Room Published, Room Description, Room Visible, Room Maximum Bookings, Room Allow Schedule Conflicts. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course Date Created. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. Signup note customfields: Request for session organiser. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Seminar Sign-ups | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Provides detailed information of Seminar events and who has signed up for them. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Event: Event Capacity, Number of Attendees, Event Details, Sign-up Period, Sign-up Start Date, Sign-up End Date, Cancellation date, Booked by, Position on sign up, Job assignment, Cancelled status, Normal cost, Discount cost, Discount code. Status: Status, Actioned By, Time of sign-up. Seminar: Seminar Name, Seminar Name (linked to event page). Date: Session Start, Session Start (linked to activity), Session Finish, Event Start Time, Event Finish Time. Approver: Approver name, Approver Email, Approval Time. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). Course: Content, Course Name, Course Name (linked to course page), Course Name (expanding details), Course Name (linked to course page with icon), Course Visible, Audience Visibility, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language, Course Date Created. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. Asset: Asset ID, Asset Name, Asset Name (linked to asset details page), Asset Published, Asset Description, Asset Visible, Asset Allow Schedule Conflicts. Room: Room ID, Room Name, Room Name (linked to room details page), Room Published, Room Description, Room Visible, Room Maximum Bookings, Room Allow Schedule Conflicts, Building, Location. Signup Custom Fields: All sign up custom fields, Requests for session organiser. User Cancellation Custom Fields: Cancellation note. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Server upgrade history | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Provides information of what, who and when Totara has been upgraded. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User Status, User Creation Time, User Last Modified, User's Picture, User's My Learning Icons, User Fullname (with links to learning components), Extensions, 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), Job assignments. Upgrade Log: Time, Componenet, Type, Version, Target version, Info, Details, Backtrace. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Site Logs | ||||||||||||||||||||||||||||||||||||||||||||
Description: | Site-wide user activity logging. On large sites this report source could cause significant performance issues. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Log: Target & action, Event Class Name, Component, Context, Action, Target, Object table, Object id, Origin, CRUD, All events, Event Name, Event Name (linked to event source), Description, Time, IP address, Other info. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User Status, User Creation Time, User Last Modified, User's Picture, User's My Learning Icons, User Fullname (with links to learning components), Extensions, 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), Job assignments. 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, Course Icon, Course Shortname, Course ID Number, Course ID, Course Start Date, Course Name and Summary, Course Summary, Type, Course Type, Course language. Category: Course Category, Course Category (linked to category), Course Category ID Number, Course Category ID. All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Tags: Tags. Related users: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email, User's Email (ignoring user display setting), User Last Login, User First Access, 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 ID Number, User's Phone number, User's Institution, User's Department, User's Address, User's City, User ID, User's Country, User Status, User Creation Time, User Last Modified, User's Picture, User's My Learning Icons, User Fullname (with links to learning components), Extensions, 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), Job assignments. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | Site Policy Records | ||||||||||||||||||||||||||||||||||||||||||||
Description: | All site policies and how users have responded. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Primary policy: Policy Title, Date Created, Created by, Version Number, Status, Date Published, Published by, Consent Statement (primary), Response (primary). User Response: Consented (Yes/No), Language consented in, Consent Statement, Response, Date Consented. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | User | ||||||||||||||||||||||||||||||||||||||||||||
Description: | User profile data and completion statistics. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). All User's Job Assignments: User's Job Title(s), User's Job Start Date(s), User's Job End Date(s), User's Position Name(s), User's Position ID(s), User's Position ID Number(s), User's Position Type(s), User's Position Framework(s), User's Position Framework ID(s), User's Position IS Number(s), User's Organisation Name(s), User's Organisation ID(s), User's Organisation ID Number(s), User's Organisation Type(s), User's Organisation Framework(s), User's Organisation Framework ID(s), User's Organisation Framework ID Number(s), User's Manager Name(s), User's Manager's First Name(s), User's Manager's Last Name(s), User's Manager ID(s), User's Manager ID Number(s), User's Manager Emails(s) (ignoring user display setting), User's Manager Email(s), User's Appraiser Name(s). Suspended user purge type: Suspended purge type, ID. Deleted user purge type: Deleted purge type, ID. Statistics: User's Achieved Competency Count, User's Courses Started Count, User's Completed Count, Course Completions as Evidence. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | User data exports | ||||||||||||||||||||||||||||||||||||||||||||
Description: | User profile data and completion statistics. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Export: ID, Origin, Context, Created, Started, Finished, Result. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). Created by: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). Type: ID, Full name, Full name (with link), ID number, Description, Permitted use, Includes files, Created, Changed, New items, Actions. | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | User data export items | ||||||||||||||||||||||||||||||||||||||||||||
| Description: | All of the user export items. | ||||||||||||||||||||||||||||||||||||||||||||
| Potential columns: | Item: ID, Item, Started, Internal item name, Item component, Finished, Result. Export: ID, Origin, Context, Created, Started, Finished, Result. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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. Created by: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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. Type: ID, Full name, Full name (with link), ID number, Description, Permitted use, Includes files, Created, Changed, New items, Actions. | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | User data export type items | ||||||||||||||||||||||||||||||||||||||||||||
| Description: | All of the types of export items. | ||||||||||||||||||||||||||||||||||||||||||||
| Potential columns: | Items: ID, Item, Internal item name, Item component, Export data. Type: ID, Full name (with link), ID number, Description, Permitted use, Include files, Created, Changed, New items, Actions, Export type (Type). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | User data export type | ||||||||||||||||||||||||||||||||||||||||||||
Description: | All of the user data export types. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Export type: ID, Full name, Full name (with link), ID number, Description, Permitted use, Includes files, Created, Changed, New items, Actions. | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | User data purge items | ||||||||||||||||||||||||||||||||||||||||||||
| Description: | All of the user purge items. | ||||||||||||||||||||||||||||||||||||||||||||
| Potential columns: | Item: ID, Item, Started, Internal item name, Item component, Finished, Result. Purge: ID, Origin, Context, Created, Started, Finished, Result, Actions. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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. Created by: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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,. Type: ID, Full name, Full name (with link), ID number, Description, Available use, Created, Changed, New items, Actions. | ||||||||||||||||||||||||||||||||||||||||||||
| Source: | User data purge type items | ||||||||||||||||||||||||||||||||||||||||||||
| Description: | All of the types of purge items. | ||||||||||||||||||||||||||||||||||||||||||||
| Potential columns: | Items: ID, Item, Internal item name, Item component, Purge data. Type: ID, User status restriction, Full name (with link), ID number, Description, Available use, Created, Changed, New items, Actions, Purge type (Type). | ||||||||||||||||||||||||||||||||||||||||||||
Source: | User data purges | ||||||||||||||||||||||||||||||||||||||||||||
Description: | A record of all of the purged that have been run. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Purge: ID, Origin, Context, Created, Started, Finished, Result. User: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). Created by: User's Fullname, User's Fullname (linked to profile), User's Fullname (linked to profile with icon), User's Email, User's Email (ignoring user display settings), 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 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, 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). Type: ID, Full name, Full name (with link), ID number, Description, Permitted use, Includes files, Created, Changed, New items, Actions. | ||||||||||||||||||||||||||||||||||||||||||||
Source: | User data purge type | ||||||||||||||||||||||||||||||||||||||||||||
Description: | All of the data purge types. | ||||||||||||||||||||||||||||||||||||||||||||
Potential columns: | Purge type: ID, User status restriction, Full name, Full name (with link), ID number, Description, Available use, Created, Changed, New items, Actions. |
The Totara Academy has a whole course dedicated to using Reports in Totara Learn. Here you can learn more on how to use reports, see best practice, and give it a go yourself.
