Knowledgebase: Manuals and Guides
Inquisiq Reports Fields
Posted by Jessica D'Apice on 29 June 2017 09:38 AM

Catalog and Course Information

Catalog Name

Name of catalog

Catalog Cost

Cost of catalog (in dollars)

Course Name

Name of course

Course Code

Course code attached to course

Course Cost

Cost of course

Course Rating

Average user rating of course

Votes Cast

Number of ratings submitted by users

Course Credits

Number of credits a course is worth

Course Published

Whether or not the course is published (“True” or “False”)

Course Closed

Whether or not the course is closed (“True” or “False”)

Course Locked

Whether or not the course is locked (“True” or “False”)

Lesson Name

Name of lesson

Lesson Type

Blank for Online Lesson; “Classroom Lesson” or “Web Meeting”

Content Resource

Name of SCORM package / IMS Identifier (SCO ID)

Session Date/Time

Date and time of Classroom Lesson or Web Meeting; blank for Online Lesson

Session Seats

Number of total seats for session

Session Waiting Seats

Number of total seats for waitlist for session

Session Seats Available

Number of open seats for session

Session Instructor

Name of session instructor (Last name, First name)

Session Instructor Email

Email of session instructor

Session City

City in which session will take place

Session Province

Province in which session will take place

Session Student Name

Student on session roster (Last name, First name)

Session Student Email

Email of student on session roster

Session Student Username

Username of student on session roster

 

 

Certificates

Full Name

User full name (Last name, First name)

Last Name

User last name

First Name

User first name

Email

User email

Username

User Username

Status

User account status (“Active” or “Disabled”)

Created

Date and time user account was created

Expires

Date and time user account expires, if any

Last Login

Date and time of user’s last login

IP address

User’s computer’s public IP address

Language

User’s preferred Language (if not selected in profile, defaults to Default Language selected in Localization in Administrator Menu)

Local Time Zone

User’s selected Time Zone (if not selected in profile, defaults to Time Zone selected in Localization in Administrator Menu)

Group

A group the user is in (one group per new line)

Identifier

Active Directory attribute distinguishedName (only populates when users are brought into the system through Active Directory sync in Administrator Menu > User Authentication)

Certificate Name

Name of certificate earned by recipient

Certificate Code

Code attached to certificate

Issuing Organization

Organization that issues the certificate

Awarded By

Denotes who awarded certificate; “[Earned]” if received by completing course requirements; user full name if awarded by user with permissions to award certificates (Last name, First name)

Award Date

Date on which certificate was awarded to recipient

Expiration Date

Date on which certificate expires, if any

Tracking Code

System-generated internal tracking code unique to user’s certificate

Credits

Certificate credits attached to the certificate

 

 

Course Transcripts

Full Name

User full name (Last name, First name)

Last Name

User last name

First Name

User first name

Email

User email

Username

User Username

Status

User account status (“Active” or “Disabled”)

Created

Date and time user account was created

Expires

Date and time user account expires, if any

Last Login

Date and time of user’s last login

IP address

User’s computer’s public IP address

Language

User’s preferred Language (if not selected in profile, defaults to Default Language selected in Localization in Administrator Menu)

Local Time Zone

User’s selected Time Zone (if not selected in profile, defaults to Time Zone selected in Localization in Administrator Menu)

Group

A group the user is in (one group per new line)

Identifier

Active Directory attribute distinguishedName (only populates when users are brought into the system through Active Directory sync in Administrator Menu > User Authentication)

Course

Name of course

Credits

Number of credits attached to course

Enroll Date

Date and time user was enrolled into course

Course Status

User’s course completion status (“future,” “enrolled,” “completed,” “incomplete,” “expired”)

Due Date

Date and time at which course completion is due, if any

Date Completed

Date and time at which course was completed by user, if status is “completed”

Lesson

Lesson name

Session Date/Time

Date and time of session, if it was a “Classroom Lesson” or a “Web Meeting”

Content Resource

Name of SCORM package / IMS Identifier (SCO ID)

Lesson Completion

User’s lesson completion status (“completed,” “incomplete,” “unknown”)

Progress Measure

Whole number measure of user’s progress in a lesson.

Lesson Success

Whether the lesson was “passed” or “failed” by the user; “unknown” means there is no score for the lesson

Score

Percentage score earned by the user for the lesson

Lesson Timestamp

Date and time the lesson was last exited

Lesson Time

Amount of time spent in the lesson, from launch to close (Web page shows hh:mm:ss; Excel shows time in seconds)

Attempts

Number of times interaction submitted

Interaction

Internal tracking number for individual interaction

Interaction Description

Directions or question for interaction

Type

Type of interaction (“true-false,” “choice,” “fill-in,” “matching,” “sequencing”)

Interaction Timestamp

Date and time interaction submitted

Interaction Time

Amount of time lapsed from interaction slide launch to interaction submission

User Response

Response given by user

Correct Responses

All possible correct responses

Result

User’s success in the interaction (“Correct,” “Incorrect,” or “Wrong”)

Objective

ADVANCED: Learning objective for the interaction

Objective Description

ADVANCED: Description of learning objective for the interaction

Objective Score

ADVANCED: Percentage score for learning objective

Objective Completion Status

ADVANCED: Whether learning objective was “completed” or “incomplete”

Objective Success Status

ADVANCED: Whether or not the objective was “passed” or “failed”

 

 

 

Purchases

Full Name

User full name (Last name, First name)

Last Name

User last name

First Name

User first name

Email

User email

Username

User Username

Status

User account status (“Active” or “Disabled”)

Created

Date and time user account was created

Expires

Date and time user account expires, if any

Last Login

Date and time of user’s last login

IP address

User’s computer’s public IP address

Language

User’s preferred Language (if not selected in profile, defaults to Default Language selected in Localization in Administrator Menu)

Local Time Zone

User’s selected Time Zone (if not selected in profile, defaults to Time Zone selected in Localization in Administrator Menu)

Group

A group the user is in (one group per new line)

Identifier

Active Directory attribute distinguishedName (only populates when users are brought into the system through Active Directory sync in Administrator Menu > User Authentication)

Order Number

Granted by system for tracking purposes

Order Date

Date and time of order submission

Credit Card Digits

Last 4 digits of credit card number used to execute the purchase (Authorize.net integrations ONLY)

Item Type

“Catalog” or “Course”

Item Name

Name of the item purchased

Item Description

Short description of the item purchased

Cost

Cost of item

Paid

Amount paid for item

Coupon Code

Coupon code used to purchase item, if any

 

 

User Demographics

Full Name

User full name (Last name, First name)

Last Name

User last name

First Name

User first name

Email

User email

Username

User Username

Status

User account status (“Active” or “Disabled”)

Created

Date and time user account was created

Expires

Date and time user account expires, if any

Last Login

Date and time of user’s last login

IP address

User’s computer’s public IP address

Language

User’s preferred Language (if not selected in profile, defaults to Default Language selected in Localization in Administrator Menu)

Local Time Zone

User’s selected Time Zone (if not selected in profile, defaults to Time Zone selected in Localization in Administrator Menu)

Group

A group the user is in (one group per new line)

Identifier

Active Directory attribute distinguishedName (only populates when users are brought into the system through Active Directory sync in Administrator Menu > User Authentication)

 

(0 vote(s))
Helpful
Not helpful