_Data Dictionary Excerpt Macros

The unique value automatically created for each user by the connected LMS system

Friendly name for the user in the platform, typically the login name for the user and created by the organization

User’s first and last name

User’s Primary Email Address as entered in the LMS. In IntelliBoard Pro, it displays as a clickable mailto link that automatically opens a new email in your default email client and prefills the “to” email address.

The organization associated with the user in the LMS

Timestamp for when the user account was created in the LMS

Language code (such as “EN”) for the user’s preferred language

Home country code of the user, such as AU or US

An arbitrary ID code number, perhaps from the institution

Timestamp for the first time the user logged in to the platform. Displays 0 if the user has not yet logged in.

Timestamp for the most recent user login to the platform. Displays 0 if the user has not yet logged in.

Count of user logins to the platform. This is an IntelliBoard calculated field.

Link to the User’s LMS profile page. You must log in to the LMS to have access.

User’s First Name

User’s Last Name

User state in the system, displays as either Active or Inactive

User’s Role in course. (ie: Learner, Instructor, Designer, Observer)

Unique ID for the user enrollment

Timestamp for the last activity of the learner in the enrolled course

Timestamp for the leaner’s last participation in the enrolled course. Note: an instructor may return a last participation if they have interacted in course forums.

Date of when learner satisfies all requirements to complete the course

Returns yes or no or the status of Complete or Incomplete to the question has the user completed the course

Count of complete activities for the learner’s enrollment. This is an IntelliBoard calculated field.

Total number of activities the learner must complete to satisfy enrollment requirements

Course Grade displayed as a percentage out of 100

Course Grade displayed by points total

Date of user's first access to the course

Date of user’s last access to the course

Course Grade displayed by letter grade

Total number of course modules or sections required to complete the course

Number of Modules Required to be completed in a course for a user

Unique ID for the type of Enrollment

Date user enrolled in course

Date for the expected start of the user’s enrollment in the course. The user is not expected to begin work in the course until this date.

Date for most recent modification to a user’s enrollment

Date for the expected completion date of an enrollment, if entered. If no completion date is set, “Never” will be displayed.

Total amount of time spent by user in the course on the LMS

How the user enrolled in a course, such as “manual,” “cohort,” or via a 3rd party registration system such as IntelliCart

Displays the status of a learner’s enrollment: Active, Inactive, Deleted, or Completed

Displays “yes” or “no” if an enrollment in a course has satisfied requirements for completion

The number of days since user last accessed the course

Date the user last accessed the course

User’s current grade in the course, number out of 100.

The total number of enrollments in the course, determined by the sum of unique User ID enrolled in the course.

Course name as it appears in the LMS system. It is a clickable link to the course page in the LMS. You must be logged in the LMS to have access.

The unique value automatically created for each course by the connected LMS system

The unique value automatically created for each course by the connected SIS data.

Course format such as weeks, topics, social, sites, etc.

The Organization associated with the course in the connected platform

Friendly name (or everyday name) for the course. This is not attached to the URL for the course in the LMS. It is useful when downloading a report as .csv or .xlsx file.

User-defined code for the course, typically the SIS ID

Date for when the course was created in the LMS

Date for the scheduled start of the course

Date for the scheduled end of the course

Displays “Yes” or “No” if the course is visible to students

URL to the course in the LMS. This is an IntelliBoard generated field.

Instructor(s) for course

Email contact for the course Instructor(s)

Average grade of all learners in the course

Displays whether the course is visible in the LMS as “Active” or “Inactive”

Total number of users in the course

Average amount of time spent per user in course

Average number of times users participated in the course

The average grade of students in the class, determined by taking the average of all current grades in the course

Total number of active courses user is enrolled.

Total number of courses user has completed.

Displays the status of the user in regards to course completion. May return “In Progress” or “Completed”

The unique value automatically created for each activity by the connected LMS system

The name of the activity as populated in the LMS. It is a clickable link to the activity page in the LMS. You must be logged in the LMS to have access.

The name of the activity as populated in the LMS. This is not attached to the URL for the activity in the LMS. It is useful when downloading a report as .csv or .xlsx file.

Grade displayed as percent or points on the individual activity in a course

If the activity is an assignment, displays type of submission such as “comment” or “file”

Date of when the activity record was created

Shows due date for activity if the activity is a quiz or assignment

Date for the expected activity completion date

Unique ID for the course module which contains the activity

URL for the activity. This is an IntelliBoard calculated field.

Displays “Yes” or “No” if the activity is visible to learners

