March 24th, 2016
Specification
Claims
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)