Change Log

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

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.