Operation Details
Description: Checks to see if an evidence screen record already exists for the specified relatedID, relatedType, pageType and evidenceNodeCode. It ignores canceled records.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  EvidenceScreen 
WHERE relatedID = :relatedID 
  AND relatedType = :relatedType 
  AND effectiveFrom = :effectiveFrom 
  AND pageType = :pageType 
  AND evidenceNodeCode = :evidenceNodeCode 
  AND 
  (
    evidenceScreenID <> :evidenceScreenID 
    OR :evidenceScreenIDIsNull <> '0' 
  ) 
  AND recordStatus <> :recordStatus