DELETE FROM #Request.prefix_db_lookup#.rpt_patientdecliningstatus SELECT patient.Patient_ID, patient.Last_Name_M0040, patient.First_Name_M0040, patient.Agency_ID FROM #Request.prefix_db_agency#.patient WHERE patient.Status = 'Active' ORDER BY patient.Agency_ID,patient.Patient_ID SELECT patient.Patient_ID, patient.Last_Name_M0040, patient.First_Name_M0040, patient.Agency_ID FROM #Request.prefix_db_agency#.patient WHERE patient.Status = 'Active' GROUP BY patient.Agency_ID,patient.Patient_ID ORDER BY patient.Agency_ID,patient.Patient_ID SELECT pd.Assessment_ID, pd.Skill, pd.Type,pd.Description, pd.Created_By, pd.Record_Creation_Date,pd.M0_Answer, pd.Pathway_Details_ID,pd.Assessment_Tracker_ID,si.Visit_Date,pvd.Patient_ID, pvd.Description as pvd_description,pvd.Performed,pvd.Severity,pvd.Notes,pvd.Reading1,pvd.Type as pvd_type,pvd.Reading2,pvd.Progress_Details_ID FROM #Request.prefix_db_agency#.PatientVisitDetails pvd LEFT OUTER JOIN #Request.prefix_db_agency#.Pathway_Details pd on pvd.Pathway_Details_ID = pd.Pathway_Details_ID LEFT OUTER JOIN #Request.prefix_db_agency#.ScheduleItems si on pvd.ScheduleItems_ID = si.ScheduleItems_ID WHERE pvd.Patient_ID = #PatientList.Patient_ID# AND pd.Deleted is null AND pd.Resolved_Date is null AND pvd.Type in ('Wound','Vital Sign','symptom','Laboratory') AND LENGTH(pd.Description) != 0 AND si.Visit_Date >= #CreateODBCDate(startdate)# ORDER BY pd.M0_Answer,pd.Skill,pd.Description,si.Visit_Date DESC INSERT INTO #Request.prefix_db_lookup#.rpt_patientdecliningstatus (pds_id,GraphURL,Name,Visit,PVisit,Diagnosis,Skill,Type,Description,Severity,PDID,PID,AGID,AID,ATID,Delta) VALUES (#indx#,"page=patient&cat=careplan&AID=#assessment_id#&ATID=#assessment_tracker_ID#&PID=#Patient_ID#&code=#skill#&detail=#type#", "#patientName#", "#patientPrevVisit#", "#patientVisit#", "#M0_Answer#", "#skill#", "#type#", "#Description#", #currentseverity#, #Progress_Details_ID#, #Patient_ID#, #theagencyid#, #assessment_ID#, '#assessment_tracker_ID#', #evaluate((currentseverity-lastseverity)*25)#) #results# #results#