A02 System Level

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
Filler	Filler	Filler	N/A	208	12	219