Operation Details
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
SQL



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