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
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
Hi Paul.
I thought that might have been the case, but when I look at the whole table it seems more random than that. The values populated in my Live environment (V11) only appear for a few shows while the majority of shows have a NULL. And it doesn't seem to be date dependent.
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
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!
Another note here that the same restriction exists in Performance Transaction Detail as well.
Thank you Ryan and Paul!
That makes sense. I'll let our users know.