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 = SELECT pd.Assessment_ID, pd.Skill, pd.Description, pd.Created_By, pd.Record_Creation_Date, e.Last_Name, pd.Pathway_Details_ID FROM #Request.prefix_db_agency#.Pathway_Details pd, #Request.prefix_db_lookup#.Employee e WHERE pd.Assessment_ID = AND pd.Deleted is not 1 AND pd.Resolved_Date is null AND pd.Created_By = e.Employee_ID Group by pd.Description ORDER BY pd.Skill, pd.Record_Creation_Date, pd.Description SELECT g.Assessment_ID, g.Skill, g.Goal_Description, g.Created_By, g.Record_Creation_Date, e.Last_Name, g.Goals_ID FROM Goals g, #Request.prefix_db_lookup#.Employee e WHERE g.Assessment_ID = AND g.Deleted is null AND g.Created_By = e.Employee_ID Group by g.Goal_Description ORDER BY g.Skill, g.Record_Creation_Date, g.Goal_Description SELECT DISTINCT pd.Pathway_Details_ID AS item_id FROM #Request.prefix_db_agency#.Assessment_New an, #Request.prefix_db_agency#.Pathway_Details pd, #Request.prefix_db_agency#.PatientVisitDetails pvd WHERE an.Assessment_ID = AND pd.Deleted is null AND pd.Resolved_Date is null AND pd.Assessment_ID = an.Assessment_ID AND pvd.Pathway_Details_ID = pd.Pathway_Details_ID UNION SELECT DISTINCT g.Goals_ID AS item_id FROM #Request.prefix_db_agency#.Assessment_New an, Goals g, #Request.prefix_db_agency#.PatientVisitDetails pvd WHERE an.Assessment_ID = AND g.Deleted is null AND g.Resolved_Date is null AND g.Assessment_ID = an.Assessment_ID AND pvd.Pathway_Details_ID = g.Goals_ID MyHomecareBiz.com

Careplan Details for #getP.Last_Name#, #getP.First_Name# #getP.Middle#

Resolved Careplan Deleted Careplan

Interventions


#Skill#
#Description# review #Last_Name# #DateFormat(Record_Creation_Date,"mm/dd/yyyy")#




Goals

#Skill#
#Goal_Description# review #Last_Name# #DateFormat(Record_Creation_Date,"mm/dd/yyyy")#