I'm trying to clean up my database a bit (removing "No Valid Address" records) and I'm trying to figure out what to do with a handful of constituents whose primary address is "No Valid Address", but have other address records that are not inactive as far as tessitura is concerned. However, in the database table, inactive has a value of '2'. My hunch is that this was a result of our data import/conversion, but I'm not sure what that would signify.
Any ideas?
Yep, sounds plausible that an int went to the char(1) column in T_ADDRESS (or C_ADDRESS, if you used it) in error.
If I were you I'd be curious enough to dig into my old conversion code to verify.
Maybe there was confusion as to what was being inactivated.
T_CUSTOMER's inactive field is an integer, with 2 meaning inactive.
T_ADDRESS' inactive field is a char(1).
Perhaps, like Chris said, there was an issue when migrating, and maybe there was a case where somebody ran update statement(s) on T_ADDRESS and specified the wrong update value. Since a char(1) could accept a one digit number, this is possible.
Good luck getting to the root of it!