Hello wise Tessitura users and Tessitura staff,
We're making some business practice decisions and have been discussing the newly added Street 3 line. I see that using it is optional but before we start to think about what sort of data might live there one of our users had an excellent question. How does Street 3 play with NCOA? We are currently using (and loving) the NCOA utility every 90 days and plan to continue to do so. Does anyone know if the NCOA utility will put any data in Street 3? Conversely if we put data there will it wipe it out?
Thank you for any insight you can provide!
Kjersten
Hi Kjersten,
MBS is set up to deal with only two address lines for processing, mostly because that's what the USPS's NCOA system lends itself to.. So the way we've implremented this in v11 is as follows:
1) All 3 Tessitura address lines will be copied around from the export, to the re-import, to the processing. You won't lose any data.
2) A new parameter has been added to the NCOA Utility in Tessitura. You can now pick "street 2 or 3".. What this means is that address line 1 will *always* be considered for processing, and you can chose whether you want to use line 2 or 3 for processing. The parameter will apply to the entire set of records you are exporting/processing. If you choose to process address line 2, address 3 will still be copied around and re-imported exactly as you had it. If you choose to process address 3 as the second NCOA line, then Tessitura address line 2 will still be copied around and preserved, just as you had it.
After a lot of discussions with MBS, we determined that trying to include a 3rd line in the NCOA processing wasn't going to help, and would be a lot of work, and could be different for different users. I'm hopeful that this hybrid approach will leverage the flexibility of a third address line where needed, while still preserving the usefulness of the NCOA and standardization processing.
I hope this helps, and am glad you are a happy user of the utility!
Rob(tm)
Rob,
Thank you so much for the fabulously complete answer! It is very helpful.