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 

Real Life Examples

Supersite with multiple sites and subsites

Site with multiple subsites

Site with a subsite of the same name