Operation Details
Description: Finds any Assessment Configuration that are active during a date range.
Sterotype: nsmulti
SQL 
SELECT
  assessmentConfigurationID,
  name,
  assessmentType,
  description,
  startDate,
  endDate
INTO
  :assessmentConfigurationID,
  :name,
  :assessmentType,
  :description,
  :startDate,
  :endDate 
FROM
  AssessmentConfiguration 
WHERE status <> :cancelStatusCode 
  AND 
  (
    endDate > :startDate 
    OR endDate IS NULL 
  ) 
  AND 
  (
    startDate < :endDate 
    OR :endDate IS NULL 
  )