Your session has Timed Out.

Please Sign In again to continue.

The information you provided in the form was incomplete or incorrect. Please take a moment to review the following list:

Patient Id Is Missing.

Your Session has timed out. Please Login again.

The information you provided in the form was incomplete or incorrect. Please take a moment to review the following list:

Revenue Code is required.
select Assessment_Tracker_ID from Assessment_New where Assessment_ID='#form.Assessment_ID#' SELECT Rev_CodeId, EClaim_Price, Quick_Books_Price, HCPCS, Rev_Code, Visit_Type, Measure, Description FROM #Request.prefix_db_agency#.Revenue_Code WHERE Rev_CodeId = '#form.Rev_CodeId#' AND Agency_Id = '#session.AgencyId#' SELECT Assessment_Reason_M0100 as vt FROM #Request.prefix_db_agency#.Assessment_New WHERE assessment_tracker_id = '#Session.CS.AssessmentTrackerID#' AND assessment_id = '#Session.CS.AssessmentID#' AND (Agency_ID = '#session.AgencyID#' or Agency_ID = 1) SELECT Pay_Rate, Measure FROM #Request.prefix_db_agency#.Employee_Payroll WHERE Agency_ID = '#session.AgencyID#' AND EmpPay_ID = '#form.EmpPay_ID#' SELECT Output_Type FROM #Request.prefix_db_agency#.Payer WHERE Agency_ID = #session.AgencyID# AND Payer_ID = '#form.Payer_ID#' 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,Payer_ID, StartTime, EndTime, Rev_CodeID, Paperwork,Travel,Mileage,Telephony_Yes,Total_Units,Total_EClaim,Total_QB,Visit_Notes,Missed,PayMileage, Bill_Type, Rev_Code,HCPCS,Output_Type,Instructions ) VALUES ( '#Session.CS.PatientID#', #CreateODBCDateTime(form.Visit_Date)#,'#form.Employee_ID#', '#form.EmpPay_ID#',#Now()#, '#form.Employee_ID#', #Now()#,'#form.Employee_ID#','#Session.AgencyID#','#Form.Visit_Type#', '#Session.CS.AssessmentTrackerID#','#Session.CS.AssessmentID#','#Form.Progress_Note#','#Form.Payer_ID#', #CreateODBCTime(Form.StartTime)#, #CreateODBCTime(Form.EndTime)#, '#Form.Rev_CodeID#','#Form.Paperwork#', '#Form.Travel#','#Form.Mileage#','#Form.Telephony_Yes#','#form.Total_Units#','#form.Total_EClaim#','#form.Total_QB#', '#Form.Visit_Notes#','#Form.Missed#','#Form.PayMileage#','#Form.Bill_Type#','#Form.Rev_Code#','#form.HCPCS#', '#form.Output_Type#','#Form.Visit_Instructions#') select MAX(scheduleitems_id) as maxid from #Request.prefix_db_agency#.ScheduleItems where agency_id = '#session.agencyid#' and employee_id = '#form.employee_id#' Update #Request.prefix_db_agency#.ScheduleItems set Visit_Date=#CreateODBCDateTime(form.Visit_Date)#, Employee_ID='#form.Employee_ID#', Payer_ID='#Form.Payer_ID#', EmpPay_ID='#Form.EmpPay_ID#', Record_creation_Date=#Now()#, Record_created_By='#form.Employee_ID#', Record_Mod_Date=#Now()#, Record_Mod_By='#form.Employee_ID#', Agency_ID='#Session.AgencyID#', Visit_Type='#Form.Visit_Type#', Output_Type='#form.Output_Type#', Instructions='#Form.Visit_Instructions#', Assessment_Tracker_Id = 0'#Session.CS.AssessmentTrackerID#', Assessment_Id = '#Form.Assessment_Id#', Progress_Note='#Form.Progress_Note#', StartTime=#CreateODBCTime(Form.StartTime)#, EndTime=#CreateODBCTime(Form.EndTime)#, Rev_CodeID='#Form.Rev_CodeID#', Paperwork='#Form.Paperwork#', Travel='#Form.Travel#' ,Mileage='#Form.Mileage#' ,Telephony_Yes='#Form.Telephony_Yes#' ,Visit_Notes='#Form.Visit_Notes#' ,Total_Units='#form.Total_Units#' ,Total_EClaim='#form.Total_EClaim#' ,Total_QB='#form.Total_QB#' ,Missed='#form.Missed#' ,PayMileage='#Form.PayMileage#' ,Bill_Type='#form.Bill_Type#' ,Rev_Code='#Rev_Code#' ,HCPCS='#form.HCPCS#' where ScheduleItems_Id = '#Form.ScheduleItems_Id#' update #Request.prefix_db_agency#.ScheduleItems set telephony_id = '#siti#' where scheduleitems_id = '#form.scheduleitems_id#'