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, Payer.Payer_ID, Payer.Output_Type FROM #Request.prefix_db_agency#.Revenue_Code, #Request.prefix_db_agency#.Payer WHERE Revenue_Code.Rev_CodeID = And Payer.Payer_ID = Revenue_Code.Payer_ID Order by Revenue_Code.Visit_Type ASC INSERT INTO #Request.prefix_db_agency#.ScheduleItems ( Patient_ID, Visit_Date, Employee_ID, EmpPay_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, Mileage, Output_Type, Telephony_Yes ,Visit_Notes ) VALUES ( #Form.Patient_ID#, #CreateODBCDateTime(ThisDate)#, '#Form.Employee_ID#', '#Form.EmpPay_ID#', #Now()#, #Session.EmployeeID#, #Now()#, #Session.EmployeeID# ,#Session.AgencyID#, '#Form.Visit_Type#', #Form.ATID#, #Form.AID#, 'No', '0', '#Form.Rev_Code#','#Form.HCPCS#' ,'#temppayerid#', #CreateODBCTime(Form.StartTime)#, #CreateODBCTime(Form.EndTime)#, #Form.Rev_CodeID#, #Form.Total_Units#, #Form.Total_EClaim#, #Form.Total_QB# ,'#Form.Bill_Type#', '0.00', '0.00', '0', '#Form.Output_Type#', '#Form.Telephony_Yes#' ,'#Form.Visit_Notes#' ) SELECT Last_Insert_Id() AS maxId update #Request.prefix_db_agency#.ScheduleItems set telephony_id = '#encodefinal#' 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.