SELECT *
FROM #Request.prefix_db_agency#.Revenue_Code
WHERE Agency_ID = #session.AgencyID#
AND Rev_CodeID = '#form.Rev_CodeID#'
SELECT Pay_Rate
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#'
Update #Request.prefix_db_agency#.ScheduleItems
Set
Patient_ID = #form.patient_ID#,
Visit_Date = #CreateODBCDateTime(form.visitdate)#,
Employee_ID = #form.employee_ID#,
Record_Mod_Date = #now()#,
Record_Mod_By = #Session.EmployeeID#,
Payer_ID = '#form.Payer_ID#',
Rev_CodeID = '#form.Rev_CodeID#',
EmpPay_ID = '#form.EmpPay_ID#',
StartTime = '#form.StartTime#',
EndTime = '#form.EndTime#',
Rev_Code = '#Rev_Code#',
Visit_Type = '#Visit_Type#',
Bill_Type = '#Bill_Type#',
HCPCS = '#HCPCS#',
Output_Type = '#Output_Type#',
Total_Units = #units#,
Total_EClaim = #eclaimtot#,
Total_QB = #qbtot#,
Total_EPay = #total_epay#,
Progress_Note = '#form.progress_note#',
Visit_Notes = '#form.visit_notes#',
Missed = '#form.missed#'
Where ScheduleItems_ID = #Form.ScheduleItems_ID#
AND Agency_ID = #session.AgencyID#
Visit Updated
Click to return to Employee Compliance.