SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Skill AS Type, pSchedules.Missed, pSchedules.Progress_Note, pSchedules.Pay_ID, 0 AS No_Days_Progress, "" AS Note_QA , pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, pAssessments.* FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAuths ON pSchedules.Auth_ID = pAuths.Auth_ID JOIN #Request.prefix_db_agency#.pAssessments ON pSchedules.Assmt_ID = pAssessments.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID WHERE pAssessments.status = 0 AND pPatients.Status < 1 AND pSchedules.status= 0 AND pSchedules.Missed = '1' AND pAuths.status = 0 ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pEmployee.Emp_Last ASC, pEmployee.Emp_First ASC, pSchedules.Skill ASC, pSchedules.Visit_Date ASC
Missed Visits
Patient Assessments Employee Visit Date Visit status Visit Type
#PatientLast# #PatientFirst# #F26# (#DateFormat(F177,"mm/dd/yyyy")# - #DateFormat(F178,"mm/dd/yyyy")#) #Emp_Last# #Emp_First# #DateFormat(Visit_Date,"mm/dd/yyyy")# MissedCompletedScheduled #Type#