Standard Jet DBnb` Ugr@?~1y0̝cßFNg7؜H(*`{6{߱hCA33y[)|*| Ţf_Љ$g'DeFx -bT4.0dv YS  Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypex"@ ReYYIdParentIdName        OYvt v SY Y Y  Y 2xACMFInheritableObjectIdSID YObjectId Y0<0<SY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order Y"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/  P  D 0(*(*KK@@ +kh+MSi`kJmYkSJMmYdbkoiqQv+kh+MMLdYbkmioMmdi: Sdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`JffdYbm`Qbm^dU+kh+MMd`LdDF+kh+MSi`JffdYbm`Qbm^dU+kh+MSi`JffdYbm`QbmmvfQk+kh+MSi`JffdYbm`Qbm^dU+kh+M^YkmD>+kh+MSi`Sd^^dsof:bO+kh+ML^ddOU^oMdkQSiQhoQbMv+kh+MSi`Sd^^dsof:bO+kh+MSiQhoQbMvdSQuQiMYkQ+kh+MSi`Sd^^dsof:bO+kh+MkQ^SSddmQuJ`mvfQ+kh+MSi`Sd^^dsofiQfdimk+kh+Mmum^dMJmYdb+kh+MSi`fJmYQbmYbSd+kh+MMd`Ld86H+kh+MSi`fJmYQbmYbSd+kh+MMd`Ld8:D+kh+MSi`fJmYQbmYbSd+kh+MMd`Ld:@H+kh+MSi`fJmYQbmYbSd+kh+MMd`Ld:B@+kh+MSi`fJmYQbmYbSd+kh+MMd`Ld<6<+kh+MSi`fJmYQbmYbSd+kh+MMd`LdFD+kh+MSi`fJmYQbmYbSd+kh+MMd`LdH@+kh+MSi`fJmYQbmYbSd+kh+MMd`LdHD +kh+MSi`fJmYQbmYbSd+kh+MMd`LdfWvkYMYJb^dd\of!+kh+MSi`fJmYQbmYbSd+kh+MMoiiQbmOYJLQmQk`QOk"+kh+MSi`fJmYQbmYbSd+kh+MOYJLQmQkmvfQ#+kh+MSi`fJmYQbmYbSd+kh+MSi`Sd^^dsof8km$+kh+MSi`fJmYQbmYbSd+kh+MSi`Sd^^dsof:bO+kh+MSi`fJmYQbmYbSd+kh+MSi`^JLiQko^mk+kh+MSi`fJmYQbmYbSd+kh+MSi`sd`Qbdb^v`QOYMJ^WYkmdiv+kh+MSi`fJmYQbmYbSd+kh+M^Ykm8<+kh+MSi`fJmYQbmYbSd+kh+M`JiYmJ^kmJmok+kh+MSi`fJmYQbmYbSd+kh+MfiY`JivJbMQkmiv+kh+MSi`fJmYQbmYbSd+kh+MfiY`JivYbkoiJbMQ+kh+MSi`fJmYQbmYbSd+kh+MiJMQ+kh+MSi`fJmYQbmYbSd+kh+MkQMdbOJivYbkoiJbMQ+kh+MSi`fJmYQbmYbSd+kh+MkQ^SSddmQuJ`mvfQ +kh+MSi`kJmYkSJMmYdbkoiqQv+kh+MMLdYbkmioMmdi8 +kh+MSi`kJmYkSJMmYdbkoiqQv+kh+MMLdYbkmioMmdi: +kh+MSi`kJmYkSJMmYdbkoiqQv+kh+MMLdYbkmioMmdi< +kh+M`JYb`Qbo+kh+MM^JkkYbOQu +kh+M`JYb`Qbo+kh+M^dMJmYdb+kh+M`JYb`Qbo+kh+MfJmYQbmYbOQuJUQMJ^Mo^JmYdbkOYJUbdkYkMJ^Mo^JmYdbk`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkbd^dU+<+JmmQbOQObd^dU+>+Md`f^QmQObd^dU+@+iJMQkQubd^dU+B+iJMQJUQbd^dU+D+iJMQOuksYmMWLdJiOYmQ`kmL^JUQiJbUQkmL^JffdYbm`Qbm^dUmL^JffdYbm`QbmkmJmokmL^JffdYbm`QbmmvfQbJ`QkmL^JffdYbm`QbmmvfQkmL^M^Jkk^YkmmL^M^JkkidkmQi mL^MoiiQbmOYJLQmQk`QOk!mL^OYJLQmQkmvfQk"mL^QOoMJmYdbf^JbNmL^QOoMJmYdbmvfQkNmL^QuQiMYkQSiQhoQbMvNmL^Sd^^dsofLUiJbUQkNmL^Sd^^dsofLUmQkmSiQhoQbMvNmL^Sd^^dsofOYJLQmQkMJmQUdiviJmYbUkNmL^Sd^^dsofQuQiMYkQSiQhoQbMvNmL^Sd^^dsofSiQhoQbMYQkNmL^Sd^^dsof`JbJUQOYJLQmQkiJmYbUkNmL^Sd^^dsof`QOSiQhoQbMYQkN mL^Sd^^dsofiJmYbUkN mL^Sd^^dsofkN mL^Sd^^dsofkQ^SSddmQuJ`mvfQkN mL^UdJ^mvfQkN mL^YbkmioMmdi^YkmNmL^YbkoiJbMQmvfQkNmL^^JLiQko^mkNmL^^JLmQkmkNmL^^dMJmYdbfYM\^YkmNmL^^dMJmYdbkNmL^`JiYmJ^kmJmokNmL^`QOYMJmYdbmvfQkNmL^`QmQimvfQkNmL^bQsfJmYQbmYbSdSYQ^OkNmL^fJmYQbmYbSdNmL^fJmYQbmfQikdbJ^YbSdNmL^fWvkYMYJb^YkmNmL^fiY`JivJbMQkmivNmL^fidUiJ`bJ`QNJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @           !"#$ !"#$%& ' ( ) * +,-./012345678 9 : ; < =>?(,048<@C F!I"LNPNSNWN\N`NeNkNoNtN xN }N N N NNNNNNNNNNNNNNNNNNN N!N"N#N$N%N&N' @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% 5 6 7 8 9 : ; < = > ? @ A B CDEFGHIJKLMNOP      !"#$%&'( ) * +!,!-!."/"0"1#2#3#4$5$6$7%8%9%:&;&<&='>'?'@(A(B(C)D)E)F*G*H*I+J++,,,---.. . ///00 0!1"1#1$2%2&2'3(3)3*4;4<4=5>5?5@6A6B6C7D7E7F8G8H8I9J9%9%:%:%:%;&;';(<)<*<+=,=-=.>/>0>1?2?3?4   (+(,(-,.,/,0010203444546878889<:<;<<@=@>@?C@CACBFCFDFEIFIGIHLIL L P P P S S S W W W \ \ \ ` ` ` e e e k k k o o o t t t x x x } } !} " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I/01234 J      !"#$%&'()*+,-.56789:  !"##//"                 !" #%&$')*(+-.,/12345678 9 : ;0<>?=@BC DAEGHFIKLMN OJPRSTQ         ! !"!$!%! &!#"'")"*"(#+#-#.# /#,$0$2$3$ 4$1%5%7%8% 9%6&:&<&=&;'>'@'A' B'?(C(E(F( G(D)H)J)K) L)I*M****N++++,, , , , ,  , ,------------- - -.. .!.".#.$.%.&.'.(.). *. +. ,. -...// @@+ 8@JO8B>O>FOQFBQHD6MJ@8J6<<6H+ +;K[+ :MF@FD6MO>OO>:LLFDO::D66B:QQHH<<+ +;K[+ >HJ8M68SL@SS>6>BJ>QQ:8FM:SMOSJHJ+ +;K[+ H8DH:BM68O>O>H:SH6FOH6:M@8HHQ:L>+ +;K[+ LQLHQBMD6OBD>LSBF8HO@L@QM< /@/@MSysRelationshipswDDDDDDDDDDB /@/@MSysQueriesw88888888886 /@/@MSysACEsw22222222220 /@/@MSysObjectsw88888888886 /@O@MSysDbu@:::......., @/@/@Relationshipsw<<<<<<<<<<: /@/@Databasesw44444444442 /@/@Tablesw..........,  U~T6z Z <  r T  b D &  p * ^ @ " n8R(b8b*f ^4\>TblCurrentDiabetesMedsFrmPatientInfoYY=   G__Patient Number111 O  G J@ 'Expr1j@' oB@  gTblPhysicianList111  G  GL@  gtblTestFrequencyList999   G tblMeterTypes.MeterTypes7 'tblMeterTypes.MeterTypes7 gtblMeterTypes+++   GtblEducationTypes333   G  G N@  ' F@  ' D@  'TblPatientPersonalInfoTblPatientInfo@eY= TblPatientPersonalInfoTblPatientInfo@eY= N@ gF@ gD@ gTblPatientInfo--- TblPatientPersonalInfo===  G  GtblGoalTypes.GoalTypes5 gtblGoalTypes)))   G",tblGoalTypes.GoalTypes5 g",tblGoalTypes))) ", ", G","tblSkinProblemsList.SkinProblems? g",tblSkinProblemsList777 ", ", G",tblExerciseFrequency999  ", G", ", G",tblTempLocations111  ", G", ", G",J@ g",tblSelfFootExamTypes999 ", ", G",tblExerciseFrequency999  ", G", ", G ",L@ g 4",tblTestFrequencyList999  4",  ", G 4",tblLocations)))   ", G 4",  ", G @ ' TblAppointmentTypesFrmAppointmentLogYY7    G __Appointment Date555 O __Patient Number111 O    G L@ g tblAppointmentStatus999     GLVAL&l(  x 4 T  ^  t * Rz,4>pTblPatientInfo.[Patient Number]=[Age calculations].[Patient Number]IIf([T118]=1,"Type 1 0-18",IIf([T119]=1,"Type 1 19 up",IIf([T218]=1,"Type 2 0-18",IIf([T219]=1,"Type 2 19 up",IIf([GDM]=1,"GDM",IIf([PDM]=1,"PreDM",IIf([Oth]=1,"Other","Unk")))))))IIf([Diabetes Type]="DM Difficult to Classify",1,0)IIf([Diabetes Type]="Pre-Diabetes",1,0)IIf([Diabetes Type]="Gestational",1,0)IIf(([Diabetes Type]="Type 2, With Insulin" Or [Diabetes Type]="Type 2, Without Insulin") And [19up]=1,1,0)IIf(([Diabetes Type]="Type 2, With Insulin" Or [Diabetes Type]="Type 2, Without Insulin") And [18]=1,1,0)IIf([Diabetes Type]="Type 1" And [19up]=1,1,0)IIf([Diabetes Type]="Type 1" And [18]=1,1,0)IIf([18]=1,"0-18",IIf([1944]=1,"19-44",IIf([4564]=1,"45-64",IIf([65up]=1,"65&up","Unk"))))([Admission Date]-[Birthdate])/365TblPatientPersonalInfo.[Admission Date]TblPatientPersonalInfo.[Patient Number]TblPatientPersonalInfo.[First Name]TblPatientPersonalInfo.[Last Name]TblPatientPersonalInfo.[First Name]TblPatientPersonalInfo.[Last Name]TblPatientPersonalInfo.[Patient Number]tblSelfFootExamTypes.SelfFootExamType([__Patient Number] = [Patient Number])([__Patient Number] = [Patient Number])([__Patient Number] = [Patient Number])TblPhysicianList.[PHYSICIANLAST NAME][PHYSICIANLAST NAME] & ", " & [PHYSICIAN FIRST NAME]TblPhysicianList.[PHYSICIAN CODE]tblTestFrequencyList.TestFrequencyListTblPatientPersonalInfo.[Patient Number]TblPatientPersonalInfo.[First Name]TblPatientPersonalInfo.[Last Name]TblPatientPersonalInfo.[Patient Number]=TblPatientInfo.[Patient Number]TblPatientPersonalInfo.[Patient Number]=TblPatientInfo.[Patient Number]TblPatientPersonalInfo.[Patient Number]TblPatientPersonalInfo.[First Name]TblPatientPersonalInfo.[Last Name]tblSelfFootExamTypes.SelfFootExamTypetblTestFrequencyList.TestFrequencyList(([__Patient Number] = [Patient Number])) AND ([__Appointment Date] = [Appointment Date])tblAppointmentStatus.AppointmentStatusO\J, j L  L .  ` 6  0  R 4  D&l,xZ,~>l&4|0x,* * G) [InstructorName]/ ')"tblInstructorList.InstructorName? g)tblInstructorList333 ) ) G( [InstructorName]/ '("tblInstructorList.InstructorName? g(tblInstructorList333 ( ( G' [InstructorName]/ ''"tblInstructorList.InstructorName? g'tblInstructorList333 ' ' G&J@ g&tblSelfFootExamTypes999 & & G% !tblInsuranceTypes.InsuranceType> '%!tblInsuranceTypes.InsuranceType> g%tblInsuranceTypes333 % % G$ tblRaces.Race, '$tblRaces.Race, g$tblRaces!!! $ $ G# !tblInsuranceTypes.InsuranceType> '#!tblInsuranceTypes.InsuranceType> g#tblInsuranceTypes333 # # G"tblPrimaryAncestry555 "  G" " G!  tblMaritalStatus.MaritalStatus= '! tblMaritalStatus.MaritalStatus= g!tblMaritalStatus111 ! ! G tblGoalTypes.GoalTypes5 g tblGoalTypes)))     GN@ 'TblWomenOnlyMedicalHistoryFrmPatientInfoaaE   G__Patient Number111 O  GN@ 'TblLabResultsFrmPatientInfoGG+   G__Patient Number111 O  G"([__Patient Number] = PatientID)? '~qryFollowup2ndFrmPatientInfoKK/   G__Patient Number111 O  G"([__Patient Number] = PatientID)? '~qryFollowup1stFrmPatientInfoKK/   G__Patient Number111 O  G "tblDiabetesTypes.[Diabetes Type]? '"tblDiabetesTypes.[Diabetes Type]? gtblDiabetesTypes111   GN@ '`#O3PLN L " KE l hIG}E(CJ^#AIL-QΑ@L-QΑ@tblDiabetesTypes@@@@@@@@@@@ IEg 0@W 0@tblDiabetesTypesu@NNNBBBBBBB@ @C<+Ag 0@7}= 0@TblClassRosteru@JJJ>>>>>>>< @@>g 0@? 0@TblClassListuW@FFF:::::::8 @<t̑@? j̑@TblAppointmentTypesu~@TTTHHHHHHHF @8 8g 0@>>>>>>< @2պKΑ@WLΑ@NoLog_6_RaceAgeu0@@XLL@@@@@@@> @1~^hGΑ@uIΑ@NoLog_5_RaceSexu@@XLL@@@@@@@> @/!9Α@a?Α@NoLog_3_Attendedue@@ZNNBBBBBBB@ @̑@̑@MSysAccessXMLu4MR2KeepLocal  T|||<<<<<<<: @ЁQΑ@ЁQΑ@MSysAccessObjectsuDDDDDDDDDDB .2͑@X}NΑ@Diagnosis calculationsu@@fZZNNNNNNNL @-~pe͑@\͑@Age calculationsu@|@ZNNBBBBBBB@ @+c0z@c0z@~sq_cMain Menu~sq_cLocationu4MR2KeepLocal TXXXXXXXV @*c0z@c0z@~sq_cMain Menu~sq_cClass Indexu4MR2KeepLocal T^^^^^^^\ @(@ 0@@ 0@~sq_cfrmSatisfactionSurvey~sq_ccboInstructor2u4MR2KeepLocal T|||||||z @'@ 0@c 0@~sq_cfrmSatisfactionSurvey~sq_ccboInstructor1u4MR2KeepLocal T|||||||z @%|A 0@|A 0@~sq_cFrmPatientInfo~sq_cSecondary Insuranceu4MR2KeepLocal Txxxxxxxv @$ 0@ 0@~sq_cFrmPatientInfo~sq_cRaceu4MR2KeepLocal TZZZZZZZX @" 0@ 0@~sq_cFrmPatientInfo~sq_cPrimary Ancestryu4MR2KeepLocal Trrrrrrrp @!ý 0@ý 0@~sq_cFrmPatientInfo~sq_cMarital Statusu4MR2KeepLocal Tnnnnnnnl @N 0@N 0@~sq_cFrmPatientInfo~sq_cFrmWomenOnlyMedicalHistoryu4MR2KeepLocal T @N 0@N 0@~sq_cFrmPatientInfo~sq_cfrmLabResultsu4MR2KeepLocal Tlllllllj @D> fH V ,  j @  L `  n 0 X}K!a+}S) c)s !0TblPatientPersonalInfoTblAppointmentTypes@ $oc= 0TblPatientPersonalInfoTblAppointmentLog@ $k_= 0TblPatientPersonalInfoTblPatientInfo@$eY= 0TblAppointmentLogTblPatientInfo@$[O3 0PastEdCnt@$/## o0PastEd@$) o0TblAppointmentTypes777 0TblPatientInfo--- 0TblAppointmentLog333 0TblPatientPersonalInfo=== 0 0 G/ @$ g/@$ '/TblPatientPersonalInfoTblPatientInfo@$eY= /PastEdCnt@$/## o/PastEd@$) o/TblPatientInfo--- /TblPatientPersonalInfo=== / / G.TblPatientInfoAge calculations@%YM- . DxGrph@$' o. Othf@## o. PDMN@"# o. GDML@!# o.T219@ % o.T218@% o.T119\@% o.T118X@% o.ge calculations].[19up]8 g.[Age calculations].[18]6 g. TblPatientInfo.[Diabetes Type]= g.!TblPatientInfo.[Patient Number]> g.Age calculations111 .TblPatientInfo--- . . G- AgeGrp@) o- 19upIIf([Age]>=19,1,0)9 o-65upIIf([Age]>=65,1,0)9 o-4564!IIf([Age]>=45 And [Age]<65,1,0)F o-1944!IIf([Age]>=19 And [Age]<45,1,0)F o-18 IIf([Age]>=0 And [Age]<19,1,0)A o-AgeD@# o-"TblPatientPersonalInfo.Birthdate? g-N@ g-N@ g-TblPatientPersonalInfo=== - G- G- - G, F@ ', D@ ',F@ g,D@ g,N@ g,TblPatientPersonalInfo=== , , G+tblLocations.[Location Name]; g+tblLocations))) + + G*TblClassList.[Class Name]8 g*TblClassList.[Class Number]: g*TblClassList)))  YNY Y DataIDrsseteYAOIndexv1K[D<HN03DTwSysAccessObjectsLLLLLLLLLLJ  T"@ zz:::::::8 @&b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b P] @ Pc  '    !     mb("HospiMSysAccounts    mLFPhysician Managed Pracx g    m*$Appointment Status  c ac c  ̑@̑@TblAppointmentLogDDDDDDDDDDB ge Date        & Telephone Number      m      "Street Address      m      lCity      m      n State      m      j Zip      m      p Gender      m      ZBirthdate        p E-mail      m       pDiQt LPrevious Diabetes Education!uJQڮpDiQt LEducation Location[4,L呜=wpDiQt LEducation DateBGGة$pDiQt LWho Referred You to Program=# NvpDiQt LDifficulty Readingݑ(FMp   Root Entry Ў*;VBA`Í+Ў*;VBAProjectpg+Ў*;VBApg+3;dir|_VBA_PROJECT_-PROJECTPROJECTwm  x0* pHddb1@= d  +H( J< rstdole>2stdole h%^*\G{00020430-;C 0046}#2.0#0#C:\WINDOWS\sys@tem32\e2.tlb#OLE Automation`hADODB> AADOBuDDE1!D10-8DAA006D2EA4D1DProgram Files\CommonSM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 LibraryHE ID="{E97D46FA-7D95-4C2E-94E9-FEAFBADC4C59}" Name="db1" HelpContextID="0" VersionCompatible32="393222000" CMG="A9ABF000F400F4am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#K[C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library +HP@6eZklқ TjѱU_Fr%0tS2jMJ!KNwyj`v,.j>|r_ñm@CI)??Ow\&ng[2XZ w nBAo>+F-C|uSOZsts})k7 %_n 4RAԠ 9;)@l%D9:hjŻqױ zpŽ)ӨT{7&;NK_g*m={0nG=d~Y[D3%P F&g@) uM麙 mAccess,DateVBAWin16~Win32MacVBA6#db1stdole`ADODBsForm_Class List  _EvaluatecmdDelete_ClickErr_cmdDelete_ClickDoCmdƧ DoMenuItem&e acFormBar acEditMenu acMenuVer70XExit_cmdDelete_Clickh;MsgBoxRErro Description Form_frmADAReportsLcmdADAReport_ClickCIsNull txtStartDatea txtEndDate̿ txtLocationi vbCritical+}RunMacroX OpenReport acViewPreview2 Form_Load{Formsfrmmdch-adareports Option8_ClicktxtEndDate_AfterUpdateȖtxtStartDate_AfterUpdateForm_frmAddPhysician#GoBacktoMainSwitchboardOption_Click~OpenFormacNormalForm_FrmAppointmentLog=vCmdOpenPatientInfoForm_Click  Err_CmdOpenPatientInfoForm_Clickj stDocNamezstLinkCriteriaYPatient Number!Exit_CmdOpenPatientInfoForm_ClickCmdAddAdditionalAppt_ClickvEErr_CmdAddAdditionalAppt_ClickK GoToRecordM6acNewRecYExit_CmdAddAdditionalAppt_Click Combo78_AfterUpdateHCombo78&FrmAppointmentTypesL+FrameAppointmentTypesEnabled۪CmdAddApptTypeSetFocus Form_CurrentflagFromWhatFormForm_FrmAppointmentTypesCmdAddNewApptType_ClickErr_CmdAddNewApptType_ClickOExit_CmdAddNewApptType_ClickYCmdAddApptType_ClickRnErr_CmdAddApptType_ClickR Exit_CmdAddApptType_ClickCForm_frmClassList_-Form_FrmClassRostera+ClassesComplete_Clickv SetWarnings OpenQuerycmdClassListForOne_ClickS acFormEditacDialogacmdSameClassDiffPatient_Click strClassNamet datClassDateW strLocation ErrorTrapQCombo16%Location-cmdAddNewRecord_Click&Number-Form_BeforeUpdateP-vbCr$cmdSamePatient_ClickY lonPatientNumCombo21_AfterUpdateScmdSaveRecord_Click:Err_cmdSaveRecord_Click acRecordsMenu6 acSaveRecordjExit_cmdSaveRecord_ClickEErr_cmdAddNewRecord_ClickI-Exit_cmdAddNewRecord_ClickFCombo21 &ClassesCompleteDLookupFCancel CancelEventURForm_FrmCurrentDiabetesMedsCmdAddAnotherMed_Click]Err_CmdAddAnotherMed_ClickiExit_CmdAddAnoK[therMed_Click)cmdDeleteMed_ClicknErr_cmdDeleteMed_Click܋Exit_cmdDeleteMed_ClickForm_frmEditPhysicianListcboPhysicianLookup*PHYSICIAN CODEcboPhysicianLookup_AfterUpdateRecordsetClone8 FindFirstM=BookmarkCForm_frmFollowup2nd!FollowupDate_BeforeUpdate{ PatientID!Form_frmFollowupReports^JForm_frmInstructorListForm_frmInsuranceTypesForm_frmLabResultscmdDeleteLab_Click!Err_cmdDeleteLab_ClickW/Exit_cmdDeleteLab_ClickForm_frmLabTests Form_frmLocations`B RunCommand`acCmdSaveRecord>Form_FrmMainSwitchboardg4 Form_GotFocuslonPatientNumber) Form_Open-Filter;FilterOn&CaptionxNzu^ItemText FillOptions conNumButtonsdbsǂrst RecordsetstrSQLF intOption8Option1Visible CurrentDbS SwitchboardID OpenRecordset|EOF OptionLabel1q) ItemNumberhGMoveNextL!HandleButtonClickExintBtn(conCmdGotoSwitchboardconCmdOpenFormAdd%conCmdOpenFormBrowseconCmdOpenReportconCmdCustomizeSwitchboardbconCmdExitApplicationconCmdRunMacroM conCmdRunCodewconErrDoCmdCancelledHandleButtonClick_Err dbOpenDynaset NoMatch/3Command]Argument= acPreviewo Application*Run_CloseCurrentDatabase3HandleButtonClick_Exitt Option4_ClickDCountForm_frmMDCH-ADAReports;cmdDiabetesAndYou_ClickucmdMDCHReport_ClickcmdPhysRefCount_Click^cmdSatisfactionSurvey_ClickForm_frmMedicationTypes68Form_frmMeterTypes?Form_FrmNewPatientLogCmdAddNewPatient_ClickErr_CmdAddNewPatient_Click9Combo54~&Exit_CmdAddNewPatient_Click$CmdAdd_View_Add_l_Patient_Info_ClickUacFormCombo54_AfterUpdate Error_Trap TimerInterval?cacCmdRecordsGoToNewflagFromPatientInfo Form_Timeri`Last_Name_AfterUpdate,RequeryValueK First NameVForm_FrmPatientfPersonalInfoAdmission_Date_LostFocusAdmission DateʋBirthdate_AfterUpdatee Birthdate  vbInformationnForm_FrmPatientInfovcmdGoBacktoApptLog_ClickcUCombo303Combo249_AfterUpdateFollow-upDate3MoLCombo259_BeforeUpdateList13(Combo259FCombo263_AfterUpdate&uCombo265_BeforeUpdateCombo265gCombo269_AfterUpdateLQCombo303_AfterUpdate Diabetes Type;4DAOAddNewaUpdateRecommendedDatesDRecA1cTest_Click RecA1cTestgRecA1cTestDate^ RecA1cTestMetLlblRecA1cTestMetNRecCholesterolTest_ClickyRecCholesterolTestRecCholesterolTestDateJRecCholesterolTestMetlblRecCholesterolTestMet^RecDentist_Click RecDentist RecDentistDatec RecDentistMetblblRecDentistMetq. RecFoot_ClickE RecEye_Click RecQuitSmoke_ClickF/RecDietitian_Click9 RecFlu_ClickYRecPneumo_ClickRecDiabetesID_Click!RecHomeCare_ClickRecSupportGroup_ClickTRecSocialWorker_ClickRecPsych_ClickgRecHDLTest_Click9qRecLDLTest_ClickRecTriglicerideTest_ClickRecMicroalbTest_Click3 RecGTT_ClickLuRecOther_Click RecDiabetesIDRecDiabetesIDDate:RecDiabetesIDMetwlblRecDiabetesIDMet RecDietitian4RecDietitianDatevRecDietitianMetOlblRecDietitianMetRecEye RecEyeDateu RecEyeMet._ lblRecEyeMetRecFlu RecFluDate99 RecFluMet lblRecFluMet>RecFoot,P RecFootDate RecFootMet lblRecFootMetVRecGTT" RecGTTDate RecGTTMetˏ lblRecGTTMet RecHDLTestRRecHDLTestDateW RecHDLTestMetNxlblRecHDLTestMet RecHomeCareGRecHomeCareDate%RecHomeCareMetlblRecHomeCareMet RecLDLTestARecLDLTestDate1 RecLDLTestMet%OlblRecLDLTestMeK[tsRecMicroalbTestRecMicroalbTestDateRecMicroalbTestMetlblRecMicroalbTestMetRecOtheri RecOtherDate+b RecOtherMet{lblRecOtherMetL RecOtherText RecPneumoM RecPneumoDate RecPneumoMetlblRecPneumoMetRecPsychO{ RecPsychDate RecPsychMetlblRecPsychMet0P RecQuitSmokeArRecQuitSmokeDate{RecQuitSmokeMetlblRecQuitSmokeMetD^RecSocialWorkerRecSocialWorkerDateBRecSocialWorkerMetulblRecSocialWorkerMet7RecSupportGroup[RecSupportGroupDatek<RecSupportGroupMetvlblRecSupportGroupMetCRecTriglicerideTestRecTriglicerideTestDate?RecTriglicerideTestMetlblRecTriglicerideTestMet6Form_frmProgramNameForm_frmSatisfactionSurveycmdDifferentClass_ClickgacActiveDataObject SurveyDate>cmdSameClass_Click| datSurveyDate@txtInstructor1FtxtInstructor2FtxtInstructor3FcboInstructor1cboInstructor2cboInstructor3fraQ1J Form_frmSatisfactionSurveyReport!cmdSurveyReport_ClickLj cboInstructor Form_frmSetupN cmdCloseForm_ClickErr_cmdCloseForm_ClickExit_cmdCloseForm_Click}cmdEditDoctor_ClickKcmdInsurance_ClickcmdMedications_ClickpcmdNewDoctor_ClickTvCommand11_ClickmCommand15_ClicklCommand17_ClickCommand19_Click\Command21_Click(nCommand23_ClickCommand25_Click]Command9_Click\Form_frmSkinProblemsListTForm_frmTestFrequencyList$Form_Main MenuOcmd1stFUAggregate_ClickCb Start DateEnd Dateu msgNoDatescmd2ndFUAggregate_ClickcmdPersonalFU_Click Patient Index msgNoPatient^cmdRecommendationSummary_Click>Command4_ClickIZErr_Command4_ClickExit_Command4_Click?!Command8_ClickIErr_Command8_ClickExit_Command8_ClickCommand10_Click%Err_Command10_ClickExit_Command10_ClicktErr_Command19_ClickExit_Command19_ClickCommand24_Click%Err_Command24_Click Class IndexSM msgNoClassExit_Command24_Click(eCommand26_Click;Err_Command26_Click2iExit_Command26_ClickCommand33_ClickErr_Command33_ClickhExit_Command33_Click-Command38_ClickE%Err_Command38_Click{ msgNoLocation!Exit_Command38_Clickd!Report_~rptAgeRangeByDiabetesType|M%Report_~rptTempGoal3MoTotals_Crosstab4%Report_~rptTempGoal6WkTotals_CrosstabmodPublicFunctionsRecType?lonID2q datFUDate varRecDate1stz varRecDate2ndomodPublicVariable<   00F400F4" DPB="1B194200B501B501B5" GC="8D8FD49A340D350D35F2" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 ijMSysDbAcessVBAData Forms  `Í+Ќ{0Cmdbars`Í+`Í+Modules  `Í+`Í+PropDataCopyK[Reports`Í+[]Scripts `Í+;PropData Databases`Í+Ў*;0`Í+ O\+Blob DirDataCustomGroupsJ+J+DataAccessPages `Í+`Í+  @S Yr! bNY  Y Y  Y  Y  Y LId LValueObjectGuidObjectNameProperty Valuett !YYYId$ObjectGuidProperty$ObjectNamePropertyHv1b   # @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @                   !" #%&$')*(+-.,/12345678 9 : ;0<>?=@BC DAEGHFIKLMN OJPRSTQ         ! !"!$!%! &!#"'")"*"(#+#-#.# /#,$0$2$3$ 4$1%5%7%8% 9%6&:&<&=&;'>'@'A' B'?(C(E(F( G(D)H)J)K) L)I*M****N++++,, , , , ,  , ,------------- - -.. .!.".#.$.%.&.'.(.). *. +. ,. -...//:" @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @/1/2/3/4/5/6/ 7/0080:0;0<0=0>0?0@0A0B0C0%0 %091%1%1%1%1%1%1% 1% 1% 1% 1% 1%1%1%1 %1 %1 %1%2%2%2%2%2%2%2%2%2%2%2%2% 2%!2%"2%#2%$2 %%2 %&2 %'2%3%(3%*3%+3%,3%-3%.3%/3%03%13%23%33%43%53%63'3'3 '3 '3 '3%)4'4'4'4' 4' 4' 4' 4' 4'4'5'5'5'5'5'5'5'5'5'5'6'6'6'6'6'6'6' 6'!6'"6'#6'$6'%6'&6''6 '(6'7')7'+7',7'-7'.7'/7'07'17'27'37'47'57'67'77 '87'*8'98';8'<8'=8'>8'?8'@8'A8'B8'C8888888 8 8 8':9 9 9 9 9999999999999 9 9 9 ::: :!:":#:$:%:&:':(:):*:+:,:-:.:/: 0: 1: 2:99999999999 9 9 9 LVALJ V &  <`j(pTblPatientPersonalInfo.[Patient Number]=TblPatientInfo.[Patient Number]TblAppointmentLog.[Patient Number]=TblPatientInfo.[Patient Number]TblPatientPersonalInfo.[Patient Number]=[Age calculations].[Patient Number]Count(TblPatientPersonalInfo.[Patient Number])TblPatientInfo.[Primary Ancestry]TblPatientInfo.[Primary Ancestry](((TblPatientPersonalInfo.[Admission Date]) Between #10/1/2008# And #9/30/2009#) AND ((TblPatientInfo.ClassesComplete)=-1))TblPatientPersonalInfo.[Patient Number]=TblAppointmentTypes.[Patient Number]TblPatientPersonalInfo.[Patient Number]=TblAppointmentLog.[Patient Number]TblPatientPersonalInfo.[Patient Number]=TblPatientInfo.[Patient Number]TblAppointmentLog.[Patient Number]=TblPatientInfo.[Patient Number]Count(TblPatientPersonalInfo.[Patient Number])TblPatientInfo.[Primary Ancestry]IIf([Previous Diabetes Education]=-1,"Yes",IIf([Previous Diabetes Education]=0,"No","Unk"))(((TblPatientPersonalInfo.[Admission Date]) Between #10/1/2008# And #9/30/2009#) AND ((TblPatientInfo.ClassesComplete)=-1))TblPatientPersonalInfo.[Patient Number]=TblAppointmentTypes.[Patient Number]TblPatientPersonalInfo.[Patient Number]=TblAppointmentLog.[Patient Number]TblPatientPersonalInfo.[Patient Number]=TblPatientInfo.[Patient Number]TblAppointmentLog.[Patient Number]=TblPatientInfo.[Patient Number]Count(IIf([Previous Diabetes Education]=-1,"Yes",IIf([Previous Diabetes Education]=0,"No","Unk")))IIf([Previous Diabetes Education]=-1,"Yes",IIf([Previous Diabetes Education]=0,"No","Unk"))IIf([Previous Diabetes Education]=-1,"Yes",IIf([Previous Diabetes Education]=0,"No","Unk"))(((TblPatientPersonalInfo.[Admission Date]) Between #10/1/2008# And #9/30/2009#))TblPatientPersonalInfo.[Patient Number]=TblPatientInfo.[Patient Number]Count(IIf([Previous Diabetes Education]=-1,"Yes",IIf([Previous Diabetes Education]=0,"No","Unk")))IIf([Previous Diabetes Education]=-1,"Yes",IIf([Previous Diabetes Education]=0,"No","Unk"))37p&h) b  j +  | 2 z 6 4Vl]HK!'3TblPatientPersonalInfoTblAppointmentLog@ &k_= 3TblPatientPersonalInfoTblPatientInfo@&eY= 3TblAppointmentLogTblPatientInfo@&[O3 3TblPatientPersonalInfoDiagnosis calculations@&ui= 3CountOfPatient Number\@&G;; o3 [Diagnosis calculations].DxGrp= g3B@& g3TblPatientInfo.Race2 g3TblAppointmentTypes777 3TblPatientInfo--- 3TblAppointmentLog333 3Diagnosis calculations=== 3TblPatientPersonalInfo=== 3 3 G2 ge calculations].AgeGrp8 g2 B@& g2 TblPatientInfo.Race2 g2@& '2TblPatientPersonalInfoTblAppointmentTypes@&oc= 2TblPatientPersonalInfoTblAppointmentLog@&k_= 2TblPatientPersonalInfoTblPatientInfo@$eY= 2TblAppointmentLogTblPatientInfo@$[O3 2TblPatientPersonalInfoAge calculations@$i]= 2CountOfPatient Number\@$G;; o2ge calculations].AgeGrp8 g2B@$ g2TblPatientInfo.Race2 g2TblAppointmentTypes777 2TblPatientInfo--- 2TblAppointmentLog333 2Age calculations111 2TblPatientPersonalInfo=== 2 2 G1 TblPatientPersonalInfo.Gender< g1 B@$ g1 TblPatientInfo.Race2 g1@$ '1TblPatientPersonalInfoTblAppointmentTypes@$oc= 1TblPatientPersonalInfoTblAppointmentLog@$k_= 1TblPatientPersonalInfoTblPatientInfo@$eY= 1TblAppointmentLogTblPatientInfo@$[O3 1CountOfPatient Number\@$G;; o1TblPatientPersonalInfo.Gender< g1B@ $ g1TblPatientInfo.Race2 g1TblAppointmentTypes777 1TblPatientInfo--- 1TblAppointmentLog333 1TblPatientPersonalInfo=== 1 1 G0 @ $ g0@ $ 'LVALl Z \ J  ( TFjhV(TblPatientPersonalInfo.[Patient Number] = TblPatientInfo.[Patient Number]TblPatientPersonalInfo.[Patient Number] = TblAppointmentTypes.[Patient Number]TblPatientPersonalInfo.[Patient Number] = TblAppointmentLog.[Patient Number]Count(IIf([Previous Diabetes Education]=-1,"Yes",IIf([Previous Diabetes Education]=0,"No","Unk")))IIf([Previous Diabetes Education]=-1,"Yes",IIf([Previous Diabetes Education]=0,"No","Unk"))(((TblPatientPersonalInfo.[Admission Date]) Between #10/1/2008# And #9/30/2009#) AND ((TblPatientInfo.[Patient Number]) Is Null))TblPatientPersonalInfo.[Patient Number]=TblPatientInfo.[Patient Number]TblPatientPersonalInfo.[Admission Date]TblPatientPersonalInfo.[First Name]TblPatientPersonalInfo.[Last Name]TblPatientPersonalInfo.[Patient Number](((TblPatientPersonalInfo.[Admission Date]) Between #10/1/2008# And #9/30/2009#))TblPatientPersonalInfo.[Admission Date]TblPatientPersonalInfo.[First Name]TblPatientPersonalInfo.[Last Name]TblPatientPersonalInfo.[Patient Number]TblPatientInfo.[Primary Ancestry](((TblPatientPersonalInfo.[Admission Date]) Between #10/1/2008# And #9/30/2009#) AND ((TblPatientInfo.ClassesComplete)=-1))TblPatientPersonalInfo.[Patient Number]=TblAppointmentTypes.[Patient Number]TblPatientPersonalInfo.[Patient Number]=TblAppointmentLog.[Patient Number]TblPatientPersonalInfo.[Patient Number]=TblPatientInfo.[Patient Number]TblAppointmentLog.[Patient Number]=TblPatientInfo.[Patient Number]TblPatientPersonalInfo.[Patient Number]=[Diagnosis calculations].[Patient Number]Count(TblPatientPersonalInfo.[Patient Number])TblPatientInfo.[Primary Ancestry]TblPatientInfo.[Primary Ancestry](((TblPatientPersonalInfo.[Admission Date]) Between #10/1/2008# And #9/30/2009#) AND ((TblPatientInfo.ClassesComplete)=-1))TblPatientPersonalInfo.[Patient Number]=TblAppointmentTypes.[Patient Number]TblPatientPersonalInfo.[Patient Number]=TblAppointmentLog.[Patient Number]DZkM/ g =  S ) 9  M Y  )O%9{E );o%g(8 TblPatientPersonalInfo.Gender< g8 B@  g8 TblPatientInfo.Race2 g8 TblAppointmentTypes777 8 TblPatientInfo--- 8 TblAppointmentLog333 8 TblPatientPersonalInfo=== 8  G8  G8  8  G7  @  g7 @  '7 TblPatientPersonalInfoTblPatientInfo@eY= 7 TblPatientPersonalInfoTblAppointmentTypes@oc= 7 TblPatientPersonalInfoTblAppointmentLog@k_= 7 TblAppointmentLogTblPatientInfo@[O3 7 PastEdCnt@/## o7 PastEd@) o7 TblAppointmentTypes777 7 TblPatientInfo--- 7 TblAppointmentLog333 7 TblPatientPersonalInfo=== 7  G7  G7  7  G6  @ g6 n@ '6 TblAppointmentLogTblPatientInfo@[O3 6 TblPatientPersonalInfoTblPatientInfo@&eY= 6 TblPatientPersonalInfoTblAppointmentTypes@&oc= 6 TblPatientPersonalInfoTblAppointmentLog@&k_= 6 PastEdCnt@&/## o6 PastEd@&) o6 TblPatientInfo--- 6 TblAppointmentTypes777 6 TblAppointmentLog333 6 TblPatientPersonalInfo=== 6  G6  G6  6  G5 @& '5 TblPatientPersonalInfoTblPatientInfo@&eY= 5 N@& g5 F@& g5 D@& g5 N@& g5 TblPatientInfo--- 5 TblPatientPersonalInfo=== 5  5  G4 @& '4 N@& g4 F@& g4 D@& g4 N@ & g4 TblPatientPersonalInfo=== 4  G4  G4  4  G3  [Diagnosis calculations].DxGrp= g3 B@ & g3 TblPatientInfo.Race2 g3@ & '3TblPatientPersonalInfoTblAppointmentTypes@ &oc= bYr! bN))Y Y  Y Y  Y dSwitchboardIDItemNumberItemTextCommandArgumentreya)+YPrimaryKeyv1{(j9 Satisfaction SurveyfrmSatisfactionSurvey6 Administrative SetupfrmSetup* ReportsfrmMDCH-ADAReports' Class RosterFrmClassRoster( Patient InfofrmPatientInfo( Patient Appt LogFrmNewPatientLog. Main SwitchboardDefault%  (*******YN-- Y Age Range-/YPrimaryKeyv1@@,No data 65+45-64 19-44 0-18 , 68F .8H>>.>@B>.B@,.bdOJmJ. YN11Y Y  Y d Y Y Y Y Patient Number Appointment DateLocation$Appointment Status&With Support Person"Hospital ReferralFPhysician Managed Practice Referral131YYL{2C85870C-D4DD-42BB-87D2-270062EE9933}PrimaryKeyv1 0oR5jM0 `@Kept @Kept  @Kept @Kept @Kept @Kept @Kept @Kept @Kept @Kept  }@Kept  @{@Kept  `x@Kept  `w@Kept q@Kept @o@Kept m@Kept m@Kept  i@Kept f@Kept  0@@@@@f2i 2m2m2o@2q2 w`2 x`2 {@2 }2 ダ2 2 ㄠ2 2 ㋀222 22`2YN55 Y "AppointmentStatus 57YPrimaryKeyv1@@4RescheduledNo Show KeptCanceled  4MJbMQ^QO6\Qfm6bdkWds6iQkMWQOo^QO6)Y N99 Y d Y d Appointment Type Appointment NameA9;xYPrimaryKeyv18 }eG/9CHO Count8Nutrition Consult7Gestational6New Meter5New Insulin4Follow up3Scheduled Class21:1 Class12Intensive Management11Heparin Training10Insulin Pump Training1Assessed 88:86:88:8::::<:>:@:B:D: F: H:  Y N==Y Y  Y  dPatient Number Appointment Date Appointment Type=?=YYL{49A1C01F-B5FF-4046-A4EE-218C2FCDFA9A}PrimaryKeyv1 @@ <v_H1ybK4`@1@1 @1@1@1@1@1@1@1@1 }@1 @{@1 `x@1 `w@1q@1@o@1m@1m@1 i@1f@1h <@@@@@f8>i 8>m8>m8>o@8>q8> w`8> x`8> {@8> }8> ダ8> 8> ㄠ8> 8> ㋀8>8>8> 8>8>`8>YNAA Y d Y dClass NumberClass NameNeABYPrimaryKeyv1 @!Yr! bNDDY  Y dY Y Y  Y i<Patient NumberClass NumberDateAttended&With Support PersonLocationSpteDE"HYPrimaryKeyv1  CvYNGGY  Y d Y dPatient Number8Current Diabetes MedicationsMedication DoseYGHYPrimaryKeyv1 FvYNJJ Y dDiabetes Typedv0Iu^LNo Data Pre-DiabetesType 2, Without InsulinType 2, With InsulinType 1 GestationalDM Difficult to ClassifyHYNMMY  Y d Y dPatient NumberSettingContent AreasseciMOseYPrimaryKeyv1g((D M> < P j  J 1 _"G>\D )_0@QΑ@QΑ@tblTempGoalTotalsBBBBBBBBBBB g 0@g 0@tblTempGoal6WkTotalsuJJJJJJJJJJH xg 0@g 0@tblTempGoal3MoTotalsuJJJJJJJJJJH $+g 0@g 0@tblTempBadDatau@ JJJ>>>>>>>< @Sg 0@2g 0@tblTempApptStatusuDDDDDDDDDDB -g 0@ &g 0@tblTempAgeRangesGenderuNNNNNNNNNNL x>>>>>>< @g 0@! 0@tblPrimaryAncestryup@RRRFFFFFFFD @g 0@ 0@TblPhysicianListu@NNNBBBBBBB@ @z̑@@ ̑@TblPatientPersonalInfou @ZZZNNNNNNNL @̑@X"̑@TblPatientInfoũJJJ>>>>>>>< @g 0@5g 0@tblNewPatientInfoFieldsu$̃\\\PPPPPPPN @g 0@ 0@tblMedicationTypesun@ RRRFFFFFFFD @P3g 0@ɤ 0@tblMaritalStatusuj@ NNNBBBBBBB@ @ōg 0@i? 0@tblLocationsu*@ FFF:::::::8 @8fg 0@ӌg 0@tblLocationPickListu@ TTTHHHHHHHF @օg 0@aZ 0@TblLabTestsu@ DDD88888886 @ng 0@= 0@TblLabResultsu @ HHH<<<<<<<: @%g 0@! 0@tblInsuranceTypesuj@ PPPDDDDDDDB @wzg 0@ 0@tblGoalTypesub@ FFF:::::::8 @Flvg 0@yg 0@tblFollowupSelfFootExamTypesu3@ fffZZZZZZZX @} sg 0@ܱug 0@tblFollowupsu ̃FFF:::::::8 @xnng 0@Hrg 0@tblFollowupRatingsu @ RRRFFFFFFFD @tpkg 0@8ng 0@tblFollowupMedFrequenciesu@ ```TTTTTTTR @obfg 0@\jg 0@tblFollowupManageDiabetesRatingsu+@ nnnbbbbbbb` @kAbg 0@Hfg 0@tblFollowupFrequenciesu@ ZZZNNNNNNNL @e ^g 0@ag 0@tblFollowupExerciseFrequencyu9@ fffZZZZZZZX @\$Vg 0@Yg 0@tblFollowupBGTestFrequencyu/@bbbVVVVVVVT @W:Rg 0@#Vg 0@tblFollowupBGRangesu@TTTHHHHHHHF @SPrXAdvanced DegreeCollege GraduateSome CollegeHigh School GraduateLess than 12th GradeLess than 8th GradeYNTT Y d$Exercise Frequency HTVY$Exercise Frequencyv1@ 'SxYEEvery Day 4 or More x per Week3 x per Week2 x per Week1 x per Week< 1 x per Week< 1 x per MonthNever  S@@.8ufQi`dbmWU.8ufQisQQ\U8ufQisQQ\U:ufQisQQ\U<ufQisQQ\U>di`diQufQisQQ\UQqQivOJvUbQqQiUyYNXXY  Y (BGRangeIDBGRangeFaXZX[YYBGRangeIDPrimaryKeyv1oWMissing Widely FluctuatingOften LowOften HighUsually in TargetW@AYYYYYW@AYYYYY3Y N]] Y  Y <TestFrequencyID"TestFrequencyList]_YTestFrequencyIDv1@@\ kYH0  Missing  Never  6-10 x Daily Other Rarely 2-3 x Weekly1-2 x WeeklyQIDTIDBIDDaily Alternating TimesFBS Daily \@AA^^^^^^^^ ^ ^  ^  ^ =YNaaY  Y $DiabetesCategoryID,DiabetesCategoryRatingac[adYY$DiabetesCategoryIDPrimaryKeyv1?`q[Missingpart of lifeopportunitychallengeproblemburdendisaster ` @bbbbbbb ` @bbbbbbb 9Y r! bNff Y  Y d&ExerciseFrequencyID$Exercise FrequencytueCfhNutd&fiSuscifjYYY$Exercise Frequency&ExerciseFrequencyIDPrimaryKeyv1 e cN=* Missing Never Every Day4 or More x per Week3 x per Week2 x per Week1 x per Week< 1 x per Week< 1 x per Monthw e@@ .8ufQi`dbmWg.8ufQisQQ\g8ufQisQQ\g:ufQisQQ\g<ufQisQQ\g>di`diQufQisQQ\gQqQivOJvg`YkkYbUgbQqQig e@AAgggggggg g e@AAgggggggg gYNllY  Y FrequencyOrderFrequencyruclnYPrimaryKeyv1@ kMissing Always Usually SometimesNever k@AmmmmmUYNppY  Y  ManageDiabetesIDManageDiabetesyprpsYY ManageDiabetesIDPrimaryKeyv1oMissing Very SureModerately SureNot Sure o@qqqqo@qqqqYNuuY  Y FrequencyOrderFrequencysuwYPrimaryKeyv1@@ztMissing NAAlways Usually SometimesNever  t@AvvvvvvsYNyyY  Y RatingID Ratinggiesy{ypry|YYPrimaryKeyRatingIDv1xMissing ExcellentGood Fair Poor x@Azzzzzx@AzzzzzB YekmesyN~~Y  Y Y Y  Y  Y  Y  Y  Y  2 Y   (Y   Y    Y    Y ( Y   Y   Y   Y  Y   Y  Y  Y Y PatientIDFollowupRankFollowupDate RecFollowThroughRecFailure2BehaviorChangeGoalSuccess(BehaviorChangeReasonCurrentHealth*BloodGlucoseFrequency"BloodGlucoseRange,BloodGlucoseAcceptance"MealPlanFollowing SelfFootExamType*Frequency of ExerciseMedicationsBloodSugarMeterSelfFootExam$ManageYourDiabetesHospitalStays DiabetesCategory(DiabetesEduactionUse0DiabetesManagementChange.AdditionalInterventions~ ~Pit ~~YYPatientIDPrimaryKey~~~~~~~ ~ v1b N  }