Hi, this is a general question about the table relationships involving T_TRANSACTION. Basically what I'm trying to find out is what our transactional load has been for past shows as far as single tickets are concerned over a time period to help gauge future transactional loads.
I need to weed out only single ticket purchases so I think need to get to the sub lineitem level to filter on price_type. If I start by using the T_TRANSACTION table as a base, how do I surmise which sub lineitems made up that T_TRANSACTION entry? The T_TRANSACTION table has a pmap_no and a perf_no which links to the TX_PERF_PMAP table but there can be several entries due to different price types within the same price map with seemingly no indication for which price_type the T_TRANSACTION pertains to. To get a snapshot view of this information is easy as I just start at the TX_PERF_SEAT and work down to the T_SUB_LINEITEM table but I want to look historically as tickets that were bought in the past may have been returned and re-bought. I want to see a historical transaction record. Actually as I write this, I realize there could be situations where there is no sublineitem to relate to. If a seat is bought but not printed and later returned (deleted) the sub lineitem would not remain. How might I find the data I'm looking for? I hope I'm not missing something.
Hmmmm.....
Thanks in advance!
Sean
One thing to keep in mind is perf_no wasn't always in t_transaction. I think that was a v6 or v7 thing. So if you're referencing t_transaction for anything older, that route won't work.
T_ORDER_SEAT_HIST might be more useful, depending on what you're trying to get at.
Thanks Amanda,
That was my backup plan. It is just that I have gotten some very mixed results from that table in the past so I was hoping to avoid it.
You're right too that deleting the line item from the order will delete the row in t_sub_lineitem. Another reason to look at t_order_seat_hist - that will have an event for release of the seat plus the seat_no and perf_no.