Operation Details
Description: Given a screening configuration ID and date range, determines how many screening have a start or end date that falls outside the start or end date provided, independent of case status.
Sterotype: ns
SQL
SELECT
  COUNT(*)
INTO
  :count 
FROM
  Screening,
  CaseHeader 
WHERE Screening.screeningConfigID = :screeningConfigID 
  AND Screening.caseID = CaseHeader.caseID 
  AND 
  (
    
    (
      CaseHeader.startDate < :startDate 
    ) 
    OR 
    (
      CaseHeader.endDate > :endDate 
    ) 
  )