When using the Online Registration feature within AWdb, it's better if there are not multiple variations for the same church or school for parents to select. The list shown to parents is pulled from Generic Lookups, which can be seen using the Windows App under Admin > System Settings > Generic Lookups. Before an unwanted record can be deleted from the Generic Lookup table, it must not be used by another record. For example, if both "FBC" and "First Baptist Church" are listed in Generic Lookups > Church Names and "FBC" is preferred, removing "First Baptist Church" will make the data more consistent. Before removing "First Baptist Church", any household currently using that name needs to be changed to use "FBC" instead. This could be a tedious process, but can be made easier by using the Windows App.


Please note, the remainder of this article will refer to church names, but school names follow the same process unless otherwise noted. Also, this information could be used to clean up any Generic Lookups, but the others are not as concerning, since they aren't exposed to parents during Online Registration.


Using the Windows App:

  • Go to Admin > System Settings > Generic Lookups > Church Names. Decide which church name from the Generic Lookups to remove (i.e. "First Baptist Church") and which name should be used instead (i.e. "FBC").
  • Select Tools > SQL Workbench from the top menu bar. Copy/Paste the following query in the SQL Workbench's top box, replacing the example church names with the actual names.
    update household set church_name='FBC' where church_name='First Baptist Church'
    For Schools, use:
    update person set school_name='FBC School' where school_name='First Baptist Church School'
  • Click the Run SQL button to update the records.
  • Delete the unwanted church, i.e. "First Baptist Church" from Generic Lookups.
  • Repeat Steps 1-4 above for any other church names that should be removed.
  • If there are names that need to be updated, correct the existing name within the Generic Lookups list, then save the change (checkmark below the grid). Existing records using the old name will be automatically updated.
  • To identify names that are not currently used by any households or members, run the following queries within the SQL Workbench. Use the results to remove unused names from the list by selecting the record and then clicking on the minus button below the grid.

For unused churches:

select church_name from gen_church_name where binary church_name not in (select distinct church_name from household where church_name is not null)

For unused schools:

select school_name from gen_school_name where binary school_name not in (select distinct school_name from person where school_name is not null)