Follow

SiD database structure: supersite, site, subsite

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

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

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

This is the hierarchy: supersite (if any) -->site -->subsite -->room -->class 

structure_supersite_to_class.png

Real Life Examples

Supersite with multiple sites and subsitessupersite_site_subsite_illustration.jpg

Site with multiple subsitessite_subsite_structure.jpg

Site with a subsite of the same namesite_same_subsite_illustration.jpg

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

0 Comments

Please sign in to leave a comment.
Powered by Zendesk