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
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.