/
StudentSchoolDemographicsBridge View
StudentSchoolDemographicsBridge View
- Stephen Fuqua
Owned by Stephen Fuqua
Jan 02, 2025
Loading data...
Purpose
This view provides student demographic information by linking the StudentSchoolDim View to the DemographicDim View. Part of the Core View Collection.
SQL Object
analytics.StudentSchoolDemographicsBridge
Usage Notes
See How to Use the Student Dimensions for detailed examples.
Data Sources
Data Standard 2.2
Data Standard 3+
Structure
Structure is the same for both data standards when taking the different data sources into account. Filtered by students who are currently enrolled (StudentSchoolAssociation.ExitWithdrawDate
is null or is a future date).
Column | Data Type | Source | Description |
---|---|---|---|
StudentSchoolDemographicBridgeKey | String | "{DemographicKey}-{StudentSchoolKey}" | Primary key |
StudentSchoolKey | String | "{Student.StudentUniqueId}-{StudentSchoolAssociation.SchoolId}" | |
DemographicKey | String | "{Demographic}:{Descriptor.CodeValue}" |
Contents