Operation Details
Description: Searches all the home studies whose date initiated is between the date range for a given status.
Sterotype: nsmulti
SQL 
SELECT 
       assessorName,
       comments,
       dateInitiated,
       finalRecommendation,
       homeStudyID,
       homeStudyType,
       providerConcernRoleID,
       purpose,
       reevaluationDate,
       status,
       supportForRecommendation
INTO
       :assessorName,
       :comments,
       :dateInitiated,
       :finalRecommendation,
       :homeStudyID,
       :homeStudyType,
       :providerConcernRoleID,
       :purpose,
       :reevaluationDate,
       :status,
       :supportForRecommendation	

FROM
	HomeStudy
Where
	dateInitiated >= :startDate
	AND dateInitiated <= :endDate
      AND status = :status