Hello,
I am doing a report on constituent with ticket exchanges. My question is by looking at some of the SQL tables such as t_order_seat_hist, t_order, t_sli_status. How can I identify that constituent having some ticket exchange transaction in that constituent?
in fact, can I look at the order_no, sli_status for exchangeable??
Thanks,
-Harry
I'm pretty sure you need to dig into the T_ORDER_SEAT_HIST table. Check out the Tessitura Table Structures document; it has a legend for every possible value in the event_code column, including 3 (Returned), 4 (Released), and 16 (Returned for Resale), which you will likely want to look into. I would recommend creating some sequences of actions in your test system and then observing what is written to T_ORDER_SEAT_HIST for each of those scenarios.
hello Nick,
Thank you for your reply.
when i do a seat exchange, I still get the another ticket_no or just the same as the previous one? it seems i get NULL in the ticket_no on t_order_seat_hist table and the same order_no.
Harry
Remember that a ticket_no is only generated when the ticket is printed. When an SLI is unprinted, it can be moved to any seat easily, but once it has been printed and has a ticket_no, it can only be returned or donated, not moved. If a ticketed seat is being exchanged, it is returned, and then a new SLI is created for the new seat.