StudentSchoolDemographicsBridge View
- Stephen Fuqua
- Ian Christopher (Deactivated)
Owned by Stephen Fuqua
Apr 19, 2020
1 min read
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