LocalEducationAgencyDim View

Owned by Stephen Fuqua
Mar 06, 2020
1 min read

Purpose

Provides information about a Local Education Agency, which could be an independent school district or a charter network. Hierarchically, public schools usually belong to a Local Education Agency.

SQL Object

analytics.LocalEducationAgencyDim

Usage Notes

As districts can cross municipal boundaries, and initial thinking about use cases does not reveal a need to display district addresses, no geographical information has been included other than that implied by the agency name and (where available) its state agency name.

Data Sources

Data Standard 2.2

Data Standard 3+

Structure

Column

Data Type

SourceDescription
​LocalEducationAgencyKeyint​LocalEducationAgency.LocalEducationAgencyIdPrimary Key​
LocalEducationAgencyNamestringEducationOrganization.NameOfInstitution
LocalEducationAgencyTypestring

LocalEducationAgencyCategoryType.CodeValue (DS 2.2)

Descriptor.CodeValue (DS 3+)


LocalEducationAgencyParentLocalEducationAgencyKeystringLocalEducationAgency.ParentLoclaEducationAgencyId
LocalEducationAgencyStateEducationAgencyNameintEducationOrganization.NameOfInstitution via LocalEducationAgency.StateEducationAgencyId
LocalEducationAgencyStateEducationAgencyKeystringLocalEducationAgency.StateEducationAgencyId
LocalEducaitonAgencyServiceCenterNameintEducationOrganization.NameOfInstitution via LocalEducationAgency.EducationServiceCenterId
LocalEducaitonAgencyServiceCenterKeystringLocalEducationAgency.EducationServiceCenterId
LocalEducationAgencyCharterStatusint

ChartStatusType.CodeValue (DS 2.2)

Descriptor.CodeValue (DS 3+)


LastModifiedDateDateTimeMost recent LastModifiedDate from EducationOrganization (LEA) or  EducationServiceCenter

Contents