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
Prepare yourself for the Lovecraftian horror that is T_ORDER_SEAT_HIST.
This may be one of the best forum responses ever. How are you caffeinated enough at 9AM to use that 50 cent word?????? I can barely use the. LOL
Really???? Is that the only place? !!!!
Thanks anyway.
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
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
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
Creating a meme now
heathwilder.files.wordpress.com/.../complete-sql-of-h.p.lovecraft.jpg
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