Description
This fact table provides the fee charge, credit & collected amounts for registrations as well as the ability. The grain of this fact table is at at the payment(s) within the prospective enrollment (consisting of application + student + school + class). This fact table, coupled with accompanying child fact table & dimension tables, can help users to understand questions such as: How much in registration fees have been collected?
Columns
| Column Name | Description |
|---|---|
business_id |
Unique identifier for the business |
prospective_enrollment_id |
Unique identifier associated with the prospective enrollment; this is useful for counting the prospective enrollment opportunities. The msot common grain is application + student + school + class. However there are other grains when students are yet to be assigned to a class. |
fee_charged |
The amount ($) of the original registration fee charged |
fee_credit |
The amount ($) of the original registration fee credited back |
promotional_discount |
The amount ($) of promotional discounts deducted from the fees charged |
payment_submission_date |
The date when the: payment (and possible processing fee) was submitted, refund (and possible processing fee) was returned, or application offer was created (when fee is waived) |
fee_collected |
The amount ($) of registration fee paid |
payment_processing_fee_paid_by_business |
The service fee amount paid by the business for the payment processing service (typically regarded as revenue lost by the business); NULL indicates that no service fee was paid by the business on the transaction |
subsidy_waived |
The amount ($) of fee wavied by subsidy |
promo_code_id |
Unique identifier for the promotional code; connects to the dim_promo_code table |