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
Hi Debbie,
Doesn't the pseat_dt field in TX_PERF_SEAT track the change date on a seat? Since the seats in question were never in orders, I'm not sure if they'd be included in T_ORDER_SEAT_HIST.
Sara
Thanks for all the replies. I think our Box Office are just going to suck it up and do the Black Out holds on matured productions.
Debbie