Address Correction procedure

Lf_titlecase

 -steve carlock

Information Technology Manager

The Granada

jsc@granadasb.org

(805) 879-3681x111 (office)

(805) 899-3002 (fax)

(562) 239-7075 (cell)

It is apparently my week for goofy questions.

A user enters "State Farm Insurance" into the Opt. Address field (street2 in t_address) and after the record is saved, it is auto-corrected to "State FaRoom Insurance".

I know there is a stored procedure somewhere that controls the specific corrections and is triggered anytime there are changes made on the constituent's record. About a year a go I had to modify it so that "Ste." was changed to "Suite" instead of "Streete".  But the intervening months have erased the name of the procedure from my memory. Searching for Address Correction on the site doesn't give me anything.

Does anyone know where the procedure is located?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Lf_titlecase

 -steve carlock

Information Technology Manager

The Granada

jsc@granadasb.org

(805) 879-3681x111 (office)

(805) 899-3002 (fax)

(562) 239-7075 (cell)

It is apparently my week for goofy questions.

A user enters "State Farm Insurance" into the Opt. Address field (street2 in t_address) and after the record is saved, it is auto-corrected to "State FaRoom Insurance".

I know there is a stored procedure somewhere that controls the specific corrections and is triggered anytime there are changes made on the constituent's record. About a year a go I had to modify it so that "Ste." was changed to "Suite" instead of "Streete".  But the intervening months have erased the name of the procedure from my memory. Searching for Address Correction on the site doesn't give me anything.

Does anyone know where the procedure is located?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!