Purge clients and patients
Purging aged records that are no longer needed reduces the amount of displayed client accounts and patient medical history and decreases the size of reports that include history. Removing outdated client and patient records also declutters your client and patient lists and improves Cornerstone performance.
Before you start
- Database Purge
Setup
Other tasks/requirements
- Backup your Cornerstone database.
- Verify you have exclusive use of Cornerstone. All other users must be logged out of Cornerstone.
- Verify you have at least one year of entered data and two processed end of year periods.
- Check out any outdated checked in patients. This can easily be done from the Daily Planner Checked in tab.
- Check any outdated balances or open invoices from either of the following:
- Accounts Receivable report
- Daily Planner Invoices tab
Important!
- Back up your database before purging any data. Purging cannot be reversed.
- Purging records should align with your state board’s medical and controlled substance records’ retention requirements.
Purge criteria
The following criteria must be met to successfully purge client and patient information.
- The client has 100% ownership of all of their patients.
- All of the patients owned by the client must meet the patient purge criteria.
- The client does not have any of the following:
- A balance
- Open/saved invoice
- Account transactions after the purge date. This includes charges on the Patient Visit List (PVL).
Patient
- The patient’s record was not created after the specified purge date.
- The patient is not checked in.
- The patient does not have any of the following:
- Future appointment or boarding reservation.
- Open/saved exam. ² Note: These would be listed under the Exam tab on the Daily Planner.
- Transactions on an open invoice. ²
- Any account transactions after the purge date. This includes charges on the Patient Visit List (PVL). ²
- A controlled substance in its history for at least two years. ²
Note: If a patient is deceased, Cornerstone will only verify that the patient does not meet any of the conditions indicated by the ² symbol.
How to purge
Navigate to Tools > Purge Data.

- Verify you have a recent backup and Click OK to the backup reminder message.
- Select Type of Purge:
- Purge both clients and patients to remove all records that fit the criteria.
- Purge only patients to remove patients and associated information that fit the criteria.
- Purge specific information and select specific information to purge. This will only remove outdated history, yet retain the client/patient record.
- Click OK.
- Change the Last date to purge to an earlier date, if needed. This will retain records for longer than the timeframe set in the default settings.
- Options area:
- Select Print list of records purged to print a list of the records purged, if needed. A text (.txt) file is automatically saved to the cstone folder.
- Specify Select/purge by ID or Select/purge by name.
- Based on type of purge and/or specific information selected, define the client and patient parameters:
- Enter the appropriate ID or name (or part of the name or ID) of the first client or patient.
- Enter the appropriate ID or name (or part of the name or ID) of the last client or patient.
- To purge information for a single client or patient, enter the same ID in both the First and Last fields.
- Modify the Status of the clients or patients, if needed: Active, Deceased (Patient only) or Inactive.
- Modify the Classifications of the clients or patients, if needed.
- Click OK to start the purge or click Close to return to the purge type selection window, if needed.
- Click Yes or No on the continue to purge confirmation.
- Selected clients and patients are evaluated, and you may be prompted to retain specific information or client/patient records. Click Yes or No as applicable.
- If there is a reason a client or patient was not deleted, the reason is displayed in the Purge Summary. Click Print to print the summary or click X to close the message.
- Click OK on the message regarding the text file being saved to the cstone folder.
- Click OK on the purged history report will now be printed message. This message will display if Print list of records purged was selected.
- Click OK on the purge is complete message.
Additional Information
Purge details
- If using a specific client classification for ‘marketing’ clients to track client referrals, do not include that classification in the client selections.
- If you need to purge a single client and delete all records so they are not part of the purged records list (due to local PII laws), use Delete Client.
- You may be prompted to retain clients that were written off or retain patient prescription refill information or most recent weight. Click Yes or No as applicable.
- Purging in batches is recommended to not tie up the system. Example:
- Letters of alphabet: aa-az, bb-bz, etc.
- Small groups: a-b, c-d, etc.
- For workstations with Auto-Lock/Logoff settings, the idle timer will not begin until the purging process is complete
Dates
- The last date to purge date is based on the purge defaults and the processed end of year dates. You cannot purge data from a date after the default period.
- When purging information that contains both client and patient account information and reminders, Cornerstone retains data using the oldest possible date from the defaults.
Purge reminders
You can purge all outdated patient reminders (Call and/or Letter) for the selected patient(s) with a due date before the default date set in your purging defaults.

