select si.ScheduleItems_ID,si.SurvoSch_Date,p.Telephone from #Request.prefix_db_agency#.ScheduleItems si join #Request.prefix_db_agency#.patient p on p.Patient_ID = si.Patient_ID where Survocall_Type > 5 and si.Patient_ID = #session.cs.patientid# SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = '#session.cs.patientid#' AND Agency_ID = #session.AgencyID# SELECT ScheduleItems_ID,Visit_Date FROM #Request.prefix_db_agency#.ScheduleItems WHERE Patient_ID = '#session.cs.patientid#' and Survocall_Type is null Order by ScheduleItems_ID desc limit 10 SELECT Visit_Type FROM #Request.prefix_db_agency#.ScheduleItems WHERE ScheduleItems_ID = '#ScheduleID#' select Max(Survocall_Type) as count from #Request.prefix_db_agency#.ScheduleItems where Patient_ID = '#session.cs.patientid#' SELECT Telephone FROM #Request.prefix_db_agency#.patient where Patient_ID = '#session.cs.patientid#' SELECT timezone FROM #Request.prefix_db_lookup#.Agency where Agency_ID = '#session.AgencyID#' limit 1 select count(ScheduleItems_ID) as counts from #Request.prefix_db_agency#.ScheduleItems where Visit_Date = Date_Format(now(),'%Y-%m-%d') and progress_note like '%yes' insert into #Request.prefix_db_agency#.ScheduleItems( Patient_ID, Agency_ID, Employee_ID, Survocall_Type, SurvoSch_Date, SurvoServer_ID, Question1, Question2, Question3, Question4, Question5) values( '#session.cs.patientid#', '#session.AgencyID#', '#Session.EmployeeID#', '#calltype#', '#vdate#', '#Server_ID#', '#QUES1#', '#QUES2#', '#QUES3#', '#QUES4#', '#QUES5#' ) select latitude,longitude from #Request.prefix_db_lookup#.zip_cbsa where state like '#state#' and latitude is not null and longitude is not null limit 1 insert into #Request.prefix_db_agency#.patient( Agency_ID, Status, Last_Name_M0040, First_Name_M0040, City, State_M0050, Telephone, DOB_M0066, Record_Creation_Date, Record_Created_By, Latitude,Longitude) values( '#Agency_ID#', 'active', '#Last_Name_M0040#', '#First_Name_M0040#', '#City#', '#State_M0050#', '#Telephone#', '#DateFormat(DOB_M0066,'yyyy-mm-dd')#', '#DateFormat(Now(),'yyyy-mm-dd')#', '#Record_Created_By#', '#Getlat.latitude#','#Getlat.longitude#' ) select p.Patient_ID, p.Last_Name_M0040, p.First_Name_M0040, p.Middle_Initial_M0040, p.Status, p.Telephone, ps.Call_Result, ps.Call_Time, ps.Caller_ID, ps.Ans1, ps.Ans2, ps.Ans3, ps.Ans4, ps.Ans5, ps.PatientSurvey_ID, s.Visit_Type, s.Question1, s.Question2, s.Question3, s.Question4, s.Question5, s.ScheduleItems_ID, s.Survocall_Type, s.Survo_ID From #Request.prefix_db_agency#.patient p join #Request.prefix_db_agency#.PatientSurvey ps on replace(replace(replace(replace(p.Telephone,'(',''),')',''),'-',''),' ','') = ps.Caller_ID join #Request.prefix_db_agency#.ScheduleItems s on s.Survo_ID = ps.PatientSurvey_ID where p.Agency_ID = '#session.AgencyID#' AND p.Status = 'active' AND ps.Status = 'TRUE' select Patient_ID, Last_Name_M0040, First_Name_M0040, City, State_M0050, Telephone, DOB_M0066 From #Request.prefix_db_agency#.patient p where Patient_ID = '#session.cs.patientid#' update #Request.prefix_db_agency#.patient set Last_Name_M0040 = '#Last_Name_M0040#', First_Name_M0040 = '#First_Name_M0040#', City = '#City#', State_M0050 = '#State_M0050#', Telephone = '#Telephone#', DOB_M0066 = '#DateFormat(DOB_M0066,'yyyy-mm-dd')#' where Patient_ID = '#session.cs.patientid#' select SurvoServer_ID from #Request.prefix_db_agency#.ScheduleItems where ScheduleItems_ID= '#Schedule_ID#' delete from #Request.prefix_db_agency#.ScheduleItems where ScheduleItems_ID= '#Schedule_ID#' SELECT ScheduleItems_ID,Question1, Question2,Question3,Question4,Question5 FROM #Request.prefix_db_agency#.ScheduleItems where ScheduleItems_ID = '#Schedule_ID#' select Max(Survocall_Type) as count from #Request.prefix_db_agency#.ScheduleItems where Patient_ID = '#session.cs.patientid#' SELECT Telephone FROM #Request.prefix_db_agency#.patient where Patient_ID = '#session.cs.patientid#' SELECT timezone FROM #Request.prefix_db_lookup#.Agency where Agency_ID = '#session.AgencyID#' limit 1 select count(ScheduleItems_ID) as counts from #Request.prefix_db_agency#.ScheduleItems where Visit_Date = Date_Format(now(),'%Y-%m-%d') and progress_note like '%yes' Update #Request.prefix_db_agency#.ScheduleItems set Survocall_Type = '#calltype#', SurvoSch_Date = '#vdate#', SurvoServer_ID = '#Server_ID#', Question1 = '#QUES1#', Question2 = '#QUES2#', Question3 = '#QUES3#', Question4 = '#QUES4#', Question5 = '#QUES5#' where ScheduleItems_ID = '#Schedule_ID#' select s.ScheduleItems_ID, s.Survocall_Type, s.Visit_Type, s.Survo_ID, s.Question1, s.Question2, s.Question3, s.Question4, s.Question5, p.Caller_ID, p.Status, s.SurvoSch_Date, p.Call_Time, p.Ans1, p.Ans2, p.Ans3, p.Ans4, p.Ans5 from #Request.prefix_db_agency#.ScheduleItems s left outer join #Request.prefix_db_agency#.PatientSurvey p on p.PatientSurvey_ID = s.Survo_ID where Patient_ID = '#session.cs.patientid#' and Survo_ID > 0 insert into #Request.prefix_db_agency#.Patient_SurveyQuestions ( Agency_ID, Employee_ID, Question, Question_Type ) values ( '#session.AgencyID#', '#Session.EmployeeId#', '#question#', '#questionType#' ) SELECT * FROM #Request.prefix_db_agency#.Patient_SurveyQuestions where (Employee_ID = '#ID#' or Employee_ID = 0) order by Question_Type asc select Max(Survocall_Type) as count from #Request.prefix_db_agency#.ScheduleItems where Patient_ID = '#session.cs.patientid#' SELECT Telephone FROM #Request.prefix_db_agency#.patient where Patient_ID = '#session.cs.patientid#' SELECT timezone FROM #Request.prefix_db_lookup#.Agency where Agency_ID = '#session.AgencyID#' limit 1 select count(ScheduleItems_ID) as counts from #Request.prefix_db_agency#.ScheduleItems where Visit_Date = Date_Format(now(),'%Y-%m-%d') and progress_note like '%yes' update #Request.prefix_db_agency#.ScheduleItems set Survocall_Type = '#calltype#', SurvoSch_Date = '#vdate#', SurvoServer_ID = '#Server_ID#', Question1 ='#QUES1#', Question2 = '#QUES2#', Question3 ='#QUES3#', Question4 = '#QUES4#', Question5 ='#QUES5#' where ScheduleItems_ID = '#SchID#'