Skip to main content

Providing details for GA Accounts

Upasana Mukherjee
  • Updated

Overview

You want all of the GA accounts with the details Customer Name, Ista Account Number, LDC #, Service Address, and Account Status. You may also request the SQL script for this report.

 

Solution

Please raise a support ticket with us specifying the set of details (as mentioned above) you are looking for. We will share the report and the SQL script for this report.

<supportagent>

Prerequisites:

  • Access to the Client database

 

Steps:

1. Run the query below.

Select Distinct CustName[CustomerName],
CustNO[Account Number],
PremNo[UAN],
Concat(Addr1,'',addr2,' ',city,' ',State,' ',Zip)[Service Address],
PS.Status
From Customer C
Join Premise P on P.CustID=C.CustID
Join LDC L on L.LDCID=P.TDSP
Join Market M on M.MarketID=L.MarketID
Join Address A on A.addrID=P.addrID
Join PremiseStatus PS on Ps.PremiseStatusID=P.StatusID
Where 1=1
and M.MarketID=17

2. Share the query result with the client.
If the SQL script is requested, share the query from the previous step.

</supportagent>