SELECT pPatients.Patient_ID, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle,pAssessments.F26, pAssessments.Assmt_ID, pAssessments.F177 AS Cert_Start, pAssessments.F178 AS Cert_End ,pAssessments.F180, pAssessments.F25 as Admission_Status,pAssessments.Admit_ID ,pAssessments.AutoAssmt_ID FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Patient_ID = pPatients.Patient_ID WHERE pPatients.Patient_ID = AND pAssessments.Assmt_ID = AND pPatients.status = AND pAssessments.status = SELECT pAssessments.F26,pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.Assmt_ID, pAssessments.F177 AS Cert_Start, pAssessments.F178 AS Cert_End ,pAssessments.F180, pAssessments.F25 AS Admission_Status FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = AND pAssessments.status = SELECT pSchedules.*, pSchedules.Skill AS Visit_Type, pSchedules.Skill, pSchedules.Paperwork, pSchedules.Travel, pSchedules.PtPayer_ID, pSchedules.Rev_ID, pSchedules.Visit_Date, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Assmt_ID, pSchedules.Notes From #Request.prefix_db_agency#.pSchedules Where pSchedules.Patient_ID = AND pSchedules.Assmt_ID = AND pSchedules.status < 1 SELECT * From Getschedule Where Schedule_ID = SELECT Emp_ID, Emp_Last, Emp_First FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = careplandash = CreateObject("Component", "pathway.careplan"); pgnotes = CreateObject("Component", "pathway.progressnotes"); getpatientgoal = pgnotes.getpatientpgnotes(#URL.AID#,'patient_goal',#skilltype#,#URL.SID#); getgoal = careplandash.getscareplan(#URL.AID#,'goal',#skilltype#,0); getstandingorder = pgnotes.getpatientpgnotes(#URL.AID#,'standing_order',#skilltype#,#URL.SID#); getproblem = careplandash.getproblems(#URL.AID#,#skilltype#,0,0,'0',1); problemcount = getproblem.recordcount; pathwaydash = CreateObject("Component", "pathway.pathway"); pwproc = pathwaydash.getspathway(0,'procedure',#URL.AID#,'M102',#skilltype#); pwteach = pathwaydash.getspathway(0,'teach',#URL.AID#,'M102',#skilltype#); pwgoal = pathwaydash.getspathway(0,'goal',#URL.AID#,'M102',#skilltype#); request.pat = CreateObject("component","components.general.patients").init(); GetMd = request.pat.medslist(#URL.ID#); SELECT pProgress.*,pPathway.*,pProgress.Type AS ptype, IFNULL(pPathway.Value,0) AS measurevalue, pCareplan.Param_Lo,pCareplan.Param_Hi ,pCareplan.Param_other,pCareplan.Date_Target,pCareplan.AutoCareplan_ID FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pProgress.Item_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules ON pProgress.Schedule_ID = pSchedules.Schedule_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pCareplan ON pCareplan.Careplan_ID = pProgress.Careplan_ID WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pSchedules.Skill = AND pProgress.Status = AND pCareplan.Status = GROUP BY pProgress.Progress_ID ORDER BY pPathway.Header_No , pPathway.Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = AND TRACK IS NOT NULL ORDER BY Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Header_No ,Order_ID ASC SELECT * FROM getpgnotes WHERE ptype = ORDER BY Header_No ,Order_ID ASC SELECT pPathway.*,pProblem.*, GROUP_CONCAT(RIGHT(dx_order, 2)) as order_ids FROM #Request.prefix_db_lookup#.pPathway INNER JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Path_ID = pPathway.Pathway_ID WHERE pProblem.Assmt_ID = AND status = AND pProblem.M0_No like 'M102%' AND pProblem.Skill = GROUP BY pProblem.Item_ID ORDER BY M0_No,Type_Order,pPathway.Order_ID ASC SELECT pProgress.*, pProblem.Oasis_Deficits,pProblem.Answer,pProblem.ques_id FROM #Request.prefix_db_agency#.pProgress LEFT OUTER JOIN #Request.prefix_db_agency#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProblem.status = 0 WHERE pProgress.Assmt_ID = AND pProgress.Schedule_ID = AND pProgress.Status = AND pProgress.type IN () AND pProgress.Item_ID NOT IN (SELECT Item_ID FROM #Request.prefix_db_lookup#.pPathway WHERE pPathway.Header = 'Vital Signs') GROUP BY pProgress.Progress_ID

#Getpat.Pt_Last# #Getpat.Pt_First#

#GetSched.Visit_Date# #GetSched.StartTime# - #GetSched.EndTime#

#GetSched.Visit_Type# #GetE.Emp_Last# #GetE.Emp_First#

Complaints this Visit

Assessment Results

SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Item_ID IN () AND Type = SELECT * FROM getpaths WHERE Item_ID = SELECT * FROM #Request.prefix_db_lookup#.pPhraseBank WHERE Item_ID = ORDER BY Order_ID DESC

SYMPTOM	Reading Or Severity	Notes	Physician Alerted
#thedescription#	#Value_1#	#Notes#	Yes No
#Description# #Answer#	#severity#	#Notes#	Yes No