StudentLocalEducationAgencyDemographicsBridge View

Purpose

This view provides student demographic information by linking the StudentLocalEducationAgencyDim View to the DemographicDim View. Part of the Core View Collection.

SQL Object

analytics.StudentLocalEducationAgencyDemographicsBridge

Usage Notes

See How to Use the Student Dimensions for detailed examples.

Data Sources

Data Standard 2.2

In the older data standard, the demographics were all stored in the school relationship — therefore these are the same data sources as for the StudentSchoolDemographicsBridge View.

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 in a school that belongs to the Local Education Agency (StudentSchoolAssociation.ExitWithdrawDate is null or is a future date).

Column	Data Type	Source	Description
StudentLocalEducationAgencyDemographicBridgeKey	String	{DemographicKey}-{StudentLocalEducationAgencyKey}	Primary key
StudentLocalEducationAgencyKey	String	{Student.StudentUniqueId}-{StudentEducationOrganization.EducationOrganizationId}
DemographicKey	String	{Demographic}:{Descriptor.CodeValue}