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.
|
Data Element |
Description |
Data Type |
Stored in [Table]Field |
Req’d |
|---|---|---|---|---|
|
educationOrganizationReference/educationOrganizationId |
Student enrolled in the school.
Need to update |
Int32 |
StudentUniqueId downloaded from State Derived from: [Students]DCID |
R |
|
studentReference/studentUniqueId |
Need to update |
String |
Need to update |
R |
|
addresses (1-many) (Need to update 1-many or 1-1) |
|
|
|
|
|
/addressTypeDescriptor |
Need to update |
String |
Need to update |
O |
|
/stateAbbreviationDescriptor |
Need to update |
String |
Need to update |
O |
|
/apartmentRoomSuiteNumber |
Need to update |
String |
Need to update |
O |
|
/buildingSiteNumber |
The number of the building on the site, if more than one building shares the same address. |
String |
|
|
|
/city |
The name of the city in which an address is located. |
String |
|
|
|
/countyFIPSCode |
|
String |
|
|
|
/doNotPublishIndicator |
|
Boolean |
|
|
|
/latitude |
|
String |
|
|
|
/longitude |
|
String |
|
|
|
/nameOfCounty |
The name of the county, parish, borough, or comparable unit (within a state) in which an address is located. |
String |
|
|
|
/postalCode |
The five- or nine-digit zip code portion of an address. |
String |
|
|
|
/streetNumberName |
The street number and street name or post office box number of an address. |
String |
|
|
|
/periods/beginDate |
|
DateTime |
|
|
|
/periods/endDate |
|
DateTime |
|
|
|
cohortYears (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/cohortYearTypeDescriptor |
|
String |
|
|
|
/schoolYearTypeReference/schoolYear |
The school year for the District Calendar |
Int32 |
|
|
|
disabilities(1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/disabilityDescriptor |
This descriptor defines a student’s impairment. |
String |
|
|
|
/disabilityDeterminationSourceTypeDescriptor |
|
String |
|
|
|
/disabilityDiagnosis |
|
String |
|
|
|
/orderOfDisability |
The order by the severity of the student's disabilities. 1- Primary, 2 - Secondary, etc. |
Int32 |
|
|
|
/designations/disabilityDesignationDescriptor |
|
String |
|
|
|
electronicMails (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/electronicMailTypeDescriptor |
The type of email listed for an individual. |
String |
|
|
|
/doNotPublishIndicator |
|
Boolean |
|
|
|
/electronicMailAddress |
The electronic mail (e-mail) address listed for an individual or organization. |
String |
|
|
|
/primaryEmailAddressIndicator |
|
Boolean |
|
|
|
hispanicLatinoEthnicity |
An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. The term, "Spanish origin," can be used in addition to "Hispanic or Latino." |
|
|
|
|
internationalAddresses (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/addressTypeDescriptor |
|
String |
|
|
|
/countryDescriptor |
|
String |
|
|
|
/addressLine1 |
|
String |
|
|
|
/addressLine2 |
|
String |
|
|
|
/addressLine3 |
|
String |
|
|
|
/addressLine4 |
|
String |
|
|
|
/beginDate |
|
DateTime |
|
|
|
/endDate |
|
DateTime |
|
|
|
/latitude |
|
String |
|
|
|
/longitude |
|
String |
|
|
|
languages (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/languageDescriptor |
|
String |
|
|
|
/languageUseDescriptor |
|
String |
|
|
|
limitedEnglishProficiencyDescriptor |
|
String |
|
|
|
loginId |
|
String |
|
|
|
oldEthnicityDescriptor |
|
String |
|
|
|
profileThumbnail |
|
String |
|
|
|
programParticipations (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/programTypeDescriptor |
|
String |
|
|
|
/beginDate |
|
DateTime |
|
|
|
/designatedBy |
|
String |
|
|
|
/endDate |
|
DateTime |
|
|
|
/programCharacteristics/ProgramCharacteristicDescriptor |
|
String |
|
|
|
races/raceDescriptor |
This value is prefixed with the namespace and code. Example: "races" : [ { "raceDescriptor" : "uri://tdoe.edu/RaceDescriptor#B" } ] |
String |
|
|
|
sexDescriptor |
|
String |
|
|
|
studentCharacteristics (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/studentCharacteristicDescriptor |
|
String |
|
|
|
/designatedBy |
|
String |
|
|
|
/periods/beginDate |
|
DateTime |
|
|
|
/periods/endDate |
|
DateTime |
|
|
|
studentIdentificationCodes (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/studentIdentificationSystemDescriptor |
|
String |
|
|
|
/assigningOrganizationIdentificationCode |
|
String |
|
|
|
/identificationCode |
|
String |
|
|
|
studentIndicators (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/indicatorName |
|
String |
|
|
|
/designatedBy |
|
String |
|
|
|
/indicator |
|
String |
|
|
|
/indicatorGroup |
|
String |
|
|
|
/periods/beginDate |
|
DateTime |
|
|
|
/periods/endDate |
|
DateTime |
|
|
|
telephones (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/telephoneNumberTypeDescriptor |
|
String |
|
|
|
/doNotPublishIndicator |
|
Boolean |
|
|
|
/orderOfPriority |
|
Int32 |
|
|
|
/telephoneNumber |
|
String |
|
|
|
/textMessageCapabilityIndicator |
|
Boolean |
|
|
|
tribalAffiliations/tribalAffiliationDescriptor |
|
String |
|
|
|
_ext.tdoe (1-many) (Need to update if 1-many for 1-1) |
|
|||
|
/entryDate |
|
DateTime |
|
|
|
/exitWithdrawDate |
|
DateTime |
|
|
|
/submittedForSchoolYearTypeReference/schoolYear |
|
Int32 |
|
|
|
/submittedByEducationOrganizationReference/educationOrganizationId |
|
Int32 |
|
|