A02 System Level (2019-20)
Introduction
The A02 - System Level report extracts district level PowerSchool data, including Title I information. One record is transmitted for each system.
Note: This report must be run for the entire district.
Selection Criteria
Selection criteria determine which database records are used in the report.
This report extracts data that is manually entered at the district level.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
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 _A02.txt will save the results to a file named 999201408010915_A02.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 a SFTP Connection for details on how to create a SFTP connection. |
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.
Layout ID | Data Element | Description | [Table]FieldName | Length | Start & End Positions | |
A201 | 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 | 1 | 4 |
A202 | Period | The reporting period. Always 1. | N/A | 1 | 5 | 5 |
A203 | System Code | The school system code. This is the district number in PowerSchool. | [Prefs]Value [Prefs]Name=districtnumber | 3 | 6 | 8 |
A204 | Record Type | Identifies the record layout. Always A02. | N/A | 3 | 9 | 11 |
A205 | Filler | Filler | N/A | 24 | 12 | 35 |
A207 | Title I Private School Code – Grade K | The number of Title I private school students in Grade K served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_GK | 6 | 36 | 41 |
A208 | Title I Private School Code – Grade 1 | The number of Title I private school students in Grade 1 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G1 | 6 | 42 | 47 |
A209 | Title I Private School Code – Grade 2 | The number of Title I private school students in Grade 2 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G2 | 6 | 48 | 53 |
A210 | Title I Private School Code – Grade 3 | The number of Title I private school students in Grade 3 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G3 | 6 | 54 | 59 |
A211 | Title I Private School Code – Grade 4 | The number of Title I private school students in Grade 4 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G4 | 6 | 60 | 65 |
A212 | Title I Private School Code – Grade 5 | The number of Title I private school students in Grade 5 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G5 | 6 | 66 | 71 |
A213 | Title I Private School Code – Grade 6 | The number of Title I private school students in Grade 6 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G6 | 6 | 72 | 77 |
A214 | Title I Private School Code – Grade 7 | The number of Title I private school students in Grade 7 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G7 | 6 | 78 | 83 |
A215 | Title I Private School Code – Grade 8 | The number of Title I private school students in Grade 8 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G8 | 6 | 84 | 89 |
A216 | Title I Private School Code – Grade 9 | The number of Title I private school students in Grade 9 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G9 | 6 | 90 | 95 |
A217 | Title I Private School Code – Grade 10 | The number of Title I private school students in Grade 10 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G10 | 6 | 96 | 101 |
A218 | Title I Private School Code – Grade 11 | The number of Title I private school students in Grade 11 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G11 | 6 | 102 | 107 |
A219 | Title I Private School Code – Grade 12 | The number of Title I private school students in Grade 12 served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1PSC_G12 | 6 | 108 | 113 |
A220 | Filler | Filler | N/A | 24 | 114 | 137 |
A222 | Title I School For Neglected Code – Grade K | The number of Title I students in grade K in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_GK | 6 | 138 | 143 |
A223 | Title I School For Neglected Code – Grade 1 | The number of Title I students in grade 1 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G1 | 6 | 144 | 149 |
A224 | Title I School For Neglected Code – Grade 2 | The number of Title I students in grade 2 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G2 | 6 | 150 | 155 |
A225 | Title I School For Neglected Code – Grade 3 | The number of Title I students in grade 3 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G3 | 6 | 156 | 161 |
A226 | Title I School For Neglected Code – Grade 4 | The number of Title I students in grade 4 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G4 | 6 | 162 | 167 |
A227 | Title I School For Neglected Code – Grade 5 | The number of Title I students in grade 5 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G5 | 6 | 168 | 173 |
A228 | Title I School For Neglected Code – Grade 6 | The number of Title I students in grade 6 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G6 | 6 | 174 | 179 |
A229 | Title I School For Neglected Code – Grade 7 | The number of Title I students in grade 7 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G7 | 6 | 180 | 185 |
A230 | Title I School For Neglected Code – Grade 8 | The number of Title I students in grade 8 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G8 | 6 | 186 | 191 |
A231 | Title I School For Neglected Code – Grade 9 | The number of Title I students in grade 9 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G9 | 6 | 192 | 197 |
A232 | Title I School For Neglected Code – Grade 10 | The number of Title I students in grade 10 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G10 | 6 | 198 | 203 |
A233 | Title I School For Neglected Code – Grade 11 | The number of Title I students in grade 11 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G11 | 6 | 204 | 209 |
A234 | Title I School For Neglected Code – Grade 12 | The number of Title I students in grade 12 in a local institution for neglected students served this year by this school system. | [Prefs]Value [Prefs]Name=GA_T1SFNC_G12 | 6 | 210 | 215 |
Filler | Filler | Filler | N/A | 4 | 216 | 219 |