Operation Details
Description: Method that reads the current case status record for a given case identifier. The most recent status record has `end date` field of null
Sterotype: ns
SQL 
SELECT
  caseID,
  statusCode,
  reasonCode,
  startDate,
  endDate,
  startDateTime,
  endDateTime,
  caseStatusID,
  comments,
  userName,
  versionNo,
  relatedID
INTO
  :caseID,
  :statusCode,
  :reasonCode,
  :startDate,
  :endDate,
  :startDateTime,
  :endDateTime,
  :caseStatusID,
  :comments,
  :userName,
  :versionNo,
  :relatedID 
FROM
  CaseStatus 
WHERE caseID = :caseID 
  AND endDate IS NULL