Operation Details |
Description: | Retrieves all participant data case records linked to evidence by the record status code and shareableInd specified. The details retrieved include PDC type ID and type. |
Sterotype: | nsmulti |
SQL |
SELECT DISTINCT PDCTypeLink.pdcTypeID, PDCTypeLink.typeCode INTO :pdcTypeID, :typeCode FROM PDCTypeLink, PDCEvidenceLink WHERE PDCTypeLink.pdcTypeID = PDCEvidenceLink.pdcTypeID AND PDCEvidenceLink.shareableInd = :shareableInd |