SELECT Assessment_New.Assessment_ID, Assessment_New.Record_creation_Date, Assessment_New.Assessment_tracker_ID, Assessment_New.Patient_ID, Assessment_New.admission_status, Assessment_New.Assessment_Reason_M0100, patient.Last_Name_M0040, patient.First_Name_M0040, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Assessment_Completed_M0090, Assessment_New.Transmission_status, Assessment_New.Start_of_Care_M0030, patient.Middle_Initial_M0040 ,patient.AD_On_File ,patient.AD_Content ,patient.AD_Eff_Date FROM #Request.prefix_db_agency#.patient JOIN #Request.prefix_db_agency#.Assessment_New on Assessment_New.Patient_ID = patient.Patient_ID Where patient.Agency_ID = '#session.agencyid#' AND patient.Status = 'active' AND Assessment_New.Deleted = 0 AND Assessment_New.Start_of_Care_M0030 BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# AND patient.AD_On_File = 'Yes' AND patient.AD_On_File = 'No' AND patient.AD_On_File is not null ORDER BY Assessment_New.Start_of_Care_M0030 ASC SELECT Assessment_New.Assessment_ID, Assessment_New.Record_creation_Date, Assessment_New.Assessment_tracker_ID, Assessment_New.Patient_ID, Assessment_New.admission_status, Assessment_New.Assessment_Reason_M0100, patient.Last_Name_M0040, patient.First_Name_M0040, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Assessment_Completed_M0090, Assessment_New.Transmission_status, Assessment_New.Start_of_Care_M0030, patient.Middle_Initial_M0040 ,patient.AD_On_File ,patient.AD_Content ,patient.AD_Eff_Date FROM #Request.prefix_db_agency#.patient JOIN #Request.prefix_db_agency#.Assessment_New on Assessment_New.Patient_ID = patient.Patient_ID Where patient.Agency_ID = '#session.agencyid#' AND patient.Status = 'active' AND Assessment_New.Deleted = 0 AND patient.Employee_ID = '#session.EmployeeID#' AND Assessment_New.Start_of_Care_M0030 BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# AND patient.AD_On_File = 'Yes' AND patient.AD_On_File = 'No' AND patient.AD_On_File is not null ORDER BY Assessment_New.Start_of_Care_M0030 ASC
Advance Directives Tracking List
" /> to " />
Date Format: mm/dd/yyyy
Reset Print below Report
Patient Start Of care Date AD on File AD Effective Date AD Content
#Last_Name_M0040# #First_Name_M0040# #DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")# #AD_On_File# #DateFormat(AD_Eff_Date,"mm/dd/yyyy")# #AD_Content#
#Last_Name_M0040# #First_Name_M0040# #DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")# #AD_On_File# #DateFormat(AD_Eff_Date,"mm/dd/yyyy")# #AD_Content#