Back to Home

CEM Audit Stuck

Overview

Business will request to update the AuditStageNo of a CallTransactionID depending on the situation.

A stuck audit is usually specified as AuditStageNo 19.

• Send to Closed (20)
• Send to Call Supervisor Stage (9)

Send to Closed

Example Script

UPDATE smart.Audit_CallRecord SET StageNo 20 WHERE CallTransactionID = '123455678912'

Send to Advocate Supervisor Review

Example Script

UPDATE smart.Audit_CallRecord SET StageNo = 9 
WHERE CallTransactionID = -- add string value here

UPDATE smart.Audit_ErrorCharged SET isSubmit = 0, NeedResponse = 1, Closed = 0 
WHERE UniqueErrorNo = -- add int here

Extra Considerations: Use UniqueCallNo value from the smart.Audit_CallRecord table to find the value in smart.Audit_ErrorCharged table isSubmit, NeedResponse, Closed values may depend on what other errors show. (Confirm with BK)