Learn the Schema

To get more information about the Illuminate database, please email [e-mail] requesting access to Schema Spy. NOTE: Illuminate does not support writing SQL queries for you. We will guide you as to where in the database specific data elements are stored.

The following schemas and/or tables are commonly used, but the schema is quite complex:

public

• students

• sites

• users

• terms

• sessions

• sections

matviews

• ss_cube (Rostering)

  Note: Illuminate uses the second half of the academic year throughout all data. For example, 2015 is used to designate the 2014-15 school year.

dna_assessments (Assessments)

dna_repositories (Summary Assessments & Demographics) Note: If a new repository is created, please email [e-mail] to have your permissions refreshed to gain ODBC access to the repositories.

state_data_XX (State Data Imports)

national_assessments (NWEA, AIMSweb, SAT, ACT, etc.)

codes (Each code tables provide links to decode what the id's stand for within many of the tables throughout the database.)

gradebook

• overall_score_cache

• category_score_cache

• standards_score_cache