Operation Details
Description: Returns a slot that exist on a schedule at a particular start and end time. It will also check if the slot times overlaps with any other slots on this schedule.
Sterotype: nsmulti
SQL 
SELECT
  slotID,
  scheduleID,
  name,
  startTime,
  endTime,
  recordStatus,
  comments,
  maxWorkUnits,
  versionNo
INTO
  :slotID,
  :scheduleID,
  :name,
  :startTime,
  :endTime,
  :recordStatus,
  :comments,
  :maxWorkUnits,
  :versionNo 
FROM
  Slot 
WHERE scheduleID = :scheduleID 
  AND recordStatus = :recordStatus 
  AND 
  (
    startTime = :startTime 
    OR endTime = :endTime 
    OR 
    (
      startTime < :endTime 
      AND endTime > :startTime 
    ) 
  )