The G01 - Special Education Level report extracts student special education data. One record is transmitted for every student for each Special Education event during the fiscal year. A student can have multiple records within the same school and fiscal year.
This report uses PS_Enrollment - This view provides current student enrollment and previous enrollment information.
Selection criteria determine which database records are used in the report.
The report selects records from the [Students] or [ReEnrollments] table that meet the following criteria:
- The student is not excluded from state reporting.
- The student must be enrolled in the school included in the report.
- The student's school enrollment entry date must occur on or before the report end date.
- The student's school enrollment exit date must occur after the report start date.
- The student's school enrollment exit date must occur after the entry date.
Special Education Event Selection
The report selects records within the reporting period from the [S_GA_STU_SpecialEd_C] table that are associated with a student included in the report.
For help with navigation and running the report, see How to Find and Generate a Report.
If run at the district level, choose one of the following:
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.
Current Selection Students
Run the report for the current selection of students or all students.
Report Start Date
Enter the start date of the report. Note: Enter the date in a format of MM/DD/YYYY.
Report End Date
Enter the end date of the report. Note: Enter the date in a format of MM/DD/YYYY.
File Path and File Suffix
The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix. For example a report run at district 999 on August 1, 2014 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201408010915_AAA.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server.
Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.
Please refer to Setting Up an SFTP Connection for details on how to create a SFTP connection.
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
The students with Dexter Mosely set as Yes in the State Information page are not included in the report output.
The fiscal year of the record.
The report extracts the year based on the last day in the current school calendar.
The reporting period.
The school system code. This is the district number in PowerSchool.
The school code. If the report is run district wide, the school code of each student’s current enrollment is reported.
Note: If the HomeSchool Override Number is set up, it will be used. If not, the alternate school number is reported if populated. Otherwise, the school number is reported.
[Schools]School_Number = [S_GA_STU_SpecialEd_C]SchoolID
[Schools]School_Number = [Students]SchoolID
Identifies the record layout.
Identifies the type of special education event.
The date that the special education event occurred.
Note: The Georgia DOE maintains a history of special education events reported for prior school years. Events with codes 01 – 06 remain static after being reported the first time – additional 01 – 06 events are ignored. Some edits compare new event records to the history records in order to properly validate current year dates.
Student Present at Conference
Indicates whether the student was present at the special education conference/meeting.
Note: This field must extract Y or N for event codes 05 and 07 when the student is either in grade 9-12 or at least 16 years old.
Parent Present at Conference
Indicates whether the parent was present at the special education conference/meeting.
Note: This field must extract Y or N if the event code is 07.
The identification number assigned to each student to uniquely identify the student throughout his/her public education years in the Georgia public school system.