Description
This bridge table maps enrollment schedule records to subsidy agencies. It enables filtering enrollment schedule data by subsidy agency. Joins to fct_enrollment_schedule via record_key and to dim_agency via agency_id.
Columns
| Column Name | Type | Description |
|---|---|---|
record_key |
int64
|
Surrogate key matching fct_enrollment_schedule.record_key |
agency_id |
string
|
Unique identifier for the subsidy agency; joins to dim_agency |
business_id |
string
|
Unique identifier for the business |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |