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 and the associated READI software are 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 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Updated | TechType | All |
The following fields were removed from the TechType table: NumTechs, NumMeas, NumImp, NumCost, NumDEERMeas, and NumDEERCost. These fields existed for the benefit of the READI tool that the CPUC stopped supporting 2021-01-01. The eTRM has never imported or leveraged these fields and the Deemed Ex Ante team has not updated their contents since no longer supporting READI. |
2023 Sep 26 | 2023 Sep 22 | See history | ||||||||
New | TechType | All |
Four new fields added to TechType table:
Three new Clothes Dryer TechTypes were added. |
2023 Sep 11 | 2023 Sep 5 | See history | ||||||||
New | MajorVersion, VersionSource | DEER2025, DEER2026 |
New MajorVersion and VersionSource records have been added for PY2025 and PY2026 (DEER and ExAnte). |
2023 Sep 6 | 2025 Jan 1 | See history | ||||||||
New | BldgWts | DEER2019 |
Uploaded BldgHVAC weights used to produce cWtd BldgHVAC records for commercial measures delivered via upstream or midstream delivery types. |
2023 Aug 16 | 2019 Jan 1 | See history | ||||||||
Updated | Measure | DEER2020 |
Expiration date for DEER2020 ceiling insulation measures was corrected so that they expire on 2023-12-31 rather than 2022-12-31. |
2023 Aug 16 | 2024 Jan 1 | See history | ||||||||
New | BldgHVAC | DEER2024 |
For PY2024, rEVAP BldgHVAC was renamed to rEVGF to allow for evaporative cooling with more heating options as indicated by 2019 RASS. Also added the following new types: rDXEH, rEVEF, rEVEH, rEVOH, and rNCEF. |
2023 Jul 17 | 2024 Jan 1 | See history | ||||||||
New | applic.BldgWts | DEER2024 |
Uploaded BldgHVAC weights used to produce rWtd BldgHVAC records for residential measures delivered via upstream or midstream delivery types. |
2023 Jul 17 | 2024 Jan 1 | See history | ||||||||
New | Measure, Technology, and EnergyImpact | DEER2023, D23v1 |
Uploaded new MeasureIDs, Technology Names, and EnergyImpactIDs for commercial packaged AC/HP systems that now require economizers per 2022 Title 24 for SEER 16-18/16-17. (SEER15 records will follow in the coming weeks to correct anomalous W/cfm ratio.) |
2023 Jul 3 | 2023 Oct 1 | See history | ||||||||
Corrections | EUL_hou | N/A |
Corrected all EUL_hou records to have ClaimSpec=True and FilingSpec=True. |
2023 May 5 | 2023 May 5 | See history | ||||||||
New | EUL_basis, TechType | DEER2023 |
New EUL_ID added for Residential "Fan Controller for HVAC" measures. |
2023 May 3 | 2023 May 2 | See history | ||||||||
New | EUL_basis, TechType, TechGroup, UseSubCategory | DEER2023 |
New EUL_ID (Com-GasPatioHeater), TechGroup (PatioHeat), TechType (GasPatioHeat), and UseSubCategory (PatioHeat) created for Gas Patio Heater measures. |
2023 May 2 | 2023 May 1 | See history | ||||||||
New | NTG_2020 | DEER2023 |
All-electric new construction NTG_ID, Res-NC-AllElectric, added to NTG_2020 table. |
2023 May 1 | 2023 Apr 10 | See history | ||||||||
Corrections | Technology | DEER2023 |
Incorrect TypeID corrected for 9 technology records with Tech Type Boiler_Ec. |
2023 May 1 | 2023 Jan 20 | See history | ||||||||
Corrections | Measure | DEER2023+ |
Two new fields, WeatherSim and FuelSubID were added to the Measure table to track which TMY weather data were used to model measures, and to indivate whether a given measure is a fuel-substitution. |
2023 May 1 | 2022 Jul 22 | See history | ||||||||
Corrections | EnergyImpact | DEER2023 |
The recently added WeatherSim and FuelSubID fields were removed in from the EnergyImpact table since they are present in the Measure table. |
2023 May 1 | 2023 Jan 27 | See history | ||||||||
New | source_status | DEER2023 |
New source_status record for Commercial Cooktop added to DEER. |
2023 Apr 21 | 2023 Apr 18 | See history | ||||||||
Corrections | EnergyImpact, Measure | DEER2020 |
Several DEER2020 water heater EnergyImpactIDs in both the Measure and EnergyImpactID table were fixed, changing IDs with "-ite" to "-lte" for less than or equal to. |
2023 Apr 21 | See history | |||||||||
Corrections | EUL_basis | DEER2023 |
EUL values corrected for WEN cold-water devices. |
2023 Apr 21 | 2023 Jan 1 | See history | ||||||||
New | EnergyImpact, Measure, Technology | DEER2023 |
Residential clothes washer measures were uploaded in May 2022, this announcement is to upload the QC workbook associated with these measures. |
2023 Apr 21 | 2023 Jan 1 | See history | ||||||||
New | NTG_2020 | DEER2023 |
New NTG ID for water-energy projects has been added per D.15-09-023. |
2023 Apr 19 | 2023 Apr 10 | See history | ||||||||
New | EUL_basis, UseCategory, UseSubCategory, TechType | DEER2023 |
New values were added to DEER support tables for Water-Energy-Nexus (WEN) cold-water conservation measures. Nine EUL_IDs were added: Wtr-WaterFixt-Toilet-Res, Wtr-WaterFixt-Toilet-Com, Wtr-WaterFixt-Urinal, Wtr-Irrig-Nozzle-LrgRot, Wtr-Irrig-Nozzle-MultiStrm, Wtr-Irrig-TurfRemoval, Wtr-Irrig-Ctrl-Weather-Res, Wtr-Irrig-Ctrl-Weather-Com, and Wtr-Irrig-Ctrl-SoilMoist. One UseCategory and one UseSubCategory were added: SCW and PointOfUse, respectively. To the Irrigation TechGroup, three TechType records were added: IrrigCtrl, Nozzle, and Xeriscape. To the WaterFixt TechGroup, one TechType was added: Sanitary. |
2023 Mar 13 | 2023 Jan 1 | See history | ||||||||
New | BldgHVAC | DEER2023 |
Three new residential building HVAC types were added to DEER:
|
2023 Feb 28 | 2023 Jan 1 | See history | ||||||||
New | MeasImpactType | DEER2023 |
Two measure impact types were added:
|
2023 Jan 26 | 2023 Jan 1 | 2025 Dec 31 | See history | |||||||
Clarifications | NTG_2020 | DEER2023 |
Based on a review of Quantum's evaluation report cited by Resolution E-5152 DEER2023, the description for "NTG_ID"='NonRes-In-Ltg-LEDFixt' and "Version"='DEER2023' has been updated from "Nonresidential indoor LED linear fixture" to "Nonresidential indoor LED fixture (including High/Low-Bay)". |
2022 Dec 21 | 2023 Jan 1 | See history | ||||||||
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 |
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:
|
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:
|
2022 Jul 22 | 2024 Jan 1 | See history | ||||||||
New | MeasImpactType | DEER2022 |
Added MeasImpactType:
|
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:
|
2022 Jun 22 | 2022 Jan 1 | See history | ||||||||
New | EnergyImpact, Measure, Technology | DEER2023 |
Added high-efficiency central DHW instantaneous boiler systems for MFm buildings:
|
2022 Jun 17 | 2023 Jan 1 | See history | ||||||||
New | EnergyImpact, Measure, Technology | DEER2023 |
Adding missing standard measures of split/package ACs:
(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:
Expired the following NTG ID:
|
2022 May 25 | 2024 Jan 1 | See history | ||||||||
New and Updated | NTG_2020 | DEER2024+ |
Added:
Expired:
|
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 conventional 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:
|
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:
Updated:
|
2022 Jan 14 | 2023 Jan 1 | See history | ||||||||
New & Corrections | NTG_2020 | DEER2021-2023 |
Added:
Expired:
Updated:
|
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 |