SELECT pPatients.Patient_ID, pPatients.Status, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pCMS4857.Order_ID, pCMS4857.Form_Type, pCMS4857.Date_Sent, pCMS4857.Certification_From, pCMS4857.Certification_To, pCMS4857.MD_Digital_Signature, pCMS4857.Date_Create, DATEDIFF(NOW(), pCMS4857.Date_Sent) AS age, pCMS4857.Order_description, pCMS4857.Form_Status, pCMS4857.Date_Received, pPhysicians.Phys_ID, pPhysicians.Phys_Last, pPhysicians.Phys_First, pEmployee.Emp_Last, pEmployee.Emp_First, COALESCE(assessment_assign.Emp_ID, 2) AS AssignedEmpID, latest_assmt.Assmt_ID, latest_assmt.F26 FROM ( SELECT pAssessments.Admit_ID, pAssessments.Assmt_ID, pAssessments.Patient_ID, pAssessments.F26 FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.Status = 0 WHERE pAssessments.Status = 0 AND (LEFT(pAssessments.F26, 1) = '1' OR LEFT(pAssessments.F26, 1) = '4') AND pAdmit.Admit_ID = ( SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = pAssessments.Patient_ID AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1 ) AND pAssessments.Assmt_ID IN ( SELECT ass.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments ass WHERE ass.Admit_ID = pAssessments.Admit_ID AND ass.Status = 0 AND (LEFT(ass.F26, 1) = '1' OR LEFT(ass.F26, 1) = '4') ORDER BY ass.F178 DESC, ass.Assmt_ID DESC ) ) AS latest_assmt JOIN #Request.prefix_db_agency#.pAdmit pAdmit ON pAdmit.Admit_ID = latest_assmt.Admit_ID AND pAdmit.Status = 0 JOIN #Request.prefix_db_agency#.pPatients pPatients ON pPatients.Patient_ID = latest_assmt.Patient_ID AND pPatients.Status < 2 JOIN #Request.prefix_db_agency#.pCMS4857 ON pCMS4857.Assmt_ID = latest_assmt.Assmt_ID AND pCMS4857.Status = 0 AND pCMS4857.Date_Sent IS NOT NULL AND pCMS4857.Date_Received IS NULL LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = latest_assmt.Assmt_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = assessment_assign.Emp_ID AND pEmployee.Status = 0 LEFT JOIN #Request.prefix_db_agency#.employee_auth ON pEmployee.Emp_ID = employee_auth.eaID LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ON pAdmit.Render_Phys_ID = pPhysicians.Phys_ID WHERE pPatients.Loc_ID = '#session.agencyid#' AND (pCMS4857.Form_Status IS NULL OR pCMS4857.Form_Status NOT IN ('Signed & Received via Fax','Signed & Received', 'E-Signed and Received')) AND COALESCE(assessment_assign.Emp_ID, 2) = GROUP BY pCMS4857.Order_ID ORDER BY pPatients.Pt_Last ASC, pCMS4857.Certification_To ASC

Unsigned Orders by physician

New Order

Patient	Form Type	Age	Certifying Physician	Order Description	Action
#PatientLast#, #PatientFirst# (ActiveInactive)	Form 487 Form 485 #DateFormat(Certification_From,"mm/dd/yyyy")# - #DateFormat(Certification_To,"mm/dd/yyyy")#	#age#	#Phys_Last#, #Phys_First#—	#Form_Status# on #DateFormat(Date_Sent, "mm/dd/yyyy hh:mm:ss")# #LEFT(Order_description,70)#...	Print Print 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 ( , , , , , ) 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 ( , , , , , )