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 | Type | Description |
|---|---|---|
prospective_enrollment_id |
string
|
Unique identifier associated with the prospective enrollment |
business_id |
string
|
Unique identifier for the business |
stage |
string
|
The stage the prospective enrollment has passed through; enumerated 'Applied', 'Waitlisted', 'Completed', 'Lost', 'Errored', 'Approval Pending', or 'Offered' |
stage_date |
date32[day]
|
The date that the prospective enrollment began the associated stage |
stage_order |
int32
|
The ordering of the stages within a prospective enrollment |
comparison_month_key |
int32
|
A ordered key used to allow the comparison of prospective enrollment dates within months (even spanning multiple years) across different terms |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |