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#' 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 Diagnosis_ID,Short_Diagnosis,Text_ICD,Severity,CONVERT(Diagnosis.Dx_Order, CHAR(10)) as Dx_Order,Primary_Diagnosis, Secondary_Diagnosis,DG_Type from #Request.prefix_db_agency#.Diagnosis where Assessment_ID='#session.cs.AssessmentId#' and M0230_Link like '%M0230%' and M0230_Link is not null 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');

#GetP.First_Name# #GetP.Last_Name#, Recertification