Student Programs

This data category presents information about student needs along with student language, support, and special education program participation. The Student Program interchange includes the following data views and resources:

Student Needs

This view captures a detailed list of student needs successfully published to AzEDS in the StudentNeeds entity within the Student Program interchange. The layout includes the School Name, Student Number, Student Name, and SAIS Number, along with the Entry Date, Exit Date, Primary Need indicator, Need Type, Last Publish Date, and the Publishing ID.

StudentNeeds

This entity represents the Arizona collection of Student Needs. "Need" is a term used to indicate that a student requires special support, either within or beyond regular norms, to enhance their capabilities. Need types include language, special education (SPED), giftedness, economic, food service eligibility, behavioral, health, and academic StudentNeeds records are based on the AZ_StudentNeed virtual table and are also generated from student program participation records.

Primary PowerSchool Source Data

[AZ_StudentNeed] / [VirtualTablesData]
[AZ_StudentLanguageProgramParticipation] / [VirtualTablesData]
[AZ_StudentSupportProgramParticipation] / [VirtualTablesData]
[AZ_StudentSPED_Service] / [VirtualTablesData]

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 reporting the need must not be excluded from state reporting.
The student has a record for at least one Need with a valid state code and a Need Entry Date that falls within the year for the term selected in the PowerSchool UI.

Or

The student has a participation record with a start date within the year for the term selected in the PowerSchool UI in one of the following program virtual tables: AZ_StudentLanguageProgram, AZ_StudentSupportProgram, or AZ_StudentSPED_Service.
The need must refer to a StudentNeed descriptor value downloaded from the State.

Entity Output

A StudentNeeds record is published per need for each student who meets the required criteria as long as the student has at least one need that also meets the selection criteria.
If a student has more than one need, or more than one period of enrollment for a need, a separate record is published for each.
The StudentNeeds entity is dependent on the prior publishing of the following entities: Student.
StudentNeeds records are not published for Stand-alone programs with a Need Code of 'NOND' (CEIS and 21st Century are stand-alone programs).
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
ReportingEducationOrganizationReference	ReportingEducationOrganizationId – The school reporting the student need.	Integer	SchoolId Derived from: [AZ_StudentNeed]SchoolId [AZ_StudentLanguageProgramParticipation]SchoolId [AZ_StudentSupportProgramParticipation]SchoolId [AZ_StudentSPED_Service] SchoolId [VirtualTablesData]SchoolID For Tuitioned-Out Students, SchoolID is output based on: EntityID_Ovr in [Students], [ReEnrollments], or [S_AS_STU_CONENR_C]	M
StudentReference/StudentIdentity	StudentUniqueId - The student associated with the program.	Integer	[Students]State_StudentNumber Derived from: [AZ_StudentNeed]StudentId [AZ_StudentLanguageProgramParticipation] StudentId [AZ_StudentSupportProgramParticipation] StudentId [AZ_StudentSPED_Service] StudentId [VirtualTablesData]ForeignKey	M
StudentNeed	StudentNeedDescriptor – The student's Need condition or type of need.	Descriptor	Derived from: [AZ_StudentNeed]NeedCode [VirtualTablesData]user_defined_text Or, if the source is a program record derived from the Program Record Type.	M
StudentNeedEntryDate	The date the student entered the state of having the need.	Date	Derived from: [AZ_StudentNeed]EntryDate [AZ_StudentLanguageProgramParticipation]EntryDate [AZ_StudentSupportProgramParticipation] EntryDate [AZ_StudentSPED_Service] EntryDate [VirtualTablesData]user_defined_date	R
StudentNeedExitDate	The date the student exited the state of having the need.	Date	Derived from: [AZ_StudentNeed]ExitDate [AZ_StudentLanguageProgramParticipation]ExitDate [AZ_StudentSupportProgramParticipation] ExitDate [AZ_StudentSPED_Service] ExitDate [VirtualTablesData]user_defined_date2	C
PrimaryStudentNeedIndicator	For special education service records, an indicator of whether the record is the student's primary need for federal reporting purposes.	Boolean	[AZ_StudentSPED_Service]AZ_FederalPrimaryNeedIndicator [VirtualTablesData]Custom	C
primaryNightTimeResidenceIndicator	Provides specific nighttime residence status for a homeless student.		[AZ_StudentNeed]AZ_PrimaryNighttimeResidence [VirtualTablesData]user_defined_text2 1 – Sheltered 2 – Doubled Up 3 – Unsheltered 4 – Hotel/Motel Populated when [AZ_StudentNeed]NeedCode is 'Homeless'.

Back to top

Student Programs

This view captures a detailed list of student program associations successfully published to the AzEDS in the StudentProgramAssociation entity within the Student Program interchange. The layout includes the School Name, Student Number, Student Name, and Grade Level, along with the Program Type, Program Name, Entry Date, Exit Date, Exit Reason, SAIS Number, Last Publish Date, and the Publishing ID.

ELL, Grand Canyon Diploma, Dropout Recovery, and Support Programs are published within the StudentProgramAssociation entity. Special Education programs are published in a separate entity.

StudentProgramAssociation

This association represents the program(s) that a student participates in or is served by.

Primary PowerSchool Source Data

ELL: [AZ_StudentLanguageProgramParticipation] / [VirtualTablesData]
Support: [AZ_StudentSupportProgramParticipation] / [VirtualTablesData]
Grand Canyon Diploma: [S_AZ_STU_GCD_C]
Dropout Recovery: [S_AZ_STU_DRP_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 reporting the Program must not be excluded from state reporting.
The program record corresponds to a StudentNeeds record (note: not all StudentNeeds records require a program, but all program records, except standalone support programs, require a StudentNeed), or to a record for the Grand Canyon Diploma or Dropout Recovery Program.
- Student Needs records are not published for standalone support programs. These include CEIS and CCLC programs.
The student has a record for at least one Language Program, Grand Canyon Diploma, Dropout Recovery Program, or Support Program with a valid state code and with an Entry Date that falls within the year for the term selected in the PowerSchool UI.

Entity Output

A StudentProgramAssociation record is published for each student who meets the required criteria as long as the student has at least one Program that also meets the selection criteria.
If a student participates in more than one Program, or has more than one period of enrollment in a Program, a separate ProgramReference is published for each.
The StudentProgramAssociation entity is dependent on the prior publishing of the following entities: Student, published concurrently with StudentNeeds.
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
StudentReference/StudentIdentity	StudentUniqueId - The student associated with the program.	Integer	[Students]State_StudentNumber Derived from: [AZ_StudentLanguageProgramParticipation] StudentId [AZ_StudentSupportProgramParticipation]StudentId [VirtualTablesData]ForeignKey [Students]StudentId	M
ProgramReference/ProgramIdentity (1-many) The program(s) associated with the student.				M
/ProgramType	ProgramType - The type of program.	Enumerated List	Derived from: [AZ_StudentNeed]NeedCode [VirtualTablesData]user_defined_text If LEPS: 'ELL'; else 'Support Program' [S_AZ_STU_GCD_C]ProgramCode 'GCD': 'Grand Canyon Diploma'	M
/ProgramName	The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Varchar(60)	Language Programs: [AZ_StudentLanguageProgramParticipation]LangProgramCode [VirtualTablesData]user_defined_text2 A: 'A4 Structured English Immersion (SEI) 4-Hour Model' A2: 'A2 Structured English Immersion (SEI) 2-Hour Model' A3: 'A3 Structured English Immersion (SEI) 3-Hour Model' A4: 'A4 Structured English Immersion (SEI) 4-Hour Model' B1: 'B1 Bilingual/Dual Language with Waiver 1' B2: 'B2 Bilingual/Dual Language with Waiver 2' B3: 'B3 Bilingual/Dual Language with Waiver 3' IP: 'IP Individual Language Learner Plan (ILLP)' PW: 'PW Parent Withdrawn ELL' Bilingual Summer: 'Bilingual Summer' Support Programs: [AZ_StudentSupportProgramParticipation]SupportProgramCode [VirtualTablesData]user_defined_text2 21: '21 21st Century program' 22: '22 Homeless' 23: 'Migrant Academic Support' 24: '24 Migrant Health, Eye and Dental Services' 25: '25 Migrant Support Services-Nonacademic' 26: '26 Neglected or Delinquent Program Services' 27: '27 School Improvement Supplemental Education Services' 28: '28 Title I Mathematics' 29: '29 Title I Other' 30: '30 Title I Reading' 31: '31 Title I Science' 32: '32 Title I Social Studies' 33: '33 Transportation/ Migrant 34: '34 Transportation/ School Choice' 35: '35 Gifted Program' 36: '36 Johnson-O'Malley Indian Education' 37: '37 Failing Schools Tutoring Program' 38: '38 Title I Vocational / Career' 39: '39 Title I Health, Dental and Eye Care' 40: '40 Title I Supporting Guidance / Advocacy' 41: '41 Title I Other Support Services' IM: 'IM Immigrant Need dummy program' CE-RE: 'Coordinated Early Intervening Services - Reading' CE-MA: 'Coordinated Early Intervening Services - Math' CE-BE: 'Coordinated Early Intervening Services - Behavior' CE-OT: 'Coordinated Early Intervening Services - Other' 21CCLC: '21st CCLC' 21st Century programs pre-FY22: Cyc15: '21st Century Community Learning Centers Cycle 15 - New' CtYr2: '21st Century Community Learning Centers Cont-Yr2' CtYr3: '21st Century Community Learning Centers Cont-Yr3' CtYr4: '21st Century Community Learning Centers Cont-Yr4' CtYr5: '21st Century Community Learning Centers Cont-Yr5' Grand Canyon Diploma: [S_AZ_STU_GCD_C]ProgramCode GCD : 'GCD Grand Canyon Diploma'; else 'Unknown'	M
/ProgramEducationOrganizationReference/ EducationOrganizationIdentity	ProgramEducationOrganizationId – The Education Organization defining the program; reported as the LEAId.	Integer	LEAId - Data element downloaded from State Derived from: [Prefs] value where Name = AZLEAEntityId For Tuitioned-Out Students, output is based on: [S_AZ_STU_CONENR_C]EntityID_Ovr	M
BeginDate	The month, day, and year on which the student first received services.	Date	[AZ_StudentLanguageProgramParticipation]EntryDate [AZ_StudentSupportProgramParticipation]EntryDate [VirtualTablesData]user_defined_date [S_AZ_STU_GCD_C]EntryDate	M
EndDate	The month, day, and year on which the student exited the program or stopped receiving services.	Date	[AZ_StudentLanguageProgramParticipation]ExitDate [AZ_StudentSupportProgramParticipation]ExitDate [VirtualTablesData]user_defined_date2 [S_AZ_STU_GCD_C]ExitDate	O
ReasonExited	ReasonExitedDescriptor - The reason the child left the program within a school or district. This element is required if the student exited the program.	Descriptor	[AZ_StudentLanguageProgramParticipation]AZ_ProgramExitReasonCode [VirtualTablesData]Custom [S_AZ_STU_GCD_C]ExitReasonCode	C
EducationOrganizationReference/ EducationOrganizationIdentity	EducationOrganizationId - The education organization where the student is participating in or receiving the program services.	Integer	SchoolId - Data element downloaded from State Derived from: [AZ_StudentLanguageProgramParticipation]SchoolId [AZ_StudentSupportProgramParticipation]SchoolId [VirtualTablesData]SchoolId [S_AZ_STU_GCD_C]SchoolId For Tuitioned-Out Students, SchoolID is output based on: EntityID_Ovr in [Students], [ReEnrollments], or [S_AS_STU_CONENR_C]	M

Back to top

Student Dropout Recovery Program

This view captures a detailed list of student program associations successfully published to the AzEDS in the StudentProgramAssociation entity within the Student Program interchange. The layout includes the School Name, Grade Level, Written Learning Plan Date, Entry Date, End Date, Exit Reason, Last Publish Date, and the Publishing ID.

StudentDropOutRecoveryProgramAssociation

This association is an Arizona extension of StudentProgramAssocation reporting additional details for participants in the Dropout Recovery Program.

Primary PowerSchool Source Data

[S_AZ_STU_DRP_C]
[S_AZ_ DRP_PROGRESS_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 reporting the Program must not be excluded from state reporting.
The student has a published record for the Dropout Recovery Program reported in the StudentProgramAssocation entity.

Entity Output

A StudentDropoutRecoveryProgramAssociation record is published for each student who meets the required criteria.
If a student participates in more than one Dropout Recovery Program, or has more than one associated Progress record, a separate ProgramReference is published for each.
The StudentDropoutRecoveryProgramAssociation entity is dependent on the prior publishing of the following entities: Student, StudentProgramAssocation.
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
StudentProgramAssociationReference/StudentProgramAssociationIdentity Relates the student and program associated with the				M
/StudentReference/StudentIdentity	StudentUniqueId – The student associated with the program.	Integer	[Students]State_StudentNumber Derived from: [S_AZ_STU_DRP_C]StudentsDCID	M
/ProgramReference/ProgramIdentity The program associated with the student.				M
//ProgramType	ProgramType- The type of program.	Enumerated List	Derived from: [S_AZ_STU_DRP_C]ProgramCode DRP: 'Dropout Recovery Program'	M
//ProgramName	The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Varchar(60)	Derived from: [S_AZ_STU_DRP_C]ProgramCode DRP: 'DRP Dropout Recovery Program'; else 'Unknown'	M
//ProgramEducationOrganizationReference/ EducationOrganizationIdentity	ProgramEducationOrganizationId – The Education Organization defining the program; reported as the LEAId.	Integer	LEAId - Data element downloaded from State Derived from: [Prefs] value where Name = AZLEAEntityId For Tuitioned-Out Students, output is based on: [S_AZ_STU_CONENR_C]EntityID_Ovr	M
/BeginDate	Month, day, and year of the student's entry or assignment to the program.	Date	[S_AZ_STU_DRP_C]EntryDate	M
/EducationOrganizationReference/ EducationOrganizationIdentity	EducationOrganizationId - The education organization where the student is participating in or receiving the program services.	Integer	SchoolId - Data element downloaded from State Derived from: [S_AZ_STU_DRP_C]SchoolId For Tuitioned-Out Students, SchoolID is output based on: EntityID_Ovr in [Students], [ReEnrollments], or [S_AS_STU_CONENR_C]	M
WrittenLearningPlanDate	The date the Written Learning Plan was approved. Note: A new Written Learning Plan date indicating preparation of a new plan must be submitted each academic (fiscal) year.	Date	[S_AZ_DRP_PROGRESS_C]PlanDate	M
Month	MonthDescriptor – The month in which the LEA is reporting student enrollment in the DRP. This transaction must be submitted each month that the student is enrolled in the DRP regardless of the student's progress.	Descriptor	[S_AZ_DRP_PROGRESS_C]Month 1: July 2: August 3: September 4: October 5: November 6: December 7: January 8: February 9: March 10: April 11: May 12: June	M
SatisfactoryProgress	Indicates whether student maintained satisfactory progress during the month prior to this transaction ("Y" or "N").	Boolean	[S_AZ_DRP_PROGRESS_C]SatisfactoryProgress If 1: 'True'; else 'False'	M

Back to top

Student Special Ed Programs

This view captures a detailed list of student special education program associations successfully published to AzEDS in the Student Program interchange. The layout includes the School Name, Student Number, Student Name, and Grade Level, along with the Program Name, Begin Date, End Date, SAIS Number, Last Publish Date, and the Publishing ID.

StudentSpecialEducationProgramAssociation

This association represents the Special Education program(s) that a student participates in or receives services from.

Primary PowerSchool Source Data

[AZ_StudentSPED_Service] / [VirtualTablesData]

Selection Criteria

Records are published if the following criteria are met:

The student was previously published in the Student Parent interchange.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The school reporting the Program must not be excluded from state reporting.
The program record corresponds to a StudentNeeds record (Note: Not all StudentNeeds records require a program, but all program records require a StudentNeed).
The student has at least one record for a Special Education Program with a valid state code and with an Entry Date that falls within the year for the term selected in the PowerSchool UI.

Entity Output

A StudentSpecialEducationProgramAssociation record is published for each student who meets the required criteria.
If a student participates in more than one Special Education Program, or has more than one period of enrollment in a Special Education Program, the records are merged and reported as one resource if the following criteria is met:
- The programs have the same SPED code.
- The programs have the same MainSPEDSchool flag (Primary or Secondary).
- The program dates overlap.

Notes:

The merged records use the start date of the record with the earliest overlapping start date, and the exit date and exit code of the record with the latest overlapping exit date.
For the 2016/2017 school year and greater: If the ExitDate of a SPED record has an ExitCodeReason of '99', then no exit date or exit reason is published for the Special Education Program. An ExitCode of '99' denotes the student is exiting the Need, but is continuing in the SPED program under another Need.
If a student participates in more than one Special Education Program, or has more than one period of enrollment in a Special Education Program, and the records do not meet the above criteria, a separate record is published for each program.
The StudentSpecialEducationProgramAssociation entity is dependent on the prior publishing of the following entities: Student, published concurrently with StudentNeeds.
LEAs and Schools may upload (publish) data to the ODS 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
StudentReference/StudentIdentity	StudentUniqueId - The student associated with the program.	Integer	[Students]State_StudentNumber Derived from: [AZ_StudentSPED_Service]StudentId [VirtualTablesData]ForeignKey	M
ProgramReference/ProgramIdentity The special education Program associated with the student.				M
/ProgramType	ProgramType - The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Enumerated List	'Special Education'	M
/ProgramName	The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Varchar(60)	[AZ_StudentSPED_Service] SPEDServiceCode [VirtualTablesData]user_defined_text2 PA1: 'PA1 Early childhood program at least 10 hours/week' PA2: ' PA2 Early childhood program at least 10 hours/week' PB1: 'Early childhood program less than 10 hours/ week' PB2: 'PB2 Early childhood program less than 10 hours/ week' PD: 'PD Separate Class' PE: 'PE Public or Private Separate Day School' PG: 'PG Public or Private Residential Facility' PH1: 'PH1 Home at least 360 minutes per week' PH2: 'PH2 Home less than 360 minutes per week' PJ: 'PJ Private School Placement by Parents' PS: 'PS Service Provider Location for Less Than 360 Minutes/Week' A: 'A Inside Regular Class 80% or More' B: 'B Inside Regular Class 40 - 79%' C: 'C Inside Regular Class Less Than 40%' D: 'D Public or Private Separate Day School' E: 'E Public or Private Residential Facility' EA: 'EA Public or Private Residential Facility' EB: 'EB Public or Private Residential Facility' EC: 'EC Public or Private Residential Facility' FA: 'FA Correctional Facilities A' FB: 'FB Correctional Facilities B' FC: 'FC Correctional Facilities C' H: 'H Homebased/ Homebound / Hospital Program' I: 'I Services Provided in a Regular Classroom' J: 'J Private School Placement by Parents'	M
/ProgramEducationOrganizationReference/ EducationOrganizationIdentity	ProgramEducationOrganizationId – The Education Organization defining the program; reported as the LEAId.	Integer	LEAId - Data element downloaded from State Derived from: [AZ_StudentSPED_Service]SchoolId [VirtualTablesData]SchoolId For Tuitioned-Out Students, output is based on: [S_AZ_STU_CONENR_C]EntityID_Ovr	M
BeginDate	The month, day, and year on which the student first received services.	Date	[AZ_StudentSPED_Service]EntryDate [VirtualTablesData]user_defined_date	M
EndDate	The month, day, and year on which the student exited the program or stopped receiving services.	Date	[AZ_StudentSPED_Service]ExitDate [VirtualTablesData]user_defined_date2	O
ReasonExited	ReasonExitedDescriptor - The reason the child left the program within a school or district. This element is required if the student exited the program.	Descriptor	[AZ_StudentSPED_Service]AZ_SPED_ExitReasonCode [VirtualTablesData]Custom	C
EducationOrganizationReference/ EducationOrganizationIdentity	EducationOrganizationId - The education organization where the student is participating in or receiving the program services.	Integer	SchoolId - Data element downloaded from State Derived from: [AZ_StudentSPED_Service]SchoolId [VirtualTablesData]SchoolId For Tuitioned-Out Students, SchoolID is output based on: EntityID_Ovr in [Students], [ReEnrollments], or [S_AS_STU_CONENR_C]	M
ServedOutsideOfRegularSession	Indicates whether the student received services during the summer session or between sessions.	Boolean	Derived from: [AZ_StudentSPED_Service]SPEDServiceCode [VirtualTablesData]user_defined_text2 If SPEDServiceCode = I or PA1: 'False'; else 'True'	O
SpecialEducationSetting	SpecialEducationSettingDescriptor - The major instructional setting (more than 50 percent of a student's special education program).	Descriptor	[AZ_StudentSPED_Service]SPEDServiceCode [VirtualTablesData]user_defined_text2	R
MainSPEDSchool	Identifies the school's role in providing SPED services to the student. The 'P' (primary) and 'S' (secondary) indicators identify the extent of the school's responsibility for determining and case managing the student's SPED needs and curriculum.	Boolean	[AZ_StudentSPED_Service]AZ_ConcurrencyType [VirtualTablesData]Custom If AZ_ConcurrencyType = P: 'True'; else 'False'	C

Back to top