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?
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