Total number of activities in course, determined by sum of unique Activities ID.

Total number of visits by users to an activity

Total time spent by users in an activity

The average score of users on an activity

Date of first time an activity was accessed by a user

Date of activity completion if the activity has been completed

Displays the completion status of an activity, such as “Complete Pass,” “Complete Fail,” or “Incomplete”

The percentage of completed activities in the course

Shows the total number of activities completed out of the total number of activities in a course. ie. 85 of 105 means the user has completed 85 activities out of the 105 activities that are in a course.

Total number of users who have completed the activity

Unique value automatically created for each activity type by the connected LMS system

Name of the activity, such as “Assignment” or “Quiz”

Friendly name (everyday name) for the activity type, such as “Assignment” or “Quiz”

Unique ID for the quiz

Friendly name (everyday name) for the quiz

Date for when the quiz becomes available in the course

Date for when the quiz will become unavailable. Includes “grace period” time.

Date for when the quiz will become unavailable. Does not include the “grace period.”

Date for when the quiz was created

Displays status of the quiz in a course as either “Active” or “Inactive”

Total number of quizzes in a course, determined by the sum of unique Quiz Activities IDs.

Unique ID for the quiz completion attempt

Number of the quiz attempt (ie: a learner’s 2nd attempt)

Timestamp for when the quiz attempt was started

Timestamp for when the quiz attempt was completed

Score for the quiz attempt

Status of the learner interaction with a quiz. Displays “Untaken,” “In Progress,” “Pending Review,” or “Complete.”

Unique ID for the quiz question

Name of the quiz question

Text of the question

Total number of points the learner can achieve with a correct answer

This column specifies the type or format of each quiz question, such as multiple-choice, true/false, short answer, essay, etc.

TBD

Unique ID for the forum activity

Name of the forum activity

Date of when the forum activity was created

Displays “Yes” or “No” if the forum activity is a course announcement

Total number of forums in a course, determined by the sum of unique Forum Activities IDs.

Unique ID for the forum discussion

Name of the forum discussion/topic

Date of when the most recent post in the discussion was created.

Unique ID for the forum post as given by the LMS

Content of the discussion post

Number of replies the post received. This is an IntelliBoard calculated field.

Date of when the forum/discussion post was created

Date of when the post/discussion was modified

Displays if the forum/discussion post is “Active,” “Inactive,” or “Deleted”

Unique ID for the page

Friendly name (everyday name) of the page

Date of when the page was created

Displays “Yes” or “No” if the course page is visible to students

Total number of pages in a course, determined by the sum of unique Page Activities IDs.

The type of submission accepted by the assignment (ie: file, URL, plain text)

ID of the course module the assignment is contained within

Name of the assignment

Date of when the assignment becomes available in the course

Date of when the assignment will no longer be available in the course

Date of assignment’s due date

Date of when the assignment was created

Displays “Yes” or “No” if the assignment is the visible to learners

Total number of assignments in a course, determined by the sum of unique Assignment Activities IDs.

Percentage grade of last assignment submitted in course

Unique ID for the assignment submission record

Date of when the assignment was submitted

Text feedback or comments on the assignment submission

Date of when the submission feedback was created

Displays score of the assignment, if graded

URL of the Assignment Submission

Name of last Assignment activity that was submitted

Maximum grade achievable on the grade object

Friendly name (everyday name) of the grade item

A unique identifier assigned to a grade entry by the connected LMS. This is used to distinguish multiple grades entered into the system for the same cell in the gradebook.

The raw number of points assigned by the grader to the submission

Date of when the grade was entered

Number of points the learner achieved on the assignment

Letter grade for an assignment or course

Displays status of a grade object as either “Published” or “Unpublished”

Displays whether the grade line item is for an activity or a course

Displays the status of a grade object as either “Active” or “Inactive”

A unique identifier for the record summarizing a single user’s action across the LMS. This is an IntelliBoard calculate field.

The number of times a user has viewed a given activity within a course over time. This is an IntelliBoard calculated field.

The cumulative amount of time spent by the user viewing or interacting with a given activity within a course over time. This is an IntelliBoard calculated field.

The number of participations in a given activity within a course over time (as calculated by IntelliBoard), where "participations" are submissions by the student of content for feedback

IP Address the user accessed the LMS from

Date of the user’s first access of the LMS

Date of the user’s most recent access of the LMS

Displays if the user tracking point is from the site, a course, or a module.

Sum total of User’s time spent in a course or of all users in a course, dependent upon the report.

Date of the most recent user login to the platform. Displays “0” if the user has not yet logged in.

