Overview

You want to update the referrer ID/referrer's RFID for an account ID for one of your customers.

Solution

Open a support ticket with the below information:

• Referrer ID: The ID of the referrer
• Account ID: The account number for whom the information needs to be updated

<supportagent>

For updating the Referrer's ID, we update the table ClientCustomer.CustomerAdditionalinfo and update the provided value of the referrer ID in the ReferAFriendToken column for the mentioned account ID.

On QAT, Query ID 1003 can be used to update this ID.

Once the update has been made, it can be checked with the below steps:

1. Login to the Jump server 10.185.40.141.
2. Open Microsoft SSMS and connect to aes.cons.com.
3. Select New Query in the top bar.
4. Run this query:

use paes_spark;
SELECT ReferAFriendToken FROM ClientCustomer.CustomerAdditionalinfo WHERE CustID=(SELECT custID FROM customer WHERE custno='<client provided account number>');

or on the CSR UI, in Account Information Section (Bottom)

</supportagent>