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.
1. In the Ohio Reports menu, click 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.
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.
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.
1. In the Ohio Reports menu, click EOY Processing.
2. Select the check box for EOC Score/Dates.
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.
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.
1. In the Ohio Reports menu, click EOY Processing.
2. Select the check box for Null Historic Test History Checkbox.
This process will null the student field "Include Historic Test History."
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.
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.
1. In the Ohio Reports menu, click EOY Processing.
2. To view the logs for the end of year processes, click Show Logs.
