PI-1563 Reconciliation Report

The PI-1563 Reconciliation report has been added to the WI state Reports page. This report is intended to assist districts with their September to January Pupil Count Reconciliation. The report will list students who enrolled between the September and January count dates and students who withdrew between those dates. Totals are provided by grade category and student detail is printed to assist with an audit.

Report Input

Field	Description
Data to be filled	Select Set All; this will store your selections for this report which is helpful when you need to submit a new file and you are unsure of how you created your last file.
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.
Date	Enter the Date – usually this is the Third Friday of September or the 2^nd Friday in January.
Trace (Internal Option)	Check the enabled button of you would like Trace Enabled. Do not need to Enable.
Include Query Output in Trace (Internal Option)	If Trace is enabled, you can enable the Query Output Row Number Limit. Do not need to set.
Query Output Row Number Limit (Internal Option)	If Trace is enabled, you can enable the Query Output Row Number Limit. Do not need to set.
Sample Dataset Mode (Internal Option)	You do not need to check this box.
Run Now	Click the Run Now button to run this report.
Submit	Click the submit button. You will be taken to the Report Queue. Once your file is complete, click on the complete button and you will have a PDF file to assist you in compiling your spreadsheet for the State.

Report Output

Item	Data Element	Description	Table [Field Name]	Length
1	Student	Student's Name	[Students].LastFirst	135
2	Entry Date	The entry date for the school enrollment	[Students].EntryDate or [Reenrollments]EntryDate	Date
3	Exit Date	The exit date for the school enrollment	[Students].ExitDate or [Reenrollments]ExitDate	Date
4	School	School	[Schools]Abbreviation	20
5	Grade	Student Grade Level	[Students]Grade_Level	10
6	Date of Birth	Student date of birth.	[Students]DOB	Date
7	Program Schedule	Program Schedule (K4 and Kindergarten students only)	[S_WI_STU_X ]Program_Schedule OR [S_WI_REN_X ]Program_Schedule	10
8	Address	The student’s address	[Students]Street, [Students]City, [Students]State, [Students]Zip
9	Resident Addition	For a list of valid values see the Appendix.	[S_WI_STU_PI1563_X ]Resident_Add OR [S_WI_REN_PI1563_X ]Resident_Add	14
10	Resident Reduction	For a list of valid values see the Appendix.	[S_WI_STU_PI1563_X ]Resident_Reduct OR [S_WI_REN_PI1563_X ]Resident_Reduct	14