Operation Details
Description: Lists all outcomes that are not associated with the goal specified, having a specific record status.
Sterotype: nsmulti
SQL
SELECT
  outcomeID,
  name,
  dateCreated
INTO
  :outcomeID,
  :name,
  :dateCreated 
FROM
  Outcome 
WHERE recordStatus = :outcomeRecordStatus 
  AND outcomeID NOT IN 
  ( 
  SELECT
    outcomeID 
  FROM
    GoalOutcomeLink 
  WHERE goalID = :goalID 
  )