Term ID/Tessitura ID Values

 If it is for a season, does he maybe need the PSN (Production Season ID)?

This is what generally pulls the productions into TNEW.

Hi Ashli, 

Do you know if the Ids you posted above are for pricetypes that need to be offered to your patrons online?

Chris

or price type IDs -

Now looking at the full post and seeing others comments (I was looking quickly on my phone - sorry) It seems more like Mary might be correct and they are referencing price type IDs.

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: 187
faculty_staff_type: 49
standard_price_type: 186
free_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: 128
silver_donor_sample_constituency: 33
patron_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: 18
package_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 ID
default_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