Summary assessments are known to us backend folks as “repositories”. The reason for that is we have both “Demographics” and “Summary Assessments” to help users better name and categorize their repositories. The only difference is the name.

Repositories can be found in the dna_repositories schema. Each new repository will get a record in the repositories.repositories table, as well as its own special table named with the repository_id, e.g, dna_repositories.repository_1, dna_repositories.repository_2, etc.

Every repository table will have a student_id column, followed by columns prefixed with field_. These are the fields that you dynamically added to the repository via the UI. You can query these any way you like.

Want some examples? Send me an email zach@illuminateed.com with a query you would like me to write