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'.
Levi,
Season type would probably work now – we’re still new enough that things kept cropping up and the season types were still in flux. I’ll mention that at our next Tess Team meeting and see if we think it’s stable enough now.
Thanks.
-steve
Information Technology Manager
The Granada
(805) 899-3000 x 111 (phone)
(805) 899-3081 (fax)
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Thursday, June 17, 2010 12:26 PM To: Steve Carlock Subject: RE: [Tessitura Technical Forum] Subscription Question
Steve,
Would it work to distinguish them through Season Type? Set up a couple of new rows in tr_season_type and drive the cursor from there?