Hi All,
Is there a table which keeps the status of seats and when they change? When our Box Office run reports to calculate the house capacity and the percentage sold, the figures change if a change is made to the auditorium once a show has started. So, retrospectively seats that had been blacked out and are now available will be calculated as not sold for past performances.
If I can identify when a seat changed from blacked out to available and then ticketed, I could add that into the reporting calculation, but I can't find where the information might be. I've tried TX_PERF_SEAT, but it doesn't hold a last updated date.
Any ideas anyone?
Thanks, Debbie
I assume when you say "blacked out", you are referring to the auditorium itself as having changed as opposed to black-out holds, is that correct? If you are talking about changes to the facility itself, then at least you can keep that from happening between seasons, but there is nothing that can be done during a season as far as I know. Because if you are talking about holds, then I am curious as to why you are applying holds to past performances.
Also, completely unhelpful here, but our organization regularly has to black out seats that we want counted as part of capacity because we close entire sections of the hall, so we have a lot of custom reporting and different hold code types which tell us which blackout codes count as capacity and which ones do not.
John
So, we are having to alter the facility map for our current and one future production, and add on some extra seats on either side of the auditorium. This will change the seating for past shows and alter their capacity. The Box Office are going to go through all the affected past shows and apply black out holds to the seats which didn't exist previously, so that board reporting on previous shows doesn't have incorrect capacity numbers.
I was hoping there was a table that would keep a log of facility changes. I wasn't being precise enough in my original ask. I don't think T_ORDER_SEAT_HIST will do the job either.
Thanks for the replies. Debbie