User visits per day

Total time a user spent on the platform by day

Date which a user activity was logged in the LMS

Count of user visits by hour of the day

Time spent in the LMS by the user, broken down by hours. This in an IntelliBoard calculated field

Date and hour for the most recent platform activity by the user. A user may have several of these per day if they access or record a participation in the LMS multiple times. (ie: 02.12.2023 12:30, 02.12.2023 13:12, 02.12.2023 15:26)

A unique identifier for a role which can be assigned to a user within a course or other context

The name of a role that can be assigned to a user within a course or other context

An alternative name for the role assigned to a user within a course or other context

A unique identifier of a category unit used to group courses or subcategories

Friendly name (everyday name) of a category unit used to group courses or subcategories

The location of a category unit within a structure used to group courses or subcategories

A parameter used to define how categories or organizational units will be sorted in a list

Displays “Yes” or “No” if the category is visible in the platform.

Date of the most recent modification in the platform

Optional category id number. This is typically an external or SIS-linked id number.

Hierarchical path of categories that has been set for courses in the LMS

Friendly name (everyday name) of a category unit used to group courses or subcategories

The unique identifier of a term or semester as defined in the connected platform

The name of the term, a set period of time often used to organize courses, as defined on the connected platform

A unique, visible identifying code given to the term within the connected platform

Date when the term begins, as defined in the connected platform

Date of the end of the term, as defined in the connected platform

Unique ID for the browser used

Friendly name (everyday name) for the browser used (ie: Firefox, Safari, or Chrome)

Unique ID for the operating system

Friendly name (everyday name) for the operating system (ie: Windows, ChromeOS, or MacOS)

Displays the status of the learner submission as “New,” “Draft,” “Submitted,” “Graded,” or “Reopened”

Date of last assignment submitted in course

Date the activity was submitted

The type of submission the activity is. Examples include: Online text entry, discussion topic, and online upload.

Show number of days since user submitted an activity (assignment, quiz, forum post, etc) in a course. Decimals can be used to measure partial days, i.e. 2.5 days. Standard rounding rules are used. Is determined by “Current Date - Date of Last submission.”

Unique ID for the LTI Tool

Friendly name (everyday name) of the LTI tool

URL of the LTI tool

Status of the LTI tool, displays as either “Active” or “Inactive”

Timestamp for when the LTI activity was created in the platform

Displays the visibility of the user profile field, either “Visible” or “Not Visible”

Format of the user profile field. Typically displays the name of the platform the profile field was created in.

Unique ID of the cohort

Friendly name (everyday name) for the cohort

User-generated ID for the cohort. Typically matched with external systems such as an SIS.

Status of the cohort, displays as “Active” or “Inactive”

Timestamp for when the cohort was created.

Timestamp for the most recent modification of the cohort.

Status of the cohort group, displays as either “Active” or “Inactive”

The total number of users enrolled in a section regardless of a role

The level in the LMS the User has accessed. i.e. Course, Module, etc.

The Internal ID number that is assigned by the LMS

The number of visits to the course by the User

Primary language of the User

The template organizational unit serves as a grouping container in the LMS for organizing similar or related courses. For example, you can group all History 101 classes in one place if you offer multiple sections or group all History classes in one place. It helps make enrolling, creating, and managing courses easier over time.

Displays the day of the week users are most active in the course.

Displays based on the filter setting. It may show 3 periods, 6 periods, or total time breakdown for the subsequent days of the week (hours) columns. In some reports, the Time of Day is already set, other reports may have a filter setting that can adjusted.

Time spent by User in specified time period of the day.

Percent of total time spent by users on a specific day of the week compared to a full week.

Progress of User on the LMS site in the course. Displays as a bar graph or a percentage of completion.

Total number of activities user has completed.

User’s status within the course. May display as either “Complete” or “Incomplete.”

Total time User has spent on the LMS.

Total time User has spent in all courses.

Total time User has spent in all activities.

User’s primary phone number

Secondary phone number if available.

Institution of User

Department of User

User’s street address

User’s city/town of residence.

User’s country of residence.

Type of Degree User is pursuing. ie. PhD, Associate, Bachelor, High School, etc

User’s self identified ethnic group if available

User’s student status, Full Time or Part Time, if available

User’s self identified gender, if available

User’s assigned group

Time stamp of the most recent log in to the LMS

Time stamp of the most recent log out of the LMS

Displays the percentage a User has used particular browsers. i.e. Firefox, Chrome, Safari, Edge, etc.

