Database SQL Operation: PerformanceMeasureLink.readPlacementClientsServedCountForProvider
Description: | Reads the performance measure against the clients served for placements 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 |
SELECT
COUNT(DISTINCT(Placement.caseParticipantRoleID))
INTO
:count
FROM
Placement,
ProviderOffering,
ServiceOffering
WHERE ProviderOffering.providerConcernRoleID = :resourceID
AND Placement.providerOfferingID = ProviderOffering.providerOfferingID
AND Placement.recordStatus = :recordStatus
AND ProviderOffering.serviceOfferingID = ServiceOffering.serviceOfferingID
AND ServiceOffering.placementPmtInd = :placementPmtInd
|