SilkRoad Logo Print topic
 

Previous Topic

Next Topic

System Reports

Name

Description

Report Query

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 qualification. 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 qualifications in any ‘type’ associated with a qualification.

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.

DuplicateUserInterventions

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 Intervention Mastery Summary

List of selected interventions (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 Qualification Details

Qualification Details

 

SR Qualifications Due By Intervention

List of Due qualifications by qualification certification type (Requirement, Competency or Intervention).

StudentTrainingPlan

SR Qualifications Due by Student

List certification by student.

StudentTrainingPlan

SR Qualifications Past Due By Intervention

List of Past Due qualifications by qualification certification type (Requirement, Competency or Intervention).

StudentTrainingPlan

SR Qualifications Past Due by Student

List past due certification by student.

StudentTrainingPlan

SR Qualifications Status By Intervention

List of qualification status by student within qualification certifications.

StudentTrainingPlan

SR Qualification Status By Intervention (Basic1)

To improve report performance for qualification reports using this new query for: List of qualification status by student within qualification certifications.

(Note: Added field UserPhone to query for v4.2.5.)

StudentTrainingPlanBasic1

SR Qualifications Status by Student

List of qualification status by certification within student. Shows students qualification status (MET, NOT MET or EXPIRED) by Interventions, Competencies, and Requirements grouped by Qualifications.

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 Intervention

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 SilkRoad Learning 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 Intervention

List of interventions / 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 Intervention

List of interventions / certifications with student activity for each.

(Note: TEStartDate and TEEndDate have been added for v4.2.5)

StudentTrainingHistory

SR Student History By Intervention (Basic1)

To improve report performance for history reports using this new queries for: List of interventions / certifications with student activity for each

StudentTrainingHistoryBasic1

SR Student Qualifications

 

QualificationByUser

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 (qualifications) 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 SilkRoad Learning 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