careplandash = CreateObject("Component", "careplan"); getproblem = careplandash.getproblems(#url.AID#,#url.Skill#,0,0,0,0); SELECT * FROM getproblem WHERE (M0_No like 'M1021%' OR M0_No like 'M1023%') ORDER BY dx_order ASC SELECT * FROM getproblem WHERE Oasis_Deficits = 1 ORDER BY dx_order ASC SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE Patient_Id = AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_lookup#.pEmployee on pEmployee.Emp_ID = pAssessments.Record_Created_By WHERE pAssessments.Assmt_ID = AND pAssessments.Status = 0 ORDER BY pAssessments.AutoAssmt_ID DESC SELECT pCareplan.*,pPathway.Param,pPathway.Pathway_ID,pPathway.Type_Order,pPathway.Order_ID,pPathway.Type as pathwaytype , pPathway.Header, pPathway.Header_No ,pPathway.Value as Measurevalue ,pPathway.Track FROM #Request.prefix_db_agency#.pCareplan LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pCareplan.Item_ID AND pPathway.Type = pCareplan.Type WHERE pCareplan.Assmt_ID = AND pCareplan.Skill = AND pCareplan.Status = GROUP BY pCareplan.AutoCareplan_ID ORDER BY Header_No ASC, pPathway.Type_Order,pCareplan.Date_Resolve,pPathway.Order_ID ASC

Teaching Plan for

#GetP.Pt_First# #GetP.Pt_Last#

Start of CareRecertificationResumption#Getass.F26# #DateFormat(Getass.F176,"mm/dd/yy")#

Prepared by #Getass.Emp_First# #Getass.Emp_Last#

TABLE OF CONTENTS

#Description#

SELECT * FROM getcareplans WHERE pathwaytype = AND Type = AND Pathway_ID IN ()

#getteach.Description#

Teaching Plan for #GetP.Pt_First# #GetP.Pt_Last#

prepared by #Getass.Emp_First# #Getass.Emp_Last#

page #cfdocument.currentpagenumber#