The Quest application allows other applications to access a wide variety of data obtained from Quest within the same database as the rest of the application data. This document provides a high-level overview of the capabilities of the application. More detailed documentation is also available:

Statistics

Statistics of this nature have the potential to be misleading, but they may provide some sense of the overall magnitude of the application.

  • Python code (automatic processes): 80 lines
  • SQL code (schema definition and stored procedures): 5200 lines

This application depends on the Data application.

Quest Data

As far as other applications and developers are concerned, the Quest application is simply a bunch of tables and views that are available for querying. Some of them contain public information such as calendar and class schedule data. Other contain student records. The public tables are relatively widely available, with any application able to use them. The student records tables will be available only to applications that actually need them, and a Privacy & Security Impact Assessment will likely need to be done for new applications or major changes to existing applications.

The Quest data are currently updated daily via extracts run within Quest and picked up using secure file transfer.