I am aware from searching other forum discussions (and from experience) that the NCOA utility will overwrite the previous address, but that you can still find it in the Audit screen of the Transactions tab in the record. I'm curious if anyone has found a way to retrieve that data and create a Postal Address record, select "Previous Address" type and mark it "Inactive"? Or are there any other creative solutions to solve for 'x' here?
Any insight from the community would be greatly appreciated.
Thanks,
Michael Dorsey
Hi Michael,
We have exactly that! We created a custom script that we run after running the NCOA utility to add back the deleted address as an inactive address so we can see the old record. We don't change the address type in the process, just re-adding as an inactive address. If you or someone at your organization is familiar with running SQL queries I'm happy to send our script along.
Sara
Hi Sara,
I would also love to snag a copy of this - we are in the beginning stages of implementing Tessitura, so we're not *quite* ready to run this; but, we definitely want to keep tabs on this kind of thing, too!
fkelly@vwfoundaiton.org