Operation Details
Description: Counts the number of service delivery evaluations either successful or not successful to arrive at the actual value of a custom performance measure for a contract for all services associated with the contract. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced.
Sterotype: ns
SQL 
SELECT
COUNT(SDEvaluationOutcome.sdEvaluationOutcomeID)

INTO
  :count

FROM  

ContractVersion,
SDEvaluationOutcome

WHERE
 ContractVersion.contractVersionID = :resourceID
 AND SDEvaluationOutcome.serviceDeliveryEvaluationID

IN
(SELECT ServiceDelivery.serviceDeliveryEvaluationID  from    ServiceDelivery,ContractVersion,SDEvaluationOutcome,ContractPOLink,ProviderOffering
 WHERE 
 ServiceDelivery.providerID IN(SELECT  ContractVersion.concernRoleID
 FROM ContractVersion WHERE  ContractVersion.contractVersionID= :resourceID)
  AND ContractVersion.contractVersionID = ContractPOLink.contractVersionID
  AND  ProviderOffering.providerOfferingID = ContractPOLink.providerOfferingID
  AND  ProviderOffering.serviceOfferingID =ServiceDelivery.serviceOfferingID

AND
 (
    ServiceDelivery.coverperiodstartdate BETWEEN ContractVersion.startDate 
    AND ContractVersion.endDate
    OR ServiceDelivery.coverperiodenddate BETWEEN ContractVersion.startDate
    AND ContractVersion.endDate
    OR ContractVersion.startDate BETWEEN ServiceDelivery.coverperiodstartdate
    AND  ServiceDelivery.coverperiodenddate
    OR ContractVersion.endDate  BETWEEN ServiceDelivery.coverperiodstartdate
    AND   ServiceDelivery.coverperiodenddate

)

AND SDEvaluationOutcome.outcome = :serviceDeliveryEvaluationOutcome
AND SDEvaluationOutcome.recordstatus =  :recordStatusOfSDEvaluationOutcome
)