Student Enrollments

This category carries core and Arizona-specific information about student enrollments, FTE's, tuition payer status, and funding districts of residence. The Student Enrollment category includes the following data views and resources:

In many cases, enrollment start and end dates are derived from the PowerSchool student entry and exit dates. To output valid in-session dates, the Ed-Fi publishing routine automatically identifies the first and last in-session dates that fall between the PowerSchool entry and exit dates. Therefore, the published dates will not always correspond to the same dates seen within PowerSchool.

Student School

This view captures student enrollments in schools as published in the StudentSchoolAssociation entity within the Student Enrollment interchange. The layout includes the School Name, School ID, Student Number, Student Name, Grade Level, Entry Date, Entry Code, Exit Date, Exit Code, and Track, along with the SAIS Number, Last Publish Date, and the Publishing ID.

StudentSchoolAssociation

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

Primary PowerSchool Source Data

• [Students]
• [ReEnrollments]
• [S_AZ_STU_CONENR_C]
• [CC] (JTED)

Selection Criteria

Records are published if the following criteria are met:

• The student has been published in the Student Parent interchange.
• StudentUniqueId must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The school must not be excluded from state reporting.
• Regular Enrollments: the student has an enrollment record where the following conditions are met:
  • 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 ExitDate is greater than the EntryDate.
• Summer Withdrawals: the student has a summer withdrawal where the following conditions are met:
  • The Entry Date equals the Exit Date.
  • The Exit Code = 'Sxx' where 'xx' is numeric.
  • The Exit Date falls during the summer after the end date of the previous school year and before or equal to the start date for the current year at the student's school.
• JTED Enrollments: the student is enrolled in a JTED course and the following conditions are met:
  • The district is reporting JTED through Ed-Fi (flag set to true):
    • [Prefs]AzEDS_ReportJTED
    • [S_AZ_SUBDISTRICTS.AzEDS]ReportJTED for sub-district enabled servers
  • The student has a primary enrollment record that meets the selection criteria, with grade level 9 or above.
  • The JTED indicator on the enrollment record is true ([Students]/[ReEnrollments]JTED_Indicator = 1).
  • The student is enrolled in a JTED section ([Sections]JTED_Indicator = 1).
• Concurrent Enrollments: the student has a current-year enrollment where the following conditions are met:
  • Exit Date is greater than Entry Date.
  • The school must be a different school than the primary school for the date range.
  • The concurrent enrollment may overlap multiple primary school enrollments (and vice versa).
• Tuitioned-Out (Private Placement) Enrollments: the student has an enrollment record where the following conditions are met:
  • The student school enrollment Entry Date 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 ExitDate is greater than the EntryDate.
  • The student is enrolled in a school having an EnitityID = 00000
  • The student enrollment Entity ID Override field is populated ([Students]/[ReEnrollments]/[S_AZ_STU_CONENR_C]EntityID_Ovr)

Entity 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, a record is published for each enrollment.
• A separate StudentSchoolAssociation record is published for each summer withdrawal record meeting the required criteria.
  • Summer withdrawal records are independent of other StudentSchoolAssociation records.
  • The published exit date is one day prior to the date entered in PowerSchool to ensure the record is outside the current school year.
  • The summer exit indicates the end of the student's association with the referenced school.
• A separate StudentSchoolAssociation record is published for each concurrent enrollment record meeting the required criteria.
• A separate StudentSchoolAssociation record is published for each continuous set of one or more JTED enrollments.
  • Within a continuous Student School enrollment, a student could have one too many continuous JTED Enrollments
  • A student could be enrolled in multiple JTED Sections at the same time. This condition is reported as a single JTED School enrollment.
  • If a student is enrolled in two JTED sections and drops one section but is still enrolled in the other JTED section, this condition is considered a continuous JTED School enrollment.
  • If a student is enrolled in a JTED Section, drops the section, and is enrolled in another JTED Section with no 'in-session days between JTED Section enrollments, this is considered a continuous JTED School enrollment.
• A separate StudentSchoolAssociation record is published for each Tuitioned-Out (Private Placement) enrollment record meeting the required criteria.
• PowerSchool enrollments where contiguous records are for the same SchoolID and with exit/entry codes of 'PS' are joined together for Ed-Fi publishing into single enrollments that begin with a non-PS entry code and end with a non-PS exit code (including null exits).
• Published records will reflect changes in student Grade Level and Track even though the student's school of enrollment may not have changed.
• The StudentSchoolAssociation entity is dependent on the prior publishing of the following entities: Student.
  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	Required
