Realistic Awarded Value for each lot

Rule Definition

For each lot, when the Awarded Value is above a given threshold, the Awaraded Value follows a realistic number pattern.

Additional Information

Rule elaboration

Examples of unrealistic number patterns: 111,111,1111; 222,222,222; 333,333,333; 444,444,444; 555,555,555; 666,666,666; 777,777,777; 888,888,888; 999,999,999 or 123,456,789.

Accuracy Business Rule with ID ACC004 as defined in deliverable D06.06 – Data Quality Action Plan.

Ontology property involved:

http://data.europa.eu/a4g/ontology#hasAwardedValue

Rule source

https://code.europa.eu/eproc/ppds/documentation/-/blob/main/documents/d0606_data_quality_action_plan.md#24-accuracy-business-rules

Rule implementation

ppsh:Lot-hasAwardedValue-is-valid

Implementation note

Implementation in PPDS SHACL shapes graph:

ppsh:Lot-hasAwardedValue-is-valid a sh:PropertyShape ;
	sh:description "For procurement procedures with awarded value / total awarded value above a given threshold, the awarded value / total awarded value should not follow an unrealistic number pattern (e.g. 111,111,1111; 222,222,222; 333,333,333; 444,444,444; 555,555,555; 666,666,666; 777,777,777; 888,888,888; 999,999,999 or 123,456,789)" ;
	sh:class epo:MonetaryAmount ;
	sh:severity sh:Warning ;
	sh:message "ACC004" ;
	sh:name "For procurement procedures with awarded value (Lot Award Value) above a given threshold, the Lot Award Value should not follow an unrealistic number pattern (e.g. 111,111,1111; 222,222,222; 333,333,333; 444,444,444; 555,555,555; 666,666,666; 777,777,777; 888,888,888; 999,999,999 or 123,456,789)." ;
    sh:path epo:hasAwardedValue ;
	sh:not [
		sh:pattern "([0-9]+)\\1$" ;
	] .