SELECT * FROM #Request.prefix_db_agency#.Pathway_Details pv Right outer join #Request.prefix_db_agency#.ScheduleItems s on s.Assessment_ID = pv.Assessment_ID where pv.Assessment_ID = '#session.cs.assessment_id#' AND s.Visit_Type like '%Occupational Therapy%' AND pv.Description like '%#Description#%' Group by s.Assessment_ID SELECT Round((sum(pv.Performed)/count(pv.Performed))) as Performed FROM #Request.prefix_db_agency#.PatientVisitDetails pv Right outer join #Request.prefix_db_agency#.ScheduleItems s on s.ScheduleItems_ID = pv.ScheduleItems_ID where pv.Assessment_ID = '#session.cs.assessment_id#' AND s.Visit_Type like '%Occupational Therapy%' AND pv.Description like '%#Description#%' Group by s.ScheduleItems_ID

	SOC #DateFormat(get_SOC.Start_of_Care_M0030,"mm-dd-yy")#	#DateFormat(Visit_Date,'mm-dd-yy')#
#Question#	#Descriptions.Response_Number#	#Performed#	0

SELECT ROUND(sum(pv.Response_Number)/2) as Response,pv.Skill FROM #Request.prefix_db_agency#.Pathway_Details pv where pv.Assessment_ID = '#session.cs.assessment_id#' AND (pv.Description like '%M1830%' or pv.Description like '%M1845%') AND pv.Skill = 'OT' AND (pv.Deleted <> 'Yes' OR pv.Deleted is null) select Round(SUM(pv.Performed)/2) as performed_total from #Request.prefix_db_agency#.PatientVisitDetails pv Right outer join #Request.prefix_db_agency#.ScheduleItems s on s.ScheduleItems_ID = pv.ScheduleItems_ID where pv.Assessment_ID = '#session.cs.assessment_id#' AND s.Visit_Type like '%Occupational Therapy%' AND (pv.Description like '%M1830%' or pv.Description like '%M1845%') Group by s.ScheduleItems_ID

Total Average

#OT_Total.Response#%   #Trim(DollarFormat(Homebound_status))#

#performed_total#%0%