Description
This fact table provides the dates and times when an enrollment was scheduled to take place or will take place (up to 1 year into the future). Unlike the Enrollment Schedule table, this fact table contains enrolled days manually scheduled by staff (ad hoc) or parents (drop-in). The grain of the data is the date at which a child is scheduled to be in a class. The grain of the data is the date at which a child is scheduled to be in a class. This fact table, coupled with the Enrollment Schedule table and accompanying dimension tables, can help users to understand questions such as: For any time period, what is the enrolled student count for each class, school, or business? For any time period, what is the utilization rate for each class, school, or business? When are the underutilized days and times for each class, school, or business? What is the full-time equivalent (FTE) enrollment for each class, school, or business? What is the enrollment trend over time for each class, school, or business?
Columns
| Column Name | Description |
|---|---|
record_key |
Surrogate key integer |
class_schedule_key |
Surrogate key for the class schedule for the date (a surrogate key to the fct_class_schedule table) |
fee_id |
Unique identifier for the fee |
current_status |
Indicates whether the scheduled enrollment is currently active; enumerated: 'Active' or 'Cancelled' |
calculated_cost |
Calculated cost for the enrolled day |
discount |
Calculated recurring discount for the enrolled day |
reason_for_no_calculated_cost |
Diagnostic information for the enrolled day when cost cannot be calculated |
class_fee_key |
A surrogate key to the fct_class_fee table |
student_id |
Unique identifier for the student |
account_id |
Unique identifier for the account |
contract_id |
Unique identifier for the contract |
business_id |
Unique identifier for the business |
date |
The date when the scheduled enrollment takes place |
scheduled_start_time_key |
The time when the scheduled enrollment day begins; a surrogate key to the dim_time table |
scheduled_end_time_key |
The time when the scheduled enrollment day ends; a surrogate key to the dim_time table |
scheduled_start_end_time |
The start and end time of the scheduled enrollment |
booking_type |
The kind of the booking; enumerated: 'Drop-in' or 'Ad hoc' (enrollment manually created by staff) |