Operation Details
Description: Method to check for overlapping records.
Sterotype: nsmulti
SQL
SELECT
  educationID,
  courseType,
  statusCode,
  fromDate,
  toDate
INTO
  :educationID,
  :courseType,
  :statusCode,
  :fromDate,
  :toDate 
FROM
  Education 
WHERE educationID <> :educationID 
  AND concernRoleID = :concernRoleID 
  AND statusCode = :statusCode 
  AND courseType = :courseType 
  AND 
  (
    
    (
      :toDate >= fromDate 
      OR :toDate IS NULL 
    ) 
    AND 
    (
      :fromDate <= toDate 
      OR toDate IS NULL 
    ) 
  )