Monthly Database Cleanup

To access:  VOTER FOCUS ADMIN > System Utilities > Database Utilities > Monthly Database Cleanup

When a document, such as a notice or mailing label, is sent to a printer, the document's record in the Notices table is updated to indicate the document was printed. The record isn't deleted. So, in the event of a printing problem, like a paper jam, you can conveniently reprint it (from the Reprint a Notice button on the Notices Utilities dialog).

Because the Notices table is primarily intended to hold only those documents that are ready for printing, the records of printed documents should be deleted periodically to increase the available database space. You can do this through the Monthly Database Cleanup utility, which removes records of documents printed more than two months ago. As the name indicates, the utility should be run at least monthly.

To run this utility, you need the SystemUtilities permission.

Note: When a document is printed, a permanent record is placed in the Voter Communications (Vtrcomm) table, so this information is not lost when the record in the Notices table is deleted.