Operation Details
Description: Method to return announcements of a particular status that have not yet reached their end date.
Sterotype: nsmulti
SQL 
SELECT
  announcementID,
  announcementText,
  comments,
  endDateTime,
  recordStatus,
  startDateTime,
  title
INTO
  :announcementID,
  :announcementText,
  :comments,
  :endDateTime,
  :recordStatus,
  :startDateTime,
  :title
FROM
  Announcement 
WHERE recordStatus = :recordStatus 
  AND startDateTime <= :dateTime 
  AND endDateTime > :dateTime 
ORDER BY startDateTime DESC