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 = '#disform.Record_Created_By#'
SELECT count(#Wnd_Type_str#) 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 *
FROM #Request.prefix_db_agency#.patient
WHERE Patient_Id = '#session.cs.patientid#'
AND Agency_Id = '#session.AgencyId#'
pat = CreateObject("Component", "patientadmin_new.patient.assessment");
get_ques = pat.get_all_ques_ans('9 - Discharge from agency','#DateFormat(disform.Assessment_Completed_M0090,'yyyy-mm-dd')#');
get_pain_que = pat.get_pain_ques('9 - Discharge from agency','pain');
get_braden_que = pat.get_pain_ques('9 - Discharge from agency','braden');
get_fallrisk = pat.get_pain_ques('9 - Discharge from agency','fall_risk');
//get_score = pat.get_live_score();
#DateFormat(disform.Start_of_Care_M0030,'mm/dd/yyyy')# - Discharge From Agency