Skip to main content

Stream - What is the correct field to pick up rollover rates in the letter XML?

Upasana Mukherjee
  • Updated

Overview

You want to identify the correct field to pick up rollover rates in the letter XML. You may want it for regions NY/PA.

 

Information

The field "RolloverFRRate" in the letter XML holds value for the rollover rate.

<supportagent>

For your reference, a sample XML with the field/attribute "RolloverFRRate" and the query used to fetch it are given below.

You need access to the Client database to run this query. 

use paes_stream;
select letterxml from letter where letterid = 3548757
<Letter><Attachments PDFServerPackage="http://PDFServer/Docs/SGE/SGE.PKG">
<Attachment Location="Letters\OH_ContractRenewalSecond_Resi_Elec_Eng_v1.doc">
<Info First_Name="Lewis " Last_Name="Carbone" CustomerName="Lewis Carbone" 
Mailing_Address1="52 Townsend Ave" Mailing_Address2="" City="Norwalk" 
State="OH" Zip="44857" CustNo="3001865892" ServiceAddress1="52 TOWNSEND AVE" 
ServiceAddress2="" ServiceAddressCity="NORWALK" ServiceAddressState="OH" 
ServiceAddressZip="44857" Letter_Generation_Date="7/17/2021" 
CURRENT_PRODUCT_NAME="20 Month Fixed Rate Plan" 
EXP_DATE_OF_CURRENT_AGREEMENT="08/31/2021" 
PRICE_TO_COMPARE="" Utility_Number="08022184650000608824" 
M2M_Rate="" RateAmount="0.0000 per kWh" LetterDays="45" 
Customer_RateDetailID="2999430" ClientName="" MailingAddress1="" 
MailingAddress2="" MailingCity="" MailingState="" MailingZip="" 
CustomerCareInfo="" Hours="" FooterLine1="" FooterLine2="" 
RateProduct="20 Month Fixed Rate" BillingAcctNo="3001865892" 
PremDesc="52 Townsend ave , Norwalk, OH 44857" M2MProductName="" 
M2MCustFeeAmt="$0.00" M2MCancelFeeAmt="$0.00" RollOverCancelFeeAmt="$0.00" 
EnrollDate="12/28/2019" COMMODITY_TYPE="Electric" RollOverProduct="$75.00" 
CurrentProductCF="$150.00" UtilityContactInformation="Ohio Edison: 1-888-544-4877" 
LDC="Ohio Edison" LDCPhoneNumber="1-888-544-4877" Utility_Name="Ohio Edison" 
RollOverTerms="" RolloverFRRate="$0.0000" BundledRolloverFRRate="$0.0000" 
LetterTypeID="4539" Incentives="Not Applicable." 
FixedRateProductName1="6 Month Fixed Rate Plan" FRRate1="$0.046800" 
FRCancelFee1="$75.00" FRCustFeeAmt1="$0.00" 
FixedRateProductName2="12 Month Fixed Rate Plan" FRRate2="$0.055000" 
FRCancelFee2="$150.00" FRCustFeeAmt2="$0.00" 
FixedRateProductName3="18 Month Fixed Rate Plan" FRRate3="$0.065800" 
FRCancelFee3="$150.00" FRCustFeeAmt3="$0.00" HdgName="" HdgRate="" 
FixedRateProductName4="" FRRate4="" FRCustFeeAmt4="" FRCancelFee4="" 
FixedRateProductName5="" FRRate5="" FRCustFeeAmt5="" FRCancelFee5="" 
FixedRateProductName6="" FRRate6="" FRCustFeeAmt6="" FRCancelFee6="" 
FixedRateProductName7="" FRRate7="" FRCustFeeAmt7="" FRCancelFee7="" 
FixedRateProductName8="" FRRate8="" FRCustFeeAmt8="" FRCancelFee8="" 
FixedRateProductName9="" FRRate9="" FRCustFeeAmt9="" FRCancelFee9="" 
FixedRateProductName10="" FRRate10="" FRCustFeeAmt10="" 
FRCancelFee10="" /></Attachment></Attachments></Letter>

Alternatively, you can use this query to get the most recent letter for a customer and check the field value. Replace the paramter custno with the customer account number.

select letterxml
from letter l
join customer c on c.custid = l.custid
where custno = '12345'
order by letterid desc

</supportagent>