Database SQL Operation: PerformanceMeasureLink.countRateOfAchievementForSuccessfulOutcomeForProviderOffering
Description: | Reads the performance measure against rate of achievement of successful outcome 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 |
SELECT
COUNT(ServiceDelivery.serviceDeliveryID)
INTO
:count
FROM
ServiceDelivery
WHERE
ServiceDelivery.providerID =(SELECT ProviderOffering.providerConcernRoleID FROM ProviderOffering WHERE ProviderOffering.ProviderOfferingID = :resourceID)
AND
ServiceDelivery.serviceOfferingID = (SELECT ProviderOffering.serviceOfferingID FROM ProviderOffering WHERE ProviderOffering.ProviderOfferingID = :resourceID )
AND ServiceDelivery.status = :status
AND ServiceDelivery.outcomeAchieved =:outcomeAchieved
|