StudentSchoolDemographicsBridge View

Owned by Stephen Fuqua
Apr 19, 2020
1 min read

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

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

Contents