SELECT MAX(pPatients.Patient_ID) AS Patient_ID, MAX(pPatients.Pt_Last) AS PatientLast, MAX(pPatients.Pt_First) AS PatientFirst, pSchedules.Schedule_ID, MAX(pSchedules.Visit_Date) AS Visit_Date, MAX(pSchedules.Missed) AS Missed, MAX(pSchedules.Skill) AS Type, MAX(pSchedules.Visit_Type) AS Visit_Type, MAX(pSchedules.Progress_Note) AS Progress_Note, MAX(pSchedules.pgnotesdraft) AS pgnotesdraft, MAX(pSchedules.Pay_ID) AS Pay_ID, 0 AS No_Days_Progress, "" AS Note_QA, MAX(pEmployee.Emp_ID) AS Emp_ID, MAX(pEmployee.Emp_Last) AS Emp_Last, MAX(pEmployee.Emp_First) AS Emp_First, MAX(pAssessments.Assmt_ID) AS Assmt_ID, MAX(pAssessments.F26) AS F26 FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.status = 0 JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status = 0 JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.Status = 0 JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID AND pEmployee.Status = 0 WHERE pSchedules.status = 0 AND pSchedules.Emp_ID != 0 AND pSchedules.pgnotesdraft != 2 AND pSchedules.Visit_Date <= now() AND pSchedules.Visit_Date BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# AND pPatients.patient_id = '#FORM.pid#' AND pEmployee.Emp_ID = '#FORM.eid#' AND EXISTS ( SELECT 1 FROM #Request.prefix_db_agency#.employee_auth WHERE employee_auth.eaID = pEmployee.Emp_ID AND employee_auth.r_PN_QA = 3 ) AND pSchedules.Emp_ID = GROUP BY pSchedules.Schedule_ID ORDER BY PatientLast ASC, PatientFirst ASC, Emp_Last ASC, Emp_First ASC, Type ASC, Visit_Date ASC SELECT COUNT(DISTINCT pSchedules.Schedule_ID) AS total_unapproved FROM #Request.prefix_db_agency#.pSchedules 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 JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID WHERE pAssessments.Status = 0 AND pPatients.Status = 0 AND pSchedules.Status = 0 AND pSchedules.Emp_ID != 0 AND pSchedules.pgnotesdraft != 2 AND pSchedules.Visit_Date <= '#DateFormat(now(),"yyyy-mm-dd")#' AND pAdmit.Status = 0 UPDATE #Request.prefix_db_lookup#.Agency SET unapprove_visits = WHERE Agency_ID = SELECT p.Patient_ID, p.Pt_Last, p.Pt_First, p.Status FROM #Request.prefix_db_agency#.pPatients p WHERE p.Loc_ID = '#session.agencyid#' AND p.Status < 2 AND p.Patient_ID IN (SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID WHERE pSchedules.Emp_ID = AND pSchedules.Status = 0 AND pAssessments.Status =0 ) ORDER BY p.Pt_Last ASC, p.Pt_First ASC SELECT e.Emp_ID, e.Emp_Last, e.Emp_First, e.Status FROM #Request.prefix_db_lookup#.pEmployee e WHERE e.Loc_ID = '#session.agencyid#' AND e.Emp_Type = 'employee' ORDER BY e.Emp_Last ASC, e.Emp_First ASC
Progress Notes that need to be Reviewed Missing Notes (Patient) Missing Notes (Patient)
" /> to " />
Date Format: mm/dd/yyyy
Patient Employee Visit Date How Old? Discipline Assessment Visit Type Missed? Status Action
#PatientLast#, #PatientFirst# #Emp_Last#, #Emp_First# #DateFormat(Visit_Date,"mm/dd/yyyy")# #diffdays# days #Type# #F26# routine visit#Visit_Type# Yes InprogressNOT APPROVEDMissing Edit - Delete
UPDATE #Request.prefix_db_agency#.Dash_emp_count SET status = 1 WHERE status = 0 AND Header = AND Emp_ID = INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , ) SELECT DISTINCT eaID FROM #Request.prefix_db_agency#.employee_auth WHERE r_PN_QA = 3 UPDATE #Request.prefix_db_agency#.Dash_emp_count SET status = 1 WHERE status = 0 AND Header = INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , ) INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , )