UPDATE #Request.prefix_db_agency#.pCareplan SET Order_ID = WHERE Assmt_ID = AND Other = AND status = SELECT patient.Patient_ID, patient.Pt_Last AS Last_Name, patient. Pt_First AS First_Name, patient.Pt_Middle AS Middle, pAssessments.F26 as Assessment_Reason,pAssessments.F176 as Date_Completed,pAssessments.* FROM #Request.prefix_db_agency#.patient JOIN #Request.prefix_db_agency#.pAssessments ON patient.Patient_ID = pAssessments.Patient_ID WHERE patient.Patient_Id = AND pAssessments.Assmt_ID = AND pAssessments.status = careplandash = CreateObject("Component", "careplan"); pgnotes = CreateObject("Component", "progressnotes"); getpatientgoal = pgnotes.getprogressnotesprint(#url.assessment_id#,'patient_goal',#url.skilltype#,#url.visit#); getgoal = careplandash.getscareplan(#url.assessment_id#,'goal',#url.skilltype#,0); getstandingorder = pgnotes.getprogressnotesprint(#url.assessment_id#,'standing_order',#url.skilltype#,#url.visit#); getproblem = careplandash.getproblems(#url.assessment_id#,#url.skilltype#,0,0,'0'); problemcount = getproblem.recordcount; getsymptom = pgnotes.getprogressnotessymptoms(#url.assessment_id#,'symptom',#url.skilltype#,#url.visit#); getprocedure = pgnotes.getprogressnotesprint(#url.assessment_id#,'procedure',#url.skilltype#,#url.visit#); getallteaching = pgnotes.getprogressnotessymptoms(#url.assessment_id#,'teach',#url.skilltype#,#url.visit#); getallgoals = pgnotes.getprogressnotessymptoms(#url.assessment_id#,'goal',#url.skilltype#,#url.visit#); pathwaydash = CreateObject("Component", "pathway"); getpathway = pathwaydash.getspathway(0,'symptom',#url.assessment_id#); SELECT * FROM #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail WHERE problems = AND total_visits = AND visit_no =
#GetPA.First_Name# #GetPA.Last_Name# #thereason# #DATEFORMAT(GetPA.Date_Completed,"mm/dd/yyyy")#
Visit #url.visit# Date __________


#getproblem["proborder_id"][i]# - #getproblem["Description"][i]# #getproblem["proborder_id"][j]# - #getproblem["Description"][j]#
No Diagnosis Found
STANDING ORDERS:
#standdsecription[i]#
 
#standdsecription[j]#
No Standing Orders Found
MET NOT MET Y N
PATIENT GOAL: #Description#: #metcheckboximage#  AGENCY GOALS FOR VISIT #url.visit#: SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID = AND Type= ORDER BY Type_Order,Order_ID ASC SELECT * FROM getallgoals WHERE Item_ID IN () #static_goals#
###diagnosis.proborder_id#: #goal_decription# None of goals Found for this diagnosis
No Goals Found
SELECT * FROM getpathway WHERE Item_ID IN () AND Item_ID != 0
#Ucase(symptomHeader[i])#
#symptomdsecription[i]# [#ListSort(orderid,"Numeric","asc",",")#]
(call if > #Param_Hi[i]# < #Param_Lo[i]# ) 		#yescheckboximage#
SELECT * FROM getpathway WHERE Item_ID IN () AND Item_ID != 0
#Ucase(symptomHeader[j])#
#symptomdsecription[j]# [#ListSort(orderid,"Numeric","asc",",")#]
(call if > #Param_Hi[j]# < #Param_Lo[j]# ) 		#yescheckboximage#
No symptoms Found
PROCEDURES:
#procdescription[i]#
 
#procdescription[j]#
None of Procedures Found
PATIENT RECALL FOR VISIT #url.visit#: SELECT * FROM #Request.prefix_db_lookup#.pPathway WHERE Pathway_ID = AND Type= ORDER BY Type_Order,Order_ID ASC SELECT * FROM getallteaching WHERE Item_ID IN () ###diagnosis.proborder_id#: TEACH caregiver #teach_decription# None of teachingplans Found for this diagnosis
None of goals Found