Operation Details
Description: Returns the users participation status for the latest completed hearing for a case- this includes all user role types except that of a hearing official and interpreter.
Sterotype: nsmulti
SQL 
SELECT
  HearingUserRole.participatedCode
INTO
  :participatedCode 
FROM
  Hearing H,
  HearingUserRole,
  CaseUserRole 
WHERE HearingUserRole.caseUserRoleID = CaseUserRole.caseUserRoleID 
  AND CaseUserRole.caseID = :caseID 
  AND HearingUserRole.hearingID = H.hearingID 
  AND CaseUserRole.typeCode <> :excludeTypeCode1 
  AND CaseUserRole.typeCode <> :excludeTypeCode2 
  AND CaseUserRole.recordStatus = :recordStatus 
  AND H.hearingID = 
  ( 
  SELECT
    hearingID 
  FROM
    Hearing 
  WHERE caseID = :caseID 
    AND statusCode = :statusCode 
    AND scheduledDateTime = 
    ( 
    SELECT
      MAX(scheduledDateTime) 
    FROM
      Hearing 
    WHERE caseID = :caseID 
      AND statusCode = :statusCode 
    ) 
  )