T_CUST_SUBSCRIPTION_SUMMARY

These rows are manually created when a package lineitem for a particular season is created in an order.  This happens en masse during the rollover process.

This is completely acceptable, but mind that a row might already exist.  You can do it in a few ways, either update existing and insert new rows, or look at the new MERGE command in SQL 2008.

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Monday, May 16, 2011 3:41 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] T_CUST_SUBSCRIPTION_SUMMARY

Are there any implications to manually adding rows to T_CUST_SUBSCRIPTION_SUMMARY in order for our Customer Care reps to use the Suggested Contribution and Suggested Additional Contribution fields when calling customers?  I just want to make sure I don't miss some sort of behind the scenes machinations that might need to take place when rows get inserted in that table.

Thanks, Tessiturians.

Matt Gonzales

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!