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 *
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 IGNORE 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,Total_Hours,Total_EPay,ScheduleItems_Dup
,Auth_ID
,Invoice_ID
)
VALUES
(
'#Session.CS.PatientID#', #CreateODBCDateTime(form.Visit_Date)#,'#form.Emp_ID#', '0#Form.EmpPay_ID#',#Now()#,
'#form.Emp_ID#', #Now()#,'#form.Emp_ID#','#Session.AgencyID#','#Form.Visit_Type#',
'#Session.CS.AssessmentTrackerID#','#Session.CS.AssessmentID#','#Form.Progress_Note#','#Form.Payer_ID#',
{t '16:00:00'},#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#','#form.Total_Hours#','#form.Total_EPay#',ScheduleItems_Dup
,'#form.Auth_ID#'
,'#form.inv#'
)
select MAX(scheduleitems_id) as maxid from #Request.prefix_db_agency#.ScheduleItems where agency_id = '#session.agencyid#' and employee_id = '#form.Emp_ID#'
update #Request.prefix_db_agency#.ScheduleItems set telephony_id = '#siti#' where scheduleitems_id = '#form.scheduleitems_id#'
Visit Updated
SELECT Assessment_New.Assessment_ID,
Assessment_New.Assessment_Reason_M0100
FROM #Request.prefix_db_agency#.Assessment_New
WHERE Assessment_New.Assessment_ID='#session.cs.AssessmentId#'