Data Quality Views for Households
There are several views on the Households page to help keep your data clean.
- Empty Households
- Displays Households that are empty (meaning with no Household Members) and you can safely delete. Empty Households can result from normal data management operations like manually changing a Contact record's assigned Household. Be aware of the following when you delete empty Households:
- The Delete action requires you to reassign or delete the Contact Household and Household Care Log records. You may want to preserve the Household Care Log records. In that case, you might make note of a generic "catch-all" record you can use.
- After you delete a Household record, the Audit Log doesn't record the Delete action itself. However, any previous Audit Log entries relating to that Household_ID remain in the database after you delete the record.
- The default of Unassign can be left for the Activity Log data. Since you moved the Contacts to another Household, their activity regenerates on the new Household the next time the Activity Log process runs.
- Fix Too Many Heads
- Displays Households with more than two Heads of Household. Why do you need to fix this? The Platform and reports use the Household position to perform certain actions or pull certain information. If you have more than two Heads, it can cause an issue when you attempt these actions or pull information. To fix this, open each Household to review and change the Household positions as needed.
- Fix Home Page
- Records in this view have home phone formatting that is not consistent with the MinistryPlatform standard of ###-###-####. To fix these, open each record to change the phone number format.
For more information on keeping your data clean, see Data Quality Routine.