SELECT Patient_ID, Last_Name_M0040, First_Name_M0040, Allergies, Primary_ReferringPhys_ID_M0072 FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = '#session.cs.patientid#' SELECT pd.Assessment_ID, pd.Skill, pd.Description,pd.Type, si.Visit_Date,Ass.Certification_Start,AsF.Addendum_Details_21,AsF.Form_Status FROM #Request.prefix_db_agency#.Pathway_Details pd LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New Ass on pd.Assessment_ID=Ass.Assessment_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_Forms AsF on pd.Assessment_ID = AsF.Assessment_Number LEFT OUTER JOIN #Request.prefix_db_agency#.ScheduleItems si on pd.Assessment_ID = si.Assessment_ID WHERE pd.Assessment_ID = AND pd.Skill = '#url.code#' AND (pd.Deleted IS NULL) AND pd.Resolved_Date IS NULL AND pd.Type = 'Intervention' Group by pd.Description ORDER BY pd.Description

Careplan Current #First_Name_M0040# #Last_Name_M0040# (#Patient_ID#) Patient Unknown
Skill	VisitSchedule	Interventions	DateOrdered	Order#	Signed?	PA

#Skill#

#DateFormat(Visit_Date,"mm/dd/yyyy")#

#Description#

#DateFormat(Certification_Start,"mm/dd/yyyy")#

#Addendum_Details_21#

#Form_Status#

##