Description
This bridge table records the historical stages and corresponding dates for each prospective enrollment. When joined with fct_prospective_enrollment, it enables historical analysis of enrollment stages, including counts of stages such as 'Early Registration', 'In Progress', 'Applied', 'Approval Pending', 'Waitlisted', 'Completed', and 'Lost'.
Columns
| Column Name | Description |
|---|---|
prospective_enrollment_id |
Unique identifier associated with the prospective enrollment |
business_id |
Unique identifier for the business |
stage |
The stage the prospective enrollment has passed through; enumerated 'Applied', 'Waitlisted', 'Completed', 'Lost', 'Errored', 'Approval Pending', or 'Offered' |
stage_date |
The date that the prospective enrollment began the associated stage |
stage_order |
The ordering of the stages within a prospective enrollment |
comparison_month_key |
A ordered key used to allow the comparison of prospective enrollment dates within months (even spanning multiple years) across different terms |