I'm having a hard time finding a table (not system like TR_XREF_TYPE) that contains the constituent ID and Associations. Our Development staff would like to do a mass inactivation of a large number of staff associations that no longer are working with the donor.
Hi Sarah
TX_XREF is where they live.
That's one that you need to be very careful with - there is a record for each side of the association, even for soft associations.
Ken