System Reports
| Name | Description | Report Query |
|---|---|---|
| Checklist Details | Includes all data stored in a checklist record for any student. Filters available for this report include: Students, Mastery Date, Checklist, Status, Supervisor, and Language. | CheckListDetails |
| SR Administrators | List of Administrators and their Workgroup memberships. | Administrators |
| SR Billable Transactional Count | Summary count of number of course instances administered (used to calculate/Validate licensing as appropriate). | TransactionDetails |
| SR Billable Transactional Count Details | Detailed list of user course records within a reporting period. | TransactionDetails |
| SR Billable User Count | Summary count of active user accounts within a reporting period. | UserDetails |
| SR Billable User Count Details | Detailed list users First Name, Last Name, login, Student Ref (Emp ID, and Job Title for all active users in a reporting period. | UserDetails |
| SR Catalog Items By Group | List of Catalog Items by Student Group | CatalogItemsForGroup |
| SR Catalog Items By Group With Training Events | List of Catalog Items by Student Group with Training Events | CatalogItemsForGroupWithTrainingEvents |
| SR Certification Due Dates | Displays when training was mastered compared to when it was due. | StudentTrainingHistory_V2 |
| SR Competency | List of selected Competencies. | Competency |
| SR Competency Gap Analysis | Matrix report showing competency mastery for a defined set of students. Use it to predict the expected compliance timeframe for any competency that is not controlled by a learning journey. The expected compliance timeframe can be estimated based on the default values for certification/recertification defined for the competency. Requires student criteria and competency filter values. | CompetencyGapAnalysis |
| SR Compliance Variance Summary | List of variances based on compliance to learning journeys in any ‘type’ associated with a learning journey. Variances can be the result of an open search or filtered. ‘UserCompany’ added as available field to this report query. | StudentTrainingPlan |
| SR Compliance Variance Summary by Area | As above and grouped by Organization Unit (parents) | StudentTrainingPlan |
| SR Course Certificate | Course Certificate by eCourse or Training Activity | StudentCompletion |
| SR Course Series Grading Chart | List of tasks and associated grades for students by Training Activity. | CourseGradingSheetSeries |
| SR Declined Training Event Invitation | To report on Training Event decline audit trail | TrainingEventUsersDeclined |
| SR Duplicate Training Records | List of duplicate training records by student. | DuplicateUserContent |
| SR Ecourses | Uses ECourses query list of Ecourses and information associated with each Ecourse | Ecourses |
| SR eCourse Activity | Displays user activity data for eCourses, including start date, end date, time in course, and exit reason. Report is grouped by eCourse. | ECourseActivity |
| SR Group Members | List of Groups and their Student members. | StudentGroups |
| SR Glossary Terms | List of Glossary terms and the associated Content Objects and eCourses. | Glossary |
| SR Glossary Terms Details | List of Glossary terms and the Content Objects and the associated eCourses along with creation date and associated audio or graphic information. | Glossary |
| SR Instructor Guide | ‘Lesson Content’ and ‘Instructor Notes’ by eCourse/Training Activity and children. | InstructorGuide |
| SR Instructor Training Event Schedule | Displays instructor schedules by training event. | TrainingEventUsers |
| SR Content Mastery Summary | List of selected content (eCourses and Training Activities) with total # of students attaining mastery. | StudentTrainingHistory |
| SR Invoice | Invoice by account name and sales item(s) (i.e. course). Includes billing data as purchaser data | InvoiceByInvoiceNumber |
| SR Invoice Details_1 v1.0 | Invoice details for exporting. | InvoiceDetails_1 |
| SR Jobs | Jobs | |
| SR Media Use | Display media in use (or not in use) and where used. | MediaUse |
| SR Metrics That Matter® Export | Used to support the integration with KnowledgeAdvisors Metrics that Matter®: Starter Edition by reporting on daily student activity. | MetricsThatMatterExport |
| SR Organization Structure | Display the Organization Unit structure. External Keys field available in query (v4.2.5) | OrganizationUnits |
| SR Organization Anomalies | External Keys field available in query (v4.2.5) | Students |
| SR Privileges and Data View Restrictions. | Provides details of privileges and data view restrictions grouped by user | PrivilegesAndDvr |
| SR Learning Journey Details | Learning Journey Details | |
| SR Learning Journeys Due By Content | List of Due learning journeys by learning journey certification type (Requirement, Competency or Content). | StudentTrainingPlan |
| SR Learning Journeys Due by Student | List certification by student. | StudentTrainingPlan |
| SR Learning Journeys Past Due By Content | List of Past Due learning journeys by learning journey certification type (Requirement, Competency or Content). | StudentTrainingPlan |
| SR Learning Journeys Past Due by Student | List past due certification by student. | StudentTrainingPlan |
| SR Learning Journeys Status By Content | List of learning journey status by student within learning journey certifications. | StudentTrainingPlan |
| SR Learning Journey Status By Content (Basic1) | To improve report performance for learning journey reports using this new query for: List of learning journey status by student within learning journey certifications. (Note: Added field UserPhone to query for v4.2.5.) | StudentTrainingPlanBasic1 |
| SR Learning Journeys Status by Student | List of learning journey status by certification within student. Shows students learning journey status (MET, NOT MET, DUE, or EXPIRED) by Content, Competencies, and Requirements grouped by Learning Journeys. | StudentTrainingPlan |
| SR Question Bank | List of question bank items. | Questions |
| SR Random Order Question Exams | Generate random order question exams in pdf – allows for printing of the exams | RandomQuestionExams |
| SR Recertification Report by Content | Recertification status for the student grouped by certification. | StudentTrainingPlan |
| SR Recertification Report by Student | Recertification status for the certification grouped by student. NOTE: UserCompany is an available field to the StudentTrainingPlan report query. | StudentTrainingPlan |
| SR Report Activity | Provides details for monitoring Report activity on your server, grouped by Report name. | ReportActivity |
| SR Report Activity By Date | Provides details for monitoring Report activity on your server, grouped by Report generation date. | ReportActivity |
| SR Resource Schedule | ResourceSchedule | |
| SR Revenue By Course | List of courses and associated revenue. | CatalogItemByCourseCombined |
| SR Revenue By Course Venue | List of course location and associated revenue. | CatalogItemByCourseVenueCombined |
| SR Revenue By Media | List of media and associated revenue. | CatalogItemByMediaCombined |
| SR Revenue By Package | List of ‘packages’ and associated revenue. | CatalogItemByPackageCombined |
| SR SCORM Interactions | List of user interaction data saved by imported SCORM 2004 SCOs. | ScormInteractions |
| SR Student Exam Failures | A printout of a student exam that matches the student choices against the correct choices for a selected exam. Instructors may use this report to review a completed exam with students. | StudentExams |
| SR Student Exam Results | List of student exam results by exam and attempt. | StudentExams |
| SR Student Exam With Answers | A student report to provide feedback to users taking Rival Learn exams. Displays exam results, as well as the correct responses for each question. | StudentExamsAnswers |
| SR Student Group | Listing of Students and the Groups in which they are members. | StudentGroups |
| SR Student History | List of students with training history for each. (Note: TEStartDate and TEEndDate have been added for v4.2.5) | StudentTrainingHistory |
| SR Student History (Recent) by Content | List of content / certifications with recent student activity for each. (Note: TEStartDate and TEEndDate have been added for v4.2.5) | StudentTrainingHistory |
| SR Student History – All Exams | Show Student Training History, including Exam contained within eCourses. (Note: TEStartDate and TEEndDate have been added for v4.2.5) | StudentTrainingHistoryAllExams |
| SR Student History By Content | List of content / certifications with student activity for each. (Note: TEStartDate and TEEndDate have been added for v4.2.5) | StudentTrainingHistory |
| SR Student History By Content (Basic1) | To improve report performance for history reports using this new queries for: List of content / certifications with student activity for each | StudentTrainingHistoryBasic1 |
| SR Student Learning Journeys | Learning JourneyByUser | |
| SR Student SCORM Activity | Displays student attempt score and completion data for all SCORM or AICC student course records. | StudentScormActivityTracking |
| SR Student Sign-In Roster | List of Training Activities/Events within student sign-in for each. | TrainingEventUsers |
| SR Student Training Combined | Combination of student training History and Student Training Plan (learning journeys) reporting on both the MET and Scored status. (Note: TEStartDate and TEEndDate have been added for v4.2.5) | StudentTrainingAll |
| SR Student Training History By Group - with Default CEUs | Shows Student Training History grouped by Student Group, and include Student Group Membership data. Group is a required filter field. You must provide at least 1 Group to retrieve records (Note: TEStartDate and TEEndDate have been added for v4.2.5) | StudentTrainingHistoryByGroup |
| SR Student Training History with Default CEUs | Shows Student Training History grouped by Student. (Note: TEStartDate and TEEndDate have been added for v4.2.5) | StudentTrainingHistory |
| SR Students | List of students by name including reference, job, and organizational area. External Keys field available in query (v4.2.5) | Students |
| SR Students by Area | List of organizational areas with students attached to each area. External Keys field available in query (v4.2.5) | Students |
| SR Students by Job | List of jobs with students attached to each job. External Keys field available in query (v4.2.5) | Students |
| SR Subscription Activity | Displays list of subscription activities during a time period. | SubscriptionActivity |
| SR Survey Results Detail | A statistical analysis of course surveys completed by students. Analyze student reactions to completed courses. Filter by eCourse has been added. | StudentSurveys |
| SR Survey Results Summary | List of surveys with summary results for each. Filter by eCourse has been added. | StudentSurveys |
| SR Test Item Analysis | A statistical analysis of selected test items used in examinations. Determine the reliability and validity of test items within the Rival Learn question banks. | Questions |
| SR Test Item Analysis (2) | Includes Matching & Fill-in-the-Blank | QuestionsFlaQ |
| SR Token Activation Code Details | Details for Tokens by invoice. | TokenActivationCodeDetails |
| SR Tokens By Group | List of student groups with tokens and the tokens available to each. | TokensByGroup |
| SR Tokens By Student | List of students with tokens and the tokens available to each. | TokensByStudent |
| SR Training Activities | List of Training Activities and information associated with each activity. | TrainingActivities |
| SR Training Analysis | Reports on daily student activity for use in integrations. | StudentTrainingHistoryAnalysis1 |
| SR Training Event Summary | List of Training Events with summary information for each. | TrainingEventUsers |
| SR Training Locations | Summary report displays Venue Name, Training Location Name, Reference, Contact Information, Email, and Phone. | TrainingLocations |
| SR Training Summary by Area (cross tabbed) | List of organizational areas with training summary information for each. | StudentTrainingHistory |
| User Course Audit | Summary of User Name, Course Title, Action (Add, Update, or Delete) and a list of fields changed for updated records. | User Course Audit |
| User Course Audit Details | Detailed list of User Name, Course Title, Action (Add, Update, or Delete) and the detailed field values changed for all updated fields. | User Course Audit Details |
| SR User Profile Details | Summary of user count | UserProfileCounts |
| SR User Profiles | Summary of user count | UserProfileCounts |
| SR Weekly Roster | List of Training Activities/Events and dates within a week, with student roster for each. | TrainingEventUsers |
| System - GL Learning Certificate | Displays course completion to all types of certificates. | StudentCompletionAllContent |