Skip to main content

Add New Field Claim.SavingsDateField to the 2025 Claim Specification Update

1.        As a PA: I want to make sure I have rules in place so that I’m aligned with all PAs in setting the ClaimYearQuarter the same way.

2.        Problem Statement/Goal: Right now, there is no ClaimYearQuarter validation. Since ClaimYearQuarter affects TSB, adding a SavingsDate field would allow for CEDARS validation. Some PAs may currently be using PaidDate or CreditDate to establish ClaimYearQuarter.

3.        Background Details: It’s a good idea to have this date in CEDARS record-level data and to have CEDARS validate all PAs have implemented the deemed logic correctly.

4.        Acceptance Criteria: For deemed measures, this is the date that results from the logic established and agreed to earlier this year by all PAs for the 2024 Q1-Q2 submission. For custom measures, this would be the installation date.

5.        Deadline for this Enhancement: Include new field, ‘SavingsDate’ as part of the “2025 Claim Specification” release.

Select the module in CEDARS
Select user type
Status: Rejected11 comments

Log in to comment and vote

Comments11

  • cedars team changed status to Rejected
    Team•

    May 1, 2025

    Pinned

    It was decided that we would implement an output filed instead of adding a new field and reworking the rules. That new ticket can be found here:

    https://cpuccedars.featurebase.app/p/add-claims-output-savingdate

  • jvrz@pge.com

    •

    Dec 4, 2024

    Hi - I’m concerned about the language here. The “SavingsDate” and the ClaimYearQuarter are not in alignment. ClaimYearQuarter is based on when the measure is paid and claimed, but SavingsDate would be based on when the savings were determined (application date or one of the other rules for deemed, post-install review date for custom (after M&V completes)). These can be even years apart in some programs (like new construction) for Deemed. I think the ClaimYearQuarter piece of this needs to be removed, and this should just focus on what data was used to determine measure package eligibility. I also don’t think Savings date should be a required field for Custom, as it would be duplicative and there wouldn’t be any validation needed on the custom side (as any date is valid).

    • Jennifer Scheuerell

      Team•

      Dec 4, 2024

      Thank you Jake, sorry for the confusion. I struckthrough my comment suggesting the ClaimYearQuarter check. And agreed that custom measures/projects be exempted from being required to provide SavingsDate.

  • sacharya

    •

    Nov 26, 2024

    Thanks, Greg. SoCalGas is in alignment with the points made by SDG&E for adding the new field ‘SavingsDate’ to the 2025 Claim Spec update.

  • Jennifer Scheuerell

    Team•

    Nov 26, 2024

    This sounds good to me, it would help simplify the date-based rules we have currently.

    We may want a second field where the PA can say how they populated the SavingsDate field. If we do, I expect we would want to add an option list for the second field so that all PAs describe it in the same way. Some options might be:

    • ApplicationDate minus 60 days

    • InstallationDate

    • PaidDate

    We could also then potentially add a rule that the SavingsDate be within the ClaimYearQuarter for each measure.

  • ggreen

    •

    Apr 22, 2025

    This enhancement was requested for inclusion in the 2025 Claim Spec update when IOU's are already required to update their backend systems with several new data points/logic.

    SDGE saw this enhancement as more of an opportunity to consolidate the CEDARS validations after an initial check that IOUs have correctly implemented the rules to set the SavingsCalcDate.

    If Jen and Sound Data are fine with running the rules on the CEDARS side and outputting which field was used by CEDARS for the validations, SDGE is also fine with that.

    Thanks,

    Greg.

  • Jennifer Scheuerell

    Team•

    Apr 24, 2025

    Let’s make a final call on this at the PCG meeting. We want to go forward with having CEDARS output the date used for the eTRM/DEER validations.

  • Roopa Reddy

    •

    Dec 7, 2024

    “SavingsDate” seems duplicative if it is a date that we are already submitting in one of the existing DATE fields in the claim spec. However, adding a field to inform the date for the savings claim validation seems reasonable to me.

  • Jennifer Scheuerell

    Team•

    Jan 13, 2025

    This field could be a descriptive field that tells what date field to use, or a field where the date to be used is populated, or both. TBD

  • cedars team

    Team•

    Apr 4, 2025

    During the PCG meeting on April 3rd, it was suggested that instead of adding a field and updating the validations, CEDARS could display in the output which date field validation was used for the savings date.

  • RoopaReddy_PGE

    •

    Apr 4, 2025

    @cedars team @Amy Reardon @jake.richardson@pge.com

    PG&E would support the path that CEDARS Dev Team ultimately recommends implementing.

    • I will emphasize that the addition of the new field and logic requires an update to PG&E’s back-end systems.

    • I believe, regardless of whether SavingsDateField is implemented or not, outcome is the same that CEDARS must still run all the DATE validations in the back end:

      - Option #1: Adding SavingsDateField requires back-end development in CEDARS and in PAs’ systems.

      -Option #2: In absence of SavingsDateField, only CEDARS development is required but the effort is minimal compared to option #1.

      CEDARS would output the DATE used in the deemed savings validation to PA and public record-level outputs in CEDARS dashboard.

      Thank you!