Your session has Timed Out.

Please Sign In again to continue.
SELECT Employee.Employee_ID, Employee.Last_Name, Employee.First_Name FROM #Request.prefix_db_lookup#.Employee WHERE Employee.Agency_ID = '#session.AgencyID#' AND Employee.Status = 'active' AND Employee.EmployeeType != 'Physician' Group by Employee.employee_id Order by Employee.Last_Name SELECT e.Employee_ID, e.Last_Name, e.First_Name, e.Skill, l.License_Type, l.Expiration_Date, l.Comments FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_agency#.EmployeeLicenses l WHERE e.Agency_ID = #session.AgencyID# AND e.Employee_ID = l.Employee_ID AND e.status = 'active' AND e.EmployeeType != 'Physician' AND l.Expiration_Date < now() and l.License_Type != 'Inservice' Group by Employee_ID ORDER BY Last_Name Select patient.Patient_ID, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040, patient.Payer_ID From #Request.prefix_db_agency#.patient Where patient.Patient_ID = '#Session.CS.PatientID#' SELECT Assessment_Reason_M0100 as visit_type from #Request.prefix_db_agency#.Assessment_New where assessment_tracker_id = '#Session.CS.AssessmentTrackerID#' and assessment_id = '#Session.CS.AssessmentID#' select authorizations.StartDate,authorizations.EndDate from #Request.prefix_db_agency#.authorizations WHERE authorizations.Patient_ID = '#GetSched.Patient_ID#' AND authorizations.Payer_ID = '#GetSched.PAYER_ID#' AND authorizations.Deleted <> 1 SELECT authorizations.Auth_ID,authorizations.Payer_ID,Payer.PayName,authorizations.Authorization_Number, authorizations.Revenue_Code,authorizations.HCPCS_Code,authorizations.StartDate,authorizations.EndDate from #Request.prefix_db_agency#.authorizations,#Request.prefix_db_agency#.Payer,#Request.prefix_db_agency#.ScheduleItems WHERE authorizations.Payer_ID= Payer.Payer_ID AND authorizations.Revenue_Code= ScheduleItems.Rev_Code AND authorizations.Payer_ID= ScheduleItems.Payer_ID AND authorizations.Patient_ID = '#GetSched.Patient_ID#' AND authorizations.Payer_ID = '#GetSched.PAYER_ID#' AND ScheduleItems.Visit_Date >= '#DateFormat(Get_auth_date.StartDate,"yyy-mm-dd")#' AND ScheduleItems.Visit_Date <= '#DateFormat(Get_auth_date.EndDate,"yyy-mm-dd")#' AND authorizations.Deleted <> 1 Group By authorizations.Auth_ID Select Certification_Start as Cert_Start1, Certification_End as Cert_End1, Assessment_Reason_M0100 from #Request.prefix_db_agency#.Assessment_New where Assessment_Tracker_ID = '#GetSched.Assessment_Tracker_ID#' SELECT Assessment_Reason_M0100, Assessment_Tracker_ID, Assessment_ID, Certification_Start AS Cert_Start, Certification_End AS Cert_End ,Assessment_Completed_M0090,Admission_Status FROM #Request.prefix_db_agency#.Assessment_New WHERE Patient_ID = '#GetSched.Patient_ID#' AND Deleted <> 1 ORDER BY Assessment_Completed_M0090 Desc SELECT Employee_Payroll.EmpPay_ID, Employee_Payroll.Employee_ID, Agency_Payroll.Visit_Type, Agency_Payroll.Description FROM #Request.prefix_db_agency#.Employee_Payroll, #Request.prefix_db_agency#.Agency_Payroll WHERE Agency_Payroll.Agency_ID = '#session.AgencyID#' AND Agency_Payroll.Deleted != 'Y' AND Employee_Payroll.Payroll_ID = Agency_Payroll.Payroll_ID AND Employee_Payroll.Employee_ID = '#GetSched.Employee_ID#' AND Employee_Payroll.Deleted != 'Y' ORDER BY Employee_Payroll.Employee_Id, Agency_Payroll.Visit_Type, Agency_Payroll.Description SELECT Payer_ID, PayName, Output_Type FROM #Request.prefix_db_agency#.Payer WHERE Agency_ID = '#session.AgencyID#' AND PayerStatus = 'active' ORDER BY PayName SELECT Rev_Code, Rev_CodeID, HCPCS, Visit_Type, Payer_ID FROM #Request.prefix_db_agency#.Revenue_Code WHERE Agency_ID = '#session.AgencyID#' And RevenueCodeStatus = 'active' And Payer_ID = '#GetSched.Payer_ID#' And EClaim_Price IS NOT NULL And Quick_Books_Price IS NOT NULL Order by Visit_Type SELECT Rev_Code, Rev_CodeID, HCPCS, Visit_Type, Payer_ID, Description FROM #Request.prefix_db_agency#.Revenue_Code WHERE Agency_ID = '#session.AgencyID#' And EClaim_Price IS NOT NULL And RevenueCodeStatus = 'active' And Quick_Books_Price IS NOT NULL And Payer_ID = '#GetSched.Payer_ID#' Order by Visit_Type SELECT Homebound_Status FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_New.Assessment_Tracker_ID = '#GetSched.Assessment_Tracker_ID#'
Edit Visit for #GetSched.last_name_m0040#, #getsched.first_name_m0040#

--->
Patient #GetSched.Last_Name_m0040#, #GetSched.First_Name_m0040# #GetSched.Middle_Initial_M0040#    
Assessment * #GetOneAssess.Assessment_Reason_M0100# #DateFormat(GetOneAssess.Cert_Start1,"mm/dd/yyyy")# - #DateFormat(GetOneAssess.Cert_End1,"mm/dd/yyyy")#
Visit Date
Start Time  :  : checked onclick="computeAndValidateDate2('Start',this.form);"> AM  checked onclick="computeAndValidateDate2('Start',this.form);"> PM 
End Time  :  : checked onclick="computeAndValidateDate2('End',this.form);"> AM  checked onclick="computeAndValidateDate2('End',this.form);"> PM 
Status #GetAssess.Admission_Status#
Employee
Payroll Code
Payer Name
Revenue Code
Authorizations
Survo Call
Paperwork Time use 15 for 15 minutes, 30 for 30 minutes etc
Travel Time: use 15 for 15 minutes, 30 for 30 minutes etc
Mileage    checked> Pay Mileage
Instructions
Notes
Missed? checked> Yes    checked> No
Progress Note? checked> Yes    checked> No
Telephony? checked> Yes    checked> No
  
Create a New Patient Satisfaction Survey Question