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.PID# SELECT pd.Assessment_ID, an.Assessment_ID, pd.Skill, pd.Description, pd.Record_Modified_By, pd.Record_Mod_Date, e.Last_Name, pd.Resolved_Date, pd.Item_Number, pd.Pathway_Details_ID FROM #Request.prefix_db_agency#.Assessment_New an, #Request.prefix_db_agency#.Pathway_Details pd, #Request.prefix_db_lookup#.Employee e WHERE an.Assessment_ID = #session.AID# AND (pd.Deleted = 1 or pd.Deleted = 'Yes') AND pd.Assessment_ID = an.Assessment_ID AND pd.Record_Modified_By = e.Employee_ID ORDER BY pd.Resolved_Date DESC, pd.Skill, pd.Description SELECT g.Assessment_ID, an.Assessment_ID, g.Skill, g.Goal_Description, g.Record_Modified_By, g.Record_Mod_Date, e.Last_Name, g.Resolved_Date, g.Goals_ID FROM #Request.prefix_db_agency#.Assessment_New an, Goals g, #Request.prefix_db_lookup#.Employee e WHERE an.Assessment_ID = #session.AID# AND g.Deleted = 'Yes' AND g.Assessment_ID = an.Assessment_ID AND g.Record_Modified_By = e.Employee_ID ORDER BY g.Resolved_Date DESC, g.Skill, 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 = #session.AID# AND pd.Deleted = 1 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 = #session.AID# AND g.Deleted = 'Yes' AND g.Assessment_ID = an.Assessment_ID AND pvd.Pathway_Details_ID = g.Goals_ID MyHomecareBiz.com

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

Interventions


Description History Skill Deleted By Date Deleted
#Description# review #Skill# #Last_Name# #DateFormat(Record_Mod_Date,"mm/dd/yyyy")#




Goals


Description History Skill Deleted By Date Deleted
#Goal_Description# review #Skill# #Last_Name# #DateFormat(Record_Mod_Date,"mm/dd/yyyy")#