Operation Details
Description: Counts how many Active Assessment configuration links exist outside the specified dates for an Assessment Configuration.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :count 
FROM
  ScreeningAssessmentConfig 
WHERE assessmentConfigurationID = :assessmentConfigurationID 
  AND recordStatus = :status 
  AND 
  (
    startDate < :startDate 
    OR endDate > :endDate 
  )