Operation Details
Description: Searches for evidence descriptor records by participant id and evidence type where the case id is empty.
Sterotype: nsmulti
SQL 
SELECT
  evidenceDescriptorID
INTO
  :evidenceDescriptorID 
FROM
  EvidenceDescriptor 
WHERE participantID = :participantID 
  AND evidenceType = :evidenceType
  AND caseID IS NULL 
  AND 
  (
    statusCode = :statusCode1 
    OR statusCode = :statusCode2 
  )