DEER Change Log

Connection to the DEER database--previously known as the Preliminary Ex Ante Review (PEAR) database*--is available via the following login information using a PostgreSQL database client such as Community Edition of DBeaver.

Host Address cpucexante.cwuiixjcexyp.us-east-1.rds.amazonaws.com
Port 5432
Public Username sptviewer
Public Password deereddev
Database DEER

 

 

 

 

* The exante database is no longer updated/maintained as of 2022-01-01 per Resolution E-5152 DEER2023 Update.

Record(s) Table Version Description Date Posted Start Date End Date Download Actions
New & Corrections EnergyImpact, Measure, Technology, TechType DEER2023

Added hot water space-heating boiler measures (NG-HVAC-Blr-HW-gt2500to10000kBtuh-87p3Ec-Drft, NG-HVAC-Blr-HW-gt2500to10000kBtuh-95p0Ec-CndLow, NG-HVAC-Blr-HW-gt2500to10000kBtuh-95p0Ec-CndReset, NG-HVAC-Blr-HW-gt2500to10000kBtuh-95p0Ec-CndStd, NG-HVAC-Blr-HW-gt2500to10000kBtuh-98p0Ec-CndLow, NG-HVAC-Blr-HW-gt2500to10000kBtuh-98p0Ec-CndReset, and NG-HVAC-Blr-HW-gt2500to10000kBtuh-98p0Ec-CndStd)

2022 Oct 26 2023 Jan 1 See history
New EnergyImpact, Measure, Technology, VersionSource DEER2023

Central Storage Water Heater Measures added (NG-WtrHt-Central-LrgStrg-Gas-gt75kBtuh-0p90Et, NG-WtrHt-Central-LrgStrg-Gas-gt75kBtuh-0p96Et).

2022 Oct 28 2023 Jan 1 See history
Revisions NTG_2020 DEER2023

Revised the start date for NTG_IDs for greenhouse measures (NonRes-sGHS-mHtCrtn-dn, NonRes-sGHS-mIRF-dn, NonRes-sGHS-mHtCrtn-ci, and NonRes-sGHS-mIRF-ci) from 2024-01-01 to 2023-01-01 to reflect change of Measure Application Type from Add-On Equipment (AOE) to Building Weatherization (BW).

2022 Oct 21 2023 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2023

Added commercial heat pump measures (NE-HVAC-airHP-SpltPkg-135to239kBtuh-10p8eer-3p48cop, NE-HVAC-airHP-SpltPkg-135to239kBtuh-11p2eer-3p51cop, NE-HVAC-airHP-SpltPkg-65to134kBtuh-11p5eer-3p50cop, NE-HVAC-airHP-SpltPkg-65to134kBtuh-11p5eer-3p50cop-wPreEcono, NE-HVAC-airHP-SpltPkg-65to134kBtuh-12p0eer-3p55cop, NE-HVAC-airHP-SpltPkg-65to134kBtuh-12p0eer-3p55cop-wPreEcono, NE-HVAC-airHP-SpltPkg-240to759kBtuh-9p7eer-3p30cop, NE-HVAC-airHP-SpltPkg-240to759kBtuh-10p0eer-3p30cop).

2022 Oct 20 2023 Jan 1 See history
Clarifications NTG_2020 DEER2024

Per Resolution E-5152 DEER2024 for Net-to-Gross (NTG) Table
Effective Program Year: 2024. Ever since the creation of the NTG_2020 table per Resolution E-4952 DEER2020 Update, Program Administrators have been asking for improvements to this table. To this end, a new table—serving as a companion to the NTG_2020 table—is proposed to clarify when a given NTG ID may be used. The planned companion table will contain a complete list of all valid combinations of NTG IDs, Measure Application Types, Measure Impact Types, and Delivery Types for deemed and custom measures. Within the NTG_2020 table itself, however, the existing string-type fields that contain sometimes-vague descriptions of which Measure Application Types, Measure Impact Types, and Delivery Types they can be used for will be deleted. 

2022 Sep 7 2024 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2024

Added ductless minisplit heat pump measures, SEER 20-22 (RE-HV-DHP-20S, RE-HV-DHP-20S-replRmAC-ER, RE-HV-DHP-21S, RE-HV-DHP-21S-replRmAC-ER, RE-HV-DHP-22S, RE-HV-DHP-22S-replRmAC-ER). 

2022 Sep 19 2024 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2024

Added ductless minisplit heat pump measures, SEER 16-19 (RE-HV-DHP-16S-replRmAC-ER, RE-HV-DHP-17S, RE-HV-DHP-17S-replRmAC-ER, RE-HV-DHP-18S, RE-HV-DHP-18S-replRmAC-ER, RE-HV-DHP-19S, RE-HV-DHP-19S-replRmAC-ER).

