Track Divorce, Marriage, and Deaths

I am trying to find a way to track the changes we make for divorce, marriage and deaths in Tessitura.

Is there a way to pull a report that would indicate who has been divorced, married or killed within Tessitura?

We specifically are looking to be able to pick a date range and pull a report based on that date range with any constituents who have been made inactive within that date range.

Parents
  • Replying mainly to say this would be a spectacular conference session title!

    'Divorced, married or killed within Tessitura?'

    In addition, I'd be really interested in this too, would a basic query on t_customer where inactive_reason is not null or the corresponding number code for your org as deceased suffice for deaths?

    How do you register your marriages and divorces? Do you household and de-household or use relationships in a different manner?

     

    Victoria



    [edited by: Victoria Carlin at 5:20 AM (GMT -6) on 3 Mar 2016]
Reply
  • Replying mainly to say this would be a spectacular conference session title!

    'Divorced, married or killed within Tessitura?'

    In addition, I'd be really interested in this too, would a basic query on t_customer where inactive_reason is not null or the corresponding number code for your org as deceased suffice for deaths?

    How do you register your marriages and divorces? Do you household and de-household or use relationships in a different manner?

     

    Victoria



    [edited by: Victoria Carlin at 5:20 AM (GMT -6) on 3 Mar 2016]
Children
No Data