Description
Class information. The data grain is class level information within a school.
Columns
| Column Name | Description |
|---|---|
class_id |
Unique identifier for the class |
business_id |
Unique identifier for the business |
school_id |
Unique identifier for the school |
class |
The name of the class |
school |
The name of the school |
current_status |
Indicates whether the class is currently active; enumerated: 'Active' or 'Inactive' |
max_roster_size |
The maximum number of students that the class may contain |
class_start_date |
The date when the class starts; a key to the dim_date table |
class_end_date |
The date when the class ends; a key to the dim_date table |
class_start_time_key |
The time when the class day is scheduled to begin; a surrogate key to the dim_time table. The value -1 indicates a NULL timestamp |
class_end_time_key |
The time when the class day is scheduled to end; a surrogate key to the dim_time table. The value -1 indicates a NULL timestamp |
care_type |
The type of care provided by the class; enumerated: 'ASC (After School Care)', 'BSC (Before School Care)', 'LDC (Long Day Care)', 'VAC (Vacation Care)' |
ratio_students |
The number of students for the student to teacher ratio for compliance |
ratio_teachers |
The number of teachers for the student to teacher ratio for compliance |
start_age |
The minimum age of students for the class, without the unit of measure |
start_age_unit |
The unit of measure for the starting age; enumerated: 'Weeks', 'Months', or 'Years' |
end_age |
The maximum age of students for the class, without the unit of measure |
end_age_unit |
The unit of measure for the ending age; enumerated: 'Weeks', 'Months', or 'Years' |
is_regulation_overriden |
Indicates whether the class regulations have been overridden; enumerated: 'Yes' or 'No' |
default_fee_status |
Indicates whether the default permanent fee is currently set for the class; enumerated: 'Set' or 'Not Set' |
default_fee_id |
Unique identifier for the class's default fee (if set); connects to the dim_fee table |
start_age_in_days |
A combination of start_age & start_age_unit converted to days; this may be inaccurate because 30 is used for months and 365 for years. Typically, useful for ordering class by age |
end_age_in_days |
A combination of end_age & end_age_unit converted to days; this may be inaccurate because 30 is used for months and 365 for years. Typically, useful for ordering class by age |
class_profile_url |
The Kangarootime URL for the class profile |
class_slicer_key |
A case sensitive key that connects to dim_slicer_class which can be used to provide distinct class names in dashboard slicers |