- Select Purge specific information. Click Reminder Calls, Reminder Letters, or both.
- Click OK.
- Change the Last date to purge to an earlier date, if needed. This will retain records for longer than the timeframe set in the default settings.
- Options area
- Select Print list of records purged to print a list of the records purged, if needed. A text txt file is automatically saved to the cstone folder.
- Specify Select/purge by ID or Select/purge by name.
- Based on type of purge and/or specific information selected, define the client and patient parameters:
- Enter the appropriate ID or name (or part of the name or ID) of the first client or patient.
- Enter the appropriate ID or name (or part of the name or ID) of the last client or patient.
- To purge information for a single client or patient, enter the same ID in both the First and Last fields.
- Modify the Status of the clients or patients, if needed: Active, Deceased (Patient only) or Inactive.
- Modify the Classifications of the clients or patients, if needed.
- Click OK to start the purge or click Close to return to the purge type selection window, if needed.
- Click Yes or No on the continue to purge confirmation.
- Selected clients and patients are evaluated, and you may be prompted to retain specific information or client/patient records. Click Yes or No as applicable.
- If there is a reason a client or patient was not deleted, the reason is displayed in the Purge Summary. Click Print to print the summary or click X to close the message.
- Click OK on the message regarding the text file being saved to the cstone folder.
- Click OK on the purge history report will now be printed message. This message will display if Print list of records purged was selected.
- Click OK on the purge is complete message.
Delete client tool
This function also requires specific security access and exclusive use of Cornerstone. It’s intended use is to comply with local Personally Identifiable Information (PII) laws and is not restricted to purging defaults. IDEXX recommends you consider all data retention laws for your state for medical, financial, prescription, and controlled substance records before using this tool.
We strongly advise backing up your Cornerstone database before purging any data.
This tool will only allow the purge of a single client at a time. To purge multiple clients, patients, or specific information only, use the Purge Data tool.
When deleting a client record Cornerstone will:
- Delete all records of the selected client and any patients owned 100% by the client before the selected date. If the client does not have 100% ownership, the client and patient records will not be deleted.
- Delete the selected client and associated patient(s) from the Client List and Patient List.
- Cornerstone will not provide a report of the purged record.
Delete client criteria
The following criteria for clients and patients must be met to delete the client record.
- The client has 100% ownership of all their patients.
- The client is not a partnership or a member of a partnership.
- If the client has trainer or barn selected for the type, patients cannot be assigned to the trainer or barn.
- The client does not have any of the following:
- A balance.
- An open/saved invoice.
- Any account transactions after the purge date, including charges on a Patient Visit List (PVL).
Patient
All of the patients owned by the client can be purged based on the following criteria.
- The patient is not checked in.
- The patient’s record was not created after the specified purge date.
- The patient does not have any of the following:
- A future appointment or boarding reservation.
- Transactions on an open invoice.*
- An open (saved) exam.* Note: Open exams can be found under the exam tab on the Daily Planner
- Account transactions after the purge date, including charges on the Patient Visit List(PVL).*
- A controlled substance in its history for at least two years.*
- Reminders in the future or in the past month.
Note: If a patient is deceased, Cornerstone will only check to verify that the patient does not meet any of the conditions indicated by the * symbol
Steps to delete a client
Navigate to Tools > Delete Client.
- Click OK to the backup reminder message.
- Enter the Client ID or F2 to search for and select the client.
- Click OK to start the purge.
- Click Yes or No on the continue to purge confirmation.
- A Purge Summary displays if the record was not deleted and includes the reason. Click Print to print the summary or click X to close the message.
- Click OK on the purge is complete message.
Related Reports
- Purge report