SELECT * FROM #Request.prefix_db_lookup#.pathway_list WHERE Type = 'goal' OR Type = 'intervention' WHERE Type = GROUP BY Pathway_ID,M0_Answer SELECT Employee_ID, Last_Name,First_Name FROM #Request.prefix_db_lookup#.Employee WHERE Status = 'active' AND Agency_ID = #arguments.AgencyID# ORDER BY Last_Name,First_Name SELECT patient.Patient_ID, Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_ID,Assessment_New.Assessment_Tracker_ID, Assessment_New.cdate_cdarte, Assessment_New.Assessment_Number,Assessment_New.Start_of_Care_M0030, Assessment_New.Transmission_Status, Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Transmission_Status, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Assessment_New.Admission_Status FROM #Request.prefix_db_agency#.patient JOIN #Request.prefix_db_agency#.Assessment_New on patient.Patient_ID = Assessment_New.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New_CW on Assessment_New.Assessment_ID = Assessment_New_CW.Assessment_ID WHERE patient.Agency_ID = AND patient.Status = 'active' AND Assessment_New.deleted <> 1 AND Assessment_New.Archive <> 1 AND (Assessment_Reason_M0100 like '%Start of Care%' OR Assessment_Reason_M0100 like '%Resumption of Care%' OR Assessment_Reason_M0100 like '%Recertification%' OR Assessment_Reason_M0100 like '%Adult%') GROUP BY Assessment_New.Assessment_ID Order by Assessment_New.cdate_cdarte DESC,Assessment_New.Start_of_Care_M0030 DESC , PatientLast ASC SELECT patient.Patient_ID, Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_ID,Assessment_New.Assessment_Tracker_ID, Assessment_New.cdate_cdarte, Assessment_New.Assessment_Number,Assessment_New.Start_of_Care_M0030, Assessment_New.Transmission_Status, Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Transmission_Status, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Assessment_New.Admission_Status FROM #Request.prefix_db_agency#.patient JOIN #Request.prefix_db_agency#.Assessment_New on patient.Patient_ID = Assessment_New.Patient_ID LEFT JOIN #Request.prefix_db_agency#.Assessment_New_CW on Assessment_New.Assessment_ID = Assessment_New_CW.Assessment_ID WHERE patient.Agency_ID = AND patient.Patient_ID = AND patient.Status = 'active' AND Assessment_New.deleted <> 1 AND Assessment_New.Archive <> 1 AND (Assessment_Reason_M0100 like '%Start of Care%' OR Assessment_Reason_M0100 like '%Resumption of Care%' OR Assessment_Reason_M0100 like '%Recertification%' OR Assessment_Reason_M0100 like '%Adult%') SELECT patient.Patient_ID, Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_ID,Assessment_New.Assessment_Tracker_ID, Assessment_New.cdate_cdarte, Assessment_New.Assessment_Number,Assessment_New.Start_of_Care_M0030, Assessment_New.Transmission_Status, Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Transmission_Status, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Assessment_New.Admission_Status FROM #Request.prefix_db_agency#.patient JOIN #Request.prefix_db_agency#.Assessment_New on patient.Patient_ID = Assessment_New.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New_CW on Assessment_New.Assessment_ID = Assessment_New_CW.Assessment_ID WHERE patient.Agency_ID = AND patient.Status = 'active' AND Assessment_New.deleted <> 1 AND Assessment_New.Archive <> 1 AND (Assessment_Reason_M0100 like '%Start of Care%' OR Assessment_Reason_M0100 like '%Resumption of Care%' OR Assessment_Reason_M0100 like '%Recertification%' OR Assessment_Reason_M0100 like '%Adult%') GROUP BY patient.Patient_ID Order by Assessment_New.cdate_cdarte DESC,Assessment_New.Start_of_Care_M0030 DESC , PatientLast ASC SELECT patient.Patient_ID, Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_ID,Assessment_New.Assessment_Tracker_ID, Assessment_New.cdate_cdarte, Assessment_New.Assessment_Number,Assessment_New.Start_of_Care_M0030, Assessment_New.Transmission_Status, Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Transmission_Status, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Assessment_New.Admission_Status, Assessment_New.OASIS_2019_2020_PDGM FROM #Request.prefix_db_agency#.patient JOIN #Request.prefix_db_agency#.Assessment_New on patient.Patient_ID = Assessment_New.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New_CW on Assessment_New.Assessment_ID = Assessment_New_CW.Assessment_ID JOIN #Request.prefix_db_agency#.Assessment_New_CW on Assessment_New.Assessment_ID = Assessment_New_CW.Assessment_ID WHERE patient.Agency_ID = AND patient.Status = 'active' AND Assessment_New.deleted <> 1 AND Assessment_New.Archive <> 1 AND (Assessment_Reason_M0100 like '%Start of Care%' OR Assessment_Reason_M0100 like '%Resumption of Care%' OR Assessment_Reason_M0100 like '%Recertification%') GROUP BY Assessment_New.Assessment_ID Order by Assessment_New.cdate_cdarte DESC,Assessment_New.Start_of_Care_M0030 DESC , PatientLast ASC } /> SELECT patient.Patient_ID, Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_ID,Assessment_New.Assessment_Tracker_ID, Assessment_New.cdate_cdarte, Assessment_New.Assessment_Number,Assessment_New.Start_of_Care_M0030, Assessment_New.Transmission_Status, Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Transmission_Status,Assessment_New.cdate_cdarte, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Assessment_New.Admission_Status, Assessment_New.OASIS_2019_2020_PDGM, (select COUNT(*) from #Request.prefix_db_agency#.Coding_Results where Coding_Results.Patient_ID = patient.Patient_ID and Coding_Results.Assessment_ID = Assessment_New.Assessment_ID and M0_Item_Medication like '%(M102%' ) as Recommended_Diagnosis_Report, (select COUNT(*) from #Request.prefix_db_agency#.Coding_Results where Coding_Results.Patient_ID = patient.Patient_ID and Coding_Results.Assessment_ID = Assessment_New.Assessment_ID ) as Recom_Visit_Schdule_Report , (select COUNT(*) from #Request.prefix_db_agency#.Coding_Scrub where Coding_Scrub.Patient_ID = patient.Patient_ID and Coding_Scrub.Assessment_ID = Assessment_New.Assessment_ID ) as OASIS_D_PDGM_Report FROM #Request.prefix_db_agency#.patient JOIN #Request.prefix_db_agency#.Assessment_New on patient.Patient_ID = Assessment_New.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New_CW on Assessment_New.Assessment_ID = Assessment_New_CW.Assessment_ID LEFT JOIN #Request.prefix_db_agency#.Coding_Results on Coding_Results.Patient_ID = patient.Patient_ID and Coding_Results.Assessment_ID = Assessment_New.Assessment_ID WHERE patient.Agency_ID = AND patient.Status = 'active' AND Assessment_New.deleted <> 1 AND Assessment_New.Archive <> 1 AND (Assessment_Reason_M0100 like '%Start of Care%' OR Assessment_Reason_M0100 like '%Resumption of Care%' OR Assessment_Reason_M0100 like '%Recertification%' OR Assessment_Reason_M0100 like '%Adult%' OR Assessment_Reason_M0100 like '%Other%') GROUP BY Assessment_New.Assessment_ID Order by Assessment_New.cdate_cdarte DESC,Assessment_New.Start_of_Care_M0030 DESC , PatientLast ASC } />