Note: Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup solution.

Table Cleanup allows you to easily manage your table entries. For example, in the Phone Type table, you can merge the types Cellular #, Cell Phone, and Mobile with the type Cell.

To use Table Cleanup:

  1. In Configuration, Tables, highlight the appropriate table
  2. Click Table Cleanup on the action bar
  3. In the grid, select each entry to be replaced

    phone type table cleanup

  4. Select or enter the replacement entry
  5. Mark the Delete the table entries being replaced checkbox, if appropriate
  6. Click Replace Now 

Note: To avoid data corruption, do not use use Table Cleanup on the Grade Level table if your Education Edge/Financial Edge database includes Student Billing 6 with multiple schools.