SELECT Patient_ID, First_Name_M0040, Last_Name_M0040, Middle_Initial_M0040 FROM #Request.prefix_db_agency#.patient WHERE Agency_ID = AND Status = 'active' ORDER BY Last_Name_M0040 SELECT Patient_ID, Last_Name_M0040, First_Name_M0040, Middle_Initial_M0040, Payer_ID FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = SELECT Assessment_ID, Start_of_Care_M0030, Admission_Status, Assessment_Reason_M0100, Assessment_Completed_M0090, Assessment_Tracker_ID, Certification_Start, Certification_End FROM #Request.prefix_db_agency#.Assessment_New WHERE Patient_ID = AND Deleted <> 1 AND (Assessment_Reason_M0100 LIKE '1%' OR Assessment_Reason_M0100 LIKE '4%' OR Assessment_Reason_M0100 LIKE '%Evaluation%') ORDER BY Assessment_Completed_M0090 Desc SELECT Payer_ID, PayName, Output_Type FROM #Request.prefix_db_agency#.Payer WHERE Agency_ID = ORDER BY PayName SELECT Assessment_ID, Start_of_Care_M0030, Admission_Status, Assessment_Reason_M0100, Assessment_Completed_M0090, Assessment_Tracker_ID, Certification_Start, Certification_End, Homebound_Status FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_Tracker_ID = ORDER BY Assessment_Completed_M0090 Desc SELECT Employee_ID, First_Name, Last_Name FROM #Request.prefix_db_lookup#.Employee WHERE Agency_ID = AND Status = 'Active' AND EmployeeType != 'Physician' ORDER BY Last_Name SELECT Revenue_Code.Rev_CodeID, Revenue_Code.Visit_Type, Revenue_Code.Description, Revenue_Code.Payer_ID, Payer.Payer_ID, Payer.Output_Type FROM #Request.prefix_db_agency#.Revenue_Code, #Request.prefix_db_agency#.Payer WHERE Revenue_Code.Agency_ID = And Payer.Payer_ID = Revenue_Code.Payer_ID AND Revenue_Code.Payer_ID = AND Payer.Output_Type = And Revenue_Code.EClaim_Price IS NOT NULL And Revenue_Code.Quick_Books_Price IS NOT NULL Order by Revenue_Code.Visit_Type ASC SELECT ScheduleItems_ID FROM #Request.prefix_db_agency#.ScheduleItems WHERE Visit_Date = AND Patient_ID = SELECT Revenue_Code.Rev_CodeID, Revenue_Code.Visit_Type, Revenue_Code.Rev_Code, Revenue_Code.HCPCS, Revenue_Code.EClaim_Price, Revenue_Code.Quick_Books_Price, Revenue_Code.Measure, Revenue_Code.Description, Revenue_Code.Payer_ID, Payer.Payer_ID, Payer.Output_Type FROM #Request.prefix_db_agency#.Revenue_Code, #Request.prefix_db_agency#.Payer WHERE Revenue_Code.Rev_CodeID = And Payer.Payer_ID = Revenue_Code.Payer_ID
Add a Visit - Step 1

 Select a Patient from the list below.
Add a Visit - Step 2

Patient Selected: #Last_Name_M0040#, #First_Name_M0040# #Middle_Initial_M0040#

Select an Assessment from the list below.

Cert Start Cert End Assessment Type Status
#DateFormat(Certification_Start,'mmm dd, yyyy')# #DateFormat(Certification_End,'mmm dd, yyyy')# #Assessment_Reason_M0100# #Admission_Status#
Add a Visit - Step 3

Patient Selected: #Session.Patient.Last#, #Session.Patient.First# #Session.Patient.Middle#

Select a Payer from the list below.
Add a Visit - Step 4

Patient Selected: #Session.Patient.Last#, #Session.Patient.First# #Session.Patient.Middle#

#Session.Patient.Last#, #Session.Patient.First# #Session.Patient.Middle#

#TempPayer#
Must be between #DateFormat(GetAssessDet.Certification_Start,"mm/dd/yyyy")# and #DateFormat(GetAssessDet.Certification_End,"mm/dd/yyyy")#
">
Date Format: mm/dd/yyyy
>
>

Remember to click Prepare Today's Schedule to download the visit.
Visits

The date you entered is not within the Certification Period for this assessment.


Please click the Back button in your browser to enter a new date.


Patient Schedule Updated


Click here to return to Visit Compliance.