Description
This fact table records the dates on which a class is available, starting from its start date and ending either on its end date or, for classes without an end date, five years from the current date. The granularity of the data is daily, representing each date a class is operational. This fact table, coupled with accompanying dimension tables, can help users to understand questions such as: What classes are open/closed on specified days? What is the maximum revenue for a class on specified days?
Columns
| Column Name | Description |
|---|---|
class_schedule_key |
Surrogate key integer |
class_fee_key |
Surrogate key for the default fee cost in this class for the date (a surrogate key to the fct_class_fee table) |
class_id |
Unique identifier for the class |
date |
The date when the class is available; a key to the dim_date table |
status |
The status of the class on the date; enumerated: 'Open' or 'Closed' |
resolution |
The resolution of a class that is marked as closed; enumerated: 'Booking Cleared' (the account does not pay) or 'Marked Absent' (the student is marked as absent and the account still pays) |
school_id |
Unique identifier for the school |
business_id |
Unique identifier for the business |