Description
Fee information. The data grain is individual fee at the school/business scope (if business the fee can be applied to any school).
Columns
| Column Name | Description |
|---|---|
fee_id |
Unique identifier for the fee |
business_id |
Unique identifier for the business |
fee |
The name of the fee |
fee_type |
Indicates whether the fee is for a daily basis or a flat rate (e.g., monthly, weekly, etc.); enumerated: 'Session' or 'Flat Rate' |
fee_structure |
Indicates a conditional group (e.g., days attended, number of siblings, etc.) for how fee rates are determined with each fee structure group corresponding to a qualifying number that adjusts the fee accordingly (e.g., more students in a family results in lower individual fees); enumerated: 'Session', 'Number of Days', 'Number of Siblings' or 'Single Flat Rate' |
current_status |
Indicates whether the fee is currently deactivated; enumerated: 'Activated' or 'Deactivated' |
fee_scope |
Indicates whether the fee is applied at the business level (all schools may use it) or specific to a single school; enumerated: 'Business' or 'School' |