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.