Operation Details
Description: Returns a list of spendDown records from a certain period.
Sterotype: nsmulti
SQL 
SELECT
  spendDownID,
  startDate,
  spenddownStatusCode,
  metInd,
  statusCode,
  retroInd
INTO
  :spendDownID,
  :startDate,
  :spendDownStatusCode,
  :metInd,
  :statusCode,
  :retroInd 
FROM
  ISPSpendDown 
WHERE ISPSpendDown.caseID = :caseID 
  AND ISPSpendDown.startDate >= :startDate 
  AND 
  (
    ISPSpendDown.startDate <= :endDate 
    OR :endDate IS NULL 
  )