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