Description
Age band configuration by school. The data grain is the age band level within a school.
Columns
| Column Name | Type | Description |
|---|---|---|
school_age_band_key |
int32
|
Surrogate key; unique integer per age band row |
business_id |
string
|
Unique identifier for the business |
school_id |
string
|
Unique identifier for the school |
start_age_in_days |
int32
|
The starting age in days for the age band (inclusive) |
end_age_in_days |
int32
|
The ending age in days for the age band (inclusive) |
age_band_order |
int32
|
The display order of the age band within the school |
age_band_label |
string
|
The descriptive label for the age band |
effective_roster_size |
int32
|
The average class size used as the capacity baseline for this age band |
min_viable_roster_size |
int32
|
55% of effective roster size; minimum enrollment needed to justify keeping a class open (40-60% range) |
viable_roster_size |
int32
|
65% of effective roster size; enrollment level at which a class is considered viable to open (60-70% range) |
heathy_roster_size |
int32
|
78% of effective roster size; enrollment level at which a class is considered healthy (70-85% range) |
optimal_roster_size |
int32
|
93% of effective roster size; enrollment level at which a class is considered full or optimal (85-100% range) |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |