Student Needs Export

Use

If run at the district level, choose one of the following from the pop-up menu:

• Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
• Current School Only – Includes all records associated with the current school that meet the selection criteria.
• District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Students to Include

Choose one of the following from the pop-up menu:

• The selected x students only – Run the report for students in the current selection.

• All Students (default) – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to runningreport.

Destination

Choose one of the following from the pop-up menu:

• Browser – Open the report results within the internet browser.
• Save as Local File (default) – Save the report results as a file on your hard drive.

Processing Options

Choose a time to run the report from the pop-up menu:

• Execute Now – Execute the report immediately.
• In Background Now (Recommended) – Execute the report immediately in the background.
• ASAP – Execute the report in the order it is received in the Report Queue.
• At Night – Execute the report during the next evening.
• On Weekend – Execute the report during the next weekend.
• On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10 AM : 05.

Data to be Filled

Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.

Select District

If this option is displayed, select a District from the pop-up menu.

School Yearterm

Choose the school year from the pop-up menu.

Include Student Demographic Detail

Select the checkbox to include student demographic data in the extract, including date of birth, gender, and ethnicity.

Check to include 011 Needs

Select the checkbox to include 011 Need records in the extract.

Restrict 011 to this need code(s)

Enter need code(s), comma-separated (without spaces), to limit the type of 011 Needs records included in the extract.

Check to include 012 Assessments

Select the checkbox to include 012 Assessment records in the extract.

Note: As offiscal year 2008-2009, 012 transactions are not generated for SAIS.

Restrict 012 to this assessment code(s)

Enter need code(s), comma-separated (without spaces), to limit the type of 012 Assessment records included in the extract.

Check to include 013 Language Programs

Select the checkbox to include 013 Language Program records in the extract.

Restrict 013 by this type

Choose Need Code or Program Code from the pop-up menu to specify the type of code you would like to enter to limit the types of 013 Language Program records included in the extract.

Restrict 013 to this assessment code(s)

Enter need or program code(s), comma-separated (without spaces), to limit the type of 013 Language Program records included in the extract.

Check to include 014 SPED Services

Select the checkbox to include 014 SPED Service records in the extract.

Restrict 014 by this type

Choose Need Code or Service Code from the pop-up menu to specify the type of code you would like to enter to limit the types of 014 SPED Service records included in the extract.

Restrict 014 to this code(s)

Enter need or service code(s), comma-separated (without spaces), to limit the type of 014 SPED Service records included in the extract.

Check to include 015 Support Programs

Select the checkbox to include 015 Support Program records in the extract.

Restrict 015 by this type

Choose Need Code or Program Code from the pop-up menu to specify the type of code you would like to enter to limit the types of 013 Language Program records included in the extract.

Restrict 015 to this code(s)

Enter need or program code(s), comma-separated (without spaces), to limit the types of 013 Language Program records included in the extract.

Check to include 021 Initial IEP

Select the checkbox to include 021 Initial IEP records in the extract.

Note: IEP information is no longer transacted to ADE. Historical data remains intact but past and future transactions are not generated.

Record Type Code

The type of Need transaction.

Valid values:

• 011 Need
• 012 Assessment
• 013 Language
• 014 SPED
• 015 Support
• 021 Initial IEP

N/A

School ID

The school ID.

[AZ_StudentNeed]SchoolID

Student ID

The student’s internal identification number.

[Students]ID

SAIS Student Number

The student’s SAIS ID.

[Students]State_StudentNumber

Student Number

The student’s locally assigned identifier.

[Students]Student_Number

Last Name

The student’s last name.

[Students]Last_Name

First Name

The student’s first name.

[Students]First_Name

DOB

The student’s date of birth.

Note: This field is included in the extract if the checkbox for “Include Student Demographic Detail” is selected at report runtime.

[Students]DOB

Gender

The student’s gender.

Note: This field is included in the extract if the checkbox for “Include Student Demographic Detail” is selected at report runtime.

[Students]Gender

Ethnicity

The student’s ethnicity.

Note: This field is included in the extract if the checkbox for “Include Student Demographic Detail” is selected at report runtime.

[Students]Ethnicity

Prog/Service Code

This field includes one of the following values:

• Language Program Code for 013 records
• SPED Service Code for 014 records
• Support Program Code for 015 records

[VirtualTablesData]user_defined_text2

Need Code

The Need code associated with 011, 013, 014, and 015 records.

[VirtualTablesData]user_defined_text

Date1

This field contains one of the following values:

• Entry Date for 011, 013, 014, and 015 records
• Assessment Date for 012 records
• Initial IEP Date for 021 records

[VirtualTablesData]user_defined_date

Date2

This field contains one of the following values:

• Exit Date for 011, 013, 014, and 015 records
• Proposed Service Initiation Date for 021 records

[VirtualTablesData]user_defined_date2

Primary Nighttime Residence

Primary Nighttime Residence is required for a need code of Homeless in fiscal year 2007 and forward.

[AZ_StudentNeed]AZ_PrimaryNighttimeResidence

[VirtualTablesData]user_defined_text2

Exit Reason

The reason the student exited 013 Language and 014 SPED Service programs.

[AZ_StudentNeed]AZ_SPED_ExitReasonCode

[VirtualTablesData]Custom

Language Status

The student’s language status for 013 Language Program records.

[AZ_StudentNeed]AZ_LanguageStatusCode

[VirtualTablesData]user_defined_text2

Grade Level

The student’s grade level while enrolled in the 014 SPED Service program.

Grade level for SPED Services is stored in PowerSchool independent of the student’s school enrollment grade level. If a correction to the school enrollment grade level is required, it is necessary to correct grade level for the appropriate SPED Services. SAIS began validating SPED and enrollment grade levels in fiscal year 2005.

[VirtualTablesData]user_defined_numeric

Special Enroll Code

The student’s special enroll code for 014 SPED Service records, if applicable.

[VirtualTablesData]SPEDSpEnrollmentCode

DOR

The student’s district of residence when enrolled in the 014 SPED Service program.

[VirtualTablesData]AZ_SPED_DOR

Federal Primary Need Indicator

Indicates whether this 014 SPED Service record is the student’s primary need.

Note: The student can only have one current “True” Federal Primary Need Indicator for all of their Student SPED Service Participation records for a particular date range.

[VirtualTablesData]AZ_FederalPrimaryNeedIndicator

CTDS ID

The receiving school CTDS, i.e. the school of choice the student attends.

This field is required when reporting a Transportation/School Choice support program.

[VirtualTablesData]AZ_Receiving_CTDS

Oral Assessment Date

The date of the student’s oral assessment. This field applies to 012 Assessment records.

Note: As of fiscal year 2008-2009, 012 transactions are not generated for SAIS.

[VirtualTablesData]user_defined_date

Oral Assessment Score

The student’s oral assessment score. This field applies to 012 Assessment records.

[VirtualTablesData]user_defined_text

Oral Proficiency Level

The student’s oral proficiency level. This field applies to 012 Assessment records.

[VirtualTablesData]user_defined_text2

Reading Assessment Date

The date of the student’s reading assessment. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_ReadingAssessmentDate

Reading Assessment Score

The student’s reading assessment score. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_ReadingAssessmentScore2

Reading Proficiency Level

The student’s reading proficiency level. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_ReadingAssessmentLevel

Writing Assessment Date

The date of the student’s writing assessment. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_WritingAssessmentDate

Writing Assessment Score

The student’s writing assessment score. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_WritingAssessmentScore2

Writing Proficiency Level

The student’s writing proficiency level. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_WritingAssessmentLevel

Overall Assessment Result

The student’s overall assessment result. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_OverallAssessmentResult

Overall Total Composite Scaled Score

The student’s overall total composite score. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_OverallTotComposScaledScore

Overall Proficiency Level

The student’s overall proficiency level. This field applies to 012 Assessment records.

[VirtualTablesData]AZ_OverallProficiencyLevel