Removed table fields

DeemedMeasure.VersionSource     

DeemedMeasure.PreTechGroup     

DeemedMeasure.PreTechType     

DeemedMeasure.StdTechGroup  

DeemedMeasure.StdTechType     

DeemedMeasure.InstallationRateCost     

DeemedMeasure.RealizationRateCost     

Claim.ClaimDate    

Updated table fields

Moved MeasImpactType to Claim from DeemedMeasure

Added table fields

DeemedMeasure.MeasInflation

CustomMeasure.MeasInflation

CustomMeasure.PreDesc

CustomMeasure.StdDesc

CustomMeasure.TechGroup

CustomMeasure.UseCategory

Claim.FinancingPrgID

Claim.WaterOnly_Flag

Claim.MarketEffectsBenefits

Claim.MarketEffectsCosts

Claim.RateScheduleElec

Claim.RateScheduleGas

Claim.Comments

Added table

WaterMeasure

Removed value list

VersionSource (DEER)

Added value lists

• RateScheduleGas (CET)

• RateScheduleElec (CET)

• SourceDesc (DEER)

Removed validation rules

Removed validation rules associated with fields that were removed

• PreTechGroup

• PreTechType

• StdTechGroup

• StdTechType

Updated validation rules

Update SiteID is not null rule to remove exception for upstream claims

Added validation rules

• To ensure water only claims do not have kW, kWh, or Therm savings in the claim.

• To ensure claims do not have both InstallationRate and RealizationRate values that are not 1.

Rule added to cross-table validation in ReadMe

Require at least one ContactClaim record for all non-C&S claims

DEER value list sync update: DEER values remain valid in CEDARS for one year past expiration.

Ensure only one ProgramCost record may be submitted per PrgID.

Ensure the ClaimYearQuarter cannot be after the submission ClaimYearQuarter, and that it belongs to the current submission year.

Ensure all Programs in ProgramCost table have at least one Claim record before allowing quarterly confirmation.

Ensure all Programs in Claim table have at least one ProgramCost record before allowing quarterly confirmation.

Non-ASCII characters will be stripped from submissions as part of the Tier 1 rules listed in the Readme.