In this lesson you will earn how to export lists of errors and warnings from Error on the Web (ERW) for your most recent enrollment file submission.
Transcript
Welcome to the Error Resolution on the Web Export Tutorial! Today, you will learn how to export the list of Clearinghouse Errors and Warnings, from the Error Resolution on the Web site, generated from your current enrollment file submission.
Select the received date to view the Error Resolution report.
Here, you will see your error report, along with the errors and warnings that were generated, from your current enrollment file submission. You can download a spreadsheet of errors and warnings from your current file submission. This downloaded list can be saved for audit purposes and can also be leveraged to update your institution’s Student Information System as needed. Select the Download Error resolution Report button. Please note, the errors and warnings that you see listed, at the time of selecting the download error resolution report button, will be the errors and warnings that are downloaded on the spreadsheet. So as you work through the errors and warnings, the errors and warnings that are actually listed on the downloaded report may change.
Once you have downloaded the errors and warnings that you wish to retain from your Error resolution report, you will be presented with a spreadsheet with 4 different tabs. This first tab, Instructions, provides you an outline of the report as well as what type of information each tab contains. We highly encourage you to read the instructions under the instructions tab in its entirety.
The next tab, Submission info, provides you General Submission information of your current enrollment file submission, a link to our programming and testing guide for your convenience, as well as a Timestamp of when this errors and warnings spreadsheet was downloaded, and by which user. You are also provided with a breakdown of the errors and warnings that were exported, at the time of download.
This next tab, Errors Resolution Report, provides you the records that have been flagged with an error, along with which error code they were flagged with, during the time of download. You can compare the program level information with previously submitted program level data. Which includes the Program Begin Date, Program Enrollment Status, Program Enrollment Status Effective Date, Unreported Program Begin Date, Unreported Program Enrollment Status, and Unreported Program Enrollment Status Effective Date. Please note, only one error will display at a time for a record, with the exception of Error codes 29 and 1568. Also this spreadsheet should not be used to correct data present on your error report to be submitted back to the Clearinghouse as errors and warnings must still be corrected on the error resolution site.
The final tab, Warning Resolution Report, provides you the records that have been flagged with a warning. Students with more than one warning will be listed multiple times on your downloaded report. Next to the warning codes, you may see fields highlighted in yellow. A highlighted field may also be present under the Warning Resolution Report tab advising you that this field is editable on the Error resolution report for the associate warning. Though this may not necessarily mean that an adjustment needs to be made. Here, you can compare the program level data submitted on the current submission with program level data previously submitted. Which includes the Program Begin Date, Program Enrollment Status, Program Enrollment Status Effective Date, Unreported Program Begin Date, Unreported Program Enrollment Status, and Unreported Program Enrollment Status Effective Date. If on your exported list you see a numbers sign populated under a field, this simply means that your column width needs to be expanded.
Once you have concluded downloading the errors and warnings you wish to retain from your error resolution report and have completed resolving the errors and warnings, you may select the “I am done” button to return your file for processing. Please note, once the “I am done” button is selected you will no longer be able to select the download button.
For questions or for additional assistance with the Error Resolution Export, please contact schoolops@studentclearinghouse.org and include Error Resolution Export in the subject line.