Greetings all -
I'm dabbling for the first time in using allocations and I need to create a report of which seats are assigned to which allocation for a given performance. I'm having difficulty finding the table in the Tessitura database that holds this information. Can anyone shed light on this topic?
Many Thanks,
Bill WaughStarlight Theatre
I believe what you're looking for is the ac_no column in the table TX_PERF_SEAT. There's a one-to-one relationship between the seat and the allocation (meaning there can only be one allocation on a seat at any time.) The descriptions of the allocations are stored in TR_AC.
Thanks Brian - I was getting confused by the existence of the TX_PERF_AC table - which seems to hold nothing. I should have thought to check TX_PERF_SEAT. Thanks again!