Operation Details
Description: Reads answers specific to one decision matrix of a determination delivery. (If the determination is multi source only consolidated answers are returned)
Sterotype: nsmulti
SQL 
SELECT
  DeterminationAnswer.determinationAnswerID,
  DeterminationAnswer.questionID,
  DeterminationAnswer.answer,
  Question.type,
  Question.codeTableInd
INTO
  :determinationAnswerID,
  :questionID,
  :answer,
  :type,
  :codeTableInd 
FROM
  DeterminationAnswer,
  DMQuestionLink,
  Question 
WHERE DMQuestionLink.decisionMatrixVersionID = :decisionMatrixVersionID 
  AND DeterminationAnswer.questionID = DMQuestionLink.questionID 
  AND DMQuestionLink.questionID = Question.questionID 
  AND DeterminationAnswer.determinationDeliveryID = :determinationDeliveryID 
  AND DeterminationAnswer.consolidationInd = :consolidationInd