Operation Details
Description: Counts the number of transcripts on the specified case that have been received from transcribers (where the date received has been set).
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  HearingTranscriptionRequest 
WHERE hearingID IN 
  ( 
  SELECT
    hearingID 
  FROM
    Hearing 
  WHERE caseID = :caseID 
    AND statusCode = :statusCode 
  ) 
  AND dateReceivedFromTranscriber IS NOT NULL