12 lines
863 B
SQL
12 lines
863 B
SQL
/*
|
|
* The letterdescription must match the letters in Temenos. If the business changes the letters
|
|
* you'll need to update and deploy this to match so that the alerts continue to function.
|
|
*/
|
|
update letters set LetterDescription = 'None'
|
|
update letters set LetterDescription = 'Right to Reinstate/Redeem' where ActionCode = '701'
|
|
update letters set LetterDescription = 'Surrender (Illinois)' where ActionCode = 'ILLSU'
|
|
update letters set LetterDescription = 'Notice of Repossession' where ActionCode = 'LTR34'
|
|
update letters set LetterDescription = 'Notice of Plan to Sell - WI' where ActionCode = 'LTR35'
|
|
update letters set LetterDescription = 'WI Unsecured RTC' where ActionCode = 'RTC 1'
|
|
update letters set LetterDescription = 'WI Auto RTC' where ActionCode = 'RTC 3'
|
|
update letters set LetterDescription = 'Surrender (Wisconsin)' where ActionCode = 'VOL' |