Follow

SiD database structure: supersite, site, subsite

This article describes the framework of a SiD database, including definitions and examples.

Each database is built in layers. Larger consortia will have more complex structure, while smaller programs will be simpler.

This is the structure for all databases:
supersite (if any) -->site -->subsite -->room -->class 

Components

Every program will have at least one of each of the following divisions:

  1. Site: distinct fiscal entity that receives ABE funding and handles staff hiring, etc.
  2. Subsite: a building or physical locations grouped together for planning, data management, and internal reporting.
  3. Room: the actual room name/number within a building where classes occur.
  4. Class: A group of students meeting regularly to study a subject under the guidance of a teacher. The class title should be reflective of what’s being taught in the class (GED Prep, ESL Level 1, Day ESL Literacy, Adult Diploma). 
    For one-room schoolhouses, where a variety of subjects and levels are taught on demand, use broader class names, like "ABE/ESL."

Consortia with multiple databases will have a supersite level, which is strictly for running consortium-wide reports.

structure_supersite_to_class.png

Real Life Examples

Supersite with multiple sites and subsitessupersite_site_subsite_illustration.jpg

Site with multiple subsites
site_subsite_structure.jpg

Site with a subsite of the same namesite_same_subsite_illustration.jpg

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk