10cmOutside0true00.25cmtrueOrthographic1510Real18MPNet=Fields!Age.Value2.25cmtrueOutside0truetruetrue3Area21.5cm=Fields!Year.Value=Fields!Year.ValueAscendingDefault=Sum(Fields!Count.Value * Fields!Cap.Value)=Fields!Visits.Valuetrue6pt1cmtextbox1024cmtrue0.74074cmRegular Patients textbox1112.5cmtrue0.91429cmCapitation Income by Age Groups1.02646cm1.25cm2cm0.25cm1.25cmtrueYear_19true=Fields!Year.Valuetextbox82trueTotal=Fields!Year.ValueDescending=Fields!Year.Value2.5cmtrueName_18true=Fields!Name.Valuetextbox91trueTotal=Fields!Name.ValueAscending=Fields!Name.Value1.5cmtrueAge7true=Fields!Age.Valuetextbox11trueTotal=VAL(LEFT(Fields!Age.Value,2))Ascending=Fields!Age.Value1.5cmtextbox126true=Fields!Sex.Value=Fields!Sex.ValueMONTH14true=MONTHNAME(Fields!MONTH.Value)textbox413trueTotal=Fields!MONTH.ValueAscending=Fields!MONTH.Value0.53333cmtrue0.53333cmtextbox512truePattextbox611trueVisittextbox1310trueCapMPNet57cm15.30291cm15true0.75cmtextbox25true=Sum(Fields!Count.Value)textbox34true=Sum(Fields!Visits.Value)3true=Sum(Fields!Cap.Value * Fields!Count.Value)59.56666cm7a5af233-aff7-4d13-92e0-08c3814735132.5cmSELECT Practitioner.FirstName + ' ' + Practitioner.LastName AS Name, CASE WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 0 AND
4 THEN ' 0-4' WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 5 AND 14 THEN '05-14' WHEN DATEDIFF(Year,
Person.DOB, GETDATE()) BETWEEN 15 AND 24 THEN '15-24' WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 25 AND
44 THEN '25-44' WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 45 AND 64 THEN '45-64' WHEN DATEDIFF(Year,
Person.DOB, GETDATE()) > 64 THEN '65+' ELSE ' No Age' END AS Age, CASE WHEN DATEDIFF(Year, Person.DOB, GETDATE())
BETWEEN 0 AND 4 AND Person.Sex = 'F' THEN 27.98 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 0 AND 4 AND
Person.Sex = 'M' THEN 29.77 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 5 AND 14 AND
Person.Sex = 'F' THEN 7.20 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 5 AND 14 AND
Person.Sex = 'M' THEN 6.83 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 15 AND 24 AND
Person.Sex = 'F' THEN 8.37 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 15 AND 24 AND
Person.Sex = 'M' THEN 8.37 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 25 AND 44 AND
Person.Sex = 'F' THEN 7.36 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 25 AND 44 AND
Person.Sex = 'M' THEN 4.76 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 45 AND 64 AND
Person.Sex = 'F' THEN 10.08 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 45 AND 64 AND
Person.Sex = 'M' THEN 10.08 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) > 64 AND
Person.Sex = 'F' THEN 17.37 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) > 64 AND Person.Sex = 'M' THEN 17.37 END AS Cap,
COUNT(DISTINCT Person.LastName + Person.FirstName + Record.ChartLabel) AS Count, YEAR(Appointment.AppointStartDate) AS Year,
MONTH(Appointment.AppointStartDate) AS MONTH, COUNT(Appointment.AppointStartDate) AS Visits, Person.Sex
FROM Person INNER JOIN
Record ON Person.PartyGUID = Record.SubjectGUID INNER JOIN
Person AS Practitioner ON Record.PreferredPractitionerGUID = Practitioner.PartyGUID INNER JOIN
Appointment ON Appointment.RefGUID = Person.PartyGUID AND NOT (Appointment.AppointStartDate IS NULL) AND
NOT (YEAR(Appointment.AppointStartDate) IS NULL)
WHERE (Record.ChartStatusID = 101366) AND (DATEDIFF(YEAR, Record.LastSeenDate, GETDATE()) < 4) AND (Person.Sex = 'M' OR
Person.Sex = 'F')
GROUP BY Practitioner.FirstName + ' ' + Practitioner.LastName, CASE WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 0 AND
4 THEN ' 0-4' WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 5 AND 14 THEN '05-14' WHEN DATEDIFF(Year, Person.DOB,
GETDATE()) BETWEEN 15 AND 24 THEN '15-24' WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 25 AND
44 THEN '25-44' WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 45 AND 64 THEN '45-64' WHEN DATEDIFF(Year,
Person.DOB, GETDATE()) > 64 THEN '65+' ELSE ' No Age' END, CASE WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN
0 AND 4 AND Person.Sex = 'F' THEN 27.98 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 0 AND 4 AND
Person.Sex = 'M' THEN 29.77 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 5 AND 14 AND
Person.Sex = 'F' THEN 7.20 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 5 AND 14 AND
Person.Sex = 'M' THEN 6.83 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 15 AND 24 AND
Person.Sex = 'F' THEN 8.37 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 15 AND 24 AND
Person.Sex = 'M' THEN 8.37 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 25 AND 44 AND
Person.Sex = 'F' THEN 7.36 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 25 AND 44 AND
Person.Sex = 'M' THEN 4.76 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 45 AND 64 AND
Person.Sex = 'F' THEN 10.08 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) BETWEEN 45 AND 64 AND
Person.Sex = 'M' THEN 10.08 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) > 64 AND
Person.Sex = 'F' THEN 17.37 WHEN DATEDIFF(Year, Person.DOB, GETDATE()) > 64 AND Person.Sex = 'M' THEN 17.37 END,
YEAR(Appointment.AppointStartDate), MONTH(Appointment.AppointStartDate), Person.Sex
ORDER BY Practitioner.FirstName + ' ' + Practitioner.LastName, Age, YearMPNetSystem.StringNameSystem.StringAgeSystem.DecimalCapSystem.Int32CountSystem.Int32YearSystem.Int32MONTHSystem.Int32VisitsSystem.StringSex26.25cm11inen-US2.5cm29.7cm