System.Data.DataSet/* Local Connection */2eefc33d-e42b-4867-a169-d4b1c366abddLastnameSystem.StringFirstnameSystem.StringAgeSystem.Int32nationalregistrationSystem.StringSexSystem.StringEthnicity1System.StringEthnicity2System.StringEthnicity3System.StringCVDRiskSystem.StringCVDEligibleSELECT DISTINCT Pe.Lastname
,Pe.Firstname
,dbo.GetAge(Pe.DOB, GetDate()) AS Age
,Pe.nationalregistration
,Pe.Sex
,sd1.Description AS Ethnicity1
,sd2.Description AS Ethnicity2
,sd3.Description AS Ethnicity3
,(
SELECT TOP 1 CASE
WHEN rd.Column5 IN (
'H'
,'-1'
,'101'
,'12C2.00'
,'> 20'
,'>20'
)
THEN '25'
ELSE rd.Column5
END
FROM Patients p
LEFT JOIN RecordData rd
ON rd.RecordGUID = p.RecordGUID
WHERE rd.usetypeid = 100026
AND rd.formattypeid = 100060
AND rd.Column1 = '100088'
AND rd.removeddate IS NULL
AND (
rd.Column5 IS NOT NULL
AND rd.Column5 <> ''
)
AND p.partyGuid = Pe.PartyGuid
ORDER BY rd.startdate DESC
) AS CVDRisk
FROM person Pe
INNER JOIN record r
ON Pe.partyguid = r.subjectguid
LEFT JOIN lookupngnet.dbo.zstaticdata sd1
ON sd1.staticdataid = EthnicityID1
LEFT JOIN lookupngnet.dbo.zstaticdata sd2
ON sd2.staticdataid = EthnicityID2
LEFT JOIN lookupngnet.dbo.zstaticdata sd3
ON sd3.staticdataid = EthnicityID3
WHERE r.ChartStatusId = '101366'
AND (
(dbo.GetAge(Pe.DOB, GetDate()) >= 55)
OR (
dbo.GetAge(Pe.DOB, GetDate()) >= 45
AND (Pe.Sex = 'M')
)
OR (
dbo.GetAge(Pe.DOB, GetDate()) >= 45
AND Pe.Sex = 'F'
AND (
dbo.getEthnicCode(Pe.EthnicityID1) LIKE '2%'
OR dbo.getEthnicCode(Pe.EthnicityID2) LIKE '2%'
OR dbo.getEthnicCode(Pe.EthnicityID3) LIKE '2%'
OR dbo.getEthnicCode(Pe.EthnicityID1) LIKE '3%'
OR dbo.getEthnicCode(Pe.EthnicityID2) LIKE '3%'
OR dbo.getEthnicCode(Pe.EthnicityID3) LIKE '3%'
OR dbo.getEthnicCode(Pe.EthnicityID1) LIKE '4%'
OR dbo.getEthnicCode(Pe.EthnicityID2) LIKE '4%'
OR dbo.getEthnicCode(Pe.EthnicityID3) LIKE '4%'
)
)
OR (
dbo.GetAge(Pe.DOB, GetDate()) >= 35
AND Pe.Sex = 'M'
AND (
dbo.getEthnicCode(Pe.EthnicityID1) LIKE '2%'
OR dbo.getEthnicCode(Pe.EthnicityID2) LIKE '2%'
OR dbo.getEthnicCode(Pe.EthnicityID3) LIKE '2%'
OR dbo.getEthnicCode(Pe.EthnicityID1) LIKE '3%'
OR dbo.getEthnicCode(Pe.EthnicityID2) LIKE '3%'
OR dbo.getEthnicCode(Pe.EthnicityID3) LIKE '3%'
OR dbo.getEthnicCode(Pe.EthnicityID1) LIKE '4%'
OR dbo.getEthnicCode(Pe.EthnicityID2) LIKE '4%'
OR dbo.getEthnicCode(Pe.EthnicityID3) LIKE '4%'
)
)
)
ORDER BY lastname
,firstname
CVDEligibleC:\Code\MyPractice\MP.MyPractice2.ReportViewer\CVDRiskReport\CVDEligible.xsdDataTable1FillGetDataDataTable1TableAdapter1.21342in1.28634in0.58842in1.30717in0.52592in0.98425in0.98425in0.98425in0.98425in0.23622intruetrueLastnameTextbox3#4c68a22pt2pt2pt2pttruetrueFirstNameTextbox32#4c68a22pt2pt2pt2pttruetrueAgeTextbox5#4c68a22pt2pt2pt2pttruetrueNHI NumberTextbox7#4c68a22pt2pt2pt2pttruetrueSexTextbox9#4c68a22pt2pt2pt2pttruetrueEthnicity 1Textbox11#4c68a22pt2pt2pt2pttruetrueEthnicity 2Textbox13#4c68a22pt2pt2pt2pttruetrueEthnicity 3Textbox15#4c68a22pt2pt2pt2pttruetrueCVDRiskTextbox16#4c68a22pt2pt2pt2pt0.23622intruetrue=Fields!Lastname.ValueLastname2pt2pt2pt2pttruetrue=Fields!Firstname.ValueFirstname12pt2pt2pt2pttruetrue=Fields!Age.ValueAge2pt2pt2pt2pttruetrue=Fields!nationalregistration.Valuenationalregistration2pt2pt2pt2pttruetrue=Fields!Sex.ValueSex2pt2pt2pt2pttruetrue=Fields!Ethnicity1.ValueEthnicity12pt2pt2pt2pttruetrue=Fields!Ethnicity2.ValueEthnicity22pt2pt2pt2pttruetrue=Fields!Ethnicity3.ValueEthnicity32pt2pt2pt2pttruetrue=Fields!CVDRisk.ValueCVDRisk2pt2pt2pt2ptAfterCVDEligible=CStr(Fields!CVDRisk.Value)LessThan017.37405cm0.37103cm1.2cm22.5cmtruetruePatients Eligible for CVD ScreeningTextbox180.44133cm0.37103cm0.86395cm22.50001cm1#4c68a22pt2pt2pt2pttruetruePatients who are eligible for CVD Screening with no CVD risk recorded yet. Criteria :Female patients : 1. Ethnicities Maori,Pacific Islander or Asian aged above 45 2. Others aged above 55Male patients : 1. Ethnicities Maori,Pacific Islander or Asian aged above 35 2. Others aged above 45Textbox141.48167cm0.37103cm3.54542cm22.50001cm22pt2pt2pt2pt=Count(Fields!CVDRisk.Value)truetrueOutputCVD Risk RecordedShapePrimaryPrimaryBlack0pt=CountRows()-Count(Fields!CVDRisk.Value)truetrueOutputNo CVD Risk RecordedShapePrimaryPrimaryBlack0pt
Axis Title
False0.5NaNNaNNaN
Axis Title
False0.5NaNOppositeNaNNaN
Axis Title
0.5NaNNaNNaN
Axis Title
0.5NaNOppositeNaNNaN
BlackBlack
CVD Risk Recorded
BrightPastel
No Data Available
CVDEligible5.37987cm0.37103cm5cm11.16419cm3WhiteNone=IIf(CInt(Fields!CVDRisk.Value) > 25,25,CInt(Fields!CVDRisk.Value)-(CInt(Fields!CVDRisk.Value) Mod 5))=CInt(Fields!CVDRisk.Value)=Count(Fields!CVDRisk.Value)OutputPrimaryPrimaryBlack0pt
CVD Risk Value
1False0.5NaN0NaN
Axis Title
False0.5NaNOppositeNaNNaN
CVD Count
0.5NaNNaNNaN
Axis Title
0.5NaNOppositeNaNNaN
Recorded CVD Risk Count
BrightPastel
No Data Available
CVDEligible5.37987cm12.51479cm5cm10.35625cm4WhiteNone=IIf(CInt(Fields!CVDRisk.Value) > 25,25,CInt(Fields!CVDRisk.Value)-(CInt(Fields!CVDRisk.Value) Mod 5))=IIf(CInt(Fields!CVDRisk.Value) > 25,25,CInt(Fields!CVDRisk.Value)-(CInt(Fields!CVDRisk.Value) Mod 5))=IIf(CInt(Fields!CVDRisk.Value) > 25,25,CInt(Fields!CVDRisk.Value)-(CInt(Fields!CVDRisk.Value) Mod 5))=Count(Fields!CVDRisk.Value)trueOutput=">= "+IIf(CInt(Fields!CVDRisk.Value) = 25,"25",CStr(CInt(Fields!CVDRisk.Value)-(CInt(Fields!CVDRisk.Value) Mod 5)))ShapePrimaryPrimaryBlack0pt
Axis Title
False0.5NaNNaNNaN
Axis Title
False0.5NaNOppositeNaNNaN
Axis Title
0.5NaNNaNNaN
Axis Title
0.5NaNOppositeNaNNaN
CVD Risk Groups
BlackBlack
Recorded CVD Risk Count
BrightPastel
No Data Available
CVDEligible10.81299cm0.37103cm5cm11.16419cm5WhiteNonetruetrueEligible Patients who does not have CVD Risk recordedTextbox116.59766cm0.37103cm0.6cm22.5cm62pt2pt2pt2pt1.21342in1.28634in0.58842in1.30717in0.52592in0.98425in0.98425in0.98425in0.98425in0.23622intruetrueLastnameTextbox3#4c68a22pt2pt2pt2pttruetrueFirstNameTextbox34#4c68a22pt2pt2pt2pttruetrueAgeTextbox5#4c68a22pt2pt2pt2pttruetrueNHI NumberTextbox7#4c68a22pt2pt2pt2pttruetrueSexTextbox9#4c68a22pt2pt2pt2pttruetrueEthnicity 1Textbox11#4c68a22pt2pt2pt2pttruetrueEthnicity 2Textbox13#4c68a22pt2pt2pt2pttruetrueEthnicity 3Textbox15#4c68a22pt2pt2pt2pttruetrueCVDRiskTextbox16#4c68a22pt2pt2pt2pt0.23622intruetrue=Fields!Lastname.ValueLastname2pt2pt2pt2pttruetrue=Fields!Firstname.ValueFirstname32pt2pt2pt2pttruetrue=Fields!Age.ValueAge2pt2pt2pt2pttruetrue=Fields!nationalregistration.Valuenationalregistration2pt2pt2pt2pttruetrue=Fields!Sex.ValueSex2pt2pt2pt2pttruetrue=Fields!Ethnicity1.ValueEthnicity12pt2pt2pt2pttruetrue=Fields!Ethnicity2.ValueEthnicity22pt2pt2pt2pttruetrue=Fields!Ethnicity3.ValueEthnicity32pt2pt2pt2pttruetrue=Fields!CVDRisk.ValueCVDRisk2pt2pt2pt2ptAfterCVDEligible=CStr(Fields!CVDRisk.Value)GreaterThanOrEqual019.83467cm0.37103cm1.2cm22.5cm7truetrueEligible Patients who currently have CVD Risk recordedTextbox119.16412cm0.37104cm0.6cm22.5cm82pt2pt2pt2pt8.41678in12.40776in29.7cm21cm2cm2cm2cm2cm0.13cmd0f9f4fc-abd7-4e98-b7db-1e0a22e8cf11Cm