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). The grain of the data is the date at which a child is scheduled to be in a class. This fact table, coupled with 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 |
calculated_subsidy |
Calculated expected subsidy 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; a surrogate key to the dim_date table |
week |
The recurrence pattern of contract dates based on the frequency type (found in fct_enrollment); for weekly enrollments the value will always be 1, for "biweekly" enrollments, the value will be 1 for the first week (starting with the week of the contracts start date) and 2 for the second week, with each week recurring every other week and for "custom" enrollments, the value will be NULL, as they do not follow a standard pattern |
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 |