2022 Sep 19 2024 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2024

Added residential freezer and refrigerator measures (Res-Refg-dKWH-Cond, Res-Frzr-dKWH-Cond).

2022 Sep 17 2024 Jan 1 See history
New EnergyImpact, Measure, Technology, TechType DEER2024

Added residential SEER-rated HP measures (RE-HV-ResHP-16S, RE-HV-ResHP-17S, RE-HV-ResHP-18S, RE-HV-ResHP-19S, RE-HV-ResHP-20S, RE-HV-ResHP-21S).

2022 Sep 16 2024 Jan 1 See history
New EnergyImpact, Measure, Technology, TechType DEER2024

Added residential SEER-rated AC measures (RE-HV-ResAC-16S, RE-HV-ResAC-17S, RE-HV-ResAC-18S, RE-HV-ResAC-19S, RE-HV-ResAC-20S, RE-HV-ResAC-21S).

2022 Sep 16 2024 Jan 1 See history
New EnergyImpact, Measure, Technology, VersionSource DEER2023

Added Whole House Fan measures (WholeHouseFan-0.7CFM-ECM, WholeHouseFan-0.7CFM-PSC, WholeHouseFan-1.5CFM-ECM, WholeHouseFan-1.5CFM-PSC, WholeHouseFan-2.0CFM-ECM, WholeHouseFan-2.0CFM-PSC, WholeHouseFan-3.0CFM-ECM, WholeHouseFan-3.0CFM-PSC)

2022 Sep 15 2023 Jan 1 See history
New EnergyImpact, Measure, Technology, TechType DEER 2024

Added fan controls for residential SEER-rated split ACs (RE-ResAC-FanCtrls)

2022 Sep 14 2024 Jan 1 See history
New EnergyImpact, Measure, Technology, TechType DEER2024

Added residential fan motor measure (RE-BrushlessFanMotor)

2022 Sep 13 2024 Jan 1 See history
Corrections MeasImpactType DEER2026

The MeasImpactType table was updated to clarify FuelSub Measure Impact Type records.

2022 Sep 13 2026 Jan 1 See history
New EnergyImpact, Measure, Technology, TechType DEER2024

Added residential package terminal air conditioners and heat pumps (RE-PTAC-10.7to12.84EER-New, RE-PTAC-8.56to10.27EER-Ex, RE-PTHP-10.7to12.81EER-New, RE-PTHP-8.92to10.70EER-Ex)

Note: VersionSource was corrected on 2022-09-13.

2022 Sep 12 2024 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2024

Added residential furnace measures (Res-GasFurnace-AFUE92-ECM, Res-GasFurnace-AFUE95-ECM, Res-GasFurnace-AFUE97-ECM)

2022 Sep 13 2024 Jan 1 See history
Updated EnergyImpact DEER2023

For DEER2023 water heater measures that indicated that the normalizing unit was based on the input capacity (NormUnit=Cap-kBTUh), the VersionSource was updated to "DEER WaterHeater Calculator v5.1" and the normalizing unit was updated to output capacity (NormUnit=CapOut-kBtuh).

2022 Sep 9 See history
Corrections EnergyImpact DEER2023

All water heater EnergyImpact records were revised by correcting the NormUnit from Cap-kBTUh to CapOut-kBtuh. No other changes were made. This is consistent with the "DEER Water Heater Calculator v.5.1.xlsm" that is available at https://cedars.sound-data.com/deer-resources/tools/water-heaters/.

2022 Aug 29 2023 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2024

Added the following ceiling insulation measures using EnergyPlus residential building prototypes calibrated with 2019 RASS data and simulated using CZ2022 weather data:

RB-BS-CeilIns-VintR-AddR11
RB-BS-CeilIns-VintR-AddR19
RB-BS-CeilIns-VintR-AddR30
RB-BS-CeilIns-VintR-AddR38
RB-BS-CeilIns-VintR-AddR44
RB-BS-CeilIns-VintR-AddR60
2022 Aug 10 2024 Jan 1 See history
Revisions EUL_basis DEER2014, DEER2016

"Unexpired" some lighting EUL_IDs:

ILtg-CFL-Com, ILtg-CFLfix-Com, ILtg-CFLfix-Res, ILtg-CFLfix-ResCmnArea, ILtg-CFL-ResCmn, Iltg-Com-CldCthd-25000hr, ILtg-HID-Cmn, ILtg-HPS, ILtg-Incand-Com, ILtg-Incand-Res, ILtg-Induct-Elec, ILtg-Lfluor-Mag, ILtg-Lfluor-T12Mag, ILtg-MH, ILtg-T5, OLtg-CFL, OLtg-CFL-Cmn, OLtg-CFLfix, OLtg-CFLfix-ResCmnArea, OLtg-HID, OLtg-HID-Cmn, OLtg-HPS, OLtg-Induct, OLtg-LFluor-CommArea, OLtg-Lfluor-Mag, OLtg-LFluor-Res, OLtg-MH, and OLtg-T5.

