Operation Details
Description: Reads the summary details for a hearing review.
Sterotype: ns
SQL 
SELECT
  Hearing.versionNo,
  Hearing.typeCode,
  Hearing.scheduledDateTime,
  Hearing.statusCode,
  Hearing.locationID,
  Hearing.postponeReasonCode,
  Hearing.postponeReasonText,
  Hearing.postponeDate,
  Hearing.comments,
  Hearing.actualStartTime,
  Hearing.actualEndTime,
  Hearing.referenceNumber
INTO
  :versionNo,
  :typeCode,
  :scheduledDateTime,
  :statusCode,
  :locationID,
  :postponeReasonCode,
  :postponeReasonText,
  :postponeDate,
  :comments,
  :actualStartTime,
  :actualEndTime,
  :referenceNumber 
FROM
  Hearing 
WHERE Hearing.hearingID = :hearingID