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
|