SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND (F26 =
OR F26 = )
AND status =
SELECT * FROM #Request.prefix_db_lookup#.Assmt_Update
WHERE
assessment_reason =
assessment_reason =
ORDER BY sort_ID ASC
DELETE FROM #Request.prefix_db_agency#.pOASIS_QA
WHERE Assmt_ID =
AND QA_Type = '#step#'
DELETE FROM #Request.prefix_db_agency#.pOASIS_QA
WHERE Assmt_ID =
AND QA_Type = '#step#'
SELECT #Field_ID# FROM getassess WHERE #Field_ID# = '#Answer#'
SELECT #Field_ID_Update# FROM getassess WHERE #Field_ID_Update# = '#Answer_update#'
SELECT *,tooltip_title AS tooltip_title FROM #Request.prefix_db_lookup#.assessment_answers_lookup
WHERE assessment_reason =
AND deleted =
AND answer =
INSERT INTO #Request.prefix_db_agency#.pOASIS_QA
(
Assmt_ID, Emp_ID, Approved,Resolved, QA_Type, Questions_label, Message,
QA_answerlabel,QA_answer
)
VALUES
(
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.pAssessments
SET #Field_ID_Update# = '#QA_answer#',
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
DELETE FROM #Request.prefix_db_agency#.pOASIS_QA
WHERE Assmt_ID =
AND QA_Type = 'step2'
SELECT * FROM #Request.prefix_db_lookup#.Assmt_Update
WHERE assessment_reason =
ORDER BY sort_ID ASC
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE F26 =
AND Admit_ID =
AND status =
SELECT #Field_ID_Update# AS Fanswer, pAssessments.*
FROM #Request.prefix_db_agency#.pAssessments
WHERE
Admit_ID =
AND F26 =
AND status =
SELECT #Field_ID_Update# AS Fanswer, pAssessments.*
FROM #Request.prefix_db_agency#.pAssessments
WHERE
Admit_ID =
AND F26 =
AND status =
SELECT #Field_ID_Update# AS Fanswer,* FROM getassess
SELECT *,tooltip_title AS Fanswer FROM #Request.prefix_db_lookup#.assessment_answers_lookup
WHERE assessment_reason =
AND deleted =
AND answer =
AND answer_label =
SELECT #Field_ID# AS SOCanswer,* FROM getSOC WHERE Assmt_ID = #SOC_AssmtID#
INSERT INTO #Request.prefix_db_agency#.pOASIS_QA
(
Assmt_ID, Emp_ID, Approved,Resolved, QA_Type, Questions_label, Message,
QA_answerlabel,QA_answer
)
VALUES
(
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.pAssessments SET
#QA_answerlabel# = '#QA_answer#',
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
#arraycolumns[k]# = '#arrayanswers[k]#',
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
#socarraycolumns[m]# = '#socarrayanswers[m]#',
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND Patient_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND Assmt_ID =
AND status =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND Assmt_ID =
AND status =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND Assmt_ID =
AND status =
UPDATE #Request.prefix_db_agency#.pProblem
SET Skill = ,
Date_Change = ,
Change_by =
WHERE ques_id >= 84 AND ques_id <= 120
AND Assmt_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pProblem
SET Skill = ,
Date_Change = ,
Change_by =
WHERE ques_id >= 70 AND ques_id <= 83
AND Assmt_ID =
AND status = 0