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.
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'
--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.
set claim_status = '2'
-- select * from claim
where claim_id ='1456808' and projectid ='IA 202100009'
IF @@ERROR <> 0 or @@rowcount <> 1
Once DBA has applied the DBCR go into DB and iZone and validate the status of the claim has been updated.