Operation Details
Description: Returns data item, data item name and verifiable data item ID for evidence type and related item type.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT VerifiableDataItem.verifiableDataItemID,
  VerifiableDataItem.dataItem,
  VerifiableDataItem.name
INTO
  :verifiableDataItemID,
  :dataItem,
  :name 
FROM
  VerifiableDataItem,
  VerificationRequirement,
  VerificationRequirementUsage 
WHERE VerifiableDataItem.evidenceType = :evidenceType 
  AND VerificationRequirement.verifiableDataItemID = VerifiableDataItem.verifiableDataItemID 
  AND VerificationRequirement.fromDate <= :currentDate 
  AND 
  (
    VerificationRequirement.toDate IS NULL 
    OR VerificationRequirement.toDate >= :currentDate 
  ) 
  AND VerifiableDataItem.recordStatus <> :recordStatus 
  AND VerificationRequirementUsage.verificationRequirementID = VerificationRequirement.verificationRequirementID 
  AND VerificationRequirementUsage.relatedItemType = :relatedItemType 
  AND VerificationRequirementUsage.recordStatus <> :recordStatus 
  AND VerificationRequirement.recordStatus <> :recordStatus