Operation Details
Description: Returns a list of elective CHIP enrollee records from a certain period.
Sterotype: nsmulti
SQL 
SELECT
  evidenceID,
  caseParticipantRoleID,
  startDate,
  endDate,
  comments
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :startDate,
  :endDate,
  :comments 
FROM
  ElectiveCHIPEnrollee 
WHERE ElectiveCHIPEnrollee.startDate <= :startDate 
  AND 
  (
    ElectiveCHIPEnrollee.endDate >= :endDate 
    OR ElectiveCHIPEnrollee.endDate IS NULL 
  )