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
Debbie Harland (Past Member) You might want to check out T_ORDER_SEAT_HIST. If I remember correctly the event_codes show information about putting hold code on seats, including blackouts.
From the table documentation, the above event codes may be of use to you.
You then look at the various hold code related columns in this table.
However, Over time there have been a number of unresolved errors in this table that may cause you some frustration.
I talked about this at TLCC 2016. You might find this SQL code snippet to be helpful.
select perf_no
,seat_no
,CAST( FLOOR(CAST (event_date AS FLOAT)) as datetime ) as hold_event_dt_only
,hc_no
,hc_priority
, sum (case
when event_code = 7 then 1
else 0
end ) as 'Count_Daily_Holds_Applied'
when event_code = 8 then 1
end ) as 'Count_Daily_Holds_removed'
when event_code = 9 then 1
end ) as 'Count_Daily_Blackout_Applied'
when event_code = 10 then 1
end ) as 'Count_Daily_Removed_Applied'
,count(*) 'Count_Daily_Holds_events'
from T_ORDER_SEAT_HIST
where event_code in (7 ,8,9,10)
group by CAST( FLOOR(CAST (event_date AS FLOAT)) as datetime ), perf_no, seat_no, hc_no, hc_priority
order by COUNT(*) desc, perf_no, seat_no , hold_event_dt_only