SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle ,Payer_ID FROM #Request.prefix_db_agency#.patient WHERE Patient_Id = '#session.cs.patientid#' AND Agency_Id = '#session.AgencyId#' #session.cs.AssessmentId# SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#' select Pathway_Details.Description,Pathway_Details.Skill,Pathway_Details.Pathway_Details_ID from #Request.prefix_db_agency#.Pathway_Details where Pathway_Details.Assessment_ID='#session.cs.AssessmentId#' select Last_Name,First_Name from #Request.prefix_db_lookup#.Employee where Employee_ID = '#AssForm.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' pat = CreateObject("Component", "patientadmin_new.patient.assessment"); 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'); get_score = pat.get_live_score();
#GetP.First_Name# #GetP.Last_Name#, Resumption of Care