Symptom Status with related Treatments
SELECT pt.*,pt.Patient_ID AS patientid,pg.Description as pgdecription FROM #Request.prefix_db_agency#.pProgress pg JOIN #Request.prefix_db_agency#.pAssessments a ON a.Assmt_ID = pg.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 #Request.prefix_db_agency#.pSchedules s ON s.Schedule_ID = pg.Schedule_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway path ON path.Item_ID = pg.Item_ID AND path.Type = 'symptom' WHERE ad.status = 0 AND pt.status = 0 AND a.status = 0 AND pg.status = 0 AND s.status = 0 AND pg.Item_ID != 0 GROUP BY pgdecription UNION SELECT patientid,Pt_Last,Pt_First,Loc_ID FROM getdecription GROUP BY patientid,Pt_Last,Pt_First,Loc_ID


SELECT * FROM #Request.prefix_db_agency#.pProgress pg JOIN #Request.prefix_db_agency#.pAssessments a ON a.Assmt_ID = pg.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 #Request.prefix_db_agency#.pSchedules s ON s.Schedule_ID = pg.Schedule_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway path ON path.Item_ID = pg.Item_ID AND path.Type = 'symptom' WHERE ad.status = 0 AND pt.status = 0 AND a.status = 0 AND pg.Description = AND pt.Patient_ID = AND pg.status = 0 AND s.status = 0 AND pg.Item_ID != 0 GROUP BY pg.Progress_ID SELECT * FROM #Request.prefix_db_agency#.pProgress pg WHERE pg.Assmt_ID = '#Assmt_ID#' AND pg.Schedule_ID = '#Schedule_ID#' AND pg.status = 0 AND pg.Type IN ('procedure','teach') SELECT * FROM #Request.prefix_db_agency#.pPtmeds JOIN #Request.prefix_db_lookup#.meds_pathway_lookup ON pPtmeds.Drug_ID = meds_pathway_lookup.Trade_Num WHERE meds_pathway_lookup.Path_ID = '#Pathway_ID#' AND pPtmeds.Patient_ID = #Patient_ID# AND (Approved IS NULL OR Approved = 'Yes') AND pPtmeds.Status = 0 GROUP BY pPtmeds.Drug_ID SELECT p2.* FROM pPathway p1 JOIN pPathway p2 ON p1.Pathway_ID = p2.Pathway_ID WHERE p1.Item_ID IN (#Item_ID# ) AND p2.Type_Order IN (2,3) GROUP BY p2.Item_ID ORDER BY p2.Type_Order ASC
Patient Date Problem Severity Medication Procedure & Teaching
#Pt_Last#, #Pt_First#
#F26#
#DateFormat(F178,"mm/dd/yyyy")# 		#DateFormat(Visit_Date,"mm/dd/yyyy")# #Description# #severity# #ValueList(getmeds.Drug_Name)# #Description#,