Displays the percentage a User has used particular operating systems. i.e. Windows 10, Mac OS X, Linus, etc

Displays the percentage a User has used particular devices. i.e. iPhone, iPad, Android, etc

Total number of courses User is enrolled

The authentication method by which the user was added to the LMS system

The column stores data about whether the user's data was confirmed

The column stores data about whether the user's activity was suspended

The column stores data about whether the user's activity was deleted

Date when User was modified in the LMS system

The last time the user logged in using previously saved data. User is still logged on.

Average of grades in all enrolled courses.

Learner's current grade in course

Displays if the user’s role has been changed, either yes or no.

Displays the name of person who changed the user’s role, if it has been changed.

Displays the previous role held by the user, if the role has been changed.

Action taken in the role change. i.e. Assigned

Click the mail icon to open a new email in your default email client and prefills the “to” email address with the user’s email address.

Click the “View” link to access the connected LMS

Date the role change occurred.

Shortened name for limited space needs

Date an assignment, activity, or quiz was graded.

Name of person who graded the assignment, activity, or quiz

The total number of forums within a course.

Total number of visits to forum(s) within a course

Total amount of time users have spent on forums within a course

Total number of posts within a course’s forum(s)

Total number of discussions within a course’s forum(s)

Total time user spent on a specific activity.

A hyperlink to details of the activity and BBB attendance

Total number of users with learner roles that have completed the course.

Total number of users with learner roles that are enrolled in a course.

Total number of Learner Events in a course

Total number of visits by all users to a course.

The percent of activities in a course that have been completed

The average number of forum posts per day by learners in a course

The average number of overall course visits per day by learners in a course

Total number of workshops in a course

Total number of any new activities added to a course after the course’s initial creation date.

Total number of Assignments that have been completed in a course

Total number of Assignments that have been submitted in a course

Total number of Assignments that have been graded in a course

Total number of all users enrolled in course, regardless of role.

The method the user used to access the content. i.e. “web”

Total Time a user has spent on the LMS dashboard

The number of clicks (mouse clicks) made by instructor in a specific course

Date of user’s first access to the LMS dashboard

Date of user’s most recent access to the LMS dashboard

The dashboard name and the particular item on this dashboard instructor has visited

Name of person or role who enrolled user in course

The total number of courses within a category.

The sum total of posts made by the instructor in a forum.

Number of learners who have engaged with the LMS system in the last 30 days

The number of learners who have completed courses with the associated instructor (must be enabled in the LMS system)

The average grade for all learners in all courses associated with the instructor

Total number of users who have accessed the course, regardless of role

Total number of users who have never accessed the course, regardless of role

Total number of users who have completed the course

Total number of instructors assigned to a course

Total number of enrolled learners that have not yet completed the course

Total number of enrolled learners that are overdue for course completion.

Total number of learners who have accessed the course and completed at least 1 activity

Total number of learners who have accessed the course but have not completed any activities

Percent of Activities that have been viewed by the user as shown by a progress bar

Percent of Modules that have been completed by the user as shown by a progress bar

Percent of Assignments that have been completed by the user as shown by a progress bar

Displays feedback from the course by the user

Displays the date the user last downloaded anything from the course

Total number of attempts users made in an activity, may be per user or for all users in a course dependent upon the report.

The complete and descriptive name of the course outcome

The condensed version of the full name, often used for brevity in reports, dashboards, or other interfaces where space is limited

Provides additional context or details about the outcome, including any specific skills, knowledge, or competencies that students should demonstrate. It elaborates on what the outcome entails and may include examples or criteria for achievement.

This indicates how the outcome will be measured or assessed. It could be a qualitative scale (e.g., Excellent, Good, Fair, Poor) or a quantitative scale (e.g., Percentage, Letter Grade, Rubric Score).

This represents the average level of achievement for the outcome across all students in the course.

Total number of assignments, activities, etc that will be graded as part of the course

The specific identifier or code assigned to each course outcome within an LMS or educational system.

The Open LMS Outcome Component for the course

Displays the minimum possible grade for the assignment or assessment.

Displays the maximum possible grade for the assignment or assessment.

The raw score or grade achieved by the user on the assignment or assessment before any adjustments or calculations.

This column may provide additional information about the instance or occurrence of the assignment or assessment within the course, such as a specific module or session.

A unique identifier for each attempt made by a user on an assignment or assessment.

Amount paid by user for enrollment

Type of currency used to pay for enrollment

Total number of courses that were enrolled in using a specific enrollment method

Total number of enrollments using a specific enrollment method