Hello!
I'm wondering which table now holds the audit trail for performance prices? I believe pre-v12 this was TA_AUDIT_PRICES (which is exactly what I'm looking for!) but no new data has written to that table since our upgrade. We have auditors coming in later this week and they want to see all pricing changes over a given time period. I think I'm essentially looking for the table behind the Change Log for the pricing tab in performances.
On a related note, we aren't actively using price events yet so the table T_PRICE_EVENT is not helpful in this situation.
Thanks!
Thanks – I found also TA_AUDIT_PRICING_PRICES
Jason Combs | Director of Information Technology |jason.combs@strazcenter.org
David A. Straz, Jr. Center for the Performing Arts |
1010 North W.C Macinnes Pl | Tampa, Florida 33602 O: 813.222.1092 F: 813.222.1057
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Thursday, September 29, 2016 2:25 PM To: Combs, Jason <Jason.Combs@strazcenter.org> Subject: Re: [Tessitura Technical Forum] Price Audit Table
************************************************************************************************************* This email is from an external sender! Don't click links or open attachments from unknown sources. Forward suspicious emails as an attachment to bulk@strazcenter.org for analysis. We're counting on you! Think before you click! *************************************************************************************************************
Jason Combs:
Did you ever find this? I am looking for it as well.
Please see TA_AUDIT_PRICING_PRICE_TYPE.
From: Jason Combs <bounce-jasoncombs3953@tessituranetwork.com> Sent: 9/29/2016 2:09:10 PM
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!