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 = '#AssForm.Record_Created_By#'
pat = CreateObject("Component", "patientadmin_new.patient.assessment");
get_ques = pat.get_all_ques_ans('6 - Transferred to an inpatient facility - patient not discharged from agency','#DateFormat(AssForm.Assessment_Completed_M0090,'yyyy-mm-dd')#');
#DateFormat(AssForm.Start_of_Care_M0030,'mm/dd/yyyy')# - Transfer Not Discharge