Operation Details
Description: Read all the answers provided for the questionnaire version and determination delivery
Sterotype: nsmulti
SQL 
SELECT
  Question.questionID,
  Question.questionText,
  DeterminationAnswer.determinationAnswerID,
  DeterminationAnswer.answer,
  DeterminationAnswer.sourceID,
  DeterminationAnswer.thirdPartyInd,
  DeterminationAnswer.consolidationInd,
  QuestionnaireVersion.name,
  QuestionnaireVersion.type,
  QuestionnaireVersion.questionnaireVersionNumber
INTO
  :questionID,
  :questionText,
  :determinationAnswerID,
  :answer,
  :sourceID,
  :thirdPartyInd,
  :consolidationInd,
  :name,
  :type,
  :versionNumber 
FROM
  Question,
  DeterminationAnswer,
  QuestionnaireVersion 
WHERE DeterminationAnswer.determinationDeliveryID = :determinationDeliveryID 
  AND Question.questionnaireVersionID = :questionnaireVersionID 
  AND DeterminationAnswer.questionID = Question.questionID 
  AND QuestionnaireVersion.questionnaireVersionID = :questionnaireVersionID 
ORDER BY iegSequenceOrder