2022 Aug 1 2022 Jul 28 See history
New EnergyImpact, Measure, Technology DEER2024

Added duct optimization measures (Res-DuctOpt-HighToLow-Retrofit, Res-DuctOpt-HightoLow-Replacement) for mobile homes.

2022 Jul 29 2024 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2024

Added duct sealing measures (RB-HV-DuctSeal-HighToLow and RB-HV-DuctSeal-MedToLow) using EnergyPlus residential building prototypes calibrated with 2019 RASS data and simulated using CZ2022 weather data.

2022 Jul 26 2024 Jan 1 See history
New EnergyImpact, Measure, Technology, & VersionSource DEER2024

Added wall insulation measure (RB-BS-BlowInIns-R0-R13) using EnergyPlus residential building prototypes calibrated with 2019 RASS data and simulated using CZ2022 weather data.

2022 Jul 22 2024 Jan 1 See history
N/A EnergyImpact DEER2024

The following fields have been added to the EnergyImpact table in DEER:

  • APreUseWBkWh & APreUseWBtherm
  • AStdUseWBkWh & AStdUseWBtherm
  • AMsrUseWBkWh & AMsrUseWBtherm
  • APreUseEUkWh & APreUseEUtherm
  • AStdUseEUkWh & AStdUseEUtherm
  • AMsrUseEUkWh & AMsrUseEUtherm
2022 Jul 22 2024 Jan 1 See history
New MeasImpactType DEER2022

Added MeasImpactType:

  • Cust-NMEC-Pop-FuelSub
2022 Jun 22 2022 Jan 1 See history
New NTG_2020 DEER2022

Added Measure Application Types (AOE, BRO-RCx, & BW) eligible for Direct-Install Delivery Type (DnDeemDI & DnCustDI) for the following NTG IDs:

  • Agricult-Default-HTR-di
  • Com-Default-HTR-di
  • Ind-Default-HTR-di
  • Res-Default-HTR-di
2022 Jun 22 2022 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2023

Added high-efficiency central DHW instantaneous boiler systems for MFm buildings:

  • NG-WtrHt-Central-Blr-gt150kBtuh-0p90Et
  • NG-WtrHt-Central-Blr-gt150kBtuh-0.96Et
2022 Jun 17 2023 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2023

Adding missing standard measures of split/package ACs: 

  • NE-HVAC-airAC-SpltPkg-240to759kBtuh-10p8eer
  • NE-HVAC-airAC-SpltPkg-240to759kBtuh-11p5eer
  • NE-HVAC-airAC-SpltPkg-240to759kBtuh-12p5eer

(Previously, only the single-zone and multi-zone component records had been uploaded.)

2022 May 27 2023 Jan 1 See history
New and Updated NTG_2020 DEER2024+

Added the following NTG IDs:

  • Res-sAll-mHVAC-SCT-dn (DEER2024)
  • Res-sAll-mHVAC-HP-MidDistr-FuelSub (DEER2024)
  • All-In-Ltg-LED (DEER2024)
  • All-In-Ltg-LEDFixt-dn (DEER2024)
  • All-In-Ltg-LEDFixt-mid (DEER2024)
  • NonRes-sAll-mIrrig-WellPump-VFD (DEER2024)
  • NonRes-sAll-mIrrig-Pump-eVFD (DEER2024)
  • Com-sAll-mFS-Fryer-dn (DEER2024)

Expired the following NTG ID:

  • Res-sAll-mHVAC-SCT-dn (DEER2022)
2022 May 25 2024 Jan 1 See history
New and Updated NTG_2020 DEER2024+

Added:

  • NonRes-sAg-mCust-ci (DEER2024)
  • NonRes-sAll-mCust (DEER2024)
  • NonRes-sAll-mCust-Elec (DEER2024)
  • NonRes-sAll-mCust-Ltg-di (DEER2024)

Expired:

  • NonRes-sAg-mCust-ci (DEER2019)
  • NonRes-sAll-mCust (DEER2019)
  • NonRes-sAll-mCust-Elec (DEER2019)
2022 May 25 2024 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2023

Water-cooled screw chillers are available.

2022 May 20 2023 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2023

Water-cooled frictionless centrifugal chillers are available.

2022 May 20 2023 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2023

Water-cooled centrifugal chillers are available.

2022 May 20 2023 Jan 1 See history
New NTG_2020 DEER2016

