Submission History Report Description

The Submission History Report provides summary counts, based on the primary key, of records that have been processed: those that successfully made it to the Master File, those that failed the edits or update process, and those that have not been successfully resubmitted. Records that failed the update process, i.e., that passed the edits but could not be placed in the Master File, are Exception records.

Below is a description of the report. Please pay particular attention to the Unresolved Errors.

  • SUBMIT: The number of records submitted to SPARCS.

  • MASTER: Of those records submitted, the number that were posted to the SPARCS Master File.

  • ERROR: Of those records submitted, the number that were NOT posted to the SPARCS Master File because of SPARCS edit failures.

  • EXCEPTION: Of those records submitted, the number that passed the SPARCS edits but were NOT posted to the SPARCS Master File. Possible reasons would have been: a new record was a duplicate of one already on the Master File, there was no record to correct, two identical records were processed in the same Master File update, or there was no record to delete.

  • UNRESOLVED - ERROR: Of those Error records failing the edits, the number that were not corrected and submitted again.

  • UNRESOLVED - EXCEPTION: Of those Exception records NOT posted to the SPARCS Master File, the number that were not corrected and submitted again.

More detailed, record level history reports are available upon request.