Seat History

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