for some reason I've noticed a lot of people in many different orgs really
trying to "make sure" about some piece of information and entering it
multiple times in multiple places... you know.... just to be sure.
I inherited a database at my new job with people who did just that and the
result is you can't trust the data. You need to take the time to really get
solid definitions for how your org uses each and every field and stick to
them.
If someone is deceased then you mark them as deceased. Marking them Inactive
as well dramatically changes the picture of who they are/were.
Case in point: I show up at my new job in April to find peopel who have no
valid address are:
1) haivng their address fields deleted, so they just have a blank address
2) bieng marked as don't send newsletter (you know... just to be sure we
don't send a nerwsletter to a bad address)
3) "No Valid Address" is not being used
Net result - we get a new address for these people and now I have no way to
know if they were marked not to receive the newsletter becuase they actually
requested it or if it was just because we didn't have an address for them.
Now I'm stuck - If I mark them "Yes" people are going to call me and
complain that "I TOLD YOU not to send the newsletter", or if I don't
"Where's my newsletter?!?!"
If they are deceased, do my heart some good and just use the deceased
checkbox. Do it for me. And the children. Think of the children.