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.