request.general = CreateObject("component","components.general.general").init(); request.ass = CreateObject("component","components.general.assessments").init(); request.pat = CreateObject("component","components.general.patients").init(); get_ass = request.general.get_answers('assessment_type','assessment_form'); getmess = request.general.get_messages('assessment_form'); AssForm = request.ass.get_assess(#url.ID#,#url.assid#); SELECT DISTINCT pSchedules.Schedule_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.Status = 0 WHERE pSchedules.Status = 0 AND pSchedules.Missed = 0 AND pAssessments.Patient_ID = AND pAssessments.Admit_ID = AND pSchedules.Visit_Date = AND pSchedules.Visit_Type = '4 - Recertification' SELECT DISTINCT q.answer_label, a.answer AS mapped_answer, src.Date_Change, src.Progress_ID FROM ( SELECT DISTINCT pProblem.Answer, pProgress.Description, pProgress.Date_Change, pProgress.Progress_ID FROM #Request.prefix_db_agency#.pProgress JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProblem.Status = 0 WHERE pProgress.Status = 0 AND pProgress.Type = AND pProgress.Severity > AND pProgress.Schedule_ID IN ( ) AND pProblem.Answer IS NOT NULL AND TRIM(pProblem.Answer) != '' ) src JOIN #Request.prefix_db_lookup#.assessment_questions_lookup q ON q.Deleted = 0 AND q.assessment_reason = JOIN #Request.prefix_db_lookup#.assessment_answers_lookup a ON a.question_id = q.ques_id AND a.assessment_reason = q.assessment_reason AND a.Deleted = 0 AND a.answer_type = 'radio' WHERE UPPER(TRIM(a.answer)) = UPPER(TRIM(src.Answer)) ORDER BY src.Date_Change DESC, src.Progress_ID DESC SELECT DISTINCT assessment_questions_lookup.answer_label, assessment_answers_lookup.answer AS mapped_answer, pProgress.Date_Change, pProgress.Progress_ID FROM #Request.prefix_db_agency#.pProgress JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProblem.Status = 0 JOIN #Request.prefix_db_lookup#.assessment_questions_lookup ON assessment_questions_lookup.Deleted = 0 AND assessment_questions_lookup.assessment_reason = JOIN #Request.prefix_db_lookup#.assessment_answers_lookup ON assessment_answers_lookup.question_id = assessment_questions_lookup.ques_id AND assessment_answers_lookup.assessment_reason = assessment_questions_lookup.assessment_reason AND assessment_answers_lookup.Deleted = 0 AND assessment_answers_lookup.answer_type = 'checkbox' WHERE pProgress.Status = 0 AND pProgress.Type = AND pProgress.Severity > AND pProgress.Schedule_ID IN ( ) AND pProgress.Description IS NOT NULL AND TRIM(pProgress.Description) != '' AND assessment_answers_lookup.answer IS NOT NULL AND TRIM(assessment_answers_lookup.answer) != '' AND ( assessment_answers_lookup.answer LIKE CONCAT('%', TRIM(pProgress.Description), '%') OR TRIM(pProgress.Description) LIKE CONCAT('%', assessment_answers_lookup.answer, '%') ) ORDER BY pProgress.Date_Change DESC, pProgress.Progress_ID DESC UPDATE #Request.prefix_db_agency#.pAssessments SET #updateField# = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND Patient_ID = AND Status = AssForm = request.ass.get_assess(#url.ID#,#url.assid#); SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE (M0_No like 'M1021%' OR M0_No like 'M1023%') AND Assmt_ID IN () AND status = 0 ORDER BY dx_order ASC SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Status = AND Patient_ID = AND Admit_ID = ORDER BY F178 DESC INSERT IGNORE INTO #Request.prefix_db_agency#.pg_files ( Agency_Id, Patient_Id, Schedule_ID ,Title, FileName, FileType,Dup_file_name, CreatedBy ) VALUES ( '#session.AgencyId#' ,'#GetP.Patient_Id#' ,'#url.assid#' ,'Wounds_assessments' ,'#filename#' ,'#File.UPLOADALLRESULTS[i].ContentType#/#File.UPLOADALLRESULTS[i].ContentSubType#' ,'#Duplicate_file_name#' ,'#session.EmployeeId#' )

#GetP.Pt_Last#, #GetP.Pt_First# - Add #title#

Back

SELECT MAX(wizard) as count FROM assessment_questions_lookup WHERE assessment_reason = AND Deleted <> 1 get_ques = request.ass.get_all_ques_ans(#form.assessment_type#,#wizrd#);

style="display:block;"style="display:none">

method="post" enctype='multipart/form-data'>

#ind#

SELECT ques_id FROM get_ques group by ques_id

#title#

(#ques_identifier#) #questions#

#text_labels#

#questions#

#Request.Notes_fieldmessage#

(#ques_identifier#) #questions#

checked > #answer#

(#ques_identifier#) #questions#

onclick="unchecknone(this.value,'#answer_label#');" ---> onclick="otherbox1('#answer_label#',this.value,this.checked);" value="#answer#" checked >#answer#

Other

(#ques_identifier#) #questions#

(#ques_identifier#) #questions#

(#ques_identifier#) #questions#

value="#DateFormat(answer_value,'mm/dd/yyyy')#" readonly style="background: white;">

#cookie.WoundCount# wounds entered

Add

Photos to Upload :

#cookie.VitalCount# vital signs entered

Add

Submit Cancel