Timed Out

Your session has Timed Out.

Please Sign In again to continue.

Incomplete or Incorrect

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

Patient Id Is Missing.

Incomplete or Incorrect

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 #Request.prefix_db_agency#.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#' SELECT Count(*) as Skill FROM #Request.prefix_db_agency#.ScheduleItems WHERE Visit_Type like '%Skilled Nursing%' AND Assessment_ID = '#Session.CS.AssessmentID#' AND Deleted = 0 AND Progress_Note = 'Yes' SELECT Count(*) as Therapy FROM #Request.prefix_db_agency#.ScheduleItems WHERE (Visit_Type like '%therapy%' OR Visit_Type like '%social%') AND Assessment_ID = '#Session.CS.AssessmentID#' AND Deleted = 0 AND Progress_Note = 'Yes' SELECT Count(*) as HHA FROM #Request.prefix_db_agency#.ScheduleItems WHERE Visit_Type like '%home health%' AND Assessment_ID = '#Session.CS.AssessmentID#' AND Deleted = 0 AND Progress_Note = 'Yes' UPDATE #Request.prefix_db_agency#.Assessment_New SET Clinical_Severity_Invalid = #Get_skill.Skill#, Clinical_Severity_Level = #Get_therapy.Therapy#, Clinical_Severity_Score = #Get_hha.HHA# WHERE Assessment_ID = '#Session.CS.AssessmentID#' AND(Assessment_Reason_M0100 like "1 -%" or Assessment_Reason_M0100 like "4 -%") 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.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.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='#form.Rev_Code#' ,HCPCS='#form.HCPCS#' where ScheduleItems_Id = '#Form.ScheduleItems_Id#' UPDATE #Request.prefix_db_agency#.PatientVisitDetails SET Goal_Met = #FORM.met_goal# WHERE Progress_Details_ID = '#FORM.Progress_Details_ID#' UPDATE #Request.prefix_db_agency#.PatientVisitDetails SET Assessment_Tracker_Id = 0'#Session.CS.AssessmentTrackerID#', Assessment_Id = '#form.Assessment_Id#' WHERE ScheduleItems_Id = '#form.ScheduleItems_Id#' update #Request.prefix_db_agency#.ScheduleItems set telephony_id = '#siti#' where scheduleitems_id = '#form.scheduleitems_id#' window.location='#form.previous#';