August 14th, 2026
Resolved an eTRM Public Database Sync Issue
Users: Users and systems that are accessing published eTRM data via the public Postgres database
Incident: Resolved a sync failure error with the eTRM public Postgres database and resynced the database to the latest data. Note: The issue affected only the published tables; measure data required by CEDARS load shape process was not affected.
On August 12, the eTRM monitoring system detected that the public database (published tables only) had not successfully synced since the last manual sync on July 28. The error was a result of a job conflict caused by the restricted sync, which happens every 5 min to send eTRM latest measure data to CEDARS load shape tool, overlapping with the nightly public sync, which syncs published measure data for reporting purposes. This job conflict automatically stopped the public sync. eTRM software team resolved the sync error by preventing the overlapping sync jobs and performed a manual sync on August 14 to update the public database.
Cal TF Staff and the eTRM development team have initiated a prior-incident review and root cause analysis to identify potential recurrence, contributing factors, and recommended improvements for permanent remediation.
Business impact: Published measure data updates made in August were not reflected in the public database and were unavailable to downstream systems. Four newly published future measure versions were missing. Their previous PY2026 published versions also lacked the updated EndDate, which was added following the approval of the newest versions. The affected measures were:
Missing published measures
SWAP014-05 Heat Pump Clothes Dryer, Residential, Fuel Substitution (StartDate = 1/1/2028)
SWAP011-06 Vending and Beverage Merchandise Controller (StartDate = 1/1/2028)
SWWH027-08 Heat Pump Water Heater, Commercial, Fuel Substitution (StartDate = 11/3/2206)
SWWH028-09 Large Heat Pump Water Heater, Commercial and Multifamily, Fuel Substitution (StartDate = 11/2/2026)
Measure version IDs with missing EndDate
SWAP014-04 Heat Pump Clothes Dryer, Residential, Fuel Substitution (EndDate = 12/31/2027)
SWAP011-05 Vending and Beverage Merchandise Controller (EndDate = 12/31/2027)
SWWH027-07 Heat Pump Water Heater, Commercial, Fuel Substitution (EndDate = 11/02/2026)
SWWH028-08 Large Heat Pump Water Heater, Commercial and Multifamily, Fuel Substitution (EndDate = 11/01/2026)
User action required: Users may need to refresh their database connection to receive the latest data.
Improved Data Sync Reliability
Users: Internal only
Features: We’ve improved monitoring and notifications for all eTRM data synchronization tasks to help ensure that sync jobs complete successfully and any issues are identified quickly.
Robust data monitoring: A new CloudWatch dashboard provides ongoing visibility into sync health. Every sync job now reports its health status and clearly identifies failed or incomplete syncs.
Data verification: A new automated daily check compares the public Postgres database against the main eTRM database and flags any discrepancies.
Faster notifications: Sync failures and data discrepancies now proactively trigger email notifications to the eTRM Development Team and designated Cal TF staff contacts, so issues can be addressed immediately.
Enhanced Multiple-Choice Filters
Users: All users
Features: Improved the multiple-choice filter widget to make it easier and faster to find the values you need.
Searchable filter options: Users can now type a word or phrase to quickly narrow down the available choices instead of scrolling through a long list.
Access to all values: Previously, the multiple-choice widget silently limited the list to the first 1,000 values, which could make some options unavailable. Users can now search across the full set of available values. If more than 1,000 results are returned, eTRM clearly indicates that the list has been limited.
Improved performance: Optimized search and retrieval algorithm, making the experience faster and more reliable.
Note: This enhancement is currently available only for CPUC Support Tables. We plan to expand the improved filtering experience to other eTRM tables in future releases.
August 5th, 2026
New
Advanced Filter UI for Permutations Table
Users: All users
Features: Permutation table now supports the same advanced filtering capabilities available for CPUC Support Table, Shared Value Table, and Measure Value Table. New filtering capabilities include:
Multiple-choice, keyword (up to 5 keywords), numerical range, single choice, and date range filtering widgets. Widget depends on the column's data type and the system configuration.
Support filtering across all table columns
Apply filters from either the main table view or the Fullscreen View (formerly Advanced Fullscreen View)
Export filtered results
Share/persist a filtered view by saving the page URL.
Training Resources: Find Measure Permutations
Advanced Customization for Custom Permutation Report
Users: All users
Features: Users can now use the advanced filter UI to create, customize, and save custom permutation reports
Apply filter when creating custom permutation report (in addition to being able to select the permutation columns)
Saving custom report for a particular measure or across all measures in eTRM
Training Resources: Create a Customized Permutation Report
Advanced Filtering UI for Measure Development Report
Users: All users
Features: Measure Development Report now supports the same advanced filtering capabilities available for CPUC Support Table, Shared Value Table, and Measure Value Table. Users can create and save customized report views to track the measure development activities most relevant to them. Additional enhancements to report customization and tracking capabilities will be introduced in a future release.
July 21st, 2026
Data Update
Permutations Update: PY2026 CET Correction
Affected User: Reporting, program designers, program implementers
Features: Overwrote the existing published PY2026 permutations in response to the CET's Electric Avoided Cost correction deployed on June 26, 2026. The 2026 CET correction resolved a day-shifting error in the electric avoided cost calculation, which updated the electric benefits and all dependent fields. To ensure consistency with the corrected CET, eTRM has rerun the 2026 CET and the related Restricted Permutation Flag calculation.
Please reach out to Cal TF staff if you would like to review the analysis of the data changes.
Notes:
This update only affects measures that are active in 2026 (i.e., End Date is blank or End Date ≥ 1/1/2026).
This update only overwrites the 10 cost-effectiveness fields and the Restricted Permutations Flag Field; No other permutation fields are modified.
Electric Benefits (ElecBen)
Gas Benefits (GasBen)
TRC Cost - No Administrative Cost (TRCCostNoAdmin)
PAC Cost - No Administrative Cost (PACCostNoAdmin)
TRC Ratio - No Administrative Cost (TRCRatioNoAdmin)
PAC Ratio - No Administrative Cost (PACRatioNoAdmin)
Total System Benefit (TotalSystemBenefit)
Water Energy Benefits (WaterEnergyBen)
Other Benefits (OtherBen)
Other Costs (OtherCost)Restricted Permutation (RestrictedPerm)
July 2nd, 2026
Advanced Filter UI for CPUC Support Tables and Shared Value Tables
Users: All users
Features: Added advanced filtering capabilities to the CPUC Support Tables and Shared Value Tables. New filtering capabilities include:
Multiple-choice, keyword (up to 5 keywords), numerical range, and date range filtering widgets. Widget depends on the column's data type and the system configuration.
Support filtering across all table columns, replacing the previous functionality that limited filtering to selected columns in CPUC Support Tables and parameter columns in Shared Value Tables.
Apply filters from either the main table view or the Fullscreen View (formerly Advanced Fullscreen View)
Export filtered results
Share/persist a filtered view by saving the page URL.
Training Resources:
Advanced Filter UI for Measure Value Tables
Users: All users
Features: Added advanced filtering capabilities to the Measure Value Tables. Measure Value Table now supports the same advanced filtering capabilities available in CPUC Support Tables and/or Shared Value Tables.
For all users: The filtering widget available for each column is determined by the column's data type and, for the text data type, the configuration defined by the measure developer or system administrator.
For measure developers: When creating or updating a value table in a measure package, the “Edit Column” panel now includes a new option for configuring the filtering widget used for text-type columns, allowing you to control how users filter the data.
Training Resources:
Create a Value Table (for measure developer)
May 14th, 2026
New
Improved
Unsynced and Removed “Load Shapes, Electric” and “Load Shapes, Gas” CPUC Support Tables
Users: All users
Features: Unsynced and removed the two Generalized Load Shape Parameter (GLSP) CPUC Support Tables—Load Shapes, Electric and Load Shapes, Gas—from eTRM. These tables are no longer in scope for deemed load shape process and will be retired in DEER.
Improve Error Handling of Invalid Text-Concatenation Calculation
Users: Measure contributors
Features: Invalid calculations (such as malformed equations or missing/invalid variable inputs) now display clear error messages, helping measure developers and reviewers identify issues more efficiently.
May 7th, 2026
Fixed
Fixed Cover Sheet Download Email Delivery Issue
Affected users: All users
Features: Resolved an issue where the cover sheet downloads were not delivered to the users’ emails for measure versions that have offering IDs removed. Users should now be able to receive all requested cover sheet download files.
May 7th, 2026
New
Fixed
Text Concatenation Calculation
This enhancement supports the Deemed Load Shape Library Project.
Affected users: Measure developers
Features: There is a new text-concatenation calculation capability, which will enable measure developers to dynamically construct the TechID-based Electric Impact Profile IDs from permutation data (e.g., Tech IDs, Building Type, Building Vintage, Building HVAC) for modeled PY2028 measures.
This enhancement supports the Deemed Load Shape Library Project by allowing the measure developer to generate the correct Electric Impact Profile ID (i.e., E3MeaElecEndUseShape), whether it's the DEER legacy ID or TechID-based ID, for their measure permutations. The E3MeaElecEndUseShape field is then used to identify the appropriate avoided cost combo when running the CET.
Updated CET Measure.csv specification: Rename “PA” to “IOU_AC_Territory”
Affected users: All
Features: The PA field in the CET Input “Measure.csv” file has been renamed to IOU_AC_Territory to align with the CEDARS CET specification. Users will see the updated field name in the “Measure.csv” file of the CET Input File download package. This update only changes the field name; the underlying data and values remain unchanged.
Fixed Lifecycle Status Not Updating in CPUC Support Tables
Affected users: All users
Features: Resolved an issue in which the Lifecycle Status field in the CPUC Support Tables was not updating correctly with the Start Date and Expire Date values. The status will now automatically transition to:
Expire — current date > Expire Date
Active — current date ≥ Start Date and current date ≤ Expire Date
Future — current date < Start Date
March 26th, 2026
New
Expose unrounded data in the restricted “latest_permutations tables
This enhancement supports the Deemed Load Shape Project
Affected users: Admins
Feature: The “latest_permutations” table of the pubic read-only Postgres database now includes unrounded measure data to provide CEDARS with higher-precision UEC data for the Deemed Load Shape Tool and avoided cost calculations and to support more accurate UES v. UEC QC. This update applies only to the restricted “latest_permutations” table; the public “permutations” table continues to follow standard rounding rules.
February 15th, 2026
New
Improved
Fixed
Restricted Postgres Database Schema for latest measure data
This enhancement supports the Deemed Load Shape Library Project.
Affected users: Admins
Features: eTRM now syncs the latest measure version of each release cycle—including unpublished drafts—to the read-only Postgres database, allowing CEDARS to query permutation data for the Deemed Load Shape Tool. Data is stored in a separate “restricted” schema with restricted access credentials.
Remove the <ENVIRONMENT> string from the name of the public database tables
This enhancement supports the Deemed Load Shape Library Project.
Affected users: Admins
Features: Table names in the public read-only Postgres database are now identical across all environments (local, testing, staging, and production) to minimize friction when connecting to different eTRM environments.
For example: STAGE-latest_measures → latest_measures.
Update sync scripts for the Interactive Effects Tables
Affected users: All users
Features:
CPUC Support Tables: Updated the sync scripts for the “Interactive Effects, Residential” and “Interactive Effects, Commercial” CPUC Support Tables to pull in the “Start Date” and “Expire Date”.
Interactive Effects CPUC Support Tables Shared Value Tables: Update the sync scripts for the “Interactive Effects, Residential” and “Interactive Effects, Commercial” Shared Value Tables to select valid records by Start Date and Expire Date.
Interactive Effects Shared Value Tables - Columns and Rows Selection
January 16th, 2026
New
Improved
Allow the upload of reference file up to 10 GB
Affected Users: Measure developers and measure reviewers
Features: The application is optimized to support the upload and storage of reference files up to 10 GB in size without timeouts or application failures. This ensures users—particularly measure developers and measure reviewers—can reliably access large supporting data files, such as EnergyPlus modeling files, directly from the measure package.
Improved Handling for Large Download Payloads
Affected Users: Measure developers, measure reviewers, base users
Features: The file storage and download processes are optimized to support long-running transfers, ensuring users can successfully download large reference files without encountering timeouts or application failures.
Separating measure package download into 2 options
Affecting Users: Measure developers, measure reviewers, base users
Features: The reference folder, which was previously included in the measure package download, has been separated into a standalone download. Users who only need the measure data—for example, to run QC tools—can now download the core measure package without being subjected to long download times or storage space requirements caused by large reference files. This decoupling provides faster, more efficient downloads while still giving users access to the materials they need.
