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

Received tender for awarded contract

Rule Definition

For every awarded lot, there is at least 1 received tender.


Additional Information

Rule elaboration

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

Ontology property involved:

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

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

Rule source

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

Rule implementation

ppsh:Contract-hasReceivedTenders

Implementation note

Implementation in PPDS SHACL shapes graph:

ppsh:Contract-hasReceivedTenders a sh:SPARQLConstraint ;
    sh:message "CON002";
    sh:name "Tender exist for awarded contract" ;
    sh:description "If contract is awarded, amount of received tenders must be greater or equal to 1" ;
    sh:severity sh:Warning ;
    sh:prefixes epo: ;
    sh:select """
        SELECT $this (epo:hasReceivedTenders AS ?path) (?receivedTenders AS ?value)
        WHERE {
	        $this epo:resultsFromLotAwardOutcome ?lotAwardOutcome .
            ?lotAwardOutcome epo:hasAwardStatus
                <http://publications.europa.eu/resource/authority/winner-selection-status/selec-w> .
            ?statisticalInfo epo:summarisesInformationForLotAwardOutcome ?lotAwardOutcome ;
                             epo:hasReceivedTenders ?receivedTenders .
            FILTER (?receivedTenders < 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

#28

#29

#30

#31

#63

#64

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