Outcomes By Symptom

Symptom Form

Patient :

Symptom :

checked='checked'> Ambulation checked='checked'> Bathing checked='checked'> Oral Medication Management checked='checked'> Pain checked='checked'> Shortness of Breath checked='checked'> Transferring

Outcomes By Symptom

SELECT DISTINCT p.Patient_Id, p.Last_Name_M0040, p.First_Name_M0040 ,at.Assessment_Type ,si.Visit_Date, si.Visit_Type ,IFNULL(pvd.Severity,0) as Severity FROM #Request.prefix_db_lookup#.Agency a, #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Assessment_New an, #Request.prefix_db_agency#.assessment_Tracker at, #Request.prefix_db_agency#.ScheduleItems si, #Request.prefix_db_agency#.Pathway_Details pd, #Request.prefix_db_agency#.PatientVisitDetails pvd WHERE a.Agency_Id = '#session.AgencyId#' AND p.Agency_Id = a.Agency_Id AND p.Patient_Id = '#form.patientId#' AND an.Patient_Id = p.Patient_Id AND at.Assessment_Id = an.Assessment_Id AND si.Assessment_Tracker_Id = at.Assessment_Tracker_Id AND si.Visit_Date >= #CreateODBCDate(form.df)# AND si.Visit_Date <= #CreateODBCDate(form.dt)# AND pd.Patient_Id = p.Patient_Id AND pd.Assessment_Id = si.Assessment_Id AND pd.Assessment_Tracker_Id = si.Assessment_Tracker_Id AND pd.Type = 'symptom' AND pd.Description LIKE '%#form.Symptom#%' AND pvd.Pathway_Details_Id = pd.Pathway_Details_Id ORDER BY p.Last_Name_M0040, p.First_Name_M0040, si.Visit_Date ASC

No data was found based on your search criteria.

Please try a different search.

Visit Date	Pain Level	Visit Type	Assessment Type
#DateFormat(getBySymptom.Visit_Date, 'mm/dd/yy')#	#getBySymptom.Severity#	#getBySymptom.Visit_Type#	#getBySymptom.Assessment_Type#