Overview

You want the ista account numbers and email addresses for a list of your customers in case of Incomplete Orders for utility AGL.

 

Solution

Open a Support ticket with the customer numbers or LDC account numbers/premise numbers and customer names whose ista account number and email address are required. Support will provide the same to you.

<supportagent>

The client Stream Energy typically raises this data request.

Prerequisites:

• Access to the Client database

Steps:

1. Usually, a range of customer information is provided by the client. A sample is shown below.
You only need to note the Account Number and Customer Name.


 
The provided Account Number is either the LDC Account Number/Premise Number or Account Number corresponding to a Customer Name. If it is not explicitly mentioned in the ticket, you need to try the queries listed below (after modifying the parameters) to fetch the requested information. If, however, it is explicitly mentioned, you can follow steps 2 or 3, depending on the provided information.

2. Run the following query to get the account number (considering LDC Account Number/Premise Number is given) and email address.
Replace the parameter pm.PremNo with the given Account Number.

use paes_stream

select ct.CustNo, pm.PremNo,ct.CustId, ad1.Addr1,ad1.email as 'Billing Email', 
ad2.email as 'Premise Email'
from Customer ct 
join Premise pm on pm.CustId = ct.CustId 
join Address ad1 on ad1.AddrId = ct.MailAddrID 
join Address ad2 on ad2.AddrId = pm.AddrId
where pm.PremNo in ('00000000004459999999')

Note: The PremNo column stored in the table may have left padding or leading zeroes and the provided Account Number may not have these (4459999999). If no query result is returned by using the provided number as-is, try replacing the filter condition in the query with pm.PremNo like ( '%4459999999')

3. Alternatively, run the following query to get the LDC Account Number/Premise Number (considering Account Number is given) and email address. Or, use it if the query result from step 2 does not return any rows (after trying the tip in 'Note').
Replace the parameter ct.CustNo with the given Account Number.

select ct.CustNo, pm.PremNo,ct.CustName, ct.CustId, ad1.Addr1,
ad1.email as 'Billing Email', ad2.email as 'Premise Email',  pm.PremNo
from Customer ct
join Premise pm on pm.CustId = ct.CustId
join Address ad1 on ad1.AddrId = ct.MailAddrID
join Address ad2 on ad2.AddrId = pm.AddrId
where ct.CustNo in ('6384444444')

4. In case, you cannot fetch any information using the provided LDC Account Number/Premise Number or Account Number, you should run the following query using the provided Customer Name.

Replace the parameter ct.CustName with the given data.

select ct.CustNo, ct.CustId,ct.CustName, ad1.Addr1,ad1.email as 'Billing Email', 
ad2.email as 'Premise Email',  pm.PremNo
from Customer ct
join Premise pm on pm.CustId = ct.CustId
join Address ad1 on ad1.AddrId = ct.MailAddrID
join Address ad2 on ad2.AddrId = pm.AddrId
where ct.CustName like '%JOHN DOE%'

5. From the query result, get the data for CustNo/PremNo (depending on whether Account Number or Premise Number is requested), Billing Email, and Premise Email. Append it to the sheet/excel provided by the client and share it.

</supportagent>