Database Maintenance for Patient

The patient level Database Maintenance tool checks the database for improper settings, inconsistencies, and corruption for a single patient.

In the Main Menu, click Tools, Misc Tools, Database Maintenance Pat.

This tool is useful for large offices that cannot run a full database maintenance fix during regular office hours.

Patient: Defaults to the patient currently selected. Click [...] to select a different patient.

Checks Tab

Patient Specific Database Checks: Highlight the table checks to perform or click None to deselect all checks. Results will display in the grid.
Breakdown: If an X shows in the Breakdown column, double click to see a breakdown of results.
Show me everything in the log: Check to include a detailed results log when checking/fixing. Uncheck to show a truncated version of the results.

Select the table checks to run and click Check to only run database checks and display results, or click Fix to run database checks and fix any errors that do not require a manual fix.

Hidden Tab

Patient Specific Database Checks - Hidden: Grid lists patient database checks that have been hidden from the main Database Maintenance Tool.

Old Tab

Patient Specific Database Checks - Old: Grid lists maintenance checks that are considered deprecated. In most cases these should not be run without explicit direction from Support.

None: Deselect all checks in the list. With none selected, all checks will be run.

Check: Run selected database checks to detect errors.

Fix: Run selected database checks and attempt to fix the errors.