SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Visit_Date = '#Visit_Date#' AND (time('#starttime#') Between StartTime And EndTime OR time('#Endtime#') Between StartTime And EndTime OR StartTime Between time('#starttime#') AND time('#Endtime#') OR EndTime Between time('#starttime#') AND time('#Endtime#')) AND Assmt_ID = #Assmt_ID# AND Patient_ID = #PatientID# AND Schedule_ID != #arguments.Schedule_ID# AND EndTime != time('#starttime#') AND StartTime != time('#Endtime#') AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Visit_Date = '#Visit_Date#' AND (time('#starttime#') Between StartTime And EndTime OR time('#Endtime#') Between StartTime And EndTime OR StartTime Between time('#starttime#') AND time('#Endtime#') OR EndTime Between time('#starttime#') AND time('#Endtime#')) AND Emp_ID = '#Emp_ID#' AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.ScheduleItems WHERE Visit_Date = '#Visit_Date#' AND (time('#starttime#') Between StartTime And EndTime OR time('#Endtime#') Between StartTime And EndTime OR StartTime Between time('#starttime#') AND time('#Endtime#') OR EndTime Between time('#starttime#') AND time('#Endtime#')) AND Assessment_ID = #AssessmentID# AND Patient_ID = #PatientID# SELECT * FROM #Request.prefix_db_agency#.ScheduleItems WHERE Visit_Date = '#Visit_Date#' AND (time('#starttime#') Between StartTime And EndTime OR time('#Endtime#') Between StartTime And EndTime OR StartTime Between time('#starttime#') AND time('#Endtime#') OR EndTime Between time('#starttime#') AND time('#Endtime#')) AND Employee_ID = #Employee_ID# SELECT pAuths.*, pPayer.bypass_compliance, pAdmit.Admit_Type FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pPtPayer ON pAuths.PtPayer_ID = pPtPayer.PtPayer_ID AND pPtPayer.Status = 0 JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pAssessments ON pAuths.Assmt_ID = pAssessments.Assmt_ID AND pAssessments.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID AND pAdmit.Status = 0 WHERE pAuths.Assmt_ID = AND pAuths.Auth_ID = AND pAuths.Status = SELECT pAuths.*, pPayer.bypass_compliance, pAdmit.Admit_Type FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pPtPayer ON pAuths.PtPayer_ID = pPtPayer.PtPayer_ID AND pPtPayer.Status = 0 JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pAssessments ON pAuths.Assmt_ID = pAssessments.Assmt_ID AND pAssessments.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pAdmit ON pAssessments.Admit_ID = pAdmit.Admit_ID AND pAdmit.Status = 0 WHERE pAuths.Assmt_ID = AND pAuths.Auth_ID = AND pAuths.Status = AND (pAuths.Date_Start <= '#DateFormat(arguments.VisitDate,"yyyy-mm-dd")#' AND pAuths.Date_End >= '#DateFormat(arguments.VisitDate,"yyyy-mm-dd")#') SELECT * FROM #Request.prefix_db_agency#.pPtmeds Left outer join #Request.prefix_db_lookup#.Meds_New mn on pPtmeds.Drug_ID = mn.Trade_id WHERE Patient_ID = #Patient_ID# AND mn.RX_ID = #RX_ID# AND Status <> '2' SELECT * FROM #Request.prefix_db_lookup#.Coding_Request WHERE Last_Name = '#Last_Name#' AND First_Name = '#First_Name#' AND Agency_ID = #Agency_name# AND Assessment_Type = '#Assessment_Type#' AND Assessment_Date = #CreateODBCDate(Assessment_Date)#