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?
As noted below T_Order_Seat_Hist has the data you want to report holds "As Of" a past date. It can be challenging to report using this data due to potential bugs in the data from earlier versions of the system, the volume of data, and the general challenges of reporting on Time Series data. I believe that the Arsht Center has done some reporting in this area. I've done some experiments work in this area. However, never really created a production report that I felt fully captured these movements in a wonderful way.