hdnval1=#Form.hdnempdata# & edate=#edate# & authid=#authid#
SELECT Revenue_Code.Rev_CodeID, Revenue_Code.Visit_Type, Revenue_Code.Rev_Code, Revenue_Code.HCPCS, Revenue_Code.EClaim_Price, Revenue_Code.Quick_Books_Price, Revenue_Code.Measure, Revenue_Code.Description, Revenue_Code.Payer_ID, Revenue_Code.Tier, Revenue_Code.Units, Revenue_Code.Balance, Payer.Payer_ID, Payer.Output_Type FROM #Request.prefix_db_agency#.Revenue_Code, #Request.prefix_db_agency#.Payer WHERE Revenue_Code.Rev_CodeID = '#Rev_CodeID#' And Payer.Payer_ID = Revenue_Code.Payer_ID Order by Revenue_Code.Visit_Type ASC SELECT Output_Type FROM #Request.prefix_db_agency#.Payer WHERE Agency_ID = #session.AgencyID# AND Payer_ID = '#Form.Payer_ID#' SELECT Pay_Rate, Measure FROM #Request.prefix_db_agency#.Employee_Payroll WHERE Agency_ID = '#session.AgencyID#' AND EmpPay_ID = '#Form.EmpPay_ID#' INSERT INTO #Request.prefix_db_agency#.ScheduleItems( Patient_ID, Visit_Date, Employee_ID, EmpPay_ID, Auth_ID,Record_creation_Date, Record_created_By, Record_Mod_Date, Record_Mod_By, Agency_ID, Visit_Type, Assessment_Tracker_ID, Assessment_ID, Progress_Note, EClaimed, Rev_Code, HCPCS, Payer_ID, StartTime, EndTime, Rev_CodeID, Total_Units, Total_EClaim, Total_QB, Bill_Type, Paperwork, Travel, PayMileage, Output_Type, Telephony_Yes, Instructions, Total_EPay, Total_Hours ) VALUES ( #Session.Patient.PatientIDValue#, #CreateODBCDateTime(edate)#, '#eid#', '#Form.EmpPay_ID#', #authid#, #Now()#, #Session.EmployeeID#, #Now()#, #Session.EmployeeID#, '#Session.AgencyID#', '#Form.typeofvisit#', #Form.ATID#, '#Form.AID#', 'No', '0', '#Form.Rev_Code#', '#Form.HCPCS#', '#Form.payerid#', #CreateODBCTime(Form.StartTime)#, #CreateODBCTime(Form.EndTime)#, #Rev_CodeID#, #Form.Total_Units#, #Form.Total_EClaim#, #Form.Total_QB#, '#Form.Bill_Type#', '#Form.Paperwork#', '#form.Travel#', '#Form.paymileage#', '#Form.Output_Type#', '#Form.Telephony_Yes#', '#Form.Instructions#', #Total_EPay#, #Total_Hours# ) SELECT MAX(ScheduleItems_ID) AS maxId from #Request.prefix_db_agency#.ScheduleItems select count(*) as count from #Request.prefix_db_agency#.authorizations_details where Auth_ID = #authid# select Auth_Details_ID from #Request.prefix_db_agency#.authorizations_details where Auth_ID=#authid# and ScheduleItems_ID is null order by Auth_Details_ID asc limit 1 update #Request.prefix_db_agency#.authorizations_details SET ScheduleItems_ID= '#NewVisit.maxId#' where Auth_Details_ID='#GetAuth_Details_ID.Auth_Details_ID#' and Auth_ID=#authid# and ScheduleItems_ID is null update #Request.prefix_db_agency#.ScheduleItems set telephony_id = '#siti#' where scheduleitems_id = #NewVisit.maxId#

Scheduling Problem

You must select at least one date to schedule.

Please click the Back button in your browser to correct the problem.

Scheduling Problem

For an Admission Visit, you can only specify one visit date.

Please click the Back button in your browser to correct the problem.

Scheduling Problem

One of the dates you specified is outside the Certification Period.

Please click the Back button in your browser to correct the problem.