Inactive records and reporting

We've decided if a person is deceased and is the only person on the account that we will update their status as deceased and inactivate the record with a deceased type.  Our development department is concerned about how this effects reporting, especially when it comes to reporting on contributions.  Can anyone shed some light on this for us?  I can't seem to find much on the forums beyond how other organizations identify deceased patrons.

Thanks!

 

Parents
  • Data in inactive records will not be excluded from Reports.  If you choose to filter by a List using a List parameter, and the list does not contain inactive records, then yes the report will exclude data from those inactive constituents.

     

    The ability to allow inactive constituent records in Lists is controlled by a System Default called INACTIVES_IN_LIST.  The default is NO, do not include inactive records in a list.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christina Bledsoe
    Sent: Tuesday, September 07, 2010 10:02 AM
    To: Ryan Creps
    Subject: RE: [Tessitura Development Forum] Inactive records and reporting

     

    Thanks for the responses.  So it sounds like if we inactivate a record that has giving history then that data will be excluded from reports and won't give us accurate numbers correct?

    From: Marissa Axell <bounce-marissaaxell3777@tessituranetwork.com>
    Sent: 9/3/2010 1:31:11 PM

    At SF Opera, we’re constantly updating our Deceased Patrons policy. We had several learning moments along the way, and specifically, recommend thinking through the ramifications of reporting across departments, including your program listings, activities, box office ‘active subscriptions’ etc. It’s important to pull everyone together and get some buy in across the entire organization!

     

    Specific to development, if we are expecting a planned gift of some sort, we will change the patron record into an ‘estate’ type. You need an open record since you can not pull a list on an inactive patron. However, almost every ‘estate’ has different specifications, so they’re almost always handled individually.

    Good luck,

    Marissa Axell

     

    _____________________________________________________________

    Marissa Axell | Associate, Annual Support

    San Francisco Opera | 301 Van Ness Avenue | San Francisco, CA 94102

    P 415.551.6239 | F: 415.861.7148 | i: www.sfopera.com

    Error! Filename not specified. Please consider the environment before printing this email


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Leslie McKinley
    Sent: Friday, September 03, 2010 11:11 AM
    To: Marissa Axell
    Subject: RE: [Tessitura Development Forum] Inactive records and reporting

     

    Inactivating a record does remove it from reports.  So there is no impact to reporting

     

    Inactivating a record does remove it from Lists created with List Manager.     Inactive records are included in Extractions unless otherwise suppressed.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christina Bledsoe
    Sent: Friday, September 03, 2010 2:01 PM
    To: McKinley, Leslie
    Subject: [Tessitura Development Forum] Inactive records and reporting

     

    We've decided if a person is deceased and is the only person on the account that we will update their status as deceased and inactivate the record with a deceased type.  Our development department is concerned about how this effects reporting, especially when it comes to reporting on contributions.  Can anyone shed some light on this for us?  I can't seem to find much on the forums beyond how other organizations identify deceased patrons.

    Thanks!

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

Reply
  • Data in inactive records will not be excluded from Reports.  If you choose to filter by a List using a List parameter, and the list does not contain inactive records, then yes the report will exclude data from those inactive constituents.

     

    The ability to allow inactive constituent records in Lists is controlled by a System Default called INACTIVES_IN_LIST.  The default is NO, do not include inactive records in a list.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christina Bledsoe
    Sent: Tuesday, September 07, 2010 10:02 AM
    To: Ryan Creps
    Subject: RE: [Tessitura Development Forum] Inactive records and reporting

     

    Thanks for the responses.  So it sounds like if we inactivate a record that has giving history then that data will be excluded from reports and won't give us accurate numbers correct?

    From: Marissa Axell <bounce-marissaaxell3777@tessituranetwork.com>
    Sent: 9/3/2010 1:31:11 PM

    At SF Opera, we’re constantly updating our Deceased Patrons policy. We had several learning moments along the way, and specifically, recommend thinking through the ramifications of reporting across departments, including your program listings, activities, box office ‘active subscriptions’ etc. It’s important to pull everyone together and get some buy in across the entire organization!

     

    Specific to development, if we are expecting a planned gift of some sort, we will change the patron record into an ‘estate’ type. You need an open record since you can not pull a list on an inactive patron. However, almost every ‘estate’ has different specifications, so they’re almost always handled individually.

    Good luck,

    Marissa Axell

     

    _____________________________________________________________

    Marissa Axell | Associate, Annual Support

    San Francisco Opera | 301 Van Ness Avenue | San Francisco, CA 94102

    P 415.551.6239 | F: 415.861.7148 | i: www.sfopera.com

    Error! Filename not specified. Please consider the environment before printing this email


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Leslie McKinley
    Sent: Friday, September 03, 2010 11:11 AM
    To: Marissa Axell
    Subject: RE: [Tessitura Development Forum] Inactive records and reporting

     

    Inactivating a record does remove it from reports.  So there is no impact to reporting

     

    Inactivating a record does remove it from Lists created with List Manager.     Inactive records are included in Extractions unless otherwise suppressed.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christina Bledsoe
    Sent: Friday, September 03, 2010 2:01 PM
    To: McKinley, Leslie
    Subject: [Tessitura Development Forum] Inactive records and reporting

     

    We've decided if a person is deceased and is the only person on the account that we will update their status as deceased and inactivate the record with a deceased type.  Our development department is concerned about how this effects reporting, especially when it comes to reporting on contributions.  Can anyone shed some light on this for us?  I can't seem to find much on the forums beyond how other organizations identify deceased patrons.

    Thanks!

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

Children
No Data