Revised energy (kWh and Therm) savings calculations for Fuel Substitution measures, per ED direction. Specific calculations are addressed in the User Guide.

Removed table fields

• DeemedMeasure.NTG_ID (already in the Claim table and required field when DeliveryType does not equal 'C&S')

• DeemedMeasure.DeliveryType (already in the Claim table and required field)

• Claim.MarketEffectsBenefits

• Claim.MarketEffectsCosts

Added table fields

• Claim.DEER_Sector

• Claim.PriorYearClaimID

• DeemedMeasure.DEER_MeasureID

Updated table fields

The change allowed NumRange for EUL_Yrs from [0,30] to [1, 30]

Added value lists

• DEER_Sector

• DEER_MeasureID

Added validation rules

• DEER_MeasureID requirement for DEER measures

• For Fuel Substitution measures, require either:

  • Positive UnitkWh1stBaseline AND negative UnitTherm1stBaseline OR

  • Positive UnitTherm1stBaseline AND negative UnitkWh1stBaseline

Readme

Updated Claim PII QC script, shown in Readme, to exclude Site and Contact data for Population-level NMEC

Rule added to the list of validation conditions in ReadMe to support new validation rule for Fuel Substitution measures

Added clarifying ProgramCost information to the Specification Notes of the Readme

Corrections

• Correction to ChangeLog entry on 2017-05-15: The line reading "DEER values remain valid in CEDARS for one year past expiration" is incorrect. The language should read, "DEER values are valid between the StartYear and EndYear, inclusively, as specified in the value list. The values are removed from the value list the year following the EndYear."

• Correction to Date for ChangeLog entry on 2018-10-23: The 2019 Spec updates were actually made on 2019-05-01.