Back to Home

Inventory Management

1. Remove Audits Not Needed

Sometimes the auditor can not finish the audit allocated for the month and the remaining new audits need to be removed so they can move on to the next month.

Steps

1. Open Remove_Audits_Not_Needed.sql
2. Update the filters and see if the counts are close to the information given by the business. Most of the time, the counts do not match because the auditors are working on the claims.
3. Update the filters below COPY BELOW comments
4. Copy update query to the new window and send out to Bud and Alexandra to be sent to DEVOPS.

--Remove_Audits_Not_Needed.sql
USE SAM_AUDIT
GO
select uniqueclaimNo INTO #UCN FROM smart.sam_audit_open where sampleNo IN (1427,1422) and reportMonth = '2/1/2020' and auditstageNo = 1

update smart.sam_audit_open set deleted = 1 where UniqueClaimNo IN (select UniqueClaimNo FROM #UCN)
update smart.sam_audit_log set auditorNo = 3 where UniqueClaimNo IN (select UniqueClaimNo FROM #UCN)