We are in the process of trying to clean up our records, including attributes and constituencies. In doing this, we've realized our constituencies tend to be repetitive with information found in other places in a Tess record. Out of curiosity --
What do you have constituencies for and why?
Does it seem like better practice to track your prospects for foundation, gov, individual, etc. in a solicitation rather than a constituency?
Thanks!
Another thing: this bit of code is pretty much automatically included in any SQL select statement I write that pulls constituents:
all_consts = (
dbo.FS_CONST_STRING_NEW(customer_no,'Y')
)