SELECT patient.Patient_ID, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, ScheduleItems.ScheduleItems_ID, ScheduleItems.Visit_Date, ScheduleItems.Visit_Type AS Type, ScheduleItems.Note_QA, ScheduleItems.Progress_Note, ScheduleItems.EmpPay_ID, Assessment_New.Assessment_Reason_M0100, Assessment_New.Certification_End,Assessment_New.Certification_start, Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Assessment_New.Assessment_ID, Assessment_New.MR_420, Assessment_New.MR_490, Assessment_New.MR_670, Assessment_New.MR_690, Assessment_New.MR_700, Assessment_New.MR_780, Assessment_New.SOC_420, Assessment_New.SOC_490, Assessment_New.SOC_680, Assessment_New.SOC_690, Assessment_New.SOC_700, Assessment_New.SOC_780, Payer.Output_Type, Payer.PayerType, Count(Pathway_Details.Assessment_Tracker_ID) AS CountC FROM #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.Pathway_Details, #Request.prefix_db_lookup#.IncidentTopic, #Request.prefix_db_agency#.Payer WHERE ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID AND Assessment_New.Deleted = 0 AND patient.Patient_ID = '#url.patient#' AND patient.Patient_ID = ScheduleItems.Patient_ID and Assessment_New.Assessment_Tracker_ID = Pathway_Details.Assessment_Tracker_ID AND Assessment_New.Payer_ID = Payer.Payer_ID AND Pathway_Details.Skill = IncidentTopic.Subject_III AND Pathway_Details.Deleted is null AND Pathway_Details.Type != 'teaching' AND Pathway_Details.Resolved_Date is null AND IncidentTopic.Topic = ScheduleItems.Visit_Type AND patient.Status = 'active' AND ScheduleItems.Agency_ID = #session.AgencyID# AND ScheduleItems.Visit_Type Not in ('Assessment','Evaluation') AND (ScheduleItems.EClaimed != 1) AND ScheduleItems.Deleted != 1 AND ScheduleItems.Employee_Id != 0 AND ScheduleItems.Progress_Note = 'Yes' AND ScheduleItems.Note_QA <> 'Approved' AND ScheduleItems.Progress_Note = 'No' AND ScheduleItems.Progress_Note = 'No' AND ScheduleItems.Missed = 'No' AND ScheduleItems.Note_QA != 'Approved' AND ScheduleItems.Visit_Date = '#url.dte#' AND ScheduleItems.Visit_Date <= NOW() AND ScheduleItems.Employee_ID = Employee.Employee_ID Group by ScheduleItems.ScheduleItems_ID ORDER BY patient.Last_Name_M0040 ASC, patient.First_Name_M0040 ASC, Employee.Last_Name ASC, Employee.First_Name ASC, ScheduleItems.Visit_Type ASC, ScheduleItems.Visit_Date ASC

Progress Notes that need to be Reviewed - for Clinical Quality Assurance Missing Notes (Patient) Missing Notes (Patient)

SELECT Count(PatientVisitDetails.ScheduleItems_ID) AS CountP FROM #Request.prefix_db_agency#.PatientVisitDetails WHERE PatientVisitDetails.ScheduleItems_ID = #SN_pain.ScheduleItems_ID# AND PatientVisitDetails.Notes != '' AND PatientVisitDetails.Notes != 'not evaluated' AND PatientVisitDetails.Notes != 'not performed'

	Patient	Employee	Assessment	Certification Start- End	Visit Date	Visit Type	Careplan Items not performed	Action
	#PatientLast#, #PatientFirst#	#Last_Name#, #First_Name#	#Assessment_Reason_M0100#	#DateFormat(Certification_start,"mm/dd/yyyy")# - #DateFormat(Certification_End,"mm/dd/yyyy")#	#DateFormat(Visit_Date,"mm/dd/yyyy")#	#Type#	#notperformed#0 /missing 5-Star /missing 5-Star /missing 5-Star	NOT APPROVED