Database SQL Operation: DeterminationAnswer.searchClaimantQuestionAnswersByDDIDAndAliasType
Description: | This method retrieves claimant question answer details for the given determination delivery ID |
Sterotype: | nsmulti |
SELECT
Question.questionID,
QuestionAlias.aliasText,
QuestionnaireVersion.name,
DeterminationAnswer.answer
INTO
:questionID,
:questionText,
:questionnaireName,
:clientAnswer
FROM
QuestionnaireVersion,
QuestionAlias,
Question,
DeterminationAnswer
WHERE DeterminationAnswer.determinationDeliveryID = :determinationDeliveryID
AND DeterminationAnswer.thirdPartyInd = :thirdPartyInd
AND DeterminationAnswer.questionID = Question.questionID
AND Question.questionnaireVersionID = QuestionnaireVersion.questionnaireVersionID
AND QuestionAlias.questionID = Question.questionID
AND QuestionAlias.type = :aliasType
|