Has anyone created an anytime ticket for general daily admission (Zoo, Garden, Aquarium, Museum) that NSCAN will admit on any date of the year (in v15)? Business case: a company wants to buy 100 tickets at a group discount and give to employees but they don't know which date they'll attend. My initial idea was sell them on last day of the fiscal year, print out with text saying must "redeem" in person only, then exchange ticket for actual attendance date. Is there a more elegant solution?
Hi Shelley, the MN Zoo has been doing Anytime tickets for years. I make a new Anytime ticket performance at the start of each fiscal year. Since the volume on these tickets is small when I receive a new order I copy and make a new performance for the date of the sale (or visit) and sell Anytime tickets with it's own unique ticket design with expiration at the end of the year (or fiscal year). When the customer arrives to redeem the admission is recorded as a comp admission with Anytime reason code. In the past we also used to exchange unused admissions and reissue them each year so make sure your ticket design include the ticket number to facilitate this in the future. In V16 when the we will have larger N-Scan capacity we may change the expiration date to the year from issue date.
To add some context to Peter's response, we use a custom utility which is scheduled to update our NScan profiles daily. One of the parameters is "Always Include Performance Type." This results in any performance with that performance type automatically being added to our NScan profiles daily. Without the custom utility, someone would have to manually add the performances to the TR_NSCAN_PROFILE system (reference) table daily.
This text is from the description part of the utility:
"This utility updates the Perf Str column of TR_NSCAN_PROFILE to support the Zoo's policy of accepting admission tickets without an expiration date.
The General Admission Facility parameter identifies the facility from TR_NSCAN_PROFILE that will have multiple performances included in the profile. The General Admission Start Date and End Date parameters identify the range of performances in that facility to include.
For the GA facility and the other facilities in the profile, the selected performances can optionally be limited to certain Titles and Productions.
Outside of any of the other parameters, the "Always Include" parameters identifies a performance type that can be used to add ad-hoc performances to the profile. The performance only needs to be in an active season.
Finally, only the profiles identified will be affected by the utility.
LRP_NSCAN_UPDATE_PROFILE"
--------
Last year, I created a custom table and added system/reference table (called a "local table") access to it so we can schedule these "Include in N-Scan" performances to no longer show up on the NScan profiles. We add the performance to the system table and schedule the date and time we want a SQL job to change the performance type to Default_perf_type. Once it does that, it no longer shows up on the NScan profiles.
Here is how to do it from the help system. I didn't know that the "how to" was in the help system. That would've been great to know about before I started.
Tessitura v15 Help System - Local Tables (tessituranetwork.com)
Neil
We have a really nice little customization set up. Unfortunately, the need for it perished shortly after implementation, so we haven't actually used it yet. But if we were, here's what we do: - Create a "Good Anytime" Prod. Season under the corresponding Production
- Create a "Good Anytime" Performance, on the expiration date (aka final exhibition date, fy end, etc).
- Assign custom Ticket Designs (Mobile & Boca) that have the correct information
- Dig into the Perf in TNEW and find the setting to hide it from the TNEW "Your Tickets" display (if any Mobile tickets are going to be issues directly to any constituent accounts)
- Update custom System Table with the Perf. ID's
Looking forward to using it in the future, whenever the need arises again. ES did the work for us.