Standard Jet DBnb` Ugr@?~1y0̝cßFN f7ٜM(+` {6~߱iCD23y[(|*|i2f_Љ$g'DeFx -bT4.0dv YSu@S SS Y   Y UY  Y Y  Y  $Y  Y  F Y l Y l Y o Y   Y 2lY  Y  t Y  sY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortType* "sRg   YYIdParentIdName        OY0J3S  RY Y Y  Y 2ACMFInheritableObjectIdSIDJ3 YObjectId Y9``S  9Y  Y ҟY Y  Y ,F Y FY  Y ,AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order,F, ,FY"ObjectIdAttribute   -Y#Q[@S  Y Y Y  Y Q Y  Y  Y @ Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship[0Q [0Q   @0ߘYYYszObject$szReferencedObjectszRelationship v1b N  : k &  = =@@@ @  @ @  @ @ @ @@@@@Si`+`JYb`dO+omY^YmviYk\+iJb\YbU+iQfdimkoLiQfdim+Ybfom+m`fM^fB><>8JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`+`JYb+kh+M^km+OJmJ+MJmQUdivLYbkMd``dOYmv+MJmQUdiv+^omMd``dOYmv+^omMdbko`fmYdbMdbko`fmYdb+iJsMdbmJ`YbJmYdbOJmJ+MJmQUdiv+^omOJmJ+mvfQ+^omOQJmW QfYOQ`Yd^dUYMJ^+^Yb\!QfYOQ`Yd^dUYMJ^+`o^mYf^YQik"UidsmW+fdmQbmYJ^#WdkfYmJ^YxJmYdb$YbSQMmYdok+OdkQ%`J\Q+mJL^Q+Mdbko`fmYdb&`J\Q+mJL^Q+kWQ^S+^YSQ'`kvkJMMQkkdL[QMmk(`kvkJMMQkku`^)`kvkJMQk`kvkbJqfJbQUidofMJmQUdiYQk*`kvkbJqfJbQUidofk+`kvkbJqfJbQUidofmddL[QMmk,`kvkbJqfJbQdL[QMmYOk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkfJmWdUQb+MJmQUdiv+^omfJmWdUQb+^omfJmWdUQb+mvfQ+^omhiv+iYk\+iJb\YbU+iQfdimhiv+koLiQfdim+YbfomiJb\+iQko^mkkWQ^S+^YSQkWQ^S+^YSQ+UidsmW+fdmQbmYJ^+Md`LYbQOkWQ^S+^YSQ+iJs kokMQfmYL^Q+fdfo^JmYdb JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOMd``dOYmv+MJmQUdiv+^omMd``dOYmv+^omMd``dOYmv+MJmQUdiv+^omMdbko`fmYdbMd``dOYmv+MJmQUdiv+^omMdbko`fmYdb+iJsMd``dOYmv+MJmQUdiv+^omMdbmJ`YbJmYdbMd``dOYmv+MJmQUdiv+^omQfY+`QJO+`o^mYf^YQikMd``dOYmv+MJmQUdiv+^omQfYOQ`Yd^dUYMJ^+^Yb\Md``dOYmv+MJmQUdiv+^omUidsmW+fdmQbmYJ^Md``dOYmv+MJmQUdiv+^omiJb\+iQko^mkMd``dOYmv+MJmQUdiv+^omkWQ^S+^YSQMd``dOYmv+MJmQUdiv+^omkWQ^S+^YSQ+iJsMd``dOYmv+^omMdbko`fmYdb+iJsMd``dOYmv+^omkWQ^S+^YSQ+iJsOJmJ+MJmQUdiv+^omLYbkOJmJ+mvfQ+^omOJmJ+MJmQUdiv+^omOQJmW+fJmW+MJm+S\OdkQ+fJmW+MJm+S\WdkfYmJ^+fJmW+MJm+S\fJmWdUQb+MJmQUdiv+^omMdbmJ`YbJmYdbfJmWdUQb+MJmQUdiv+^omQfY+`QJO+`o^mYf^YQikfJmWdUQb+MJmQUdiv+^omQfYOQ`Yd^dUYMJ^+^Yb\fJmWdUQb+MJmQUdiv+^omUidsmW+fdmQbmYJ^fJmWdUQb+MJmQUdiv+^omfJmWdUQb+^omfJmWdUQb+MJmQUdiv+^omiJb\+iQko^mkfJmWdUQb+MJmQUdiv+^omkWQ^S+^YSQ+UidsmW+fdmQbmYJ^+Md`LYbQO fJmWdUQb+mvfQ+^omfJmWdUQb+MJmQUdiv+^om fdf+fJmW+MJm+S\ k^Uf+Md``+MJm+S\ 5  @ @ @ @ @ @ @ @ @ @          &' !"#$%&'()*+ , - . $(,39> C!I"O#U$Z%_()*+,  v1@q @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% & ' ( ) * + , - . / 0 1 2 3 456789:@ABCDE    !"#$%&'()*+,-. / 0 1!2!3!4"5"6"7#8#9#:$;$<$=%>%?%@&A&B&C'D'E'F(G(H(I)J))***+++,, , - - - ..../0 !123456;<=>?@ABC$D$E$F(G(H(I,J,K,L3M3N3O9P99>>>CCCII I O O O UUUZZZ___=>?"#$%&'()*+,-789:;<FGHI    !"#v1s  @ @ @ @ @ @ @            !"#$ %&()*+,-./01234 5 6 7 8'v1@@  @ @@  Md``dOYmv+MJmQUdiv+^omMd``dOYmv+^omMd``dOYmv+MJmQUdiv+^omMdbko`fmYdbMd``dOYmv+MJmQUdiv+^omMdbko`fmYdb+iJsMd``dOYmv+MJmQUdiv+^omMdbmJ`YbJmYdbMd``dOYmv+MJmQUdiv+^omQfY+`QJO+`o^mYf^YQikMd``dOYmv+MJmQUdiv+^omQfYOQ`Yd^dUYMJ^+^Yb\Md``dOYmv+MJmQUdiv+^omUidsmW+fdmQbmYJ^Md``dOYmv+MJmQUdiv+^omiJb\+iQko^mkMd``dOYmv+MJmQUdiv+^omkWQ^S+^YSQMd``dOYmv+MJmQUdiv+^omkWQ^S+^YSQ+iJs Md``dOYmv+^omMdbko`fmYdb+iJs Md``dOYmv+^omkWQ^S+^YSQ+iJs OJmJ+MJmQUdiv+^omLYbk OJmJ+mvfQ+^omOJmJ+MJmQUdiv+^om OQJmW+fJmW+MJm+S\OdkQ+fJmW+MJm+S\WdkfYmJ^+fJmW+MJm+S\fJmWdUQb+MJmQUdiv+^omMdbmJ`YbJmYdbfJmWdUQb+MJmQUdiv+^omQfY+`QJO+`o^mYf^YQikfJmWdUQb+MJmQUdiv+^omQfYOQ`Yd^dUYMJ^+^Yb\fJmWdUQb+MJmQUdiv+^omUidsmW+fdmQbmYJ^fJmWdUQb+MJmQUdiv+^omfJmWdUQb+^omfJmWdUQb+MJmQUdiv+^omiJb\+iQko^mkfJmWdUQb+MJmQUdiv+^omkWQ^S+^YSQ+UidsmW+fdmQbmYJ^+Md`LYbQOfJmWdUQb+mvfQ+^omfJmWdUQb+MJmQUdiv+^omfdf+fJmW+MJm+S\k^Uf+Md``+MJm+S\  @@ LYbk Md``dOYmv+^omMdbko`fmYdbMdbko`fmYdb+iJsMdbko`fmYdb+iJs MdbmJ`YbJmYdbMdbmJ`YbJmYdbOJmJ+MJmQUdiv+^om OQJmWQfYOQ`Yd^dUYMJ^+^Yb\QfYOQ`Yd^dUYMJ^+^Yb\QfYOQ`Yd^dUYMJ^+`o^mYf^YQikQfYOQ`Yd^dUYMJ^+`o^mYf^YQikUidsmW+fdmQbmYJ^UidsmW+fdmQbmYJ^WdkfYmJ^YxJmYdbYbSQMmYdok+OdkQfJmWdUQb+MJmQUdiv+^omfJmWdUQb+^omiJb\+iQko^mkiJb\+iQko^mkkWQ^S+^YSQkWQ^S+^YSQ+UidsmW+fdmQbmYJ^+Md`LYbQOkWQ^S+^YSQ+UidsmW+fdmQbmYJ^+Md`LYbQO kWQ^S+^YSQ+iJs kWQ^S+^YSQ+iJs kokMQfmYL^Q+fdfo^JmYdb @ @    Md``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^omMd``dOYmv+MJmQUdiv+^om Md``dOYmv+MJmQUdiv+^om Md``dOYmv+^om Md``dOYmv+^om OJmJ+MJmQUdiv+^om OJmJ+mvfQ+^om fJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+MJmQUdiv+^omfJmWdUQb+mvfQ+^om=-d _ Z L _  Kb  Q w Ht7iBNCvr BZVA;zu;zu;zu@FzuWZW@WZW@ MSysNavPaneGroupToObjects3U4MR2KeepLocal  TTTTTTTTR @W@WZW@ MSysNavPaneGroupCategories3U4MR2KeepLocal  TVVVVVVVT @_xu@Zu@MSysAccessObjects3UDDDDDDDDDDB I^@f@MAKE_TABLE_SHELF_LIFE3U@|@dXXLLLLLLLJ @Kc^@*Fشi@MAKE_TABLE_CONSUMPTION3U@|@fZZNNNNNNNL @Zviu]@Pu@INFECTIOUS_DOSE3U @LLL@@@@@@@> @O-u]@Pu@GROWTH_POTENTIAL3UN @NNNBBBBBBB@ @Ic:Lu]@Pu@EPIDEMIOLOGICAL_MULTIPLIERS3U @dddXXXXXXXV @CtN]@Pu@EPIDEMIOLOGICAL_LINK3U @VVVJJJJJJJH @>nu]@Pu@DEATH3UT@888,,,,,,,* @95_@Pu@DATA_TYPE_LUT3UN@HHH<<<<<<<: @3BH|]@Pu@DATA_CATEGORY_LUT3U @PPPDDDDDDDB @,A@u]@Pu@CONTAMINATION3U+@HHH<<<<<<<: @($0u]@Pu@CONSUMPTION_RAW3U@LLL@@@@@@@> @$ ib@u@CONSUMPTION3U@DDD88888886 @':s]@Pu@COMMODITY_LUT3U@HHH<<<<<<<: @E78s]@Pu@COMMODITY_CATEGORY_LUT3U@ZZZNNNNNNNL @y]@Pu@BINS3U@666*******( @  f?p_@|4pf@Admin3UN8,,,,,,,,,*  48_@48_@~TMPCLP643413U::::::::::8  ^@^@SUBREPORT_INPUT3U@LLL@@@@@@@> @ P^@P^@RISK_RANKING_REPORT3U@TTTHHHHHHHF @ ,B^@,B^@mod_utility3U88888888886   }]@n]8_@frm_Main3U@>>>22222220 @ 0ߘQ[@0ߘQ[@UserDefined3UA@DDD88888886 @ 0ߘQ[@0ߘQ[@SummaryInfo3U@DDD88888886 @ 0ߘQ[@0ߘQ[@SysRel3U.........., 0ߘQ[@0ߘQ[@Scripts3U0000000000. 0ߘQ[@0ߘQ[@Reports3U0000000000. 0ߘQ[@0ߘQ[@Modules3U0000000000. BQ[@BQ[@DataAccessPages3U@@@@@@@@@@> #Q[@#Q[@MSysRelationships2WDDDDDDDDDDB #Q[@#Q[@MSysQueries2W88888888886 #Q[@#Q[@MSysACEs2W22222222220 #Q[@#Q[@MSysObjects2W88888888886 #Q[@)c.@MSysDb3U*@:::......., @#Q[@#Q[@Relationships2W<<<<<<<<<<: #Q[@#Q[@Databases2W44444444442 #Q[@#Q[@Tables2W.........., I9ZqS5 U  } _ A  G   5 V |7]l#t wM NBINS.BIN_RANK, ' N!DATA_CATEGORY_LUT.DATA_CATEGORY> ' NN@ ' NDATA_TYPE_LUT.DATA_TYPE6 'NDATA_CATEGORY_LUTDATA_TYPE_LUTr@ YM3 NDATA_CATEGORY_LUTBINSp@ G;3 NBINS.BIN_HIGH_USER1 gNBINS.BIN_LOW_USER0 gN BINS.BIN' gNDATA_CATEGORY_LUT.USER_WEIGHT< gNBINS.BIN_RANK, gN!DATA_CATEGORY_LUT.DATA_CATEGORY> gNN@  gNDATA_TYPE_LUT.DATA_TYPE6 gNDATA_TYPE_LUT+++ NBINS NDATA_CATEGORY_LUT333 N N G ParasdRANK_RESULTS.RANK_TOTAL8 /arasRANK_RESULTSPATHOGEN_CATEGORY_LUT@ _S) arasRANK_RESULTSCOMMODITY_CATEGORY_LUT@ aU) arasRANK_RESULTS.RANK_TOTAL6 garasR@ garasN@ gParasPATHOGEN_CATEGORY_LUT;;; ParasCOMMODITY_CATEGORY_LUT=== ParasRANK_RESULTS))) Paras aras G NT0 g NTH@ gNTUSER_BIN_RANK09++ oNTAVG_SHELF_LIFE_DAYSF@C77 oNTH@ gENTSHELF_LIFE_RAW--- NT GNT GENT NT G ח0 g חJ@ gחUSER_BIN_RANK09++ oחAVG_POP_CONSUMING_PERCENTT@OCC oחJ@ gחCONSUMPTION_RAW/// ח Gח Gח ח G {[DATA_CATEGORY]. '{NUMERIC_CRITERIA_FLAG=Yes8 '{!DATA_CATEGORY_LUT.DATA_CATEGORY> g{D@ g{DATA_CATEGORY_LUT333 { { G~ LVALrF ^ ( j DATA_CATEGORY_LUT.NUMERIC_CRITERIA_FLAGDATA_CATEGORY_LUT.DATA_TYPE_ID=DATA_TYPE_LUT.DATA_TYPE_IDDATA_CATEGORY_LUT.DATA_CATEGORY_ID=BINS.DATA_CATEGORY_IDDATA_CATEGORY_LUT.NUMERIC_CRITERIA_FLAGRANK_RESULTS.PATHOGEN_CATEGORY_ID=PATHOGEN_CATEGORY_LUT.PATHOGEN_CATEGORY_IDRANK_RESULTS.COMMODITY_CATEGORY_ID=COMMODITY_CATEGORY_LUT.COMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUT.COMMODITY_CATEGORYPATHOGEN_CATEGORY_LUT.PATHOGEN_CATEGORYSHELF_LIFE_RAW.COMMODITY_CATEGORY_IDAvg(SHELF_LIFE_RAW.SHELF_LIFE_DAYS)SHELF_LIFE_RAW.COMMODITY_CATEGORY_IDCONSUMPTION_RAW.COMMODITY_CATEGORY_IDSum(CONSUMPTION_RAW.POP_CONSUMING_PERCENT)CONSUMPTION_RAW.COMMODITY_CATEGORY_IDDATA_CATEGORY_LUT.DATA_CATEGORY_ID 8Y(#Q[@N  ( ((Y Y Y  Y C Y EY  Y Y Y $ DATA_CATEGORY_IDBIN_NUMBERBIN_RANKBINBIN_RANGEBIN_LOW_DEFAULT BIN_HIGH_DEFAULTBIN_LOW_USERBIN_HIGH_USER YYY3Y DATA_CATEGORY_ID*DATA_CATEGORY_LUTBINSPrimaryKeyv1 'j B \ x 0 D ( b ll`Jf @@@@Strong3 - 5D:. @@Moderate1 - 2H>. 7u@4~sqWeak - Less than 100 Total CasesLess than 100 Total Casesn._ 7u@48u@~sq_cfrStrongChildren, pregnant women, immunocompromised:. 7u@48u@~sq_cfrMediumSeverity increases with agep:. 7u@48u@~sq_cfrSomeYoung children or elderly (more susceptible or have more disease)6. 7u@48u@~sq_cfrNoneNo one is more suscptible than others6. H@8u@H@_cfrLong49+ daysF6. .@H@.@H@Moderate15-48 daysR>. @.@@.@Short7-14 daysJ8. 7u@4@~sq@Very Short0-7 daysRB._ j@8u@j@_cfrHigh1000001+F6. H@j@H@j@Medium1001 - 100000T:. @Y@H@@Y@H@Low101 - 1000H4. 7u@4@Y@~sq@Y@Very Low1-100H>._ I@8u@I@_cfrSevere> 50%D:. 4@I@4@I@Serious20 - 50%L<. $@4@$@4@Moderate10 - 20%N>. 7u@4$@~sq$@Mild<10%>6._ 7u@48u@~sq_cfrStrongDocumented growth at refrigeration temperature:. 7u@48u@~sq_cfrMediumLikely growth at room temperature|:. 7u@48u@~sq_cfrSomeSome evidence that bacteria may grow (e.g., higher pH and/or bruising/damage) and includes conflicting studies6. 7u@48u@~sq_cfrNoneNo evidence N6. F@8u@F@_cfrVery High>45F@. C@F@C@F@High38:6. 4@C@4@C@Medium20>:. 7u@44@~sq4@Low264._ ?8u@?_cfrHigh> 1%>6. ????Medium High0.5 - 1RD. ????Medium0.1 - 0.5L:. 7u@4?~sq?Low< 0.1%@4._ @8u@@_cfrHigh>5%<6. ?@?@Medium1 - 5%F:. ??Low< 1%<4. 7u@4~sqUnknown, Poorly Characterized - Number of Studies is less than 3Unknown, Poorly Characterized._ $@8u@$@_cfrVery High>10%H@. @$@@$@High5 - 10%D6. ?@?@Medium1 - 5%F:. 7u@4?~sq?Low< 1%<4._ @8u@@_cfrVery Strong> 5JD.  @ @ @ @ @            ! " # $ % &  @@@@@@@@@@            ! " # $ % &  AYf ~N Y  Y d*COMMODITY_CATEGORY_ID$COMMODITY_CATEGORYG_TO OG_`!YY$Y(Y,YIYCYOY Y Y Y YY.rC.rD.rE.rF.rG.rH.rI.rJ.rK.rL.rM PATHOGEN_TYPE_IDPrimaryKeyv1@ kmX@"PeppersNuts Sprouts Mangos Green Onions Mixed Produce Root VegetablesMushroomsMelonsLeafy GreensHerbs CrucifersTomatoesCitrus - GeneralBerries  @ @           @ @         @ YN  Y  Y Y COMMODITY_IDCOMMODITY*COMMODITY_CATEGORY_IDA*POU "_P #)+ )Y(YYYY.rD.rEFCOMMODITY_CATEGORY_LUTCOMMODITY_LUTPATHOGEN_IDPrimaryKeyv10 y\C(}cI- n !Lettuce  White Watermelon Strawberry Spinach Raspberry Portabella Pineapple Parsley Mesclun Lettuce Romaine Lettuce Leaf Lettuce Head  Leek  Honeydew  Garlic  Cilantro  Carrot Cantaloupe Cabbage Broccoli Blackberry Basil Baby Bella H  @ @ @!!!!!!! ! ! ! ! ! ! ! !!!!!!!! !!!H  @ @ @!!!!!!! ! ! ! ! ! ! ! !!!!!!!! !!! YN%%Y Y Y *COMMODITY_CATEGORY_ID*POP_CONSUMING_PERCENTUSER_BIN_RANK%'%YYBCOMMODITY_CATEGORY_LUTCONSUMPTIONPrimaryKeyv1@@\$y^C( ?/@(\? ~jt? )Ǻ? d;O? >W[@#~j?pxz,C@,Ԛ:@ʡE?`I @o3@ @ $ @ @&&&&&&& & & &  & & & & W YN)) Y Y Y Y COMMODITY_ID*COMMODITY_CATEGORY_IDMEAN_GRAMS*POP_CONSUMING_PERCENT)+)YYYYJCOMMODITY_CATEGORY_LUTCONSUMPTION_RAWCOMMODITY_ID8COMMODITY_LUTCONSUMPTION_RAWv1?(y^C( k ge?d;O?'-\Va?"~? 2R臭?)Ǻ?h㈵?ʡE? {ԗ%?~jt?uBY?#~j?g?RD?@JY?o\?k ?)^emS??) @b @MhXR.@+e @l ]t!@pxz,C@ k dv@>W[@pa.)@o3@!.H+@lxz,7@ ( B!@**** * * * * ******!* uY7#Q[@N--777 77Y Y  Y Y Y Y (PATHOGEN_CATEGORY_ID*COMMODITY_CATEGORY_ID0PREVALENCE_RANGE_PERCENT,AVG_PREVALENCE_PERCENTNUMBER_STUDIESUSER_BIN_RANK47-/48-0Y-1-2YYYYYY*COMMODITY_CATEGORY_IDFCOMMODITY_CATEGORY_LUTCONTAMINATIONNUMBER_STUDIESDPATHOGEN_CATEGORY_LUTCONTAMINATIONPATHOGEN_IDPrimaryKeyHv1b@@,7vU4nM, ~ O 0  j I (  b A x K *  g 6  yX7 0? 0? Q?0 - 0.6&? 0? q= ףp?0 - 1.1&? 0? 0? (\?0.2 - 9.4*? zG?0 - 7"? 0? Q?0 - 0.09(? 0? Gz @0 - 4"? @5? {Gz? 0 - 2.4&? {Gz?0 - 0.9&? (\?0 - 1.2&? 0? (\?0 - 2.8&? 0? 0? 0? 0? 0? 0? 0? 0? 0? 0? 0? 0? 0? 0? 0? 0?ףp= ??Q?0 - 2.78(? 0?Q? 0 - 0.35(?= ףp=?0 - 1.33(?ףp= ?0 - 0.89(?0?0? 0?0?0?0? 0?0? 0?0?? ?0? 0?Gz,@14.29"?1 , @ @ @ @ @ @ @.. ...#.....$.1... ...%. ...&.2.. ...'.3... .(.4.) .! .* . . .  . . . . ." .+ .5 .6 . . ., .-..../.01 , @ @ @ @ @ @ @........ . . .............. .!.".+.5.6..#.).-.1. .0.4..*./. .,.2.3.%..$.. . .( ...&..'1 , @ @ @ @ @ @ @.......... . . . . ....... . . . . . . . . . . . .  .! ." .# .$ .% .& .' .( .) .* .+ ., .- .. ./ .0 .1 .2 .3 .4 .5.6 ,@@@@@@@@@@@@@@. .... .. ... .  . . . ... ... .  . . . .  .  . . . . . . .   .!  ." .# .$ .% .& .' .( .)  .*  .+  .,  .- .. ./ .0 .1 .2 .3 .4  .5 .6 iY #Q[@N44  Y  Y dY Y  Y Y  DATA_CATEGORY_IDDATA_CATEGORYDATA_TYPE_ID*NUMERIC_CRITERIA_FLAGBIN_DESCUSER_WEIGHTDATIH46DEIL_EB47IG48YYYY9Y.rD DATA_CATEGORY_IDDATA_TYPE_ID<DATA_TYPE_LUTDATA_CATEGORY_LUTPrimaryKeyv1@  3 Kr z 4  Epidemiological LinkNumber of Outbreaks=(? Susceptible PopulationStrength for Evidence of a Susceptible Population]*7 Shelf LifeShelf Life Time (Days)6?Infectious DoseInfectious Dose (Number of Organisms)J#?HospitalizationHospitalization Percentage?#?Growth PotentialEvidence for growth9$7Epidemiological MultiplierTotal Case MultipliersF.?DeathDeath Percentage+?ContaminationPrevalence Percentage8!?ConsumptionConsumption Percentage7? 3 @5555555 5 5 5  3 @5555555 555 3 @5555555 5 5 5 CYN::Y  Y dDATA_TYPE_IDDATA_TYPE :<YA_T:=_IY3YY.rC PATHOGEN_TYPE_IDPrimaryKeyv1 9Production/ProcessingHealthAgent 9;;;9;;; YN??Y Y Y  (PATHOGEN_CATEGORY_IDDEATH_PERCENTUSER_BIN_RANKD?A3?BYYY"DEATH_PATH_CAT_FKPATHOGEN_IDPrimaryKeyv1>xgVE4#fffff2@? ? ? G%u{? 333333? {Gzt?{Gz?@?gfffff?(\@? > @ @@@@@@@@ @ @ @  @  @ @ @  > @ @@@@@@@@ @ @ @  @  @ @ @ : Y7NDD77 77Y Y Y Y Y (PATHOGEN_CATEGORY_ID*COMMODITY_CATEGORY_IDOUTBREAKSTOTAL_CASESUSER_BIN_RANKDFMDGNYDHYYYYY*COMMODITY_CATEGORY_IDTCOMMODITY_CATEGORY_LUTEPIDEMIOLOGICAL_LINK(PATHOGEN_CATEGORY_IDRPATHOGEN_CATEGORY_LUTEPIDEMIOLOGICAL_LINKPrimaryKeyv1@ I C7oR5jM0 e H +  } ` C & x [ > !  s V 9   ?;@  @(@ 3@@@a@ @``@ ?;@ @@ @Z@ ?0@ @N@ 1@@ @]@n@ @@ ?I@ ?r@ *@`t@ @@`@ @Z@ @@ ? @ @@^@ ?$@ ?L@ (@{@ &@z@?@?.@ @&@ @ b@ $@s@0@@@D@@s@ @@ @L@?P@@@@ @ @J@ (@{@ @@@@ d@? @? @ ?@ 6@V@ $@z@ ?7@?*@ @`@ ?*@ @@h@ @s@@<@"@ܕ@1 C @ @ @ @ @ @ @EEEEEEEEEE E E E E EEEEEEEEEEEEEEEEEEE E! E" E# E$ E% E& E' E( E) E* E+ E, E- E. E/ E0 E1 E2E3E4E5E61 C @ @ @ @ @ @ @E E$EEEE%E E/EEEE&EE EEEE'E3EE( E) E E E E* E0 E E E E E E E" E+ E E  E E E E E! E# E, E1 E2 E4 E5 E6 E  E E E  E-E. C@@@@@@@@@@@@@@EE E E E EE E E E  E E E E  E E EEEE E EEEE E E EEE E E E  E!  E"  E# E$ E% E& E' E(  E)  E*  E+  E,  E- E. E/  E0  E1  E2E3 E4 E5 E6{ }Y7NJJ77 77Y Y Y Y (PATHOGEN_CATEGORY_ID*COMMODITY_CATEGORY_IDMULTIPLIERUSER_BIN_RANKIRKJLYJMUJNYYYYY*COMMODITY_CATEGORY_IDTCOMMODITY_CATEGORY_LUTEPI_MEAD_MULTIPLIERSRPATHOGEN_CATEGORY_LUTEPI_MEAD_MULTIPLIERSPATHOGEN_IDPrimaryKeyv1@  I7mXC.q\G2 u ` K 6 ! y d O : %  }  4@ 4@ 4@4@ 4@ 4@ 4@ F@ @ 4@ 4@ F@ 4@ 4@ C@ 4@ C@ C@ C@ 4@ F@ 4@ 4@ 4@ F@4@C@ 4@ 4@ F@4@C@C@ 4@ 4@C@4@C@ 4@ F@ 4@4@F@C@ 4@ 4@ F@ 4@C@ F@ 4@ F@ 4@4@C@1 I @ @ @ @ @ @ @KKKKKKKKKK K K K K KKKKKKKKKKKKKKKKKKK K! K" K# K$ K% K& K' K( K) K* K+ K, K- K. K/ K0 K1 K2K3K4K5K61 I @ @ @ @ @ @ @K K$KKKK%K K/KKKK&KK KKKK'K3KK( K) K K K K* K0 K K K K K K K" K+ K K  K K K K K! K# K, K1 K2 K4 K5 K6 K  K K K  K-K. I@@@@@@@@@@@@@@KK K K K KK K K K  K K K K  K K KKKK K KKKK K K KKK K K K  K!  K"  K# K$ K% K& K' K(  K)  K*  K+  K,  K- K. K/  K0  K1  K2K3 K4 K5 K6 Y7#Q[@NPP77 77Y Y  Y H Y Y( Y N(Y (PATHOGEN_CATEGORY_ID*COMMODITY_CATEGORY_ID2GROWTH_POTENTIAL_COMMENTSDEFAULT_BINUSER_BINUSER_BIN_RANKYPRYPSPTYYYYY*COMMODITY_CATEGORY_IDLCOMMODITY_CATEGORY_LUTGROWTH_POTENTIALJPATHOGEN_CATEGORY_LUTGROWTH_POTENTIALPATHOGEN_IDPrimaryKeyv1O7lG"F b =  _ :  ^ l G " iDwR-hC SomeSome ; NoneNone ; MediumMedium  ;MediumMedium  ; SomeSome ; SomeSome ; NoneNone ; NoneNone ; NoneNone ; Yes, at room temperature (22 - 24 degrees C)MediumMediumxpd ? SomeSome ; NoneNone ; NoneNone ; NoneNone ; SomeSome ; SomeSome ; NoneNone ; NoneNone ; NoneNone ; SomeSome ; NoneNone ; NoneNone ; Yes, at room temperature (22 - 24 degrees C)MediumMediumxpd ? StrongStrong  ; NoneNone ;MediumMedium  ;NoneNone ; Yes, at room temperature (22 - 24 degrees C)MediumMediumxpd ? SomeSome ; NoneNone ;SomeSome ;NoneNone ;NoneNone ; SomeSome ; SomeSome ;SomeSome ;SomeSome ;NoneNone ; SomeSome ; NoneNone ; NoneNone ;SomeSome ;NoneNone ;NoneNone ; Yes, at room temp (22 - 24 degrees C)MediumMediumjbV ? damaged, chopped, or sliced tomatoesSomeSomeb\T ? NoneNone ; NoneNone ;NoneNone ; NoneNone ; SomeSome ; NoneNone ; NoneNone ;SomeSome ;NoneNone ;1 O @ @ @ @ @ @ @QQQQQQQQQQ Q Q Q Q QQQQQQQQQQQQQQQQQQQ Q! Q" Q# Q$ Q% Q& Q' Q( Q) Q* Q+ Q, Q- Q. Q/ Q0 Q1 Q2Q3Q4Q5Q61 O @ @ @ @ @ @ @Q Q$QQQQ%Q Q/QQQQ&QQ QQQQ'Q3QQ( Q) Q Q Q Q* Q0 Q Q Q Q Q Q Q" Q+ Q Q  Q Q Q Q Q! Q# Q, Q1 Q2 Q4 Q5 Q6 Q  Q Q Q  Q-Q. O@@@@@@@@@@@@@@QQ Q Q Q QQ Q Q Q  Q Q Q Q  Q Q QQQQ Q QQQQ Q Q QQQ Q Q Q  Q!  Q"  Q# Q$ Q% Q& Q' Q(  Q)  Q*  Q+  Q,  Q- Q. Q/  Q0  Q1  Q2Q3 Q4 Q5 Q6 .YNVVY Y Y  (PATHOGEN_CATEGORY_ID.HOSPITALIZATION_PERCENTUSER_BIN_RANKO_SNVXRIRKVYYYY(HOSPITAL_PATH_CAT_FKPATHOGEN_IDPrimaryKeyv1UxgVE4#V@R@ gfffff+@ 4@ )\(? *@ ?333333%@33333sC@ffffff@3333336@T@&@333333? U @ @WWWWWWW W W W  W  W W W  U @ @WWWWWWW W W W  W  W W W  wYN[[Y  Y Y Y  (PATHOGEN_CATEGORY_ID*INFECTIOUS_DOSE_RANGE:INFECTIOUS_DOSE_NUM_ORGANISMSUSER_BIN_RANK[]YY[^YYY DOSE_PATH_CAT_FKPATHOGEN_IDPrimaryKeyv1@  ZtM&fG(חA10^8j@10^5 $@10 .@15 - 20 Y@< 100 $@10 - 100  ?1.A10^6$@10 - 100 $@low dose ?1 - 10.A10^6@@500j@10^5 - 10^6& Z @ @\\\\\\\ \ \ \  \  \ \ \  Z @ @\\\\\\\ \ \ \  \  \ \ \  Y=N``(=Y Y DataIDDAY`IYAOIndexv1?K_[aSwxO SysAccessObjectsQLLLLLLLLLLJ Form&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRptNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By    08.50  W* "Risk Ranking Tool            " Form.frm_Main  w   %&@&p&& & &&TooltipVisibleIsDefaultButtonIsCancelButtonIsEnabledUseImageFilenameDateCategoryTitleDescriptionSizeOriginNoPreviewImgValueLayoutPositionCurrentFileLocationFilenameEnabledShowDescriptionMaxFilenameLengthShowStatusStatusMessageOnlineEnabledImageWidthImageHeightgs#DialogViewbuttonimagelabelsimpleButtonIsEnterFocusableelementhyperlinkTemplateCategoryLabelTemplateDataLabellistcontentTemplateCategoryStaticlistviewitemTemplateCategorypreviewLineItemdescriptionLineItempreviewLineItemExpreviewLineItemOnlineOnly0previewLineItemLabelgalleryContainer1statusContainergettingstartedContentPaneLinkFeaturedContentfeaturedcontentcontrolGettingStartedFeaturedContentEventHandlerLeftPanescrollviewerSelectSingleItemTemplateCategoriesGallerylistviewSelectedIndexHasVerticalScrollbarHasHorizontalScrollbarTemplateCategoriesShowInformationTemplateCategoriesHeadermsocbvcrOGGrpHeaderBkgSelectionItemTemplateLogoClickCommandStyledParentBrowseCategoryIsSelectedMainPaneGalleryAndPreviewCenterPaneScrollBarSheet#OfficeLightScrollBarViewBrandingSpaceSrcCategoryAreaGalleryAreaTemplateGalleryEventHandlerOfficeSpaceQATSuperTipEventHandlerRightPanemruImageSourceImageSrcmrufileIsAcceleratorIgnoreddocTplidPreviewDetailslineTypeStrokeStrokeWidthlblFileNametextboxIsEditableIsMultilineMaxCharactersIsDelayLoadDesiredLocationtplPreviewImageidSharepointOptionsfooterExecuteActiontplBtnLinkWithTooltipsRoot#gsGalleryDataSourcedDataSourceShowBorderLayoutAnchorCanGrowIsEnterBubbleEnabledIsStaK_[ࡱ> inkmpRoot EntryQI7@IVBA0knRP(DVBAProject `t{R?CVBA`t{R?C6  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghj      ("#$%&'*)+,08:;<=>?@ABDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~0PaQIBlob PropData =TypeInfo>BlobDeltaO DirData PropDataCmdbars0knR0knRK_[!n2_highd -lbl_linkm,txt_link|!Binsd .Label51d /Label52d 0Label53d 1Label54h #cmd_runm2txt_bin4h 3cmd_resetBinsm!txt_populationg5Image59d 6Label60d 7Label61d 8Label62f9Line63f:Line64f;Line65|!Weightsd lbl_slgpmtxt_slgpd <lbl_Bin1d =lbl_Bin21D/1Fd    g    h    l    m     n     {    {|    nmmmmddddddmmdddddhdd|    mdmdmdmdmdmdmdmdmddddf    f    f    dh!gK_[!frm_Main 0CB0028=Babc\+e gDiXkX }]@|X֠F>\ Uu~XCSa @Pu@R 44K_[Two-sided (Duplex) PrintingdMicrosoft Office AccessDomain Users;EHS GIS Admin;09627.001_users;08249_users;08784-users;HSER_RTPLSAS04_USERS;STAFFNET_Web_List;08673_Project_Mgmt;STAFFNET-Web_ListTwo-sided (Duplex) PrintingMSACCESS.EXEC:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXEIPACDRWDSGATCAPI;F4E8Q;Ki݅&E%9xPPBHAERPK_[G2p981.printer.rti.orgd2 Tahomag237hgh Tahomal2m45 Tahoman2 Tahoma{ Tahoma` Detail #! @9vZ{1U5`abO)ceTabCtl0w)~KN(|1`,abA(chBins uOyIBـcn3A`a(bc d j "lst_data_categoryTable/Query8SELECT DATA_CATEGORY_LUT.DATA_CATEGORY_ID, DATA_CATEGORY_LUT.DATA_CATEGORY FROM DATA_CATEGORY_LUT WHERE NUMERIC_CRITERIA_FLAG=Yes ORDER BY [DATA_CATEGORY]; 0;1440"[Event Procedure]O"#kM#Um7F`aTbc,i ktxt_Bin1General Number"[Event Procedure]%" G/.m7F`a4bc,i ktxt_Bin2_lowGeneral Number"[Event Procedure]@) J Jm7F` a4b(c,i ktxt_Bin2_highK_[General Number"[Event Procedure]=DđOUuNZ^m7F`a bc,i ktxt_Bin3_lowGeneral Number"[Event Procedure]n3TA4{ld5`a bc,d lbl_Bin3Medium Highf(GnGd57`a8bc,d elbl_Caption Death Percentage"mB&,~cTd5`aTbc,d Label40<G=+M5+d5`a bcd Label41>D+ALEKnd5`a4bcd Label42 <  E#KKmd5`a bhcd Label43 <=|D_B DU)m7F` a b(c,i ktxt_Bin3_highGeneral Number"[Event Procedure]2b_8J9B%اm7F`a bc,i ktxt_Bin4General Number"[Event Procedure]6)'Eu7qPd5`a bc,d lbl_Bin4High1|@ Eqekd5`a4bcd Label51 And/.G93dWG d5`a bcd Label52 AndGl8H]VY=c1*d5`a4b,cd Label53>=< NC3d5`a b,cd Label54>= A@ύXuh1`Tahbg hicmd_resetBinsReset All Bins"[Event Procedure]I Mlsm d5`abc,d lbl_bin1LowMpiƬF2FUd5`a4bc,d lbl_bin2 MediumA/A[}cW@n|1`,abA(chWeights_5Erm7F`P abc,i txt_infectiousGeneral Number"[Event Procedure]t^(F_#,6d5`abcd lbl_infectiousInfectious Dose^KF@m7F`P apbc,i ktxt_populationGeneral Number"[Event Procedure]JR EjI9pd5`apbpcd lbl_populations.Susceptible Populations ׀B9oym7F`Cabc,i ktxt_hospitalGeneral Number"[Event Procedure]B;J ;Nd5`abdcd lbl_hospitalHospitalization]F'_N(Bm7F`Capbc,i ktxt_deathGeneral Number"[Event Procedure]T;Oz͏znd5`apbcd lbl_death DeathcUOcfm7F`Ca bc,i ktxt_linkGeneral Number"[Event Procedure]ajNY$d5`a bcd lbl_link(Epidemiological Link@iN)~Dm7F`4a bc,i ktxt_multiplierGeneral Number"[Event Procedure]1pLNd5`a b cd lbl_multiplier4Epidemiological Multiplier:O$4%Bym7F`%abc,i k"txt_contaminationGeneral Number"[Event Procedure]eyg,@K}d5`0abdcd "lbl_contaminationContamination݅r4mLhom7F`%apbc,i ktxt_consumptionGeneral Number"[Event Procedure];IVC幪d5`0apbcd lbl_consumptionConsumptionۇL>}wEm7F`%a bc,i ktxt_slgpGeneral Number"[Event Procedure]sI\IzAsd5`0a b cd lbl_slgp>Shelf Life and Growth PotentialِJ@EґT.Gd57`a(b| c,d eLabel60 AgentϥhPrL@S9d57`a(b c,d eLabel61 HealthUVu47GDSd57`0a(b c,d eLabel62*Production/Processing나0O_Ff3wK_[`aTb| Line63xw LלkJf3w`aTb Line64D+N.O=rkf3w`0aTb Line65"IYVBO1d5U`DabXcde33Label15"Risk Ranking ToolMaiandra GD TׄܩC{h1U`ab(cg hicmd_runRun"[Event Procedure]؛ZPFSSKYg6`abTcdImage59\$Q &" Xg L   .-)-.$4KK^7`M8)444&&-$~ukaVK?5*! !0?N]lz   ss_eHU0D1 #w!| !Iq     &048$;,>3@;CCEKHRJZK`NgRlUrYv^zd}ioty}s-$H&W;hS{o.K)e;{JV_eioy /AQanztg\PE:/%  !  yqhaYTNIDA=:86444 57:=)A3F>KIPSV^\hcqiyou| wmcX OD:0( ~l[H6n$[I9," p^L<-ui_ YUSQOMKIGECA??=}<y<y<:!7HH-$yk_RH<4,&nS5fJ1kXJ=2$ vmda_c~koybVLD>:7 6%5>7V8n=AGNV[^^]YT*N8GF@S9a2o-}(&%'+08BLXe"r0=JU`jsz .?P`o~}xrke]VNG?7/(  vnf^WPJD>951-*'%##"##$%&'-)3+8-=1A4F8K<RCXH_PfWl_sgyp~y@W-$w!>D=HMGKGHGAG:G0G%GH HIJLNPSX\agov-8CJOSY`it~&7FUbpz$2 =GP\gu #&),/36: ;;:962 .#*$%& ())+++">@/!>!>Yn-$pw~0G_w !&0,E1Z8o>EJQV\`ehkl osvz!#$&&(()+(!}eN9' ~reWJ:+x nf_ZTOJF@;6}2r-f(Z#OD8-"  K_[wwcB-l$$6HZl~ .<JXdp{!)08?HPXaipx~Y LLM"N*R6UB[Qb`kqt+E^v -D[p  $(+.14788O    ] !    mXRSW$\.b7iAqKyV_iqy-<$cb`\XSMG@92+%   u^DB=:73/*&! $' , 17=ENV_ipx.026:?EKQX^djpuz"*29AFKOQQRSTUVWYZ\]_abe~gzjunprhxa}XOF=4+#cc+-$^N:Q;S>WCYE[I]L_QaUc[eagiipj{kkkkkkjjii hgg!g#h$j*k-l2n7o<oAoGnMnRlWj]fabf]iXlRnMpGqAr<r6s0r*r$rrqqq qpppponmkifb_ZTNG>6-#I//N:N:u-$LCDEGIKORV Z_di"p&u+}-037:=?BBBB@<82+! ~{wsnic^YUROLJFDCCC0G-$cd"h(o2w<IWfv 3I_v  &*06:BENP[[gftq{  *9"I(W-f2s6:?CFJLOPRRRQOMJ E@:4(kJ,!$'*-013z3p3f1^.V)P#LHDA?\><::G9877]787!777`cc-$+:IVdp{   Bqruz #)06<AFJOSVY]_beiloszvuyp|l~iecaa_\WPF=3({xvv|wqle]TKA6+{ vs pnlkkklosytfYK>2)  xlaVNE?:84.'  $(,.000133579;=ADKQV\_cefY)-$l?m?qBsCvEyG}JKOQUX\_dhnt| $)/6>F K_[NU]c}iznxrvtvvVUQLF=5,#ljgc]UMD:0%~tkbXOF>5-$ |uplkjhea\WQKD?82 -($!!(08AIR[dlt{!#&')*,---.-,+*))(((((%(+(0*5+9.</?1C2G4K5P7T8X:[:_<b<f>k?l?l?n-P$&i|mx '0:CNYcmwi|i|@-T$(!%)}+z-u/p1i3c4]4W5R4L4G4C3?2<1:/8.8,<*?(B'F&J%N$R$V"Z"]!a d g lnǔ-$]^adi)o6vE}Tfw*6CMXaipuyz| %.6>EMSZ_dinqtx{}~ '/8?HQZ}cyluvqle_XQIB:1'yrkc\TN}FxAs;o7k2i0g.f,b(^"XQJB:0(   }rfZL?1$ }uojfb`^]\\\\\] ]]]Yn-$uu$UhSUuu}-$sE0F0I/O-W+`)j'u&%$$&*-3:DOYdoy %1=GR[dkqv|}qdVK@7/)# vlbXNC8." zric\XTQ O OE0E0c^-T$(^'-145\Y\^^^s-r$7 8XXY[]`beghhge` Z#R$H$<#3!*#    yof`\Z!-n$5#FEB<7/( !&-28?ELU`m{   ###M-$ {|2)XE=Oo{{+-$a8a9b;c@fFhLlTp\ueznv~ &-4:?DKR\fp{ |jZLB<:83-$ zrkd^XSNIE~By?s=o<m<l'4'1),))+%-!.0258: > B FIMPSUW Y$[']-_3`6a8a80-$r ~|zyw!u$t(r,q0q5r8r=tBwG{KNPSSSSSRQPONMLLKGA90 K_[% |qh]TKB:50-)))+{.w2t6r<pAoGoMnToZoaqgsmuswxy~|x-:$#.&91B=KITU\aamfzjnprtuuuuuuuuutqonlki i ijkmpuy }pcWLA7.' |wsoid_ZUPKGA<5/(" +-b$/)),.37=BI NTY_dgjlllkjgea^YTNIB;3,$))Ԋ!-$PWVTPLF@80&     !&,2:AHNU[afknruxz{}}}{ywspmjfb_]XWWz+-$]}{xvsolgb\VNG>5+#  "%%',)3+:-@/F/L0Q0W0\0b/f-k,o*t(w${!~  }}nM-$$"&,27<A(F=JRLgNzMLHDA>952/+ '$" !#$&*-25;?EK Q X _ elquww"u's,p1l7g;d@_D[HWKUNRORPQPNRHTBW;Z2_(chm quz}|odYOE=61*" |wrnhd_\YWUUUTSR}PvOoLhJ`FZCT?P<L7J2J-L(O!SW\afkquy}-$lADHMRV[`fkpuz&.7?GMQTUW\_cglpsvz|{vndXK=/ }xtokgd}`w^r\m\i]e_ab^h\mXrUwR|PNKIHDCAAA+-$g   ")/6<BGLQT X#['_+a1d7f=iCiIiNhTgXd\`_[aUaNaF_=^5\,Y$VSP LIGDCB@=:741-*&# @-$Clll l$n)p/q6s?vHxQ{Z}dnvxrkd]WPJE@<:8ll-$a  &-6=FNW]dioruxz}$+28=BFKMPRTTUTTRP K_[NKHD?:4/(! zrkc]UPIE@;62-)%!  $qpo oooo&o/o:qEqQs\tivux|   ytnid_YVQMIFB@><96}3u0k,a)U%K#?3("%*06=DJQV]bgjmoppP$&5c%  {xwH5c5c+-$a~{zvql|fw_rXmRhKdD^>Y8T3O/I-C,>-9.21.5*:&@#G!OW_gn v"}$&*.159<@DHKORVZ^cglpv|$Ohhjnsx&-38=@AA?=;740,' #   |tmfa\WSPJFCChhў-$L+++***)((&% #"#*28>DINSWZ^ __][XSPLHD@<83.(# "'*++Ԋ!-$Q<}xqjb[SNGB=;9:<@DIMQSVY{\w^sandjgej`nZqSwL{B;3,%     $(,04:<<+-$?\\\[YWTPMHB;4*!}xsmgb^YURNKIFFEGJNSZahov|  zE-$[??@ADFJMRV[aflr x%+17:?BFHJKMOOOONLJHDA<71*" ~{xt|pxmvitesaq^qZoWoSoRoNoLp??+-d$0 !&&.+50<5A7E9I:L:O9Q7S4U1V-W(W$WVVUU SPLID@;71,($B-j$3"1#&*/1332.(   '-27<@DGKMOPQPPyNtNoMiKdJ^IYGSFODJCGABAA"1"1Yn-$Nz8  {tngd`\YVPJD>:62.)%!z8z8@-t$8JJKLPQSUW]cipu{~~|yvqmid_ZURMJG K_[E@<62.+)))++-/27<AFIJJG-T$(   !(.4:@EJOSVVSNJGC?;63/*'$     +k-Z$+M '09?FKORUWZ\\\MM$mlnptw| '0;GUan{}wqjc\W~PzKwEtAq<m9i7f6c4^3Y3T3P2K2F2A2>09/6-4+3(2$3 59<@ DIMQUZ]acfjll$`&/: F R^kv!%)-16:>ADE EDA<83/)$  {ti]OC80(#&Y-&$0023 8<A"G,O7WC_NiYsd}nw&.6=EMU]emt{~~||zzz{|t}g~\NB5)~}zwrmhb[UNHA<62-+)(%! {siaXRKFA=:74310000+k-$k<9<7<4;/;(::: ::::<=@BGKOSY_djpuz}}xrlgb]YUSONL~LsLiN_PWTMWF[=_7c0g+j%o!tx~    !%#)&-*3/84;7<9<9$M^_]^\]YZWWSSPNMIJDF=C6A0?*=#<<?@ DGMRX_flsz $+2:@HNTY_begiiiknqvx{ -$a z}uypvlrinfhdcd\dUfMiGlAq=v9}64322469<AGMSYahov~  %*.37;>BEHJKKJHFDA=:750/-:$ &-4;CJQX^diknooo nkieb$^)Z.U5Q:MBIGENBS?Y=^:c8h6m6q4v3z333345579;=@CFHJMOQSSTQLHD?;4/)# xpibZSLF?82-'#   $PLMPV^fpz&0;DNV^dksz} K_[xsokgdbz`r^l]f\a[\ZXXTXQTKPFLDHAD??<8918)7#78: <>@CDGHJKLL&Y-$?stx}  &+05:>BFILOPRRSSSRRPO{MvLqJkHgFcE_B[?W<S9Q2J,G(E$C!BA@@sss-$p $/7@GNTY]ac ffh!h)h1f8d@cHaP_X^`\iZpYxWWWWXY\^^\YSNGA91*#y q j d ] W Q K F @ : 5 / )$ Yz-$liYiXgTePcK_D[<V3Q*J B: 2(BA=:753222247:?FNWakx~~~~&1:DLU\dkqx~  %*049=BGKOSY_bdiYiYG3-$ooorv} #+4=FNW`hqz    ~xqjc]UPJEy?t;n7i3e0_,[(V&R"MID@:4.( !   $*06;@CFHIooc^-$>!#&*.4:CMXcm t |   |wrniea^YUQMIEA>9520,*(&$"! f-$pxodWI:z)ur pommmmlkjigd_[UPKHDB?><:Root Entry "a s@IVBA0knR "a VBAProject `t{R "a VBA`t{R "a 9 9777 7!7%7+737<7G7S7a9m9z;>ADJOU\ckrz  )}-$322 2335#7*;3?;DEKOS[\fgsq}    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghjroltvwxyz{|}~PROJECT K_[3PROJECTwm:PAcessVBAData< Forms 0knR]'      ("#$%&'*)+,  !"#$%&'()*+,-./012456789;?@ABCDEFGHIJKLMNPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~0C911005A};VBE;&H00000000 [Workspace] Form_frm_Main=22, 22, 1058, 802, Z mod_utility=44, 44, 1080, 824, Form_frm_MainForm_frm_Mainmod_utilitymod_utilityͬ4Z:D<+GDetail{ TabCtl0d Label15nlst_data_categoryd lbl_Bin3dBox\.Descri End1NvalVariaC!릡DBEngine(0)X>@DuBQ*SQnapshotIf LEOF Thepn 8"ElR BAJIf IsNulEF)V iE ID="{A1AA6910-4F55-4A32-A968-CD3449D91C9A}" DocClass=Form_frm_Main/&H00000000 Module=mod_utility Name="FDA_EPI" HelpContextID="0" VersionCompatible32="393222000" CMG="C2C01E5EE462E462E462E462" DPB="848658A0D863D963D963" GC="46449AE29E66616761679E" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00AIKEKACGELHROHEJFBUSSIRBHKCQI: h MDTSDDKSZPCYAESXXSSVGAWXTAHC:_VBA_PROJECTudir0* pHdFDA_EPIQ(@= l p%J J< rstdole>stdoleP h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\e2.tlb#OLE Automation`DAO>JDAOA A5E0 1A5AProgram Files\CommonMicrosoft Share d\;360.0DLL# 3.6 Object Librar&yHAD@ODB> ADDZDB\=\\10-8AA006D2EA4N1N.SS\\ms`ado21T+ActiveX Data-s 2.1K.B W *mod_utilit0yG@d_uK_[@ii yIKEKACGELHROHEJFBUSSIRBHKC QI28AKEACGA@LHRGHJF@IUSU@I@BK Q4IB1BB,-H!+B@\Form_fMainG*#0rm1fMain1MDTSDDKSZPCYAESXXSSVGAWXTAHC1Mu*T)DKZ"P*YA1SX@1V8AWu@T@H@I1~1"0(bbWxam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL#Microsoft DAO 3.6 Object Library*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ADO\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library p%JW8IKEKACGELHROHEJFBUSSIRBHKCQI014dac14fbmod_utility8MDTSDDKSZPCYAESXXSSVGAWXTAHC024dac14fbAForm_frm_Main~8xVP3J@VỌQKvq& H|:AccessVBAWin16~Win32MacVBA6#FDA_EPIPstdole`DAOADODBs mod_utility+j _EvaluateSIDEBAR8wsqlstrdbMainqtrec Recordsetqry1ǟCommand] err_handlerlCurrentProject$ Connection adOpenStatic RecordCount{MsgBoxRErro Description sqlval7DBEngineQ OpenRecordset|dbOpenSnapshotEOFIsNull Form_frm_Maincmd_resetBins_Clickp RESET_BINSlst_data_category_Click cmd_run_ClickY error_msg CHECK_BINStxt_consumptionValueKtxt_contaminationw txt_deathQtxt_multiplier>txt_link[ytxt_slgp8 txt_hospitaltxt_infectious ~txt_population UvbOKOnly ASSIGN_BINS aRANK db\rstbin1bin2_low]ubin3_low+ bin2_high{t bin3_high1bin4data_catN[response Application* CurrentDbSMoveLast MoveFirstN bin_numberF bin_high_user data_categoryC; bin_low_userMoveNextL! Form_Open-CK_[ancel RESET_FORMlst_data_category\ExecuteYpopulate_labels7populate_labels_multi_catQ data_cat_idatxt_Bin1VisibleLabel40 txt_Bin2_lowLabel51Label53 lbl_CaptioncCaptionxlbl_Bin4lbl_Bin3lbl_Bin2lbl_Bin1txt_bin4 txt_Bin3_high=6 txt_Bin2_high txt_Bin3_low[ start_tablek~start_table_count)RANK_PROCESS_TABLE?DoCmdƧ OpenReport acViewPreview2 tablename` weight1 data_typeadd_risk user_bin_rankpathogen_category_idoCOMMODITY_CATEGORY_IDM UPDATE_BINS UPDATE_MULTI_COLUMN_BASED_BINS'DETERMINE_SLGP_BINa bin_columnrcriteria7bin_rankDETERMINE_NUMERIC_BINDETERMINE_NARRATIVE_BINrEdit+Updatecriteria_column>6 data_value bin4_low8SUM_SL_GP_RANKbin3bin2 txt_Bin1_ExitEtxt_Bin2_low_ExitQtxt_Bin2_high_Exit|ktxt_Bin3_low_ExitMKtxt_Bin3_high_ExitO txt_Bin4_ExitgL update_weight0)data_category_idVtxt_consumption_Exittxt_contamination_Exittxt_death_ExitTa txt_slgp_Exittxt_hospital_Exit[txt_infectious_Exitu txt_link_Exitktxt_multiplier_Exittxt_population_Exit)s`A    $ffice\OFFICE11\MSACCESS.EXE8~WxME PS<S<S<<<<<<XN0{07AB005A-3AA3-44B9-97A4-3CE1D62B47A2} B@ H`J,LAi !< h % j0%`l`n`p`r`t`vq!`x`z X8i F`ORY_ (;iTEGO`TA_C h+iATA_`BER f(8`j`` 8h&iii`K_[ h % j%` dx #iiii hP % jp%` $iii0iPi h % j%`,+i(iHi ``p`n` ` 4 h  % j@ %`,x +i i i `v```l` D 8`    P i`  i` x @ i`  i` h 0 i`  i` x i@I ` i  8i  xi i X8iD i i xXi  i% !x- " "(0 8  0@px  6@   BK_[ (08@HPX`h p x  0      ( 0  8 H P  X h p  x   $$\@PX `ph     (08H " PX `h  p 4  "    ( ,8h x   "    ( $ (@ *h ( * $  $( (P *x ( * $ (  8  H  X  h  x L  R H R`  R ( R@  \  ( \@   \ 0H `hp "         L@ RX R  R8 R \x \  \8  "   4 ( $  H BP * , 6 0 @ 6H * , *    h(  f8, (x.6$.0.`4,> L8 p N &H p :  "   0 HPX  `p 8 P  x   " @ P(Lx 2D FH L z <`! L!D! 88">p" " " " """" " "#K_[ # #(#  0#@# X#p# ## ## #### ## $$$ $ " ($0$8$@$ H$ P$h$ $$$  $$ $$ $$  $% % %(%0% 8%@% H%P%X%h% B p%x%%%% % \%& \&p& \&&  &X'X' h'X'' 'X(X(  h(Xx(( ((( ())) " )()0)8) @) H)(* 8** +8+ P+X+`+  h+x+ + (+ + (+ + + , ,  ,(, 0,@, P,`,h,p, x,, ,,,, B ,,,,,, , R,@- RP-- R-. R .x. . . X. ./ X/ `/p/ Xx/ // X/ @0P0 X0`0 h0p0x00"00 0 X01 :1P1 @`11 011 21(2 *82h2 @x22 :23 43P3 4`33  Z3 4 0(4X4 Jh44 J45  h(5 05 "5 5556 "6 6  686P6h66666666677(787H7X7h7 Dx77 7777 " 78 8 8 p 88 p89  9(909@9" H9P9 X9 `9 pp99 p9`: p:x:::" :: : : p:0; p@;K_[; ;;;;" ;; ; < p<< p<= == =0=" 8=@= H= P= p`== p=P> `>h>p>>" >> > > p> ? p0?? ???? " ?? ?  ?`@`@p@ x@@@@ " @@@ " @@@ " @@A " A A8APA " XA`AxA " AAA " AAA " AAA " ABB & B 8HB 6B BBxADAFoX@]$@)check that the bins values are increasing L'J JERROR|hk`/check that all the data categories have weights !N!P !R!P !T!P !V!P !X!P !Z!P !\!P !^!P !`!P-Please enter a weight for each data category. b$.'J|(k AdAf|$ 0!2A@.o]]]8]P]h]]]]]$ !|!~.h SELECT BINS.DATA_CATEGORY_ID, DATA_CATEGORY, BIN, BIN_NUMBER, BIN_RANK, BIN_LOW_USER, BIN_HIGH_USER FROM BINS, DATA_CATEGORY_LUT WHERE BINS.DATA_CATEGORY_ID=DATA_CATEGORY_LUT.DATA_CATEGORY_ID AND NUMERIC_CRITERIA_FLAG=TRUE ORDER BY BINS.DATA_CATEGORY_ID, BIN_NUMBER h%8.j)check that the bins values are increasingNONE'L jC@C@5<b66'l6'x6e6'n6'r6e6'p6't6e6'v l n r p t v l r  r t The values entered for the x" bins must be in increasing order. b$.'zERROR'LzkdThe end values entered for the x2 bins must match the previous and subsequent bins. b$.'zERROR'LzkkC@q.j.hz$ 0!2A@.i$ADAselect first item !(PAF,UPDATE DATA_CATEGORY_LUT SET USER_WEIGHT = 0'  ~B@|$ 0!2A@.oX]$ !PRKKKKK KT !PA@R KT !PA@S`AnP|H$@ 0!2A@.o(]$" If DATA_CAT_ID = 3 Then 'DEATH txt_Bin1.DecimalPlaces = 1" txt_Bin2_low.DecimalPlaces = 1# txt_Bin2_high.DecimalPlaces = 1" txt_Bin3_low.DecimalPlaces = 1# txt_Bin3_high.DecimalPlaces = 1 txt_bin4.DecimalPlaces = 1 Else txt_Bin1.DecimalPlaces = 0" txt_Bin2_low.DecimalPlaces = 0# txt_Bin2_high.DecimalPlaces = 0" txt_Bin3_low.DecimalPlaces = 0# txt_Bin3_high.DecimalPlaces = 0 txt_bin4.DecimalPlaces = 0 EK_[nd If ( ( ( ( (>SELECT BIN_DESC FROM DATA_CATEGORY_LUT WHERE DATA_CATEGORY_ID= ' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4 !(5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4 !(P $4 !(P5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4 !(P $4 !(P6SELECT BIN_HIGH_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4 !(P $4 !(P|$ 0!2A@.ox(]$` ( ( ( ( (>SELECT BIN_DESC FROM DATA_CATEGORY_LUT WHERE DATA_CATEGORY_ID= ' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4 !(5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4 !(P $4 !(P5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4 !(P $4 !(P6SELECT BIN_HIGH_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4 !(P $4 !(P|0 $( 0!2A@.o ]]]$ find the table with the most pathogen category - commodity category pairs (either contamination, epi mead multiplier, epidemiological_link, or growth potential)-sqlstr = "select count(*) from contamination""start_table_count = sqlval(sqlstr)start_table = "contamination";sqlstr = "select count(*) from EPIDEMIOLOGICAL_multipliers"#If sqlval(sqlstr) > pair_count Then& start_table_count = sqlval(sqlstr)/ start_table = "EPIDEMIOLOGICAL_multipliers"End If0sqlstr = "select count(*) from growth_potential"#If sqlval(sqlstr) > pair_count Then& start_table_count = sqlval(sqlstr)$ start_table = "growth_potential"End Ifa'populate the rank_results table with pathogen category - commodity category pairs of start tablesqlstr = "insert into rank_results (pathogen_category_id, commodity_category_id) select distinct pathogen_category_id, commodity_category_id from " & start_table_instead of populating pathogen-commodity pair list based on tables, go with pre-determined list$update rank_results set rank_total=0'  ~B@cycle through tables multiplying USER_BIN_RANK * WEIGHT and adding to RANK_TOTAL for corresponding pathogen, commodity or pathogen-commodity. CONTAMINATION R!PBOTHAEPIDEMIOLOGICAL_LINK X!PBOTHAEPIDEMIOLOGICAL_MULTIPLIERS V!PBOTHADEATH T!PPATHOGENAHOSPITALIZATION \!PPATHOGENAINFECTIOUS_DOSE ^!PPATHOGENASUSCEPTIBLE_POPULATION `!PPATHOGENA K_[CONSUMPTION N!P COMMODITYA$SHELF_LIFE_GROWTH_POTENTIAL_COMBINED Z!PBOTHAECall RANK_PROCESS_TABLE("GROWTH_POTENTIAL", txt_growth.Value, "BOTH")iCall RANK_PROCESS_TABLE("PRODUCTION", txt_production.Value, "COMMODITY") 'Removed production from rankingGCall RANK_PROCESS_TABLE("SHELF_LIFE", txt_shelflife.Value, "COMMODITY")RISK_RANKING_REPORT  B@to print4DoCmd.OpenReport "RISK_RANKING_REPORT", acViewNormal|8$0 0!2A@.o(]]]] $ !|!~.h  h%8.j jC@C@5<b BOTH2UPDATE RANK_RESULTS SET RANK_TOTAL = RANK_TOTAL + j"!P  WHERE PATHOGEN_CATEGORY_ID =  j"!P AND COMMODITY_CATEGORY_ID =  j"!P' PATHOGENe2UPDATE RANK_RESULTS SET RANK_TOTAL = RANK_TOTAL + j"!P  WHERE PATHOGEN_CATEGORY_ID =  j"!P'  COMMODITYe2UPDATE RANK_RESULTS SET RANK_TOTAL = RANK_TOTAL + j"!P  WHERE COMMODITY_CATEGORY_ID =  j"!P'k  ~B@C@`qX.j.h|@$8 0!2A@.o 8 CONSUMPTIONPOP_CONSUMING_PERCENTNUMERICAICall UPDATE_BINS(2, "CONTAMINATION", "AVG_PREVALENCE_PERCENT", "NUMERIC") CONTAMINATIONAVG_PREVALENCE_PERCENTNUMBER_STUDIESADEATH DEATH_PERCENTNUMERICAEPIDEMIOLOGICAL_MULTIPLIERS MULTIPLIERNUMERICAHOSPITALIZATIONHOSPITALIZATION_PERCENTNUMERICAINFECTIOUS_DOSEINFECTIOUS_DOSE_NUM_ORGANISMSNUMERICAtCall UPDATE_BINS(8, "PRODUCTION", "AVG_TOTAL_US_PRODUCTION_METRIC_TONS", "NUMERIC") 'Removed Production from ranking SHELF_LIFEAVG_SHELF_LIFE_DAYSNUMERICAFCall UPDATE_BINS(11, "EPIDEMIOLOGICAL_LINK", "TOTAL_CASES", "NUMERIC") EPIDEMIOLOGICAL_LINK OUTBREAKS TOTAL_CASESdAGROWTH_POTENTIALUSER_BIN NARRATIVEA SUSCEPTIBLE_POPULATIONUSER_BIN NARRATIVEAAo@x]8]X]x$ !|!~.h  h%8.j jC@C@5<b NUMERIC $j $'  NARRATIVEe $j $'kX jB@  j"(P jB@C@q.j.h|$ 0!2A@.o]p]]$ !|!~.h  h%8.j jC@C@5<b $j!P  'd0 $j $'k jB@  j"(P jB@C@q.j.h|$ 0!2A@.o]h]]]$`5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4'5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4'p5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4'n   1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4'    pe1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4'  p  ne1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4'  n e1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4'd'kz$ 0!2A@.i] ]( ]H $UPDATE SHELF_LIFE_GROWTK_[H_POTENTIAL_COMBINED C, GROWTH_POTENTIAL G SET C.SUM_SL_GP_RANK = G.USER_BIN_RANK WHERE G.COMMODITY_CATEGORY_ID = C.COMMODITY_CATEGORY_ID AND G.PATHOGEN_CATEGORY_ID = C.PATHOGEN_CATEGORY_ID'  ~B@UPDATE SHELF_LIFE_GROWTH_POTENTIAL_COMBINED C, SHELF_LIFE S SET C.SUM_SL_GP_RANK = C.SUM_SL_GP_RANK + S.USER_BIN_RANK WHERE S.COMMODITY_CATEGORY_ID = C.COMMODITY_CATEGORY_ID'  ~B@ !|!~.h$SHELF_LIFE_GROWTH_POTENTIAL_COMBINED h%8.j jC@C@5<b j"!P ' j"!P j"!P e' j"!P j"!P e' j"!Pe'd'k jB@  j"(P jB@C@q.j.h|p$h 0!2A@.oP` ] ] ]0 ]H ]` $,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4'v,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4',SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4',SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4'l  vRT1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4' RT1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4' RT1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4' lRT1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4'S'nz$ 0!2A@.ipx ] $XPUPDATE BINS SET BIN_LOW_USER = BIN_LOW_DEFAULT, BIN_HIGH_USER = BIN_HIGH_DEFAULT'  ~B@2UPDATE GROWTH_POTENTIAL SET USER_BIN = DEFAULT_BIN'  ~B@8UPDATE SUSCEPTIBLE_POPULATION SET USER_BIN = DEFAULT_BIN'  ~B@(UPDATE CONSUMPTION SET USER_BIN_RANK = 0'  ~B@*UPDATE CONTAMINATION SET USER_BIN_RANK = 0'  ~B@"UPDATE DEATH SET USER_BIN_RANK = 0'  ~B@8UPDATE EPIDEMIOLOGICAL_MULTIPLIERS SET USER_BIN_RANK = 0'  ~B@1UPDATE EPIDEMIOLOGICAL_LINK SET USER_BIN_RANK = 0'  ~B@,UPDATE HOSPITALIZATION SET USER_BIN_RANK = 0'  ~B@,UPDATE INFECTIOUS_DOSE SET USER_BIN_RANK = 0'  ~B@Tsqlstr = "UPDATE PRODUCTION SET USER_BIN_RANK = 0" 'Removed Production from rankingCurrentDb.Execute sqlstr'UPDATE SHELF_LIFE SET USER_BIN_RANK = 0'  ~B@AUPDATE SHELF_LIFE_GROWTH_POTENTIAL_COMBINED SET USER_BIN_RANK = 0'  ~B@BUPDATE SHELF_LIFE_GROWTH_POTENTIAL_COMBINED SET SUM_SL_GP_RANK = 0'  ~B@ainstead of populating pair combinations each time, use predetermined pathogen-commodity pair list) sqlstr = "DELETE * FROM RANK_RESULTS" CurrentDb.Execute sqlstr| $ 0!2A@.o  $ - !(Bin4 !(Bin3 !(Bin2 !(Bin1 !( !(P !(P !(P !(P !(P !(P !N(P !R(P !T(P !V(P !X(P !Z(P !\(P !^(P>Me.txt_production.Value = "" 'Removed Production from ranking !`(P|($  0!2A@.o ]p $ !P (P UPDATE BINS SET BIN_HIGH_USER = !P- WHERE BIN_NUMBER = 1 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 2 AND DATA_CATEGORY_K_[ID =  !P'  ~B@|$ 0!2A@.o ] $ !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 1 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 2 AND DATA_CATEGORY_ID =  !P'  ~B@|$ 0!2A@.oh ]` $P !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 2 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 3 AND DATA_CATEGORY_ID =  !P'  ~B@|8$0 0!2A@.ox ] $ !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 2 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 3 AND DATA_CATEGORY_ID =  !P'  ~B@|$ 0!2A@.o ]P $ !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 3 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 4 AND DATA_CATEGORY_ID =  !P'  ~B@|$ 0!2A@.oxh ] $` !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 3 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 4 AND DATA_CATEGORY_ID =  !P'  ~B@|H$@ 0!2A@.o( ]`$ +UPDATE DATA_CATEGORY_LUT SET USER_WEIGHT =  WHERE DATA_CATEGORY_ID =  '  ~B@k?|?$x? 0!2A@.o`?x N!PAo8? R!PAo?8 T!PAo> Z!PA Z!PAo> \!PAo>X ^!PAoX> X!PAo0> V!PAo>x `!PAo=Removed Production from ranking2Private Sub txt_production_Exit(Cancel As Integer)/ Call update_weight(8, txt_production.Value)End Sub0=Attribute VB_Name = "Form_fMain" Bas0{07AB005A-3AA3-44B9-97A4-3CE1D62B47A2} |@GlobalSpacFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT P&* Sub cmd_resetBins_Click() Call RESET_BINSA lst_d(_Bc#gory 0 End*2un/Dim error_msg As Sng<On E GoTo_handler C'check thate b0 va lues ApNӮgNothԪAk6ox P7!n(CancelvI0ger]uo¶FORM3S'sel` f[ items@~v13bgbSsq@^"tUPqEyt` Qx_WEwT=0.ExecA2!Su??OP o ׁd 's S~CU rIs1, 3, 4, 6, 7,` 8, 94e_labels (ow2, v1_bN?.Value) PCase` Elsep`Call RESE@T_FORM`End Select Exit Sub err_handler: MsgBox Err.Description^. P@rivate= popul _labels(data_cat_id As IntegerDim sqlstrStringOnwor GoXTo $'If DATA_CAT_ID = 3 Then 'DEATH txt_Bin1bcimalPlPaces1 2_lowhigJh3!%3_%bin45z808 %L 8 8IfɅsVisibleqTruļL40.3y5153C'IJ= "SELECT BIN_DESC FROMFEGORY_LUT WHEREID=" & Me.lbl_Ca.@val(C@CSv& " ANDNUMBER=4"jk4`u!d#3330$22k11_LOW_USERILYq7Isb"t[axTNtqP2#?HIGHE R=" 1q p{F'SA /7/`n/ /te$_multi1φφφ 3"φDS bFalgkgg !g@gÓ.s gnȨINCTUgoppr0 pINpQz?3?3R=ggz ů  R=gg  A   gg  Rg!:gNg009O O O q1 (vFR_[_[ing*Hg gԺoetu'gU@gggRANK(`ERtart_ta0u@_countLro hhfBithe with the most pathogen category - commodityPpairs (eirntamination, epi mead multi plier(demiological_link, or growth potential) 'sqlstr = "selectaunt(*) Pfrom o"/tart_tablpe_co*:Cvxal(JT$Yco";EPIDEMIOLOGIPCAL_os I$f : >irIThen1 sW Y@End If1{_/>@ /Q -'popul@rank_res@s w w=oeA[ Finsert intTo (E_E_8id,) WdistinC(" & H v @)&tЀ/Di4ngF>-A l based on Js, goKre-deter@ LJupd!.* setC"total=0!CCurr tDb.Execute Ccyclea6rougqsy!USER_BIN_RANK * WEIGHT a Vadd!0a_TOTAL$ f co spon*0G". Call  PROCESS_TABLE("CONTAMINATION", txts.Value, "BO8TH"V mqLI|NK$ a e MULTIPLIEp2M8";Noth_ A?6?`QoToToTQiTASSIGNS(@ACS1{"`_#bPERCwb"NUMERInC{q2"AVG_PREVALENCE_қLUM` ASEDc  BSTUDI Eq3INS(3P"?  4ɵOLOGICAL_MULTIPLIERS", "p4NUMERIC") Call UPDATE_BINS(6^HOSPITALIZATIONh $_PERCXENT M7MINFECGUS_DOSE2 __ORGANISVM'T8TP0RODUUAVG_TO_2 _METt N* 'Removed Production from rankin g9:SHELF_LIFb:_DAY] ^11$EPIDEMILINKbCASE %_COLUMN_BD-OUT`BREAK1005*GROWTH_POT{IAL)USERCNARRV&Ej10SUSCEPTIBLEPUL`DETERMINE_SLGPEnd SubPrivatedata_cat_id As Integer, tablenaDmeAStrz, bin_columnIcriteriaI @Dim dbDAO.D@base rstRecordsetGA%COn Error GoTo err_handle"r SetA = Access.A0ppli@;X.CurrentD#A=.OptenF(f!# Wpith A.bM@eLasFFiDo While .EOF = Fale"If )= "{ Then' !#\= ?@((#6), h=$EFUN[?3SK_[If.E di' !user_.Value&Up`$L#a"2NexD Loo>$i>(6W o7o7o7"o7Po7o7o7o7Salo7o7o7PoFun/!By`EQvE48r)~.34_lowDoutS3 2sqlstr=Spp d(SEL _LOWER FROMS WHERE A_C0GORY_ID=" &ic" A NDRfBER=l4"=Ap(ϳ4(CIN& 3q+T!=2#D(>$CRANKA 2=a}: N  tH <=W AG "***=!5 3< # 0 888& Ctrz9 / ((DD=12/ / PQ$ /(0i End If Exit Function err_handler: MsgBox Err.Descripf Private Sub DETERMINE_SLGP_BIN()Dim db As DAO.DatabaserstRecordsetbin_rank"IntegLerOnor GoTo  $sqlstr = "UPDATE SHELF_LIFE_GROWTH_POTENTIAL_COM^ED C,   G SET C.SUMs_tRANK,G.U(SER{_WH@ERE G.&MODITY_C= A52 K`5 |7{3ug\ 4A+A({kH.0#魡).EdihA+user_= g qUpd`gKNexD LoopaQKg\Noth8ingA= h `'NARRA0TIVEb`a_FvWStr`,F t_id)wnAɠ#4c 321Ŧ!  =`̀SELECT FROMS €Ai=" &a & " A_NUMBER=4= (( *C "?TE$i33pIN?AT?Ӊ ?=22č6_yX:110Select C`=pu$QIsP!w IN$O O K $1:  Wq1 o0qO(O(E( F Vj pL++ l5Qz} G/ W Q st532 q٩RE@iS!˱d:`ra _` A DDLOW_@*DEFAULT,Qb_HIGH G߾#O@eup$?oO USCEPTIBLEpPULONb?̢; CONR= 0 sTA@? ADEpzooohEPIDEMIOLOGICMUϴLTIPLIERS SET USER_BIN_RANK = 0" CurrentDb.Execute sqlstrt "h"UPDATE EPIDEMIOLOGICAL_ LINHOSPITALIZATIONOINFEC-US_DOS E>0'PRODU1^ 'Removed Production from ranking'ӠSHELF@gF66_GROWTH_POTENT"ICOMEDl¢HfSUM_ SL_GP-'instead of populat@a pair @combinons each time, use predet erminspathogen- @modityClist 'AGTDELE@* FROM _RESULTS ]Exit Sub err_handler: MsgBox Err.DescripK End Priva ~ ET_FORM() #OOnor Go8To Me.lbl_Ca v.6-@$Bin4.3,3.2,2.1,B1'txt_84.Valuek`3_high(low22_1 c`Oum,s@taPUde@Tmulti plier5linkuslgpuhospital!infeus.'`Ha7pH&Ub${on ciib `I1_s(Cancel As Integer lcDimDaStrbo  Je S\Z#_HIGH_3a1 &6 T& " WHERE NUMBER@1 AND A_CGORY_ ID$Є_data_c`Fgory9 M  䇰 LOW nO @ 2_ _ _ _ U #XXWX9###0 #/$a"C` /$t_a0s0%/$ ?$?$?$g/ IN?$! _ /?$_ _ _ /}/}/} } l$$$ $ 43 n%HOI%:vO>O>IstIueS.o%S S o%p=`ST_ S 3III`_ U IIIIГ(s>>> u rnn (LJ!NUMBER = 3 AND DATA_CATEGORY_ID" & lst_data_category.Value CurrentDb.Execute sq`r Exit Sub err_handler: MsgBox Err.Description /nd.Privk txt_Bin3_high_R(Cancel As Iner)Dim}String Onsor GoTo g9bin4t BO yUPE BINS SET_HIGH_US= &@" WHER_[̇s-LOW-E6&2Q,4 E嘒4rrdFQÏB{{H_HHE$ Iupe_$we t(J_id, cb DIf <> "" The@1a.zkLUT’_WETG(H A7rIf!‹0consum{z Call 61,?BHCt`52tapmina!l2feat|503 d t_pslgp/ vO(5C6 9wZhospital/ / 96sinfec us7link=K_[1$+OOmultiplier4C popul1n_$x(10'C'Removed Produn from rankҞ'p_Uv'+]8T &V '6BM'S'S¨R-$B "&*-///.ME ('4k B@Bz$ 0!2A@.ixرAttribute VB_Name = "mod_utility" Option Compare Database Public FuncFSIDEBAR(sqlstr As Sng) Dim dbMain,trecNew Recordset2qry1!mandxOn Error GoTo err_"hlerSetj= CurrentProject.Conn)x.Open X,, ad Static  kQCouFnRCloEHxit L: Msg ypiaZTPMKIJJKNRUZ`how   $(+.24678775531/.,*('$$$@-$M ysmf_YTOK~HxGoEjEdE`F[HYJVLVPTRTWTZV_VdYi[o_uazdgjloqtuwy{}~}}{{yxvvuuuwx{~    ~$=IPIQKTLYO_QfSpVyXYZYXUQLD<4-(" ~ z u pjd_ Y T OKGCA#?(?-?1@5A9C?GDKGOIPIP$]bbbcefilpu{"(-1332/,|(v#pkgb ^ZXUTSRRPOMKJHFFEFFILP~UxYq]laee`i[mVpQtNwJ{HFDCCCDFGILORUWZ]`bb-$t !)19@GMSX]bglrw}{xtpli|et`j]bYYVQSIQBP:O4M,L&K KIII IHHHIIKLOPRSUWZ]adgjnqtvxz}~K_[-$j_]\ZXTPLID@<85300.$///:0E2O3Y5b8l:s<z>@ACDDsstuvvvtsqnje_YQIB<50)% #&(|*x+t-p.m0k2h7h:i=mBpHvM{QUXZ\]______$$;G<G?IEMLRUW`^lezmt{!2BP_ly"$(+038<ADHLPQQPNKGB=83.*&#!! qcWJ<- 0.*(%"~zupkgb^ Y U P LGB<71 - ' # !#&'!(%)(+,,/-3.70:2>5A7D;G;Gs-$vMwNzQV^fpz  *2:@GLQUZ_dioty{}skc\TLF?93-($~xqjd]VNIB=#:(6-3217/=.C,I+N)U)Z&_$d!ilpsvwxyzyyxxvtrqnligc`\YURNLHFBA?=~=w=q=i=b>\@WARCOEKGJJENCPBRBSBWC\DbFiHoJsKvMvM$SL.  yof]UNIEBABCEINSX_elsz (07>CJNS W[^ad$f)g.f2d7a:]=Y@SCNEHGBH<J8K4K0L.L.L.z-$X:863.(" {xvtssssuxz} "%(*+149=CHMRX\aeijjigd`[VQLGC?<:::-$K}JKNPSVZ]aeilquy}{s~i{axYrRlJfD_>W:O7G5?373/2(3 457 9:<=?@ABCDEGILQSVZ]adgknpsux{|}}-$jeddcb`^ZVPJB8."|uoha[UOJEA>:97779<?CHOTZaipw~ ' (-/48=AFJOSX[_ adeffggggfee$X  | r f \RJA;5%2+/1,8*?(F&L$S$Z$_$e&j(o+r/u4v:xBwIvPuWu]scqhommsjwg|db^[WTPMKKIIIJJJJJIHFDA=:82,&#!  $l??>=<:987531/-|,q+g*^)T)L)E+?,:.5013-5)8$:=?ABDDCA=84.)#      #)/7?GOXajt}  !( - 258K_[;<=>????z$;mSnUp[tdzq !(+---}*v'p#kd_ZW S QONNLKIGFDBAAAACuEkIcL[PVSQWN]KbKfLjOlRmSmS-$Jdccbbbcdfhlpu{~zwtpmihddd$H6r4r0q-p+p'p$rrtwz~  #'*-.011//./036:<?BFGIIIHGEC>{:v7s6r6r$>7D5C1C+D%F!HLOU[dmx !"#%(, 0 6<BGMRWZ^` aa`^]ZXVTQNLKIzGvGsGr7D7D-h$2  %,4:AHOUZ^acfhk n qtwyz!{%|(|+{-y/v/q0l0f0a/Z.T.N.H-B,<+7*3)/),)*@-$`YY[~^}b{fymxrvzsqnljhfdbaabbdefggg gdb^Z"S"N"H B=72. )%!!%)-z2q5h9_<W>Q?KAGACB?E;I8L4Q2V/\-b+g)m's&x%~%%&(*-049=BFJNRWYY$R5757391</A+F(L$S![clu    "'* - /1333431/-)%  }skc]WR LHDA >%<):-90837475757-|$<#"!  |yvtpo noptw {"~##)!-$Jww yy{|}~~~~}{ywsojgb^YUQLIF@=<==?#@3CDEUIfJvNOSTVWX V VWY]`fi l ptxz|~Pyww 3-$Cooqtz|{xvuttsstttvwyy{|~~wrnjfc_]YWUUUVWXYYooE-x$:zy y"x%x+x1w8w?xIxQx[yd|n~w:83/,($ }}zz+-l$4v}vpkfcaabcddeddddcdgkoruvv@-$CFuFuDwBzA=;8630.-+++,-/023579=ABDFIJLMOPQSTUUUVVVVVVX[_adeeeedc}bz`x^t[rWpVpFuFu 3-^$-YWSNHEB@?== =?@K_[DI#N(T-Z2`7h:n=u@{BBBA>950+&! YYn$5X:Z<[?_DbIfOjVn]peslvtx}xxvtojea\WRNIF|Bv?p<j:g9e9d8b6]5Y3V2S2O0J0G/C/@0:3877=7B7I8N8S8V9X:X:-$s"2D'Y2p;CINQTTT(T;SLP\NjKwIFCA?<9640-*&#   | m ]M<,   |voida\XSPKGC?;73/+($"{vt sttwy|Ԋ!-$^rrtuwy|~(:L]|nw}qi_UMF?93/*&"#(y-s1n5j:f>cAaBaC`C]CXBSBLAEA=A5A+@#??? ????><:95410.--/05;CKRX^aehkmpprr0-f$1OPRVZ_djpw}}|{{{{|}yOOz-$Q "(08BNZfs }wqlfa\YUSRRPNJE>7/(    @-$ryyz|$/;GS_lx  }{zzzzzz{zzyywvutr{qupqollgibe\bV]PYITCP<L5H.D(B!?>>? @ACDDFGILRTX\aeilosvxyyԊ!-z$;$)/38<@DGILNPRSRPLGC?;71,&  x-$\xwvutqpljfa\WPIB: 1)! !%&(*,./06:>CHMRW\af imo+p5o?mIiRe[_dZlRsJ{A9/%yxx$n '/5=DLT\c|ktqlxe}_ZWTSQKGC?;62.,)))+-16=ENXcnz|wrlfa[UOIB;4/( !   )!-$r"',4;DLV_iqyxpf]SI>4)  ti\OB5)  ")28<?BBCBBAAACEIOW_ekoruxz{}~ E-K_[$HpMrNxR{TW[`djpx{vqmhd`|]xXrWqUoOkKiGfCc?a<]8Z7W5T5Q6O8M=MAKFKKJPJSJXJ[J`KcKfKiKlLoMpMpMԀ-n$5{{   !"!!   zvrojgee{{i-$C**,/26:?DHKOQRRvQlObJ\FYAX=Y9\4a0f-l(r%x!~    !$%'()*** -$>optvy}~{toifeeeeddb`^\ZXURMJFCABDJOU[afkmooR->$abefhjmnpqrrrrqnkifa[UQNMM>aa-$T>(?'B&D%G%J$N$Q#V"Z!`!e!k!q!x!}!!!!"#$&&(*+/59<?CDFFGFCA@?><::{:v:q:n;j>g?cA`D]HVNPULWIYEZB\=\:\6[2Y-U)T&R$PNMKJ#G)D/?3;76:2<-=*=(>(>(3-$B".8?EG IIHEA=83.)$  -$VPPONLKI GFD#B+@3?<=D=L<T=[=b?iAqByDFHKLMMNMLJHDA><97542100...}.|.y.v.q.j.d.\.U.M.E.>.7.0.+.'.$.---- --.01368:<?BFKLPP:$oooH$".-+(#  A..@-$@BCFHJLNNOMLHD?7.$}tkb[TPLLLNQV[agnszBBz$;V^U]R]N[IZBX<V5S0Q)N$K!HEB!?%<-:66A6M6Z8g9u<?CFJNQTVXYZ\`cglquzz+-l$4qrt w}$/<IWfv-WRqq-$N#!{wsnhb [UNF?7.$ (/6=BHMSX]bglpty} !##f-$@>><: 9 775N3i212259>DNW_flqvz~vdP=* { K_[sld_YTNJFC?>>@-P$&}{z xw!w+v4v>vFvPvXv`vgwowtwzwxxxxyguuw-$X$$#! &-5>HP Z ckry~  #%')+,.0223|3u4o4h5b5[5U5O5I5C5?5:5754625-4)1%.!*'%$$J0234000.WMF@@TH(h lbl_Bin4mtxt_Bin1d %lbl_Captiond lbl_consumptionmtxt_consumptiond lbl_contaminationmtxt_contaminationd lbl_deathmtxt_deathd lbl_multipliermtxt_multiplierd lbl_hospitalmtxt_hospitald lbl_infectiousmtxt_infectiousd "lbl_populationsd &Label40d 'Label41m txt_Bin2_lowmtxt_Bin3_lowd (Label42d )Label43m+txt_Bin3_highm*txt_Bin2_highd -lbl_linkm,txt_link|!Binsd .Label51d /Label52d 0Label53d 1Label54h #cmd_runm2txt_bin4h 3cmd_resetBinsm!txt_populationg5Image59d 6Label60d 7Label61d 8Label62f9Line63f:Line64f;Line65|!Weightsd lbl_slgpmtxt_slgpd <lbl_Bin1d =lbl_Bin21D/BlobDeltaO DirData PropDataCmdbars0knR0knR }yuqnkgeb_[YXVSQNLIE@;4-%}xsl}gzaw\uUtOtItCv=y8}3.)&$###$&()+./1233p-$>Lp[ZWT{OwKsHnEiCa?Z=P:G7<423(234 57:=@CGJMPSUXZ^bfinr1Fd    g    h !K_[   l    m     n     {    {|    nmmmmddddddmmdddddhdd|    mdmdmdmdmdmdmdmdmddddf    f    f    dh!g!frm_Main 0CB0Modules (0knR]'0rrPropData DirData mod_utility 0CB0048:<=Babc#e ghuijuk 1_@zD.Nh U'Ζ G݇SlS1_@|QRY_RISK_RANKING_REPORTFlAɍ'Ζ G݇SlPATHOGEN_CATEGORYGjDݓʊ'Ζ G݇SlCOMMODITY_CPropData"K_[DirDataCopyPropDataCopyReports!0knR]'0ƿ Blob  PropDataTypeInfo ATEGORYnojK'D'Ζ G݇SlRANK_TOTAL>w@UIw0i@SUBREPORT_INPUT .QRY_RISK_RANKING_REPORT Arial8#hTSdXXLetter.HP LaserJet 9000 PCL 62/3 in 2xe.DQ׿יnCנ ` 1$DSb4/B$eN$V񭵿d_&BEM> )K8f8 'mg pɥ6W%p[E~XI~ Zixs(;xvÞ*|Nžބb` VG&je(6@s u;Nîw_eA2g|Xj/NAGՅ\:,}!ul97 Jb=`/FHCpgDF1p586.printer.rti.orgd28 Arialm5< Arial`<ReportHeaderЬDyE僟`"PageHeaderSectionO@ K+Ƽc"d8"`abP c,d e Label2"Pathogen CategoryVeN8C=yd8"`ab c,d e Label3$Commodity CategoryzAlO߱"qd78"a<b#c;d e Label6(RISK RANKING RESULTSK$EvB'xf`xaHb" Line17O6bJn^Wٳd8"`abc,d eLabel20 Score cNor ` DetailkrjNksm<"F`a<bP c,i Text7"PATHOGEN_CATEGORYt.HADnm<"F`a<b c,i k Text9$COMMODITY_CATEGORYTE+K>^m3<"F`a<bi k Text10=11nI(vZm;<"F`a<bc,i k Text19RANK_TOTAL kOg'6`"PageFooterSectionHʀOn`>WMmF`abt" Text0 =Now()Long DateW(ԝ O$f`xa<b(# Line5KpMJmEE`ReportFooter 1(G)D|p4`<ahbd#cSUBREPORT_INPUT,Report.SUBREPORT_INPUTZUbqGE5sd8"`a<bQ cd e*SUBREPORT_INPUT Label"USER INPUT VALUES*SUBREPORT_INPUT_LabelőN>f`xahb(# Line18KHxDpX#K_[ͬ}yI#$BAReportHeaderPageHeaderSectiondLabel2dLabel3dLabel6fLine17dLabel20DetailmText7m Text9m Text10m Text19 PageFooterSectionm Text0fLine5ReportFooterpSUBREPORT_INPUTdSUBREPORT_INPUT_LabelSUBREPORT_INPUT LabelfLine18PATHOGEN_CATEGORYCOMMODITY_CATEGORYRANK_TOTALBlobDelta51&#`ݤX Blob PropData"$ 1D1Fd    m     dddf    dm+m+m+m+m+f    p    df    ͬ`eeK6+ceReportHeaderdDATA_CATEGORY_ID_LabeldBIN_LabeldBIN_LOW_USER_La 048y9:<=Babc$e ghUijUkDATA_TYPE_LUT.DATA_TYPE, DATA_CATEGORY_LUT.NUMERIC_CRITERIA_FLAG, DATA_CATEGORY_LUT.DATA_CATEGORY, BINS.BIN_RANKN^@>w@UI Uv*Dk@Mgs#M_@uQRY_SUBREPORT_INPUT^HS?mv*Dk@MDATA_TYPE-(BzG;v*Dk@MNUMERIC_CRITERIA_FLAG20D,=6>w@UIDATA_CATEGORYR6Kv*Dk@MBIN_RANKPI%0`Zv*Dk@MDATA_CATEGORYi&8ZATwv*Dk@MUSER_WEIGHTlI\v v*Dk@MBINS$K_[WI!qv*Dk@MBIN_LOW_USER &(Mb(v*Dk@MBIN_HIGH_USER &QRY_SUBREPORT_INPUTSUBREPORT_INPUT Arial8$,hTSdXXLetter.HP LaserJet 9000 PCL 62/3 in 2xe.DQ׿יnCנ ` 1$DSb4/B$eN$V񭵿d_&BEM> )K8f8 'mg pɥ6W%p[E~XI~ Zixs(;xvÞ*|Nžބb` VG&je(6@s u;Nîw_eA2g|Xj/NAGՅ\:,}!ul97 Jb=`/FHCpgDF1p586.printer.rti.orgd278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4DATA_TYPEDATA_CATEGORY`ReportHeader79QEVvd8"`axb c,,DATA_CATEGORY_ID_LabelData Category ArialDetachedLabel=ȊN_9%d8"`axbc,BIN_LabelBin ArialDetachedLabel3m+KZb_d78"`axbc,$BIN_LOW_USER_LabelBin-Low ArialDetachedLabel_yLwXId78"`axbc,&BIN_HIGH_USER_LabelBin-High ArialDetachedLabel%~qRZ@c;?d78"` axb8c,Label10 Weight ArialDetachedLabellGuVE]qf`<ab(# Line13B{ +HyԲK3`"PageHeaderSectionJRՅu@nf2b Line8n ,O޸<`,GroupHeader0L&m CF`<b(#c,i jDATA_CATEGORYDATA_TYPE20D,=6`haGroupHeader1N uD:mF` a<b ci j Text15DATA_CATEGORYBA18D,}v&m;F` a<bci k Text16USER_WEIGHTO/{A3"Ga`, DetailYN Of@mF`bce(i BINBIN$JqY +m;F`bcei kBIN_LOW_USERBIN_LOW_USER|kD vm;F`Lbtcei kBIN_HIGH_USERBIN_HIGH_USERϻGvYF˭p)`"PageFooterSection|Ja?APO.f2b Line9ko`M m`ReportFooterX[_1I"2TypeInfo%3BlobDelta%K_[E DirData'TPropDatabeldBIN_HIGH_USER_LabeldLabel10fLine13PageHeaderSectionfLine8 GroupHeader0m DATA_CATEGORY GroupHeader1m Text15m Text16DetailmBINmBIN_LOW_USERmBIN_HIGH_USERPageFooterSectionfLine9ReportFooterDATA_TYPENUMERIC_CRITERIA_FLAGBIN_RANKUSER_WEIGHT1D1     Fd    e    f    g    j    m     n     o     p    dddddffm+m+m+m+m+m+f"SUBREPORT_INPUT*RISK_RANKING_REPORT&K_[ 1CB0 0CB033 frm_Main0-10Scripts1-0knR]'0+R⥐R⥐Blob PropData*, BlobDeltaDirData). "PropData/!DirDataCopy"~TMPCLP64341 0CB1AutoexecjiMSysDbPropData#Databases0620knR'0430knRP{RBlob DirData$ImExSpecsz4nz4nCustomGroups570knR0knRDataAccessPages 0knR0knRRoot EntryP(D7@IVBA0knRP(DVBAProject `t{R?CVBA`t{R?C      ("#$%&'*)+,6i208:;<=>?@ABDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~'-QN- ` 8  s K  c = c <  { C   cA- Shigella sonnei , Shigella flexneri serotype 3 unspecified4 + Shigella flexneri Serotype 2a) * Shigella boydnii CDPH serotype 18- ) Sapovirus ( Salmonella Virchow ' Salmonella Typhimurium var Copenhagen1 & Salmonella Typhimurium" % Salmonella Thompson $ Salmonella Stanley # Salmonella Senftenberg" " Salmonella Saphra ! Salmonella Saintpaul  Salmonella Poona  Salmonella Paratyphi B"  Salmonella Oranienburg"  Salmonella Newport  Salmonella Montevideo, Salmonella Meleagridis9  Salmonella Meunchen  Salmonella Mbandaka  Salmonella Kottbus, Salmonella Mbandaka3  Salmonella Johannesburg#  Salmonella Javiana  Salmonella Infantis, Salmonella Anatum2  Salmonella Heidelberg!  Salmonella Hartford  Salmonella Group B  Salmonella Enteriditis"  Salmonella Cubana, Havana%  Salmonella Chester  Salmonella Braenderup!  Salmonella Bovismorbificans'  Salmonella Berta  Salmonella Baildon  Salmonella Anatum, Group D, Javiana, Muenchen, Thompson, TyphimuriumP  E. coli O6:H16  E. coli O26 (Enterohemorrhagic)+ E. coli O157:non-motile# E. coli O157:NM (H-) (Enterohemorrhagic)4 E. coli O157:NM (Enterohemorrhagic)/ E. coli O157:H7 (Enterohemorrhagic)/ E. coli O121 (Enterohemorrhagic), E. coli O111:H8 E. coli (Enterotoxigenic)% E. coli (Enterohemorrhagic)'   @ @ @ @ @        ! "!#"$#%$&%'&(')(*)+*,+-,  @ @ @ @ @        ! "!#"$#%$&%'&(')(*)+*,+-,3YNY  Y d PATHOGEN_TYPE_IDPATHOGEN_TYPEG_TO*CCERI_SY YY.rC PATHOGEN_TYPE_IDPrimaryKeyv1@@ParasiticViral Bacterial _ @ @ @ @ @ @ @ abcdefghi j k l m nopqrstuvwxyz{|}~ !"#$%&'()*+,-./01234567 8 9 : ; <S YNY  Y Y  Y , Y ,~ Y ~Id LValueObjectGuidObjectNameProperty Value,~,~,~,~,~,~,~,~,~,YYYId$ObjectGuidProperty$ObjectNamePropertyHv1b    >YN Y Y ڟY  Y Y ,Y Y  Filter FlagsIdNamePosition SelectedObjectIDType,,,YIdv1auCustom ^Tables "w V RYNY Y Y  Y @Y ,Y Y  FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPosition,,,,,,YYGroupCategoryIDIdv1@  yL|O" n A   w w w9 w  w 3 w C w , w  wCustom Group 162.*  w w w w w w w  @ @       @ @       Y--N- --Y Y Y Y @ Y ,Y Y  FlagsGroupIDIconIdNameObjectIDPosition,,,,,,YYGroupIDIdv1-yLk> ] 0  | O " n A  ` 3   R % qD-  o,  o+  o*  o )  o (  o' o& o% o$ o# o" o!  o  o o o o o o o_ o o oZ oU oO oI oC o> o9 o3 o, o ( o $ o  o   o   o  o  o  o  o o o o o  @ @ @ @ @       !"#$%& ' ()*+,  @ @ @ @ @        ! "!#"$#%$&%'&(')(*)+*,+-,RYQNY  Y Y IdNameTypedvY  P V " ykE71Ea!/xU_@/xU_@DATA_TYPE_LUTDATA_CATEGORY_LUT3U^^^^^^^^^^\  _l_@_l_@DATA_CATEGORY_LUTBINS3ULLLLLLLLLLJ %Zb@%Zb@COMMODITY_LUTSHELF_LIFE_RAW3UXXXXXXXXXXV $p9[b@$p9[b@COMMODITY_LUTCONSUMPTION_RAW3UZZZZZZZZZZX ^]b@^]b@COMMODITY_CATEGORY_LUTSHELF_LIFE_RAW3Ujjjjjjjjjjh _ub@_ub@COMMODITY_CATEGORY_LUTSHELF_LIFE3Ubbbbbbbbbb` Ê_@Ê_@COMMODITY_CATEGORY_LUTRANK_RESULTS3Uffffffffffd =_@=_@COMMODITY_CATEGORY_LUTGROWTH_POTENTIAL3Unnnnnnnnnnl @ _@@ _@COMMODITY_CATEGORY_LUTEPIDEMIOLOGICAL_LINK3Uvvvvvvvvvvt '5_@'5_@COMMODITY_CATEGORY_LUTEPI_MEAD_MULTIPLIERS3Uvvvvvvvvvvt Η_@Η_@COMMODITY_CATEGORY_LUTCONTAMINATION3Uhhhhhhhhhhf [b@[b@COMMODITY_CATEGORY_LUTCONSUMPTION_RAW3Ullllllllllj *b@*b@COMMODITY_CATEGORY_LUTCONSUMPTION3Uddddddddddb 5/o_@5/o_@COMMODITY_CATEGORY_LUTCOMMODITY_LUT3Uhhhhhhhhhhf WZW@WZW@ MSysNavPaneGroups3U4MR2KeepLocal  TDDDDDDDB @`r[@`r[@MSysAccessXML3U4MR2KeepLocal  T|||<<<<<<<: @U$u]@Pu@HOSPITALIZATION3U@LLL@@@@@@@> @ dm@ dm@~sq_cfrm_Main~sq_clst_data_category3U @4MR2KeepLocal Tthhhhhhf ` #[@V#Υ2@AccessLayout3U4MR2KeepLocal T"@zz:::::::8 @0ߘQ[@0ߘQ[@Forms3U,,,,,,,,,,*  }u]@Pu@SUSCEPTIBLE_POPULATION3U5 @ZZZNNNNNNNL @oOu]@Pu@SHELF_LIFE_RAW3U@JJJ>>>>>>>< @s e@Pu@SHELF_LIFE_GROWTH_POTENTIAL_COMBINED3U? @vvvjjjjjjjh @$bJlb@Pu@SHELF_LIFE3U"@BBB66666664 @<^@Pu@RANK_RESULTS3U@FFF:::::::8 @^@gs#M_@QRY_SUBREPORT_INPUT3U@@`TTHHHHHHHF @_ϙ^@S1_@QRY_RISK_RANKING_REPORT3U@@h\\PPPPPPPN @r[@Pu@PATHOGEN_TYPE_LUT3U,@PPPDDDDDDDB @d w[@Pu@PATHOGEN_LUT3U?@FFF:::::::8 @{[@Pu@PATHOGEN_CATEGORY_LUT3U]@XXXLLLLLLLJ @XW@XW@ MSysNavPaneObjectIDs3U4MR2KeepLocal  TJJJJJJJH @ LVALrGDJ x x؄ ? x                d CDATA_CATEGORY_LUT.DATA_CATEGORY_ID!DATA_CATEGORY_LUT=DATA_CATEGORY_LUT.DATA_CATEGORYx p  (  0 dm@0 X  0a  0a%DATA_CATEGORY_LUT8    0 Pu@E~sq_cfrm_Main~sq_clst_data_categoryX          0a  0a%DATA_CATEGORY_LUT  p   x         0 8 @ H P X                                                             x    #4  #4   z h    cX H  H  d 0P X H   !DATA_CATEGORY_LUT  8 X PrimaryKey;DATA_TYPE_LUTDATA_CATEGORY_LUTDATA_TYPE_IDDATA_CATEGORY_ID  v  x 0    q                                  )  DATA_CATEGORY_LUT#4   #4  #4    H  X |     *)NUMERIC_CRITERIA_FLAG   x  h     d  d@ #4   #4      X   h  LVALoGDU x x4} b? x                d CDATA_CATEGORY_LUT.DATA_CATEGORY_ID!DATA_CATEGORY_LUT=DATA_CATEGORY_LUT.DATA_CATEGORYx p  (  0 dm@0 X  V  V%DATA_CATEGORY_LUT8    0 Pu@E~sq_cfrm_Main~sq_clst_data_categoryX          VRI3_ VERADATA_CATEGORY_LUT  p   x         0 8 @ H P X                                                             x    x#4  z#4   z h    pYX H  H  d 0P X H   !DATA_CATEGORY_LUT  8 X PrimaryKey;DATA_TYPE_LUTDATA_CATEGORY_LUTDATA_TYPE_IDDATA_CATEGORY_ID  v  x 0    q                                  )  DATA_CATEGORY_LUTz#4   x#4  x#4    H  X |     *)NUMERIC_CRITERIA_FLAG   x  h     d  d@ z#4   x#4      X   h   ,Yf ~NY  Y dY (PATHOGEN_CATEGORY_ID"PATHOGEN_CATEGORY PATHOGEN_TYPE_ID`!H[ZYY>YZYUY,YIYCYOY Y Y Y YY Y.rC.rD.rE.rF.rG.rH.rI.rJ.rK.rL.rN*PATHOGEN_CATEOGORY_IDLPATHOGEN_TYPE_LUTPATHOGEN_CATEGORY_LUTPrimaryKeyv1@  jAiG' Listeria monocytogenes" Salmonella Typhi  Shigella spp.  Salmonella spp.  Norovirus  Hepatitis A Virus  Giardia lamblia E. coli, other pathogenic% E. coli, EHEC Cyclospora cayetanensis# Cryptosporidium parvum" Clostridium botulinum! Campylobacter spp. Campylobacter jejuni Bacillus cereus   @ @        @ @       fY-N-----Y  Y Y PATHOGEN_IDPATHOGEN(PATHOGEN_CATEGORY_IDOOTCRYESOLSRKY YYBPATHOGEN_CATEGORY_LUTPATHOGEN_LUTPATHOGEN_IDPrimaryKeyv1  :Y7N77 77Y Y Y (PATHOGEN_CATEGORY_ID*COMMODITY_CATEGORY_IDRANK_TOTALRSYY YY Y*COMMODITY_CATEGORY_IDDCOMMODITY_CATEGORY_LUTRANK_RESULTS(PATHOGEN_CATEGORY_IDBPATHOGEN_CATEGORY_LUTRANK_RESULTSPrimaryKeyv1@ o 7{hUB/ q^K8% z g T A .   p ] J 7 $   <@ A@ D@ F@ E@ F@ E@ K@ H@ F@ E@ E@ H@ C@ J@ J@ E@ F@ K@ D@ C@ F@ E@ G@ E@ G@ B@ D@ E@ A@ C@ E@ E@ <@ :@>@K@ H@J@N@H@J@G@ >@B@A@C@ H@H@ B@B@F@D@ 8@<@1  @ @ @ @ @ @ @ #$1 % &2 '3 (4) ! *        " + 5 6   , -./01  @ @ @ @ @ @ @                  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 56 @@@@@@@@@@@@@@                            !  " # $ % & ' ( )  *  +  ,  - . / 0 1 2 3 4  5 6 YNY Y Y *COMMODITY_CATEGORY_ID&AVG_SHELF_LIFE_DAYSUSER_BIN_RANK'Y Y@COMMODITY_CATEGORY_LUTSHELF_LIFEPrimaryKeyv1\y^C( 5@v@@ <@ <@ f@,@>@3333332@UUUUUU=@?@5@<@$@  @ @      u Y7N77 77Y Y Y Y  (PATHOGEN_CATEGORY_ID*COMMODITY_CATEGORY_IDSUM_SL_GP_RANKUSER_BIN_RANKYPAYYY YY *COMMODITY_CATEGORY_ID(PATHOGEN_CATEGORY_IDrPATHOGEN_CATEGORY_LUTSHELF_LIFE_GROWTH_POTENTIAL_COMBINEDPrimaryKey SLGP_COMM_CAT_FKv1@  7xgVE4#yhWF5$ z i X G 6 %   { j Y                                         1  @ @ @ @ @ @ @ #$1 % &2 '3 (4) ! *        " + 5 6   , -./01  @ @ @ @ @ @ @                  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 56 @@@@@@@@@@@@@@                            !  " # $ % & ' ( )  *  +  ,  - . / 0 1 2 3 4  5 6 YN Y Y  Y Y COMMODITY_ID*COMMODITY_CATEGORY_ID*SHELF_LIFE_RANGE_DAYSSHELF_LIFE_DAYS # YY YY*COMMODITY_CATEGORY_IDHCOMMODITY_CATEGORY_LUTSHELF_LIFE_RAWCOMMODITY_ID6COMMODITY_LUTSHELF_LIFE_RAWv1  T)T' y L  k > 5@14-21 days& <@14-28 days& <@21-28 days& f@90-180 days(,@7-14 days$ H@21-48 days&5@14-21 days&5@14-21 days&,@10-14 days&,@10-14 days&<@28 days !5@14-21 days&,@10-14 days&N@30-60 days&,@14 days  ,@14 days E@21-42 days&5@7-21 days$<@14-28 days&@3-6 days"$@7-10 days$,@2-14 days$Z  @ @ @        n  @ @      !  7YNY  Y ( Y Y(Y (PATHOGEN_CATEGORY_IDDEFAULT_BINUSER_BINUSER_BIN_RANKC YY YPATHOGEN_IDPOP_PATH_CAT_FKPrimaryKeyv1 ~_:z[6StrongStrongNoneNone SomeSome SomeSome SomeSome MediumMedium SomeSomeNoneNoneStrongStrongNoneNoneStrongStrongNoneNoneSomeSomeNoneNone  @ @         @ @       QQvcP=*z @ -  } j C 0  m Z G p]I6#r_L8%uaN;'93U 32U 31K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 33U ,2U ,1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp ,3U (2U (1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp (3U $2U $1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp $3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U  2U  1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp  3U 3U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 2U  3U  1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp  2U  3U  1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp  2U  3U  1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp  2U  3U  1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp  2U  3U  1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp  2U 2U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 2U 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2P 2P 3U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 2U 2P 3U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 2U 2P 3U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 2U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2P 2P 3U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 2U 2P 3U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 2U 3U 2P 3U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 2U LVALʾ,xxxEPIDEMIOLOGICAL_LINK MAKE_TABLE_CONSUMPTIONCreate report in Design viewCreate data access page in Design viewmod_utility8`^3 LVALh''1  MR2 GUIDNameMap >w@UI  Uv*Dk@Mgs#M_@uQRY_SUBREPORT_INPUT^HS?mv*Dk@MDATA_TYPE-(BzG;v*Dk@MNUMERIC_CRITERIA_FLAG20D,=6>w@UIDATA_CATEGORYR6Kv*Dk@MBIN_RANKPI%0`Zv*Dk@MDATA_CATEGORYi&8ZATwv*Dk@MUSER_WEIGHTlI\v v*Dk@MBINSWI!qv*Dk@MBIN_LOW_USER &(Mb(v*Dk@MBIN_HIGH_USER MR2 GUIDNameMap zD.Nh  U'Ζ G݇SlS1_@|QRY_RISK_RANKING_REPORTFlAɍ'Ζ G݇SlPATHOGEN_CATEGORYGjDݓʊ'MR2 GUIDNameMap >w@UI  Uv*Dk@Mgs#M_@uQRY_SUBREPORT_INPUT^HS?mv*Dk@MDATA_TYPE-(BzG;v*Dk@MNUMERIC_CRITERIA_FLAG20D,=6>w@UIDATA_CATEGORYR6Kv*Dk@MBIN_RANKPI%0`Zv*Dk@MDATA_CATEGORYi&8ZAMR2 GUIDNameMap >w@UI  Uv*Dk@Mgs#M_@uQRY_SUBREPORT_INPUT^HS?mv*Dk@MDATA_TYPE-(BzG;v*Dk@MNUMERIC_CRITERIA_FLAG20D,=6>w@UIDATA_CATEGORYR6Kv*Dk@MBIN_RANKPI%0`Zv*Dk@MDATA_CATEGORYi&8ZATwv*Dk@MUSER_WEIGHTlI\v v*Dk@MBINSWI!qv*Dk@MBIN_LOW_USER &(Mb(v*Dk@MBIN_HIGH_USER MR2 GUIDNameMap zD.Nh  U'Ζ G݇SlS1_@|QRY_RISK_RANKING_REPORTFlAɍ'Ζ G݇SlPATHOGEN_CATEGORYGjDݓʊ'Ζ G݇SlCOMMODITY_CATEGORYnojK'D'Ζ G݇SlRANK_TOTAL>w@UIw0i@SUBREPORT_INPUT MR2( ReplicateProject MR20 Title AuthorCompanyd FDA_EPI tulloch, $RTI, InternationalLVALNά4|rV  eKCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_LUT1~CONSUMPTIONCONSUMPTIONMCONSUMPTION_RAWCONSUMPTION_RAW#JCONTAMINATIONCONTAMINATION2^EPIDEMIOLOGICAL_LINKEPIDEMIOLOGICAL_LINKIGROWTH_POTENTIALGROWTH_POTENTIALu%MPATHOGEN_LUTPATHOGEN_LUTsS(PATHOGEN_TYPE_LUTPATHOGEN_TYPE_LUTRANK_RESULTSRANK_RESULTSSHELF_LIFE_RAWSHELF_LIFE_RAWY'nDATA_CATEGORY_LUTDATA_CATEGORY_LUT4nBINSBINS ZCOMMODITY_LUTCOMMODITY_LUTY6)HOSPITALIZATIONHOSPITALIZATIONYDEAT LVALHDEATHe"bPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_LUTSHELF_LIFESHELF_LIFEfEINFECTIOUS_DOSEINFECTIOUS_DOSE}19SUSCEPTIBLE_POPULATIONSUSCEPTIBLE_POPULATIONyDATA_TYPE_LUTDATA_TYPE_LUTnSHELF_LIFE_GROWTH_POTENTIAL_COMBINEDSHELF_LIFE_GROWTH_POTENTIAL_COMBINEDdtQEPIDEMIOLOGICAL_MULTIPLIERSEPIDEMIOLOGICAL_MULTIPLIERSVLVALfMR2BValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionSmartTagsDecimalPlaces    U nB?m>_rCgpf@BINS+ {*@@( nB?m>_DATA_CATEGORY_IDFNOՄ* nB?m>_BIN_NUMBERR6K nB?m>_BIN_RANKlI\v  nB?m>_BINa;$DK&3 nB?m>_BIN_RANGEu[pڥ@} vX nB?m>_BIN_LOW_DEFAULTӷ9E # nB?m>_BIN_HIGH_DEFAULTSWI!q nB?m>_BIN_LOW_USER &(Mb( nB?m>_BIN_HIGH_USER    nB?m>_ Contains the bin descriptions and high and low values for each data category> 6((BINS.DATA_CATEGORY_ID=6)) BIN  L       m    lI\v b ZDescription of the bin for each data categoryBIN_RANGE         m    a;$DK&3@ 8Description of the bin range& DATA_CATEGORY_ID  p       m + {*@@( Unique identifier assigned to a data category -- FK to DATA_CATEGORY_LUT$BIN_LOW_DEFAULT         m u[pڥ@} vXX PDefault value for the low end of the bin& BIN_HIGH_DEFAULT         m ӷ9E #Z RDefault value for the high end of the bin?BIN_LOW_USER         m SWI!q User defined value for the low end of the bin, defaulted initially to the BIN_LOW_DEFAULT valueE BIN_HIGH_USER         m  &(Mb( User defined value for the high end of the bin, defaulted initially to the BIN_HIGH_DEFAULT valueBIN_RANK         m R6K\ TRank/Risk assigned to the bin number (1-4)BIN_NUMBER      F >Identifies the bin number (1-4)   m FNOՄ*LVALN MR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenDecimalPlacesRequiredDisplayControlAllowZeroLengthIMEModeIMESentenceMode$UnicodeCompressionDefaultValueGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionSmartTags  L D Uv2UuB>Zb@COMMODITY_LUT `:Nz+jH&v2UuB>COMMODITY_ID"RĈET|/i`v2UuB>COMMODITYRPrkK٫-v-Mv2UuB>COMMODITY_CATEGORY_ID   v2UuB> Look up table for the individual commodities. Contains the mapping to the commodity category level.N FCOMMODITY_LUT.COMMODITY_CATEGORY_IDCOMMODITY_ID r      m  `:Nz+jH&R JUnique identifier for the commoditiesCOMMODITY r       m       "RĈET|/i`L DName of the individual commodities0*COMMODITY_CATEGORY_ID       m RPrkK٫-v-M Identifier of the commodity category to which the commodity belongsMR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenDecimalPlacesRequiredDisplayControlAllowZeroLengthIMEModeIMESentenceMode$UnicodeCompressionGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTags  . & Uh1\zL<{o._@COMMODITY_CATEGORY_LUT]*-qtGt h1\zL<{COMMODITY_CATEGORY_IDGjDݓʊh1\zL<{COMMODITY_CATEGORY   h1\zL<{ Look up table for commodity categories. This is the level the ranking is done on.0*COMMODITY_CATEGORY_ID       m ]*-qtGt ` XUnique identifier for the commodity categoryh*$COMMODITY_CATEGORY        m       GjDݓʊ Name of the commodity category to which commodities are assigned. The tool ranks at this level.LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTags]  b Z UGڦ?zeSi@CONSUMPTION9 5KE?B_Gڦ?zeCOMMODITY_CATEGORY_ID5!QFHgOGڦ?zePOP_CONSUMING_PERCENT08 &JζGڦ?zeUSER_BIN_RANK   Gڦ?ze Contains consumption data summarized to the commodity category level. (Commodity Category)0*COMMODITY_CATEGORY_ID         m 9 5KE?B_R JIdentifier for the commodity categoryu0*POP_CONSUMING_PERCENT         m 5!QFHgO Sum of the percentages of the population consuming the commodity/commodity category across the commodity category USER_BIN_RANK         m 08 &Jζ" Rank assigned to thiscommodity category for consumption based on where the value in AVG_POP_CONSUMING_PERCENT falls in the user defined binsLVALMR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTags;    U‚G"u6/_@-CONSUMPTION_RAWmȩIs|‚G"uCOMMODITY_IDB 0K~3‚G"uCOMMODITY_CATEGORY_IDvZ*|9ktHLG+Y‚G"uMEAN_GRAMSAk&‚G"uPOP_CONSUMING_PERCENT   ‚G"uV NContains consumption data as collected.MEAN_GRAMS '       m vZ*|9ktHLG+YN FAverage grams of commodity consumed!0*POP_CONSUMING_PERCENT        m Ak& Percentage of the population consuming the commodity/commodity categoryCOMMODITY_ID r       m mȩIs|@ 8Identifier for the commodity0*COMMODITY_CATEGORY_ID        m B 0K~3R JIdentifier for the commodity categoryLVALMR2OrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTags8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldTextAlignAggregateType  Z R Up1F4@r~l3f@0gCONTAMINATIONWIioJfsPp1F4@rPATHOGEN_CATEGORY_ID RobJ$K2p1F4@rCOMMODITY_CATEGORY_IDKB^LF2p1F4@rPREVALENCE_RANGE_PERCENTF2-N)X_3p1F4@rAVG_PREVALENCE_PERCENTOEYp1F4@rNUMBER_STUDIES]Ie_Fa+ڎp1F4@rUSER_BIN_RANK   p1F4@r Contains contamination data. (Pathogen Category and Commodity Category)N FCONTAMINATION.COMMODITY_CATEGORY_ID     S60PREVALENCE_RANGE_PERCENT D      m       KB^LF2 Percentage range of pathogen category - commodity category prevalence  2,AVG_PREVALENCE_PERCENT        m F2-N)X_3p hAverage prevalence percent based on prevalence range  .(PATHOGEN_CATEGORY_ID        mP HIdentifier for the pathogen category WIioJfsP  0*COMMODITY_CATEGORY_ID        mR JIdentifier for the commodity category  RobJ$K2   USER_BIN_RANK        m\ TRank assigned to this commodity category-pathogen category combination for contamination based on where the value in AVG_PREVALENCE_PERCENT falls in the user defined bins  0 ]Ie_Fa+ڎ  ,"NUMBER_STUDIES        m Number of studies referencing this pathogen category - commodity category OEY   LVALMR2BValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTagsAllowZeroLengthIMEModeIMESentenceMode$UnicodeCompression     Uu~XCSa @ɴb@DATA_CATEGORY_LUTTj"aC2-u~XCSa @DATA_CATEGORY_IDPI%0`Zu~XCSa @DATA_CATEGORYU_wp0hA4_iqu~XCSa @DATA_TYPE_ID-(BzG;u~XCSa @NUMERIC_CRITERIA_FLAG_RNKl˨u~XCSa @BIN_DESCi&8ZATwu~XCSa @USER_WEIGHT   u~XCSa @T LLook up table for the data categories.L DDATA_CATEGORY_LUT.DATA_CATEGORY_ID& DATA_CATEGORY_ID  p       m Tj"aC2-H @Identifier for the data category DATA_CATEGORY  Q       m    PI%0`Z2 *Name of data categoryB0*NUMERIC_CRITERIA_FLAG       Yes/No  j -(BzG; Flag to track whether the evaluation criteria for the bins is numeric or narrative2BIN_DESC  g       m    _RNKl˨Ӧ Description of the bin (including unit where applicable) for each data categoryUSER_WEIGHT         m i&8ZATwj bWeight assigned by the user for the data categoryDATA_TYPE_ID      @ 8Identifier for the data type   m U_wp0hA4_iqJvcO<)   x e R > +  {  g T A @-}iVC/ lXE2 n[3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U T1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U T1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U T1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U T1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U T1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U T1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U _2U _1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp _3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U Z2U Z1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp Z3U U2U U1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp U3U O2U O1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp O3U I2U I1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp I3U C2U C1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp C3U >2U >1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp >3U 92U 91K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp LLVAL ^MR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTags  D < US4bxE+$&p3_@-DEATH۠fƿM^vOS4bxE+$&PATHOGEN_CATEGORY_IDEfbeXFS4bxE+$&DEATH_PERCENTvzk",Nq,S4bxE+$&USER_BIN_RANK   S4bxE+$&X PContains death data. (Pathogen Category) DEATH_PERCENT 5       m EfbeXF\ TDeath percentage for the pathogen category.(PATHOGEN_CATEGORY_ID        mP HIdentifier for the pathogen category ?MS@բ{>!O USER_BIN_RANK        m Rank assigned to this pathogen category for death based on where the value in DEATH_PERCENT falls in the user defined bins  0 H;K/iIMR2BOrientationOrderByOnNameMapDefaultViewDescriptionColumnWidthColumnOrderColumnHiddenDecimalPlacesRequiredDisplayControlAllowZeroLengthIMEModeIMESentenceMode$UnicodeCompressionGUIDValidationRuleValidationText FilterOrderBy FormatInputMaskCaptionDefaultValueSmartTags    UevRM%-_u5_@ DATA_TYPE_LUTl6oB&xR7evRM%-_DATA_TYPE_ID^HS?mevRM%-_DATA_TYPE  J BLook up table for the data types. evRM%-_DATA_TYPE_ID 6       mN FUnique identifier for the data type l6oB&xR7DATA_TYPE         m     2 *Name of the data type ^HS?mLVAL MR2OrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTags8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldTextAlignAggregateType    Uh LizD^G4\f@EPIDEMIOLOGICAL_LINKdA}LB0!h LizD^GPATHOGEN_CATEGORY_IDj{E'ܳih LizD^GCOMMODITY_CATEGORY_IDMKF$'e2h LizD^GOUTBREAKS@ς;9h LizD^GTOTAL_CASES2^tD}$h LizD^GUSER_BIN_RANK   h LizD^G Contains epidemiological link data. (Pathogen Category and Commodity Category)h `((EPIDEMIOLOGICAL_LINK.COMMODITY_CATEGORY_ID=4))\ TEPIDEMIOLOGICAL_LINK.COMMODITY_CATEGORY_ID      OUTBREAKS d       m MKF$'e2 Number of outbreaks for this pathogen category - commodity category pair  TOTAL_CASES        m @ς;9 Number of case for this pathogen category - commodity category pair  0*COMMODITY_CATEGORY_ID        mR JIdentifier for the commodity category 0I['EFJM1cTu  .(PATHOGEN_CATEGORY_ID        mP HIdentifier for the pathogen category ͦL@⳸   USER_BIN_RANK        mf ^Rank assigned to this pathogen category - commodity category pair for epidemiological link based on where the value in AVG_NUMBER_PER_OUTBREAK falls in the user defined bins  0 Rx{H,  kLVAL{MR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTags    U刎Ҭ1AE*z5,y3f@EPIDEMIOLOGICAL_MULTIPLIERSТ-?Bu 刎Ҭ1AE*zPATHOGEN_CATEGORY_IDuu\:INaG}刎Ҭ1AE*zCOMMODITY_CATEGORY_IDQ2*}L#[刎Ҭ1AE*zMULTIPLIERz[Ena刎Ҭ1AE*zUSER_BIN_RANK   刎Ҭ1AE*z Contains Epidemiological Multiplier data. (Pathogen Category and Commodity Category) MULTIPLIER        m Q2*}L#[ Mulitplier assigned to each pathogen category - commodity category pair0*COMMODITY_CATEGORY_ID        mR JIdentifier for the commodity category uu\:INaG}.(PATHOGEN_CATEGORY_ID O       mP HIdentifier for the pathogen category Т-?Bu  USER_BIN_RANK        mL DRank assigned to this pathogen category - commodity category for epidemiological multiplier based on where the value in MULTIPLIER falls in the user defined bins  0 z[EnaLVALMR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTagsDecimalPlaces  @ 8 U:bs@@z69T_@0GROWTH_POTENTIALd%dLn:bs@@z6PATHOGEN_CATEGORY_ID ~nOvE*i:bs@@z6COMMODITY_CATEGORY_ID@ O1:bs@@z6GROWTH_POTENTIAL_COMMENTSN]"PKCMBI:bs@@z6DEFAULT_BINBD%#b:bs@@z6USER_BIN'n|&*j J֐_NPATHOGEN_TYPEvAebPI<L~0_@EIDPATHOGEN_CATEGORY_LUT]O$B&vAebPI|&*: 2Name of the pathogen typeMR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTags  l d UĨTfZN*Zlu3_@-HOSPITALIZATIONpFf#˟H2~ ĨTfZN*PATHOGEN_CATEGORY_ID* CM ꐚCĨTfZN*HOSPITALIZATION_PERCENT0[OIů<:z ĨTfZN*USER_BIN_RANK   ĨTfZN*l dContains hospitalization data. (Pathogen Category)4.HOSPITALIZATION_PERCENT 1       m * CM ꐚCr jHospitalization percentage for the pathogen category.(PATHOGEN_CATEGORY_ID        mP HIdentifier for the pathogen category "7;wMq# USER_BIN_RANK        m& Rank assigned to this pathogen category for hospitalization based on where the value in HOSPITALIZATION_PERCENT falls in the user defined bins  0 |_<׹F~]p怑LVAL:(MR2 RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLUseTransactionNameMapRecordsetType|  <    12NX7I  UwedOx}ϲokd@@N SHELF_LIFE_RAW%%uqIat~wedOx}ϲCOMMODITY_CATEGORY_ID~.[HBM 6uwedOx}ϲSHELF_LIFE_DAYS     MR2<ColumnWidthColumnHiddenRecordLocksODBCTimeoutUseTransactionOrientationNameMapGUIDDOLMaxRecordsRecordsetType FilterOrderByOrderByOnDefaultViewkPJCONSUMPTION_RAW.COMMODITY_CATEGORY_ID  S82AVG_POP_CONSUMING_PERCENT k   <   P9Ej&  U‚G"uA[b@M CONSUMPTION_RAWB 0K~3‚G"uCOMMODITY_CATEGORY_IDAk&‚G"uPOP_CONSUMING_PERCENT      MR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTagsDecimalPlacesw    UxgJG;b@INFECTIOUS_DOSE@GCnSX!xgJG;PATHOGEN_CATEGORY_ID0gEEGzxgJG;INFECTIOUS_DOSE_RANGE/&bRANK_RESULTS2gCOMMODITY_CATEGORY_LUTTPATHOGEN_CATEGORY_LUTά;G&jqSHELF_LIFE_RAWά@&KqCONSUMPTION_RAWRLVALdMR2BValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTagsAllowZeroLengthIMEModeIMESentenceMode$UnicodeCompressionM  D < UIz;MCJC@1:0_@-PATHOGEN_LUT[Q%O{XIz;MCJC@1PATHOGEN_IDqF}'&Iz;MCJC@1PATHOGENEJ܋cIz;MCJC@1PATHOGEN_CATEGORY_ID   Iz;MCJC@1 Look up table for the individual pathogens. Contains the mapping to the pathogen category level.PATHOGEN  O       m    qF}'&H @Name of the individual pathogensPATHOGEN_ID         m [Q%O{XN FUnique identifier for the pathogens.(PATHOGEN_CATEGORY_ID         m EJ܋c Identifier of the pathogen category to which the pathogen belongsMR2BValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTagsAllowZeroLengthIMEModeIMESentenceMode$UnicodeCompression  r j UvAebPI<3_@0PATHOGEN_CATEGORY_LUT<>]J3/CprvAebPI]J3/Cpr^ VUnique identifier for the pathogen category^("PATHOGEN_CATEGORY         m    FlAɍ Name of the pathogen category to which pathogens are assigned. The tool ranks at this level.& PATHOGEN_TYPE_ID         m Identifier of the pathogen type to which the pathogen category belongs ]O$B&}LVAL{ MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLColumnWidthColumnHiddeno        v*Dk@M  Uu~XCSa @J#o@[DATA_CATEGORY_LUT nB?m>_J#o@[BINSevRM%-_K#o@[DATA_TYPE_LUT^HS?mevRM%-_DATA_TYPE-(BzG;u~XCSa @NUMERIC_CRITERIA_FLAGPI%0`Zu~XCSa @DATA_CATEGORYR6K nB?m>_BIN_RANKi&8ZATwu~XCSa @USER_WEIGHTlI\v  nB?m>_BINSWI!q nB?m>_BIN_LOW_USER &(Mb( nB?m>_BIN_HIGH_USERTj"aC2-u~XCSa @DATA_CATEGORY_ID+ {*@@( nB?m>_DATA_CATEGORY_IDU_wp0hA4_iqu~XCSa @DATA_TYPE_IDl6oB&xR7evRM%-_DATA_TYPE_ID [@:DATA_CATEGORY_LUT.USER_WEIGHT  6  MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLColumnWidthColumnHidden  <      'Ζ G݇SlF > U9%Dko#K#o@oRANK_RESULTSh1\zL<{K#o@oCOMMODITY_CATEGORY_LUTvAebPI<J#o@oPATHOGEN_CATEGORY_LUTFlAɍvAebPI]J3/CprvAebPI +  {  g T A -}jVC0 lYE2 n[H)3U (2U (1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp (3U '2U '1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp '3U &2U &1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp &3U %2U %1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp %3U $2U $1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp $3U #2U #1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp #3U "2U "1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp "3U !2U !1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp !3U  2U  1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp  3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp 3U 2U 1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTagsU  \ T UvGZˀѡ pf@~?SHELF_LIFEی/FGvGZˀѡCOMMODITY_CATEGORY_IDx!iL_hlG7vGZˀѡAVG_SHELF_LIFE_DAYS*OFݢHvGZˀѡUSER_BIN_RANK   vGZˀѡ Contains shelf life data summarized to the commodity category level. (Commodity Category)0*COMMODITY_CATEGORY_ID         m ی/FGR JIdentifier for the commodity category,&AVG_SHELF_LIFE_DAYS         m x!iL_hlG7 Average of shelf lifes in days for the commodity/commodity category (currently using maximum of range) across commodity category USER_BIN_RANK         m *OFݢH Rank assigned to this commodity category for shelf life based on where the value in AVG_SHELF_LIFE_DAYS falls in the user defined binsLVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTags    UJC!}#ro?f@SHELF_LIFE_GROWTH_POTENTIAL_COMBINED3bE) JC!}#rPATHOGEN_CATEGORY_ID{gUDCHA+}JC!}#rCOMMODITY_CATEGORY_ID"X;FGpJC!}#rUSER_BIN_RANKwx`FMx79sJC!}#rSUM_SL_GP_RANK   JC!}#r Contains growth potential data and shelf life combined user bin ranking. (Pathogen Category and Commodity Category).(PATHOGEN_CATEGORY_ID      P HIdentifier for the pathogen category   m Px,OIqB0*COMMODITY_CATEGORY_ID      R JIdentifier for the commodity category   m bϿB: USER_BIN_RANK      : 2Rank assigned to the commodity category-pathogen category combination for growth potential and shelf life based on the sum of each individual bin value   0  m  IHuU^&Q"SUM_SL_GP_RANK      n fSum of the shelf life and growth potential rankings   0  m H=NbHI"i LVAL0MR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTagsDecimalPlaces    UwedOx}ϲ^]b@SHELF_LIFE_RAW~gBktwedOx}ϲCOMMODITY_ID%%uqIat~wedOx}ϲCOMMODITY_CATEGORY_IDO1E=\wedOx}ϲSHELF_LIFE_RANGE_DAYS~.[HBM 6uwedOx}ϲSHELF_LIFE_DAYS   wedOx}ϲT LContains shelf life data as collected.P HSHELF_LIFE_RAW.COMMODITY_CATEGORY_ID(0*SHELF_LIFE_RANGE_DAYS       m       O1E=\ zShelf life range for the commodity/commodity category in daysCOMMODITY_ID r      m ~gBkt@ 8Identifier for the commodity0*COMMODITY_CATEGORY_ID       m %%uqIat~R JIdentifier for the commodity category;$SHELF_LIFE_DAYS       m ~.[HBM 6u Shelf life in days for the commodity/commodity category (currently using maximum of range)LVALMR2ANSI Query Mode(Themed Form ControlsAccessVersion BuildProjVerAppTitleStartUpForm&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRptNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By    08.50  W* "Risk Ranking Tool            " Form.frm_Main  w   MR2BOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionGUIDValidationRuleValidationText FilterOrderByDescription FormatInputMaskCaptionDefaultValueSmartTagsDecimalPlaces?    UC]#m\H6.(PATHOGEN_CATEGORY_ID   P HIdentifier for the pathogen category    m .KDJ"|DEFAULT_BIN   * "Default bin value    m       _o=EdtbUSER_BIN    User defined bin value, default value is DEFAULT_BIN, can be manually changed by the user in this table    m       ,kIBnG b)TwHOSPITAL_PATH_CAT_FKHOSPITALIZATIONPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_ID|T6DOSE_PATH_CAT_FKINFECTIOUS_DOSEPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_IDtL.DEATH_PATH_CAT_FKDEATHPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_IDb:0DATA_TYPE_LUTDATA_CATEGORY_LUTDATA_CATEGORY_LUTDATA_TYPE_IDDATA_TYPE_LUTDATA_TYPE_IDlJDATA_CATEGORY_LUTBINSBINSDATA_CATEGORY_IDDATA_CATEGORY_LUTDATA_CATEGORY_ID`@8COMMODITY_LUTSHELF_LIFE_RAWSHELF_LIFE_RAWCOMMODITY_IDCOMMODITY_LUTCOMMODITY_IDx`DCOMMODITY_LUTCONSUMPTION_RAWCONSUMPTION_RAWCOMMODITY_IDCOMMODITY_LUTCOMMODITY_ID|dFCOMMODITY_CATEGORY_LUTSHELF_LIFE_RAWSHELF_LIFE_RAWCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDrVCOMMODITY_CATEGORY_LUTSHELF_LIFESHELF_LIFECOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDbNCOMMODITY_CATEGORY_LUTRANK_RESULTSRANK_RESULTSCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDjRCOMMODITY_CATEGORY_LUTGROWTH_POTENTIALGROWTH_POTENTIALCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDzZCOMMODITY_CATEGORY_LUTEPIDEMIOLOGICAL_LINKEPIDEMIOLOGICAL_LINKCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_ID bCOMMODITY_CATEGORY_LUTEPI_MEAD_MULTIPLIERSEPIDEMIOLOGICAL_MULTIPLIERSCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDbCOMMODITY_CATEGORY_LUTCONTAMINATIONCONTAMINATIONCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDnTCOMMODITY_CATEGORY_LUTCONSUMPTION_RAWCONSUMPTION_RAWCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDvXCOMMODITY_CATEGORY_LUTCONSUMPTIONCONSUMPTIONCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDfPCOMMODITY_CATEGORY_LUTCOMMODITY_LUTCOMMODITY_LUTCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDnTH  @ @ @!!!!!!!!!! ! ! !!!!! !!!! ! ! !  $ @ @&&&&&&& & & &  & & & &  ( @ @** **** *****  * * *  *   @ @        @V 4 * m  .pf@pf@SLGP_COMM_CAT_FK3UBBBBBBBBBB@ -b33_@b33_@POP_PATH_CAT_FK3U@@@@@@@@@@> ,xz_@xz_@PATHOGEN_TYPE_LUTPATHOGEN_CATEGORY_LUT3Unnnnnnnnnnl +/߿'pf@/߿'pf@PATHOGEN_CATEGORY_LUTSHELF_LIFE_GROWTH_POTENTIAL_COMBINED3U *LZ_@LZ_@PATHOGEN_CATEGORY_LUTRANK_RESULTS3Uddddddddddb )qp_@qp_@PATHOGEN_CATEGORY_LUTPATHOGEN_LUT3Uddddddddddb (u_@u_@PATHOGEN_CATEGORY_LUTGROWTH_POTENTIAL3Ullllllllllj '6_@6_@PATHOGEN_CATEGORY_LUTEPIDEMIOLOGICAL_LINK3Uttttttttttr &$_@$_@PATHOGEN_CATEGORY_LUTEPI_MEAD_MULTIPLIERS3Uttttttttttr %_@_@PATHOGEN_CATEGORY_LUTCONTAMINATION3Uffffffffffd $սO23_@սO23_@HOSPITAL_PATH_CAT_FK3UJJJJJJJJJJH #-:23_@-:23_@DOSE_PATH_CAT_FK3UBBBBBBBBBB@ "^C\13_@^C\13_@DEATH_PATH_CAT_FK3UDDDDDDDDDDB   SLGP_COMM_CAT_FKSHELF_LIFE_GROWTH_POTENTIAL_COMBINEDCOMMODITY_CATEGORY_IDCOMMODITY_CATEGORY_LUTCOMMODITY_CATEGORY_IDv.POP_PATH_CAT_FKSUSCEPTIBLE_POPULATIONPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_IDX,PATHOGEN_TYPE_LUTPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_LUTPATHOGEN_TYPE_IDPATHOGEN_TYPE_LUTPATHOGEN_TYPE_IDZPATHOGEN_CATEGORY_LUTSHELF_LIFE_GROWTH_POTENTIAL_COMBINEDSHELF_LIFE_GROWTH_POTENTIAL_COMBINEDPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_IDBPATHOGEN_CATEGORY_LUTRANK_RESULTSRANK_RESULTSPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_IDhPPATHOGEN_CATEGORY_LUTPATHOGEN_LUTPATHOGEN_LUTPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_IDhPPATHOGEN_CATEGORY_LUTGROWTH_POTENTIALGROWTH_POTENTIALPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_IDxXPATHOGEN_CATEGORY_LUTEPIDEMIOLOGICAL_LINKEPIDEMIOLOGICAL_LINKPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_ID`PATHOGEN_CATEGORY_LUTEPI_MEAD_MULTIPLIERSEPIDEMIOLOGICAL_MULTIPLIERSPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_ID`PATHOGEN_CATEGORY_LUTCONTAMINATIONCONTAMINATIONPATHOGEN_CATEGORY_IDPATHOGEN_CATEGORY_LUTPATHOGEN_CATEGORY_IDlR  @ @ @ @ @   (                        ! " # $ % & ' ) * + ,  @ @     5 vcO<)   x e .2U .1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp .3U -2U -1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp -3U ,2U ,1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp ,3U +2U +1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp +3U *2U *1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp *3U )2U )1K)TX4օUuq2}e/u$c-pC;Q[5m2STGOf=SUH߱"}&v[НMճY,Y+@Mp K_[lmnopqrstuvwxyz{|}~PROJECT 3PROJECTwm:PAcessVBAData< Forms 0knR]'  !"#$%&'()*+,-./012456789;?@ABCDEFGHIJKLMNPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~0A0C911005A};VBE;&H00000000 [Workspace] Form_frm_Main=22, 22, 1058, 802, Z mod_utility=44, 44, 1080, 824, Form_frm_MainForm_frm_Mainmod_utilitymod_utilityͬ4Z:D<+GDetail{ TabCtl0d Label15nlst_data_categoryd lbl_Bin3dBox\.Descri End1NvalVariaC!릡DBEngine(0)X>@DuBQ*SQnapshotIf LEOF Thepn 8"ElR BAJIf IsNulEF)V iE ID="{A1AA6910-4F55-4A32-A968-CD3449D91C9A}" DocClass=Form_frm_Main/&H00000000 Module=mod_utility Name="FDA_EPI" HelpContextID="0" VersionCompatible32="393222000" CMG="A6A47A949ABCAAC0AAC0AAC0AAC0" DPB="BAB866807B817B817B" GC="CECC12BC32C447C547C5B8" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-0!3PLJGGZBMYWPITDOUIVMLEVDETKBE: h WINAJZGBBPHRMDWSIYTJEEQEDILL:C_VBA_PROJECT9dir(K_[0* pHdFDA_EPIQ(@= l p%J J< rstdole>stdoleP h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\e2.tlb#OLE Automation`DAO>JDAOA A5E0 1A5AProgram Files\CommonMicrosoft Shared\;\dao360.dll# 3.6 Object Lib0raryHADODB>" ADZDB\\!\10-8AA006D2EA4-N1N.SS\a do\ms@21T+Active@X Data-sP 2.1K.BW *mod_utilityGA@d_u@iiyPLJGGZBMYWPITDOUIVMLEVDETKBE28ALJG@Z@DMYWPITBIU@VMEV@*EK EBH@1BB,-!B+B@\F orm_fMa8inG*0rm1fMa0in1AJZGBBPHRMDWSIYTJEEQEDILL1W*N@JZ2B(P'R.D4S@Y.JE@QD@L5I1~1"-0(bbWxam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll#Microsoft DAO 3.6 Object Library*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library p%JW8PLJGGZBMYWPITDOUIVMLEVDETKBE0@4d99ee7emod_utility8WINAJZGBBPHRMDWSIYTJEEQEDILL0A4d99ee7eAForm_frm_Main~8,ZMU8qIB%ZnH|:AccessVBAWin16~Win32MacVBA6#FDA_EPIPstdole`DAOADODBs mod_utility+j _EvaluateSIDEBAR8wsqlstrdbMainqtrec Recordsetqry1ǟCommand] err_handlerlCurrentProject$ Connection adOpenStatic RecordCount{MsgBoxRErro Description sqlval7DBEngineQ OpenRecordset|dbOpenSnapshotEOFIsNull Form_frm_Maincmd_resetBins_Clickp RESET_BINSlst_data_category_Click c)K_[md_run_ClickY error_msg CHECK_BINStxt_consumptionValueKtxt_contaminationw txt_deathQtxt_multiplier>txt_link[ytxt_slgp8 txt_hospitaltxt_infectious ~txt_population UvbOKOnly ASSIGN_BINS aRANK db\rstbin1bin2_low]ubin3_low+ bin2_high{t bin3_high1bin4data_catN[response Application* CurrentDbSMoveLast MoveFirstN bin_numberF bin_high_user data_categoryC; bin_low_userMoveNextL! Form_Open-Cancel RESET_FORMlst_data_category\ExecuteYpopulate_labels7populate_labels_multi_catQ data_cat_idatxt_Bin1VisibleLabel40 txt_Bin2_lowLabel51Label53 lbl_CaptioncCaptionxlbl_Bin4lbl_Bin3lbl_Bin2lbl_Bin1txt_bin4 txt_Bin3_high=6 txt_Bin2_high txt_Bin3_low[ start_tablek~start_table_count)RANK_PROCESS_TABLE?DoCmdƧ OpenReport acViewPreview2 tablename` weight1 data_typeadd_risk user_bin_rankpathogen_category_idoCOMMODITY_CATEGORY_IDM UPDATE_BINS UPDATE_MULTI_COLUMN_BASED_BINS'DETERMINE_SLGP_BINa bin_columnrcriteria7bin_rankDETERMINE_NUMERIC_BINDETERMINE_NARRATIVE_BINrEdit+Updatecriteria_column>6 data_value bin4_low8SUM_SL_GP_RANKbin3bin2 txt_Bin1_ExitEtxt_Bin2_low_ExitQtxt_Bin2_high_Exit|ktxt_Bin3_low_ExitMKtxt_Bin3_high_ExitO txt_Bin4_ExitgL update_weight0)data_category_idVtxt_consumption_Exittxt_contamination_Exittxt_death_ExitTa txt_slgp_Exittxt_hospital_Exit[txt_infectious_Exitu txt_link_Exitktxt_multiplier_Exittxt_population_Exit)s`A    $8~WxME PS<S<S<<<<<<XSN0{07AB005A-3AA3-44B9-97A4-3CE1D62B47A2} B@ H`J,LAi !< h % j0X!%`l `n!`p`!`rPlea`tr ea`vb$`x `z X8i F` (;i` h+i` f(8``` 8h&iHi i*K_[` hed f % j be %`. dx #i'ziii hP % jp%` $iii0!PiPKi!P hT % j%`!2,+i( iHRi ``p`n` ` 4 h  % j@ %`,x +i i Ri `v ```l ` D 8`\    P i`  i`0 x @ i(`  i`0 h 0 i`H  i` x i@I ` i  8i  xi iD X8iRE D iIN F i xXi  i_CAT% !x- " "(0 8  0@px  6@  +K_[ B (08@HPX`h p x  0      ( 0  8 H P  X h p  x   $$\@PX `ph     (08H " PX `h  p 4  "    ( ,8h x   "    ( $ (@ *h ( * $  $( (P *x ( * $ (  8  H  X  h  x L  R H R`  R ( R@  \  ( \@   \ 0H `hp "         L@ RX R  R8 R \x \  \8  "   4 ( $  H BP * , 6 0 @ 6H * , *    h(  f8, (x.6$.0.`4,> L8 p N &H p :  "   0 HPX  `p 8 P  x   " @ P(Lx 2D FH L z <`! L!D! 88">p" " " " """" ,K_[" "# # #(#  0#@# X#p# ## ## #### ## $$$ $ " ($0$8$@$ H$ P$h$ $$$  $$ $$ $$  $% % %(%0% 8%@% H%P%X%h% B p%x%%%% % \%& \&p& \&&  &X'X' h'X'' 'X(X(  h(Xx(( ((( ())) " )()0)8) @) H)(* 8** +8+ P+X+`+  h+x+ + (+ + (+ + + , ,  ,(, 0,@, P,`,h,p, x,, ,,,, B ,,,,,, , R,@- RP-- R-. R .x. . . X. ./ X/ `/p/ Xx/ // X/ @0P0 X0`0 h0p0x00"00 0 X01 :1P1 @`11 011 21(2 *82h2 @x22 :23 43P3 4`33  Z3 4 0(4X4 Jh44 J45  h(5 05 "5 5556 "6 6  686P6h66666666677(787H7X7h7 Dx77 7777 " 78 8 8 p 88 p89  9(909@9" H9P9 X9 `9 pp99 p9`: p:x:::" :: : : p:-K_[0; p@;; ;;;;" ;; ; < p<< p<= == =0=" 8=@= H= P= p`== p=P> `>h>p>>" >> > > p> ? p0?? ???? " ?? ?  ?`@`@p@ x@@@@ " @@@ " @@@ " @@A " A A8APA " XA`AxA " AAA " AAA " AAA " ABB & B 8HB 6B BBxADAFoX@]$@)check that the bins values are increasing L'J JERROR|hk`/check that all the data categories have weights !N!P !R!P !T!P !V!P !X!P !Z!P !\!P !^!P !`!P-Please enter a weight for each data category. b$.'J|(k AdAf|$ 0!2A@.o]]]8]P]h]]]]]$ !|!~.h SELECT BINS.DATA_CATEGORY_ID, DATA_CATEGORY, BIN, BIN_NUMBER, BIN_RANK, BIN_LOW_USER, BIN_HIGH_USER FROM BINS, DATA_CATEGORY_LUT WHERE BINS.DATA_CATEGORY_ID=DATA_CATEGORY_LUT.DATA_CATEGORY_ID AND NUMERIC_CRITERIA_FLAG=TRUE ORDER BY BINS.DATA_CATEGORY_ID, BIN_NUMBER h%8.j)check that the bins values are increasingNONE'L@ jC@C@5<b66'l6'x6e+6'n6'r6e(6'p6't6eH6'v l n r p t v l r  r t The values entered for the x" bins must be in increasing order. b$.'zERROR'LzkdThe end values entered for the x2 bins must match the previous and subsequent bins. b$.'zERROR'LzkkC@q.j.hz$ 0!2A@.i$ADAselect first item !(PAF,UPDATE DATA_CATEGORY_LUT SET USER_WEIGHT = 0'  ~B@|$ 0!2A@.oX]$ !PRKKKKK KT !PA@R KT !PA@S`AnP|H$@ 0!2A@.TEo(]$" If DATA_CAT_ID = 3 Then 'DEATH txt_Bin1.DecimalPlaces = 1" txt_Bin2_low.DecimalPlaces = 1# txt_Bin2_high.DecimalPlaces = 1" txt_Bin3_low.DecimalPlaces = 1# txt_Bin3_high.DecimalPlaces = 1 txt_bin4.DecimalPlaces = 1 Else txt_Bin1.DecimalPlaces = 0" txt_Bin2_low.DecimalPlaces = 0# txt_Bin2_high.DecimalPlaces = 0" txt_Bin3_low.DecimalPlaces = 0# txt_Bin3_high.DecimalPlaces = 0 t.K_[xt_bin4.DecimalPlaces = 0 End If ( ( ( ( (>SELECT BIN_DESC FROM DATA_CATEGORY_LUT WHERE DATA_CATEGORY_ID= ' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4 !(5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4 !(P $4 !(P5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4 !(P $4 !(P6SELECT BIN_HIGH_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4 !(P $4 !(P|$ 0!2A@.ox(]$` ( ( ( ( (>SELECT BIN_DESC FROM DATA_CATEGORY_LUT WHERE DATA_CATEGORY_ID= ' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4 !(,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4 !(5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4 !(P $4 !(P5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4 !(P $4 !(P6SELECT BIN_HIGH_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4 !(P $4 !(P|0 $( 0!2A@.o ]]]$ find the table with the most pathogen category - commodity category pairs (either contamination, epi mead multiplier, epidemiological_link, or growth potential)-sqlstr = "select count(*) from contamination""start_table_count = sqlval(sqlstr)start_table = "contamination";sqlstr = "select count(*) from EPIDEMIOLOGICAL_multipliers"#If sqlval(sqlstr) > pair_count Then& start_table_count = sqlval(sqlstr)/ start_table = "EPIDEMIOLOGICAL_multipliers"End If0sqlstr = "select count(*) from growth_potential"#If sqlval(sqlstr) > pair_count Then& start_table_count = sqlval(sqlstr)$ start_table = "growth_potential"End Ifa'populate the rank_results table with pathogen category - commodity category pairs of start tablesqlstr = "insert into rank_results (pathogen_category_id, commodity_category_id) select distinct pathogen_category_id, commodity_category_id from " & start_table_instead of populating pathogen-commodity pair list based on tables, go with pre-determined list$update rank_results set rank_total=0'  ~B@cycle through tables multiplying USER_BIN_RANK * WEIGHT and adding to RANK_TOTAL for corresponding pathogen, commodity or pathogen-commodity. CONTAMINATION R!PBOTHAEPIDEMIOLOGICAL_LINK X!PBOTHAEPIDEMIOLOGICAL_MULTIPLIERS V!PBOTHADEATH T!PPATHOGENAHOSPITALIZATION \!PPATHOGENAINFECTIOUS_DOSE ^!PPATHOGENASUSCEPTIBLE_POP/K_[ULATION `!PPATHOGENA CONSUMPTION N!P COMMODITYA$SHELF_LIFE_GROWTH_POTENTIAL_COMBINED Z!PBOTHAECall RANK_PROCESS_TABLE("GROWTH_POTENTIAL", txt_growth.Value, "BOTH")iCall RANK_PROCESS_TABLE("PRODUCTION", txt_production.Value, "COMMODITY") 'Removed production from rankingGCall RANK_PROCESS_TABLE("SHELF_LIFE", txt_shelflife.Value, "COMMODITY")RISK_RANKING_REPORT  B@to print4DoCmd.OpenReport "RISK_RANKING_REPORT", acViewNormal|8$0 0!2A@.o(]]]] $ !|!~.h  h%8.j jC@C@5<b BOTH2UPDATE RANK_RESULTS SET RANK_TOTAL = RANK_TOTAL + j"!P  WHERE PATHOGEN_CATEGORY_ID =  j"!P AND COMMODITY_CATEGORY_ID =  j"!P' PATHOGENe2UPDATE RANK_RESULTS SET RANK_TOTAL = RANK_TOTAL + j"!P  WHERE PATHOGEN_CATEGORY_ID =  j"!P'  COMMODITYe2UPDATE RANK_RESULTS SET RANK_TOTAL = RANK_TOTAL + j"!P  WHERE COMMODITY_CATEGORY_ID =  j"!P'k  ~B@C@`qX.j.h|@$8 0!2A@.o 8 CONSUMPTIONPOP_CONSUMING_PERCENTNUMERICAICall UPDATE_BINS(2, "CONTAMINATION", "AVG_PREVALENCE_PERCENT", "NUMERIC") CONTAMINATIONAVG_PREVALENCE_PERCENTNUMBER_STUDIESADEATH DEATH_PERCENTNUMERICAEPIDEMIOLOGICAL_MULTIPLIERS MULTIPLIERNUMERICAHOSPITALIZATIONHOSPITALIZATION_PERCENTNUMERICAINFECTIOUS_DOSEINFECTIOUS_DOSE_NUM_ORGANISMSNUMERICAtCall UPDATE_BINS(8, "PRODUCTION", "AVG_TOTAL_US_PRODUCTION_METRIC_TONS", "NUMERIC") 'Removed Production from ranking SHELF_LIFEAVG_SHELF_LIFE_DAYSNUMERICAFCall UPDATE_BINS(11, "EPIDEMIOLOGICAL_LINK", "TOTAL_CASES", "NUMERIC") EPIDEMIOLOGICAL_LINK OUTBREAKS TOTAL_CASESdAGROWTH_POTENTIALUSER_BIN NARRATIVEA SUSCEPTIBLE_POPULATIONUSER_BIN NARRATIVEAAo@x]8]X]x$ !|!~.h  h%8.j jC@C@5<b NUMERIC $j $'  NARRATIVEe $j $'kX jB@  j"(P jB@C@q.j.h|$ 0!2A@.o]p]]$ !|!~.h  h%8.j jC@C@5<b $j!P  'd0 $j $'k jB@  j"(P jB@C@q.j.h|$ 0!2A@.o]h]]]$`5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4'5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4'p5SELECT BIN_LOW_USER FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4'n   1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4'    pe1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4'  p  ne1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4'  n e1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4'd'kz$ 0!2A@.i] ]( ]0K_[H $UPDATE SHELF_LIFE_GROWTH_POTENTIAL_COMBINED C, GROWTH_POTENTIAL G SET C.SUM_SL_GP_RANK = G.USER_BIN_RANK WHERE G.COMMODITY_CATEGORY_ID = C.COMMODITY_CATEGORY_ID AND G.PATHOGEN_CATEGORY_ID = C.PATHOGEN_CATEGORY_ID'  ~B@UPDATE SHELF_LIFE_GROWTH_POTENTIAL_COMBINED C, SHELF_LIFE S SET C.SUM_SL_GP_RANK = C.SUM_SL_GP_RANK + S.USER_BIN_RANK WHERE S.COMMODITY_CATEGORY_ID = C.COMMODITY_CATEGORY_ID'  ~B@ !|!~.h$SHELF_LIFE_GROWTH_POTENTIAL_COMBINED h%8.j jC@C@5<b j"!P ' j"!P j"!P e' j"!P j"!P e' j"!Pe'd'k jB@  j"(P jB@C@q.j.h|p$h 0!2A@.oP` ] ] ]0 ]H ]` $,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4'v,SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4',SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4',SELECT BIN FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4'l  vRT1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=4' $4' RT1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=3' $4' RT1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=2' $4' lRT1SELECT BIN_RANK FROM BINS WHERE DATA_CATEGORY_ID=  AND BIN_NUMBER=1' $4'S'nz$ 0!2A@.ipx ] $XPUPDATE BINS SET BIN_LOW_USER = BIN_LOW_DEFAULT, BIN_HIGH_USER = BIN_HIGH_DEFAULT'  ~B@2UPDATE GROWTH_POTENTIAL SET USER_BIN = DEFAULT_BIN'  ~B@8UPDATE SUSCEPTIBLE_POPULATION SET USER_BIN = DEFAULT_BIN'  ~B@(UPDATE CONSUMPTION SET USER_BIN_RANK = 0'  ~B@*UPDATE CONTAMINATION SET USER_BIN_RANK = 0'  ~B@"UPDATE DEATH SET USER_BIN_RANK = 0'  ~B@8UPDATE EPIDEMIOLOGICAL_MULTIPLIERS SET USER_BIN_RANK = 0'  ~B@1UPDATE EPIDEMIOLOGICAL_LINK SET USER_BIN_RANK = 0'  ~B@,UPDATE HOSPITALIZATION SET USER_BIN_RANK = 0'  ~B@,UPDATE INFECTIOUS_DOSE SET USER_BIN_RANK = 0'  ~B@Tsqlstr = "UPDATE PRODUCTION SET USER_BIN_RANK = 0" 'Removed Production from rankingCurrentDb.Execute sqlstr'UPDATE SHELF_LIFE SET USER_BIN_RANK = 0'  ~B@AUPDATE SHELF_LIFE_GROWTH_POTENTIAL_COMBINED SET USER_BIN_RANK = 0'  ~B@BUPDATE SHELF_LIFE_GROWTH_POTENTIAL_COMBINED SET SUM_SL_GP_RANK = 0'  ~B@ainstead of populating pair combinations each time, use predetermined pathogen-commodity pair list) sqlstr = "DELETE * FROM RANK_RESULTS" CurrentDb.Execute sqlstr| $ 0!2A@.o  $ - !(Bin4 !(Bin3 !(Bin2 !(Bin1 !( !(P !(P !(P !(P !(P !(P !N(P !R(P !T(P !V(P !X(P !Z(P !\(P !^(P>Me.txt_production.Value = "" 'Removed Production from ranking !`(P|($  0!2A@.o ]p $ !P (P UPDATE BINS SET BIN_HIGH_USER = !P- WHERE BIN_NUMBER = 1 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. 1K_[WHERE BIN_NUMBER = 2 AND DATA_CATEGORY_ID =  !P'  ~B@|$ 0!2A@.o ] $ !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 1 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 2 AND DATA_CATEGORY_ID =  !P'  ~B@|$ 0!2A@.oh ]` $P !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 2 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 3 AND DATA_CATEGORY_ID =  !P'  ~B@|8$0 0!2A@.ox ] $ !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 2 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 3 AND DATA_CATEGORY_ID =  !P'  ~B@|$ 0!2A@.o ]P $ !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 3 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 4 AND DATA_CATEGORY_ID =  !P'  ~B@|$ 0!2A@.oxh ] $` !P (P UPDATE BINS SET BIN_HIGH_USER = !P. WHERE BIN_NUMBER = 3 AND DATA_CATEGORY_ID =  !P'  ~B@UPDATE BINS SET BIN_LOW_USER = !P. WHERE BIN_NUMBER = 4 AND DATA_CATEGORY_ID =  !P'  ~B@|H$@ 0!2A@.o( ]`$ +UPDATE DATA_CATEGORY_LUT SET USER_WEIGHT =  WHERE DATA_CATEGORY_ID =  '  ~B@k?|?$x? 0!2A@.o`?x N!PAo8? R!PAo?8 T!PAo> Z!PA Z!PAo> \!PAo>X ^!PAoX> X!PAo0> V!PAo>x `!PAo=Removed Production from ranking2Private Sub txt_production_Exit(Cancel As Integer)/ Call update_weight(8, txt_production.Value)End Sub0=Attribute VB_Name = "Form_fMain" Bas0{07AB005A-3AA3-44B9-97A4-3CE1D62B47A2} |@GlobalSpacFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT P&* Sub cmd_resetBins_Click() Call RESET_BINSA lst_d(_Bc#gory 0 End*2un/Dim error_msg As Sng<On E GoTo_handler C'check thate b0 va lues ApNӮgNothԪAk6ox P7!n(CancelvI0ger]uo¶FORM3S'sel` f[ items@~v13bgbSsq@^"tUPqEyt` Qx_WEwT=0.ExecA2!Su??OP o ׁd 's S~CU rIs1, 3, 4, 6, 7,` 8, 94e_labels (ow2, v1_bN?.Value) PCase` Elsep`Call RESE@T_FORM`End Select Exit Sub err_handler: MsgBox Err.Description^. P@rivate= popul _labels(data_cat_id As IntegerDim sqlstrStringOnwor GoXTo $'If DATA_CAT_ID = 3 Then 'DEATH txt_Bin1bcimalPlPaces1 2_lowhigJh3!%3_%bin45z808 %L 8 8IfɅsVisibleqTruļL40.3y5153C'IJ= "SELECT BIN_DESC FROMFEGORY_LUT WHEREID=" & Me.lbl_Ca.@val(C@CSv& " ANDNUMBER=4"jk4`u!d#3330$22k11_LOW_USERILYq7Isb"t[axTNtqP2#?HIGHE R=" 1q p{F'SA /7/`n/ /te$_multi1φφφ 3"φDS bFalgkgg !g@gÓ.s gnȨINCTUgoppr0 pINpQz?3?3R=ggz ů  R=gg  A   gg  Rg!:gNg009O O O q1 (vFR_[_[ing*Hg gԺoetu'gU@gggRANK(`ERtart_ta0u@_countLro hhfBithe with the most pathogen category - commodityPpairs (eirntamination, epi mead multi plier(demiological_link, or growth potential) 'sqlstr = "selectaunt(*) Pfrom o"/tart_tablpe_co*:Cvxal(JT$Yco";EPIDEMIOLOGIPCAL_os I$f : >irIThen1 sW Y@End If1{_/>@ /Q -'popul@rank_res@s w w=oeA[ Finsert intTo (E_E_8id,) WdistinC(" & H v @)&tЀ/Di4ngF>-A l based on Js, goKre-deter@ LJupd!.* setC"total=0!CCurr tDb.Execute Ccyclea6rougqsy!USER_BIN_RANK * WEIGHT a Vadd!0a_TOTAL$ f co spon*0G". Call  PROCESS_TABLE("CONTAMINATION", txts.Value, "BO8TH"V mqLI|NK$ a e MULTIPLIEp2M8";Noth_ A?6?`QoToToTQiTASSIGNS(@ACS1{"`_#bPERCwb"NUMERInC{q2"AVG_PREVALENCE_қLUM` ASEDc  BSTUDI Eq3INS(3P"?  4ɵOLOGICAL_MULTIPLIERS", "p4NUMERIC") Call UPDATE_BINS(6^HOSPITALIZATIONh $_PERCXENT M7MINFECGUS_DOSE2 __ORGANISVM'T8TP0RODUUAVG_TO_2 _METt N* 'Removed Production from rankin g9:SHELF_LIFb:_DAY] ^11$EPIDEMILINKbCASE %_COLUMN_BD-OUT`BREAK1005*GROWTH_POT{IAL)USERCNARRV&Ej10SUSCEPTIBLEPUL`DETERMINE_SLGPEnd SubPrivatedata_cat_id As Integer, tablenaDmeAStrz, bin_columnIcriteriaI @Dim dbDAO.D@base rstRecordsetGA%COn Error GoTo err_handle"r SetA = Access.A0ppli@;X.CurrentD#A=.OptenF(f!# Wpith A.bM@eLasFFiDo While .EOF = Fale"If )= "{ Then' !#\= ?3K_[@((#6), h=$EFUN[?3SIf.E di' !user_.Value&Up`$L#a"2NexD Loo>$i>(6W o7o7o7"o7Po7o7o7o7Salo7o7o7PoFun/!By`EQvE48r)~.34_lowDoutS3 2sqlstr=Spp d(SEL _LOWER FROMS WHERE A_C0GORY_ID=" &ic" A NDRfBER=l4"=Ap(ϳ4(CIN& 3q+T!=2#D(>$CRANKA 2=a}: N  tH <=W AG "***=!5 3< # 0 888& Ctrz9 / ((DD=12/ / PQ$ /(0i End If Exit Function err_handler: MsgBox Err.Descripf Private Sub DETERMINE_SLGP_BIN()Dim db As DAO.DatabaserstRecordsetbin_rank"IntegLerOnor GoTo  $sqlstr = "UPDATE SHELF_LIFE_GROWTH_POTENTIAL_COM^ED C,   G SET C.SUMs_tRANK,G.U(SER{_WH@ERE G.&MODITY_C= A52 K`5 |7{3ug\ 4A+A({kH.0#魡).EdihA+user_= g qUpd`gKNexD LoopaQKg\Noth8ingA= h `'NARRA0TIVEb`a_FvWStr`,F t_id)wnAɠ#4c 321Ŧ!  =`̀SELECT FROMS €Ai=" &a & " A_NUMBER=4= (( *C "?TE$i33pIN?AT?Ӊ ?=22č6_yX:110Select C`=pu$QIsP!w IN$O O K $1:  Wq1 o0qO(O(E( F Vj pL++ l5Qz} G/ W Q st532 q٩RE@iS!˱d:`ra _` A DDLOW_@*DEFAULT,Qb_HIGH G߾#O@eup$?oO USCEPTIBLEpPULONb?̢; CONR= 0 sTA@? ADEpzooohEPIDEMIOLOGICMUϴLTIPLIERS SET USER_BIN_RANK = 0" CurrentDb.Execute sqlstrt "h"UPDATE EPIDEMIOLOGICAL_ LINHOSPITALIZATIONOINFEC-US_DOS E>0'PRODU1^ 'Removed Production from ranking'ӠSHELF@gF66_GROWTH_POTENT"ICOMEDl¢HfSUM_ SL_GP-'instead of populat@a pair @combinons each time, use predet erminspathogen- @modityClist 'AGTDELE@* FROM _RESULTS ]Exit Sub err_handler: MsgBox Err.DescripK End Priva ~ ET_FORM() #OOnor Go8To Me.lbl_Ca v.6-@$Bin4.3,3.2,2.1,B1'txt_84.Valuek`3_high(low22_1 c`Oum,s@taPUde@Tmulti plier5linkuslgpuhospital!infeus.'`Ha7pH&Ub${on ciib `I1_s(Cancel As Integer lcDimDaStrbo  Je S\Z#_HIGH_3a1 &6 T& " WHERE NUMBER@1 AND A_CGORY_ ID$Є_data_c`Fgory9 M  䇰 LOW nO @ 2_ _ _ _ U #XXWX9###0 #/$a"C` /$t_a0s0%/$ ?$?$?$g/ IN?$! _ /?$_ _ _ /}/}/} } l$$$ $ 43 n%HOI%:vO>O>IstIueS.o%S S o%p=`ST_ S 3III`_ U IIIIГ(s>>> u rnn (LJ!NUMBER = 3 AND DATA_CATEGORY_ID" & lst_data_category.Value CurrentDb.Execute sq`r Exit Sub err_handler: MsgBox Err.Description /nd.Privk txt_Bin3_high_R(Cancel As Iner)Dim}String Onsor GoTo g9bin4t BO yUPE BINS SET_HIGH_US= &@" WHER_[̇s-LOW-E6&2Q,4 E嘒4rrdFQÏB{{H_HHE$ Iupe_$we t(J_id, cb DIf <> "" The@1a.zkLUT’_WETG(H A7rIf!‹0consum{z Call 61,?BHCt`52tapmina!l2feat|503 d t_pslgp/ vO(5C6 9wZhospital/ / 96s4K_[infec us7link=1$+OOmultiplier4C popul1n_$x(10'C'Removed Produn from rankҞ'p_Uv'+]8T &V '6BME (TE'4k B@BMPTz$ 0!2A@.ixرAttribute VB_Name = "mod_utility" Option Compare Database Public FuncFSIDEBAR(sqlstr As Sng) Dim dbMain,trecNew Recordset2qry1!mandxOn Error GoTo err_"hlerSetj= CurrentProject.Conn)x.Open X,, ad Static  kQCouFnRCloEHxit L: Msguz~)}-$`@??=;862.)${tmifedc_]YVRPMKJJKOT[cks|   %). 1 57:;=?@@3ޫ-$x~ukcZRJC<60,(&$$#! ypha[V#S,N4L<IDHMFVF_FhFqFyGHJLNQUWZ^behkorv{B-$m|sg\OD8-5ZLVALjrGDR x+ x`| ?+ x+ + +    + + + + + + + +   d CDATA_CATEGORY_LUT.DATA_CATEGORY_ID!DATA_CATEGORY_LUT=DATA_CATEGORY_LUT.DATA_CATEGORYx+ p+ + (+  0+ dm@0+ X+ + 0a + 0a%DATA_CATEGORY_LUT8+ + +  + 0+ Pu@E~sq_cfrm_Main~sq_clst_data_categoryX+  + +  + + + + + 0a_C I+ 0a(A_LDATA_CATEGORY_LUT + p+  + x+ + +  +  +  +  0+ 8+ @+ H+ P+ X+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + x+ +  +  #4+ +  #4+ +  + z h +  +  + cX+ H +  + + H +  d + 0P + X + H +  +  + !DATA_CATEGORY_LUT +  + 8+ X+ PrimaryKey;DATA_TYPE_LUTDATA_CATEGORY_LUTDATA_TYPE_IDDATA_CATEGORY_ID+ + v + x+ 0 +  + +q + + + + + + + + + + + + + + + + + + + + + + + + + + + + +  + + + ) + DATA_CATEGORY_LUT#4+ +  #4+ + #4+ + + + + H+ + X+ |+ + + + + *)NUMERIC_CRITERIA_FLAG + + x+ + h+ + + +  d+ + d@ #4+ +  #4+ + + +  + X+  + h+  +  W0 z # ;  .SLGP_COMM_CAT_FK*&-POP_PATH_CAT_FK($,PATHOGEN_TYPE_LUTPATHOGEN_CATEGORY_LUTVR+PATHOGEN_CATEGORY_LUTSHELF_LIFE_GROWTH_POTENTIAL_COMBINED|x*PATHOGEN_CATEGORY_LUTRANK_RESULTSLH)PATHOGEN_CATEGORY_LUTPATHOGEN_LUTLH(PATHOGEN_CATEGORY_LUTGROWTH_POTENTIALTP'PATHOGEN_CATEGORY_LUTEPIDEMIOLOGICAL_LINK\X&PATHOGEN_CATEGORY_LUTEPI_MEAD_MULTIPLIERS\X%PATHOGEN_CATEGORY_LUTCONTAMINATIONNJ$HOSPITAL_PATH_CAT_FK2.#DOSE_PATH_CAT_FK*&"DEATH_PATH_CAT_FK,( LVAL MR2ANSI Query Mode(Themed Form ControlsAccessVersion BuildProjVerAppTitleStartUpForm&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRptNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By    08.50  W* "Risk Ranking Tool            " Form.frm_Main  w   MR2ANSI Query Mode(Themed Form ControlsAccessVersion BuildProjVerAppTitleStartUpForm&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRptNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By    08.50  W* "Risk Ranking Tool            " Form.frm_Main  w   MR28GUIDNameMapDescription |X֠F>d \ Uu~XCSa @Pu@ 6Risk Ranking Tool Main Form Dh=dA W 2  z ]  ` ) S  w 8  R b+W-wJ;F!DATA_TYPE_LUTDATA_CATEGORY_LUTFB DATA_CATEGORY_LUTBINS40COMMODITY_LUTSHELF_LIFE_RAW@<COMMODITY_LUTCONSUMPTION_RAWB>COMMODITY_CATEGORY_LUTSHELF_LIFE_RAWRNCOMMODITY_CATEGORY_LUTSHELF_LIFEJFCOMMODITY_CATEGORY_LUTRANK_RESULTSNJCOMMODITY_CATEGORY_LUTGROWTH_POTENTIALVRCOMMODITY_CATEGORY_LUTEPIDEMIOLOGICAL_LINK^ZCOMMODITY_CATEGORY_LUTEPI_MEAD_MULTIPLIERS^ZCOMMODITY_CATEGORY_LUTCONTAMINATIONPLCOMMODITY_CATEGORY_LUTCONSUMPTION_RAWTPCOMMODITY_CATEGORY_LUTCONSUMPTIONLHCOMMODITY_CATEGORY_LUTCOMMODITY_LUTPLSUSCEPTIBLE_POPULATION62SHELF_LIFE_RAW&"SHELF_LIFE_GROWTH_POTENTIAL_COMBINEDRNSHELF_LIFERANK_RESULTS"QRY_SUBREPORT_INPUT0,QRY_RISK_RANKING_REPORT84PATHOGEN_TYPE_LUT,(PATHOGEN_LUT"PATHOGEN_CATEGORY_LUT40MSysNavPaneObjectIDs2.MSysNavPaneGroupToObjects<8MSysNavPaneGroups,(MSysNavPaneGroupCategories>:MSysAccessXML$ _MSysAccessObjects,(MAKE_TABLE_SHELF_LIFE40MAKE_TABLE_CONSUMPTION62ZINFECTIOUS_DOSE($UHOSPITALIZATION($OGROWTH_POTENTIAL*&IEPIDEMIOLOGICAL_MULTIPLIERS@<CEPIDEMIOLOGICAL_LINK2.>DEATH9DATA_TYPE_LUT$ 3DATA_CATEGORY_LUT,(,CONTAMINATION$ (CONSUMPTION_RAW($$CONSUMPTION COMMODITY_LUT$ COMMODITY_CATEGORY_LUT62BINSAdmin  SUBREPORT_INPUT($ RISK_RANKING_REPORT0, mod_utility  frm_MainUserDefined SummaryInfo AccessLayout "SysRelScriptsReportsModulesFormsDataAccessPages($MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTables W0 z # ;  .SLGP_COMM_CAT_FK*&-POP_PATH_CAT_FK($,PATHOGEN_TYPE_LUTPATHOGEN_CATEGORY_LUTVR+PATHOGEN_CATEGORY_LUTSHELF_LIFE_GROWTH_POTENTIAL_COMBINED|x*PATHOGEN_CATEGORY_LUTRANK_RESULTSLH)PATHOGEN_CATEGORY_LUTPATHOGEN_LUTLH(PATHOGEN_CATEGORY_LUTGROWTH_POTENTIALTP'PATHOGEN_CATEGORY_LUTEPIDEMIOLOGICAL_LINK\X&PATHOGEN_CATEGORY_LUTEPI_MEAD_MULTIPLIERS\X%PATHOGEN_CATEGORY_LUTCONTAMINATIONNJ$HOSPITAL_PATH_CAT_FK2.#DOSE_PATH_CAT_FK*&"DEATH_PATH_CAT_FK,(K_[#  "'*-/0/*%! '2=GQ[dmt{    M-$AW`}||~",4=DJPV[_begijklprux{~!(.37:?BCEGL{QtToVkWgWbW`W`-$j !'+048;?CDFJKOSW[`dioty~}wpi_~WzNxEt<s3q*q!opqstvy~$^ttttvwy{|vpje`\YUSQPNNN NMM(M/N7N<NANCODLEGFBF>G:F5E0B+>'8#0& }"t%k)d.\5V<PDLLFSBZ>a;f7k5o3t3x1{1~2469<AEJOTX\`dgjmpstt-$@n"n pqrst ttttsrpnjhdb_[XUPLHD?:50)&#! !#&($+,.41;5A7E;G?GDGHDMBR>W;[6`2d.g*i&l$m"n"n"-$Td1c1a/].Z,T)N&H"B<60+'$!!!#&*.39@FMT[biov{$),/0110/.,*) )'''#)(*-.21789=<C=I>O=V=\<b;i9n7s5x3|2100z+-$^OqLpGnBk>i:f5c0^,Y(T%N"G ?7 .!$!"#$ %')+-048= BIPV[$b+g1l8q>wE{KQV\_cfhhikoqtw{~    +-$q  (0"7$?%E'K)Q*V,[-a.d.h-k+o*q'u#wzzz wtojd^VPHB:50,& }yvtrpozoqqgs_uWyP|JFA?<;:;<?BGLRX_dkqx~-$o3h2h0k-m+o(p%s tvwyyyxwtrnjea\YTPLJDCIHFB?94.)$"(.5=DLSZbgnsx{~    !%(#+*-0071>2E2K3R3W3]3a3d3f3h3h-$^{X|X~Z\adjpv| %)-023332/,|'w"rokh eca^[YWTRPMJFC?<952+%#!{vsnieb^[YW$U*U0V5X;Z?]DaHeKiNlPpRtTyW{X{Xǔ-6K_[$['S'R'P'N)K)F+A-<07307*:#@EK RZbiqx}si_TI@6-$ %+059=AFJLM'S'S¨R-$B "&*-///.-+(w%o#g^VNG ?:40+'"     #+3<DLT\ciotx{}zE-$^ *7BNZe~o{y{zzzz{|}}~}{xuqlf`YSLG@:4z0l+_(Q%D$7#)$%(+/4;BKT_iry$}yus}qyovnsmskshses`r[qUpPoJlDi>e9a4[0U-M+E):)0(%*+. 158=BGMSX_dimquy} %/8@IQY_flrw|"(-1368:::9852-)$ z+-d$0WX[_elt}  |wsokgd`^\ZXWW$\igd`[TME=4+# $1<GPZag l q uwxzyx wvvutsqpnmkjfa[SI?3(}xtqnmll l,l8nAoJqPsVv[y_}dghiiYn-$>cb_[VSPKGB>83-'!ztmg b ]XSNJD ?:5/!*'%-"38=BFKNQ#S&U,V1W:W@XHYN[T]Y__addifliojqmtpwqxcc$P$#"  ypiaZTPMKIJJKNRUZ`how   $(+.24678775531/.,*('$$$@-$M ysmf_YTOK~HxGoEjEdE`F[HYJVLVPTRTWTZV_VdYi[o_uazdgjloqtuwy{}~}}{{yxvvuuuwx{~    ~$=IPIQKTLYO_QfSpVyXYZYXUQLD<4-(" ~ z u pjd_ Y T OKGCA#?(?-?1@5A9C?GDKGOIPIP$]bbbcefilpu{"(-1332/,|(v#pkgb ^ZXUTSRRPOMKJHFFEFFILP~UxYq]laee`i[mVpQtNwJ{HFDCCCDFGILORUWZ]`bb-$t !)19@GMSX]bglrw}7K_[{xtpli|et`j]bYYVQSIQBP:O4M,L&K KIII IHHHIIKLOPRSUWZ]adgjnqtvxz}~-$j_]\ZXTPLID@<85300.$///:0E2O3Y5b8l:s<z>@ACDDsstuvvvtsqnje_YQIB<50)% #&(|*x+t-p.m0k2h7h:i=mBpHvM{QUXZ\]______$$;G<G?IEMLRUW`^lezmt{!2BP_ly"$(+038<ADHLPQQPNKGB=83.*&#!! qcWJ<- 0.*(%"~zupkgb^ Y U P LGB<71 - ' # !#&'!(%)(+,,/-3.70:2>5A7D;G;Gs-$vMwNzQV^fpz  *2:@GLQUZ_dioty{}skc\TLF?93-($~xqjd]VNIB=#:(6-3217/=.C,I+N)U)Z&_$d!ilpsvwxyzyyxxvtrqnligc`\YURNLHFBA?=~=w=q=i=b>\@WARCOEKGJJENCPBRBSBWC\DbFiHoJsKvMvM$SL.  yof]UNIEBABCEINSX_elsz (07>CJNS W[^ad$f)g.f2d7a:]=Y@SCNEHGBH<J8K4K0L.L.L.z-$X:863.(" {xvtssssuxz} "%(*+149=CHMRX\aeijjigd`[VQLGC?<:::-$K}JKNPSVZ]aeilquy}{s~i{axYrRlJfD_>W:O7G5?373/2(3 457 9:<=?@ABCDEGILQSVZ]adgknpsux{|}}-$jeddcb`^ZVPJB8."|uoha[UOJEA>:97779<?CHOTZaipw~ ' (-/48=AFJOSX[_ adeffggggfee$X  | r f \RJA;5%2+/1,8*?(F&L$S$Z$_$e&j(o+r/u4v:xBwIvPuWu]scqhommsjwg|db^[WTPMKKIIIJJJJJIHFDA=:82,&#!  $l??>=<:987531/-|,q+g*^)T)L)E+?,:.5013-5)8$:=?ABDDCA=848K_[.)#      #)/7?GOXajt}  !( - 258;<=>????z$;mSnUp[tdzq !(+---}*v'p#kd_ZW S QONNLKIGFDBAAAACuEkIcL[PVSQWN]KbKfLjOlRmSmS-$Jdccbbbcdfhlpu{~zwtpmihddd$H6r4r0q-p+p'p$rrtwz~  #'*-.011//./036:<?BFGIIIHGEC>{:v7s6r6r$>7D5C1C+D%F!HLOU[dmx !"#%(, 0 6<BGMRWZ^` aa`^]ZXVTQNLKIzGvGsGr7D7D-h$2  %,4:AHOUZ^acfhk n qtwyz!{%|(|+{-y/v/q0l0f0a/Z.T.N.H-B,<+7*3)/),)*@-$`YY[~^}b{fymxrvzsqnljhfdbaabbdefggg gdb^Z"S"N"H B=72. )%!!%)-z2q5h9_<W>Q?KAGACB?E;I8L4Q2V/\-b+g)m's&x%~%%&(*-049=BFJNRWYY$R5757391</A+F(L$S![clu    "'* - /1333431/-)%  }skc]WR LHDA >%<):-90837475757-|$<#"!  |yvtpo noptw {"~##)!-$Jww yy{|}~~~~}{ywsojgb^YUQLIF@=<==?#@3CDEUIfJvNOSTVWX V VWY]`fi l ptxz|~Pyww 3-$Cooqtz|{xvuttsstttvwyy{|~~wrnjfc_]YWUUUVWXYYooE-x$:zy y"x%x+x1w8w?xIxQx[yd|n~w:83/,($ }}zz+-l$4v}vpkfcaabcddeddddcdgkoruvv@-$CFuFuDwBzA=;8630.-+++,-/023579=ABD9K_[FIJLMOPQSTUUUVVVVVVX[_adeeeedc}bz`x^t[rWpVpFuFu 3-^$-YWSNHEB@?== =?@DI#N(T-Z2`7h:n=u@{BBBA>950+&! YYn$5X:Z<[?_DbIfOjVn]peslvtx}xxvtojea\WRNIF|Bv?p<j:g9e9d8b6]5Y3V2S2O0J0G/C/@0:3877=7B7I8N8S8V9X:X:-$s"2D'Y2p;CINQTTT(T;SLP\NjKwIFCA?<9640-*&#   | m ]M<,   |voida\XSPKGC?;73/+($"{vt sttwy|Ԋ!-$^rrtuwy|~(:L]|nw}qi_UMF?93/*&"#(y-s1n5j:f>cAaBaC`C]CXBSBLAEA=A5A+@#??? ????><:95410.--/05;CKRX^aehkmpprr0-f$1OPRVZ_djpw}}|{{{{|}yOOz-$Q "(08BNZfs }wqlfa\YUSRRPNJE>7/(    @-$ryyz|$/;GS_lx  }{zzzzzz{zzyywvutr{qupqollgibe\bV]PYITCP<L5H.D(B!?>>? @ACDDFGILRTX\aeilosvxyyԊ!-z$;$)/38<@DGILNPRSRPLGC?;71,&  x-$\xwvutqpljfa\WPIB: 1)! !%&(*,./06:>CHMRW\af imo+p5o?mIiRe[_dZlRsJ{A9/%yxx$n '/5=DLT\c|ktqlxe}_ZWTSQKGC?;62.,)))+-16=ENXcnz|wrlfa[UOIB;4/( !   )!-$r"',4;DLV_iqyxpf]SI>4)  ti\OB5) :K_[ ")28<?BBCBBAAACEIOW_ekoruxz{}~ E-$HpMrNxR{TW[`djpx{vqmhd`|]xXrWqUoOkKiGfCc?a<]8Z7W5T5Q6O8M=MAKFKKJPJSJXJ[J`KcKfKiKlLoMpMpMԀ-n$5{{   !"!!   zvrojgee{{i-$C**,/26:?DHKOQRRvQlObJ\FYAX=Y9\4a0f-l(r%x!~    !$%'()*** -$>optvy}~{toifeeeeddb`^\ZXURMJFCABDJOU[afkmooR->$abefhjmnpqrrrrqnkifa[UQNMM>aa-$T>(?'B&D%G%J$N$Q#V"Z!`!e!k!q!x!}!!!!"#$&&(*+/59<?CDFFGFCA@?><::{:v:q:n;j>g?cA`D]HVNPULWIYEZB\=\:\6[2Y-U)T&R$PNMKJ#G)D/?3;76:2<-=*=(>(>(3-$B".8?EG IIHEA=83.)$  -$VPPONLKI GFD#B+@3?<=D=L<T=[=b?iAqByDFHKLMMNMLJHDA><97542100...}.|.y.v.q.j.d.\.U.M.E.>.7.0.+.'.$.---- --.01368:<?BFKLPP:$oooH$".-+(#  A..@-$@BCFHJLNNOMLHD?7.$}tkb[TPLLLNQV[agnszBBz$;V^U]R]N[IZBX<V5S0Q)N$K!HEB!?%<-:66A6M6Z8g9u<?CFJNQTVXYZ\`cglquzz+-l$4qrt w}$/<IWfv-WRqq-$N#!{wsnhb [UNF?7.$ (/6=BHMSX]bglpty} !#;K_[#f-$@>><: 9 775N3i212259>DNW_flqvz~vdP=* {sld_YTNJFC?>>@-P$&}{z xw!w+v4v>vFvPvXv`vgwowtwzwxxxxyguuw-$X$$#! &-5>HP Z ckry~  #%')+,.0223|3u4o4h5b5[5U5O5I5C5?5:5754625-4)1%.!*'%$$J0234000.WMF@@TH(h0A0C911005A};VBE;&H00000000 [Workspace] Form_frm_Main=22, 22, 1058, 802, Z mod_utility=44, 44, 1080, 824, Form_frm_MainForm_frm_Mainmod_utilitymod_utilityͬ4Z:D<+GDetail{ TabCtl0d Label15nlst_data_categoryd lbl_Bin3d lbl_Bin4mtxt_Bin1d %lbl_Captiond lbl_consumptionmtxt_consumptiond lbl_contaminationmtxt_contaminationd lbl_deathmtxt_deathd lbl_multipliermtxt_multiplierd lbl_hospitalmtxt_hospitald lbl_infectiousmtxt_infectiousd "lbl_populationsd &Label40d 'Label41m txt_Bin2_lowmtxt_Bin3_lowd (Label42d )Label43m+txt_Bin3_highm*txt_Bi<