Skip to main content
Skip table of contents

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



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.


Enter the Date – usually this is the Third Friday of September or the 2nd 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.


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

ItemData ElementDescriptionTable [Field Name]Length
1StudentStudent's Name[Students].LastFirst135
2Entry DateThe entry date for the school enrollment

[Students].EntryDate or [Reenrollments]EntryDate

3Exit DateThe exit date for the school enrollment[Students].ExitDate or [Reenrollments]ExitDateDate
4SchoolSchool[Schools]Abbreviation 20
5GradeStudent Grade Level[Students]Grade_Level10
6Date of BirthStudent date of birth.[Students]DOBDate
7Program ScheduleProgram Schedule (K4 and Kindergarten students only)

[S_WI_STU_X ]Program_Schedule OR

[S_WI_REN_X ]Program_Schedule

8AddressThe student’s address[Students]Street, [Students]City, [Students]State, [Students]Zip
9Resident 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

10Resident 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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.