Operation Details
Description: This method will read the ispCaseDecisionSummaryProc table and return a decision result for a household member based on the tag value, case decision set id, decision date and their concern role id. This method will find a result matching the search criteria to the nearest date up to the decision date specified in the key. This method works on the assumption that a household member will only have one entry in the table with the same case decision set id, tag value and decision date. However, it is possible to have multiple records for example in the case of LIFC where the household member could be on a number of assistance units, for this reason the method should not be used to check eligibility of products where a household member can be on multiple assistance units.
Sterotype: ns
SQL 
SELECT
  decisionResultCode
INTO
  :decisionResultCode 
FROM
  ISPCaseDecisionSummaryProc 
WHERE concernRoleID = :concernRoleID 
  AND tagValue = :tagValue 
  AND caseDecisionSetInstanceID = :caseDecisionSetInstanceID 
  AND decisionDate = ( 
  SELECT
    MAX(decisionDate) 
  FROM
    ISPCaseDecisionSummaryProc 
  WHERE caseDecisionSetInstanceID = :caseDecisionSetInstanceID 
    AND concernRoleID = :concernRoleID 
    AND tagValue = :tagValue 
    AND decisionDate <= :decisionDate 
  )