SELECT * FROM #Request.prefix_db_agency#.Assessment_New
WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#'
select Last_Name,First_Name from #Request.prefix_db_lookup#.Employee where Employee_ID = '#Recertform.Record_Created_By#'
SELECT count(Wnd_Type) as CouNt from #Request.prefix_db_agency#.PatientVisitDetails
where Patient_ID='#session.cs.patientid#' and Assessment_ID='#session.cs.AssessmentId#'
and Wnd_Location<>'' and Wnd_Type<>'' and trim(Type)='Wound'
Select patient.patient_ID, patient.First_Name_M0040, patient.Last_Name_M0040 from #Request.prefix_db_agency#.patient where patient.Patient_ID=(Select Assessment_New.Patient_ID from #Request.prefix_db_agency#.Assessment_New where Assessment_New.Assessment_ID='#session.cs.AssessmentId#')
pat = CreateObject("Component", "patientadmin_new.patient.assessment");
get_ques = pat.get_all_ques_ans('4 - Recertification (follow-up) reassessment','#DateFormat(Recertform.Assessment_Completed_M0090,'yyyy-mm-dd')#');
get_pain_que = pat.get_pain_ques('1 - Start of care - further visits planned','pain');
get_braden_que = pat.get_pain_ques('1 - Start of care - further visits planned','braden');
get_fallrisk = pat.get_pain_ques('1 - Start of care - further visits planned','fall_risk');
