Overview

You inquire how to fetch Agreement/Contract ID for gas accounts from the replication database.

Solution

<supportagent>

Only the client has access to their replication database raes_AEPEnergy.

</supportagent>

You can use the sample query below to fetch the Agreement/Contract ID from your replication database if you are referring to the RateTransitionID from the Rate Transition table as the Agreement ID.

SELECT DISTINCT cai.AccessDBID AS 'gSignature', 
p.premno AS 'Account Number',
 CONVERT(VARCHAR(20), rt.SwitchDate, 101) AS 'Start Date',
 CONVERT(VARCHAR(20), rt.EndDate, 101) AS 'End Date',
 ps.status AS 'Status', c.CustID AS 'Customer ID',
 p.premid AS 'Prem ID', 
rt.RateTransitionID AS 'Agreement ID'
from raes_AEPEnergy.dbo.Customer c
join raes_AEPEnergy.dbo.Premise p on c.CustID = p.CustID
join raes_AEPEnergy.dbo.PremiseStatus ps on ps.PremiseStatusID = p.StatusID
join raes_AEPEnergy.dbo.CustomerAdditionalInfo cai on 
c.custid = cai.custid AND (0 = NULL OR 0 = 0 OR 0 = cai.DivisionID)
join raes_AEPEnergy.dbo.RateTransition rt on rt.CustID = c.CustID
WHERE c.CustType = 'I'
AND p.PremType = 'Gas'
AND cai.AccessDBID = '645000015'