Database SQL Operation: ContractPerformanceMeasure.countIncidentsReqInvestigationCountForProvider
Description: | Reads the performance measure against incidents requiring investigation 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(Incident.incidentID)
INTO
:count
FROM
Incident,
IncidentParticipantRole,
ContractVersion
WHERE ContractVersion.contractVersionID = :resourceID
AND IncidentParticipantRole.concernRoleID = ContractVersion.concernRoleID
AND IncidentParticipantRole.incidentID = Incident.incidentID
AND Incident.status IN ( :incidentStatus)
AND Incident.closureReason = :closureReason
AND IncidentParticipantRole.recordStatus = :recordStatus
AND Incident.recordedDate BETWEEN ContractVersion.startDate AND ContractVersion.endDate
|