SELECT pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Patient_ID, pSchedules.Assmt_ID, pPatients.Pt_Last, pPatients.Pt_First, IFNULL(pRevenue_Code.HCPCS, '') AS HCPCS, IFNULL(pRevenue_Code.Description, '') AS Rev_Description FROM #Request.prefix_db_agency#.pSchedules LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee on pSchedules.Emp_ID = pEmployee.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients on pSchedules.Patient_ID = pPatients.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments on pSchedules.Assmt_ID = pAssessments.Assmt_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pSchedules.HCPCS_ID AND pRevenue_Code.Status = 0 WHERE pSchedules.Patient_ID = pSchedules.Emp_ID = AND pSchedules.Status = AND pPatients.Status < AND pAssessments.Status = AND pSchedules.Visit_Date > CURDATE() GROUP BY pSchedules.Schedule_ID ORDER BY pSchedules.Visit_Date ASC
Patient Name Visit Date HCPCS Description Action
#HTMLEditFormat(Pt_Last)#, #HTMLEditFormat(Pt_First)# #DateFormat(Visit_Date,'mmm dd, yyyy')# #HTMLEditFormat(HCPCS)# #HTMLEditFormat(Rev_Description)#
Delete VisitUn-assign Now
No Visits Exist for this Employee