Reference ZenDesk Incident: #1333100

Summary:  The claims team accidentally accepted an advance request on a member file within iZone IRP before validating all the required information was present. 

At this point the advance request has gone to the 2nd level reviewer.  Unfortunately they do not have the ability to revert the status.

• Member File # IA 202100009
• Claim/Advance ID 1456808 – Lease Liability for $930.00

NOTE: We do not remove or reject advances on member files.  What we will do is reset the advance status to "Waiting for Audit" and allow the business to determine what needs to be actioned on the advance. 

Troubleshooting:

1. Login to IRP iZone> Open the member file > Click on Advance Request from the "File Profile" menu.

2. Locate and validate the status of the advance 1456808.

3. Login to the IRP DB 10.139.88.101\IRP

--Locate the advance on member file with claim ID
select * from AdvanceRequest where ProjectId = 'IA 202100009' and ClaimId='1456808'
--Validate Claim_ID status in database
select * from claim where projectid='IA 202100009' and claim_id='1456808'

Status codes:

--1 - Pending for submit

--2 - Waiting for audit

--3 - Accepted for payment

--4 - New Claim

--5 - Audit Complete

--6 - Approved

--7 - Declined

Resolution: We need to update the Claim_ID status to "Waiting for Audit"so that the claim is in a modifiable state for the Claims team. 

Use irp
Begin tran
Update claim
set claim_status = '2'
-- select * from claim
where claim_id ='1456808' and projectid ='IA 202100009'
IF @@ERROR <> 0 or @@rowcount <> 1
BEGIN
ROLLBACK TRAN
RETURN
END
Commit tran

Once DBA has applied the DBCR go into DB and iZone and validate the status of the claim has been updated.