In the course of record updates in The Raiser's Edge, stray entries can appear on the States table found at Config > Tables > States. Some values are hard-coded and cannot be deleted. For more information, please refer to Unable to edit states and provinces or their abbreviations on the States (Provinces) code table. Other values, however, can be deleted if needed to help maintain accurate records.


To find records that a state (province) value may be on:

1. Using a constituent query on the Criteria tab, add the following fields:

Addresses > All Addresses > State equals [state]
OR Relationships > Banks > Address > State equals [state]
OR Relationships > Contacts > Address > State equals [state]
OR Relationships > Individuals > Address > State equals [state]
OR Relationships > Organizations > Address > State equals [state]


2. Using a relationship query on the Criteria tab, add the following fields:

Individuals > Address > State equals [state]
OR Organizations > Address > State equals [state]

NOTE: Records cannot be opened from the Relationship query results. However, this query can help identify which relationships on constituent records have the value in question.


3. If the RE:Event module is present, using a Participant query on the Criteria tab, add the following fields:

Address > State equals [state]
OR Guest > Address > State equals [state]
 

4. If the RE:Event module is present, using an Event query on the Criteria tab, add the following fields:

Location > Location State equals [state]


5. Go to Config > Attributes and review the Table Name column for Attributes. If any use the States table, then query for that attribute and the desired state value.

6. Go to Config > Financial Institutions and review each record's address. Edit the state to remove it from the record.

7. Go to Config > General to ensure that the state in question is not selected for the organization's address.




To use Global Change to remove the value from records:

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.

  1. Create a constituent query. On the Criteria tab, select Addresses > All Addresses > State equals [state to be deleted].
  2. Globally delete the state from the records in the query by going to Admin, Globally change records, use a Constituent Change.
  3. Create a new relationship query filtering on: Individuals > Address > State equals [state to be deleted] OR Organizations > Address > State equals [state]
  4. Globally delete the state from the records in the relationship query by going to Admin, Globally change records, use an Individual/Contact/Employee Change.



To remove value from records entirely:
If results are not produced in any of the queries and you are still unable to delete the state table entries, run the Delete Table Entry Plug-in.