Consortium Merge

Hi Shereen,

I’d be happy to set up a time to discuss this further. Please feel free to email me directly at dfrederick@scfta.org to coordinate a time to discuss.

Thanks,

David

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Shereen Marino
Sent: Wednesday, May 22, 2013 10:05 AM
To: David Frederick
Subject: Re: [Tessitura Technical Forum] Consortium Merge

Hello David,

Thank you for your reply.  Yes, as I'm testing the process, I see that it can be time consuming.  I'm very interested in the customized process you're rolling out.  Could you let me know how it goes?  I'd like to discuss the process in more detail with you if possible.

Thanks again,

Shereen

Hi Shereen,

We are a consortium of 4 organizations. We allow each organization to schedule merges. The merges take place in a scheduled job weekly.  The person scheduling the merge is required to enter a CSI if it is a shared record (i.e. in a nutshell, a record with activity in the last 3 years or so for two or more organizations). No merges are allowed to be scheduled after 1pm on Fridays to allow time for a review process.

Before the weekly merge process, our ticketing functional support staff reviews the list of scheduled merges. They first validate to make sure the pair really are duplicates based on name/address type of data. In the past, they would manually look at records for potential issues that would need to be resolved before the merge could take place, like changes to memberships. So it was fairly time-consuming.

We are in the process of finishing up customizations to the lp_validate_cust_merge procedure to trap issues upfront rather than relying on someone to manually review. It specifically looks for situations where we do not want a merge to take place, and reports what it found as specifically as possible to the user trying to schedule the merge. The weekly review of scheduled merges by our ticketing functional support team will be much easier and quicker now. We expect to go live with this in June.

I hope this is helpful!

Thanks,
David

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

Hi Shereen,

I’d be happy to set up a time to discuss this further. Please feel free to email me directly at dfrederick@scfta.org to coordinate a time to discuss.

Thanks,

David

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Shereen Marino
Sent: Wednesday, May 22, 2013 10:05 AM
To: David Frederick
Subject: Re: [Tessitura Technical Forum] Consortium Merge

Hello David,

Thank you for your reply.  Yes, as I'm testing the process, I see that it can be time consuming.  I'm very interested in the customized process you're rolling out.  Could you let me know how it goes?  I'd like to discuss the process in more detail with you if possible.

Thanks again,

Shereen

Hi Shereen,

We are a consortium of 4 organizations. We allow each organization to schedule merges. The merges take place in a scheduled job weekly.  The person scheduling the merge is required to enter a CSI if it is a shared record (i.e. in a nutshell, a record with activity in the last 3 years or so for two or more organizations). No merges are allowed to be scheduled after 1pm on Fridays to allow time for a review process.

Before the weekly merge process, our ticketing functional support staff reviews the list of scheduled merges. They first validate to make sure the pair really are duplicates based on name/address type of data. In the past, they would manually look at records for potential issues that would need to be resolved before the merge could take place, like changes to memberships. So it was fairly time-consuming.

We are in the process of finishing up customizations to the lp_validate_cust_merge procedure to trap issues upfront rather than relying on someone to manually review. It specifically looks for situations where we do not want a merge to take place, and reports what it found as specifically as possible to the user trying to schedule the merge. The weekly review of scheduled merges by our ticketing functional support team will be much easier and quicker now. We expect to go live with this in June.

I hope this is helpful!

Thanks,
David

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