Added previously expired NTG IDs for which no better data exists:

  • Res-sAll-mAppPlug-AirCleaner-up (DEER2016)
  • Res-sAll-mAppPlug-ElecClothesDryer-up (DEER2016)
  • Res-sAll-mAppPlug-Freezer-up (DEER2016)
  • Res-sAll-mAppPlug-GasClothesDryer-up (DEER2016)
2022 May 18 2016 Jan 1 See history
Correction EUL_basis DEER2014

EUL_ID ILtg-HID was unexpired as it was still needed.

2022 May 18 2014 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2023

Residential clothes washer measures are now available.

2022 May 18 2023 Jan 1 See history
New EnergyImpact, Measure, Technology DEER2023

Air-cooled screw chiller measures are available.

2022 May 16 2023 Jan 1 See history
New MeasImpactType DEER2022

The following two MeasImpactTypes were added: Cust-NMEC-Site-FuelSub and Cust-SEM-FuelSub

2022 May 5 2022 Jan 1 See history
New EnergyImpact DEER2023

Res, SFm, MFm, and DMo records for residential dishwashers have been uploaded.

2022 May 3 2023 Jan 1 See history
Corrections NTG_2020 DEER2023

For DEER2023 NTG_IDs NonRes-In-Ltg-LEDFixt and NonRes-sAll-mLtg-TLEDLamp, changed eligible MeasureAppTypes to include: NR, AR, NC.

2022 Apr 1 2023 Jan 1 See history
Corrections NTG_2020 DEER2023

Corrected NTGRs for Nonres-sAll-mLtg-TLEDLamp to 0.65.

2022 Apr 1 2023 Jan 1 See history
New EUL_basis & TechType DEER2022

Added new EUL_ID for new buried duct measure, BS-BuriedDuct, supported by the weighted average of attic insulation, duct sealing, and attic weatherization. Also added new TechType to support associated EUL_ID, BuriedDuct, in the BldgShell TechGroup.

2022 Mar 18 2022 Jun 10 See history
New measures EnergyImpact, Measure, Technology, TechType DEER2023 Using EnergyPlus, a model was built to determine the impacts of replacing either a central gas boiler system or a central gas storage water heater system with a central heat pump water heater system at an 8-unit multi-family building. 2022 Feb 15 2023 Jan 1 See history
New Measure DEER2023

Added newly updated commercial measure categories: package/split ACs, package/split HPs, space-heating furnaces/boilers, duct sealing, and VRF HPs.

2021 Dec 23 2023 Jan 1 See history
New EUL_basis DEER2022

For gas fryers, extended 12-year EUL through 2022-03-20 and delayed start date of 11- year EUL until 2022-03-21.

2022 Jan 7 2022 Mar 21 See history
New NTG_2020 DEER2023

Added:

  • Res-sAll-mSHW-InstWtrHtr
  • Res-sAll-mSHW-StorWtrHtr
  • Res-sMFm-mSHW-DemCtrlRecircPump-di
  • Res-sMFm-mSHW-TempCtrl-di
  • Nonres-sAll-mLtg-TLEDLamp
  • Res-sAll-mHVAC-FanCtrl
  • Res-sAll-mHVAC-CndsrCoilClng
  • Nonres-sAll-mProc-OzoneLaundry

Updated:

  • NonRes-In-Ltg-LEDFixt
2022 Jan 14 2023 Jan 1 See history
New & Corrections NTG_2020 DEER2021-2023

Added:

  • Res-sAll-mHVAC-SCT-di (DEER2022)
  • Res-sAll-mHVAC-SCT-dn (DEER2022)

Expired:

  • Res-sAll-mHVAC-SCT-di (DEER2021)
  • Res-sAll-mHVAC-SCT-dn (DEER2021)

Updated:

  • Res-sAll-mSHW-InstWtrHtr (DEER2023)
  • Nonres-sAll-mProc-OzoneLaundry (DEER2023)
  • Res-sAll-mHVAC-CndsrCoilClng (DEER2023)
2022 Feb 2 2021 Jan 1 See history
New 2020-Res-InLtg DEER2023

Added records for interactive effects for residential lighting measures by utilizing CZ2022 weather data.

2022 Feb 11 2023 Jan 1 See history
New 2020-Com-InLtg DEER2023

Added records for interactive effects for lighting commercial measures that utilize CZ2022 weather data.

2022 Feb 11 2023 Jan 1 See history
New 2020-Com-InLtg & 2020-Res-InLtg DEER2023

Added 33 records per table to provide updated coincident demand factors for exterior lighting. These needed to be updated since the peak period days for each climate zone changed with the update to CZ2022 weather data (per Resolution E-5152).

2022 Feb 25 2023 Jan 1 See history
Correction EnergyImpact DEER2023

Updated missing kW UES values for NE-HVAC-airHP-Split-lt55kBtuh-18p0seer-9p7hspf

2022 Feb 23 2023 Jan 1 See history