Operation Details
Description: Returns a list of the details of evidence descriptor records associated with a specified case and evidence status and linked to a change of circumstance.
Sterotype: nsmulti
SQL 
SELECT
  EvidenceDescriptor.evidenceDescriptorID,
  EvidenceDescriptor.relatedID,
  EvidenceDescriptor.evidenceType,
  EvidenceDescriptor.correctionSetID,
  EvidenceDescriptor.successionID
INTO
 :evidenceDescriptorID,
 :evidenceID,
 :evidenceType,
 :correctionSetID,
 :successionID
FROM
  CoCEvidenceLink,
  EvidenceDescriptor
WHERE
  EvidenceDescriptor.caseID = :caseID AND
  CoCEvidenceLink.evidenceDescriptorID =   EvidenceDescriptor.evidenceDescriptorID AND
  EvidenceDescriptor.statusCode = :statusCode