Hi all -
I got an email from our website developer saying he needs Term ID's and/or Tessitura ID Values. It looks like our developers need these to put in all of the hard coded setup values for our new season for the website. This is my first time dealing with this and I am totally clueless as to where to find these. No one else seems to remember who pulled them for the previous season but I don't believe they are here anymore.
I have placed examples below.
student_type: 187
faculty_staff_type: 49
standard_price_type: 186
I'm sorry if none of this makes sense - thank you in advance!!
Thank you all for your prompt responses!
So here is the full list. It's not all based on price types so that's why I'm a little confused. Does this help give a little more information? Sorry I'm just really clueless when it comes to this type of stuff! Also something I should have noted is the number values are based off of the past season.
student_type: 187 faculty_staff_type: 49 standard_price_type: 186 free_performance_price_type: 70 last_season_subscriber_sample_constituency: 128 silver_donor_sample_constituency: 33 patron_donor_sample_constituency: 42 web_interests: 3 web_alerts: 4 available_seat: 0 default_mode_of_sale: 18 package_mode_of_sale: 21 default_facility_no: 15 default_business_unit: 3 current_season_no: 107
Hi Ashli,
Based on what you provided I *think* the following is where you'll find the info you need, but this is a bit of a guess, and you'll want to get in touch with your integrator and ask where the values are used on your site and for what purpose - that will help understand in the future what you need to provide. You also may want to ask them to put the values in a place where you can update them each year, if possible.
I'm guessing these are all pricetypes:
student_type: 187faculty_staff_type: 49standard_price_type: 186free_performance_price_type: 70
If you didn't build any new pricetypes for this year, then they could be the same. If you have any new pricetypes for the new season, you'll want to check with your vendor to see if you need to provide the Ids. You can find the Pricetype IDs in Ticketing Setup->Pricing Setup->Pricetypes->Id column.
----------------------
These are constituency IDs -
last_season_subscriber_sample_constituency: 128silver_donor_sample_constituency: 33patron_donor_sample_constituency: 42
Your development / fund raising team will probably be able to tell you if any of these changed.
------------------
Perhaps a Keyword Category ID?web_interests: 3
Check with your integrator on this to be sure. If so, this is maybe keyword category ID, that contains all of the interests you want to display online. If that's the case, then you can find the ID in TR_TKW_CATEGORY in system tables.
No idea what this is, you'll need to ask your web integrator what it is used for...web_alerts: 4
-------------------
No idea what this is, you'll need to ask your web integrator what it is used for...available_seat: 0
-----------------
These are Mode of Sale IDs. default_mode_of_sale: 18package_mode_of_sale: 21
If you want to use different or new modes of sale on your site this season, you'll want to provide them with the Ids. You can find the Ids in Ticketing Setup -> Modes of Sale -> ID column
--------------------
Facility ID - default_facility_no: 15
If you need to provide a new facility, you can find the ID in Ticketing Setup->Facility Manager->Facility Tab->ID.
Business Unit IDdefault_business_unit: 3
Your default business unit is highly unlikely to have changed. But you can look in TR_BU to see if you need to use a different business unit online.
---------------
This looks to be the SeasonId from TR_SEASON of your current Season.
current_season_no: 107
You can look in System Tables, at the TR_SEASON table and find the ID of the season you are looking for.
Hope its helpful! All this stuff is different for custom websites, so its a bit hard to tell what they need from some of the descriptions.
Chris