ID Average Daily Attendance County Of Residence Report

Contents

Introduction

Extracts Average Daily Attendance for County Of Residence Reports.

Enter School District number in cell B1. School District Name will be displayed in cell B2, County name(s) will be displayed in cells A5 through A9, and Full-Term ADA per SDE records will be displayed in cell B11.
Enter ADA in cells B5 through B9. County names displayed are those counties within your school district boundaries. ADA for students not in these counties should be entered in “Other”. The total of cells B5 through B9 will be displayed in cell B10. This total should equal the amount displayed in cell B11. Any difference will be displayed in cell B12, which should be zero when completed.
Email (address in cell B25), Fax (number in cell B27), or print and mail (address in cells B29 through B32).

Report Input

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

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office. For this report, the Select Schools option is for troubleshooting purposes only.
Report Period	The school year for which data is reported. This value is manually selected at report runtime. Select a date with the format YYYY-YYYY for the year's record you want to pull.
SFTP Connections	Choose the appropriate SFTP connection from the pop-up menu to establish a remote connection from your PowerSchool server to a reporting authority. This option is not available for all users. You must set up remote connection to configure a connection to a secure remote server. Using this remote connection parameter in combination with a daily report scheduling option ensures that this report will be automatically sent to the state on a daily schedule. See the System Administrator User Guide on PowerSource for more information. Note: Remote connection requires PowerSchool 7.1.4 or higher.

Field

Description

Select Schools

Choose one of the following:

Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note:

The All Schools option is only available when running the report from the District Office.
For this report, the Select Schools option is for troubleshooting purposes only.

Report Period

The school year for which data is reported. This value is manually selected at report runtime. Select a date with the format YYYY-YYYY for the year's record you want to pull.

SFTP Connections

Choose the appropriate SFTP connection from the pop-up menu to establish a remote connection from your PowerSchool server to a reporting authority. This option is not available for all users.

You must set up remote connection to configure a connection to a secure remote server. Using this remote connection parameter in combination with a daily report scheduling option ensures that this report will be automatically sent to the state on a daily schedule. See the System Administrator User Guide on PowerSource for more information.

Note: Remote connection requires PowerSchool 7.1.4 or higher.

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.

Item #	Data Element	Description	[Table]FieldName	Field type	Field Length	Reqd
1	districtID	The school district's identifying number.	[Prefs]Value [Prefs]Name=districtnumber	Option Set	3	Yes
2	districtName	The official name for the school district.	[Prefs]Value [Prefs]Name=districtname	Varchar	50	Yes
3	County	The official name of the county.	[S_ID_REN_X]County_of_Residence	String	5	Yes
4	Full-Term ADA	Represented by YYYY-YYYY.	Calculated	Numeric
5	Total ADA	The total average daily attendance for the specified county.	Calculated	Numeric
6	Total ADA Per SDE Records	The total average daily attendance for the specified county per state department of education records.	Calculated	Numeric
7	Difference	The difference between the Total ADA per SDE and Total ADA, and it should always report 0.00.	Calculated	Numeric	N/A	N/A