Purpose

Describes the student demographics available for analysis via the StudentSchoolDemographicsBridge View and StudentLocalEducationAgencyDemographicsBridge View. Part of the Core View Collection.

SQL Object

analytics.DemographicDim

Usage Notes

See How to Use the Student Dimensions for usage examples.

The data have an implicit parent-child relationship. Run the following query for a list the "parent" demographic keys:

select
	distinct
	DemographicParentKey
from
	analytics.DemographicDim

This gives us the following parent keys:

• CohortYear
• Disability
• DisabilityDesignation
• Language
• LanguageUse
• Race
• StudentCharacteristic
• TribalAffiliation

The DemographicKey column exists in order to establish a unique key for indexing purposes. As a general rule, the column need not be used or made available to report designers. The DemographicLabel column is the one of primary interest for use in filters and/or visual display, as can be seen in the following sample rows (two for each parent key):

Data Sources

Data Standard 2.2

In the older data standard, the demographics were all stored in the school relationship — therefore this is little different than the StudentSchoolDim View.

Data Standard 3+

Structure

Data Standard 2.2

Data Standard 3+