Description
This fact table records the default fee rate for a class (when a default permanent fee is set up), including the dates when the fee rate becomes effective and expires. The grain of the data is at the level of the class default permanent fee schedule. 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_fee_key |
Surrogate key integer |
class_id |
Unique identifier for the class |
effective_date |
The date when the default fee rate becomes effective; a key to the dim_date table |
expiration_date |
The date when the default fee rate expires; a key to the dim_date table |
default_fee_id |
Unique identifier for the default permanent fee set for the class |
default_fee_cost |
The daily cost for the class based on the default permanent fee |
school_id |
Unique identifier for the school |
business_id |
Unique identifier for the business |