Enrollments and Demographics

studentSchoolAssociation

This view captures student enrollments in schools in the current year as published in the StudentSchoolAssociation resource within the (Need to update category name) Enrollments and Demographics 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.

studentSchoolAssociation

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: students and graduationPlans.

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.

Need to update

Data Element	Description	Data Type	Stored in [Table]Field	Req’d
entryDate	The month, day, and year on which an individual enters and begins to receive instructional services in a campus.	Date	[Students]EntryDate (current) [ReEnrollments]EntryDate (historical) [S_TN_STU_ConcurrentEnroll_C]EntryDate	M
calendarReference
/calendarCode	Instructional Program Number Must be two character left padded integer between 1 and 99 inclusive Need to update	Sting	Need to update	O
/schoolId	Need to update	Int32	Need to update	R
/schoolYear	The school year for the District Calendar	Int32	Derived from: YearId for term selected in the PowerSchool UI and [DistrictCalendar]CalendarYear	R
classOfSchoolYearTypeReference/schoolYear	Need to update	Int32	Need to update	Need to update
graduationPlanReference graduationPlan is required if applicable; otherwise it is excluded from publishing. This complex type is reported for middle and high school students only; it is not reported for concurrent enrollments.
educationOrganizationId	For standard plans defined by an education organization, this is the reference to the organization defining the plan. Individualized plans do not require this reference.	Int32	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M Need to update
/graduationPlanTypeDescriptor	The graduation plan associated with the student enrolled in the school.	String	[S_TN_STU_X]CourseOfStudy [S_TN_REN_X]CourseOfStudy	M Need to update
/graduationSchoolYear	The graduation school year associated with the graduation plan.	Int32	[Students]ClassOf	M Need to update
schoolReference/schoolId	School enrolling the student.	Int32	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M
schoolYearTypeReference/schoolYear	Need to update	Int32	Need to update	Need to update
studentReference/studentUniqueId	Student enrolled in the school.	String	StudentUniqueId downloaded from State Derived from: [Students]DCID	Need to update
educationPlans/educationPlanDescriptor	Need to update	String	Need to update	Need to update
employedWhileEnrolled	Need to update	Boolean	Need to update	Need to update
entryGradeLevelDescriptor	The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.	String	Derived from: [S_TN_STU_X]TransitionalGrade [S_TN_REN_X]TransitionalGrade [Students]Grade_Level (current) [ReEnrollments]Grade_Level (historical) If the TransitionalGrade flag is set, then ‘T’ + grade level; else, grade level.	R
entryGradeLevelReasonDescriptor	Need to update	String	Need to update	Need to update
entryTypeDescriptor	The process by which a student enters a school during a given academic session.	String	[Students]EntryCode (current) [ReEnrollments]EntryCode (historical) [S_TN_STU_ConcurrentEnroll_C]EntryCode	R
exitWithdrawDate	The month, day, and year of the first day after the date of an individual's last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school. This element is required if applicable; otherwise it is excluded from publishing.	DateTime	[Students]ExitDate (current) [ReEnrollments]ExitDate (historical) [S_TN_STU_ConcurrentEnroll_C]ExitDate	Need to update
exitWithdrawTypeDescriptor	The circumstances under which the student exited from membership in an educational institution. This element is required if applicable; otherwise it is excluded from publishing.	String	[Students[ExitCode (current) [ReEnrollments]ExitCode (historical) [S_TN_STU_ConcurrentEnroll_C]ExitCode	Need to update
primarySchool	Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true.	Boolean	Derived from: [S_TN_STU_X]ISPToS [S_TN_REN_X]ISPToS P: ‘True’; else ‘False’	Need to update
repeatGradeIndicator	An indicator of whether the student is enrolling to repeat a grade level, either by failure or by an agreement to hold the student back. This element is required if applicable; otherwise it is excluded from publishing.	Boolean	Derived from: [S_TN_STU_X]EndofServiceAction R or D: ‘True’; else ‘False’	Need to update
residencyStatusDescriptor	Need to update	String	Need to update	Need to update
schoolChoiceTransfer	Need to update	String	Need to update	Need to update
_ext.tdoe/characteristicDescriptors	Need to update	String	Need to update	Need to update
_ext.tdoe/instructionalGradeLevels
/gradeLevelDescriptor	Need to update	String	Need to update	Need to update
/beginDate	Need to update	DateTime	Need to update	Need to update
/endDate	Need to update	DateTime	Need to update	Need to update
_ext.tdoefundingStatuses (0-many)				R
/fundingStatusDescriptor	The funding status of the student while enrolled at the associated school; an indication of whether the student is eligible for state funding.	Descriptor	[S_TN_STU_X]FundIneligStatus	R
/beginDate	The start date for the funding status.	DateTime	[S_TN_STU_X]FundIneligBeginDate	R
/endDate	The end date for the funding status.	DateTime	[S_TN_STU_X]FundIneligEndDate	O
_ext.tdoe/instructionalServicesDescriptors	The targeted assistance a student receives.	String	[S_TN_STU_TAInstrAssistance_C]AssistanceID	O
_ext.tdoe/supportServicesDescriptors	The student’s TA Support Service types	Descriptor	[S_TN_STU_TASupportAssistance_C]AssistanceID	O
_ext.tdoe/standardDays (1-many)				R
/totalInstructionalMinutes	The number of minutes for a full time student of this grade, expressed in minutes.	Int32	[S_TN_STU_X]StudentStandardDay [S_TN_REN_X]StudentStandardDay If blank: [S_TN_SCH_X]StndDayDuration	Need to update
/effectiveDate	The start date for this student’s standard day. This is the student’s first in-session day as of their school entry date	DateTime	[Calendar_Day]Date Derived from: Firstin-session day following student’s entry date.	Need to update
_ext.tdoe/associatedPrimarySchool/schoolId	Need to update	Int32	Need to update	Need to update
_ext.tdoe/submittedForSchoolYearTypeReference/schoolYear	Need to update	Int32	Need to update	Need to update
_ext.tdoe/submittedByEducationOrganizationReference/educationOrganizationId	Need to update	Int32	Need to update	Need to update

studentTransportations

This view captures information about student transportation as published in the StudentTransportation resource within the Student Enrollment category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level along with From/To School, Bus Number, Last Publish Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.