Finalize the list for 2024 Claim Specification updates

Table Changes

RENAME FIELDS

• Measure.CEInputID to Measure.ClaimID

• Measure.PA to Measure.IOU_AC_Territory

REMOVE FIELDS

• Claim.ImplementationID (to be replaced by MeasDetailID)

• Claim.LGP_Flag

• Claim.SchoolIdentifier

• Claim.SEM_ProgramCycle (to be replaced by Claim.SEM_Phase)

• Claim.SEM_ReportingPeriod (to be replaced by Claim.SEM_Phase)

• Claim.SEM_ProgramYear (to be replaced by Claim.SEM_Phase)

ADD FIELDS

• Claim.ShipmentDate (date)

• Claim.SalesDate (date)

• Claim.OriginalMeterInstallYear (required for IOU fuel sub, integer)

• Claim.TotalCustomerInfrastructureCosts (required for IOU fuel sub, numeric)

• Claim.Underserved_Flag (Equity, true/false)

• Claim.CA_Flag (HTR Cultural Accessibility, true/false)

• Claim.LG_Flag (HTR, true/false)

• Claim.IDSM_DR (numeric)

• Claim.IDSM_DER (numeric)

• Claim.SEM_Phase (replaces three existing SEM fields, text, value list)

• PII_Site.SchoolIdentifier (text)

Value List Changes

ADD VALUE LIST

• New CEDARS value list SEM_Phase

  • Value list options:

    • SEM Program Cycle 1, Reporting Period 1, Program Year 1

    • SEM Program Cycle 1, Reporting Period 2, Program Year 2

    • SEM Program Cycle 2, Reporting Period 1, Program Year 3

    • SEM Program Cycle 2, Reporting Period 2, Program Year 4

    • SEM Program Cycle 3, Reporting Period 1, Program Year 5

    • SEM Program Cycle 3, Reporting Period 2, Program Year 6

Validation Changes

REMOVE FUEL SUBSTITUTION RULES

• Measure.UnitkWh1stBaseline is greater than 0 when (Measure.MeasImpactType ends with 'NC-AE' or Measure.MeasImpactType ends with 'FuelSub') and (Measure.UnitTherm1stBaseline is less than or equal to 0).

• Measure.UnitTherm1stBaseline is greater than 0 when (Measure.MeasImpactType ends with 'NC-AE' or Measure.MeasImpactType ends with 'FuelSub') and (Measure.UnitkWh1stBaseline is less than or equal to 0).

Data Processing Updates

• Stop converting fuel savings for fuel substitution measures in claims

Dashboard Updates

• Switch to TSB goals for non-C&S

• Use program segment to identify C&S everywhere