Your Session has timed out.


Please Login again.

SELECT Employee_Payroll.EmpPay_Id, Employee_Payroll.Emp_ID, Agency_Payroll.Visit_Type, Agency_Payroll.Description FROM #Request.prefix_db_agency#.Employee_Payroll, #Request.prefix_db_agency#.Agency_Payroll WHERE Agency_Payroll.Agency_Id = #session.AgencyId# AND Agency_Payroll.Deleted != 'Y' AND Employee_Payroll.Payroll_Id = Agency_Payroll.Payroll_Id AND Employee_Payroll.Emp_ID = #url.id# AND Employee_Payroll.Deleted != 'Y' AND Employee_Payroll.Emp_ID<>'0' ORDER BY Employee_Payroll.Emp_ID, Agency_Payroll.Visit_Type, Agency_Payroll.Description SELECT * FROM #Request.prefix_db_agency#.pPtPayer JOIN #Request.prefix_db_agency#.pPayer on pPtPayer.Payer_ID = pPayer.Pay_ID WHERE pPtPayer.Status = 0 AND pPtPayer.PtPayer_ID = '#url.id#' SELECT Rev_Code, Rev_CodeID, HCPCS, Visit_Type, Payer_ID, Description FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Agency_ID = '#session.AgencyId#' AND Status = '0' AND EClaim_Price IS NOT NULL AND Quick_Books_Price IS NOT NULL AND Payer_ID = '#getpayers.Pay_ID#' SELECT Rev_Code, Rev_CodeID, HCPCS, Visit_Type, Payer_ID, Description FROM #Request.prefix_db_agency#.pRevenue_Code WHERE Agency_ID = '#session.AgencyId#' AND Status = '0' AND EClaim_Price IS NOT NULL AND Quick_Books_Price IS NOT NULL AND Payer_ID = '#url.id#'
select authorizations.StartDate,authorizations.EndDate from #Request.prefix_db_agency#.authorizations WHERE authorizations.Patient_ID = '#Session.CS.PatientID#' AND authorizations.Payer_ID = '#url.id#' AND authorizations.Deleted <> 1 SELECT authorizations.Auth_ID,authorizations.Payer_ID,Payer.PayName,authorizations.Authorization_Number, authorizations.Revenue_Code,authorizations.HCPCS_Code,authorizations.StartDate,authorizations.EndDate from #Request.prefix_db_agency#.authorizations,#Request.prefix_db_agency#.Payer,#Request.prefix_db_agency#.ScheduleItems WHERE authorizations.Payer_ID= Payer.Payer_ID AND authorizations.Revenue_Code= ScheduleItems.Rev_Code AND authorizations.Payer_ID= ScheduleItems.Payer_ID AND authorizations.Patient_ID = '#Session.CS.PatientID#' AND authorizations.Payer_ID = '#url.id#' AND ScheduleItems.Visit_Date >= '#DateFormat(Get_auth_date.StartDate,"yyy-mm-dd")#' AND ScheduleItems.Visit_Date <= '#DateFormat(Get_auth_date.EndDate,"yyy-mm-dd")#' AND authorizations.Deleted <> 1 Group By authorizations.Auth_ID
select authorizations.StartDate,authorizations.EndDate from #Request.prefix_db_agency#.authorizations WHERE authorizations.Patient_ID = '#Session.CS.PatientID#' AND authorizations.Payer_ID = '#url.id#' AND authorizations.Deleted <> 1 SELECT authorizations.Auth_ID,authorizations.Payer_ID,Payer.PayName,authorizations.Authorization_Number, authorizations.Revenue_Code,authorizations.HCPCS_Code,authorizations.StartDate,authorizations.EndDate from #Request.prefix_db_agency#.authorizations,#Request.prefix_db_agency#.Payer,#Request.prefix_db_agency#.ScheduleItems WHERE authorizations.Payer_ID= Payer.Payer_ID AND authorizations.Revenue_Code= ScheduleItems.Rev_Code AND authorizations.Payer_ID= ScheduleItems.Payer_ID AND authorizations.Patient_ID = '#Session.CS.PatientID#' AND authorizations.Payer_ID = '#url.id#' AND ScheduleItems.Visit_Date >= '#DateFormat(Get_auth_date.StartDate,"yyy-mm-dd")#' AND ScheduleItems.Visit_Date <= '#DateFormat(Get_auth_date.EndDate,"yyy-mm-dd")#' AND authorizations.Deleted <> 1 Group By authorizations.Auth_ID SELECT Distinct Pay_ID, Pay_Name,Payer_No FROM #Request.prefix_db_agency#.pPayer WHERE Loc_ID = #session.AgencyID# AND Status = 0 AND Payer_No = '#url.id#' ORDER BY Pay_Name SELECT pDeposit.*,Invoices.PatientPayer_ID,pPayer.Pay_ID,Invoices.Invoice_ID FROM #Request.prefix_db_agency#.pDeposit LEFT OUTER JOIN #Request.prefix_db_agency#.Invoices ON Invoices.Internal_control_number = pDeposit.Internal_control_number AND Invoices.Deleted = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer ON Invoices.PatientPayer_ID = pPayer.Pay_ID WHERE pDeposit.Dep_ID = '#url.Dep_ID#' AND pDeposit.Status = 0 GROUP BY pDeposit.Dep_ID