iLMS My Reports - Sources, Joins, Fields

Data Sources

To create an adhoc report, you would need to use one or more data sources. A data source represents a particular object or relations among objects and contains various fields to use in a report.

Data sources are categories into two different categories.

1. Master Data Sources:These are the date sources which represents one single object. All such data sources start with the word "Obj_" such as "Obj_Users" represents user object.

2. Relational Data Sources:These are the data sources which represent a relationship between or among data sources.All such data sources start with "_" such as "_CoursesAndUsers" represents the relationship between course and user object so in other words this contains the data of enrolled users for courses.

Here is the list of all the data sources available. Click on the name of a data source to know more about each one.

Master Data Sources

Data Source Name

Description

Obj_Asset

Returns all the Instructor Led Assets of an organization.

Obj_AssetCategory

Returns the entire Instructor Led Asset Categories of an organization.

Obj_Course

Returns all the Courses of an organization.

Obj_CourseVersion

Returns all Course Versions of an organization.

Obj_Curriculum

Returns all the Curriculum of an organization.

Obj_Group

Returns all the Groups of an organization.

Obj_iComposerCourse

Returns all the native iComposer Courses of an organization.

Obj_Location

Returns all the Locations of an organization.

Obj_Room

Returns all the Rooms of an organization.

Obj_SCORMCourse

Returns all the SCORM Courses of an organization.

Obj_Session

Returns all the Sessions of an organization.

Obj_User

Returns all the (active and inactive) Users of an organization.

Relational Data Sources

Report Name

Description

_CourseAndUser

Returns all the User transcripts of an organization.

_CourseExamRecords

Returns all the iComposer Exam Question Analysis of an organization.

_Curriculum_Info

Returns all the Curriculum details of an organization.

_CurriculumAndCourse

Returns all the Course and Curriculum of an organization.

_CurriculumAndUser

Returns all the Curriculum and Users of an organization.

_CurriculumCourseAndUser

Returns all the Curriculum, Course and User transcripts of an organization.

_DuplicateAndBlankEmail_EmployeeIDs

Returns all the duplicate or blank Email ID's or Employee ID's of an organization.

_GroupAndCourse

Returns all the Courses and Groups of an organization.

_GroupAndUser

Returns all the Groups and their user members.

_iComposerChoiceSurveyQuestionAnalysis

Returns all the Survey Choice Question Analysis of an organization.

_iComposerCommentSurveyQuestionAnalysis

Returns all the Survey Comment Question Analysis of an organization.

_iComposerExamFillintheBlankQuestionAnalysis

Returns all the iComposer Exam Fill in the Blank Question Analysis of an organization.

_iComposerExamQuestionAnalysis

Returns all the iComposer Exam Question Analysis of an organization.

_iComposerRatingSurveyQuestionAnalysis

Returns all the Survey Rating Question Analysis of an organization.

_SessionAndAsset

Returns the entire Instructor Led Sessions and Assets of an organization.

_SessionAndInstructor

Returns all the Instructors of an organization.

_SessionAndLocationRoom

Returns all the Locations and Rooms of an organization.

_UnEnrollCourseAndUser

Returns all the unenroll Courses and Users of an organization.

_UserAndExamResponse

Returns all the User and Exam Response of an organization.

_UserTranscript

Returns all the User transcript of an organization.

Data Joins

Incorrect Data Joins will result in poor performance due to a query to your iLMS. There are a plethora of variables that can be chosen when creating reports. The below information provides information on creating valid data joins to correctly use custom reports.

For example, if you would like to use User Profile fields in your report (found in Obj_User), but you would also like to add in transcript data (found in _CourseAndUser), then you can join these data sources with the field "User ID" which exists in both sources. This allows the report to accurately correlate records with one another when reporting.

Many Data sources will populate the correct join automatically, but in the event, this info does not populate correctly, the recommended Data joins to use are listed below for each Object.