Purpose

Contains attributes of a student including name, enrollment, and demographic information as defined in relationship to a school at which the student is currently enrolled. Part of the Core View Collection.

SQL Object

analytics.StudentSchoolDim

Usage Notes

See How to Use the Student Dimensions.

Data Sources

Data Standard 2.2

Student to Characteristic Relationships (DS 2) Copy Copy

Data Standard 3+

StudentSchoolDim ERD Copy Copy

Structure

Data Standard 2.2

ColumnData TypeSourceDescription
StudentSchoolKeyString"{Student.StudentUniqueId}-{StudentSchoolAssociation.SchoolId}"Primary key
​StudentKeyStringedfi.Student.UniqueId​
SchoolKeyStringedfi.StudentSchoolAssociation.SchoolId
SchoolYearStringedfi.StudentSchoolAssocation.SchoolYearconvert to string to signal to modeling tools that this is not an aggregatable number
StudentFirstNameStringedfi.Student.FirstName
StudentMiddleNameStringedfi.Student.MiddleName
StudentLastNameString

edfi.Student.LastSurname


EnrollmentDateKeyStringedfi.StudentSchoolAssociation.EntryDateformatted as YYYY-MM-DD
GradeLevelStringedfi.Descriptor.CodeValue via edfi.StudentSchoolAssociation.EntryGradeLevelDescriptorId
LimitedEnglishProficiency

String

edfi.Descriptor.CodeValue via edfi.Student.LimitedEnglishProficiencyDescriptorId

Replace null with "Not Applicable"
IsHispanic

Boolean

edfi.Student.HispanicLatinoEthnicity

Replace null with 0
SexStringedfi.SexType.CodeValue via edfi.Student.SexTypeId
LastModifiedDateDateTime

Most recent date from any source that has a LastModifiedDate column


Data Standard 3+

ColumnData TypeSourceDescription
StudentSchoolKeyString"{Student.StudentUniqueId}-{StudentSchoolAssociation.SchoolId}"Primary key
​StudentKeyStringedfi.Student.UniqueId​
SchoolKeyStringedfi.StudentSchoolAssociation.SchoolId
SchoolYearStringedfi.StudentSchoolAssocation.SchoolYearconvert to string to signal to modeling tools that this is not an aggregatable number
StudentFirstNameStringedfi.Student.FirstName
StudentMiddleNameStringedfi.Student.MiddleName
StudentLastNameString

edfi.Student.LastSurname


EnrollmentDateKeyStringedfi.StudentSchoolAssociation.EntryDateformatted as YYYY-MM-DD
GradeLevelStringedfi.Descriptor.CodeValue via edfi.StudentSchoolAssociation.EntryGradeLevelDescriptorId
LimitedEnglishProficiency

String

edfi.Descriptor.CodeValue via edfi.StudentEducationOrganizationAssociation.LimitedEnglishProficiencyDescriptorId

Replace null with "Not Applicable"
IsHispanic

Boolean

edfi.StudentEducationOrganizationAssociation.HispanicLatinoEthnicity

Replace null with 0
SexStringedfi.Descriptor.CodeValue via edfi.StudentEducationOrganizationAssociation.SexDescriptorId
LastModifiedDateDateTime

Most recent date from any source that has a LastModifiedDate column


Contents

  • No labels