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?
Kathleen Smith said:a number of accounts that were tagged with an incorrect constituent type
How many are we talking about? Re: Carol's and John's replies about whether or not these are worth cleaning up, the time it would take to do so is definitely a factor, even for data hygiene fans like myself. If a few hundred or less, and I would likely clean them up, one by one if necessary. If thousands, I'd... probably let it go.