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.

Data on this dashboard is updated twice per day: at 5am EST and 3pm EST.

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."

Please contact Unizin Services if you would like to set up this dashboard for your institution.

Last updated