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.
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
Update Status to 9 to suppress notifications to member.
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
update BGRS_CSRSignInfo set used='9'
-- select * from BGRS_CSRSignInfo
where MoveId='45144' and SupplierInvoiceID in ('5022', '4834')
IF @@ERROR <> 0 or @@rowcount <> 2