Reference ZenDesk Incident: 1884113

Description: A member has updated their CSR - Certificate of Service Received for their Home Sale claim in MSW and have uploaded the required documentation however the member is constantly being notified the action as not yet been completed.

Troubleshooting:

Login to 10.139.88.201\servicengine

--Obtain member movid

select * from customer where cust_ref_nbr='2848267221'

-- Search CSR table with members moveid and review the column 'Used'

select * from BGRS_CSRSignInfo where moveid='45144'

Note:The used column is set to 0 which means the CSR is outstanding 

F

Solution:

Update Status to 9 to suppress notifications to member.

Note:

Used Status 0 = No

Used Status 1 = Yes

Given that we cannot accept the CSR on behalf of the member we set it to 9 to disable notifications 

use Servicengine

Begin Tran

update BGRS_CSRSignInfo set used='9'

-- select * from BGRS_CSRSignInfo

where MoveId='45144' and SupplierInvoiceID in ('5022', '4834')

IF @@ERROR <> 0 or @@rowcount <> 2

BEGIN

ROLLBACK TRAN

RETURN

END

Commit tran