March 24th, 2016

Specification

Claims

2016 March - Claims Updates

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)