The FES Payment Confirmation Reports are used to verify the FES (Family Empowerment Scholarship) data prior to sending the file to DOE.
DOE continues to provide districts with FES survey (prepayment) files, requiring the returned file to contain public school enrollment or withdrawal dates.
- Survey H responses reflect on September Payment File
- Survey I responses reflect on November Payment File
- Survey J responses reflect on February Payment File
- Survey K responses reflect on April Payment File
1. Use the Florida Reports > Florida Reports Setup > FES Payment File Upload tab to upload the appropriate FES Payment File to Focus.
2. Use the Florida Reports > Generate FES Extracts screen to generate the appropriate files to send to DOE.
3. From the Florida Reports menu, click FES Payment Confirmation Reports to check if the data fails any of the DOE edits.
The FES Payment Confirmation Reports work just like the DOE verification reports. If there are any errors, you can click on the specific error and drill down to see the actual records that are in error. You can correct the errors and rerun the Generate FES Extracts process to re-create the file for DOE.
4. Click FES Payment Data Reconciliation or FES Scholarship Verification to generate the report.
FES Payment Data Reconciliation runs off of FLORIDA_FES_PAYMENT table.
FES Scholarship Verification runs off of FLORIDA_FES_PREPAYMENT table.
5. Select the applicable Survey from the pull-down.
6. Click Refresh Report.
Once a tab/report is selected, you will see more information about the data and the errors. Data will be broken up into sections all starting with a gray arrow. The first column of information displays error numbers and percentages.
- If there are 0 errors, the font will be black, and the percentage of error-free data will be listed in parentheses as (100%) as shown in the image.
- If data for a section is 90% to 99% error-free, the font will be in blue.
- If a section is between 80% and 90% error-free, the font will be in yellow.
- If data for a section is less 80% error-free, the font will be in red.
The second column displayed next to the number of errors is a description of DOE rules and regulations. These descriptions will help explain what errors are being found in your data. As shown in the image, the error in blue explains: Student is enrolled in 3900 in Florida Demographic but is not in the payment files.
7. Click on the blue question marks at the end of each error description for a Query to generate the error report. When using run query for your districts site, use the provided query to return a list of errors that need correcting. Note: The same data returned here is listed under errors as explained in the next step.
8. For a list of the students containing incorrect data, click on either the gray arrow or the blue, yellow or red links.
a. To navigate back to the list of errors, click Go Back to Summary.
b. To edit the data and correct the error, click the Student name in the first column of the list.
Clicking the Student name opens a new window or tab (depending on browser settings) to Students > Student Info. From the Student Info screen, you can navigate to the tabs in which the incorrect information is housed.
When the information in question has been changed, be sure to Save the data before closing the window/tab and returning to the FES Payment Confirmation Reports.
Upon navigating back to the FES Payment Confirmation Reports screen, a pop-up will display asking if you'd like to Recover Options, i.e. go back to the report even though changes have been made. Click Recover Options to return the to the report.
Utilize the Search text box at the top of the panel by typing the name of a tab to quickly navigate from one tab to another.
To close the panel, click the X. Doing so will allow for more room on the screen, which will be helpful when viewing reports. To make the panel reappear, click the arrow where the panel used to display.
Data can be organized by clicking on any of the headers; click once for ascending results; click twice for descending results.
To make the report full screen, click on the expansion icon (four arrows) next to the Search text box. Once in full screen mode, click the icon again to exit full screen.
If looking for specific information housed within the resulting data, type the information in the Search text box provided and press Enter.
