Operation Details
Description: This is for multi source determination. Returns questionnaire name and question text of the answers provided and not selected as part of consolidation
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT QuestionnaireVersion.name,
  Question.questionText,
  Question.questionID
INTO
  :questionnaireName,
  :questionText,
  :questionID 
FROM
  DeterminationAnswer,
  QuestionnaireVersion,
  Question 
WHERE DeterminationAnswer.determinationDeliveryID = :determinationDeliveryID 
  AND Question.questionID = DeterminationAnswer.questionID 
  AND QuestionnaireVersion.questionnaireVersionID = Question.questionnaireVersionID 
  AND DeterminationAnswer.questionID NOT IN 
  ( 
  SELECT
    Question.questionID 
  FROM
    DeterminationAnswer,
    Question 
  WHERE DeterminationAnswer.determinationDeliveryID = :determinationDeliveryID 
    AND Question.questionID = DeterminationAnswer.questionID 
    AND consolidationInd = :consolidationInd 
  )