Where does perf_name pull from in T_TICKET_HISTORY? I had assumed T_INVENTORY, but that doesn't appear so...? Unless I am seriously missing something .. which, let's be real, is a distinct possibility. :)
I am trying to clean up some remnants in terms of out dated Performance Name standardization was left over from when we were part of a consortium. Its a mess and my Type A needs it to be fixed. We do not have any orders from prior to moving from our consortium - only ticket history - so I am hoping that T_ORDER and T_SUB_LINEITEM have nothing to do with it.
Also, when the TP_UPDATE_TICKET_HISTORY runs, does it overwrite the existing table or just appends for additional historical items? Considering this just in case I am feeling adventurous and want to update T_TICKET_HISTORY manually. O.o
Any insight would be appreciated!
Thanks!
Perf_name is the short_name column from T_INVENTORY, unless I am much mistaken, which comes from the "Short Name" box when you are building the performances in the Ticketing Setup module.
Yup, that is what I thought too. And it does appear to be the case. I just wanted to make sure I wasn't overlooking something in the SP. It would seem that perhaps I may have just been impatient with respect to the SP as a lot (if not all) of my data seems to have updated.
Patience is a virtue and all of that. :)