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.

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.

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

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.

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”.

  

• 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.

  

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.

Permutations Update: PY2026 Annual CET Update

Affected User: Reporting, program designers, program implementers

Features: Overwrote the values for 10 cost effectiveness output data in the permutation table to ensure they reflect the correct CET avoided cost version (2026), CET version (v25.1), and net present value (2026Q3) for the new program year 2026. This is part of the eTRM annual update process to keep eTRM CET results aligned with the best available data for program planning and payment. 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; 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)

Resolved various AWS security vulnerabilities

Affected users: None

Features: Resolved various AWS container vulnerabilities identified by the monitoring software to maintain security compliance and SLA.

Unsync and remove the "Source Status" CPUC Support Table (Resolution E-5350, §A.5)

Affected users: All users

Features: The "Source Status" table is no longer maintained in the DEER database as the eTRM is the data source of record for active measure packages. The table has never been used in the eTRM. As a result, this table is removed in the eTRM. Per Resolution E-5350, the table will remain in the DEER database for at least 5 years.

Unsync the "Measure" and "Energy Impact" CPUC Support Tables (Resolution E-5350, §E.3)

Affected users: All users

Features: The "Measure" and "Energy Impact" table is no longer maintained in the DEER database. eTRM will be the only repository for deemed permutations and their respective energy impacts. These two tables shall remain in the eTRM until they are removed from the DEER database.

System dependencies updates

Affected users: None

Features: System update to upgrade the underlying software packages that support the application to their latest stable versions. Update keeps the platform safe, secure, stable, and running smoothly.