SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, pAssessments.Assmt_ID,pAssessments.* ,pAdmit.* FROM #Request.prefix_db_agency#.pAdmit JOIN #Request.prefix_db_agency#.pAssessments ON pAdmit.Admit_ID = pAssessments.Admit_ID JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAdmit.Patient_ID LEft OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pAssessments.Record_Created_By = pEmployee.Emp_ID WHERE pAssessments.status = 0 AND pPatients.Status < 1 AND pAdmit.Status = 0 GROUP BY pAdmit.Admit_ID ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pEmployee.Emp_Last ASC, pEmployee.Emp_First ASC
Case Management Report
SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_lookup#.pPathway ON pProblem.Path_ID = pPathway.Pathway_ID WHERE pProblem.status = 0 AND pProblem.Assmt_ID = #Assmt_ID# and pProblem.Answer NOT like '06%' AND pPathway.Header_No NOT IN (12,13) AND pPathway.Header_No = '#header_no#' AND pProblem.Description NOT like 'GG%' AND pProblem.M0_No NOT LIKE 'M102%' AND pProblem.Skill != 'HHA' AND pProblem.Description NOT like 'M18%' GROUP BY pProblem.Problem_ID
  Patient Admission Date Deficits Total Description
  #PatientLast#, #PatientFirst# #DateFormat(M0030_START_CARE_DT,"mm/dd/yyyy")# #headername# #getproblems.recordcount# #Description#-#Answer#