Operation Details
Description: returns list of admin case roles by user ID, type code and end date
Sterotype: nsmulti
SQL 
SELECT
  AdministrationCaseRole.caseID,
  AdministrationCaseRole.userName,
  AdministrationCaseRole.startDate,
  AdministrationCaseRole.endDate,
  AdministrationCaseRole.typeCode,
  AdministrationCaseRole.statusCode,
  AdministrationCaseRole.reasonCode,
  AdministrationCaseRole.comments,
  AdministrationCaseRole.administrationCaseRoleID,
  AdministrationCaseRole.versionNo
INTO
  :caseID,
  :userName,
  :startDate,
  :endDate,
  :typeCode,
  :statusCode,
  :reasonCode,
  :comments,
  :administrationCaseRoleID,
  :versionNo 
FROM
  AdministrationCaseRole 
WHERE AdministrationCaseRole.userName = :currentUserID 
  AND AdministrationCaseRole.typeCode = :typeCode 
  AND 
  (
    AdministrationCaseRole.endDate < :endDate 
    OR AdministrationCaseRole.endDate IS NULL 
  )