Hello all, we are an arts consortium with residents, etc. exploring the idea of standardizing our event codes. This process would include going back and changing past event codes in Tessitura. I'm curious to know if anyone has done this or has thoughts on doing so as we want to see how and if updating these past codes would affect reporting or any other function within Tessitura. Thanks!
You can change perf codes without much worry. That being said, here are a couple of things to keep in mind.
Ticketing History: the local procedure LP_UPDATE_TKT_HIST (which is usually scheduled to run nightly) updates the ticketing history table (usually lt_tkt_hist). The procedure deletes the rows from the table and then recreates them each time it is executed, meaning you should not see a need to manually delete the old rows. If the codes in Ticketing History are still showing the old values after you have made the changes and executed the stored procedure, then this would be one place to look (assuming you have a perf_code column in ~lt_tkt_hist, of course).
Season Overview: you will need to delete the relevant rows from T_IMP_PERF_DATA and T_IMP_PERF_COMP tables based on the perf_no of the performances whose codes you change. The next time that the EIS_IMP_CHANGED_LOAD_NEW procedure runs with the @scope parameter set to 'F', the data will be rebuilt for these performances.
Thanks so much JD.