• Replies 7 replies
  • Subscribers 336 subscribers
  • Views 46 views
  • Users 0 members are here
Related

Question about suppressions

Christina Bledsoe
$organization

So we're starting to delve more into doing extractions and I just had a question from development about suppressing records with a deceased status. They were concerned that if one person on the account had the deceased status that it would completely suppress that account even though one person on it is still alive.  I've done some testing and discovered that it will exclude them, but perhaps I'm just not building the suppression segment correctly.  Any advice?

Thanks!

Parents
  • $organization

    Hi Christina,

    I think typically organizations have two ways of marking patrons as deceased.
    Via the name1/name2 statuses (system table tr_namestatus), which leaves the account active, and/or by an inactive type (tr_inactive_reason) which will inactive the account completely.
    We use an inactive type of deceased (as well as any other inactive reason) as a standard suppression but not typically the name status.

    Hope that makes sense.

Reply
  • $organization

    Hi Christina,

    I think typically organizations have two ways of marking patrons as deceased.
    Via the name1/name2 statuses (system table tr_namestatus), which leaves the account active, and/or by an inactive type (tr_inactive_reason) which will inactive the account completely.
    We use an inactive type of deceased (as well as any other inactive reason) as a standard suppression but not typically the name status.

    Hope that makes sense.

Children
No Data