Skip to main content
Ed-Fi.orgDocsCommunityAcademy

StudentSchoolDemographicsBridge View

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​

CohortYear DS2.2

Disability DS2.2

Language DS2.2

LanguageUse DS2.2

Race DS2.2

StudentCharacteristic DS2.2

Data Standard 3+​

Cohort Year DS3.x

Disability DS3.x

Disability Designation DS3.x

Language DS3.x

Language Use DS3.x

Race DS3.x

Tribal Affiliation DS3.x

Student Characteristic DS3.x

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).

ColumnData TypeSourceDescription
StudentSchoolDemographicBridgeKeyString{DemographicKey}-{StudentSchoolKey}Primary key
​StudentSchoolKeyString{Student.StudentUniqueId}-{StudentSchoolAssociation.SchoolId}
DemographicKeyString{Demographic}:{Descriptor.CodeValue}