Operation Details
Description: Retrieve event details by Case ID, Date and Type .
Sterotype: nsmulti
SQL 
SELECT
  caseEventID,
  caseID,
  relatedID,
  eventTypeCode,
  startDate,
  endDate,
  statusCode,
  recordStatus,
  versionNo
INTO
  :caseEventID,
  :caseID,
  :relatedID,
  :eventTypeCode,
  :startDate,
  :endDate,
  :statusCode,
  :recordStatus,
  :versionNo 
FROM
  CaseEvent 
WHERE startDate >= :fromDate 
  AND caseID = :caseID 
  AND eventTypeCode = :type