CET 25.1 code updates

[sureL]

Tables

Table E3Settings

Add columns

• DiscountRateAnnual_SCT: Value is .0503 for all rows
• DiscountRateQtr_SCT: Value is .012575 for all rows

Table E3AvoidedCostGasSeq2026

Add columns

• Commodity_SB - Societal base commodity costs
• TD_SB - Societal base T&D costs
• Total_SB - Societal base total costs
• Commodity_SH - Societal high commodity costs
• TD_SH - Societal high T&D costs
• Total_SH - Societal high total costs

Views

View Settingsvw

Add columns

• Ra_SCT - Equal to: DiscountRateAnnual_SCT
• Raf_SCT - Equal to: DiscountRateAnnual_SCT + 1
• Rq_SCT - Equal to DiscountRateQtr_SCT
• Rqf_SCT - Equal to: DiscountRateQtr_SCT + 1

View AvoidedCostSourceGasvw

Add columns

• Commodity_SB - i. Societal base commodity costs
• TD_SB - Societal base T&D costs
• Total_SB - Societal base total costs = Commodity_SB + TD_SB
• Commodity_SH - Societal high commodity costs
• TD_SH - Societal high T&D costs
• Total_SH - Societal high total costs = Commodity_SH + TD_SH

View AvoidedCostGasvw

Add columns

• Cost_SB - Equal to Total_SB from AvoidedCostSourceGasvw
• Cost_SH - Equal to Total_SH from AvoidedCostSourceGasvw

Stored Procedures

CalcCE

• GasBen_SB - Societal Base Gas Benefits
• GasBen_SH - Societal High Gas Benefits
• GasBenGross_SB - Societal Base Gross Gas Benefits
• GasBenGross_SH - Societal High Gross Gas Benefits
• WaterEnergyBen_SB - Societal Base Water Energy Benefits
• WaterEnergyBen_SH - Societal High Water Energy Benefits
• WaterEnergyBenGross_SB - Societal Base Gross Water Energy Benefits
• WaterEnergyBenGross_SH - Societal High Gross Water Energy Benefits
• GasSupplyCost_SB - Societal Base Gas Supply Costs
• GasSupplyCost_SH - Societal High Gas Supply Costs
• GasSupplyCostGross_SB - Societal Base Gross Gas Supply Costs
• GasSupplyCostGross_SH - Societal High Gross Gas Supply Costs
• WaterEnergyCost_SB - Societal Base Water Energy Costs
• WaterEnergyCost_SH - Societal High Water Energy Costs
• WaterEnergyCostGross_SB - Societal Base Gross Water Energy Costs
• WaterEnergyCostGross_SH - Societal High Gross Water Energy Costs
• BillIncrElec - Fuel Substitution bill Increases for electric
• BillIncrGas - Fuel Substitution bill increases for gas

To do list taken from update specification document sent by Jake R: CET V25.1 Update Specification.docx

[sureL]

Table E3Settings

--select * from E3Settings;

alter table E3Settings 
add DiscountRateAnnual_SCT float;

alter table E3Settings 
add DiscountRateQtr_SCT float;
go

update E3Settings set DiscountRateAnnual_SCT = 0.0503;
update E3Settings set DiscountRateQtr_SCT = 0.012575;
go