9687387e-cb06-4e25-8505-380b7739418fMPNet11intrue8.5in0.25cmtrue2.5cm2.5cm2.5cm66ba2ddd-6546-4697-8557-c594ced0a75221cmProviderSystem.StringMonthSystem.Int32YearSystem.Int32LateSystem.Int32SeenSystem.Int32WaitSystem.Int32ConsultSystem.Int32MPNetSELECT Person.FirstName + ' ' + Person.LastName AS Provider, MONTH(Appointment.AppointStartDate) AS Month, YEAR(Appointment.AppointStartDate)
AS Year, AVG(DATEDIFF(mi, Appointment.AppointStartDate, Appointment.ArrivalTime)) AS Late, AVG(DATEDIFF(mi, Appointment.AppointStartDate,
Appointment.SeenTime)) AS Seen, AVG(DATEDIFF(mi, Appointment.ArrivalTime, Appointment.SeenTime)) AS Wait, AVG(DATEDIFF(mi,
Appointment.SeenTime, Appointment.DepartTime)) AS Consult
FROM Appointment INNER JOIN
Person ON Appointment.WithGUID = Person.PartyGUID
WHERE (Appointment.ArrivalTime IS NOT NULL) AND (Appointment.SeenTime IS NOT NULL) AND (Appointment.DepartTime IS NOT NULL) AND
(Appointment.AppointStartDate IS NOT NULL)
GROUP BY Person.FirstName + ' ' + Person.LastName, MONTH(Appointment.AppointStartDate), YEAR(Appointment.AppointStartDate)
HAVING (NOT (MONTH(Appointment.AppointStartDate) IS NULL)) AND (AVG(DATEDIFF(mi, Appointment.AppointStartDate, Appointment.ArrivalTime)) < 90 AND
AVG(DATEDIFF(mi, Appointment.AppointStartDate, Appointment.ArrivalTime)) > - 90) AND (AVG(DATEDIFF(mi, Appointment.AppointStartDate,
Appointment.SeenTime)) < 90 AND AVG(DATEDIFF(mi, Appointment.AppointStartDate, Appointment.SeenTime)) > - 90) AND (AVG(DATEDIFF(mi,
Appointment.ArrivalTime, Appointment.SeenTime)) < 90 AND AVG(DATEDIFF(mi, Appointment.ArrivalTime, Appointment.SeenTime)) > - 90) AND
(AVG(DATEDIFF(mi, Appointment.SeenTime, Appointment.DepartTime)) < 90 AND AVG(DATEDIFF(mi, Appointment.SeenTime, Appointment.DepartTime))
> - 90)
ORDER BY Person.FirstName + ' ' + Person.LastName, YEAR(Appointment.AppointStartDate), MONTH(Appointment.AppointStartDate)16.25cm1cmOutside0true5MPNettrue55Simple10Cylinder032.25cmPlaintrueOutside060truetruetrueColumn14.75cm=Fields!Provider.ValueDefault=AVG(Fields!Consult.Value)=INT(AVG(Fields!Consult.Value))true6pt
12.5cm0.25cmtextbox112.69841cm1true0.91429cmWait Times2cm2cm1.75cm2cmMPNet2.53968cm=Fields!Provider.Value=Fields!Provider.ValueAscendingtextbox111trueTotalProvider7true=Fields!Provider.Value2.53968cm=Fields!Year.Value=Fields!Year.ValueAscendingtextbox12trueTotalYear6true=Fields!Year.Value42cm0.53333cmtextbox7Difference between appointment time and arrival 11trueArrival textbox8Difference between appointment time and time seen10trueSeen textbox9Time from arrival until seen 9trueWaittextbox108trueConsult12.82936cmtextbox612true0.53333cmtextbox25true=INT(AVG(Fields!Late.Value))textbox34true=INT(AVG(Fields!Seen.Value))textbox43true=INT(AVG(Fields!Wait.Value))textbox52true=INT(AVG(Fields!Consult.Value))1.59999cm0.25cm43.75cmen-US2.5cm29.7cm