Operation Details
Description: reads verification details based on the verification linkedID, linkedType and evidence descriptor status
Sterotype: nsmulti
SQL 
SELECT
  Verification.verificationID,
  VerificationRequirement.mandatory,
  Verification.dueDate,
  Verification.verificationStatus,
  VDIEDLink.evidenceDescriptorID,
  VDIEDLink.VDIEDLinkID,
  VDIEDLink.verifiableDataItemID
INTO
  :verificationID,
  :mandatory,
  :dueDate,
  :verificationStatus,
  :evidenceDescriptorID,
  :VDIEDLinkID,
  :verifiableDataItemIDOpt 
FROM
  Verification,
  VDIEDLink,
  EvidenceDescriptor,
  VerificationRequirement 
WHERE Verification.verificationLinkedID = :verificationLinkedID 
  AND Verification.verificationLinkedType = :verificationLinkedType 
  AND Verification.VDIEDLinkID = VDIEDLink.VDIEDLinkID 
  AND VDIEDLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID 
  AND Verification.verificationRequirementID = VerificationRequirement.verificationRequirementID 
  AND 
  (
    EvidenceDescriptor.statusCode = :evidenceDescriptorStatus1 
    OR EvidenceDescriptor.statusCode = :evidenceDescriptorStatus2 
  ) 
ORDER BY Verification.dueDate DESC