Student Contacts

studentEducationOrganizationAssociation

This view captures student enrollments in schools in the current year as published in the StudentSchoolAssociation resource within the Student Enrollment category. The layout includes the School Name, Student Number, Student Name, Grade Level, Graduation Plan, Entry Date, Exit Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.

studentEducationOrganizationAssociation

This association represents the school in which a student is enrolled.

Primary PowerSchool Source Data

• [Students]
• [S_TN_STU_X]
• [ReEnrollment]
• [S_TN_REN_X]
• [S_TN_STU_ConcurrentEnroll_C]
• [S_TN_STU_TAInstrAssistance_C]
• [S_TN_STU_TASupportAssistance_C]

Selection Criteria

Records are published if the following criteria are met:

• The student was published in the Student category.
• StudentUniqueId must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The school must not be excluded from state reporting.
• The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.
• The enrollment ExitDate is greater than the EntryDate.

Resource Output

• A separate studentSchoolAssociation record is published for each student and school enrollment reflected in the [Students] and [Reenrollments] tables based on the year for the Term selected in the PowerSchool UI.
  • If the student is or was enrolled in a single school, one record is published.
  • If the student was enrolled in a single school, withdrew, and later re-enrolled in the same school, two records are published.
  • If the student was enrolled in multiple schools, or has a concurrent enrollment, a record is published for each enrollment.
• The graduationPlanReference complex type is included for high school students and, if available, for middle school students, but is not included for elementary students. It is also not included for concurrent enrollments.
• The studentSchoolAssociation resource is dependent on the prior publishing of the following resources: student and graduationPlan.

Note: After a student record is uploaded, it cannot be modified until a studentSchoolAssociation record has also been uploaded for the same student.

• • This establishes a relationship between the school, the associated LEA and the student.
  • The LEA then has permission to modify the previously uploaded student record.
• LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.