November 6th, 2016
Specification
Claims
2016-12.01
==========
* Updated good.zip file for the Q4 quarter
2016-11-16
==========
* Added the cost equations to the Readme.txt file
2016-11-07
==========
* The gross savings calculations were updated to use net values for 'C&S' claims
* Added `StartsWith` rule that enforces prefix use in fields
* Added `MarginsOfWarningAndError (x,y)` rule that enforces limits on the difference between fields for warnings and error:
- A record is accepted if the claimed field is within x of the CEDARS calculation
- A record is accepted and a warning is returned if the claimed record is
between x and y of the corresponding CEDARS calculation
- A record is rejected if the claimed field is more than y different than the CEDARS calculation
* Added `StartsWith PA` rule to claim_spec.sql fields:
- Claim.ClaimID
- Site.SiteID
- ContactClaim.ContactID
* Added `MarginsOfWarningAndError (0.01, 0.1)` rule to claim_spec.sql for all `Total*` fields to enforce that claimed total savings and costs are within 0.1% of CEDARS calculations for a claim to be accepted,and within 0.01% of CEDARS calculations for it to issue no warnings.
* Added `NotEmpty` rule to `claim_spec.sql` for fields:
- UnitEndUserRebate
- UnitIncentiveToOthers
- UnitDirectInstallLab
- UnitDirectInstallMat
* Updated warning that RUL <= EUL / 3 to RUL <= EUL / 2.75
* Removed warning rules:
- NumUnits = 0 when three Unit_1stBaseline fields = 0 and WhySavingsZeroed is not null
- WhySavingsZeroed is not null when three Unit_1stBaseline fields = 0
* Added warning rules:
- WhySavingsZeroed is null when any of the three TotalFirstYearGross_ savings fields =! 0
- WhyCostsZeroed is null when any of the three TotalGross_ cost and incentive fields =! 0
- WhySavingsZeroed is not null when all 0f the three TotalFirstYearGross_ savings fields = 0
- WhyCostsZeroed is not null when all of the three TotalGross_ cost and incentive fields = 0
* Added warning rules:
- RUL > 0 when MeasAppType = 'ER'
- RUL = 0 when MeasAppType = 'ER'
* The Readme.txt was updated to document the `MarginsOfWarningAndError` and `StartsWith` rules,
and to update the gross savings equations for 'C&S' claims.
* Note that, from this change set onwards, the dates given for each change will be
the dates of publication to PA users on staging or production, not the dates on which
the change was implemented in the codebase.