SELECT p.Pt_Last, p.Pt_First, c.Description, c.Notes, c.Proc_QA, c.Date_Create, c.Order_Date, c.Careplan_ID, c.Skill, e.Emp_Last, e.Emp_First, e.Emp_ID AS AssignedEmpID, a.Visit_Type, a.Patient_ID, a.Parent_Assmt_ID AS Assmt_ID, pA.F26 AS Assessment_Reason_M0100, pA.F177 AS Certification_Start, pA.F178 AS Certification_End FROM #Request.prefix_db_agency#.pCareplan c LEFT JOIN #Request.prefix_db_agency#.assessment_assign a ON a.Parent_Assmt_ID = c.Assmt_ID AND ( (a.Visit_Type LIKE '%PT%' AND c.Skill = 'PT') OR (a.Visit_Type LIKE '%OT%' AND c.Skill = 'OT') OR (a.Visit_Type LIKE '%SN%' AND c.Skill = 'SN') ) JOIN #Request.prefix_db_lookup#.pEmployee e ON e.Emp_ID = a.Emp_ID JOIN #Request.prefix_db_agency#.pPatients p ON p.Patient_ID = a.Patient_ID AND p.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pAssessments pA ON pA.Assmt_ID = a.Parent_Assmt_ID AND pA.Status = 0 WHERE (c.Item_ID IN (253,301,1052,297,2408,295,259,289,2316,779) OR c.Description LIKE '%wound care%') AND c.Notes IS NULL AND c.status = 0 AND c.Date_Create > AND c.Proc_QA IN (0,2) AND a.Emp_ID = GROUP BY c.Careplan_ID ORDER BY p.Pt_Last ASC, p.Pt_First ASC SELECT CommSub_Id, Subject FROM #Request.prefix_db_agency#.CommunicationSubjects WHERE Agency_Id = #session.AgencyId# AND active = 'Y' AND Subject like 'procedure requires correction' ORDER BY Subject

Procedures Require QA

Add Communication

Patient Name	Assessment	Procedure	Notes	Clinician	Date Ordered
#Pt_Last#, #Pt_First#	#Assessment_Reason_M0100# #DateFormat(Certification_Start, "mm/dd/yy")# - #DateFormat(Certification_End, "mm/dd/yy")#	#Description#	#Notes#	#Emp_Last#, #Emp_First#	#DateFormat(Order_Date, "mm/dd/yy")#

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 ( , , , , , ) 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 ( , , , , , )