Order Tool Dashboard
Institution specific ordering data from the Order Tool can be visualized in a Google's Looker Dashboard for Program Administrators.
The Order Tool Dashboard has four views:
View 1
This view demonstrates the amount of orders that each profile has submitted, as well as the percentages of Course Coordinators and Instructors with at least one order.

View 2
This view demonstrates the growth of orders by SIS term and shows the percentages of Course Coordinators and Instructors with at least one order.

View 3
This view demonstrates the amount of sections and courses that have at least one order, grouped by SIS Term ID.

View 4
This view demonstrates a list of all active profiles with Program Administrator permissions and Course Coordinator permissions, respectively.

The following data are pulled from the Order Tool to populate the dashboard:
Column name
Data type
Definition
is_active
Boolean
If “true,” the profile is active.
is_admin
Boolean
If “true,” the profile has program administrator ordering permissions.
is_coordinator
Boolean
If “true,” the profile has at least one course coordinator ordering permission.
is_instructor
Boolean
If “true,” the profile has instructor ordering permissions.
network_id
Text
The "network_id" for a user is the identifier released by your Institutions' Identity Provider in a Single Sign-on integration. In a Shibboleth implementation, this value must be identical to the EPPN attribute released by your Institution's Identity Provider.
last_name
Text
The SIS provided last name for a user.
first_name
Text
The SIS provided first name for a user.
sis_term_id
Text
The unique and immutable SIS ID for the Term; e.g., "201890."
sis_user_id
Text
The unique and immutable SIS ID for the individual user.
profile_id
Text
The unique and immutable Profile ID for the individual user in Order Tool.
has_teaching_assignments
Boolean
If “true,” the profile has at least one teaching assignment.
order_id
Text
The unique and immutable Order ID for an individual order.
sis_section_id
Text
The unique and immutable SIS ID for the Term; e.g. "201890-22-BIO-101-0001" or "4205-30855". This key is used to uniquely identify sections upon import into Order Tool.
sis_course_id
Text
The unique and immutable SIS ID for the Course; e.g., "201890-22-BIO-101."
Last updated