Is there an easy way to find the information that appears (while on the Performance History radial button) in the ticket history tab? I mean subscriptions history is pretty easy being that there's a T_SUBSCRIPTION_HIST table, but is it really as convoluted as it first appears to get the performance history for a given customer number/season?
Thanks, Tessiturians.
BONUS TRIVIA: Tasmania has the cleanest air in the inhabited world.
I think you are looking for t_tck_hist
Actually, the subscription history you see on the Ticket History tab comes from the LT_SUB_HIST table. The performance history comes from the LT_TKT_HIST table. These are local tables because each organization usually customizes them a bit. They are populated based on local procedures that are again customized and usually scheduled to run nightly: LP_UPDATE_SUB_HIST and LP_UPDATE_TKT_HIST. Essentially these two procedures collect order information that is spread across many tables and put it in a single table (one for subs and one for perfs) that is easier to reference for things like lists and extractions.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
Is there anything we could do to cause ticket history > performance history to sort by performance date instead of order date?
We wrote out own custom screen for this which filters the data to only show past performances, sorts the data by performances date descending (last attended performance first) and groups it by season so it was easy to see how often someone comes.
Also paired it with a second screen that uses sub-lineitems to show what they have booked for in the future, which is was more useful for box office and was always up-to-date.
Mark