Track Divorce, Marriage, and Deaths

Donna

You might want to look at the audit table in Tessitura – you can see it under the Transactions Tab and the Audit radio button in a constituent’s account

Your System Admin could make a custom list criteria based upon the audit date and the column being inactive and the new_value = 2 (meaning it has been inactivated) and then you can include your other criteria of the inactive reasons you are interested in.

Of course you could make a report based upon the Audit table and combine the inactive reasons too.

Just a thought that might help if nothing else pops up.

Cheers

Sandra

From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Donna Searles-Brown
Sent: Thursday, March 3, 2016 10:07 AM
To: Sandra Ashby <sashby@tessituranetwork.com>
Subject: [Tessitura Shared Reports Forum] 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.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Donna

You might want to look at the audit table in Tessitura – you can see it under the Transactions Tab and the Audit radio button in a constituent’s account

Your System Admin could make a custom list criteria based upon the audit date and the column being inactive and the new_value = 2 (meaning it has been inactivated) and then you can include your other criteria of the inactive reasons you are interested in.

Of course you could make a report based upon the Audit table and combine the inactive reasons too.

Just a thought that might help if nothing else pops up.

Cheers

Sandra

From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Donna Searles-Brown
Sent: Thursday, March 3, 2016 10:07 AM
To: Sandra Ashby <sashby@tessituranetwork.com>
Subject: [Tessitura Shared Reports Forum] 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.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!