Documentation for Administrators

EOY Processing

Updated on

The End of Year (EOY) Processing module aids users in updating student data for the new school year. Currently, the EOY Processing screen allows users to set the "Year Entered Ninth Grade" (year_entered_ninth) student field, update EOC scores and dates, and null the "Include Historic Test History" student field.

Setting the Year Entered Ninth Grade Student Field

1. In the Ohio Reports menu, click EOY Processing.

EOY Processing

2. Select the check box for Year Entered Ninth Grade.

This process will update any active student in the current school year selected, where the Year Entered Ninth Grade (year_entered_ninth) field IS NULL and the student’s current grade is 09 and the student doesn’t have a previous enrollment record with a grade level of 09.

EOY Processing

3. Select the Effective Date.

This date is compared against the student enrollment End_Date. Only student enrollment records where the End_Date is Null or <= with the date specified from this screen be processed. Select the desired month, day, and year from the provided pull-downs, or click the calendar icon for a calendar view.

4. Click Run Selected Processes.

When the process completes, Focus will display a confirmation as well as a summary of how many students had their records updated.

EOY Processing

To output SQL queries for review, and make no changes to the database, select Year Entered Ninth Grade, select Download SQL, and click Run Selected Processes. The file will download to your computer.

EOY Processing
Updating EOC Score and Dates

1. In the Ohio Reports menu, click EOY Processing.

EOY Processing

2. Select the check box for EOC Score/Dates.

EOY Processing

3. Select the Effective Date.

This date is compared against the student enrollment End_Date. Only student enrollment records where the End_Date is Null or <= with the date specified from this screen be processed. Select the desired month, day, and year from the provided pull-downs, or click the calendar icon for a calendar view.

4. Click Run Selected Processes.

EOY Processing

When the process completes, Focus will display a confirmation as well as a summary of how many students had their records updated.

To output SQL queries for review, and make no changes to the database, select EOC Score/Dates, select Download SQL, and click Run Selected Processes. The file will download to your computer.

EOY Processing
Nulling the "Include Historic Test History" Student Field

1. In the Ohio Reports menu, click EOY Processing.

EOY Processing

2. Select the check box for Null Historic Test History Checkbox.

This process will null the student field "Include Historic Test History."

EOY Processing

3. Select the Effective Date.

This date is compared against the student enrollment End_Date. Only student enrollment records where the End_Date is Null or <= with the date specified from this screen be processed. Select the desired month, day, and year from the provided pull-downs, or click the calendar icon for a calendar view.

4. Click Run Selected Processes.

EOY Processing

When the process completes, Focus will display a confirmation as well as a summary of how many students had their records updated.

To output SQL queries for review, and make no changes to the database, select Null Historic Test History Checkbox, select Download SQL, and click Run Selected Processes. The file will download to your computer.

EOY Processing
Viewing the Logs

1. In the Ohio Reports menu, click EOY Processing.

EOY Processing

2. To view the logs for the end of year processes, click Show Logs.

EOY Processing
Previous Article Attendance Summary
Next Article Ohio Reports Setup