Operation Details
Description: Counts the number of active record(s) with a specified name.
Sterotype: ns
SQL 
SELECT
  COUNT (*)
INTO
  :count 
FROM
  VerificationItem 
WHERE name = :name 
  AND recordStatus <> :recordStatus