select s.Visit_Date 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 pv.Performed is not null
AND s.Visit_Type like '%Physical Therapy%'
AND (pv.Description like '%M1840%' or pv.Description like '%M1850%' or pv.Description like '%M1860%')
Group by s.ScheduleItems_ID
ORDER BY s.Visit_Date ASC
SELECT * FROM #Request.prefix_db_agency#.Assessment_New
where Assessment_ID = '#session.cs.assessment_id#'
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 '%Physical Therapy%'
AND pv.Description like '%#Description#%'
Group by s.Assessment_ID
#Descriptions.Response_Number#
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 '%Physical Therapy%'
AND pv.Description like '%#Description#%'
Group by s.ScheduleItems_ID
#Performed#
0
Total Average
SELECT ROUND(sum(pv.Response_Number)/3) as Response,pv.Skill FROM #Request.prefix_db_agency#.Pathway_Details pv
where pv.Assessment_ID = '#session.cs.assessment_id#'
AND (pv.Description like '%M1840%' or pv.Description like '%M1850%' or pv.Description like '%M1860%')
AND pv.Skill = 'PT'
AND (pv.Deleted <> 'Yes' OR pv.Deleted is null)
select Round(SUM(pv.Performed)/3) 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 '%Physical Therapy%'
AND (pv.Description like '%M1840%' or pv.Description like '%M1850%' or pv.Description like '%M1860%')
Group by s.ScheduleItems_ID