Standard Jet DBnb` Ugr@?~1y0̝cßFN(`7ߜh(-`{6[߱oCa43y[<.|*|=X}Kf_Љ$g'DeFx -bT4.0dv YaS aa Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeniYYIdParentIdName        OYBS`Y Y Y  Y 2ACMFInheritableObjectIdSID YObjectId YISIY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/ @ ! @H \H @    @@@@ @@@   @@ Si`LQbxJmWYbQ2F6Si`Md`f^YJbMQMJ^Mo^JmYdbkoLSdi`WQJ^mWSJMY^YmvfJmYQbmSdi`x^dd\ofmiQJm`QbmMQbmiQkoLSdi`MJ^Mo^JmYdbkiQfLQbxJmWYbQfQbYMY^^YbiQfdimiQfLQbxJmWYbQfQbYMY^^YbiQfdimWQJ^mWSJMY^YmviQfMJkQkiQUYkmQiQOiQfOQJmWkiQfOQbmJ^JffmkiQfQMWdMJiOYdUiJ`JffmkiQf`QOYMJ^kfQMYJ^YkmJffmkiQffQiMQbmsYmWF6di`diQMd`f^YJbMQiQffiYdiYmv^YkmiQfkQMdbOJivfidfWv^JuYk^YkmmiQJm`QbmMQbmiQ iQfkoiUQivJffmk!iQfmiQJm`QbmMQbmiQ^Ykm"JomdQuQM#M^dkQMd`f^YJbMQ$M^dkQfJmYQbmSdi`%M^dkQmiQJm`QbmMQbmiQQOYm&SYbOiQMdiO'dfQbmiQJm`QbmMQbmiQQOYm(JO`Yb)OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MQmWbYMYmv+kh+MQmWbYMYmvkoLSdi`+kh+MSi`YO+kh+MJdimYM+kh+MSi`YO+kh+MJiS8LJkYk+kh+MSi`YO+kh+MMJokQdSOQJmW+kh+MSi`YO+kh+MMWY^O8DF+kh+MSi`YO+kh+MMo`o^JmYqQOYJUbdkYk+kh+MSi`YO+kh+MSi`iQqYQskoLSdi`8+kh+MSi`YO+kh+M`YmiJ^+kh+MSi`YO+kh+Mfo^`dbJiv+kh+MSi`YO+kh+MiWO8LJkYk +kh+MSi`YO+kh+MmiQJm`QbmMQbmiQ +kh+MSi`YO+kh+MmiYMokfYO +kh+MSi`LQbxJmWYbQ2F6+kh+Md^QobLdobO6 +kh+MWQJ^mWSJMY^Ymv+kh+Mx^dd\ofmiQJm`QbmMQbmiQkoLSdi` +kh+MbQsfJmYQbmYbSdi`JmYdb+kh+MMoiiQbmOYJUbdkYk+kh+MbQsfJmYQbmYbSdi`JmYdb+kh+MmiQJm`QbmMQbmiQ8+kh+MbQsfJmYQbmYbSdi`JmYdb+kh+MmiQJm`QbmMQbmiQ:+kh+MfJmYQbmSdi`+kh+MJiSSdobOLv+kh+MfJmYQbmSdi`+kh+MMJokQdSOQJmW+kh+MfJmYQbmSdi`+kh+MOYJUbdkYkkoLSdi`+kh+MfJmYQbmSdi`+kh+MSi`Md`f^YJbMQMJ^Mo^JmYdbkoLSdi`+kh+MfJmYQbmSdi`+kh+M^dMJ^WQJ^mWSJMY^Ymv+kh+MfJmYQbmSdi`+kh+MiWOSdobOLv+kh+MfJmYQbmSdi`+kh+MkoiUQivkoLSdi`+kh+MfJmYQbmSdi`+kh+MmLiQqYQsiQko^mkkoLSdi`+kh+Mf^JMQdSkoiUQiv+kh+Mf^JMQdSkoiUQivkoLSdi`+kh+MxxxmiQJm`QbmMQbmiQ+kh+Mx^dd\ofmiQJm`QbmMQbmiQkoLSdi`+kh+OiQfLQbxJmWYbQfQbYMY^^YbiQfdim+kh+O^dMJ^miQJm`QbmMQbmiQ+kh+SfJmYQbmSdi`Oof^YMJmQiQMdiOk`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkY`QuMd^o`bk`kvkY`QukfQMk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhivLQbxJmWYbQfQbYMY^^YbiQfdimhivLQbxJmWYbQfQbYMY^^YbiQfdimWQJ^mWSJMY^YmvhivMJkQkiQUYkmQiQOhivMd`f^YJbMQJqQiJUQLvvQJihivMd`f^YJbMQMJ^Mo^JmYdb hivOQJmWk hivOQbmJ^Jffmk hivQMWdMJiOYdUiJ`Jffmk hivWQJ^mWSJMY^Ymv^Ykm hiv`QOYMJ^kfQMYJ^YkmJffmkhivbo`Md`f^LvvQJihivfiYdiYmv^YkmhivkQMdbOJivfidfWv^JuYk^YkmWQJ^mWSJMY^YmvhivkoiUQivJffmkhivmdmJ^iQMJbvYb[LvvQJimL^Md`f^YJbMQmL^fJmYQbmSdi`x^dd\ofJiSOYJUbdkYkx^dd\ofMJokQdSOQJmWx^dd\ofWQJ^mWSJMY^Ymvx^dd\ofiWOOYJUbdkYkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO  @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"#$%&'()*+ , - . / 0123456789:;<=>?@ABCD E F G H IJKLMNWY^bmqvz| @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP        !!!" "!"""##$#%#&#'$($)$*$+%,%-%.%/&0&1&2&3'4'5'6'7(8(9(:(;)<)=)>)?*@***++++,,, , - - - -....////0000111122 2!2"3#3$3%3&4'4(4)4*5+5,5-5.6/60616273747576878889999::: : ; ; ; ;<<<<====>>>>???@9@:@;A<AABBBCCCDD D E E E FFFGGGHHHIIIJJJKKKL L!L"M#M$M%N&N'N(012&'345678 !W2W3W4Y"Y#Y$Y%^(^)^*^+b,b-b.b/m)m*m+q,q-q.v/v0v1z5z6z7|8|9|:  !"# l9gEe*h"####$$ $ $ % %%% &&&&&&''''(((((() )")#)!*$*&*'*%+(+*+++),,,.,/,--0-2-3-1.4.6.7.8. 9.5/:/0@0A0?1B1D1E1C2F2H2I2G3J3L3M3K4N4P4Q4O5R5T5U5V5W5S6X6Z6[666Y7777888 89 9 9 999 ::::::;;;;<<<<== =!=>">$>%>#?&?(?)?*?+?,?-?.?/?0?1? 2?'@3@5@6@7@8@9@:@;@<@=@>@ ?@@@A@4ABADAEAFAGAHAIAJAKALAMA eAeAeACBeBeBeBeBeBe Be Be Be Be BeBeB eBeBeCeCeCeCeCeCeCeC eCeDeDeDeDeDe De!De"DeEe#Ee%Ee&Ee'Ee(Ee)Ee$C   e*d _ Z g  ~K O [ mHk8DNJDjY!! /Tu@/Tu@Admin***********  /Tu@/T! s@+@Admin@8,,,,,,,,,*  2@2@Open Treatment Centre EditVVVVVVVVVVT W$@W$@Find Record88888888886 (r@(r@Close Treatment Centre EditXXXXXXXXXXV ;9W$@;9W$@Close Patient FormFFFFFFFFFFD xV$@xV$@Close ComplianceBBBBBBBBBB@ TU$@TU$@AutoExec22222222220 Q)@Q)@repTreatmentCentreList~@ZZZNNNNNNNL @Л8@Л8@repSurgeryAppts@LLL@@@@@@@> @<+)@<+)@repPriorityList(@LLL@@@@@@@> @nh@nh@repPercentWith80%orMoreCompliance~@pppdddddddb @Ŋ8@Ŋ8@repMedicalSpecialistApptsF@```TTTTTTTR @@ @@ @repEchocardiogramAppts8@ZZZNNNNNNNL @Tj@Tj@repDentalAppts@JJJ>>>>>>>< @[)@[)@repDeaths(@@@@44444442 @Q7x7@Q7x7@repCasesRegistered@RRRFFFFFFFD @D98@D98@repBenzathinePenicillinReport(Health Facility)δ@~~~~~~~| @dY-&@dY-&@Calculations::::::::::8  j@j@zlookup Treatment Centre subform@nnnbbbbbbb` @ b0@b0@PATIENT FORMh @FFF:::::::8 @ ` @` @HEALTH FACILITY@LLL@@@@@@@> @ 8ur@8ur@frmComplianceCalculation subformH@nnnbbbbbbb` @ `1g@`1g@frmBenzathine>80%~@PPPDDDDDDDB @ qѶ'@qѶ'@UserDefinedA@DDD88888886 @ qѶ'@qѶ'@SummaryInfod@DDD88888886 @'@'@SysRel.........., qѶ'@qѶ'@Scripts0000000000. qѶ'@qѶ'@Reports0000000000. '@'@Modules0000000000. qѶ'@qѶ'@Forms,,,,,,,,,,* '@'@DataAccessPages@@@@@@@@@@> +U'@+U'@MSysRelationshipsDDDDDDDDDDB +U'@+U'@MSysQueries88888888886 +U'@+U'@MSysACEs22222222220 +U'@+U'@MSysObjects88888888886 +U'@tC/&@MSysDb@:::......., @+U'@+U'@Relationships<<<<<<<<<<: +U'@+U'@Databases44444444442 +U'@+U'@Tables.........., ]OQN $ Mu K P LJ[ xtHFEK~C@>u@u@~sq_fPATIENT FORMBBBBBBBBBBB =JZo1g@JZo1g@~sq_drepBenzathinePenicillinReport~sq_dLocal Treatment Centre4MR2KeepLocal T @<'8@'8@~sq_czzzTREATMENT CENTRE~sq_czlookup Treatment Centre subform4MR2KeepLocal T @;ʠ@ʠ@~sq_cPLACE OF SURGERY~sq_cPlace of Surgery subform4MR2KeepLocal T @9(7@(7@~sq_cPATIENT FORM~sq_cSurgery subform4MR2KeepLocal Tlllllllj @82Tj@2Tj@~sq_cPATIENT FORM~sq_cRHD Found by4MR2KeepLocal Tfffffffd @62Tj@2Tj@~sq_cPATIENT FORM~sq_cfrmComplianceCalculation subform4MR2KeepLocal T @5(7@(7@~sq_cPATIENT FORM~sq_cDiagnosisSubform4MR2KeepLocal Tnnnnnnnl @32Tj@2Tj@~sq_cPATIENT FORM~sq_cARF Found by4MR2KeepLocal Tfffffffd @2 5̐@ 5̐@~sq_cnew Patient Information~sq_cTreatment Centre 24MR2KeepLocal T @0v̐@v̐@~sq_cnew Patient Information~sq_cCurrent Diagnosis4MR2KeepLocal T @/MnIOg@MnIOg@~sq_cHEALTH FACILITY~sq_czlookup Treatment Centre subform4MR2KeepLocal T @-kCv@kCv@~sq_cfrm ID~sq_cTricuspid4MR2KeepLocal TTTTTTTTR @,d7@d7@~sq_cfrm ID~sq_cTreatment Centre4MR2KeepLocal Tbbbbbbb` @ *֦v@֦v@~sq_cfrm ID~sq_cPulmonary4MR2KeepLocal TTTTTTTTR @)֦v@֦v@~sq_cfrm ID~sq_cMitral4MR2KeepLocal TNNNNNNNL @'/?h@/?h@~sq_cfrm ID~sq_cCumulative Diagnosis4MR2KeepLocal Tjjjjjjjh @&&Rp@&Rp@~sq_cfrm ID~sq_cChild1784MR2KeepLocal TRRRRRRRP @$0jo@0jo@~sq_cfrm ID~sq_cARF1 Basis4MR2KeepLocal TVVVVVVVT @#֦v@֦v@~sq_cfrm ID~sq_cAortic4MR2KeepLocal TNNNNNNNL @+\;y[= [ =  ^ @ "  ` B w -  k M / I+ i)X:jL `B$z\rT6sU76 uB G6uB__PID O6uB 6uB G5uB([__PID] = PID). '5uBPATIENT FORM@5) 75 uB G5uB__PID O5uB 5uB G4uBzlookup Cause of Death=== 4 uB G4uB 4uB G3uBzlookup ARFDiagnosis999 3 uB G3uB 3uB G2uBzlook-up Treatment CentreCCC 2 uB G2uB 2uB G1uBzlook-up Treatment CentreCCC 1 uB G1uB 1uB G0uBzlook-up Diagnosis555 0 uB G0uB 0uB G/uBV@ g/uBzlookup Health Facility??? /uB /uB G. uB[Year]% g.uBCountOfCompliance (%)Count([Compliance (%)])`;; o.uB[Year]% g.nuBqryBenzathine>80%333 .nuB .uB G-nuBzlookup Valve Severity=== - uB G-nuB -uB G,nuBzlookup Treatment CentreAAA , uB G,nuB ,uB G+nuBzlookup Found By111 + uB G+nuB +uB G*nuBzlookup Valve Severity=== * uB G*nuB *uB G)nuBzlookup Valve Severity=== ) uB G)nuB )uB G(nuB([__PID] = PID). '(nuBfrm ID@) 7( uB G(uB__PID O(nuB (uB G'nuBzlookup Diagnosis333 ' uB G'nuB 'uB G&nuB([__PID] = PID). '&nuBtbl Surgeryfrm ID33' & uB G&uB__PID O&nuB &uB G%nuBzlookup Cause of Death=== % uB G%nuB %uB G$nuBzlookup Found By111 $ uB G$nuB $uB G#nuBzlookup Valve Severity=== # uB G#nuB #uB G"[zlookup Ethnicity].Ethnicity< g"zlookup Ethnicity333 " " GLVAL V ZLlDateDiff("yyyy",[date of birth],[date of death])+Int(Format([date of death],"mmdd")<Format([date of birth],"mmdd"))DateDiff("yyyy",[date of birth],[registration date])+Int(Format([registration date],"mmdd")<Format([date of birth],"mmdd"))tblPatientForm.[Local Health Facility](((tblPatientForm.[Local Health Facility])=[Please enter name of Health Facility]) AND ((tblPatientForm.Medication)="Benzathine Penicillin G (3-weekly)" Or (tblPatientForm.Medication)="Benzathine Penicillin G (4-weekly)") AND ((tblPatientForm.[Date of Death]) Is Null))tblPatientForm.PID=qryComplianceCalculation.PIDtblPatientForm.[General Comments]qryComplianceCalculation.[Compliance (%)]tblPatientForm.[Local Health Facility](((tblPatientForm.Medication)="Benzathine Penicillin G (3-weekly)" Or (tblPatientForm.Medication)="Benzathine Penicillin G (4-weekly)") AND ((tblPatientForm.[Date of Death]) Is Null))tblPatientForm.PID=qryComplianceCalculation.PIDtblPatientForm.[General Comments]qryComplianceCalculation.[Compliance (%)]tblPatientForm.[Local Health Facility](((tblPatientForm.[Health Number]) In (SELECT [Health Number] FROM [tblPatientForm] As Tmp GROUP BY [Health Number] HAVING Count(*)>1 )))tblPatientForm.[Local Health Facility][zlookup Treatment Centre].[Treatment Centres][zlookup Place of Surgery].[Place of surgery]SELECT tblSurgery.PID, tblSurgery.Date, tblSurgery.Procedure, tblSurgery.[Place of Surgery] FROM tblSurgery; SELECT qryComplianceCalculation.PID, qryComplianceCalculation.Year, qryComplianceCalculation.[Injections Required (Jan-Dec)], qryComplianceCalculation.[Injections Received (Jan-Dec)], qryComplianceCalculation.[Compliance (%)] FROM qryComplianceCalculation; SELECT tblDiagnosis.PID, tblDiagnosis.Date, tblDiagnosis.Diagnosis, tblDiagnosis.[Found By] FROM tblDiagnosis; [zlookup Health Facility].[Health Facility]SELECT [tbl Review].PID, [tbl Review].[Review Date], [tbl Review].Basis, [tbl Review].Findings FROM [tbl Review]; /NeG)= y >  h -  y [ = k   m O 1  PQ'gq'vL jL.g(w-A B@ gA R@ gA  tblPatientForm.[Address/Phone]= gA tblPatientForm.PID1 gA qryComplianceCalculation.Year< gA L@ gA tblPatientForm.Name2 gA tblPatientForm.Name2 gA qryComplianceCalculationAAA A tblPatientForm--- A  A  G@ n@  '@ tblPatientFormqryComplianceCalculation^@ i]- @  tblPatientForm.Default5 g@ B@  g@ tblPatientForm.PID1 g@ R@  g@ qryComplianceCalculation.Year< g@  tblPatientForm.[Address/Phone]= g@ L@  g@ tblPatientForm.Name2 g@ tblPatientForm.Name2 g@ qryComplianceCalculationAAA @ tblPatientForm--- @  @  G? / tblPatientForm.[Health Number]= '?/@ '?/ tblPatientForm.[Address/Phone]= g?/L@ g?/tblPatientForm.Gender4 g?/ tblPatientForm.[Date of Birth]= g?/tblPatientForm.Name2 g?/ tblPatientForm.[Health Number]= g?/tblPatientForm--- ?/ G?/ G?/ ?/ G>/tblPatientForm--- > / G>/ >/ G=/zlookup Health Facility??? = / G=/ =/ G</\@ g</zlookup Treatment CentreAAA </ </ G;/Z@ g;/zlookup Place of SurgeryAAA ;/ ;/ G:/([__PID] = PID). ':/tbReviewResultsPATIENT FORMGG/ : / G:/__PID O:/ :/ G9([__PID] = PID). '9PATIENT FORM@5) 79  G9__PID O9 9 G8zlookup RHDDiagnosis999 8  G8 8 G7uBzlookup Health Facility??? 7 uB G7uB 7uB G6uB([__PID] = PID). '6uBPATIENT FORM@5) 7"!&0 F BM < L V RJ P Hbx';n%r+0jo@++0jo@0jo@~sq_cfrm ID~sq_cRHD1 Basis4MR2KeepLocal TVVVVVVVT @(@@~sq_cfrm ID~sq_cfrm Review subform14MR2KeepLocal Thhhhhhhf @%S?h@/?h@~sq_cfrm ID~sq_cCause of Death4MR2KeepLocal T^^^^^^^\ @"rW@rW@~sq_cETHNICITY~sq_c Ethnicity subform4MR2KeepLocal Tlllllllj @̊K@̊K@repSecondaryProphylaxisList(Treatment Centre)@|||||||z @?9ur@?9ur@repBenzathinePenicillinReport@hhh\\\\\\\Z @ \>@ u@AccessLayout4MR2KeepLocal T"@zz:::::::8 @| Ig@OGIg@zlookup RHDDiagnosisη@VVVJJJJJJJH @z< @PE @zlookup Health Facility@\\\PPPPPPPN @W"C@쒮7@zlookup Cause of Death-@ZZZNNNNNNNL @va3^g@=ӆIg@zlookup ARFDiagnosisί@VVVJJJJJJJH @qٶ-@m>Tj@tblPatientFormβ" JJJ>>>>>>>< @m5ur@K @KJy%@ju@qryPriorityList΃@|@XLL@@@@@@@> @JXh@ph@QryNumComplByYearY@|@\PPDDDDDDDB @I4 U8@Tj@qryMedicalSpecialistAppts΁@|@l``TTTTTTTR @Gq @=0'g@qryEchocardiogramApptsc@|@fZZNNNNNNNL @F>Tj@Tj@qryDentalApptsS@|@VJJ>>>>>>>< @E%@ ~/u@qryDeaths7@|@L@@44444442 @D7ur@[^ @qryComplianceCalculationE@|@j^^RRRRRRRP @CyJ@jE0g@qryComplianceAverageByYear(@|@nbbVVVVVVVT @B%7@Tu@qryCasesRegisteredK@|@^RRFFFFFFFD @@7ur@ /0g@qryBenzathinePenicillinReport@@thh\\\\\\\Z @bQ !@Q !@MSysIMEXSpecs<<<<<<<<<<: ^Q !@VQ !@MSysIMEXColumns@@@@@@@@@@> YF@F@MSysAccessXML4MR2KeepLocal  T|||<<<<<<<: @u@u@MSysAccessObjectsDDDDDDDDDDB ?U h@ȷ n{-*  !"#$%&'()+,km/0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijlpqrstuvwxyz{|}~Root Entry+ 9b1@VBAJj 9b1VBAProject Jj 9b1VBAJjqBdir_VBA_PROJECT 1CPROIMHMLOMTYDNLFNMMCAIHGDNK:GTZGKRFEJOTTTDILJKRKHCKGIJVF:  !"#$%&()*+,-./1268:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdehijklmoprstuvwxyz{|}~0* pH"dDTest<@j= B zJ J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.tlb#OLE AutomatiLon`hADODB> ADOBDDE1D10-8DAA006D2EA4D1DProgram Files\@CommonSM\ado\ms 21NMicrosoft ActiveX Data Objects 2.1 LibraryHDAO>DA[ Y25E0цY00-5O,'Shared\360.DL L# 3.6-, @*Form_HEALTH FACILI`TYG(Arm_HE7LT@ FACILT@Y@ GTZGKRFEJOTTTDILJKRKHCKGIJVF28AZGKREJ@LTT{UAJBKC@G@JV@ A@1B,3'X"B.+B8PATIENT FORMG *F7P4TEVN#8O(M6HZODSUDOFDUICEJRDKHWNCHIXDUG6HZ2DSU2O,D@ICMJ@D3HW@C1hIX@ UB6c !z@CalculisG@Caxcuazi`ns$CPROIMHMLOMTYDNLFNMMCAIHGDNKQ#CPO`!ME M@Err_Secondary_Prophylaxis_List__Treatment_Centre__Button_ClickY;(Exit_Secondary_Prophylaxis_List__TreatmeDeaths_Report_Button_ClickKErr_Deaths_Report_Button_ClickExit_Deaths_Report_Button_Click"Treatment_Centre_List_Button_Click &Err_Treatment_Centre_List_Button_Clicki+'Exit_Treatment_Centre_List_Button_ClickFind_Button_ClickErr_Find_Button_Clickc Exit_Find_Button_Click Add_New_Button_ClickGErr_Add_New_Button_ClickGPExit_Add_New_Button_ClickEchocardiogram_Due_Button_Click$#Err_Echocardiogram_Due_Button_Click$Exit_Echocardiogram_Due_Button_Click%&General_Specialist_Review_Button_Clickt*Err_General_Specialist_Review_Button_Click-(Exit_General_Specialist_Review_Button_ClɇHeart_Specialist_Button_ClickК!Err_Heart_Specialist_Button_Click&"Exit_Heart_Specialist_Button_Click"B Primary_Care_Doctor_Button_Click$Err_Primary_Care_Doctor_Button_Click%Exit_Primary_Care_Doctor_Button_ClickVSurgery_List_Button_ClickErr_Surgery_List_Button_Click6Exit_Surgery_List_Button_ClickASurgery_History_Button_Clicky Err_Surgery_History_Button_Clickk!Exit_Surgery_History_Button_Clickh Cardiac_Review_List_Button_Click$Err_Cardiac_Review_List_Button_ClickYk%Exit_Cardiac_Review_List_Button_Click@ Echocardiogram_List_Button_Click$Err_Echocardiogram_List_Button_Click[%Exit_Echocardiogram_List_Button_Click-Paediatrician_Clinic_Review_List_Button_Clickr1Err_Paediatrician_Clinic_Review_List_Button_Click|(Exit_Paediatrician_Clinic_Review_List_Buk)Physician_Clinic_Review_List_Button_Click -Err_Physician_Clinic_Review_List_Button_Click*(Exit_Physician_Clinic_Review_List_Button_*Physician_Clinic_Review_List_Button1_Clickb4.Err_Physician_Clinic_Review_List_Button1_Click7++Physician_Clinic_Review_List_Button21_Click,/Err_Physician_Clinic_Review_List_Button21_ClicktCompliance_Report_Button_Click"Err_Compliance_Report_Button_Clickx#Exit_Compliance_Report_Button_Clickqo1Compliance_Report__Treatment_Centre__Button_ClickH5Err_Compliance_Report__Treatment_Centre__Button_Click(Exit_Compliance_Report__Treatment_Centre%Medical_Secialist_Report_Button_Click)Err_Medical_Secialist_Report_Button_Clickd(Exit_Medical_Secialist_Report_Button_Cli8>!Heart_Secialist_List_Button_Click$%Err_Heart_Secialist_List_Button_Click^+&Exit_Heart_Secialist_List_Button_ClickʹDatabase_HELP_Button_ClickErr_Database_HELP_Button_ClickExit_Database_HELP_Button_ClickdATABASE_reports_BUTTON_Clickj4!Err_dATABASE_reports_BUTTON_Click6"Exit_dATABASE_reports_BUTTON_Click|DATABASE_REPORT_Button_ClickV Err_DATABASE_REPORT_Button_Click!Exit_DATABASE_REPORT_Button_ClickEBenzathien_Chart_Button_Click!Err_Benzathien_Chart_Button_Click"Exit_Benzathien_Chart_Button_ClickfH0Benzathine_Penicillin_Compliance__by_Year__Clicks4Err_Benzathine_Penicillin_Compliance__by_Year__Click(Exit_Benzathine_Penicillin_CoK[mpliance__bKReview_History_Button_Click$Err_Review_History_Button_Click#S Exit_Review_History_Button_Click1Compliance_Report__Health_Facility___button_Click|5Err_Compliance_Report__Health_Facility___button_ClickpG(Exit_Compliance_Report__Health_Facility_S) EchocardiogramAppts_Button_Click@$Err_EchocardiogramAppts_Button_Click%Exit_EchocardiogramAppts_Button_ClickPCDoctorAppts_Button_ClickjErr_PCDoctorAppts_Button_Click{Exit_PCDoctorAppts_Button_Click_#MedicalSpecialistAppts_Button_Click8'Err_MedicalSpecialistAppts_Button_ClickH(Exit_MedicalSpecialistAppts_Button_ClickSurgeryAppts_button_Click9Err_SurgeryAppts_button_ClickBExit_SurgeryAppts_button_Click̟!HeartSpecialistAppts_button_Click%Err_HeartSpecialistAppts_button_Click&Exit_HeartSpecialistAppts_button_ClickF} repBenzathineReport_button_Click@$Err_repBenzathineReport_button_Click%Exit_repBenzathineReport_button_Click*repBenzathine_HealthFacility__button_Clickt3.Err_repBenzathine_HealthFacility__button_Click9(Exit_repBenzathine_HealthFacility__butto,p!qryDuplicate_Records_button_Click %Err_qryDuplicate_Records_button_Click; OpenQueryacNormalacEditI&Exit_qryDuplicate_Records_button_ClicknHealth_Facility_button_Click Err_Health_Facility_button_Clickp!Exit_Health_Facility_button_Clickv Calculations DMedian97 TableName`  FieldNameCriteria7 Err_Mediandb\rs_ RecordsetstrSQLFRowCountu LowMedianx HighMedian݄ CurrentDbS IsMissing OpenRecordset| dbOpenDynaset MoveLast RecordCount{ MoveFirstNMove>y Exit_MedianNumber-Form FormHeader Detail2 PID_LabelRegistration_DateNRegistration_Date_LabelDisease_Severity_LabelGyFirst_Name_Label Date_of_Birth Date_of_Birth_LabelGender@ Gender_LabelO Health_NumberClinic_Hospital_Number_LabelqLocal_Health_Facilityn[Local_Treatment_Centre_Label 5PERSONAL_DETAILS_Label MedicationcMedication_Labelg Date_started[]Date_STARTED_Label[ Date_ceasedDate_CEASED_LabelBSECONDARY_PROPHYLAXIS_LebalGeneral_Comments NOTES_Label8Label458 Address_PhonefHome_Address_LabelDefaultLabel6241Text648 Label6911 Date_of_DeathtLabel701=!Cause_of_DeathzLabel703?!Box704 frmComplianceCalculation_subform,Label720!Label721! Find_ButtonAdd_New_ButtonLabel734!Label735! FormFooterTCases_Added_ButtonPriority_List_ButtonÍTreatment_Centre_List_Button4Secondary_Prophylaxis_List__Treatment_Centre__Button-Deaths_Report_Button Label724!Label725!Label726!Label727!Label728!Label730!Label731! EXIT_Button:]Label736!Warfarin*Label591Label597Label600Label754!Label758!Label760"Medical_Specialist_DateY^Echocardiogram_Date-r Surgery_Datel>EchocardiogramAppts_ButtonMedicalSpecialistAppts_ButtonYSurgeryAppts_buttonBLabel771@"Last_Surgery_DateLabel772A"Label774C"Label776E" ARF_Diagnosis* RHD_DiagnosisCurrent_Disease_State.Label778G"Label780d" ARF_Found_byA RHD_Found_byUZEchocardiogramuSURGERYLabel783g"Line7847repBenzathineReport_button_T$repBenzathine_HealthFacility__button0qryDuplicate_Records_buttonUVLabel788l"Label789m"Health_Facility_button Label791"ClickrepGraph80__buttonLabel792"repGraph80__button_ClickdErr_repGraph80__button_Click|Exit_repGraph80__button_Clickw*Label795" Dental_DatemrepDental_buttonLabel796"repDental_button_ClicktErr_repDental_button_ClickMExit_repDental_button_ClicklK[%   6=wWxME(<<< <XX+@ OOi`ii  % %``fiel``no r8HzJS B " *H Fx & < ,( FX D B @0 Bp  8   (08 $H p(2  ,8 h x    D ,Hhx  D 0 H`p x    (  (0@HP `x B@B Created by Roger J. Carlson !"# http://www.rogersaccesslibrary.com@ Terms of use: You may use this function in any application, but it must include this notice.D5Returns the median of a given field in a given table.%Returns -1 if no recordset is created@ You use this function much like the built-in Domain functions= (DLookUp, DMax, and so on). That is, you must provide the< 1) field name, 2) table name, and 3) a 'Where' Criteria.9 When used in an aggregate query, you MUST add each field; in the GROUP BY clause into the into the Where Criteria of this function.1 See Help for more on Domain Aggregate functions.]]]]](Open a recordset on the table.0 .SELECT  FROM  ' $  WHERE   ORDER BY  'd  ORDER BY  'k   %.%Find the number of rows in the table. B@ !' B@Determine Even or Odd  >There is an even number of records. Determine the low and high&values in the middle and average them.  B@ $' B@ $' Return Median   'd0>There is an odd number of records. Return the value exactly inK[ the middle.  B@ Return Median $'kclose recordset B@BzPH ! '( ! e"EOF or BOF ie no recordset created'd !"A@kijAttribute VB_Name = "Calculation@s" Op$ Compare Database Publi@c FuncNDMedian97@(TableAs Sng, _ Fie ld$+al Criteria _Vant)  '"eated by Roger J. Ca rlsonhttp://www.rsaccesslibrar y.comTerms of use: You may this f}in any app , ! it must in cludeno tice.'R@eturns e m9a gi`ven f l-1 if no re@cordse5s cr0]a=[&ch likA%e,ilt-3Doma7s2(DLookUp, DMax,<d so on)@. Tha, yAI;provi;'~1)D3n, 2) 2 and 3)9'WherepSCy@I' nA^dB[ggregx@ queryMUST add = `CB@Fir'Demine E UOddc 0 Mod 2@R0/'TAw `a8n e!h#V. g low"hN .'valuefmiddle@averagm`j%4$ Int(/a- 1 ]#(fO.- bı g'%(+l) #N)>o)ǂb& exactlyD'!-(&2_ c)Y rs~E/ PExitDN:'closeDSCqQ1PS[(0.N1= 3075(9 0s Resu 4? _21-.EOF p1B`iekw6wC r4-%?7MsgBox qDescri_qA1xME (SLS S<N0{996F37B9-C276-4818-BB8E-79692354C945}x h@%@@ "   (0 8@P Xhxh B@B000P|H@ !"A@-(o jAttribute VB_Name = "Form_HEALTH FACILITY" Bas0{996F37B9-C276-4818-BB8E-79692354C945} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT P&* Sub Closr_ton_Click() On Error Go=xd`l \ "    (0 8@P X" `h p   "    ( 0" 8@ HX x  "      "   08 @HX `" hp x   "    ( 08H P" X`  h K[x  "       "   "    " (0 8@ (Hp   "   (   8@ HP` h" px     "   (8 PX `hx "      "    @ X` hp  "   "   "       (" 08 @ *Hx   "   $  ( 0 8 H P " X ` h 6p        "    ( @ H P X h p " x           "    @ H P X h p " x         "     ( 0 8 @ P X " ` h p "x        "     ( @ H P X h p " x   "       "   K[  @ X` hp "      "   (  0P hp x "   $    (" 08 @ "Hp   "      (8 @" HP X `   "     ( 08H P" X` h p   "   .( @H PXh p" x  &   "   $ H `h px "      " ( 08 @` x  "     ( 0" 8@ H ,P   "   :( @H PXh p" x     "   .@ X` hp "      "   ( 0P hp x K[ "   "    (" 08 @ H` x  "      ( 0" 8@ H &Px   "   6 08 @HX `" hp x    "   ( @H PXh p"   *   " ( 0 8P hp x x(h B@B*P|H(@ !"A@*(o @. 2 B@0x4p|h.` !"A@4Ho@80 :!<B@> B D F B@@H|8 !"A@HoL :!<B@> B D F B@@N|xLp !"A@NXoPR@ B@TV(| R !"A@Vo@Z 2 B@0\|Z !"A@\o` :!<B@> B D F B@@bP|H`@ !"A@b(o f :!<B@> B D F B@@h|f !"A@hol B@Bn|xlp !"A@nXoP@r@ B@Tt(| r !"A@tooo ~]`]x Benzathine Penicillin Compliance'   B@p|h~` !"A@Ho@0]]Benzathine Pencillin Compliance'[PID]= "'   B@| !"A@o]@]XDATABASE TOOLS'   B@8|0( !"A@op] repTOTALSecondaryProphylaxisList'   B@| !"A@oxh] repDeaths'   B@(|  !"A@o ]`repCasesRegistered'   B@| !"A@xopxo`oP@]8repPriorityList'   B@| !"A@oP]!repPriorityList(Treatment Centre)'   B@h|`X K[ !"A@@o8(]repSecondaryProphylaxisList'   B@| !"A@o]@-repSecondaryProphylaxisList(Treatment Centre)'   B@8|0( !"A@oX] repDeaths'   B@| !"A@ox]repTreatmentCentreList'   B@0|(  !"A@o :!<B@> B D F B@@| !"A@oHx 2 B@0X|PH !"A@0o(]repEchocardiogramReview'   B@| !"A@o] repGeneralSpecialistReview'   B@@|80 !"A@o8 ]x repHeartSpecialistReview'   B@| !"A@o x] repPrimaryCareDoctorReview'   B@(|  !"A@o ]( repReviewSurgeryList'   B@| !"A@xop@ `] repSurgeryHistory'   B@| !"A@o ] repReviewCardiacTeamList'   B@| !"A@ho` P]0 repReviewEchocardiogramList'   B@|  !"A@oH ] repReviewPaediatricianList'   B@p|h` !"A@Ho@ 0] repReviewPhysicianList'   B@| !"A@o ]8 repReviewPhysicianList'   B@`|XP !"A@8o0P " ] repReviewPhysicianList'   B@ | " !"A@ o  & ] repComplianceReport'   B@(P |H &@ !"A@(( o  , ]@ &repComplianceReport (Treatment Centre)'   B@. | , !"A@. o X 2x ] repReviewMedicalSpecialistList'   B@4( | 2 !"A@4 o  8 ] repReviewHeartSpecialistList'   B@: | 8 !"A@:p oh >X ]H]` DATABASE HELP'   B@@ | > !"A@@ o xD ]]frmDatabaseREPORTS'   B@F |x Dp !"A@FX oP J@ ](]@DATABASE REPORTS'   B@L | J !"A@L o XP ]$repBenzathineComplianceAverageByYear'   B@R` |X PP !"A@R8 o0 V ]1Benzathine Penicillin Compliance Average (ByYear)'   B@X|V !"A@Xo\x]HrepReviewResults'   B@^8|0\( !"A@^o`b]%repComplianceReport (Health Facility)' K[   B@d|b !"A@dxoph`]repEchocardiogramAppts'   B@j|h !"A@jon]PrepPCDoctortAppts'   B@p|n !"A@pho`htP]repMedicalSpecialistAppts'   B@v|t !"A@voz]repSurgeryAppts'   B@||xzp !"A@|XoP@]XrepHeartSpecialistAppts'   B@| !"A@op]repBenzathinePenicillinReport'   B@h|`X !"A@@o8(].repBenzathinePenicillinReport(Health Facility)'   B@| !"A@o ]`DUPLICATE RECORDS'    B@@|80 !"A@ox]]HEALTH FACILITY'   B@| !"A@o p]`!repPercentWith80%orMoreCompliance'   B@| !"A@ox]repDentalAppts'   B@| !"A@oAttribute VB_Name = "Form_PATIENT FORM" " Bas0{C3230265-FF26-42E0-B4AD-DDF1B002 9560} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Option Comp@ DT P&* Sub Cl?_Click() On Error GoTo  DoCmd. Exit : 2rrMsgBox3.DescriZResu- EndI3New_Patien#4 A(C6A?Record ,@ac@ 2:T< =Z?Find_-ZV? G?Screen.viousControl.SetFocusHDoMenuI@tem acBar,EditaA, 10NAVer70ON O ' F'Seaxrch9')&&rm&&%P_%C%I$EXITy$'$jQuit?t?#Ad d_keButton-݇X !?##8 %ii%'%_̯FFF .@i  o_ #!OAvsjocxH1_/Qry+?re\\\\\OM__X# ?OM'Me_N/Ҙ ⚟R?=n]Iob^?_ In(jec:s qui@_every_12mths_AfterUpd?8BeforeCancel As Integer@))кli!@a/Dim `stDoc2Spng#HLinkCripia! 3Benzathine Penicilli BOpen(Y, 2Z1_k#2oa##2_Q 7_/ /Q4_0! ?q????6/c [PID]=" & Me!O//|ia&/-Benzathine_Compliance_Button_Click: MsgBox Err.DescriptionlResume Exit_ Bef End Sub P@rivate Database@_Tools ( ) Onor GoTo _0 jDim s@tDocNaAs String LinkCriteria = "DATABASE TOOLS""oCmd.OpenForɈ6, st/K?]rrv,{gALL_Secondary_Prophylaxij^mdrepTOTALF&&ListNi@ReportG, acPreviewg+i#:ll CFTnDe_>տ3jf3s116/_C,Cs_Addezd,_,, Reg`^ered--U---n-Paediac nic\y/cM`cal_Spel'E/oy_o?? ?p? li}di6_Tr`Kment_C@re_3p,\ N ա(f c )iiat?: ;oa73ЎD֞ obO _^r%po:o:o:n: ntMO ;;;/ . / ( s@rQ/O:?s : /ntJ  7a >m!mA_y3 Dim stDocName As String h= "repTreatmentC reList"RDoCmd.OpenReportt, acPr eviewExit__H_I_Button_Click:V- Sub9rr'8MsgBox Err.Descr@iptionTR8esu$ EndDPrivate Find[() On;or GoTo_g,Screen.ousControl.SetFocusDoMen K[uItemFormBarEdit , 10, Ver70@ S0OAdd_New`PQ QG[RecordAA@A eBCEchocardiogram_DueE > Rw}}/a1 B| z2General_Special_!_3_?42 4bbl5?h55 lz6Heart)6Z?424b 3_43 2zqrmary_Care_Ptor3r_[ϋBwËd/3/3t_/ + _ odϋA}_qRwSurge/2 pT1e1_ A _ /֢UHpdoI'p$4___# ĉ/&ϿckHH?diac|A'HH_tZooo/Team HHoop __Q,__-CϯOsbIebt_? ; oo;_e|2tton_Cli ck End Sub Private0 Paedia@tricianic_Review_List_Bu() On Error G(oTo_* Dim stDocName As Sng= "rep i"LoCmd.OpenReportY, acPrg-ExitW:+rrt!MsgBox.Description/Resu~Jhys9B3pE7o)o_-n=n1&_7"to _7 zn_7liD7 n_7;2$7477an77u075e77 A7Complce@ǿ_{44 ; p| *?l8lكx_Treat@ment_C@re_ 4 _oj/=Q ( )?o ,n2Mp@cal_SeRl: OAP?2Sp oRϥeOnt_ ߾ _kOOH?>OHHeart(ao_7_7@qDƯt__ \ ߏ /(Database_HELPw44A LinkCriteriaRjDATABASE >QForx, st" r _d_hs_BUTTON/(O3L3kCriteria As String stDocName = "frmDatabaseREPORTS"DoCmd.OpenForm h, stL inExit_dATABASE_reports_BUTTON_Click:X!( Sub4rr"3MsgBox Err.DescriptionOpResu  End?Private D\_Button\() On>or GoTo_mDiՅ8 Y/j iiBenz athiefharti jC#neComplianceAverageByYe4arRĉacPreview BZ*e 2 22ne_Peni`cilli 4f#__by_"_9je_7g ' 8 8 (9)?9 7989 c _<K< =R"V_Historyo_77`o# lts33x2?008 /'T@*a__Health_Famity_loo_bhO?9@wO( 5R5  `_tEchocardiogramApp 9_  o6 ooxPCN_q&U44P tN~? 5  OHMedicalSpecialf4ooopN rSurgeryycP___p  qt0trt]1_露or GoTo Err_HeartSpecialistAppts_button_Click  Dim stDocName As Stri ng<4= "rep"oCmd.OpenReportV, acPreviewWExit:U, Sub8!؄@MsgBox.Description)ResuvC EndCPrivate Benza`thine{() OnB Νu͇DPenicillin$rh])?h gglthFa@Fity_o-jll(@@+ +)p8neZ{: n : z:q`ryDup@`p_Record+sn?8 DUPLICATE RE CORDS4Query+NormalaEdit"5)33 3V_lI39~2LinkCri teriaHEALTH FACILITYn6F4I6, , 65_ _5C5Y _kkGraph80_Pj;//3-PercentWit%orMoreCom =ancelτ C/ !ocDalgepa1m?kO NT FORM/&H00000000 DocClass=Form_HEALTH FACILITY/&H00000000 Module=Calculations Name="Test" HelpContextID="0" VersionCompatible32="393222000" CMG="B5B706DF0E9012901290129012" DPB="6A68D9AE8FAF8FAF8F" GC="1F1DAC65D4AF88B088B077" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_PATIENT FORM=22, 29, 694, 476, C Form_HEALTH FACILITY=0, 0, 0, 0, C Calculations=44, 44, 867, 435, Form_PATIENT FORMForm_PATIENT FORMForm_HEALTH FACILITYForK[m_HEALTH FACILITYCalculationsCalculationsͬPDvWTDetailrOLEUnbound0dmrrForms *Jj 9b1008/P^9/Blob o{HPropData4 f8)0280=Bb c4e ghijRk$`1g@a~Ah@Z=. U  Ariald2 Tahomam45bg[ Tahomar35cd ` Detail,NkKMr027Uc4dOLEUnbound0FFࡱ> Root EntryF9/CompObjeOle /Workbook Root EntryF@C9/CompObjeOle /Workbook   !K[  !"#$%&'()*+,-0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcAccessObjSiteData&8OlePres000. 88 FMicrosoft Graph ChartGBiff5MSGraph.Chart.89q  WestQ B""$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-1Arial1Arial1Arial1hArial1Arial1Arial1Arial1Arial=p5J,##0.00_ ` &4|h` J ` J ` n(883ffff̙̙3f3fff3f3f33333f33333\R3=&STU YearCountOfCompliance (%)L@?P@@T@@WYI += f!B >X4q3d 3Q .CountOfCompliance (%)QQQ3_4E4 3Q 2nd QtrQQQ3_4E4 3Q 3rd QtrQQQ3_4E4 3Q 4th QtrQQQ3_4E4D $% M3O&Q4$% M3O&Q4FAG 3O-WF 3 b#M&43*#M&! M43" 44% hSfK[M"3OJ&Q TNumber of people receiving 80% or more of Benzathine Penicillin injections by Year '44 44]2  gF  !"#$%&'()*+,-0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcAccessObjSiteData&8OlePres000. 88 FMicrosoft Graph ChartGBiff5MSGraph.Chart.89q  WestQ B""$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-1Arial1Arial1Arial1hArial1Arial1Arial1Arial1Arial=p5J,##0.00_ ` &4|h` J ` J ` n(883ffff̙̙3f3fff3f3f33333f33333\R3=&STU YearCountOfCompliance (%)L@?P@@T@@WYI += f!B >X4q3d 3Q .CountOfCompliance (%)QQQ3_4E4 3Q 2nd QtrQQQ3_4E4 3Q 3rd QtrQQQ3_4E4 3Q 4th QtrQQQ3_4E4D $% M3O&Q4$% M3O&Q4FAG 3O-WF 3 b#M&43*#M&! K[ M43" 44% hSfM"3OJ&Q TNumber of people receiving 80% or more of Benzathine Penicillin injections by Year '44 44]2  gF    '' "Arial-"System&:`8------"Arial-----------'- -'- ---'-- vu$% uM%Mu%u%u%uz%zu--'-- --'-- --'-- wy$--'-- xw$--  $yyy$$  ---'--- wy$---'--- -z% %- % %M M% % % %z z%%u%%@@ZZuu----------'--- Z  F2 *Number of people receiving 80% or more of         E2 5)Benzathine Penicillin injections by Year          -----'--- ---'--- ----'---   2 0 2 y1 2 D2 2 3 2 4 2 5 2 q6---'--- ---'---   2 2003 2 2004 2 2005---'--- ---' ' 'NANI .---'--- nM---'---K[ ---'     '' "Arial-"System"&`8------"Arial-----------'- -'- ---'-- vu$% uM%Mu%u%u%uz%zu--'-- --'-- --'-- wy$--'-- xw$--  $yyy$$  ---'--- wy$---'--- -z% %- % %M M% % % %z z%%u%%@@ZZuu----------'--- Z  F2 *Number of people receiving 80% or more of         E2 5)Benzathine Penicillin injections by Year          -----'--- ---'--- ----'---   2 0 2 y1 2 D2 2 3 2 4 2 5 2 q6---'--- ---'---   2 2003 2 2004 2 2005---'--- ---' ' 'NANI .---'--- nM---'--- ---' Table/QuerySELECT [Year],Count([Compliance (%)]) AS [CountOfCompliance (%)] FROM [qryBenzathine>80%] GROUP BY [Year];MSGraph.Chart.8*MicroK[soft Graph ChartFM'+BJTypeInfo5EBlobDelta7A1 `;dz5 r.Blob 9/  02689=Bb c$e g&h# iZj.k31@?bc>LCoZ6ј Ug*@bMsTE @`s zlookup Treatment Centre subform  Ariald2 Tahomae12bRcRhbcgh Tahomam45bg[ Tahomap5bc`FormHeader6bIBa|R` DetailǑscD p3`abc@zlookup Treatment Centre subformJForm.zlookup Treatment Centre subform@zlookup_Treatment_Centre_subformL0yFAo@;e1245]`}abc Box139,Cn?ygCd5U7`xabcLabel23LTo ADD a Health Facility to the list: 3 #AKÏd5]7`abcLabel24P1. Click into the row with the star (*)nQ!Kcbd5_7`abcLabel26P2. Type the name of the Health Facilityur@'V"d5_7`abcLabel2863. Click 'CLOSE this list"*FGmzNd5W7`adbceLabel30VType each Health Facility name in a new row5KpH^N쇔md5_7`xaqbcLabel31nTo permanently REMOVE a Health Facility from the list: c^OOnwBd5_7`abcLabel32ݰ1. Click into the the grey square to the left of the Health Facility you want to deletem~HjiFr741md5_7`a7 bcLabel3302. Press the DELETE keyNO>vLd5_7`a bcLabel35V3. Click YES to delete the Health Facility(eK } ]8d5W7`a bcLabel37P4. Click NO to keep the Health Facilitys;FR>>$Ud5U7`abceLabel43Health Facilities that have been removed from this list will not be deleted from the MAIN FORM records. C>xFKVGf`FormFootervtO@j5|h1U`[abscCLOSE_ButtonCLOSE this List6Close Treatment Centre Edit34aJF0d5U7`aZbycd eLabel34ݖNOTE: Only Health Facilities in this list can be selected on the MAIN FORM.s;VKTZͬ7ovHyi#TEK[FormHeaderDetaPropDatafTypeInfogBlobDeltan2lkfp+>:ilpzlookup_Treatment_Centre_subformzlookup Treatment Centre subformeBox13d Label23d Label24d Label26d Label28d Label30d  Label31d  Label32d  Label33d  Label35d  Label37FormFooterh CLOSE_Buttond Label34d Label43dehmp pedddddddddddhd 028|=Bb ce g hij1k m^ @ iG#CY3 Uu()A^j-[^ @qryComplianceCalculationzjL `~Kdyu()A^j-PID{ HM+=tu()A^j-YearclvzE >_u()A^j-Injections Required (Jan-Dec)*C[suu()A^j-Injections RecBlob q0PropDataTypeInfoBlobDeltaeived (Jan-Dec)>> Iy? u()A^j-Compliance (%) SELECT qryComplianceCalculation.PID, qryComplianceCalculation.Year, qryComplianceCalculation.[Injections Required (Jan-Dec)], qryComplianceCalculation.[Injections Received (Jan-Dec)], qryComplianceCalculation.[Compliance (%)] FROM qryComplianceCalculation; @qryComplianceCalculation subform Ariald2e12bRcRfbg237bchbcghMS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcijMS Sans Serif{5bcJ `FormHeaderaE ok\Oc0Wz`; Detail9A(A m7UF`arbcePIDPIDߝAbd5U`9arbcPID_LabelPIDVZiMKfm7UF`ab cekYearYearߎEnter YEAR for which injection delivery is being calcK[ulated (e.g. 2006)aB[N_/ͽ=d5U`9abcYear_LabelYearcP\)K:,o05UD`acde fhn]9=IXMK:Injections Required (Jan-Dec):Injections Required (Jan-Dec)Value List.17;3-weekly;13;4-weekly284;1134Select the appropriate number of Benzathine penicillin G injections prescribed for the full year from the list provided:Injections_Required__Jan_Dec_d5U`<ab6cFInjections Required this year_Label$Required (Jan-Dec)FInjections_Required_this_year_Label,jEaEbU 9Nm7UF`atbXce5k:Injections Received (Jan-Dec):Injections Received (Jan-Dec)ߘEnter the TOTAL number of Benzathine injections DELIVERED over the full year:Injections_Received__Jan_Dec_g-IN"Y{d5U`9atbcFInjections Received this year_LabelGiven (Jan-Dec)FInjections_Received_this_year_Labelơ)1I0dnm07UF`ab cekCompliance (%)Compliance (%)StandardPercent RECEIVED is calculated automatically from number of injections PRESCRIBED and number RECEIVEDCompliance____^X F**Јd5U`9abc(Compliance (%)_LabelReceived (%)(Compliance_____Labelf=J:Bω E`FormFooter9ПFcGhͬ {IF˵IuFormHeaderDetailmPIDd PID_LabelmYeard Year_LabeloInjections_Required__Jan_Dec_Injections Required (Jan-Dec)d Injections_Required_this_year_LabelInjections Required this year_LabelmInjections_Received__Jan_Dec_Injections Received (Jan-Dec)d  Injections_Received_this_year_LabelInjections Received this year_Labelm Compliance____Compliance (%)d  Compliance_____LabelCompliance (%)_Label FormFooterdefghijklmnoprz{mdmdodmdmdͬhe#&B`FormHeaderDetailmPIDd PID_LabelmRegistration_DateRegistration Dated Registration_Date_LabelRegistration Dat5&?JsбX0Blob ZPropDataTypeInfo 028w9=Bb c1e gh i j=ks#@((tblPatientForm.Gender="Male"))I~@'I}MgVq U@NC8Fz `m>Tj@tblPatientForm iG#CY3hh@H0frK[mComplianceCalculation subformu()A^j-[^ @qryComplianceCalculationzjL `~Kdyu()A^j-PID{ HM+=tu()A^j-YearclvzE >_u()A^j-Injections Required (Jan-Dec)*C[suu()A^j-Injections Received (Jan-Dec)>> Iy? u()A^j-Compliance (%)oNc[g|i@NC8Fz `PID+=vOÊg/@NC8Fz `Registration Date:ՙ3I҃ocj@NC8Fz `Current Disease StateS*M+L:hWF@NC8Fz `NameXJÉOy@NC8Fz `Date of BirthPYOS2 @NC8Fz `Gender I1Bw.J@NC8Fz `Health Numberg#^ I>1*@NC8Fz `Local Health FacilitymSłEEDxPE @zlookup Health Facilitymo-pB+YtBe@NC8Fz `Medication. N8t^@NC8Fz `Date startedy$HPd7@NC8Fz `Date ceasedρcMЎݍG|@NC8Fz `General CommentsQIAE\?V@NC8Fz `Address/PhoneɩPKAeZ(@NC8Fz `Defaultހ`EAOyD'I}MgVqDate of Birth :B@NC8Fz `Case~WD@LoQ]9@NC8Fz `Date of Death09DDKcq@NC8Fz `Cause of Death`Ն8G!Y쒮7@zlookup Cause of Death JKF+8@NC8Fz `Medical Specialist Date\PBBN%@NC8Fz `Echocardiogram Date(|zNېN@NC8Fz `Dental Date|C==J{5\@NC8Fz `Valve Surgery Datep3 F`F@NC8Fz `ARF Diagnosis? eTsE u U@NC8Fz `RHD DiagnosisB䲀lNa>h@NC8Fz `ARF Found by9|!Nqd=ӆIg@zlookup ARFDiagnosisu8FK=_F`@NC8Fz `RHD Found byNk@nXJf(SOGIg@zlookup RHDDiagnosis3fK7Q3@NC8Fz `Surgery Date tblPatientFormݰSAMPLE - RHEUMATIC HEART DISEASE REGISTER 2007 World Heart Federation Arial8?h߁ odLetterBJDM VT$m,`Oj,`OjVT$m,`Oj,`OjXXDRAFTSample 1'dVT$mVT$m@= K[VT$mCanon i905D߁ odLetterN."' USB001d2e12bRcRfbg237bchbcghMS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcijMS Sans Serif{5bcJ |bc`FormHeaderp(|fM.x$3` Detail'qI_>&m457U;CF`b>ciekPIDPID E;Wkd5U7`bbcZPID_LabelComputer ID:25}Kܵm457U;CF`Tbcie k"Registration Date"Registration DateShort Date00/00/0000"Registration_DateF"խ H¥\1d5U7`bci.Registration Date_Label$Registration Date:.Registration_Date_LabelyiD|s}o025]9Dacg#dHeS fmn eEDK+ށ*Current Disease State*Current Disease StateValue ListZARF (no RHD);MILD RHD;MODERATE RHD;SEVERE RHDEnter CURRENT DISEASE STATE as determined by a Medical Specialist*Current_Disease_StateEnter current SEVERITY OF DISEASE as determined by the Medical Officer (or Nurse Practitioner)d5]7`aHbcc,Disease Severity_Label*Current Disease State,Disease_Severity_Label? ܧڂC# Dm47];F`TaMbcNameNameEnter NAME&Enter FIRST name(s)dNo"d5]7`aMbc First Name_LabelName First_Name_Label3 cFB܌5~Gm47];F`PaHbRckDate of BirthDate of BirthShort DateߪEnter DATE OF BIRTH (if exact date is unknown, enter year of birth as - 01/07/1990)#0/00/00Date_of_BirthEnter DATE OF BIRTH (if exact date is unknown, enter year - 01/01/1990)ހ`EAOyDd5]7`aHbc&Date of Birth_LabelDate of Birth&Date_of_Birth_Labelđ7/G ݅-o025]9DacPdGefhtnvK Gender GenderValue ListMale;FemaleXSelect MALE or FEMALE from the list providedXSelect MALE or FEMALE from the list providedd5]7`aGbcGender_Label Genderr7VSJ}+Ytm47];F`PaEbckHealth NumberHealth NumberNEnter HEALTH, CLINIC or HOSPITAL NUMBERHealth_Number.EBNxj2]`a bci DefaultDefaultTICK if this person received LESS THAN 80% of Benzathine Penicillin G injections during the previous full yearHeG'ߛrNd5]7`a b(cLabel624݊Less than 80% of Benzathine injections received in the last 12 months77PA.*-m47];F`aHb(cjkText648="Age" & " " & DateDiff("yyyy",[date of birth],Now())+Int(Format(Now(),"mmdd")<Format([date of birth],"mmdd"))A)6K2L^o025]Dacg#dMeS fn _fc@Qj;$gCaseCaseValue List&New Case;Known CaseSelect whether person was previously KNOWN to the health system or a NEW identified case of ARF or RHDd5]7`aMbccLabel691,Status at registrationU")E3tWm47];F`l#arbS ckDate of DeathDate of DeathShort Date.Enter the DATE OF DEATH#0/00/00Date_of_DeathyέH.id5]7`arbccLabel701Date of DeathbgC%D?o25]Dcl#dveS n "";"";"10";"100"} {K`/ Cause of DeathCause of DeathTable/Query,zlookup Cause of DeathpSelect the primary CAUSE OF DEATH from the list providedCause_of_Deathd5]7`avbccLabel703Cause of DeathrϖELRe15`a@b0c Box704C\BG켭Bp3`asbcd@frmComplianceCalculation subformJForm.frmComplianceCalculation subformPIDPID@frmComplianceCalculation_subform_]A HEJDd57`abceLabel720PBENZATHINE PENICILLIN INJECTION DELIVERYOʹJe;d57`abcceLabel721 DEATHfIBYIIm47;F`g#a bS k.Medical Specialist Date.Medical Specialist DateShort DateZEnter DATE for next Medical Specialist REVIEW00/00/00.Medical_Specialist_DatejYO}Md57`a bccLabel754$Medical SpecialistKqԗBy" i:m47;F`g#a bS k&Echocardiogram Date&Echocardiogram DateShort DateDEnter DATE for next Echocardiogram00/00/00&Echocardiogram_Date/'!|Nl(?%d57`a bccLabel758EchocardiogramCk6LJK[ m47;F`g#a bS kDental DateDental DateShort DateREnter the expected DATE for Dental Review00/00/00Dental_DaterjZKXd57`a bccLabel760Dental ReviewQ%@K2Zm47;F`g#aCbS ck"Last Surgery Date$Valve Surgery DateShort DatebEnter DATE of the most recent heart valve surgery00/00/00"Last_Surgery_DateMWzG'Ed57`aCbcLabel771*PreviouK[s Surgery Date8oG1$zd57`aYb ceLabel7720DIAGNOSIS AND MANAGEMENT}rk7Npm47;F`g#aGbS ck ARF DiagnosisARF DiagnosisShort DateVEnter DATE of the most recent ARF Diagnosis00/00/00ARF_Diagnosis1*/EF7J/Pid57`aGbccLabel774$Last ARF Diagnosisu{ +6BF;m47;F`g#aEbS ckRHD DiagnosisRHD DiagnosisShort Date6Enter DATE of RHD Diagnosis00/00/00RHD_DiagnosisJzޞ7H"/b,Qd57`aEbccLabel776RHD DiagnosisUnz4@.BMo25Dacg#dFeS fn "";"";"10";"100"JƯ@MpsARF Found byARF Found byTable/Query(zlookup ARFDiagnosis~Select how this diagnosis was DISCOVERED from the list providedARF_Found_byd57`aFbccLabel778"ARF Discovered byr2Nse'Eo25Dacg#dDeS fn "";"";"10";"100"#g2K-.?CRHD Found byRHD Found byTable/Query(zlookup RHDDiagnosis~Select how this diagnosis was DISCOVERED from the list providedRHD_Found_byd57`aDbccLabel780"RHD Discovered by:}C47o f3w`a bLine784Z!4Gy,ȴd5U78`/+abccd Label783(updated October 2008Centaur;Oq7B_L0mm47;F`g#a bS kSurgery DateSurgery DateShort Date^Enter the expected DATE for Heart Valve Surgery00/00/00Surgery_Date p#AJnNd57`a bccLabel795&Heart Valve SurgeryH&0Nx)o(`6FormFooter lM$D`x#h1U` abc$Cases Added_Button"[Event Procedure]$Cases_Added_Button$ @EP\uh1U`;abci(Priority List_Button"[Event Procedure](Priority_List_ButtonV?rO#"Lh1U` abci8Treatment Centre List_Button"[Event Procedure]8Treatment_Centre_List_Buttonls)5A o h1U` abcihSecondary Prophylaxis List (Treatment Centre)_Button"[Event Procedure]hSecondary_Prophylaxis_List__Treatment_Centre__ButtoniXFe 'Vh1U`;abci (Deaths Report_Button"[Event Procedure](Deaths_Report_Buttonu9_cC4zd5]7`ab cLabel7246Cases added to the Register$;X J\Z d57`ab cLabel725(Health Facility ListA`$riO-)p d5]7`Gab cLabel726*Disease Priority ListpCKL^c'yL[fd5]7`Gab cK[Label731Deaths ReportK=HO9Q1Vh1]`-abc<hiEXIT_ButtonEXIT"[Event Procedure]YB*,Aφ(;zd5U7`bceLabel736REPORTSCMz7d5`Gab cLabel5916Echocardiogram Appointments ArialVqdCb0$Ud5`Gab cLabel597>Medical Specialist Appointments Arial}\&uKVr UD{d5`GaGb cLabel600Surgery List ArialOkA"nh1U`;abci4EchocardiogramAppts_Button"[Event Procedure]h{dtE%v@h1U`;abci:MedicalSpecialistAppts_Button"[Event Procedure]'Kt)gN\Mh1U`;aGbci &SurgeryAppts_button"[Event Procedure]NCe>DUG5h1U`abcgi Find_Button"[Event Procedure]V2LF+}h1U`abcgi Add New_Button"[Event Procedure]Add_New_Button bB)x80% (by Year)-8 C@;l(h1U` abci$repGraph80%_button"[Event Procedure]$repGraph80__button=m%J=ljLd5`Iaub cLabel796&Dental Appointments Arial""(E{42h1U`;aubci repDental_button"[Event Procedure]o'H&))Ǩe_Labeld Disease_Severity_LabelDisease Severity_Labeld  First_Name_LabelFirst Name_Labelm Date_of_BirthDate of Birthd  Date_of_Birth_LabelDate of Birth_Labelo Genderd  Gender_LabelmHealth_NumberHealth Numberd Clinic_Hospital_Number_LabelClinic/Hospital Number_LabeloLocal_Health_FacilityLocal Health Facilityd Local_Treatment_Centre_LabelLocal Treatment Centre_Labeld PERSONAL_DETAILS_LabelPERSONAL DETAILS_LabeloMedicationd Medication_LabelmDate_startedDate startedd Date_STARTED_LabelDate STARTED_LabelmDate_ceasedDate ceasedd Date_CK[EASED_LabelDate CEASED_Labeld SECONDARY_PROPHYLAXIS_LebalSECONDARY PROPHYLAXIS_LebalmGeneral_CommentsGeneral Commentsd NOTES_Labeld Label458m!Address_PhoneAddress/Phoned "Home_Address_LabelHome Address_Labelj#Defaultd $Label624m%Text648o&Cased 'Label691m.Date_of_DeathDate of Deathd /Label701o0Cause_of_DeathCause of Deathd 1Label703e2Box704p3frmComplianceCalculation_subformfrmComplianceCalculation subformd 4Label720d 5Label721h 6Find_Buttonh 7Add_New_ButtonAdd New_Buttond 9Label734d :Label735;FormFooterh <Cases_Added_ButtonCases Added_Buttonh @Priority_List_ButtonPriority List_Buttonh ATreatment_Centre_List_ButtonTreatment Centre List_Buttonh BSecondary_Prophylaxis_List__Treatment_Centre__ButtonSecondary Prophylaxis List (Treatment Centre)_Buttonh CDeaths_Report_ButtonDeaths Report_Buttond DLabel724d ELabel725d FLabel726d GLabel727d HLabel728d JLabel730d KLabel731h LEXIT_Buttond MLabel736OWarfarind PLabel591d QLabel597d SLabel600d bLabel754d fLabel758d hLabel760maMedical_Specialist_DateMedical Specialist DatemeEchocardiogram_DateEchocardiogram Dateh iEchocardiogramAppts_Buttonh kMedicalSpecialistAppts_Buttonh lSurgeryAppts_buttond rLabel771mqLast_Surgery_DateLast Surgery Dated sLabel772d uLabel774d wLabel776mtARF_DiagnosisARF DiagnosismvRHD_DiagnosisRHD DiagnosismNameoCurrent_Disease_StateCurrent Disease Stated yLabel778d {Label780oxARF_Found_byARF Found byozRHD_Found_byRHD Found by|Echocardiogram}SURGERYd ~Label783fLine784h repBenzathineReport_buttonh repBenzathine_HealthFacility__buttonrepBenzathine(HealthFacility)_buttonh qryDuplicate_Records_buttonqryDuplicate Records_buttond Label788d Label789h Health_Facility_buttonHealth Facility_buttond Label791d Label792h repGraph80__buttonrepGraph80%_buttond Label795mgDental_DateDental DatemSurgery_DateSurgery Dated Label796h repDental_buttondefghijklmnoprz{|&mdmdodmdmdodmdoddodmdmddmddmdjdmodmdodepddmdmdmBlobDelta13#UNsPOBuBlob PropData"$dmddmdmdododfdmd#hhhhhdddddddhddddhhhhhddhhhddhddhdh028=Bb ce ghZi"j,kHB J @g*@bMsT UmSłEEDxPE @zlookup Health Facility8+ؤD     K[ !"#$%'(./0123456789:;=>?@CDFIJKLMNOPQRSTUVXYZ[^_`abcdefghjklmpqrstuvwxz{|}`mSłEEDxHealth Facility ܦSELECT [zlookup Health Facility].[Health Facility] FROM [zlookup Health Facility]; @zlookup Treatment Centre subform Ariald2e12bRcRfbg237bchbcghMS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcijMS Sans Serif{5bcJ `FormHeaderRrk]gE7@im` Detail J%@-Y/'m7UF`arb ce? Health FacilityHealth FacilityHealth_Facility<&`EQ '[d5U`9arbc.Treatment Centres_LabelHealth Facility.Treatment_Centres_Label[ɵAvLV:`FormFooter_kKyCͬ.`'Al+|nFormHeaderDetaild Treatment_Centres_LabelTreatment Centres_LabelFormFootermHealth_FacilityHealth Facilitydefghijklmnoprz{mdTypeInfo%BlobDeltaDirData!(PropData=&frmBenzathine>80%Dzlookup Treatment Centre subform PATIENT FORMDfrmComplianceCalculation subform"HEALTH FACILITY 0CB0 13CB0 5CB0 2CB0 1CB0DfrmComplianceCalculation subform0tbReviewResultssubform ETHNICITY*frmDiagnosisSubformDirDataCopy')PropDataCopy&CmdbarsJjJjModules s/Jj 9b1PATIENT FORM$PLACE OF SURGERY"Surgery subform6zlookup Ethnicity subform Dzlookup Place of Surgery subform Dzlookup Treatment Centre subform $TREATMENT CENTRE 2CB0 9CB0 3CB0 4CB0 5CB0 6CB0 7CB0K[ 10CB0 11CB0 13CB0 1CB0Calculations 0CB0ͬ"oR~Ba2푭ReportHeaderfLine19dLabel27mText22dLabel23mText42PageHeaderSectionfLine20fLine20-+G+GPropData.) PropDataCopyDirData,0*"PropData1+PropDataCopyReportsBJj 9b105m 0j0Blob PropData46, TypeInfo7-BlobDelta<08|:<=Babc2e g,himjm8k/>8@}B$J_ U'Ip6ZTj@qryMedicalSpecialistApptss䘯Hi'Ip6ZExpr18tqKNjΦ'Ip6ZExpr2:ՙ3I҃ocj'Ip6ZCurrent Disease StateρcMЎݍG|'Ip6ZGeneral CommentsXJÉOy'Ip6ZDate of BirthS*M+L:hWF'Ip6ZNameQIAE\?V'Ip6ZAddress/Phone JKF+8'Ip6ZMedical Specialist Dateg#^ I>1*'Ip6ZLocal Health Facility 2qryMedicalSpecialistAppts.Medical Specialist List Arial82bh(& 4dLetter PRIV d4  yArialP _splmf01.exeZK[dArialdEOSCK&DUSB001d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4.Medical Specialist Date*Local Health Facility*Current Disease State`ReportHeaderr.xM`;f2a<b2 Line19W|37OL/sd2avb$cdLabel27?@ABCDEFJIVXLMNOPQRSTUWgiZ[\]^_`abcdehjxylmnopqrstuvwz}~08:<=Bb cX1e gij0*k nh@D%qf@0@ $T. U ^Proportion Receiving >80% Benzathine Injections Arial8X1"h( 4dA4 PRIV d!K[4  yArialP _splmf01.exeZdArialdEOSCK&DUSB001d28 Arialm5<bg[ Arialq5cd `"PageHeaderSection$ }qjC`" Detail@x)Mfiq02a6bmc"/d Graph0FFࡱ> Root EntryFP'=:CompObjeOle 6Workbook Root EntryF@'=:CompObjeOle 6Workbook   !"K[  !"#$%&'()*+,-./12345789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefgAccessObjSiteData&8OlePres0000   !"#$%&'()*+,-./12345789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefg88& FMicrosoft Graph ChartGBiff5MSGraph.Chart.89q@ B""$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-1Arial1Arial1Arial1Arial1YArial1Arial1Arial1Arial1YArial1Arial=/ ,##0.00_ ` (]` (]@` (]` J ` J `  883ffff̙̙3f3fff3f3f33333f33333\R3=& STU YearPercentL@9@P@N@T@m۶mQ@WY-h= \ )B >X4[3d 3Q PercentQQQ3_4E4 3Q 2nd QtrQQQ3_4E4 3Q 3rd QtrQQQ3_4E4 3Q 4th QtrQQQ3_4E4D$% M3O&Q4$% #K[M3O&Q4FAfiC 3O2; 3 b#M& 43*Y@4@#M& ! M43" 44% Oz M"3OAz=&P]^gQ gProportion of people requiring Benzathine Penicillin G who received 80% or more of Injections (by Year)'44 e requiring Benzathine AccessObjSiteData&8OlePres0000 88& FMicrosoft Graph ChartGBiff5MSGraph.Chart.89q@ B""$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-1Arial1Arial1Arial1Arial1YArial1Arial1Arial1Arial1YArial1Arial=/ ,##0.00_ ` (]` (]@` (]` J ` J `  883ffff̙̙3f3fff3f3f33333f33333\R3=& STU YearPercentL@9@P@N@T@m۶mQ@WY-h= \ )B >X4[3d 3Q PercentQQQ3_4E4 3Q 2nd QtrQQQ3_4E4 3Q 3rd QtrQQQ3_4E4 3Q 4th QtrQQQ3_4E4D$% M3O&Q4$% M3O&Q4FAfiC 3O2; 3 b#M& 43*Y@4@#M& ! M43" $K[44% Oz M"3OAz=&P]^gQ gProportion of people requiring Benzathine Penicillin G who received 80% or more of Injections (by Year)'44 e requiring Benzathine S 5D   m  %  '' "Arial-"Arial--"Arial--"SystemS`8-------'- $-'- $---'-- nK|L |:L:LLsLs--'-- $--'--  --'-- rK--'-- pK--  $kkk$$nnn---'--- rK---'--- $-sL L-EL|E|L:E:LELELsEsLLLL::''-------------'--- Ma---  m2 eDProportion of people requiring Benzathine Penicillin G who received                 -2 080% or more of Injections        - 2 , -2 3 (by Year)  -----'--- $---'--- $----'--- %  2 -0 2 o 20 2 - 40 2 60 2 80 2 f100 ---'--- $---'--- %  2 2003 2 2004 2 2005 ---'--- $---' ' 'NANI %  2 %K[East S 5D   m  %  '' "Arial-"Arial--"Arial--"System}`8-------'- $-'- $---'-- nK|L |:L:LLsLs--'-- $--'--  --'-- rK--'-- pK--  $kkk$$nnn---'--- rK---'--- $-sL L-EL|E|L:E:LELELsEsLLLL::''-------------'--- Ma---  m2 eDProportion of people requiring Benzathine Penicillin G who received                 -2 080% or more of Injections        - 2 , -2 3 (by Year)  -----'--- $---'--- $----'--- %  2 -0 2 o 20 2 - 40 2 60 2 80 2 f100 ---'--- $---'--- %  2 2003 2 2004 2 2005 ---'--- $---' ' 'NANI %  2 East Table/QueryjSELECT QryNumComplByYear.Year, [Num>80%]/[Total]*100 AS [Percent] FROM QryNumComplByYear INNER JOIN QryTotalRecAnyInjByYear ON QryNumComplByYear.Year = QryTotalRecAnyInjByYear.Year;M&K[SGraph.Chart.8*Microsoft Graph ChartX<Lcl"d278`aYbycdeLabel20>Rheumatic Heart Disease Report Times New Roman.1[SS5Evm;<CF`abc,i k Text22 =Now()Long DateTimes New RomanD-=WNĚ'd78`abc,d Label23Report Date:Times New RomanDetachedLabelm"(xMۣEE`"PageFooterSectionM8A!_h)BlobDeltaEa2?)zZ2Blob *WPropData>@G08|:<=Babc2e g,hgij7kJ.JG!8@WMOha6 U&}L]I>]=0'g@qryEchocardiogramAppts{Ka0ӳ?&}L]I>]Expr1LOH:/&}L]I>]Expr2:ՙ3I҃ocj&}L]I>]Current Disease StateρcMЎݍG|&}L]I>]General CommentsXJÉOy&}L]I>]Date of BirthS*M+L:hWF&}L]I>]NameQIAE\?V&}L]I>]Address/Phone\PBBN%&}L]I>]Echocardiogram Dateg#^ I>1*&}L]I>]Local Health Facility ,qryEchocardiogramAppts&Echocardiogram List Arial82bh(& 4dLetter PRIV d4  yArialP _splmf01.exeZdAriald'K[EOSCK&DUSB001d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4&Echocardiogram Date*Local Health Facility*Current Disease State`ReportHeader\WC,d6Ff2a<b2 Line19\#M\r ׬d2axb$cdLabel27>Rheumatic Heart Disease Report a"I3Pm;<F`afbc,i Text22 =Now()Long DateTimes New Roman28FÖ}[dafbc,eLabel23Report Date:DetachedLabel-+q{"C."m<Fab+cHi jk Text42,="ECHOCARDIOGRAM Appointments scheduled between" & " " & Format$([Expr1],"dd mmmm yyyy",0,0) & " " & "and" & " " & Format$([Expr2],"dd mmmm yyyy",0,0)Times New RomanĕHjp$`"PageHeaderSectionWdA/rRd`a<bc;d e,Disease Severity_Label"Current DiagnosisDetachedLabel,Disease_Severity_Labelz@ .dD"cLda<bc;d e0Echocardiogram Due_LabelDue DateDetachedLabel0Echocardiogram_Due_LabelkIiE'qASd` a<bc;d e First Name_LabelNameDetachedLabel First_Name_Label6pTGO'3.PEd`ba<bdc;d e&Date of Birth_LabelDate of BirthDetachedLabel&Date_of_Birth_Label Abm~v(d`ka<bc;d eAddress_Label&Contact InformationDetachedLabelDf27Jo-<ȍd`&a<bm c;d e,General Comments_Label NotesDetachedLabel,General_Comments_Label}0&s#EH"Omf2b2 Line20nYlcD}&f2ab2 Line21\^GC}G`b DetailЊHuRGKc=o0Dacd-eTf,h%}=f@@u Disease Severity*Current Disease StateValue ListNNO RHD;MILD RHD;MODERATE RHD;SEVERE RHD Disease_SeveritymF`&a-b c,ek General Comments General Comments General_CommentshN/THMߒmF`Sa-bsc,k Text29T=Format$([Date of Birth],"d mmm yyyy",0,0)_fZ+A75>7mF` a-bc,k Text34NamebhL$]imF`kabP c,kAddress/PhoneAddress/PhoneAddress_Phone!]>KjlmFa/bc,k Text41`=Format$([Echocardiogram Date],"d mmm yyyy",0,0)B\2A9>`"PageFooterSectionK,iBK.{m ;<F`ab9c,i j Text18H="Page " & [Page] & " of " & [Pages]Times New RomanP?o)JY`ReportFooter`'C*%*m;<F`/abc,i j Text33=Count(*)Times New Roman(I2\Ѵd7`$ab c;d Label34 TOTAL IN REPORT:h·J1q(K[TypeInfoAHBlobDeltaW38VDprfun0Blob ;ͬ#иtJW ԏReportHeaderfLine19dLabel27mText22dLabel23mText42PageHeaderSectiondDisease_Severity_LabelDisease Severity_LabeldEchocardiogram_Due_LabelEchocardiogram Due_Labeld First_Name_LabelFirst Name_Labeld Date_of_Birth_LabelDate of Birth_Labeld Address_Labeld General_Comments_LabelGeneral Comments_Labelf Line20fLine21DetailoDisease_SeverityDisease SeveritymGeneral_CommentsGeneral CommentsmText29mText34mAddress_PhoneAddress/PhonemText41PageFooterSectionmText18ReportFootermText33dLabel34Current Disease StateNameDate of BirthLocal Health FacilityEchocardiogram Date Echocardiogram!Expr1"Expr2defgjmnopfdmdmddddddffommmmmmmdͬaQG]'JǙReportHeaderdLabel14fLine17dLabel22mText22dLabel23PageHeaderSectiondFirst_Name_LabelFir08|:<=Bb c$e g)hi[j$k-[10g@}Ho UhqB 1㠮V /0g@qryBenzathinePenicillinReportg#^ I>1*hqB 1㠮VLocal Health FacilitymSłEEDxPE @zlookup Health FacilityoNc[g|ihqB 1㠮VPIDɩPKAeZ(hqB 1㠮VDefaultS*M+L:hWFhqB 1㠮VName{ HM+=thqB 1㠮VYear>> Iy? hqB 1㠮VCompliance (%)ρcMЎݍG|hqB 1㠮VGeneral Comments :qryBenzathinePenicillinReportNBenzathine Penicillin Compliance Report Arial8$1h(& 4dLetter PRIV d4  yArialP _splmf01.exeZ)K[dArialdEOSCK&DUSB001d278d eTimes New Romane24bRcRfbg37bcjghlbc g[m5Cbg[ Arialn=cdh[ Arialo3Aej[ Arialp4bcrcd *Local Health FacilityPIDPIDYear`ReportHeader0< VtGe >[d2aibcdLabel14>Rheumatic Heart Disease Report E5!iDl{f2a9b$ Line17;u7A>ɐdab9!chd Label22ݘBenzathine Penicillin G - Injections received each Year (January - December)DvKF_Om;<F`afbci Text22 =Now()Long DateTimes New RomanЄmWD'dafbceLabel23Report Date:DetachedLabel獲G&]`"PageHeaderSection AX{[:d`a8bc;e First Name_LabelNameDetachedLabel First_Name_Label{x"E%b1Ƞd`a<bc;eYear_LabelYearDetachedLabelpϏMy^d`} a<bRc;e Compliance_Label,Injections received(%)DetachedLabel EVEsHbM@f2b$ Line18DHnFf2ab$ Line19 QEJFd`a<bsc;eLabel39Less than 80%DetachedLabel1ۡƽI|!zOZ`GroupHeader2!g+Ao:Dadc<de f"l "";"";"10";"100"|KN = ,Local Treatment Centre*Local Health FacilityTable/Query.zlookup Health FacilityTimes New Roman,Local_Treatment_Centre`<aGroupHeader090# VHcl[6m0<F`9brc<ei jPIDPIDTimes New Roman9RAEޏj`aGroupHeader1)DDy?Ү`1 Detail L+{S%j`a<bcDefaultDefault F֌SOb- WrmF`8bc"i kNameName^}KC{&oy9UmF`abci kYearYear 1*6QB]Y,Local Health FacilityoNc[g|i6QB]Y,PIDɩPKAeZ(6QB]Y,DefaultS*M+L:hWF6QB]Y,Name{ HM+=t6QB]Y,Year>> Iy? 6QB]Y,Compliance (%)ρcMЎݍG|6QB]Y,General Comments \qryBenzathinePenicillinReport(Health Facility)NBenzathine Penicillin Compliance Report Arial8$Wh(& 4dLetter PRIV d4  yArialP +K[_splmf01.exeZdArialdEOSCK&DUSB001d278d eTimes New Romane24bRcRfbg37bcjghlbc g[m5Cbg[ Arialn=cdh[ Arialo3Aej[ Arialp4bcrcd PIDPIDYear`ReportHeader3_qM[7d2aibcdLabel14>Rheumatic Heart Disease Report 2"O3 }27f2a9b$ Line17㙃I Wbm;<F`afbci Text22 =Now()Long DateTimes New RomanHN(F˚ȝdafbceLabel23Report Date:DetachedLabelw1CKOm<Fab$cWi jk Text32ݰ="Benzathine Penicillin G - Injections received each year at " & [Local Health Facility]Times New Roman7HF0d`"PageHeaderSection33h(BO,$d`a8bc;e First Name_LabelNameDetachedLabel First_Name_Label^}^sKD{ άd`a<bc;eYear_LabelYearDetachedLabel=O'And`} a<bc;e Compliance_Label,Injections received(%)DetachedLabelEAu f2b$ Line18NLF1Nyyf2ab$ Line19imUtzCuw0d`a<bsc;eLabel39Less than 80%DetachedLabel2bD AcR}"`<GroupHeader0Q<J5E/m0<F`9brc<ei jPIDPIDTimes New RomanCI%Iza]W`aGroupHeader1dUdB b`W DetailGS WqM,m\Xj`a<bcDefaultDefaultKpMKk{;mF`8bc"i kNameNameӓCKŒiOmF`abci kYearYearώ&D[OߎQnm0;F`x abci kCompliance (%)Compliance (%)StandardCompliance____\}IsE|mF`ab c"i k General Comments General Comments General_Comments 6`L-/`"PageFooterSectiont IP(mm ;<F`abc,i j Text16H="Page " & [Page] & " of " & [Pages]Times New Roman oP$Iwp\S`ReportFooterlg@qfbel14fLine17mT,K[ext22dLabel23mText32PageHeaderSectiondFirst_Name_LabelFirst Name_LabeldYear_Labeld Compliance_Labelf Line18f Line19d Label39 GroupHeader0mPIDGroupHeader1DetailjDefaultmNamemYearmCompliance____Compliance (%)mGeneral_CommentsGeneral CommentsPageFooterSectionmText16ReportFooterExpr1000Local Health FacilityAddress/Phonedefgjlmnoprdfmdmdddffdmjmmmmmͬ"cGsűTReportHeaderfLi5GQN R\2Blob YPropDataMO~ TypeInfoP08|:<=Babc2e g,hijm8k 0Л8@sBI%& U6UD__hnEg@qrySurgeryApptsXĈ%CBO6UD__hnExpr14sL4G~lX6UD__hnExpr2:ՙ3I҃ocj6UD__hnCurrent Disease StateρcMЎݍG|6UD__hnGeneral CommentsXJÉOy6UD__hnDate of BirthS*M+L:hWF6UD__hnNameQIAE\?V6UD__hnAddress/Phone3fK7Q36UD__hnSurgery Dateg#^ I>1*6UD__hnLocal Health Facility qrySurgeryApptsSurgery List Arial82[h(& 4dLetter PRIV d4  yArialP _splmf01.exeZdAriald-K[EOSCK&DUSB001d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4Surgery Date*Local Health Facility*Current Disease State`ReportHeaderRHAgg "f2a<b2 Line19n!nO:$Y!d2axb$cdLabel27>Rheumatic Heart Disease Report {kM;~{m;<F`afbc,i Text22 =Now()Long DateTimes New Roman0JIG(CaRdafbc,eLabel23Report Date:DetachedLabeloT@(ӝ"m<Fab"cHi jk Text42 ="Cardiac SURGERY scheduled for" & " " & Format$([Expr1],"dd mmmm yyyy",0,0) & " " & "to" & " " & Format$([Expr2],"dd mmmm yyyy",0,0)Times New Romanug'@e9`"PageHeaderSection, s2Gy?ۚ_f2b2 Line205̃Kis*f2ab2 Line216  Hnd`a-bc;e,Disease Severity_Label"Current DiagnosisDetachedLabel,Disease_Severity_LabelY. XC 0da-bc;e0Echocardiogram Due_LabelDue DateDetachedLabel0Echocardiogram_Due_Label*hKL^ȼd` a-bc;e First Name_LabelNameDetachedLabel First_Name_LabelxxzɀF[2\d`ba-bdc;e&Date of Birth_LabelDate of BirthDetachedLabel&Date_of_Birth_LabeluE_zF=p9d`ka-bc;eAddress_Label&Contact InformationDetachedLabel(dDpK )d`&a-bm c;e,General Comments_Label NotesDetachedLabel,General_Comments_Label,{-TJ`[ Detail7VQL.nlo0Dacd-eTf,h%l HN?7D:ReN Disease Severity*Current Disease StateValue ListNNO RHD;MILD RHD;MODERATE RHD;SEVERE RHD Disease_SeveritymF`&a-b c,ei k General Comments General Comments General_CommentsɆ)Cl}F:tmF`ba-bUc,i k Text29T=Format$([Date of Birth],"d mmm yyyy",0,0)j=UNҒ#mF` a-bc,i k Text34NameRZRN%aRmF`kabP c,i kAddress/PhoneAddress/PhoneAddress_PhonepomRD)0XmFa/bc,i k Text41R=Format$([Surgery Date],"d mmm yyyy",0,0)者O p$gD`"PageFooterSectionXbAKL!7tm ;<F`ab9c,i j Text18H="Page " & [Page] & " of " & [Pages]Times New Roman:CO@fa`ReportFooterRV~dE&ug"m;<F`/abc,i j Text33=Count(*)Times New Roman|i0FAcFȻd7`$ab c;d Label34 TOTAL IN REPORT:9Ì[HCҾ.K[ˁne19dLabel27mText22dLabel23mText42PageHeaderSectionfLine20fLine21d Disease_Severity_LabelDisease Severity_Labeld Echocardiogram_Due_LabelEchocardiogram Due_Labeld First_Name_LabelFirst Name_Labeld Date_of_Birth_LabelDate of Birth_Labeld Address_LabeldGeneral_Comments_LabelGeneral Comments_LabelDetailoDisease_SeverityDisease SeveritymGeneral_CommentsGeneral CommentsmText29mText34mAddress_PhoneAddress/PhonemText41PageFooterSectionmText18ReportFootermText33dLabel34Current Disease StateNameDate of BirthLocal Health FacilitySurgery Date Expr1!Expr2defgjmnopfdmBlobDelta6S)BPBBlob kPropDataRT dmffddddddommmmmmmdͬ"FdI"Hhܪ1*boTyNР^B Local Health Facility qryDentalAppts.Medical Specialist List Arial82bh(& 4dLetter PRIV d/K[4  yArialP _splmf01.exeZdArialdEOSCK&DUSB001d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4Dental Date*Local Health Facility*Current Disease State`ReportHeader,MOBC[v$%f2a<b2 Line19f}GW+d2avb$cdLabel27GtN22km ;<F`ab9c,i j Text18H="Page " & [Page] & " of " & [Pages]Times New RomanI0lM?\I`}ReportFooterg BIziBm;<F`/abc,i j Text33=Count(*)Times New RomanLT&=Z Lg_d7`$ab c;d Label34 TOTAL IN REPORT:PyvJTypeInfoUBlobDelta8LjXv<PM30Blob |Echocardiogram_Due_LabelEchocardiogram Due_Labeld First_Name_LabelFirst Name_Labeld Date_of_Birth_LabelDate of Birth_Labeld Address_LabeldGeneral_Comments_LabelGeneral Comments_LabelDetailoDisease_SeverityDisease SeveritymGeneral_CommentsGeneral CommentsmText29mText34mAddress_PhoneAddress/PhonemText41PageFooterSectionmText18ReportFootermText33dLabel34Current Disease StateNameDate of BirthLocal Health FacilityDental Date Expr1!Expr2defgjmnopfdmdmffddddddommmmmmmdˁ08:<=Bb cJ$e gFhj k^)A-@ܼ @K5 ݞ2 U΄M\Ĭ79Tu@qryCasesRegistered,؃[NBnY΄M\Ĭ79Expr1n M/4~^΄M\Ĭ79Expr2 :B΄M\Ĭ79Caseg#^ I>1*΄M\Ĭ79Local Health Facility~WD@LoQ]9΄M\Ĭ79Date of DeathBjftM#i΄M\Ĭ79Age at Regist1K[rationS*M+L:hWF΄M\Ĭ79Name<5ձH?/v; ΄M\Ĭ79Age at Deathdnz7K656Jkܼ @K5 ݞ2Case $qryCasesRegisteredNew Cases Added Arial8J$h(߁ 4dLetter PRIV d4  yArialP _splmf01.exeZdArialdEOSCK&DUSB001d278d eTimes New Romane24bRcRfbg37bcjghlbc g[m5Cbg[ Arialn=cdh[ Arialo3Aej[ Arialp4bcrcd Case*Local Health Facility`ReportHeader?3ű)Cpf2a9b9# Line13iuyi-jHظY$Xd2aibycdLabel16K6j`"PageHeaderSectionԈcPNT@}da8bc,e First Name_LabelNameDetachedLabel First_Name_Labelɞ';&AwJf2b9# Line14Πݝ@Cr՚Xf2ab9# Line15XGn_d`a<bc,eLabel26Date of Death M78A0"d`A a<bc,eLabel45&Age at RegistrationDetachedLabelO…Fp0tAd`oa<bsc,eLabel68Age at Death|/AC=0`]GroupHeader1J;^JAPm<F`<a<bc!i j33CaseCaseTimes New Romandnz7K62K[56Jk`aGroupHeader0CȻ6m<F`bH ci 33*Local Health Facility*Local Health FacilityTimes New Roman*Local_Health_Facility"U~QgJמT` DetailuԗMA>&Tm F`bci Text31V=Format$([Date of Death],"dd mmm yyyy",0,0)Z#P~Og.)\m;F` bci k&Age at Registration&Age at Registration&Age_at_Registration4{f~EʀEm;Fbi ci kNameNameE)ARc%$m ;F`nbci kAge at DeathAge at DeathAge_at_Death}tB+J`aGroupFooter1:xA#/`TGroupFooter3kSNn]m;<F`!bci j Text58=Count(*)Times New Roman}S+KCm;<F`bjci jk Text594=[Case] & " " & "Total - "Times New RomanQ"EiɧO|`"PageFooterSection`RD^.m ;<F`zabc,i j Text12H="Page " & [Page] & " of " & [Pages]Times New Roman 6T&A9vFG`6ReportFooterfFH;嵍m;<F` U=AVBDF ~/u@qryDeaths+W_BVE=AVBDFExpr1C )VI2X=AVBDFExpr209DDKcq=AVBDFCause of DeathPYOS2 =AVBDFGenderρcMЎݍG|=AVBDFGeneral Comments:ՙ3I҃ocj=AVBDFCurrent Disease StateF9OK$!iZ=AVBDFAgeS*M+L:hWF=AVBDFName~WD@LoQ]9=AVBDFDate of Death[^@ ǝ;-},PE>Cause of Death qryDeathsDeaths Report Arial8-3,h( 4dLetter PRIV d4  yArialP _splmf01.exeZdArialdEOSCK&DUSB001d278d eTimes New Romane24bRcRfbg37bcjghlbc g[m5Cbg[ Arialn=cdh[ Arialo3Aej[ Arialp4bcrcd Cause of DeathDate of Death`ReportHeaderto)FS *f2a9b2 Line19x/yXDEdDkd2aibcdLabel27>Rheumatic Heart Disease Report 1ʄKE)_Dۇcm<Fab"cHi j Text32="Deaths4K[ between " & Format$([Expr1],"d mmmm yyyy",0,0) & " " & "and" & " " & Format$([Expr2],"d mmmm yyyy",0,0)Times New RomanK; M#m;<F`aWbc,i k Text22 =Now()Long DateTimes New RomanZDғzdaWbc,eLabel23Report Date:DetachedLabelBVaCv`"PageHeaderSectionw88Ndgda8bc,eLast Name_LabelNameDetachedLabelLast_Name_LabelU,@EtHG`kGroupHeader0}9zB8Pnm;<F`a<b c/i Cause of DeathCause of DeathTimes New RomanCause_of_Death[^@ ǝ;`, Detail, 5KmmF`Yabci ,Local Treatment Centre Gender,Local_Treatment_CentrenMJ2mF`!abmci k General Comments General Comments General_CommentsSK+ximF`^abci k Text46*Current Disease StateIY}0L9lQm;F`Nabci kAgeAgeTẼ%A#ߧmFabci kNameNameџ)bRL͖&Dm;F`b ci k Text37T=Format$([Date of Death],"d mmm yyyy",0,0)C_IR` GroupFooter0H 5(lD,øW7m;<F`/bc i j Text51=Count(*)Times New Roman~mfQBg֛¼m;<F`yb'c i jk Text53H=[Cause of Death] & " " & "Total - "Times New RomanSEHC㒤`I"PageFooterSectionՋĽH~Jm ;<F`habc,i j Text18H="Page " & [Page] & " of " & [Pages]Times New Roman{MdCI`ReportFooterNS|L3| [y+m;<F`0abcJi j Text79=Count(*)Times New RomanǏʄ?HbBd7` ab-cJd Label80TOTAL IN REPORT>r=gMt.pߝLabel42d Disease_SeverityDisease Severityd Age_LabeldLabel49GroupHeader0mCause_of_DeathCause of DeathDetailmLocal_Treatment_CentreLocal Treatment CentremGeneral_CommentsGeneral CommentsmText46mAgemNamemText37GroupFooter0mText51mText53PageFooterSectionmText18ReportFootermText79dLabel80 Expr1!Expr2"Expr1002#Date of Death$Current Disease Statedefgjlm5K[noprfdmmddffdddddmmmmmmmmmmmdͬgA؀BeK /ReportHeaderfLi18[ebۄJs>0Blob PropDataacTypeInfod080:<=Bb cb$e g6hij3k+@MMc3FCS Ub T E#M_qju@qryPriorityList:ՙ3I҃ocjb T E#M_qCurrent Disease Stateg#^ I>1*b T E#M_qLocal Health FacilityρcMЎݍG|b T E#M_qGeneral CommentsS*M+L:hWFb T E#M_qNamemo-pB+YtBeb T E#M_qMedication qryPriorityList"RHD Priority List Arial8b$,h(߁ 4dLetter PRIV d4  yArialP _splmf01.exeZdArialdEOSCK&DUSB001d278d eTimes New Romane24bRcRfbg37bcjghlbc g[m5Cbg[ Arialn=cdh[ Arialo3Aej[ Arialp4bcrcd *Current Disease State*Local Health FacilityMedication`ReportHeaderO|f2a9b1# Line17^ld{HKRd2aibycdLabel20>Rheumatic Heart Disease Report h9LԿ[ m;<F`aWbc,i 6K[Text22 =Now()Long DateTimes New RomanɮOFy:daWbc,eLabel23Report Date:DetachedLabel |~}8EHbm<Fabxc[i jk Text48N=[Current Disease State] & " " & "List"Times New Roman\Fo"R`"PageHeaderSectionUiCf Nx"Ld`xaWbtc,e First Name_LabelNameDetachedLabel First_Name_LabelW3J;9:Zd` aZb c,e,General Comments_Label NotesDetachedLabel,General_Comments_Label[ZH`1Ugf2ab1# Line18Rn\xMs*Of2ab1# Line19vUDޝ`GroupHeader0ZBD1'I~qLi`aGroupHeader1l< O4m0<F`KaKb} cJi 33,Local Treatment Centre*Local Health FacilityTimes New Roman,Local_Treatment_Centrejw8JqYo`, Detail g93N ¹mF` bBcei General Comments General Comments General_Comments"CdpLQDmF`b/ ci kNameNameVhg7EoC$*`GroupFooter0o&_ՑkC5Y"m;<F`5!a<bc#i j Text27=Count(*)Times New RomanCg{Auù:m;<F`,a<bc#i jk Text46V=[Current Disease State] & " " & "Total - "Times New Roman$">*F$ Y"`"PageFooterSectiondI+am ;<F`Habc,i j Text16H="Page " & [Page] & " of " & [Pages]Times New RomansM?He`ReportFooterPeE"Fc!ne17dLabel20mText22dLabel23mText48PageHeaderSectiondFirst_Name_LabelFirst Name_LabeldGeneral_Comments_LabelGeneral Comments_Labelf Line18f Line19 GroupHeader0 GroupHeader1m Local_Treatment_CentreLocal Treatment CentreDetailmGeneral_CommentsGeneral CommentsmNameGroupFooter0mText27mText46PageFooterSectionmText16ReportFooterCurrent Disease StateExpr1001Local Health FacilityMedicationdefgjlmnoprfdmdmddffmmmmmmBlobDelta 24gpJs?D0Blob PropDatafh080:<=Bb cQ$e g#hij2k-T!@b I]+. UTϡUEerP3\͝g@qryHealthFacilityListg#^ I>1*TϡUEerP3Local Health Facility:ՙ3I҃ocjTϡUEerP3Current Disease StateXJÉOyTϡUEerP3Date of BirthQIAE7K[\?VTϡUEerP3Address/PhoneS*M+L:hWFTϡUEerP3Name3s>'WO+؃Pyb I]+Disease Severity *qryHealthFacilityList*Treatment Centre List Arial8Q$,h(߁ 4dLetter PRIV d4  yArialP _splmf01.exeZdArialdEOSCK&DUSB001d278d eTimes New Romane24bRcRfbg37bcjghlbc g[m5Cbg[ Arialn=cdh[ Arialo3Aej[ Arialp4bcrcd *Current Disease StateName`ReportHeaderI(ZG.[-{Wzf2a9b# Line15CӢ1,NէWd2aib#cdLabel20>Rheumatic Heart Disease Report Mj^KF܀mm;<F`aubci Text22 =Now()Long DateTimes New Romanʒ=NL b{daubceLabel23Report Date:DetachedLabelpPF gm;<Fa b#chi jk Text18݈="ARF and RHD Cases Registered from" & " " & [Local Health Facility]Times New Romanvk=6ܔK栘`"PageHeaderSection`GDs?Ed`"a9bvc,e First Name_LabelNameDetachedLabel First_Name_LabelyoDSl(Hd`2 a9bc,e&Date of Birth_LabelDate of BirthDetachedLabel&Date_of_Birth_Label~TtC]8Vd`9a<bvc,eAddress_Label&Contact InformationDetachedLabel5G΂.M wf2b# Line16l޷B{<f2ab# Line17ޅ8\jC<i\5W`wGroupHeader0n@-/F_Km0;<F`<a-bcJe%i Disease Severity*Current Disease StateTimes New Roman Disease_Severity3s>'WO+؃Py`,8K[ Detail#CfH}Km;F`2 abci Text23T=Format$([Date of Birth],"d mmm yyyy",0,0)\DG+t=mF`9ab8ci kAddress/PhoneAddress/PhoneAddress_Phone՘)G19m;<F` ab5cJi j Text79=Count(*)Times New Roman{jAh!@8=d7`ab cJd Label80 TOTAL IN REPORT:j B=TvTypeInfoiBlobDelta25`plw;t\a2Blob lͬiC}@.3MReportHeaderfLine15dLabel20mText22dLabel23mText18PageHeaderSectiondFirst_Name_LabelFirst Name_LabeldDate_of_Birth_LabelDate of Birth_Labeld Address_Labelf Line16f Line17 GroupHeader0m Disease_SeverityDisease SeverityDetailmText23mAddress_PhoneAddress/PhonemText34GroupFooter0mText27mText30PageFooterSectionmText14ReportFootermText79dLabel80Current Disease StateExpr1001NameDate of BirthLocal Health Facilitydefgjlmnoprfdmdmdddffmmmmmmmmdͬa[$fHO&ReportHeaderfLine15dLabel16mText17dLabel29mText75PageHeaderSectiondName_LabeldContact_Information_LabelContact Information_Labelf Line16f Line17d Label69d Comments GroupHeader1mMedicationDetailjDefault08:<=Bb c1e gYhijm8k)M?[!@`iKF 2x USiAZT[8@qrySecondaryProphylaxisList(Health Facility)g#^ I>1*SiAZLocal Health Facilitymo-pB+YtBeSiAZMedicationɩPKAeZ(SiAZDefaultρcMЎݍG|SiAZGeneral CommentsQIAE\?VSiAZAddress/PhoneS*M+L:hWFSiAZNameA@$O9R`iKF 2Medication XqrySe9K[condaryProphylaxisList(Health Facility)VSecondary Prophylaxis (by Treatment Centre) Arial81,h(& 4dLetter PRIV d4  yArialP _splmf01.exeZdArialdEOSCK&DUSB001d278d eTimes New Romane24bRcRfbg37bcjghlbc g[m5Cbg[ Arialn=cdh[ Arialo3Aej[ Arialp4bcrcd vbMedication`ReportHeaderh4~!GNf2a9b#1 Line15˝5D!wZ d2aibL,cdLabel16o6m ;<F`abc,i j Text14H="Page " & [Page] & " of " & [Pages]Times New Romany][MP`oReportFooter~p[6}M7`m;<F`w.abcJi j Text79=Count(*)Times New RomannE7A|d7`r$ab cJd Label81 TOTAL IN REPORT:&缙,I]/?@BmjmmmmmmmdFrepPercentWith80%orMoreCompliance>repBenzathinePenicillinReport"repSurgeryAppts6repMedicalSpecialistAppts0repEchocardiogramAppts(repCasesRegisteredrepDeaths "repPriorityList^repSecondaryProphylaxisList(Treatment Centre)0repTreatmentCentreList`repBenzathinePenicillinReport(Health Facility) repDentalAppts 1CB0 3CB0 24CB0 25CB0 18CB0 13CB0 8CB0 2CB0 0CB0 5CB0 4CB0 6CB0Prop;K[Dataoq DirDataCopyrPropDataCopyScripts2Jj 9b1>repBenzathinePenicillinReport"repSurgeryAppts6repMedicalSpecialistAppts0repEchocardiogramAppts(repCasesRegisteredfBenzathine Penicillin Compliance Average (ByYear)repDeaths "repPriorityList^repSecondaryProphylaxisList(Treatment Centre)0repTreatmentCentreList`repBenzathinePenicillinReport(Health Facility) 3CB0 24CB0 25CB0 18CB0 13CB0 6CB0 8CB0 2CB0 0CB0 5CB0 4CB033$(2HEALTH FACILITY00vadzPc5/Blob PropDatauw! BlobDelta$(PATIENT FORM0-1033$(PATIENT FORM0-1033DH2Benzathine Pencillin Compliance02t|z0%Is0%IsBlob "tPropDatay{$ BlobDelta3} QIsIsBlob ~%BlobDelta6x Is IsBlob (&BlobDelta9ǚIsǚIsBlob<K[ -f33"2PATIENT FORM0DH2Benzathine Pencillin Compliance0$(PATIENT FORM0-1033  00200-133 $*BlobDelta15dz`0a/Blob /PropData2 .HEALTH FACILITY0-10"2PATIENT FORM0AutoExecFind Record (Close Patient Form$Close Compliance8Open Treatment Centre Edit:Close Treatment Centre Edit 0CB0 15CB0 3CB0 6CB0 9CB0 BlobDeltaDirData3PropData7HDirDataCopy92CB0:Close Treatment Centre Edit8Open Treatment Centre Edit$Close Compliance,Close Ethnicity Edit(Close Patient Form:Close Place of Surgery EditFind Record *Open Ethnicity Edit 8Open Place of Surgery Edit AutoExec 0CB0 15CB0 3CB0 6CB0 9CB0 2CB0 13CB1 12CB1 7CB1 5CB1ijMSysDbPropDataCopyAxPropDataCDatabasesJj 9b10JjJjBlob DirDataDCustomGroups=K[JjJjDataAccessPages JjJj>xvClinical PresentationScreening ProgrammeSchool Health CheckPost Mortem v@M^YbYMJ^fiQkQbmJmYdbUfdkm`dimQ`UkMWdd^WQJ^mWMWQM\UkMiQQbYbUfidUiJ``QUxYNxx Y dCause of Death  @ @ @ @ @ @ @ @   ! " #$%&'()*+,-./012345 6!7"8#9$:%;&<'=(>)?*@+A,B-C.D/E0F1G2H3I4J5K6L7M8N9O:P;Q<R=S>TS YNZZY  Y Y U  Y  Ԃ Y Ղ Y UId LValueObjectGuidObjectNameProperty Value U UZ[U ԉ U UZ\U ԁ U UZ]U ԁYYYId$ObjectGuidProperty$ObjectNamePropertyZHv1b  Y Y Y qYN__Y Y  Y Y Y Y UY Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start Width U U_`U Ԁ U U_aU ԉYY Index1PrimaryKeyv1 ^ ^ YN  cc Y Y Y Y  Y  Y Y Y  Y Y  Y   Y   Y  eDateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelimcdˉYPrimaryKeyv1 bFHl- p * \  \ 2 B n 1 Y;GOoE[^4O%FG  tblPatientForm.[Address/Phone]= gG  tblPatientForm.[Date of Birth]= gG tblPatientForm.Name2 gG L@f gG tblPatientForm--- G  G  GF R@f 'F  Expr2[Please Enter END Date]@ oF Expr1[Please Enter START Date]C oF tblPatientForm.[Dental Date]; gF B@f gF L@f gF  tblPatientForm.[Address/Phone]= gF  tblPatientForm.[Date of Birth]= gF tblPatientForm.Name2 gF L@f gF tblPatientForm--- F  F  GE  tblPatientForm.[Date of Death]= 'E `@ f 'E  B@ f gE  tblPatientForm.Gender4 gE L@ f gE !tblPatientForm.[Cause of Death]> gE  tblPatientForm.[Date of Death]= gE Age@ f# oE tblPatientForm.Name2 gE tblPatientForm.Name2 gE Expr2[Please enter End Date]@ oE Expr1lease enter Start Date]B oE tblPatientForm--- E  E  GD Compliance (%)@ f9-- oD Z@f gD Z@f gD tblCompliance.Year1 gD tblCompliance.PID0 gD tblCompliance+++ D  D  GC H@f gC Median@f) oC MaxOfCompliance (%)j@fC77 oC MinOfCompliance (%)j@fC77 oC AvgOfCompliance (%)j@fC77 oC H@f gC qryBenzathinePenicillinReportKKK C  C  GB @f 'B  Age at Death@5)) oB tblPatientForm.Case2 gB tblPatientForm.Case2 gB Age at Registration@C77 oB Expr2[Enter End Date]9 oB Expr1[Enter Start Date]< oB  tblPatientForm.[Date of Death]= gB L@ gB tblPatientForm.Name2 gB tblPatientForm--- B  GB  GB  B  GA @ 'A tblPatientFormqryComplianceCalculation^@i]- A  tblPatientForm.Default5 gLVALV x  : T  f:`Z r0tblPatientForm.[General Comments]tblPatientForm.[Local Health Facility]tblPatientForm.[Current Disease State](((tblPatientForm.[Local Health Facility])=[Please enter name of Health Facility]) AND ((tblPatientForm.[Date of Death]) Is Null))tblPatientForm.[Local Health Facility]tblPatientForm.[Current Disease State]((([Please Enter START Date])<tblPatientForm![Echocardiogram Date]) And (([Please Enter END Date])>tblPatientForm![Echocardiogram Date]) And ((tblPatientForm.[Date of Death]) Is Null))tblPatientForm.[Echocardiogram Date]tblPatientForm.[General Comments]tblPatientForm.[Local Health Facility]tblPatientForm.[Current Disease State]((([Please Enter START Date])<tblPatientForm![Dental Date]) And (([Please Enter END Date])>tblPatientForm![Dental Date]) And ((tblPatientForm.[Date of Death]) Is Null))tblPatientForm.[General Comments]tblPatientForm.[Local Health Facility]tblPatientForm.[Current Disease State]((([Please enter Start Date])<tblPatientForm![Date of Death]) And (([Please enter End Date])>tblPatientForm![Date of Death]) And (Not (tblPatientForm.[Date of Death]) Is Null))tblPatientForm.[General Comments]tblPatientForm.[Current Disease State]DateDiff("yyyy",[date of birth],[date of death])+Int(Format([date of death],"mmdd")<Format([date of birth],"mmdd"))([Injections Received (Jan-Dec)]/[Injections Required (Jan-Dec)]*100)tblCompliance.[Injections Received (Jan-Dec)]tblCompliance.[Injections Required (Jan-Dec)][qryBenzathinePenicillinReport].YearFormatNumber(DMedian97("[qryComplianceReport]","[Compliance (%)]","[Year] = '" & [Year] & "'"),1)Max([qryBenzathinePenicillinReport].[Compliance (%)])Min([qryBenzathinePenicillinReport].[Compliance (%)])Avg([qryBenzathinePenicillinReport].[Compliance (%)])[qryBenzathinePenicillinReport].Year((([Enter Start Date])<[tblPatientForm]![Registration Date]) AND (([Enter End Date])>[tblPatientForm]![Registration Date]))h @ @ @ @ @ @ @ @ @ @ @ @ @ @""""####$$ $ $ % %%% &&&&&&''''(((((() )")#)!*$*&*'*%+(+*+++),,,.,/,--0-2-3-1.4.6.7.8. 9.5/:/0@0A0?1B1D1E1C2F2H2I2G3J3L3M3K4N4P4Q4O5R5T5U5V5W5S6X6Z6[666Y7777888 89 9 9 999 ::::::;;;;<<<<== =!=>">$>%>#?&?(?)?*?+?,?-?.?/?0?1? 2?'@3@5@6@7@8@9@:@;@<@=@>@ ?@@@A@4ABADAEAFAGAHAIAJAKALAMA eAeAeACBeBeBeBeBeBe Be Be Be Be BeBeB eBeBeCeCeCeCeCeCeCeC eCeDeDeDeDeDe De!De"DeEe#Ee%Ee&Ee'Ee(Ee)Ee$Cgl @ @ @ @ @ @ @ @ @ @ @ @ @ @99 ::::::;;;;<<<<== =!=>">$>%>#?&?(?)?*?+?,?-?.?/?0?1? 2?'@3@5@6@7@8@9@:@;@<@=@>@ ?@@@A@4ABADAEAFAGAHAIAJAKALAMA eAeAeACBeBeBeBeBeBe Be Be Be Be BeBeB eBeBeCeCeCeCeCeCeCeC eCeDeDeDeDeDe De!De"DeEe#Ee%Ee&Ee'Ee(Ee)Ee*Ee+Ee,Ee-E e.E e/Ee0E e1Ee$Fe2Fe4Fe5Fe6Fe7Fe8Fe9Fe:Fe;FeFe3Ge?GeAGeBGeCGeDGeEGiGiGiGiG iGiGe@HiHiHi Hi Hi Hi Hi HiHiHiHiHiIiIiIiIiIiIiIiIiIiIiI iIiIiJiJi!Ji"Ji#Ji$Ji%Ji&J i'Ji Ki(Ki*Ki+Ki,Ki-Ki.Ki/Ki0Ki1Ki2Ki3Ki)Li4Li6Li7Li8Li9Li:Li;LiLi?Li@L iALi5MiBMiDMiEMiFMiGMiHMiIMiJMiKMiLMiMMiC6N2aC  a  y [ =  P  8 g I zPU+>r8u+k,zP}S)M tblPatientForm.[Surgery Date]< gM B@ j gM L@ j gM  tblPatientForm.[Address/Phone]= gM  tblPatientForm.[Date of Birth]= gM tblPatientForm.Name2 gM L@ j gM tblPatientForm--- M  GM  GM  M  GL tblPatientForm.Name2 'L @ j 'L B@ j gL tblPatientForm.Default5 gL L@j gL  tblPatientForm.[Address/Phone]= gL tblPatientForm.Medication8 gL tblPatientForm.Name2 gL tblPatientForm.Name2 gL tblPatientForm--- L  GL  GL  L  GK 8@j 'K B@j gK tblPatientForm.Medication8 gK L@j gK tblPatientForm.Name2 gK tblPatientForm.Name2 gK L@j gK tblPatientForm--- K  GK  GK  K  GJ qryComplianceCalculation.Year< gJ f@j 'J Num>80%F@j+ oJ qryComplianceCalculation.Year< gJ qryComplianceCalculationAAA J  GJ  GJ  J  GI @j 'I  Expr2[Please Enter END Date]@ oI Expr1[Please Enter START Date]C oI P@j gI B@f gI L@f gI  tblPatientForm.[Address/Phone]= gI  tblPatientForm.[Date of Birth]= gI tblPatientForm.Name2 gI L@f gI tblPatientForm--- I  I  GH @f 'H L@f gH  tblPatientForm.[Address/Phone]= gH  tblPatientForm.[Date of Birth]= gH tblPatientForm.Name2 gH tblPatientForm.Name2 gH L@f gH tblPatientForm--- H  GH  GH  H  GG r@f 'G  Expr2[Please Enter END Date]@ oG Expr1[Please Enter START Date]C oG H@f gG B@f gG L@f g|LVAL. 6 p $ ( NCount(qryComplianceCalculation.PID)((([Please Enter START Date])<[tblPatientForm]![Surgery Date]) AND (([Please Enter END Date])>[tblPatientForm]![Surgery Date]) AND ((tblPatientForm.[Date of Death]) Is Null))tblPatientForm.[General Comments]tblPatientForm.[Local Health Facility]tblPatientForm.[Current Disease State]((Not (tblPatientForm.Medication) Is Null) AND ((tblPatientForm.[Local Health Facility])=[Please enter name of Health Facility]) AND ((tblPatientForm.[Date of Death]) Is Null) AND ((tblPatientForm.[Date ceased]) Is Null))tblPatientForm.[General Comments]tblPatientForm.[Local Health Facility](((tblPatientForm.[Current Disease State])=[Please enter 'Current Disease State' category, eg ARF (no RHD)]) AND ((tblPatientForm.[Date of Death]) Is Null))tblPatientForm.[General Comments]tblPatientForm.[Local Health Facility]tblPatientForm.[Current Disease State](((qryComplianceCalculation.[Compliance (%)])>=80))Count(qryComplianceCalculation.PID)((([Please Enter START Date])<tblPatientForm![Medical Specialist Date]) And (([Please Enter END Date])>tblPatientForm![Medical Specialist Date]) And ((tblPatientForm.[Date of Death]) Is Null))tblPatientForm.[Medical Specialist Date]  c9s* N qryComplianceCalculation.Year< gN TotalF@j' oN qryComplianceCalculation.Year< gN qryComplianceCalculationAAA N  GN  GN  N  GM ^@j 'M  Expr2[Please Enter END Date]@ oM Expr1[Please Enter START Date]C oWh @ @ @ @ @ @ @ @ @ @ @ @ @ @ @Ee+Ee,Ee-E e.E e/Ee0E e1Ee$Fe2Fe4Fe5Fe6Fe7Fe8Fe9Fe:Fe;FeFe3Ge?GeAGeBGeCGeDGeEGiGiGiGiG iGiGe@HiHiHi Hi Hi Hi Hi HiHiHiHiHiIiIiIiIiIiIiIiIiIiIiI iIiIiJiJi!Ji"Ji#Ji$Ji%Ji&J i'Ji Ki(Ki*Ki+Ki,Ki-Ki.Ki/Ki0Ki1Ki2Ki3Ki)Li4Li6Li7Li8Li9Li:Li;LiLi?Li@L iALi5MiBMiDMiEMiFMiGMiHMiIMiJMiKMiLMiMMkM kMkMiCNkNkNkNkNkNk N k Nk YU U U NnnY  Y UdY Y PIDYear:Injections Required (Jan-Dec):Injections Received (Jan-Dec)U U Uno UnpYYPIDPrimaryKeyv1 m m$YN rrY  Y (Y  Y  ( Y dY   Y U Y  d Y  Y  UDY  Y  Y  $ Y  U, Y U Y   Y  Y  ,Y  Y  4Y  <Y  DY  LY  T Y  dY  \ Y  U dPIDHealth Number"Registration Date*Current Disease StateNameDate of Birth Gender*Local Health FacilityAddress/PhoneMedicationDate startedDate ceasedDate of DeathCause of Death General CommentsDefaultCase$Valve Surgery Date"Requires Warfarin.Medical Specialist Date&Echocardiogram DateDental DateSurgery DateARF DiagnosisARF Found byRHD DiagnosisRHD Found byrsPUrtruYYYHospital NumberPIDPrimaryKeyv1  q q qY