SchoolDim View

Owned by Stephen Fuqua
Mar 09, 2020
1 min read

Purpose

Contains attributes of a school including its local and state education agency hierarchy. Part of the Core View Collection.

SQL Object

analytics.SchoolDim

Usage Notes

The school dimension contains the flattened physical address as a single string. It also contains the city, county, and state, which can be used as filters or pivots. The view also includes flattened key and name values for these related entities: local education agency, state education agency, and education service center.

Data Sources

Data Standard 2.2

Data Standard 3+

Structure

Column Name

Data Type

Source Table

Description

SchoolKeyintSchool.SchoolIdPrimary Key
SchoolNamestringEducationOrganization.NameOfInstitution
SchoolTypestringSchoolType.CodeValue
LocalEducationAgencyNamestringEducationOrganization.NameOfInstitution
LocalEducationAgencyKeyintSchool.LocalEducationOrganizationId
StateEducationAgencyNamestringEducationOrganization.NameOfInstitution
StateEducationAgencyKeyintLocalEducationOrganization.StateEducationAgencyId
EducationServiceCenterNamestringEducationOrganization.NameOfInstitution
EducationServiceCenterKeyintLocalEducationAgency.EducationServiceCenterId
SchoolAddressstring

Concatenation of StreetNumber, AparatmentRoomSuiteNumber, City, State abbreviation, and PostalCode from EducationOrganizationAddress

Where Descriptor Constant for address type is "Physical".

SchoolCitystringEducationOrganizationAddress.CityWhere Descriptor Constant for address type is "Physical".
SchoolStatestring

StateAbbreviationType.CodeValue (DS 2.2)

Descriptor.CodeValue (DS 3+)

Where Descriptor Constant for address type is "Physical".
LastModifiedDatedatetimeMost recent LastModifiedDate value from EducationOrganization, SchoolType, or SchoolAddress

Contents