| Operation Details |  |
| Description: | Counts the number of hearings matching this date time and status for the specified caseID, |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :numberOfRecords FROM Hearing WHERE caseID = :caseID AND scheduledDateTime = :scheduledDateTime AND statusCode = :statusCode OR :statusCode IS NULL |