##10813 — F201 / F203 new_wizard for important error-check
SOC new-wizard only error-checks questions with important=1 and new_wizard <> 0.
F201 (M2001) is important=1 but still has new_wizard=0 (legacy wizard 8/9), so blank answers are allowed.
This sets new_wizard = 1 (same History tab as F204/F205) on PATTII for SOC SN/PT/OT.
SELECT assessment_reason, answer_label, important, new_wizard, wizard, display, ques_identifier
FROM #lookupDb#.assessment_questions_lookup_PATTII
WHERE answer_label IN ()
AND assessment_reason IN ()
AND Deleted = 0
ORDER BY assessment_reason, answer_label
Preview (before)
| Reason | Label | ID | important | new_wizard | wizard | display |
|---|
| #HTMLEditFormat(assessment_reason)# |
#answer_label# |
#ques_identifier# |
#important# |
#new_wizard# |
#wizard# |
#HTMLEditFormat(display)# |
UPDATE assessment_questions_lookup_PATTII
SET new_wizard = 1
WHERE answer_label IN ('F201','F202','F203')
AND assessment_reason LIKE '1 - Start of care%'
AND Deleted = 0
AND (new_wizard = 0 OR new_wizard IS NULL);
UPDATE #lookupDb#.assessment_questions_lookup_PATTII
SET new_wizard =
WHERE answer_label IN ()
AND assessment_reason IN ()
AND Deleted = 0
AND (new_wizard = 0 OR new_wizard IS NULL)
Updated #Val(updResult.recordCount)# row(s). Reload SOC Start of Care — blank F201 should now block Next/Submit.
SELECT assessment_reason, answer_label, important, new_wizard, wizard, ques_identifier
FROM #lookupDb#.assessment_questions_lookup_PATTII
WHERE answer_label IN ()
AND assessment_reason IN ()
AND Deleted = 0
ORDER BY assessment_reason, answer_label
After
| Reason | Label | ID | important | new_wizard | wizard |
|---|
| #HTMLEditFormat(assessment_reason)# |
#answer_label# |
#ques_identifier# |
#important# |
#new_wizard# |
#wizard# |
#HTMLEditFormat(cfcatch.message)# — #HTMLEditFormat(cfcatch.detail)#
← Migrations