Adding additional salutations

Hi Christina,

Actually in the system table TR_CUST_TYPE, you can define which salutation you want the default salutation to be by customer type.  Of course whatever you define there would be the default for all departments, not just development.  And in TR_SALUTATION_FORMAT, you can control how you want the salutation built. 

Those two tables might solve it for you.

Tanya

Our development department would like to have additional salutations automatically added when a new account is created.  They've been manually changing the default salutation type to preferred and then adding an informal salutation.  I know that this is something I could do with a stored procedure, but being that we are pretty new to Tessitura I have never written a stored procedure.  Could I modify the stored procedure that creates the default salutation?  Can someone point me in the right direction? Or if you're feeling generous perhaps share a stored procedure you've created to do this?  

Thanks!

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!

Hi Christina,

Actually in the system table TR_CUST_TYPE, you can define which salutation you want the default salutation to be by customer type.  Of course whatever you define there would be the default for all departments, not just development.  And in TR_SALUTATION_FORMAT, you can control how you want the salutation built. 

Those two tables might solve it for you.

Tanya

Our development department would like to have additional salutations automatically added when a new account is created.  They've been manually changing the default salutation type to preferred and then adding an informal salutation.  I know that this is something I could do with a stored procedure, but being that we are pretty new to Tessitura I have never written a stored procedure.  Could I modify the stored procedure that creates the default salutation?  Can someone point me in the right direction? Or if you're feeling generous perhaps share a stored procedure you've created to do this?  

Thanks!

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!