Operation Details
Description: Returns the active attendees for a hearing. These include all user role types except that of a hearing official.
Sterotype: nsmulti
SQL 
SELECT
  HearingUserRole.hearingUserRoleID
INTO
  :hearingUserRoleID 
FROM
  HearingUserRole,
  CaseUserRole 
WHERE HearingUserRole.caseUserRoleID = CaseUserRole.caseUserRoleID 
  AND HearingUserRole.hearingID = :hearingID 
  AND CaseUserRole.recordStatus = :recordStatus 
  AND NOT CaseUserRole.typeCode = :excludeTypeCode