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.
Recommended Data Joins - Master Data Sources
| Object | Field | Join with | Result |
| Obj_Asset | Category: Category ID | Obj_AssetCategory | Asset category's properties name, location name etc. |
Location: Location ID | Obj_Location | Location's properties location name directions, map url etc. | |
| Obj_CourseVersion | Course: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| Obj_Curriculum | Curriculum: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| Obj_iComposerCourse | iComCourse: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| Obj_Room | Room: Location ID | Obj_Location | Location's properties location name directions, map url etc. |
| Obj_SCORMCourse Description | SCOCourse: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| Obj_Session | Session: Parent Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
Recommended Data Joins - Relational Data Source
| Object | Field | Join with | Result |
| _CourseAndUser | Course: Course UID | Obj_Course | Other course's properties such as enrollment type, course credits, course outline etc. |
| Course_Transcript: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. | |
| User: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. | |
| _CourseExamRecords | Course: Course UID | Obj_Course | Other course's properties such as enrollment type, course credits, course outline etc. |
| Course: Session ID | Obj_Session | Other session's properties such as start date, end date, maximum attendence etc. | |
| _Curriculum_Info | User: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. |
| _CurriculumAndCourse | Course: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| Curriculum: Curriculum UID | Obj_Curriculum | Curriculum's properties such as description credits, outline etc. | |
| User: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. | |
| _CurriculumAndUser | Curriculum_Transcript: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| Curriculum_Transcript: Curriculum UID | Obj_Curriculum | Curriculum's properties such as enrollment type, course credits, course outline etc. | |
| _DuplicateAndBlankEmail_ EmployeeIDs | User: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. |
| _GroupAndCourse | Course: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| Group: Group ID | Obj_Group | Group's properties such as name etc. | |
| _GroupAndUser | User: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. |
| _iComposerChoiceSurvey QuestionAnalysis | Survey: Question ID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| _iComposerComment SurveyQuestionAnalysis | intUserId | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| _iComposerExamFillinthe BlankQuestionAnalysis | Course: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| Course: Session ID | Obj_Session | Other session's properties such as start date, end date, maximum attendence etc. | |
| User: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. | |
| _iComposerExam QuestionAnalysis | Course: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| _iComposerRatingSurvey QuestionAnalysis | Survey: Response User ID | Obj_User | Other user's properties such as region, division, department, job title etc. |
| _SessionAndAsset | SessionAndAsset: Asset ID | Obj_Asset | Asset's properties such as asset name, category, description, location etc. |
| _SessionAndInstructor | SessionAndInstructor: Instructor User ID | Obj_User | Other user's properties such as region, division, department, job title etc. |
| _SessionAndLocationRoom | SessionAndLocRoom: Location ID | Obj_Location | Location's properties location name directions, map url etc. |
| SessionAndLocRoom: Room ID | Obj_Room | Room's properties such as room name, max seating capacity location etc. | |
| _UnEnrollCourseAndUser | Course: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| User: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. | |
| _UserAndExamResponse | Course: Course UID | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| User: User ID | Obj_User | Other user's properties such as region, division, department, job title etc. | |
| _UserTranscript | fldUserDefinedCourseId | Obj_Course | Course's properties such as enrollment type, course credits, course outline etc. |
| flduserid | Obj_User | Other user's properties such as region, division, department, job title etc. |
Available Fields - Master Data Sources
Obj_Asset
Description:
Returns all the instructor led assets of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Asset: Allow to Assign | String | Returns Yes or No. Yes - If asset can be assigned. No - If assets cannot be assigned. | No |
| Asset: Asset Description | String | Returns description of assets. | No |
| Asset: Asset ID | Integer Number | ID, assigned by system to uniquely identify an asset. | Yes |
| Asset: Asset Name | String | Returns the name of asset. | No |
| Category: Category ID | Integer Number | ID, assigned by system to uniquely identify a category of asset. | Yes Hint: Join it with "Obj_AssetCategory" to get asset category's properties name, location name etc. |
| Category: Category Name | String | Returns the category name. | No |
| Location: Location ID | Integer Number | ID, assigned by system to uniquely identify a location. | Yes Hint: Join it with "Obj_Location" to get location's properties location name directions, map url etc. |
| Location: Location Name | String | Returns the location name. | No |
Obj_AssetCategory
Description:
Returns all the instructor led asset categories of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Category: Category ID | Integer Number | ID, assigned by system to uniquely identify an asset. | Yes |
| Category: Category Name | String | Returns the category name. | No |
| Location: Location ID | Integer Number | ID, assigned by system to uniquely identify a location. | No |
| Location: Location Name | String | Returns the location name. | No |
Obj_Course
Description:
Returns all the courses of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Code | String | Course code. | No |
| Course: Course Delivery Type | String | Returns Web Based or Instructor Led or Event delivery type of course. | No |
| Course: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes |
| Course: Credits | Integer Number | Credits of course. | No |
| Course: Default Enroll Type | String | Returns Mandatory or Optional enrollment type of course. | No |
| Course: Description | String | Description of course. | No |
| Course: Displayed in Catalog | String | Returns Yes or No. Yes - If course is displayed in catalog. No - If course is not displayed in catalog. | No |
| Course: Duration(Days) | String | Displays duration (Unlimited or number of days) of course. | No |
| Course: Has Exam | String | Returns Yes or No. Yes - If course is having an exam. No - If course is not having an exam. | No |
| Course: Has Pre-Test | String | Returns Yes or No. Yes - If course is having a pre-test. No - If course is not having a pre-test. | No |
| Course: Hours | Integer Number | Hours of course. | No |
| Course: Is Certification Enabled | String | Returns Yes or No. Yes - If certification enabled course. No - If not certification enabled course. | No |
| Course: Is Curriculum | String | Returns Yes or No. Yes - If curriculum. No - If not a curriculum. | No |
| Course: Is Deleted | String | Returns Yes or No. Yes - If course is deleted. No - If course is not deleted. | No |
| Course: Is Event | String | Returns Yes or No. Yes - If event type course. No - If not event type course. | No |
| Course: Is iComposer | String | Returns Yes or No. Yes - If course is native iComposer course. No - If course is other than native iComposer course. | No |
| Course: Is ILT | String | Returns Yes or No. Yes - If course is Instructor Led course. No - If course is other than Instructor Led course. | No |
| Course: Is SCORM | String | Returns Yes or No. Yes - If SCORM course. No - If not SCORM course. | No |
| Course: Licenses | String | Returns the number of course seats. Unlimited in case of unlimited course seats. | No |
| Course: Name | String | Name of course. | No |
| Course: Outline | String | Outline of course. | No |
| Course: Owner Email ID | String | Returns email id of course creator (Author/Instructor/Organization Administrator). | No |
| Course: Owner Employee ID | String | Returns employee id of course creator (Author/Instructor/Organization Administrator). | No |
| Course: Owner Name | String | Returns name of course creator (Author/Instructor/Organization Administrator). | No |
| Course: Owner User ID | Integer Number | Returns ID, of course creator (Author/Instructor/Organization Administrator). | No |
| Course: Pre-Test Percentage | Float | Returns percentage of pre-test for course. | No |
| Course: Publish Status | String | Returns course is published or not published. (Publish or Not Publish) | No |
| Course: Published Date | DateTime | Course published date. | No |
| Course: Resource and Asset Notes | String | Returns the resources and assets notes of Instructor Led or Event course. | No |
| Course: Room Setup Instructions | String | Return the room setup instructions of Instructor Led or Event course. | No |
| Course: SCO Type | String | Returns Single or Multiple SCO type of SCORM course. | No |
| Course: SCORM Version | String | SCORM version of course. | No |
| Course: Search Keywords | String | Search keywords of course. | No |
| Course: Sponsoring Organization | String | Returns sponsoring organization name of Instructor Led or Event course. | No |
| Course: Status | String | Returns Active or Inactive. | No |
| Course: Type | String | Returns SCORM or Native iComposer. | No |
| Course: Used Licenses | Integer Number | Returns the number of course seats consumed. | No |
| Course: Version Type | String | Returns Single or Multiple versions of course. | No |
Obj_CourseVersion
Description:
Returns all course version of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Course ID | Integer Number | ID, assigned by system to uniquely identify a course. | No |
| Course: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| CourseVersion: Version Number | String | Returns version number of course. | No |
Obj_Curriculum
Description:
Returns all the curriculum of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Curriculum: Course Delivery Type | String | Returns Web Based deliver type of curriculum. | No |
| Curriculum: Credits | Integer Number | Credits of curriculum. | No |
| Curriculum: Course UID | String | ID, assigned by system to uniquely identify a curriculum. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| Curriculum: Default Enroll Type | String | Returns Mandatory or Optional enrollment type of curriculum. | No |
| Curriculum: Description | String | Description of curriculum. | No |
| Curriculum: Displayed in Catalog | String | Returns Yes or No. Yes - If curriculum displayed in catalog. No - If curriculum not displayed in catalog. | No |
| Curriculum: Duration(Days) | String | Displays duration (Unlimited or number of days) of curriculum. | No |
| Curriculum: Has Exam | String | Returns Yes or No. Yes - If curriculum is having an exam. No - If curriculum is not having an exam. | No |
| Curriculum: Has Pre-Test | String | Returns Yes or No. Yes - If curriculum is having a pre-test. No - If curriculum is not having a pre-test. | No |
| Curriculum: Hours | Integer Number | Hours of curriculum. | No |
| Curriculum: Is Deleted | String | Returns Yes or No. Yes - If curriculum is deleted. No - If curriculum is not deleted. | No |
| Curriculum: Name | String | Name of curriculum. | No |
| Curriculum: Outline | String | Outline of curriculum. | No |
| Curriculum: Owner Email ID | String | Returns email id of curriculum creator (Author/Instructor/Organization Administrator). | No |
| Curriculum: Owner Employee ID | String | Returns employee id of curriculum creator (Author/Instructor/Organization Administrator). | No |
| Curriculum: Owner Name | String | Returns name of curriculum creator (Author/Instructor/Organization Administrator). | No |
| Curriculum: Owner User ID | Integer Number | Returns ID, of curriculum creator (Author/Instructor/Organization Administrator). | No |
| Curriculum: Search Keywords | String | Search keywords of curriculum. | No |
| Curriculum: Status | String | Returns Active or Inactive. | No |
Obj_Group
Description:
Returns all the groups of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Group: Group ID | Integer Number | ID, assigned by system to uniquely identify a groups. | Yes |
| Group: Name | String | Returns the name of group. | No |
Obj_iComposerCourse
Description:
Returns all the native iComposer courses of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| iComCourse: Certification After User Field | String | Returns the recertification rule for native iComposer course. | No |
| iComCourse: Certification Period | String | Returns the certification period. | No |
| iComCourse: Code | String | Code of native iComposer course. | No |
| iComCourse: Course Delivery Type | String | Returns Web Based or Instructor Led or Event deliver type of native iComposer course. | No |
| iComCourse: Course UID | String | ID, assigned by system to uniquely identify a native iComposer course. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| iComCourse: Credits | Integer Number | Credits of native iComposer course. | No |
| iComCourse: Default Enroll Type | String | Returns Mandatory or Optional enrollment type of native iComposer course. | No |
| iComCourse: Description | String | Description of native iComposer course. | No |
| iComCourse: Displayed in Catalog | String | Returns Yes or No. Yes - If native iComposer course is displayed in catalog. No - If native iComposer course is not displayed in catalog. | No |
| iComCourse: Duration(Days) | String | Displays duration (Unlimited or number of days) of native iComposer course. | No |
| iComCourse: Grace Period | String | Grace period to complete the certification of native iComposer course. | No |
| iComCourse: Has Exam | String | Returns Yes or No. Yes - If native iComposer course is having an exam. No - If native iComposer course is not having an exam. | No |
| iComCourse: Has Pre-Test | String | Returns Yes or No. Yes - If native iComposer course is having a pre-test. No - If native iComposer course is not having a pre-test. | No |
| iComCourse: Hours | Integer Number | Hours of native iComposer course. | No |
| iComCourse: Is Certification Enabled | String | Returns Yes or No. Yes - If certification enabled native iComposer course. No - If not certification enabled native iComposer course. | No |
| iComCourse: Is Deleted | String | Returns Yes or No. Yes - If native iComposer course is deleted. No - If native iComposer course is not deleted. | No |
| iComCourse: Is Grace Period Enabled | String | Returns Yes or No. Yes - If grace period is enabled. No - If grace period is not enabled. | No |
| iComCourse: Licenses | String | Returns the number of course seats. Unlimited in case of unlimited course seats. | No |
| iComCourse: Name | String | Name of native iComposer course. | No |
| iComCourse: Outline | String | Outline of native iComposer course. | No |
| iComCourse: Pre-Test Percentage | Float | Returns percentage of pre-test for native iComposer course. | No |
| iComCourse: Publish Status | String | Returns native iComposer course is published or not published. (Publish or Not Publish) | No |
| iComCourse: Published Date | DateTime | Course published date. | No |
| iComCourse: Search Keywords | String | Search keywords of native iComposer course. | No |
| iComCourse: Status | String | Returns Active or Inactive. | No |
| iComCourse: Type | String | Returns SCORM or Native iComposer. | No |
| iComCourse: Used Licenses | Integer Number | Returns the number of course seats consumed. | No |
| iComCourse: Version Type | String | Returns Single or Multiple version of native iComposer course. | No |
Obj_Location
Description:
Returns all location of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Location: Address1 | String | Address 1 of location. | No |
| Location: Address2 | String | Address 2 of location. | No |
| Location: BuildingName | String | Building name of location. | No |
| Location: City | String | City name of location. | No |
| Location: Country | String | Country name of location. | No |
| Location: Directions | String | Directions to reach location. | No |
| Location: Location ID | Integer Number | ID, assigned by system to uniquely identify a location. | Yes |
| Location: Location Name | String | Name of location. | No |
| Location: MapURL | String | Map URL of location. | No |
| Location: Notes | String | Notes about location. | No |
| Location: Other State | String | Other state name of location. | No |
| Location: State | String | State name of location. | No |
| Location: Zip Code | String | Zip code of location's area. | No |
Obj_Room
Description:
Returns all rooms of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Room: Location ID | Integer Number | ID, assigned by system to uniquely identify a location. | Yes Hint: Join it with "Obj_Location" to get location's properties location name directions, map url etc. |
| Room: Max Seating Capacity | String | Maximum Seating Capacity of room. | No |
| Room: Room Description | String | Description of room. | No |
| Room: Room ID | Integer Number | ID, assigned by system to uniquely identify a room. | Yes |
| Room: Room Name | String | Name of room. | No |
Obj_SCORMCourse
Description:
Returns all the SCORM courses of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| SCOCourse: Code | String | Code of SCORM course. | No |
| SCOCourse: Course Delivery Type | String | Returns Web Based or Instructor Led or Event deliver type of SCORM course. | No |
| SCOCourse: Course UID | String | ID, assigned by system to uniquely identify a SCORM course. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| SCOCourse: Credits | Integer Number | Credits of SCORM course. | No |
| SCOCourse: Default Enroll Type | String | Returns Mandatory or Optional enrollment type of SCORM course. | No |
| SCOCourse: Description | String | Description of SCORM course. | No |
| SCOCourse: Displayed in Catalog | String | Returns Yes or No. Yes - If SCORM course is displayed in catalog. No - If SCORM course is not displayed in catalog. | No |
| SCOCourse: Duration(Days) | String | Displays duration (Unlimited or number of days) of SCORM course. | No |
| SCOCourse: Enrollment Type | String | Returns the course enrollment type. (Closed, Open or Open with Ecommerce) | No |
| SCOCourse: Hours | Integer Number | Hours of SCORM course. | No |
| SCOCourse: Is Deleted | String | Returns Yes or No. Yes - If SCORM course is deleted. No - If SCORM course is not deleted. | No |
| SCOCourse: Licenses | String | Returns the number of SCORM course seats. Unlimited in case of unlimited course seats. | No |
| SCOCourse: Name | String | Name of SCORM course. | No |
| SCOCourse: Outline | String | Outline of SCORM course. | No |
| SCOCourse: Publish Status | String | Returns SCORM course is published or not published. (Publish or Not Publish) | No |
| SCOCourse: Published Date | DateTime | Course published date. | No |
| SCOCourse: SCO Type | String | Returns Single or Multiple SCO type of SCORM course. | No |
| SCOCourse: SCORM Version | String | SCORM version of SCORM course. | No |
| SCOCourse: Search Keywords | String | Search keywords of SCORM course. | No |
| SCOCourse: Status | String | Returns Active or Inactive. | No |
| SCOCourse: Type | String | Returns SCORM or Native iComposer. | No |
| SCOCourse: Used Licenses | Integer Number | Returns the number of SCORM course seats consumed. | No |
| SCOCourse: Version Type | String | Returns Single or Multiple version of SCORM course. | No |
Obj_Session
Description:
Returns all the sessions of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Name | String | Returns the name of Instructor Led course or Event name. | No |
| Session: Asset(s) | String | Returns the assets associated with session. | No |
| Session: Course Code | String | Instructor Led course or Event code. | No |
| Session: Credits | Integer Number | Credits of course. | No |
| Session: Days before Automatically Cancel Session | Integer Number | Returns number of days before system can cancel the session if minimum seats are not filled. | No |
| Session: Days before Close Enrollment | Integer Number | Returns the number of days before session enrollment can be closed. | No |
| Session: Days before User Cancel Enrollment | Integer Number | Returns the number of days before user can cancel the session. | No |
| Session: Default Enroll Type | String | Returns Mandatory or Optional enrollment type of Instructor Led course or Event. | No |
| Session: Description | String | Description of Instructor Led course or Event. | No |
| Session: Displayed in Catalog | String | Returns Yes or No. Yes - If Instructor Led course or Event is displayed in catalog. No - If Instructor Led course or Event is not displayed in catalog. | No |
| Session: Duration(Days) | String | Displays duration (Unlimited or number of days) of Instructor Led course or Event. | No |
| Session: End Date | DateTime | Returns the end date of session. | Yes |
| Session: Enrolled User Count | Integer Number | Returns total users enrolled in session. | No |
| Session: Enrollment | String | Returns current enrollment of session. | No |
| Session: Enrollment Type | String | Returns enrollment type (Closed, Open or Open With Ecommerece) of session. | No |
| Session: Has Exam | String | Returns Yes or No. Yes - If Instructor Led course or Event is having an exam. No - If Instructor Led course or Event is not having an exam. | No |
| Session: Hours | Integer Number | Hours of course. | No |
| Session: Instructor(s) Name | String | Returns the instructor(s) name of session. | No |
| Session: Is Close Enrollment Policy Enable | String | Returns Yes or No. Yes - If automatic session close before N days enabled for session. No - If automatic session close before N days disabled for session. | No |
| Session: Is Deleted | String | Returns Yes or No. Yes - If course is deleted. No - If course is not deleted. | No |
| Session: Is User Cancelation Enable | String | Returns Yes or No. Yes - If user can cancel the session. No - If user cannot cancel the session. | No |
| Session: Is Wait List Enable | String | Returns Yes or No. Yes - If wait is enabled for session. No - If wait is not enabled for session. | No |
| Session: Location Name | String | Returns the location name of session. | No |
| Session: Lock Course/Event | String | Returns Yes or No. Yes - If course content is locked. No - If course content are not locked. | No |
| Session: Maximum Attendance | String | Returns the maximum attendance for session. | No |
| Session: Minimum Attendance | Integer Number | Returns the minimum attendance for session. | No |
| Session: Notes | String | Returns the notes of session. | No |
| Session: Outline | String | Outline of Instructor Led course Or Event. | No |
| Session: Parent Course UID | String | ID, assigned by system to uniquely identify a Instructor Led course or Event. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| Session: Refund Amount | Decimal | Returns the refund amount of session. | No |
| Session: Room Name | String | Returns the room name of session. | No |
| Session: Search Keywords | String | Search keywords of course. | No |
| Session: Session ID | String | ID, assigned by system to uniquely identify a session. | Yes |
| Session: Session Type | String | Returns the type of session. (Instructor Led or Event) | No |
| Session: Start Date | DateTime | Returns start date of session. | No |
| Session: Status | String | Returns Active or Inactive. | No |
| Session: Type | String | Returns Native iComposer. | No |
Obj_User
Description:
Returns all the (active and inactive) users of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| User: Address1 | String | Address 1 of user. | No |
| User: Address2 | String | Address 2 of user. | No |
| User: Author Privilege | String | Returns Yes or No. Yes - If user is having author privilege. No - If user doesn't have author privilege. | No |
| User: City | String | City name of user. | No |
| User: Company/Employer | String | Company/Employer name of user. | No |
| User: Country | String | Country name of user. | No |
| User: Custom Field 1 | String | Custom field 1 value of user. | No |
| User: Custom Field 2 | String | Custom field 2 value of user. | No |
| User: Custom Field 3 | String | Custom field 3 value of user. | No |
| User: Custom Field 4 | String | Custom field 4 value of user. | No |
| User: Department | String | Department name of user. | No |
| User: Division | String | Division name of user. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: Fax | String | Fax number of user. | No |
| User: First Name | String | First name of user. | No |
| User: Hire Date | DateTime | Hire date of user. | No |
| User: Instructor Privilege | String | Returns Yes or No. Yes - If user is having instructor privilege. No - If user doesn't have instructor privilege. | No |
| User: Job Title | String | Job title of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: Middle Name | String | Middle name of user. | No |
| User: Organization Name | String | Name of the organization where user's account exists. | No |
| User: Other State | String | Other state name of user. | No |
| User: Password Admin Privilege | String | Returns Yes or No. Yes - If user is having password admin privilege. No - If user doesn't have password admin privilege. | No |
| User: Phone | String | Phone number of user. | No |
| User: Realm Administrator Privilege | String | Returns Yes or No. Yes - If user is having realm admin privilege. No - If user doesn't have realm admin privilege. | No |
| User: Region | String | Region name of user. | No |
| User: Registration Date | DateTime | The date on which user's account is created in the system. | No |
| User: Special Booking Instructions | String | Any specific booking instructions when user is instructor. | No |
| User: State | String | State name of user. | No |
| User: Status | String | Returns Active or Inactive. | No |
| User: Supervisor Email | String | Email ID of user's supervisor. | No |
| User: Supervisor Name | String | Name of user's supervisor. | No |
| User: TimeZone | String | Time zone of user's area. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes |
| User: Zip Code | String | Zip code of user's area. | No |
Available Fields - Relational Data Sources
_CourseAndUser
Description:
Returns all the user transcript of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Is Curriculum | String | Returns Yes or No. Yes - If curriculum. No - If not a curriculum. | No |
| Course: Name | String | Name of course. | No |
| Course_Transcript: Certificate Number | String | Course completion certificate number. | No |
| Course_Transcript: Certification Expiration Date | DateTime | Returns the course certification expiration date if course is certification enabled course. | No |
| Course_Transcript: Certification Status | String | Returns the course certification status if course is certification enabled course. | No |
| Course_Transcript: Completion Date | DateTime | Returns course completion date. | No |
| Course_Transcript: Course ID | Integer Number | ID, assigned by system to uniquely identify a course. | No |
| Course: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get other course's properties such as enrollment type, course credits, course outline etc. |
| Course_Transcript: Due Date | DateTime | Due date of course. | No |
| Course_Transcript: Earned Credits | Decimal | Credits earned by completing course. | No |
| Course_Transcript: Earned Hours | Integer Number | Hours earned by completing course. | No |
| Course_Transcript: Enroll Date | DateTime | Returns enrollment date of course. | No |
| Course_Transcript: Enroll Type | String | Returns Mandatory or Optional enrollment type of course. | No |
| Course_Transcript: Enrollment Path | String | Returns how the course is enrolled. (Via Curriculum, Group, Or Direct) | No |
| Course_Transcript: Exam Retries | Integer Number | Returns number of exam attempted by user. | No |
| Course_Transcript: License Expiration Date | DateTime | Returns the course license expiration date. | No |
| Course_Transcript: Past Due | String | Returns Yes or No. Yes - If course due date is past date. No - If course due date is future date. | No |
| Course_Transcript: Percentage | Decimal | Exam Percentage user got. | No |
| Course_Transcript: Pre-Test Percentage | String | Pre-Test Percentage user got. | No |
| Course_Transcript: Session ID | Integer Number | ID, assigned by system to uniquely identify a session. | No |
| Course_Transcript: Start Date | DateTime | Course start date. | No |
| Course_Transcript: Status | String | Returns course status (Not Started, Inprogress, Pass, Failed, Waived). | No |
| Course_Transcript: Time Spent | String | Total time spent to complete the course. | No |
| Course_Transcript: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
| Course_Transcript: Version Number | Decimal | Version of course. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: First Name | String | First name of user. | No |
| User: Hire Date | DateTime | Hire date of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: Status | String | Returns Active or Inactive. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
_CourseExamRecords
Description:
Returns all the iComposer Exam Question Analysis of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Course ID | Integer Number | ID, assigned by system to uniquely identify a iComposer course. | No |
| Course: Course UID | String | ID, assigned by system to uniquely identify a iComposer course. | Yes Hint: Join it with "Obj_Course" to get other course's properties such as enrollment type, course credits, course outline etc. |
| Course: Name | String | Name of course. | No |
| Course: Session ID | Integer Number | ID, assigned by system to uniquely identify a session. | Yes Hint: Join it with "Obj_Session" to get other session's properties such as start date, end date, maximum attendence etc. |
| Exam: Correct | Integer Number | Returns the number of users answer correctly. | No |
| Exam: Gauge of % Correct | Decimal | Returns the gauge of % of users answer correctly. | No |
| Exam: Gauge of % InCorrect | Decimal | Returns the gauge of % of users answer incorrectly. | No |
| Exam: Incorrect | Integer Number | Returns the number of users answer incorrectly. | No |
| Exam: Percentage Correct | String | Returns percentile of number of users answer correctly. | No |
| Exam: Percentage InCorrect | String | Returns percentile of number of users answer incorrectly. | No |
| Exam: Question ID | String | ID, assigned by system to uniquely identify a iComposer course exam question. | No |
| Exam: QuestionText | String | Returns the exam question. | No |
| Exam: Total | Integer Number | Returns number of users the exam is attempted. | No |
_Curriculum_Info
Description:
Returns all the Curriculum details of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Code | String | Course code. | No |
| Course: Credits | Integer Number | Credits of course. | No |
| Course: Default Enroll Type | String | Returns Mandatory or Optional enrollment type of course. | No |
| Course: Delivery Type | String | Returns Web Based or Instructor Led or Event deliver type of course. | No |
| Course: Hours | Integer Number | Hours of course. | No |
| Course: Is Curriculum | String | Returns Yes or No. Yes - If curriculum. No - If not a curriculum. | No |
| Course: Name | String | Name of course. | No |
| Course: Type | String | Returns SCORM or Native iComposer. | No |
| Course_Transcript: Completion Date | DateTime | Returns curriculum/course completion date. | No |
| Course_Transcript: Due Date | DateTime | Due date of curriculum/course. | No |
| Course_Transcript: Earned Certificate | String | Earned certificate of curriculum/course. | No |
| Course_Transcript: Enroll Date | DateTime | Returns enrollment date of curriculum/course. | No |
| Course_Transcript: Enroll Type | String | Returns Mandatory or Optional enrollment type of curriculum/course. | No |
| Course_Transcript: Exam Retries | Integer Number | Returns number of exam attempted by user. | No |
| Course_Transcript: Past Due | String | Returns Yes or No. Yes - If course due date is past date. No - If course due date is future date. | No |
| Course_Transcript: Percentage | Decimal | Exam Percentage user got. | No |
| Course_Transcript: Pre-Test Percentage | Decimal | Returns percentage of pre-test for course.. | No |
| Course_Transcript: Start Date | DateTime | Curriculum/course start date. | No |
| Course_Transcript: Status | String | Returns curriculum/course status (Not Started, Inprogress, Pass, Failed, Waived). | No |
| Curricula: Name | String | Name of Curricula. | No |
| Curricula: Status | String | Returns Active or Inactive. | No |
| Curriculum: IsParent | String | Returns Yes or No. Yes - If course is parent course. No - If course is not parent course. | No |
| User: Address1 | String | Address 1 of user. | No |
| User: Address2 | String | Address 2 of user. | No |
| User: Author Privilege | String | Returns Yes or No. Yes - If user is having author privilege. No - If user doesn't have author privilege. | No |
| User: City | String | City name of user. | No |
| User: Country | String | Country name of user. | No |
| User: Department | String | Department name of user. | No |
| User: Division | String | Division name of user. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: Fax | String | Fax number of user. | No |
| User: First Name | String | First name of user. | No |
| User: Job Title | String | Job title of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: Middle Name | String | Middle name of user. | No |
| User: Other State | String | Other state name of user. | No |
| User: Phone | String | Phone number of user. | No |
| User: Realm Administrator Privilege | String | Returns Yes or No. Yes - If user is having realm admin privilege. No - If user doesn't have realm admin privilege. | No |
| User: Region | String | Region name of user. | No |
| User: State | String | State name of user. | No |
| User: Status | String | Returns Active or Inactive. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
| User: Zip Code | String | Zip code of user's area. | No |
_CurriculumAndCourse
Description:
Returns all the course and curriculum of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| Course: Credits | Integer Number | Credits of course. | No |
| Course: Default Enroll Type | String | Returns Mandatory or Optional enrollment type of course. | No |
| Course: Hours | Integer Number | Hours of course. | No |
| Course: Is Curriculum | String | Returns Yes or No. Yes - If curriculum. No - If not a curriculum. | No |
| Course: Name | String | Name of course. | No |
| Curriculum: Curriculum UID | String | ID, assigned by system to uniquely identify a curriculum. | Yes Hint: Join it with "Obj_Curriculum" to get curriculum's properties such as description credits, outline etc. |
| Curriculum: Name | String | Name of curriculum. | No |
_CurriculumAndUser
Description:
Returns all the curriculum and users of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Curriculum: Curriculum UID | String | ID, assigned by system to uniquely identify a curriculum. | Yes Hint: Join it with "Obj_Curriculum" to get curriculum's properties such as description, course credits, course outline etc. |
| Curriculum: Name | String | Name of curriculum. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: First Name | String | First name of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: Status | String | Returns Active or Inactive. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
_CurriculumCourseAndUser
Description:
Returns all the Curriculum, Course, User Transcript of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Name | String | Name of course. | No |
| Curriculum_Transcipt: Enrollment Path | String | Returns how the curriculum/course is enrolled. (Via Curriculum, Group, Or Direct) | No |
| Curriculum_Transcript: Certificate Number | String | Course completion certificate number. | No |
| Curriculum_Transcript: Completion Date | DateTime | Returns curriculum/course completion date. | No |
| Curriculum_Transcript: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| Curriculum_Transcript: Curriculum Name | String | Name of curriculum. | No |
| Curriculum_Transcript: Curriculum UID | String | ID, assigned by system to uniquely identify a curriculum. | Yes Hint: Join it with "Obj_Curriculum" to get curriculum's properties such as enrollment type, course credits, course outline etc. |
| Curriculum_Transcript: Due Date | DateTime | Due date of curriculum/course. | No |
| Curriculum_Transcript: Earned Certificate | String | Earned certificate of curriculum/course. | No |
| Curriculum_Transcript: Earned Credits | Decimal | Credits earned by completing curriculum/course. | No |
| Curriculum_Transcript: Earned Hours | Integer Number | Hours earned by completing curriculum/course. | No |
| Curriculum_Transcript: Enroll Date | DateTime | Returns enrollment date of curriculum/course. | No |
| Curriculum_Transcript: Enroll Type | String | Returns Mandatory or Optional enrollment type of curriculum/course. | No |
| Curriculum_Transcript: Exam Retries | Integer Number | Returns number of exam attempted by user. | No |
| Curriculum_Transcript: Is Parent | String | Returns Yes or No. Yes - If course is parent course. No - If course is not parent course. | No |
| Curriculum_Transcript: License Expiration Date | DateTime | Returns the curriculum/course license expiration date. | No |
| Curriculum_Transcript: Past Due | String | Returns Yes or No. Yes - If course due date is past date. No - If course due date is future date. | No |
| Curriculum_Transcript: Percentage | Decimal | Exam Percentage user got. | No |
| Curriculum_Transcript: Start Date | DateTime | Curriculum/course start date. | No |
| Curriculum_Transcript: Status | String | Returns curriculum/course status (Not Started, Inprogress, Pass, Failed, Waived). | No |
| Curriculum_Transcript: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: First Name | String | First name of user. | No |
| User: Hire Date | DateTime | Hire date of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: Status | String | Returns Active or Inactive. | No |
_DuplicateAndBlankEmail_EmployeeIDs
Description:
Returns all duplicate or blank Email ID or Employee ID of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Filter: Field | String | Returns the field Email ID or Employee ID. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
_GroupAndCourse
Description:
Returns all the course and group of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| Course: Name | String | Name of course. | No |
| Group: Group ID | String | ID, assigned by system to uniquely identify a group. | Yes Hint: Join it with "Obj_Group" to get group's properties such as name etc. |
| Group: Name | String | Name of group. | No |
_GroupAndUser
Description:
Returns all the groups and their user members. You can "group by" the result by "Group: Name" field to get the users list group wise.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Group: Group ID | Integer Number | ID, assigned by system to uniquely identify a group. | No |
| Group: Name | String | Name of group. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: First Name | String | First name of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes. Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
_iComposerChoiceSurveyQuestionAnalysis
Description:
Returns all the Survey Choice Question Analysis of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Name | String | Name of course. | No |
| Survey: Gauge of Percent Selected | Decimal | Returns the gauge of % of users selection. | No |
| Survey: Option Text | String | Returns the option text. | No |
| Survey: Percentage Selected | String | Returns percentile of number of users selected specific option. | No |
| Survey: Question ID | String | ID, assigned by system to uniquely identify a question. | Yes Hint: Join it with "Obj_Course" to get other course's properties such as enrollment type, course credits, course outline etc. |
| Survey: Question Text | String | Returns the question text. | No |
| Survey: Question Type | String | Returns the question type. | No |
| Survey: Times Selected | Integer Number | Returns number of times users selected the option. | No |
_iComposerCommentSurveyQuestionAnalysis
Description:
Returns all the Survey Comment Question Analysis of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Name | String | Name of course. | No |
| intUserId | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_Course" to get other course's properties such as enrollment type, course credits, course outline etc. |
| Question: Comment Answer | String | Returns the comment answer. | No |
| Survey: Question | String | Returns the question text. | No |
| Survey: Question ID | String | ID, assigned by system to uniquely identify a question. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: First name | String | First name of user. | No |
| User: Last name | String | Last name of user. | No |
_iComposerExamFillintheBlankQuestionAnalysis
Description:
Returns all the iComposer Exam Fill in the Blank Question Analysis of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Course ID | Integer Number | ID, assigned by system to uniquely identify a iComposer course. | No |
| Course: Course UID | String | ID, assigned by system to uniquely identify a iComposer course. | Yes Hint: Join it with "Obj_Course" to get other course's properties such as enrollment type, course credits, course outline etc. |
| Course: Name | String | Name of course. | No |
| Course: Session ID | Integer Number | ID, assigned by system to uniquely identify a session. | Yes Hint: Join it with "Obj_Session" to get other session's properties such as start date, end date, maximum attendence etc. |
| Exam: Question | String | Returns the fill in the blanks question. | No |
| Exam: Question ID | String | ID, assigned by system to uniquely identify a iComposer course exam question. | No |
| Exam: User Attempt | Integer Number | Returns number of users the question is attempted. | No |
| Question: Correct Answer | String | Returns the correct answer of question. | No |
| Question: Iscorrect | String | Returns Yes or No. Yes - If question is correct. No - If question is incorrect. | No |
| Question: Percentage Correct | String | Returns percentage of users answer the question correctly. | No |
| Question: Percentage Incorrect | String | Returns percentage of users answer the question incorrectly. | No |
| Question: Total Response | String | Returns number of users responded to question. | No |
| Question: User Answer | String | Returns the user answer of question. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: First Name | String | First name of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
_iComposerExamQuestionAnalysis
Description:
Returns all the iComposer Exam Question Analysis of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Course ID | Integer Number | ID, assigned by system to uniquely identify a course. | No |
| Course: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get other course's properties such as enrollment type, course credits, course outline etc. |
| Course: Name | String | Name of course. | No |
| Exam: Question | String | Returns the question text. | No |
| Exam: Question ID | String | ID, assigned by system to uniquely identify a exam question. | No |
| Exam: Question Result | String | Returns Yes or No. Yes - If correct/true. No - If incorrect/false. | No |
| Exam: Question Type | String | Returns the question type. | No |
| Gauge of Response | String | Returns gauge of response. | No |
| Percent Selected | String | Returns percentage of users selects the option | No |
| Quesiton: Options | String | Returns options. | No |
| Quesiton: Total Attempts | Integer Number | Returns number of users attempted. | No |
| Quesiton: Total Response | Integer Number | Returns number of users responded. | No |
_iComposerRatingSurveyQuestionAnalysis
Description:
Returns all the Survey Rating Question Analysis of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Name | String | Name of course. | No |
| Question: Rating | String | Rating of question. | No |
| Question: RowChoice | String | Returns the chosen rating text. | No |
| Survey: Option ID | Integer Number | ID, assigned by system to uniquely identify a option. | No |
| Survey: Question | String | Returns the question text. | No |
| Survey: Question ID | Integer Number | ID, assigned by system to uniquely identify a question. | No |
| Survey: Rating ID | Integer Number | ID, assigned by system to uniquely identify a rating. | No |
| Survey: Rating Weight | Integer Number | Weight given to rating. | No |
| Survey: Response ID | Integer Number | ID, assigned by system to uniquely identify a response. | No |
| Survey: Response User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
| Survey: User Rating | Integer Number | Returns the users rating. | No |
| Survey: User Rating Text | String | Returns the user rating text. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: First Name | String | First name of user. | No |
| User: Last Name | String | Last name of user. | No |
_SessionAndAsset
Description:
Returns all the instructor led sessions and assets of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Asset: Asset Name | String | Returns the name of asset. | No |
| SessionAndAsset: Asset ID | Integer Number | ID, assigned by system to uniquely identify a asset. | Yes Hint: Join it with "Obj_Asset" to get asset's properties such as asset name, category, description, location etc. |
| SessionAndAsset: Session ID | Integer Number | ID, assigned by system to uniquely identify a session. | No |
_SessionAndInstructor
Description:
Returns all the instructors of an organization.
Available Fields:
Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
Instructor: Email | String | Email ID of instructor. | No |
Instructor: Employee ID | String | Employee ID of instructor. | No |
Instructor: First Name | String | First Name of instructor. | No |
Instructor: Last Name | String | Last Name of instructor. | No |
SessionAndInstructor: Instructor User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
SessionAndInstructor: Session ID | Integer Number | Returns the session id. | No |
_SessionAndLocationRoom
Description:
Returns all the location, rooms of an organization.
Available Fields:
Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
Location: Location Name | String | Returns the name of location. | No |
Room: Room Name | String | Returns the name of room. | No |
SessionAndLocRoom: Location ID | Integer Number | ID, assigned by system to uniquely identify a location. | Yes Hint: Join it with "Obj_Location" to get location's properties such as address, city, direction, map URL etc. |
SessionAndLocRoom: Room ID | Integer Number | ID, assigned by system to uniquely identify a room. | Yes Hint: Join it with "Obj_Room" to get room's properties such as room name, max seating capacity location etc. |
SessionAndLocRoom: Session ID | Integer Number | ID, assigned by system to uniquely identify a sessions. | No |
_UnEnrollCourseAndUser
Description:
Returns all the un-enroll course user of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Code | String | Course code. | No |
| Course: Course Delivery Type | String | Returns Web Based or Instructor Led or Event delivery type of course. | No |
| Course: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get course's properties such as enrollment type, course credits, course outline etc. |
| Course: Credits | Integer Number | Credits of course. | No |
| Course: Default Enroll Type | String | Returns Mandatory or Optional enrollment type of course. | No |
| Course: Description | String | Description of course. | No |
| Course: Displayed in Catalog | String | Returns Yes or No. Yes - If course is displayed in catalog. No - If course is not displayed in catalog. | No |
| Course: Duration(Days) | String | Displays duration (Unlimited or number of days) of course. | No |
| Course: Has Exam | String | Returns Yes or No. Yes - If course is having an exam. No - If course is not having an exam. | No |
| Course: Has Pre-Test | String | Returns Yes or No. Yes - If course is having an pre-test. No - If course is not having an pre-test. | No |
| Course: Hours | Integer Number | Hours of course. | No |
| Course: Is Certification Enabled | String | Returns Yes or No. Yes - If certification enabled course. No - If not certification enabled course. | No |
| Course: Is Curriculum | String | Returns Yes or No. Yes - If curriculum. No - If not a curriculum. | No |
| Course: Is Deleted | String | Returns Yes or No. Yes - If course is deleted. No - If course is not deleted. | No |
| Course: Is Event | String | Returns Yes or No. Yes - If event type course. No - If not event type course. | No |
| Course: Is iComposer | String | Returns Yes or No. Yes - If course is native iComposer course. No - If course is other than native iComposer course. | No |
| Course: Is ILT | String | Returns Yes or No. Yes - If course is instructor led course. No - If course is other than instructor led course. | No |
| Course: Is SCORM | String | Returns Yes or No. Yes - If SCORM course. No - If not SCORM course. | No |
| Course: Licenses | String | Returns the number of course seats. Unlimited in case of unlimited course seats. | No |
| Course: Name | String | Name of course. | No |
| Course: Outline | String | Outline of course. | No |
| Course: Owner Email ID | String | Returns email id of course creator (Author/Instructor/Organization Administrator). | No |
| Course: Owner Employee ID | String | Returns employee id of course creator (Author/Instructor/Organization Administrator). | No |
| Course: Owner Name | String | Returns name of course creator (Author/Instructor/Organization Administrator). | No |
| Course: Owner User ID | Integer Number | Returns ID, of course creator (Author/Instructor/Organization Administrator). | No |
| Course: Pre-Test Percentage | Float | Returns percentage of pre-test for course. | No |
| Course: Publish Status | String | Returns course is published or not published. (Publish or Not Publish) | No |
| Course: Published Date | DateTime | Course published date. | No |
| Course: SCO Type | String | Returns Single or Multiple SCO type of SCORM course. | No |
| Course: SCORM Version | String | SCORM version of course. | No |
| Course: Search Keywords | String | Search keywords of course. | No |
| Course: Status | String | Returns Active or Inactive. | No |
| Course: Type | String | Returns SCORM or Native iComposer. | No |
| Course: Used Licenses | Integer Number | Returns the number of course seats consumed. | No |
| Course: Version Type | String | Returns Single or Multiple version of course. | No |
| User: Address1 | String | Address 1 of user. | No |
| User: Address2 | String | Address 2 of user. | No |
| User: Author Privilege | String | Returns Yes or No. Yes - If user is having author privilege. No - If user doesn't have author privilege. | No |
| User: City | String | City name of user. | No |
| User: Company/Employer | String | Company/Employer name of user. | No |
| User: Country | String | Country name of user. | No |
| User: Department | String | Department name of user. | No |
| User: Division | String | Division name of user. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: Fax | String | Fax number of user. | No |
| User: First Name | String | First name of user. | No |
| User: Hire Date | DateTime | Hire date of user. | No |
| User: Instructor Privilege | String | Returns Yes or No. Yes - If user is having instructor privilege. No - If user doesn't have instructor privilege. | No |
| User: Job Title | String | Job title of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: Middle Name | String | Middle name of user. | No |
| User: Organization Name | String | Name of the organization where user's account exists. | No |
| User: Other State | String | Other sate name of user. | No |
| User: Password Admin Privilege | String | Returns Yes or No. Yes - If user is having password admin privilege. No - If user doesn't have password admin privilege. | No |
| User: Phone | String | Phone number of user. | No |
| User: Realm Administrator Privilege | String | Returns Yes or No. Yes - If user is having realm admin privilege. No - If user doesn't have realm admin privilege. | No |
| User: Region | String | Region name of user. | No |
| User: Registration Date | DateTime | The date on which user's account is created in the system. | No |
| User: Special Booking Instructions | String | Any specific booking instructions when user is instructor. | No |
| User: State | String | State name of user. | No |
| User: Status | String | Returns Active or Inactive. | No |
| User: TimeZone | String | Time zone of user's area. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
| User: Zip Code | String | Zip code of user's area. | No |
_UserAndExamResponse
Description:
Returns all the User and Exam Response of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Course ID | Integer Number | ID, assigned by system to uniquely identify a course. | No |
| Course: Course UID | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get other course's properties such as enrollment type, course credits, course outline etc. |
| Course: Name | String | Name of course. | No |
| Course: Session ID | Integer Number | ID, assigned by system to uniquely identify a session. | No |
| Course_Transcript: Default Percentage | Integer Number | Returns the default percentage. | No |
| Course_Transcript: Percentage | String | Returns the percentile. | No |
| Course_Transcript: Status | String | Returns active/inactive course status. | No |
| Exam: Correct Answer | String | Correct answer of question. | No |
| Exam: Question | String | Returns the question text. | No |
| Exam: Question ID | String | ID, assigned by system to uniquely identify a exam question. | No |
| Exam: Question Result | String | Returns the correct/incorrect result. | No |
| Exam: Question Type | String | Returns the question type. | No |
| Exam: User Answer | String | Returns user's answer. | No |
| Exam: User Attempt | Integer Number | Returns number of attempt made by user. | No |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | Integer Number | Employee ID of user. | No |
| User: Status | Integer Number | Returns Active or Inactive. | No |
| User: User ID | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
_UserTranscript
Description:
Returns all the user transcript of an organization.
Available Fields:
| Field Name | Data Type | Description | Can be used to JOIN with other data source? |
|---|---|---|---|
| Course: Name | String | Name of course. | No |
| Course_Transcript: Certification Status | String | Returns the course certification status if course is certification enabled course. | No |
| Course_Transcript: Completion Date | DateTime | Returns course completion date. | No |
| Course_Transcript: Due Date | DateTime | Due date of course. | No |
| Course_Transcript: Enroll Date | DateTime | Returns enrollment date of course. | No |
| Course_Transcript: Expiration Date | DateTime | Returns expiration date date of course. | No |
| Course_Transcript: Start Date | DateTime | Course start date. | No |
| Course_Transcript: Status | String | Returns course status (Not Started, Inprogress, Pass, Failed, Waived). | No |
| fldUserDefinedCourseId | String | ID, assigned by system to uniquely identify a course. | Yes Hint: Join it with "Obj_Course" to get other course's properties such as enrollment type, course credits, course outline etc. |
| flduserid | Integer Number | ID, assigned by system to uniquely identify a user. | Yes Hint: Join it with "Obj_User" to get other user's properties such as region, division, department, job title etc. |
| User: Email | String | Email ID of user. | No |
| User: Employee ID | String | Employee ID of user. | No |
| User: First Name | String | First name of user. | No |
| User: Last Name | String | Last name of user. | No |
| User: Status | String | Returns Active or Inactive. | No |