Hello,
We recently changed an organizational protocol regarding patron records and entering their company name when their address happens to be their business address. According to our box office/USPS resources, the street 2 field is best used for the company name. For example:
Jon Smith
281 Huntington Avenue
Huntington Theatre Company
Boston, MA 02115
This looks SOOOOOO BIZARRE to me, but we agreed to move forward with this way of entering business information into mailing addresses.
Fast forward to last week when we ran our NCOA and the street 2 data for a few of these patrons has been erased and updated. We are still in the process of evaluating as to how many this happened to and it may not be that big of a manual fix, but I'm wondering if anyone else has had this issue.
My solution in the future is to track these addresses with a different address type and filter them from the NCOA, but in the meantime, I'm curious what others are doing? Are you entering the organization name in the street 2 field? Is that recommended?
Thanks!
Tiffany
Good to know it’s not just us. The option to update street 2 is a parameter in the NCOA update, but I think we have always selected it and it’s never been a problem before. Then again, we were not ever really consistent with where we were entering company name before we decided on street 2 this year. Maybe we’re just noticing the impact of the update for the first time.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Thursday, January 07, 2016 4:51 PM To: Tiffany Elliott Subject: Re: [Tessitura Ticketing Forum] NCOA Street 2 Business Address /Company Name
Tiffany Elliott: Are you entering the organization name in the street 2 field? Is that recommended?
Tiffany Elliott:
Are you entering the organization name in the street 2 field? Is that recommended?
We have always entered org name data in Street2, with Street1 always used for the actual USPS address line. For display, printing, etc., we sort the data
Street2
Street1
City/State/Zip
(The above is set in the Tessitura client in T_DEFAULTS, field name "ADDRESS_STREET_ORDER")
This order has worked fine for NCOA updates (Streets other than 1 are ignored by these updates, which may be optional, I forget).
From: Tiffany Elliott <bounce-tiffanyevans7088@tessituranetwork.com> Sent: 1/7/2016 4:31:10 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Unknown said: ... Then again, we were not ever really consistent with where we were entering company name before we decided on street 2 this year...
Same here, which is no doubt why we always skip street2 re: NCOA updates. Many updates later, no issues.