Greetings, Tessiturians.
It's another slow summer day in the off season. Perfect time for silly questions like:
I know that Subscription information from seasons past (including the current season, though technically not over yet) can be found in T_SUBSCRIPTION_HIST. But, where do I find subscription information (including data like the SERIES_NO and LOCATION) for upcoming seasons?
I'm assuming the information gets updated into the T_SUBSCRIPTION_HIST by some stored procedure call at the appropriate, pre-designated times, which is why my development contact didn't get next year's information like she wanted from Output Set Builder.
Any takers? Or too early in the morning for silly questions from people that don't like going through reams of boring manuals before lunch?
Thank you in advance, as always, for your assistance. Crowd surfing is my Tessitura research tool of choice.
BONUS TOOL-RELATED TRIVIA: The opposite end of the striking face of a hammer is called the 'peen'.
In the job that updates lt_sub_hist for us we've got a cursor that makes it so it'll run for any active season, which may not be what you want, but it is handy for not needing to manually add new seasons when they're created. Worth considering.