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