Operation Details
Description: Reads the actual value of a custom performance measure for the provider offering. @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
SDEvaluationOutcome 

WHERE

SDEvaluationOutcome.serviceDeliveryEvaluationID
IN
(SELECT ServiceDeliveryEvaluation.serviceDeliveryEvaluationID  from  ServiceDeliveryEvaluation 
 WHERE 
 ServiceDeliveryEvaluation.providerID =(SELECT ProviderOffering.providerConcernRoleID    FROM  ProviderOffering WHERE  ProviderOffering.ProviderOfferingID  =:resourceID) 
 AND 
 ServiceDeliveryEvaluation.serviceOfferingID = (SELECT  ProviderOffering.serviceOfferingID  FROM ProviderOffering WHERE  ProviderOffering.ProviderOfferingID =:resourceID )
 AND  
ServiceDeliveryEvaluation.recordstatus = :recordStatusOfServiceDeliveryEvaluation) 

AND SDEvaluationOutcome.outcome = :serviceDeliveryEvaluationOutcome

AND  SDEvaluationOutcome.recordstatus = :recordStatusOfSDEvaluationOutcome