Table: dim_fee

Type: Dimension Columns: 9

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 Type Description
fee_id string

Unique identifier for the fee

business_id string

Unique identifier for the business

fee string

The name of the fee

fee_type string

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 string

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 string

Indicates whether the fee is currently deactivated; enumerated: 'Activated' or 'Deactivated'

fee_scope string

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'

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.