/
VALIDATION OF CLAIMS ABOVE 6 MONTHS

VALIDATION OF CLAIMS ABOVE 6 MONTHS

Owned by Mary-Cynthia Ejike, created
Last updated: Mar 18, 2025

This document explains and contains a step by step guide in validating claims

 

INSTRUCTIONS

  1. Download the excel file from the email received

image-20241218-162253.png
image-20241218-162130.png

  1. Open the excel sheet copy the RRN column.

  2. Insert the RRN in the brackets of all 4 queries below

  3. BANK QUERY FOR DATABASE SPOOLING

  4. Get a session with the bank to access the database server and access the bank server via the Password Page.

  5. RUN your queries on the database server

  6. Download the result of the queries on an excel sheet gotten from the server.

    Download the excel sheets given to you by the moniepoint officer from the slack channel and do a comparison with your spooled data gotten from the banks database.

Steps to run comparison checks on the documents

 

  1. Combine the TID number and RRN on the sheet using

    = concat(m2,f2) where m = column of TID and F = column of RRN and paste on a different column eg on Column S.

  2. Hover over the cell and drag it down to populate other cells.

    image-20250318-171901.png

  3. From the results gotten from the database table copy the TIDRRN and the Response code and paste on two separate columns in the excel sheet gotten from the moniepoint officer eg .TIDRRN on column U AND response_code on column V .

    image-20250318-173723.png

  4. Run a VLOOKUP on eg. column S using

=VLOOKUP(S2, U$2:V$81, 2, FALSE)

This shows the result of the response code.

a. TIDRRN with response_code :00 and Accepted the result is true /correct

b. TIDRRN with response_code :00 and Declined, Value Given the result is true /correct.

b. TIDRRN with response_code:91 and Accepted the result is false/Not correct and should be changed to Declined, Not Settled.

c. TIDRRN with response_code:91 and Accepted but the result is showing Null, first reverify from the banks database and after reverifying on the archived table (Date) it falls on and still not found, then escalate to TSE in charge of the bank

  1. Send the final result of this along with the receipts given to you via slack to the originating mail from the bank .