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.
View 5
This view demonstrates a list of any order that contains both an eText and DLT from the same publisher. This can be used to determine orders where the orderer may have accidentally ordered the eText and DLT of versions of the same title.
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."
publisher_name
Text
The name of the content item’s publisher.
title
Text
The title of a content item that is on the order.
Last updated