Operation Details
Description: Reads the actual value of a custom performance measure for the provider. @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 = :resourceID 
 AND  ServiceDeliveryEvaluation.recordstatus = :recordStatusOfServiceDeliveryEvaluation) 

AND SDEvaluationOutcome.outcome = :serviceDeliveryEvaluationOutcome

AND  SDEvaluationOutcome.recordstatus = :recordStatusOfSDEvaluationOutcome
AND SDEvaluationOutcome.SOPerformanceMeasureLinkID IN 
(
SELECT SOPerformanceMeasureLink.SOPerformanceMeasureLinkID 
FROM SOPerformanceMeasureLink
WHERE performanceMeasureID = :performanceMeasureIDOpt
)