pm = CreateObject("Component", "Menu"); myArgument = 'careplan_review'; pm.MenuFunction(myArgument,#getP.Patient_Id#,'','','',''); request.pat = CreateObject("component","components.general.patients").init(); getadmit = request.pat.get_admissions(#session.cs.patientid#); SELECT p.*, pt.*,a.AutoAssmt_ID,a.Admit_ID,a.F26,a.F176, a.* FROM #Request.prefix_db_agency#.pProblem p JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Pathway_ID = p.Path_ID AND pPathway.Agency_ID IS NULL JOIN #Request.prefix_db_agency#.pAssessments a ON a.Assmt_ID = p.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients pt ON pt.Patient_ID = a.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit ad ON ad.Admit_ID = a.Admit_ID JOIN ( SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = '#session.cs.patientid#' AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1 ) AS latest_admit ON latest_admit.Admit_ID = a.Admit_ID WHERE ad.status = 0 AND pt.status < 2 AND a.status = 0 AND p.status = 0 AND pt.Patient_ID = '#session.cs.patientid#' AND a.Assmt_ID = "#form.Assmt_ID#" AND a.F26 like '1%' AND a.F25 = 1 GROUP BY p.Problem_ID,p.Assmt_ID ORDER BY p.Path_ID, p.Assmt_ID, pt.Pt_Last ASC, p.dx_order ASC SELECT pSchedules.* FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.status = 0 AND pSchedules.Followup_visit != 1 AND pSchedules.Emp_ID != 0 AND pSchedules.Missed = '0' AND pSchedules.patient_id = '#session.cs.patientid#' AND pSchedules.Assmt_ID IN (#assmt_ids#) GROUP BY pSchedules.Schedule_ID ORDER BY pSchedules.Visit_Date ASC SELECT p.* FROM #Request.prefix_db_agency#.pCareplan p WHERE p.status = 0 AND p.Assmt_ID IN (#assmt_ids#) AND p.Assmt_ID = 0 AND p.Skill NOT IN ('HHA') GROUP BY p.Careplan_ID SELECT pProgress.* FROM #Request.prefix_db_agency#.pProgress WHERE pProgress.status = 0 AND pProgress.Assmt_ID IN (#assmt_ids#) AND pProgress.Assmt_ID = 0 GROUP BY pProgress.Progress_ID SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Approved = 'Yes' AND Pathway_ID IN (#ValueList(GtDX.Path_ID)#) AND Pathway_ID = 0 SELECT a.* FROM #Request.prefix_db_agency#.pAssessments a JOIN #Request.prefix_db_agency#.pPatients pt ON pt.Patient_ID = a.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit ad ON ad.Admit_ID = a.Admit_ID WHERE ad.Status = 0 AND pt.Status < 2 AND a.Status = 0 AND pt.Patient_ID = '#session.cs.patientid#' AND a.F25 = 1 AND a.F26 LIKE '1%' ORDER BY a.F177 DESC SELECT po.Orphan_ID, po.Assmt_ID, po.Problem_ID, IFNULL(ps.Description, po.Problem) AS Symptom, po.Problem_Dx_ID, IFNULL(pd.Description, po.Diagnosis) AS Diagnosis, pd.Path_ID AS Dx_Path_ID, pd.Skill AS Dx_Skill, po.Paired, po.Date_Created AS Orphan_Date FROM #Request.prefix_db_agency#.pOrphan po LEFT JOIN #Request.prefix_db_agency#.pProblem ps ON ps.Problem_ID = po.Problem_ID LEFT JOIN #Request.prefix_db_agency#.pProblem pd ON pd.Problem_ID = po.Problem_Dx_ID WHERE po.Status = 0 AND po.Assmt_ID IN (#assmt_ids#) ORDER BY po.Assmt_ID, po.Problem_ID, po.Problem_Dx_ID SELECT mr.Orphan_ID, mr.Assmt_ID, mr.PtMeds_ID, mr.Drug_Name, mr.Med_Dx_ID, mr.Diagnosis, mr.Paired, mr.automatic_paired, mr.Date_Created AS Recon_Date, mr.Date_Created AS Recon_Change_Date, pm.Status AS MedStatus, pm.Record_Creation_Date FROM #Request.prefix_db_agency#.pMed_Recon mr LEFT JOIN #Request.prefix_db_agency#.pPtmeds pm ON pm.PtMeds_ID = mr.PtMeds_ID WHERE mr.Status = 0 AND mr.Assmt_ID IN (#assmt_ids#) ORDER BY mr.Assmt_ID, mr.Med_Dx_ID, mr.Drug_Name ASC SELECT DISTINCT cp.Careplan_ID, cp.Assmt_ID, cp.Description, cp.Type, cp.Status AS CareplanStatus, cp.Skill, cp.Date_Resolve, pw.Pathway_ID FROM #Request.prefix_db_agency#.pCareplan cp JOIN #Request.prefix_db_lookup#.pPathway pw ON pw.Item_ID = cp.Item_ID AND pw.Type = cp.Type AND pw.Agency_ID IS NULL WHERE cp.Status < 2 AND cp.Assmt_ID IN (#assmt_ids#) AND cp.Type IN ('procedure', 'goal') UNION SELECT DISTINCT cp.Careplan_ID, cp.Assmt_ID, cp.Description, cp.Type, cp.Status AS CareplanStatus, cp.Skill, cp.Date_Resolve, pwr.Pathway_ID FROM #Request.prefix_db_agency#.pCareplan cp JOIN #Request.prefix_db_lookup#.pPathwayReview pwr ON pwr.Item_ID = cp.Item_ID WHERE cp.Status < 2 AND cp.Assmt_ID IN (#assmt_ids#) AND cp.Type IN ('procedure', 'goal') AND (pwr.Patient_ID = '#session.cs.patientid#' OR pwr.Approved IS NULL) SELECT pr.Progress_ID, pr.Assmt_ID, pr.Careplan_ID, pr.Type, pr.YesOrNo, pr.Severity, ps.Visit_Date FROM #Request.prefix_db_agency#.pProgress pr LEFT JOIN #Request.prefix_db_agency#.pSchedules ps ON ps.Schedule_ID = pr.Schedule_ID WHERE pr.Status = 0 AND pr.Assmt_ID IN (#assmt_ids#) AND pr.Type IN ('procedure', 'goal') ORDER BY pr.Assmt_ID, pr.Careplan_ID, ps.Visit_Date DESC, pr.Progress_ID DESC

Careplan Review

SELECT MIN(Problem_ID) AS Problem_ID, Symptom FROM GetAllOrphanSymptoms WHERE Assmt_ID = '#current_assmt_id#' GROUP BY Symptom ORDER BY Symptom ASC SELECT Problem_Dx_ID, Diagnosis, MIN(Orphan_Date) AS Orphan_Date, MAX(Dx_Path_ID) AS Dx_Path_ID, MAX(Dx_Skill) AS Dx_Skill FROM GetAllOrphanSymptoms WHERE Assmt_ID = '#current_assmt_id#' AND Symptom = '#getSymptomsForAssmt.Symptom#' AND Paired = 'Y' GROUP BY Problem_Dx_ID, Diagnosis ORDER BY Orphan_Date ASC, Diagnosis ASC SELECT Drug_Name, MIN(Recon_Date) AS Recon_Date, MAX(MedStatus) AS MedStatus FROM GetAllMedRecon WHERE Assmt_ID = '#current_assmt_id#' AND Med_Dx_ID = '#getDxForSymptom.Problem_Dx_ID#' AND ( Paired = 'Y' OR automatic_paired = 'Y' OR automatic_paired = 1 ) GROUP BY Drug_Name ORDER BY Recon_Date ASC, Drug_Name ASC SELECT Careplan_ID, Description, Type, CareplanStatus, Date_Resolve FROM GetAllCareplanPathItems WHERE Assmt_ID = '#current_assmt_id#' AND Pathway_ID = '#getDxForSymptom.Dx_Path_ID#' AND Skill = '#getDxForSymptom.Dx_Skill#' ORDER BY Type ASC, Description ASC SELECT Careplan_ID, Description, CareplanStatus, Date_Resolve FROM getCareplansForDiagnosis WHERE Type = 'procedure' ORDER BY Description ASC SELECT Careplan_ID, Description, CareplanStatus, Date_Resolve FROM getCareplansForDiagnosis WHERE Type = 'goal' ORDER BY Description ASC SELECT Progress_ID, Visit_Date FROM GetAllCareplanProgress WHERE Assmt_ID = '#current_assmt_id#' AND Careplan_ID = '#getProceduresForDiagnosis.Careplan_ID#' ORDER BY Visit_Date DESC, Progress_ID DESC SELECT DisplayText, DisplayDate, StatusText, StatusClass FROM procedureRows ORDER BY SortDate ASC, SortText ASC SELECT Progress_ID, Visit_Date, YesOrNo FROM GetAllCareplanProgress WHERE Assmt_ID = '#current_assmt_id#' AND Careplan_ID = '#getGoalsForDiagnosis.Careplan_ID#' ORDER BY Visit_Date DESC, Progress_ID DESC SELECT DisplayText, DisplayDate, StatusText, StatusClass FROM goalRows ORDER BY SortDate ASC, SortText ASC

SYMPTOM / DIAGNOSIS / INTERVENTIONS	STATUS / % MET
#F26# #DateFormat(F177,"mm/dd/yyyy")# - #DateFormat(F178,"mm/dd/yyyy")#
No orphan symptoms found for this assessment.
#getSymptomsForAssmt.Symptom# #symptomRows.DisplayText#	#symptomRows.StatusText#