2016-05-15 ========== * Updated the `good.zip` sample upload file. 2016-05-12 ========== * Removed `references Claim` directive from CustomMeasure and DeemedMeasure specs. This is just a technical adjustment. Uploads are still required to contain matching Claims/Measures for every ClaimID. * Corrected the `RUL_Yrs is less than EUL_Yrs` rule so it doesn't trigger when both values are zero. 2016-04-29 ========== * Removed rule on CombustionType from `validation_rules.csv`. The field is now optional for all PAs. * Updated `claims_metadata.csv` file. * Added `claims_spec_PII.sql` file. 2016-04-19 ========== * Removed PartialPaymentPercent warning. 2016-04-14 ========== * Formatting changes to `claims_spec.sql` 2016-04-10 ========== * UploadPA field deleted from `claim_spec.sql`. This is an automatically generated field, and was erroneously included in the SoT files. 2016-04-03 ========== * CombustionType now validates against the Uploader's PA, not against the ImplementationPA stated in the uploaded record 2016-04-02 ========== * AvoidedCostCombo now validates against the Uploader's PA, not against the ImplementationPA stated in the uploaded record. * good.zip file now matches the current Source of Truth. 2016-03-31 ========== * `DefaultFalse` modifier added to our SQLPlus dialect. See Readme.txt for more details. * Spec updated with new fields and new field names: - PII fields removed from Site table. - Contact table removed completely because of PII - Two new fields added to Claim: `CombustionType` and `TotalGrossMeasureCost_ER` - Some flags now have the `DefaultFalse` modifier applied instead of `NotEmpty` - Validation ranges for EUL/RUL are now uniformly [0, 30] - Some table names changed for clarity: - `DirectImplementation*` fields are now named `DI*` - `EUL`, `RUL` are now named `EUL_Yrs`, `RUL_Yrs`. - `*Flag` names normalized to be named `*_Flag`. - See versioned claims_spec.sql for the full picture. * Validation changes: - Validate `SiteState` to be 'CA' only. - Validate `SiteZipCode` to be valid California zipcode (in interval [90001, 96162] exclusively) * Correct first year savings equation for the case when both `EUL` and `RUL` are less than one. * Readme.txt file edited to reflect new validators. * WARNING: Test data benchmark good.zip NOT updated yet to the new column names/contents. 2016-03-25 ========== * Changes management implemented and deployed * Cosmetic fixes to claims_spec.sql (no new content)