Code development platform for open source projects from the European Union institutions 🔵 EU Login authentication by SMS has been phased out. To see alternatives please check here

Skip to content

Realistic awarded value / total awarded value

Rule Definition

For procurement procedures with Awarded Value/Total Awarded Value above a given threshold, the estimated 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

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

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$" ;
	] .

https://sdlc.webcloud.ec.europa.eu/ppds/docker/ppds-shacl-shapes/-/blob/featured/revision_0.3.3/ppds-shapes.ttl?ref_type=heads

Related rules

#26

#27

#56

#57

#84

#86

Related generic rule

(If the rule is a specialisation of a generic rule registered in this Rulebook, include here URL of that generic rule)

History note

(If applicable, add here a note about a previous state of the rule, before the Rulebook)

Edited by Enrique Jose Barcala Soto