Now that we have been on Tessitura for more than 10 years, we want to go back to the beginning of our season codes and more clearly define them. In order to match the season codes we are now using, it involves changing the season codes for a lot of old ticketing and subscription records. For example, when we started, we had one season code for all our non-renewables. Now we split them into 3 different groupings - classical, pops and hybrid. Our purpose is to be able to compare our old non-renewables to our new non-renewables.
Other than the T_PKG and T_PERF tables, I know we will have to update or T_TCK_HIST and T_SUBSCRIPTION_HIST files. What other tables would be affected? T_SUB_LINEITEM, T_LINEITEM? How deep do these code reach?
Jan LaRocque
Houston Symphony
How did this work out for you? What all did you need to change in order to update the perf code? We may have to do that and are considering what all would be included in this.