select sch.Visit_Date, sch.Visit_Type, sch.Rev_Code, sch.HCPCS, py.PayName, au.StartDate, au.EndDate, pt.Last_Name_M0040 AS Last_Name, pt.First_Name_M0040 AS First_Name from #Request.prefix_db_agency#.ScheduleItems sch, #Request.prefix_db_agency#.authorizations au, #Request.prefix_db_agency#.patient pt, #Request.prefix_db_agency#.Payer py where sch.Rev_CodeID = au.Rev_CodeID AND sch.Payer_ID = au.Payer_ID AND sch.Payer_ID = py.Payer_ID AND sch.Patient_ID = au.Patient_ID and sch.Visit_Date between au.StartDate and au.EndDate and sch.Patient_Id = pt.Patient_Id and sch.Auth_Id = 0 and au.Deleted <> 1 and pt.Patient_Id = #url.id#; invalid request
#GetList.Last_Name# #GetList.First_Name# Not Connected to an Active Authorization
Visit Date Prior Auth Start Prior Auth End Prior Auth Payer Prior Auth Visit Type
#DateFormat(Visit_Date,"mm/dd/yyyy")# #DateFormat(StartDate,"mm/dd/yyyy")# #DateFormat(EndDate,"mm/dd/yyyy")# #PayName# #Visit_Type#