I can't find any reference to this in documentation. Can anyone tell me what logic populates T_PERF.sales_version?
I had never really noticed the column before, but in V12 testing, a user noted that the Ticket Sales by Period report will not run in Price Type Category mode if the report includes sales_version values < 12.
Looking at all of our T_PERF records, I can't find anything obvious for when this value gets populated. I seek enlightenment oh wise message board!
- Levi
Paul is correct. For the Ticket Sales by Period report, we can only reliably show sales by Price Type Category using v12 sales data. This is because this is the first time that we can track performance revenue all the way down to the Peformance Price Type and Layer.
This column (sales_version) is the mechanism that drives this decision (whether or not we can assume a performance contains pre v12 or post v12 sales data).
=>Ryan Creps
@Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Paul Kappel Sent: Tuesday, June 3, 2014 2:02 PM To: Ryan Creps Subject: Re: [Tessitura Technical Forum] T_PERF.sales_version
Hi Levi,
I believe that the sales_version column is populated during data migration to indicate what version of Tess was used to set up the performance originally to indicate if you can continue to join on TX_PERF_PMAP
From: Levi Sauerbrei <bounce-levisauerbrei7046@tessituranetwork.com> Sent: 6/3/2014 12:46:54 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!