2018-10-23

Value list updated

Updated Claim.Sector value list to use business plan sector values.

Update claim_spec.sql

Made Claim.DeliveryType required for all claims.

Added three new validation rules

• Claim table NTG_ID field is required for all claims except C&S.

• Made DeemedMeasure and CustomMeasure tables StdDesc field required for all claims that have savings.

• Made DeemedMeasure and CustomMeasure tables PreDesc field required for all claims that have RUL greater than zero. *

Update two warning rules

Update warnings to use the new DEER MeasAppType 'AR' instead of 'ER' when checking the consistency between RUL and MeasAppType.

Changed claim_good.zip file name to claim_good_YYYY.zip

2018-10-23

Added claim PII QC to the ReadMe.txt

2018-07-06

Changed good.zip file name to claim_good.zip

Changed combined source of truth zipfile name to Claim_SourceOfTruth.zip

2018-04-20

Updated table fields

• DeemedMeasure.MeasCostID max size increased from 50 to 100 characters

• ProgramCost.PA now validates against the uploader's PA