SELECT pAssessments.Patient_ID, pAssessments.F26, pAdmit.M0030_START_CARE_DT, pAssessments.F177, pAssessments.Assmt_ID,pAssessments.Assmt_ID,pAssessments.Admit_ID,pAssessments.F178, pAssessments.F176, pAssessments.F177, pAssessments.F197, pAssessments.F25,pAssessments.F175, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pPatients.Pt_Gender, pPatients.Pt_DOB, pPatients.Pt_Zip, pSchedules.Visit_Type,pEmployee.Emp_Last,pEmployee.Emp_First, pPayer.Pay_Name, pPayer.GL_Account FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAssessments on pPatients.Patient_ID = pAssessments.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit on pAssessments.Admit_ID = pAdmit.Admit_ID JOIN ( SELECT Patient_ID, MAX(Admit_ID) AS Latest_Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Status = 0 GROUP BY Patient_ID ) AS LatestAdmit ON pAdmit.Admit_ID = LatestAdmit.Latest_Admit_ID JOIN #Request.prefix_db_agency#.pPtPayer on pPatients.Patient_ID = pPtPayer.Patient_ID JOIN #Request.prefix_db_agency#.pPayer on pPtPayer.Payer_ID = pPayer.Pay_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules on pPatients.Patient_ID = pSchedules.Patient_ID AND pSchedules.status= 0 AND M0030_START_CARE_DT = pSchedules.Visit_Date AND pSchedules.Visit_Type like '1%' LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID WHERE pPatients.Status < 2 AND pAssessments.Status = 0 AND pAssessments.F25 = 1 AND pPtPayer.Status = 0 AND pPayer.Status = 0 AND pAdmit.Status = 0 AND pAssessments.F26 like '#reason#' AND pAssessments.F177 <> '0000-00-00' AND pAssessments.F178 <> '0000-00-00' AND ((pAssessments.F176 between '#dateformat(Form.From_Date,'yyyy-mm-dd')#' AND '#dateformat(Form.To_Date,'yyyy-mm-dd')#')) AND ((pAssessments.F176 between '#dateformat(ParseDatetime(Form.From_Date),'yyyy-mm-dd')#' AND '#dateformat(ParseDatetime(Form.To_Date),'yyyy-mm-dd')#')) GROUP BY pAssessments.Assmt_ID ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pAssessments.F177 DESC SELECT pProblem.*,pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pProblem.Assmt_ID AND pAssessments.Status = 0 WHERE pProblem.Status = 0 AND pProblem.M0_No like 'M102%' AND pAssessments.Admit_ID IN (#ValueList(Assessments.Admit_ID)#) ORDER BY dx_order,RIGHT(M0_No, 1) ASC
Assessment Types Report #Form.From_Date# to #Form.To_Date#
Assessment Types Report #Form.From_Date# to #Form.To_Date#
&From_Date=#Form.From_Date#&To_Date=#Form.To_Date#&M0100=#Form.M0100#">
SELECT * FROM getproblems WHERE Admit_ID = #Admit_ID#
Name Type Completed Payer Status Elapsed
since SOC		 Employee Diagnosis List Notes
#PatientLast#, #PatientFirst# #F26# #DateFormat(F176,"mm/dd/yyyy")# #Pay_Name# completedin progress transmitted not transmitted #NumDays# #Visit_Type# created by #Emp_First#, #Emp_Last# #Description#
 #F175#
TOTAL #Assessments.recordcount#