Consistency between the number of received tenders and SME tenders

Rule Definition

For every lot, the number of received tenders is greater or equal than the number of received SME tenders.

---

Additional Information

Rule elaboration

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

Ontology property involved:

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

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

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:SubmissionStatisticalInformation-hasReceivedTenders-greater-or-equal-than-hasReceivedSMETenders

Implementation note

Implementation in PPDS SHACL shapes graph:

ppsh:SubmissionStatisticalInformation-hasReceivedTenders-greater-or-equal-than-hasReceivedSMETenders a sh:SPARQLConstraint ;
    sh:message "CON003";
    sh:name "Total tenders greater or equal than SME" ;
    sh:description "The number of total tenders received should be greater or equal that tne number of SME tenders received" ;
    sh:severity sh:Warning ;
    sh:prefixes epo: ;
    sh:select """
        SELECT $this (epo:hasReceivedTenders AS ?path) (?receivedTenders AS ?value)
        WHERE {
	        $this epo:summarisesInformationForLotAwardOutcome ?lotAwardOutcome ;
                             epo:hasReceivedTenders ?receivedTenders ;
                             epo:hasReceivedSMETenders ?receivedSMETenders .
            FILTER (?receivedTenders < ?receivedSMETenders)
        }
    """ .

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)