Good morning to you! J
One of my data specialists gave me a list of zip codes that do not show up in Tessitura. Who would we forward this to?
I did confirm these zip codes on http://zip4.usps.com/zip4/citytown_zip.jsp
72631 Eureka Springs, AK
95757 Elk Grove, CA
92867 Orange, CA
95377 Tracy, CA
59602 Helena, MT
30297 Forest Park, GA
89044 Henderson, NV
95811 Sacramento, CA
The table where you would add those is TR_CITYSTATE. Due to the size of this table you cannot access it from the System Tables screen. Updates to this table must be made from SQL Server.
New zip codes must be manually added to the table; they are not automatically added as they are used in the application. Existing entries may be edited if desired. The following columns in this table are required: zip5 (5 digit zip code), city, and state (postal abbreviation).
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
Thank you Kevin! Al doesn't let me play around in the SQL Server so I will email him the information and ask him to add them for me!
I appreciate you help! Will you be in San Antonio?