Skip to main content

Stream - Renewal rate display in CEN

Upasana Mukherjee
  • Updated

Overview

You want that customers will auto-renew to a fixed rollover product and the renewal rate will display in the Contract Expiration Notice (CEN).

 

 

Solution

There is no need for the Plan Type and Rate Type for given fixed rollover products for a utility to be revised to a 'Fixed' Plan Type and a 'Fixed Rate Calculation' for Rate Type. Updating the ActiveEnrollmentFlag to 1 for these rollover products is sufficient to enable the customers to auto-renew to them and the renewal rate to display in CEN. 

Please raise a support ticket with us mentioning the ProductCode for the products that you want us to make the change to. We will update the ActiveEnrollmentFlag for these products and inform you.

<supportagent>

Pre-requisite

Access to the Client database

 

1. Run the select query below to get the productid for the given products.
Replace the parameter productcode with the given list of product code.

use paes_stream;

select productid
from product 
where productcode in ('IL_COMMED_E_24MO_RO', 'IL_COMMED_E_12MO_RO')

2. Run the update query below. 
Replace the parameter productid with the values fetched in the previous step.

update product
set ActiveEnrollmentFlag = 1
where productid in (4045, 4046)

 

</supportagent>