Operation Details
Description: Gets the most recent record based on the lockTS field for a case, excluding backed-off locks. Should typically find one record but high contention could generate multiple records hence this is a read multi.
Sterotype: nsmulti
SQL 
SELECT lockTS, completionTS, statusCode
INTO :lockTS, :completionTS, :statusCode
FROM reassessmentQueueControl
WHERE (caseID = :caseID)
  AND (completionTS IS NULL OR lockTS = (SELECT MAX(lockTS) FROM reassessmentQueueControl
     WHERE caseID = :caseID
     AND statusCode <>  'RCS4')) ORDER BY lockTS DESC;