G01 - Special Education Level

Introduction

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

Selection criteria determine which database records are used in the report.

Student Selection

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.

Back to Top

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report All Schools – Run the report for the entire district. 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.
SFTP Connections	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.

Back to Top

Report Output

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.

ID	Data Element	Description	[Table]FieldName	Length
G001	Fiscal Year	The fiscal year of the record. The report extracts the year based on the last day in the current school calendar.	[Terms]LastDay	4
G002	Period	The reporting period. Always 1.	N/A	1
G003	System Code	The school system code. This is the district number in PowerSchool.	[Prefs]Value [Prefs]Name=districtnumber	3
G004	School Code	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.	[S_GA_STU_X]SchoolNumberOverride [S_GA_REN_X]SchoolNumberOverride [Schools]Alternate_School_Number [Schools]School_Number = [S_GA_STU_SpecialEd_C]SchoolID [Schools]School_Number = [Students]SchoolID	4
Filler	Filler	Filler	N/A	9
G006	Record Type	Identifies the record layout. Always G01.	N/A	3
G007	Event Code	Identifies the type of special education event.	[S_GA_STU_SpecialEd_C]EventCode	2
G008	Event Date	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.	[S_GA_STU_SpecialEd_C]EventDate	8
G009	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.	[S_GA_STU_SpecialEd_C]StudentPresent	1
G010	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.	[S_GA_STU_SpecialEd_C]ParentPresent	1
G011	GTID	The identification number assigned to each student to uniquely identify the student throughout his/her public education years in the Georgia public school system.	[Students]State_StudentNumber	10
Filler	Filler	Filler	N/A	50

Back to Top