Operation Details
Description: Searches for outcomes not associated with a sub goal and having a specific status.
Sterotype: nsmulti
SQL 
SELECT
  outcomeID,
  name,
  dateCreated
INTO
  :outcomeID,
  :name,
  :dateCreated 
FROM
  Outcome 
WHERE recordStatus = :outcomeRecordStatus 
  AND outcomeID NOT IN 
  ( 
  SELECT
    outcomeID 
  FROM
    SubGoalOutcomeLink 
  WHERE subGoalID = :subGoalID 
  )