StudentReference/StudentIdentity	StudentUniqueId - Student enrolled in the school.	Integer	[Students]State_StudentNumber	M
SchoolReference/SchoolIdentity	SchoolId - School enrolling the student.	Integer	SchoolId downloaded from State Derived from: [Students]EntityID_Ovr (current - override) [Students]SchoolID (current) [ReEnrollments]EntityID_Ovr (historical - override) [ReEnrollments]SchoolID (historical) [S_AZ_STU_CONENR]EntityID_Ovr (concurrent - override) [S_AZ_STU_CONENR]SchoolID (concurrent) [Students]JTED_School_CTDS (JTED) Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr	M
PrimarySchool	Indicates whether a given enrollment record should be considered the primary record for a student.	Boolean	[Students]EnrollmentType [S_AZ_STU_CONENR]EnrollmentType (concurrent) 'True is published if EnrollmentType = M; else 'False'	O
SchoolYear	SchoolYearType - The school year associated with the student's enrollment.	Enumerated List	[Terms]YearID	R
TrackReference Note: Track information is not reported for AOI schools and DRP enrollments.				R
/EducationOrganizationId	The education organization associated with the track – either the school or the district.	Integer	If a track number is available for the school, the SchoolId as downloaded from the state is published. Derived from: [Students]SchoolID [ReEnrollments]SchoolID [S_AZ_STU_CONENR]SchoolID [Students]JTED_School_CTDS If no track number is available for the school, then the district to which the school belongs is published. If multiple districts exist within the PowerSchool database: [S_AZ_SUBDISTRICTS] Otherwise, the LEAID is downloaded from the state. For Tuitioned-out students: If [CST_PUBORGANIZATION] StateOrgID = EntityID_Ovr in [S_AZ_STU_X], [S_AZ_REN_X], or [S_AZ_STU_CONENR_C] then [CST_PUBORGANIZATION]EduOrgID Otherwise, the LEAID as downloaded from the state. Note: For tuitioned-out schools, JTED enrollments, and any school where the district is reporting tracks on the behalf of another entity, the LEAID for the reporting district is published.	R
/SchoolYear	The school year associated with the track.	Enumerated List	[Terms]YearID	R
/TrackNumber	The track number associated with the education organization (school or district).	Integer	[CST_PUBORGTRACK_AZ]TrackNumber If multiple for school: [Students]Track [ReEnrollments]Track [S_AZ_STU_CONENR]Track A or NULL: '1' (default) B: '2' C: '3' D: '4' E: '5' F: '6'	R
EntryDate	The month, day, and year on which an individual enters and begins to receive instructional services on campus.	Date	[Students]EntryDate (current) [ReEnrollments]EntryDate (historical) [S_AZ_STU_CONENR]EntryDate (concurrent) [CC]EntryDate (JTED) First Day of enrollment in JTED Sections for the school year. Or, the first date of enrollment in a JTED Section after a break in continuous enrollment of any JTED Section.	M
EntryGradeLevel	GradeLevelDescriptor - 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.	Descriptor	[Students]Grade_Level (current) [ReEnrollments]Grade_Level (historical) [S_AZ_STU_CONENR]Grade_Level (concurrent) Grade_Level -2: 'UE' Grade_Level -1: 'PS' Grade_Level 0: 'KG'	R
EntryType	EntryTypeDescriptor - The process by which a student enters a school during a given academic session.	Descriptor	[Students]EntryCode (current) [ReEnrollments]EntryCode (historical) [S_AZ_STU_CONENR]EntryCoe(concurrent) If MembershipType = P then the value is blank. JTED: Entry Code from most recent school enrollment <= the reported EntryDate above, within the same term year. Default to E3 if cannot locate. Default to R1 after a W1 withdrawal from a JTED Enrollment.	C
ClassOfSchoolYear	SchoolYearType – The projected High School graduation year. Note: Only required for grades 9-12.	Enumerated List	[Students]ClassOf If blank, derived based on student's current grade level	C
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.	Date	[Students]ExitDate (current) [ReEnrollments]ExitDate (historical) [S_AZ_STU_CONENR]ExitDate(concurrent) [CC]ExitDate (JTED) Last day of continuous enrollment in JTED Sections. Summer withdrawals: The Exit Date is a date between the end of the previous school year and the start of the current school year.	C
ExitWithdrawType	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.	Descriptor	[Students[ExitCode (current) [ReEnrollments]ExitCode (historical) [S_AZ_STU_CONENR]ExitCode(concurrent) JTED: Exit Code from most school enrollment where school enrollment exitdate = CC exitdate, within the same term year. If JTED Exit Date is before the Student exit date, report W1. Translate a G exit code to C if Students / ReEnrollments exit code = G and exit dates match	C
ExitWithdrawReason	ExitWithdrawReasonDescriptor – The reason for the student's withdrawal.	Descriptor	[Students]Withdrawal_Reason_Code (current) [ReEnrollments]Withdrawal_ReasonCode (historical) [S_AZ_STU_CONENR] ]Withdrawal_ReasonCode (concurrent) JTED: Exit Reason from most recent school enrollment where school enrollment exitdate >= reported exit date within the same term year.	C
MembershipType	Identifies whether a school has primary responsibility for managing a specific student's curriculum or not. The 'P' code value will allow the reporting of students who are enrolled in a Special Education program but are not enrolled in a school.	Varchar (2)	[Students[EnrollmentType (current) [ReEnrollments]EnrollmentType (historical) [S_AZ_STU_CONENR]EnrollmentType(concurrent) M: 'Main' A: 'Ancillary' T: 'AOI' P: 'Program Only' G: 'Grand Canyon Diploma' JTED: always reported as 'Ancillary'
totalPlannedInstructionalHours	The total instructional hours from all JTED or CTED Main campuses satellite course enrollments. The Total Planned Insturctional CTED hours is published as 150 when the following conditions are true: Student has a single enrollment in all schools for the current year Total Planned Insturctional hours is more than zero and less than 150	String	[S_AZ_STU_CONENR_C]TotPlanInstHrsCTED [S_AZ_STU_X]TotPlanInstHrsCTED [S_AZ_REN_X]TotPlanInstHrsCTED If the fields do not have values for CTED Satellites the ‘highest ranked’ logic is used to determine which JTED/CTED class is used for Attendance reporting, If CTED Satellite FTE Value is blank or 0.25, then Total Planned Instructional Hours = Days Enrolled in Class that counts towards JTED times total Bell Schedule Minutes for the class. Each enrolled class that counts towards JTED for the reported enrollment is considered, then summed together. If  CTED Satellite FTE Value is blank or 0.50, then the same logic is applied for the two highest ranked classes. If  CTED Satellite FTE  0.75, three highest ranked classes are used If  CTED Satellite FTE is 1.00, four highest ranked classes are used
totalCommunityCollegeEnrolledCredits	The total community college enrolled credits earned.	String	[S_AZ_STU_CONENR_C]TotComColEnrredCTED [S_AZ_STU_X]TotComColEnrredCTED [S_AZ_REN_X]TotComColEnrredCTED

Student FTEs

This view captures a detailed list of Student FTEs successfully published to AzEDS in the StudentSchoolAssociationMembershipFTE entity within the Student Enrollment interchange. The layout includes the School Name, Student Number, Student Name, Grade Level, and SAIS Number along with the Start Date and End Date for each FTE status, Last Publish Date, and the Publishing ID.

StudentSchoolAssociationMembershipFTE

This entity publishes the membership full-time equivalency values for student enrollments with possible values from 0.25 to 1.25. At least one record is included for all students with a reportable current year school enrollment; additional records are published for students with multiple enrollments or with changes in FTE value during an enrollment.

Primary PowerSchool Source Data

• [Students]
• [ReEnrollments]
• [S_AZ_STU_CONENR_C]
• [CC] (JTED)

Selection Criteria

Records are published if the following criteria are met:

• The student has been published in the Student Parent interchange.
• 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.
• For JTED, the student is enrolled in a JTED course that meets the criteria outlined in the StudentSchoolAssociation section.

Entity Output

• At a minimum, a matching StudentSchoolAssociationMembershipFTE record is published for each StudentSchoolAssociation record.
• In addition, if a student's FTE value changes during any school enrollment, an additional record is published to report the new FTE value and its applicable dates.
• The StudentSchoolAssociationMembershipFTE entity is dependent on the prior publishing of the following entities: Student published concurrently with StudentSchoolAssociation.
• 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.

Student Tuition Payer

This view captures a detailed list of Student Tuition Payer statuses successfully published to AzEDS in the StudentSchoolAssociationTuition Payer entity within the Student Enrollment interchange. The layout includes the School Name, Student Number, Student Name, Grade Level, Tuition Payer status, and SAIS Number, along with the Start Date and End Date for each tuition status period, Last Publish Date., and the Publishing ID.

StudentSchoolAssociationTuitionPayer

This entity publishes the Tuition Payer status for student enrollments. At least one record is included for all students with a reportable current year school enrollment; additional records are published for students with multiple enrollments or with changes in Tuition Payer status during an enrollment.

Primary PowerSchool Source Data

• [Students]
• [ReEnrollments]
• [S_AZ_STU_CONENR_C]
• [CC] (JTED)

Selection Criteria

Records are published if the following criteria are met:

• The student has been published in the Student Parent interchange.
• 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.
• For JTED, the student is enrolled in a JTED course that meets the criteria outlined in the StudentSchoolAssociation section.

Entity Output

• At a minimum, a matching StudentSchoolAssociationTuitionPayer record is published for each StudentSchoolAssociation record.
• In addition, if a student's Tuition Payer status changes during any school enrollment, an additional record is published to report the new Tuition Payer value and its applicable dates.
• The StudentSchoolAssociationTuitionPayer entity is dependent on the prior publishing of the following entities: Student published concurrently with StudentSchoolAssociation.
• 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.

Student Special Enrollment

This view captures a detailed list of Student Special Enrollments successfully published to AzEDS in the StudentSchoolAssociationSpecialEnrollment entity within the Student Enrollment interchange. The layout includes the School Name, Student Number, Student Name, Grade Level, Special Enrollment Status, and SAIS Number, along with the Start Date and End Date of the special enrollment, Last Publish Date, and the Publishing ID

StudentSchoolAssociationSpecialEnrollment (optional)

This entity publishes enrollments associated with a special dispensation granted for membership, which allows the student to attend a school outside the student's normal district of residence. This entity is published only for students with special enrollments and is never published for JTED enrollments.

Primary PowerSchool Source Data

• [Students]
• [ReEnrollments]
• [S_AZ_STU_CONENR_C]

Selection Criteria

Records are published if the following criteria are met:

• The student has been published in the Student Parent interchange.
• 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 Special Enrollment Code that is greater than 0 and is associated with a school enrollment where the Entry Date 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.

Entity Output

• A StudentSchoolAssociationSpecialEnrollment record is published for each period of school enrollment associated with a Special Enrollment Code that is greater than 0.
• In addition, if a student's Special Enrollment Code changes during any school enrollment, an additional record is published to report the new Special Enrollment Code and its applicable dates.
• The StudentSchoolAssociationSpecialEnrollment entity is dependent on the prior publishing of the following entities: Student published concurrently with StudentSchoolAssociation.
• 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.

Student Funded DOR

This view captures a detailed list of Student Funded District of Residence (DOR) records successfully published to AzEDS in the StudentEducationOrganizationAssociation entity within the Student Enrollment interchange. The layout includes the School Name, Student Number, Student Name, Grade Level, Funded DOR, and SAIS Number, along with the Start Date and End Date for the funded DOR, Last Publish Date, and the Publishing ID.

StudentEducationOrganizationAssociation

This association indicates any relationship between a student and an education organization other than how the state views enrollment. For Arizona, this entity captures students' funding district(s) of residence.

Primary PowerSchool Source Data

• [Students]
• [ReEnrollments]
• [S_AZ_STU_CONENR_C]
• [CC] (JTED)

Selection Criteria

Records are published if the following criteria are met:

• The student has been published in the Student Parent interchange.
• 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.
• For JTED, the student is enrolled in a JTED course that meets the criteria outlined in the StudentSchoolAssociation section.

Entity Output

• To capture the funded District of Residence for each student school enrollment, a matching StudentEducationOrganizationAssociation record is published for each StudentSchoolAssociation record.
• In addition, if a student has a change in District of Residence during any school enrollment, a separate record is published to capture the change.
• The StudentEducationOrganizationAssociation entity is dependent on the prior publishing of the following entities: Student published concurrently with StudentSchoolAssociation.
• 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.