I’m doing some database cleanup and have a number of accounts that were tagged with an incorrect constituent type when they were converted during the Tessitura integration. For example, id 12345 “Mr & Mrs Smith” is tagged as a corporate constituent type, but should really be a household. However, I have no idea what first name or even first initials are, so I can’t change the type in the front end of the client. (I should mention that all of the accounts I've checked are ancient and have no recent activity on them).
What is the harm/is there harm in me changing the type in SQL so that I have a more accurate count of constituent types? Or would you choose a placeholder letter/name? Or is this one of those things I should just live with?
Both Chris and Carol have points. There are indeed database concerns. You have affiliate, name and prefix issues. But frankly, if they are converted/import accounts and they have no activity, are they really worth anything to you? E-mailing them with zero purchases is not really actually anything. (I have had this fight with marketing.) And a duplicate account of an inactive account... is that really an issue? Just asking.