APPENDIX C: Report Edits

Data for each UI report, either hand entered or uploaded from an ASCII file, is put through edits before saving to State files and again, before transmission to the National Office. Results of these edits are displayed to the user and the opportunity to make corrections is given at both times. Users should review the edits and make corrections as appropriate or explain in the comments section of the report, that the data has been checked and is correct and why.

There are three different types of edits: fatal errors, errors, and warnings. These are discussed in Chapter 2, Checking for Errors. It would be prudent, if possible, to edit data in the State system before it is loaded onto the UIRR entry system, especially through ASCII upload, so that transmission goes smoothly.

The following shows the edits performed by the system for most reports for which States would prepare ASCII upload files. For each table name, the condition that should exist for certain cells is shown. Deviations from these conditions will result in edit exceptions. Refer to the data maps in Appendix A which gives the cell names to understand the edits. To avoid edit errors in the entry or upload process, States may choose to apply edits at the time that their own systems create the data.>