Operation Details
Description: Retrieves a list of evidence types associated with a participant data case by type.
Sterotype: nsmulti
SQL
SELECT
  PDCEvidenceLink.pdcEvidenceLinkID,
  EvidenceMetadata.evidenceType,
  PDCEvidenceLink.shareableInd
INTO
  :pdcEvidenceLinkID,
  :evidenceType,
  :shareableInd 
FROM
  PDCEvidenceLink,
  EvidenceMetadata 
WHERE PDCEvidenceLink.pdcTypeID = :pdcTypeID
  AND EvidenceMetadata.evidenceMetadataID = PDCEvidenceLink.evidenceMetadataID 
  AND EvidenceMetadata.recordStatus = :recordStatus