Hello
Our Box Office would like to be able to report on the hold codes on a performance, however they would like to look at all the hold codes that have ever existed (ie. we would like to report on hold codes that have been released). Is historical hold code data stored anywhere within the Tessitura database for us to report on?
Thanks
Mark
t_order_seat_hist has the hostory of every seat in the database for every perfomance. It includes a hc_no and event_code column which you can query to see when holds were applied and removed from seats using seat_no.Caryl
Hi Carly
Thanks so much for this, its exactly what I was looking for.
Take care
Hi Mark,
Did you guys ever end up attaining this hold code nirvana report? Should I talk to Scott?
We'd like to look at whether hold codes are being used by their 'owners' and how long before a performance they're released etc. so it can help us determine appropriate numbers.
B
Hi-
Bringing this to the top. Did anyone ever get a report like this up and running?