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 | Type | Description |
|---|---|---|
business_id |
string
|
Unique identifier for the business |
prospective_enrollment_id |
string
|
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 |
double
|
The amount ($) of the original registration fee charged |
fee_credit |
double
|
The amount ($) of the original registration fee credited back |
promotional_discount |
double
|
The amount ($) of promotional discounts deducted from the fees charged |
payment_submission_date |
date32[day]
|
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 |
double
|
The amount ($) of registration fee paid |
payment_processing_fee_paid_by_business |
double
|
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 |
double
|
The amount ($) of fee wavied by subsidy |
promo_code_id |
string
|
Unique identifier for the promotional code; connects to the dim_promo_code table |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |