Operation Details
Description: This method reads all the InternalAssistanceHistory record for a Integrated Case ID
Sterotype: nsmulti
SQL
SELECT
  INTERNALASSISTANCEHISTORY.CASEPARTICIPANTROLEID,
  INTERNALASSISTANCEHISTORY.NUMBEROFMONTHS,
  INTERNALASSISTANCEHISTORY.STARTMONTH,
  INTERNALASSISTANCEHISTORY.STARTYEAR,
  INTERNALASSISTANCEHISTORY.ENDMONTH,
  INTERNALASSISTANCEHISTORY.ENDYEAR
INTO
  :caseParticipantRoleID,
  :numberOfMonths,
  :startMonth,
  :startYear,
  :endMonth,
  :endYear 
FROM
  CASEHEADER,
  INTERNALASSISTANCEHISTORY 
WHERE CASEHEADER.INTEGRATEDCASEID = :caseID 
  AND CASEHEADER.CASEID = INTERNALASSISTANCEHISTORY.CASEID 
  AND INTERNALASSISTANCEHISTORY.PROGRAMTYPE = :programType 
  AND INTERNALASSISTANCEHISTORY.STATUS = 'RST1' 
ORDER BY INTERNALASSISTANCEHISTORY.CASEPARTICIPANTROLEID