select Agency_Login from #Request.prefix_db_lookup#.Agency where status='active' ArrayAppend(myArr1,#Agency_Login#); SELECT MAX(p.Progress_Details_ID), s.Visit_Type,pa.Last_Name_M0040,pa.First_Name_M0040,p.Patient_ID,MAX(p.severity) as severity,a.Freq_of_Pain_M0420,a.Start_of_Care_M0030, (select count(Visit_Date) from #Request.prefix_db_agency#.ScheduleItems where Patient_Id = p.Patient_ID and (Visit_Type like '%Skilled Nursing%' or Visit_Type like '%SN%') ) as SN_Visits, a.Start_of_Care_M0030, MAX(s.Visit_Date) as Visit_Date, DATEDIFF(MAX(s.Visit_Date),a.Start_of_Care_M0030) as Diff_visit,1 FROM #Request.prefix_db_agency#.PatientVisitDetails p, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.patient pa where p.Agency_ID = #myArr1[REF]# and p.ScheduleItems_ID = s.ScheduleItems_ID and pa.Patient_ID = p.Patient_ID and pa.status = 'active' and s.Assessment_ID = a.Assessment_ID and (s.Visit_Type like '%SN%' or s.Visit_Type like '%Skilled Nursing%') and s.Progress_Note = 'Yes' and p.Type = 'symptom' and p.Description like '%pain%' and s.Deleted = 0 group by p.Patient_ID order by p.Patient_ID SELECT MAX(p.Progress_Details_ID), s.Visit_Type,pa.Last_Name_M0040,pa.First_Name_M0040,p.Patient_ID,MAX(p.severity) as severity, a.Breathing_M0490 ,a.Start_of_Care_M0030, (select count(Visit_Date) from #Request.prefix_db_agency#.ScheduleItems where Patient_Id = p.Patient_ID and (Visit_Type like '%Skilled Nursing%' or Visit_Type like '%SN%') ) as SN_Visits, a.Start_of_Care_M0030, MAX(s.Visit_Date) as Visit_Date, DATEDIFF(MAX(s.Visit_Date),a.Start_of_Care_M0030) as Diff_visit,1 FROM #Request.prefix_db_agency#.PatientVisitDetails p, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.patient pa where p.Agency_ID = #myArr1[REF]# and p.ScheduleItems_ID = s.ScheduleItems_ID and pa.Patient_ID = p.Patient_ID and pa.status = 'active' and s.Assessment_ID = a.Assessment_ID and (s.Visit_Type like '%SN%' or s.Visit_Type like '%Skilled Nursing%') and s.Progress_Note = 'Yes' and p.Type = 'symptom' and p.Description like '%dyspnea%' and s.Deleted = 0 group by p.Patient_ID order by p.Patient_ID SELECT MAX(p.Progress_Details_ID), s.Visit_Type,pa.Last_Name_M0040,pa.First_Name_M0040,p.Patient_ID,MAX(p.severity) as severity,a.Surgical_Wound_Status_M0488,a.Start_of_Care_M0030, (select count(Visit_Date) from #Request.prefix_db_agency#.ScheduleItems where Patient_Id = p.Patient_ID and (Visit_Type like '%Skilled Nursing%' or Visit_Type like '%SN%') ) as SN_Visits, a.Start_of_Care_M0030, MAX(s.Visit_Date) as Visit_Date, DATEDIFF(MAX(s.Visit_Date),a.Start_of_Care_M0030) as Diff_visit,1 FROM #Request.prefix_db_agency#.PatientVisitDetails p, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.patient pa where p.Agency_ID = #myArr1[REF]# and p.ScheduleItems_ID = s.ScheduleItems_ID and pa.Patient_ID = p.Patient_ID and pa.status = 'active' and s.Assessment_ID = a.Assessment_ID and (s.Visit_Type like '%SN%' or s.Visit_Type like '%Skilled Nursing%') and s.Progress_Note = 'Yes' and p.Type = 'symptom' and p.Description like '%surgical%' and s.Deleted = 0 group by p.Patient_ID order by p.Patient_ID SELECT MAX(p.Progress_Details_ID), s.Visit_Type,pa.Last_Name_M0040,pa.First_Name_M0040,p.Patient_ID,MAX(p.severity) as severity,Bathing_M0670,a.Start_of_Care_M0030, (select count(Visit_Date) from #Request.prefix_db_agency#.ScheduleItems where Patient_Id = p.Patient_ID and (Visit_Type like '%OT%' or Visit_Type like '%occupational%') ) as OT_Visits, a.Start_of_Care_M0030, MAX(s.Visit_Date) as Visit_Date, DATEDIFF(MAX(s.Visit_Date),a.Start_of_Care_M0030) as Diff_visit,1 FROM #Request.prefix_db_agency#.PatientVisitDetails p, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.patient pa where p.Agency_ID = #myArr1[REF]# and p.ScheduleItems_ID = s.ScheduleItems_ID and pa.Patient_ID = p.Patient_ID and pa.status = 'active' and s.Assessment_ID = a.Assessment_ID and (s.Visit_Type like '%OT%' or s.Visit_Type like '%occupational%') and s.Progress_Note = 'Yes' and p.Type = 'symptom' and p.Description like '%bath%' and s.Deleted = 0 group by p.Patient_ID order by p.Patient_ID SELECT MAX(p.Progress_Details_ID), s.Visit_Type,pa.Last_Name_M0040,pa.First_Name_M0040,p.Patient_ID,MAX(p.severity) as severity,a.Transferring_M0690,a.Start_of_Care_M0030, (select count(Visit_Date) from #Request.prefix_db_agency#.ScheduleItems where Patient_Id = p.Patient_ID and (Visit_Type like '%PT%' or Visit_Type like '%physical%') ) as PT_Visits, a.Start_of_Care_M0030, MAX(s.Visit_Date) as Visit_Date, DATEDIFF(MAX(s.Visit_Date),a.Start_of_Care_M0030) as Diff_visit,1 FROM #Request.prefix_db_agency#.PatientVisitDetails p, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.patient pa where p.Agency_ID = #myArr1[REF]# and p.ScheduleItems_ID = s.ScheduleItems_ID and pa.Patient_ID = p.Patient_ID and pa.status = 'active' and s.Assessment_ID = a.Assessment_ID and (s.Visit_Type like '%PT%' or s.Visit_Type like '%physical%') and s.Progress_Note = 'Yes' and p.Type = 'symptom' and p.Description like '%transfer%' and s.Deleted = 0 group by p.Patient_ID order by p.Patient_ID SELECT MAX(p.Progress_Details_ID), s.Visit_Type,pa.Last_Name_M0040,pa.First_Name_M0040,p.Patient_ID,MAX(p.severity) as severity,a.Ambulation_M0700,a.Start_of_Care_M0030, (select count(Visit_Date) from #Request.prefix_db_agency#.ScheduleItems where Patient_Id = p.Patient_ID and (Visit_Type like '%PT%' or Visit_Type like '%physical%') ) as PT_Visits, a.Start_of_Care_M0030, MAX(s.Visit_Date) as Visit_Date, DATEDIFF(MAX(s.Visit_Date),a.Start_of_Care_M0030) as Diff_visit,1 FROM #Request.prefix_db_agency#.PatientVisitDetails p, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.patient pa where p.Agency_ID = #myArr1[REF]# and p.ScheduleItems_ID = s.ScheduleItems_ID and pa.Patient_ID = p.Patient_ID and pa.status = 'active' and s.Assessment_ID = a.Assessment_ID and (s.Visit_Type like '%PT%' or s.Visit_Type like '%physical%') and s.Progress_Note = 'Yes' and p.Type = 'symptom' and p.Description like '%ambul%' and s.Deleted = 0 group by p.Patient_ID order by p.Patient_ID SELECT MAX(p.Progress_Details_ID), s.Visit_Type,pa.Last_Name_M0040,pa.First_Name_M0040,p.Patient_ID,MAX(p.severity) as severity,a.Oral_Meds_M0780,a.Start_of_Care_M0030, (select count(Visit_Date) from #Request.prefix_db_agency#.ScheduleItems where Patient_Id = p.Patient_ID and (Visit_Type like '%Skilled Nursing%' or Visit_Type like '%SN%') ) as SN_Visits, a.Start_of_Care_M0030, MAX(s.Visit_Date) as Visit_Date, DATEDIFF(MAX(s.Visit_Date),a.Start_of_Care_M0030) as Diff_visit,1 FROM #Request.prefix_db_agency#.PatientVisitDetails p, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.patient pa where p.Agency_ID = #myArr1[REF]# and p.ScheduleItems_ID = s.ScheduleItems_ID and pa.Patient_ID = p.Patient_ID and pa.status = 'active' and s.Assessment_ID = a.Assessment_ID and (s.Visit_Type like '%SN%' or s.Visit_Type like '%Skilled Nursing%') and s.Progress_Note = 'Yes' and p.Type = 'symptom' and p.Description like '%medication%' and s.Deleted = 0 group by p.Patient_ID order by p.Patient_ID Update #Request.prefix_db_lookup#.Agency a set a.OMsame=#total_same1#, a.OMworse=#total_worse1#, a.OMbetter=#total_Better1# where a.Agency_Login =#myArr1[REF]#