Skip to content
Snippets Groups Projects

Fix AnswerLineNBR Integer Overflow

Merged Hubbell, Harrison Taylor requested to merge hh_qnr_line_fix into master
1 file
+ 2
2
Compare changes
  • Side-by-side
  • Inline
@@ -33,9 +33,9 @@ select distinct
qq.QuestionTypeDSC,
qqc.QuestionTXT,
qqa.AnswerTXT,
-- NOTE: Only set `AnswerLineNBR` for "Patient-Entered Question" types
-- NOTE: Only set `AnswerLineNBR` for "Custom List" types
case
when qq.QuestionTypeCD = '100' then convert(INTEGER, qqa.FloatAnswerNBR)
when qqc.ResponseTypeCD = 6 then convert(INTEGER, qqa.FloatAnswerNBR)
else null
end as AnswerLineNBR,
-- NOTE: Currently `ScoreNBR` is only supported for "Scoring Question" types
Loading