Standard Jet DBnb` Ugr@?~1y0̝cßFNa7ޜV(,`{6e߱nC_53y[/|*|=@ulf_Љ$g'DeFx -bT4.0 YcS cc Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeniYYIdParentIdName        OY+  SbY Y Y  Y 2ACMFInheritableObjectIdSIDF dYObjectId YSY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -Y4S4Y Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipEy4 e Q = / D Ct/` A B@ BBAB"DH!D" I)d4 *D$)Ef$#ReD" @*%J KR_%TU)$cbeLTJ)$ST$R`0@ @ `@@e@X Z@BEaV#ZR`IaUYuCVIZܕZZjRUeQV#UZBgRRdK5mUYPR"*(*)@*JER TH=ewOfTERZ"**)ĪJUR*UJdʒ&w~@  @ @@@hivJkiQhoQkmS^dskJ^^R}hivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkoffdimc~hivSobQfkMoiiQbmJiMWbdmYbiQUYdbSJkdb^vhiv`fQ^Q`QbmkkQ^QMmYbqJ^YOhiviQUYdbJ^JiMWkmJ\QWd^OQikhiviQfdimMd`fYbqkmJmokqJ^oQSid`YbkmJbMQhiviQfdimfid[QMmJiMWJ^^S^dsk!hiviiiQf^YMJmQiiJffQbO1!@hivkmOmQ`fkmJbOJiOQbmYmvJffQbOiQUYdbG vmL^fid[QMmJiMWYmQMmoiQ + HF<:8>D<<@SHH6<:MDSM:MBD:Q:S+ +;K[ fS^dskiQUYdbQbo`QiJmQhivJfS^dskiQUYdbSdihivJfS^dskiQUYdbYOkhivJfS^dskiQUYdbYOkQ^QMmhivJfS^dskiQUYdbiQqhivJfS^dskiQUYdbkWdsJ^^hivJfS^dskiQUYdbkWdsJ^^MdobmhivJfS^dskiQUYdbkWdsJ^^Qbo`QiJmQ hivJfS^dskiQUYdbkWdsJ^^YOkQ^QMm!hivJfYbmQiMdbbQMmk"hivJfYbmQiMdbbQMmkLJkYM#hivJfYbmQiMdbbQMmkLJkYM`Yb$hivJfYbmQiMdbbQMmkMdobm%hivJfYbmQiMdbbQMmkQbo`QiJmQ&hivJfYbmQiMdbbQMmkSY^mQiQO'hivJfYbmQiMdbbQMmkkWdsJ^^(hivJfYbmQiMdbbQMmkkWdsJ^^Mdobm)hivJfYbmQiMdbbQMmkkWdsJ^^Qbo`QiJmQRhivJfYbmQiMdbbQMmkkWdsJ^^SY^mQiQORhivJiMWJUiQQ`QbmkRhivJiMWQ^Q`QbmkRhivJiMWQ^Q`QbmkMdbbQMmQORhivJiMWQ^Q`QbmkiQUYdbdifid[QMmRhivJiMWS^dsmiYf^QmkRhivJiMW`Ji\QmfJM\JUQkRhivJiMW`Ji\QmfJM\JUQkfid[QMmRhivJiMW`Ji\QmfJM\JUQkiQUYdbR hivJiMW`fkQ^QMmQOQ^Q`QbmkR hivJiMWiiJiQJkR hivJiMWkmJ\QWd^OQikR hivJiMWkmJ\QWd^OQikMJ^Mo^JmQOR hivJiMWkmJ\QWd^OQikMJ^Mo^JmQOQufJbOQORhivJiMWkmJ\QWd^OQikMdbbQMmQORhivJiMWkmJ\QWd^OQikMdbbQMmQOsYmWUidof`Q`LQikRhivJkOQ^QmQS^dskfid[QMmRhivJkiQhoQkmS^dskJ^^RhivJkiQhoQkmS^dskQuM^oOQfid[QMmRhivJkiQhoQkmS^dskQuM^oOQiQUYdbRhivJkiQhoQkmS^dskYbM^oOQfid[QMmRhivJkiQhoQkmS^dskYbM^oOQiQUYdbRhivJkiQhoQkmS^dsk`YkkYbUJffQbORhivJkiQhoQkmS^dskbdmYbM^oOQOfid[QMmRhivJkiQhoQkmS^dskbdmYbM^oOQOiQUYdbRhivJkiQhoQkmS^dskkQmkmJmokfid[QMmRhivJkiQkfdbkQS^dskJ^^RhivJkiQkfdbkQS^dskQuM^oOQfid[QMmRhivJkiQkfdbkQS^dskQuM^oOQiQUYdbRhivJkiQkfdbkQS^dskYbM^oOQfid[QMmRhivJkiQkfdbkQS^dskYbM^oOQiQUYdbRhivJkiQkfdbkQS^dsk`YkkYbUJffQbOR hivJkiQkfdbkQS^dskbdmYbM^oOQOfid[QMmR!hivJkiQkfdbkQS^dskbdmYbM^oOQOiQUYdbchivJkiQkfdbkQS^dskkQmkmJmokfid[QMmchivLJmMWkQ^QMmYbmQiSJMQkchivLJmMWkQ^QMmYbmQiSJMQkLJkYMchivMoiiQbmJiMWQ^Q`QbmS^dskmJbOJiOkchivMoiiQbmJiMWQ^Q`QbmS^dskmJbOJiOkWQ^fQichivMoiiQbmJiMWQ^Q`QbmYbkmJbMQkbdmYbiQUYdbchivMoiiQbmJiMWQ^Q`QbmkbdmYbiQUYdbchivMoiiQbmJiMWQuM^oOQOQ^Q`QbmS^dskmJbOJiOkchivMoiiQbmJiMWQuM^oOQOS^dskmJbOJiOkc hivMoiiQbmJiMWQuM^oOQOkmJbOJiOUidofkc hivMoiiQbmJiMWQuM^oOQOkmJbOJiOkc hivMoiiQbmJiMWS^dskmJbOJiOkc hivMoiiQbmJiMWiiJiQJkbdmYbiQUYdbc hivMoiiQbmJiMWkmJ\QWd^OQikbdmYbiQUYdbchivMoiiQbmJiMWkmJbOJiOUidofkchivMoiiQbmJiMWkmJbOJiOkchivMokMoiiQbmfid[QMmQ^Q`QbmkchivMokkQ^QMmMoiiQbmfid[QMmS^dskchivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkchivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkobYhoQchivMokmQ`fJffQbOfid[QMmS^dskchivMokmQ`fJffQbOfid[QMmS^dskSY^mQichivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkchivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkSY^mQicJMMQkk^Jvdom`kvkOL            !"#$%&'() R!R"R#R$R%R&R'R(R)R *R +R ,R -R .R/R0R1R2R3R4R5R6R7R8R9R:R;R<R=R>R?R@R AR!BcCcDcEcFcGcHcIcJcKc Lc Mc Nc Oc PcQcRcScTcUcVcWcXcYcZc[c\c]c^c_c`calblcldlelflglhliljl kl ll ml nl olplqlrlsltlulvlwlxlylzl{l|l}l~llll l!l"l#                !"#$%&'()*+,- . / 0 1 23456789:;<=>?@ABCD E!F"G#H$I1J1K1L1M1N1O1P1Q1R1 S1 T1 U1 V1 W1X1Y1Z1[1\1]1^1_1`1a1b1c1d1e1f1g1h1i1 j1!k1"lJmJnJoJpJqJrJsJtJuJ vJ wJ xJ yJ zJ{J|J}J~JJJJJJJJJJJJJJJ J!GGGGGGGGGG G G G G GGGAlG|GGGGGGGGGGGGGGG G!G"G#G$aeG%  @J4DnE ,!w5"ED  $%&'() + , - . / 0 1 2 3 E F G H I J      !"#$%&'()*+,-./012345 6 7 8!9!:!;"<"=">#?#@#A$B$C$D%E%F%G&H&I&J'%'%'%(%(%(%)%)%)%*% *% *% +% +% +%,%,%,%-%-%-%.%.%.%/%/%/%0%0%0%1%1%1% 2%!2%"2%#3%$3%%3%&4%'4%(4%)5%*5%+5%,6%-6%.6%/7%07%17%28%38%48%59%69%79%8:%9:%::%;;%<;%=;%><%?<%@<%A=%B=%C=%D>%E>%F>%G?%H?%I?%J@4@4@4A4A4A4B4B4B4C4 C4 C4 D4 D4 D4E4E4E4F4F4F4G4G4G4H4H4H4I4I4I4J4J4J4 K4!K4"K4#L4$L4%L4&M4'M4(M4)N4*N4+N4,O4-O4.O4/P40P41P42Q43Q44Q45R46R47R48S49S4:S4;T4<T4=T4>U4?U4@U4AV4BV4CV4DW4EW4F*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNO      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJ      !"#$%&'()*<=>:;?@ABCD456A7A8A9  !"#y @ @ @ @ @ @ @I%NMO%TU2W)Y9\,^AhaGgpNstWv-xbj.g nx#}*?#('!4   & !% "  ( (# +, 1  6" #: %6&@)++G.0N45X61:]<'>fnI<KwN/RVW[\` a d eBCh#pr$sIIIII IIIIIIIIIIIIII I!II"I$I%I&I'I(I)I*I+I,I-I.I/I0I1I2 I3 I4 I5 I6I#I7I9I:I;I<I= I> I?I8KKKKKKKKK K K K K KKKKKKKKK KKKKKKKKKK K!K"K#K$K%K& K' K(KK)K+K,K-K.K*K/K1K2K3K4K5K6 K7 K8K0K9K;K<K=K>K? K@ KA KBK:KCKEKFKGKHKDMMMMMMK@@@@@@@@@@@@@ @ @@+ 6@SDMHMMQDD>FJ:>Q@LO6QD@BSMDL+ +;K[+ 8QMSLMOHDDJH>SO8J>LB8JJOMHBBB86L>QD6JJDLQLFQ@DQ>LLQM+ +;K[+ :FDJBLOL>@B8H:D:B68Q@:6J68@S>LMMJS8SSFJ>:FBF@SMOFH>JFDJ@@:D+ +;K[+ >@DMDLFSLFOF>MQSHMD6MLM8Q>Q8F@6O+ +;K[+ >@FDBHDD>F6@>MDQLSO6>>>6JH@JQ<:MBJBSMSSD+ +;K[+ FH<LLDO6HMHO>8L6O@SQ8M6L+ +;K[ + H8QQ>JOSBQMJ>OBSHLBLL>JS@SFL@DJ6+ +;K[ + H>LO:@M>D:DML8B8LOQJLS:DHD<<@SHH6<:MDSM:MBD:Q:S+ +;K[ + J8QFSHFH>OD6HFQBMO@HS86S+ +;K[+ LB:@8<>8O6SQ>DSLFO@:LBLLJDL8>8MH+ +;K[+ LFH@:DL8H>8JQF@<8ODMLLOD>BJ+ +;K[+ MF@6FJ88M@DQ>SBMFQ6DO@FOHFBQJ6MB+ +;K[+ O@QJJ8HD@8FQ>F@JHMJ>8+ +;K[+ QBD@:HLOFO>S>J8@FFD66DJDOSLOJ68<+ +;K[+ SM@MH@F>>8B>SMF@S>88JO:OOJLO@MJLQFQO+ +;K[+ SSBQDHD8B8:H>Q8@FO>BB6J:OFD@@B:O+ +;K[mL^JUiQQ`QbmkmL^JUiQQ`Qbmkfid[QMmkmL^JUiQQ`QbmkmL^JUiQQ`QbmkkmJ\QWd^OQikmL^Q^Q`QbmkmL^QfJiMWmL^Q^Q`QbmkmL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^Q^Q`QbmkmL^kQ^QMmQOYbmQiMdbbQMmk mL^Q^Q`QbmkmL^kQ^QMmQOYbmQiMdbbQMmk8 mL^QbmYmYQkmL^S^dsiQ^JmYdbkWYfk mL^QbmYmYQkmL^S^dsiQ^JmYdbkWYfk8 mL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^QfJiMWiQhoYiQ`Qbmk mL^QhoYf`QbmfJM\JUQkmL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^QhoYf`QbmfJM\JUQkmL^Qf`fkmL^QhoYf`QbmfJM\JUQkmL^Qffid[QMmkmL^QhoYf`QbmfJM\JUQkmL^QfiQhoYiQ`QbmkmL^`Ji\QmfJM\JUQkmL^Qf`fk mL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQQ^Q`Qbmk mL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQfid[QMmk mL^`Ji\QmfJM\JUQkmL^iQUYdbJ^kQiqYMQk mL^`Ji\QmfJM\JUQkmL^iiJiQJ`fk mL^fid[QMmYbSdi`JmYdbmL^JUiQQ`Qbmkfid[QMmk mL^fid[QMmYbSdi`JmYdbmL^Q^Q`QbmJiMW mL^fid[QMmYbSdi`JmYdbmL^QfJiMWiQhoYiQ`Qbmk mL^iiJiQJkmJ\QWd^OQikiikmL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQikiik mL^iiJiQJkmL^iiJiQJ`fk mL^iiJiQJkmL^iiJiQJkmJ\QWd^OQik mL^kmJ\QWd^OQikmL^JUiQQ`QbmkkmJ\QWd^OQik mL^kmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQik mL^kmJ\QWd^OQikmL^kmJ\QWd^OQiUidofk @@@ @  @@@@ mL^JUiQQ`Qbmkfid[QMmkmL^JUiQQ`Qbmkfid[QMmk mL^JUiQQ`QbmkkmJ\QWd^OQikmL^JUiQQ`QbmkkmJ\QWd^OQik mL^Q^Q`Qbm`JffYbU mL^Q^Q`Qbm`JffYbUmL^QfJiMWmL^QfJiMWmL^QfJiMWiQhoYiQ`Qbmk mL^QfJiMWiQhoYiQ`Qbmk mL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^Qf`fkmL^Qf`fk mL^QfiQhoYiQ`QbmkmL^SY^mQiQbmYmvM^JkkQkmL^SY^mQiQbmYmvmvfQkmL^SY^mQiS^dsSomoiYkmYMmL^SY^mQiS^dsmvfQk mL^S^dsiQ^JmYdbkWYfk mL^S^dsiQ^JmYdbkWYfk mL^YbmQiqYQsMQbmQikLvkQU`QbmmL^`Ji\QmfJM\JUQQ^Q`QbmkmL^`Ji\QmfJM\JUQQ^Q`Qbmk mL^`Ji\QmfJM\JUQfid[QMmkmL^`Ji\QmfJM\JUQfid[QMmk mL^dmWQiQbmYmYQkmL^dmWQiQbmYmYQk mL^fid[QMmJiMWYmQMmoiQ mL^fid[QMmJiMWYmQMmoiQmL^fid[QMmQ^Q`QbmkmL^fid[QMmQ^Q`Qbmk mL^iQUYdbJ^JiMWYmQMmoiQmL^iQUYdbJ^JiMWYmQMmoiQ mL^iQUYdbJ^JiMWYmQMmoiQmL^iQUYdbJ^kQiqYMQk mL^iiJiQJ`fk mL^iiJiQJ`fk mL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQikiik mL^kQ^QMmQOYbmQiMdbbQMmk mL^kQ^QMmQOYbmQiMdbbQMmk mL^kmJ\QWd^OQiLdobOYbmQiSJMQkmL^kmJ\QWd^OQiLdobOYbmQiSJMQkmL^kmJ\QWd^OQiUidofk mL^kmJ\QWd^OQiid^QkmL^kmJ\QWd^OQiid^QkmL^oOQbmYmvS^dskmL^oOQbmYmvS^dskmL^oOQbmYmvS^dsk @@@@@ @     @mL^JUiQQ`QbmkmL^JUiQQ`QbmkmL^Q^Q`QbmkmL^Q^Q`QbmkmL^Q^Q`Qbmk mL^Q^Q`Qbmk mL^Q^Q`QbmkmL^Q^Q`QbmkmL^Q^Q`QbmkmL^Q^Q`QbmkmL^Q^Q`Qbmk mL^Q^Q`Qbmk mL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQk mL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQk mL^QbmYmYQk mL^QfQ^Q`QbmkiQhoYiQ`Qbmk mL^QhoYf`QbmfJM\JUQkmL^QhoYf`QbmfJM\JUQkmL^QhoYf`QbmfJM\JUQkmL^QhoYf`QbmfJM\JUQkmL^S^dskmL^S^dskmL^S^dsk mL^S^dskmL^YbmQiqYQskQU`QbmkmL^`Ji\QmfJM\JUQk mL^`Ji\QmfJM\JUQk mL^`Ji\QmfJM\JUQk mL^`Ji\QmfJM\JUQk mL^`Ji\QmfJM\JUQk mL^fid[QMmYbSdi`JmYdbmL^fid[QMmYbSdi`JmYdbmL^fid[QMmYbSdi`JmYdb mL^fid[QMmYbSdi`JmYdb mL^fid[QMmYbSdi`JmYdb mL^iQUYdbJ^JiMWYmQMmoiQ mL^iiJiQJk mL^iiJiQJk mL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQikiik mL^kmJ\QWd^OQikmL^kmJ\QWd^OQik mL^kmJ\QWd^OQik mL^kmJ\QWd^OQik `*d _ Z g  ~K Q H DIND@G<E,CqYUA  ZR@ ZR@qryAPInterconnectsShowAllFa@Fa@qryAPInterconnectsShowAllCount'@|@ vjj^^^^^^^\ @ Ȥ6@F 8@qryAPInterconnectsFiltered% @\ @nbbVVVVVVVT @Ea@1Ea@qryAPInterconnectsEnumerate@ |@pddXXXXXXXV @FEa@FEa@qryAPInterconnectsCount'@ |@h\\PPPPPPPN @Ea@={8@qryAPInterconnectsBasicMin@|@nbbVVVVVVVT @ Da@Da@qryAPInterconnects@@^RRFFFFFFFD @]NDa@]NDa@qryAPFlowsRegionShowAllIDSelectY@@xll```````^ @:Da@:Da@qryAPFlowsRegionShowAllEnumerate@`@znnbbbbbbb` @Ca@Ca@qryAPFlowsRegionShowAllCount'@|@rffZZZZZZZX @ fBa@,T7-@qryAPFlowsRegionRev+@@`TTHHHHHHHF @C]Ba@fBa@qryAPFlowsRegionIDSelectY@ @j^^RRRRRRRP @ Ba@C]Ba@qryAPFlowsRegionIDs4@`@`TTHHHHHHHF @ ٢Aa@٢Aa@qryAPFlowsRegionEnumerate@`@l``TTTTTTTR @dAa@٢Aa@qryAPFlowsRegionCountY@|@dXXLLLLLLLJ @ &Aa@dAa@qryAPFlowsRegionBoth'@@bVVJJJJJJJH @ o@a@&Aa@qryAPFlowsRegion@@ZNNBBBBBBB@ @ п@|:@q@|:@MSysAccessObjectsDDDDDDDDDDB   HĔӇ@#-@Admin. 8,,,,,,,,,*  xH@xH@AutonumFix66666666664  &e@&e@turbo data schema~@PPPDDDDDDDB @עI@עI@modAutoNumFix<<<<<<<<<<: wۅ.)@wۅ.)@Search Queries~@JJJ>>>>>>>< @ Z@Z@SysRel.........., Z@Z@Scripts0000000000. Z@Z@Reports0000000000. Z@Z@Modules0000000000. Z@Z@Forms,,,,,,,,,,* Z@Z@DataAccessPages@@@@@@@@@@> c@c@MSysRelationshipsDDDDDDDDDDB c@c@MSysQueries88888888886 c@c@MSysACEs22222222220 c@c@MSysObjects88888888886 c@c@MSysDbx@:::......., @c@c@Relationships<<<<<<<<<<: c@c@Databases44444444442 c@c@Tables..........,  Y.N..Y Y DataIDk Q@YAOIndexv1K[FN083DTw qryPtoRElementFlowStandardsInProjectNotInRegionSearch QueriesCreate report in Design viewCreate data access page in Design viewAutonumFixh L @,S,S@h0,p,,`,,DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD,,0,,PMSysAccounts.XX@K[ࡱ> LM > :; !"$%&'()*+,-./0123456789<=?G@ABCDEFIHJJKIOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntryP<VBA PVBAProject  PVBA dirx__SRP_1~__SRP_2 __SRP_3 AR  !"#$%&'()*+,-./0123456789:;<=>?@BCDEFHIJKLMNPSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~t0* pHdblank back endD@  = Vz @CG J<  rstdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\System32\e2.tlb#OLE Automation0hADODB> ADOBD DE1D10-8DAA006D2(EA4D1DProgram Files\CommonsM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 LibraryHDAO>DAр[ Y25E0Y00-5O,'Shared\\dao360.dll# 3.6- ,[X>(ZXQZ6*w[UZ8^ZCGZx*@" Ext.W8 for DDL and Secu(ritDZ",modNumFixG3m dauoNumFi x@FEUWMSKJLXDVXDIXURDKHIOSKOW_28AEUWMSK@JLXVEBI@URKHI@{O@ 4_A@1ݸB",.@!+BForm_Search QueriesG&Fr_@earc s Qe i`usPEMCDKLJKRGSIEXDJLASEEHPQMDFEPMCLKG IAAAEHP M`F7"`(`brU~~~~~~~q  Y  ( ! 8  H  X  hReplace strSearchCompare strReplaceWarningGrU  1 Y  IK[  1    1@ 4Ya@ 8rrr@< ppp@@! I ttt@D! a vvv@H  xxx@L  |||@ PYa  @T  @X A @\ Y @ `Yaq I@:d ! WW0 0  \*#t*#p*#l*#h*#d *#`*#\ *#X*#T*#P *#L*#H *#D*#@ *#<*#8*#4*#0*#,*#(*#$*# *#*#*#*#*# *#*#*#*#*#*1x2@tplhd`\XTPLHD@<840,($  &'''xM@ 6\( x#tplhd`\XTPLHD@<840,($  /0   @hx! x h(X]1HVD! lD ()xD5h@hx! x h(X]1HVD! TD P)xD5h@hx! x h(X]1HVD! D )xD5h8$  xDhH0 H  0   P`480rU p$` $A` $` $`,(`A#<A` Yy0&0nID="{9F1F7BA8-C5D3-41E6-BE60-F49CDAAB6B9C}" Module=modAutoNumFi_VBA_PROJECTFEUWMSKJLXDVXDIXURDKHIOSKOW_: RPEMCDKLJKRGSIEXDJLASEEHPQMDF:#-PROJECT Gam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\K[G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\system\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library*\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{00000600-0000-0010-8000-00AA006D2EA4}#2.8#0#C:\Program Files\Common Files\System\ado\msadox.dll#Microsoft ADO Ext. 2.8 for DDL and Security CG8FEUWMSKJLXDVXDIXURDKHIOSKOW_0143ea145cmodAutoNumFix@8PEMCDKLJKRGSIEXDJLASEEHPQMDF0647e243dbU&Form_Search QueriesP7"pP!7=MAFv(\$)6P7~0dr2H H[%0be2Access!CompareVBAWin16~Win32MacVBA6#blank back endstdole`ADODBsDAOADOX modAutoNumFix _Evaluate AutoNumFixcatJ}Catalog#tblPTablecolHColumnivarMaxIDs "!l @*Is seed negative or below existing values?Seed "%>'(\[ "!][ ,]$B'&S ( ( &:\W 'Offer the next available value above 0.O &$D '*\Sy * W'*:\Pk ,Get confirmation before changing this table.\AT $$$'$Table: F , HField: F "! HMax:  F & HSeed:  FSeed "%> H HReset seed to  *?'. $ . L N $Alter the AutoNumber for this table?$J'0 0 P<Set the value. *Seed ",>t 2 '2$&Write a trail in the Immediate Window.gK[r[ , "! ( => *suakkky!#Table can have only one AutoNumber.ilkp Next columnskPkH)If the user chose Cancel, no more tables. 0 R-syk Next table.1Clean upp.".. 2'iAttribute VB_Name = "modAutoNumFix" Option Compare Database`Explicit ` FuncZ() As Long 'Pu@rpose:Find aocally fix ales in current project` wherz; 'rnumber is negative or below actual v@alues.ReturnE xof?5 seed was rPesetpUto dialog: YW= change . NBoskipC ancel quit,archiDng*Not Re79fw 5Microsoft ADO Ext. library Dim cas NebwX.CP 6'oc HtblAkX.TableW'EachD1CNoG Column C field varMaxIDVaria@u 'Highest exis>t@C@i&lngOldSAcēfoundK @qU aft@k s,tr=S@ng MsgA4 '@Box messageH @1Answ@ 1 'Responso CK Ku'$B'C=t tC]Set.AveConFn@Ё= CCP j.g#'LooVhrough wrC? F`jBEItatEsaP= 0&Ikb l.TypTABLE" The`G'` viewO 3= T.1asyste "M@" A1~athe c"`6%%  %Ae% @.3perties(" increm")&,adInt"FAk'?"p+ V-& Q3:  YBs5&"phB (!5?Dn=lW,@No+QИ!, ?"Al{W$7$?Es2 vb1?'s!<)ezdZ=E8o( ~rpo??'Wria trH! Imme`Wow Debug`[iu%5,X,A ^`X =t'"]C ?;x x'rBn haanon|/#N^'oK'(ubsychoП1, no mQИ N+4jE7  iW'Cleanx up@ioZR2@oY~h]CĒ`"K01 U   1"!K2w@)Q^^II`;HwxME [LS S<<<,<0<<< <$<(<4<8<<<Xcejg N0{D9B56B8F-089E-47C8-A441-BF80513E0C5F}  (% Vp` x`@`zx |` ~H`D@ v`i `?` u;,^`VV.id8iDXI xI i f % h%`p```K[`` ` X0 0p%t(%#x This tool will search all the stored queries in your database H>for a specified string and optionally replace the string with  H<another that you supply. Use this tool just like any other  H>find and replace utility. Use the Find/Replace tabs to switch Hmodes. H H- Find What - enter your search string here  H2 Replace With - enter a replaceK[ment string here  H9 Case Sensitive - Select if you don't want to find 'a'  H( when looking for 'A' H@ Warn Before... - Select to be prompted for each query updated HB Find Button - Start the search. Note that hitting 'Find' will  HD only find (not replace)the selected text,even when  H0 you are on the replacement tab. H1 Replace Button - Start the search and replace. H: Results - Lists the queries where the string was found. H? For replace, it also indicates whether replacement H was successful.'z zA@Jo(A@vo ! ( ! ( ! (oH] X(Z ! 'dx 'kh  !' `   $^'\d( ` $^'\k \ Not Found'\k X(Zo?Searches stored SQL (procedures/queries) for a specified string]](@Xp $' $ $'9 provide warnings by default$l.f h f!n h!r'p p d D h!' ~sq_2sql embedded in formbthe name returned by dao for embedded sql appears to include this string followed by one character ~sq_' G 'j   $ (Form)'kh  p d  D$'p  X!Z' X(Z Replace string in query ' '? L$J'  X(Z  P p h(r h!r p  'dx  'kPdH  '  R ^  H '^y k k d p h(r%. replace the string without warning if desired h!r p  'd  'kX kP kH ^  H'^k( h the following ADO code didn't work as well because only some querydefs are classified as "views" by ADO Dim rst As ADODB.Recordset Dim intColumn As Integer% On Error GoTo Error_SearchQueriesA Set rst = CurrentProject.Connection.OpenSchema(adSchemaViews) Do While Not rst.EOF; If InStr(1, rst("VIEW_DEFINITION"), strSearch) ThenF SearchQueries = SearchQueries & rst("TABLE_NAME") & vbCrLf End If' rst.MoveNext Loop Set rst = Nothing Exit FunctionError_SearchQueries: 'clean upQ MsgBox ("Error " & Err.Number & ": " & Err.Description & " in SearchQueries") If Not rst Is Nothing Then Set rst = Nothing End Ifi^Attribute VB_Name = "Form_Search Queries" Bas0{D9B56B8F-089E-47C8-A441-BF80513E0C5F} |@GlobalSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDqvCustomizD$Option Comp@ D3T  MsgBox(" Replace string in query '" &!(Name"'?", vbYesNoCance"7Else-AgError.nd If S4Notŀ6hC`RSearchQ9ieIvbCrLfbLoop G$h@@Cunct߀$`@.K-:a'clean u  ("#5!A .Numb& ": eDescrip A"1 -0 Is2 5q1 P.)%0 F x DocClass=Form_Search Queries/&H00000000 Name="blank back end" HelpContextID="0" VersionCompatible32="393222000" CMG="EAE8A8E670EA70EA70EA70EA" DPB="B6B4F43A0CCAD9CBD9CBD9" GC="8280C00E8D0F8D0F72" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] modAutoNumFix=44, 44, 719, 513, Z Form_Search Queries=0, 0, 0, 0, C modSearchQueries=22, 29, 760, 442, C modAutoNumFixmodAutoNumFixForm_Search QueriesFPROJECTwmOhAcessVBADataQ Forms w P1`o.orm_Search Queries0289=Babe gh6ij 1k_](@Cu?@XU^3e. U Search Queries Arial8 h\\RONS LAPTOP\HP4P4C odXXLetterBlob R PropDataK[TypeInfoEBlobDeltaDINU"4z==*HP LaserJet 4P\\RONS LAPTOP\HP4P\\RONS LAPTOP\HP4Pd2 Tahomahgh Tahomaj1ghm45 Tahoma{ Tahoma` Detail G@-%HaR W {1]`<a<blcdfgp tabFR"[Event Procedure]olsxBOĒP~G|1`ab^cH pgFindFind1gߕnLI+ߚ|1`ab^cHpgReplaceReplaceRIG^|m7F`TaXbc,txtFind_AEP\d5`aXbc Label1Find What:5]`F.3pm27F`abc0 ktxtResults A{B8GOKd5`abc Label3Results:PXZ>APh1`paXbcnicmdFindFind"[Event Procedure]Find SQLn+_(7B}̫Tm7F`TaGbc,ktxtReplace?*KC Ymd5`aGb8c Label6Replace With:i>WVpK 1h1`paGbcnicmdReplaceReplace"[Event Procedure]Update SQL  XcGz@Qj2`TaTb,cichkCase FalseP}ֽI F d5`abcLabel12Case Sensitive:@yҡDȜ#cj2`TaTb,cichkWarnTrueMJnOL|H5uuPhd5` abo cLabel14:Warn Before Each Replacement:L=IV@kGh1`pa-bcnicmdHelpHelp"[Event Procedure]Update SQL}. ?@E O K[ͬkٞGAQ> _Detail{ tabFR|!pgFind|!pgReplacemtxtFindd Label1mtxtResultsd Label3h cmdFindm txtReplaced  Label6h  cmdReplacej chkCased  Label12jchkWarnd Label14h cmdHelpdhjm{ {||mdmdhmdhjdjdh Search Queries 1CB0 Search Queries"Search Queries1 0CB0 1CB0DirData&PropDataDirDataCopyJPropDataCopyCmdbarsw w Modules(w P0w w PropData modAutoNumFix 0CB0 0CB0ͬBy k5ObL׆e{ReportHeaderdLabel201dLabel202PageHeaderDetailfLine0fLine1gImage2gImage3fPropDataCopyDirData$PropDataPropDataCopyReports&w P0#w @Blob NPropData"$ K[      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHTKLMNOPQRSVUWX0:<=Babc3e ghXiJj18k6$cFV@m:B:!. U 8Relationships for turbo data Arial834h!@hg odXXBeRLdMSACCESSdHBeںں\\YANCE\HP Officejet 7300 series,LocalOnly,DrvConvertN!:Officejet7300seriesd28 Arialg37n7 Arial`ReportHeaderD*̣Rtd8"bceLabel2018Relationships for turbo dataV5Nu\1EjdabcLabel202.Thursday, July 29, 1999J#~BciVE`PageHeaderChM@BWC`4 Detail 50Fs3Zf2`sab Line0=R ==BMC~Urf2`a b Line19&Pa@u/hg`a" bZcx Image2h(@@@@@@@@ K[@@@@@@@ꝏCB _g`a}bcK Image3x( P@@@@@@@@@@@@@@UJs+7:f`a b c. Line47Lt,f2`$a$ b Line5|2s#Dif2`#ab Line6kՊ.nJ0Lf`#a K[bcX Line7DgFg`+abcKImage14x( P@@@@@@@@@@@@@@ K[ػAʖ\f`#abc Line15d`&HӍ f2`2ab Line16n~NG:~f2`--aZb Line17C}ǧ{Ew:5g`Z-abZcxImage18h(@@@@@@@@@@@@@@@R5Gˁvg`72abcKImage19x( P@@@@@@@K[@@@@@@@z-E nʂf`--abcS Line20$GK]!Xhf2`ab Line32A`H6D.g`a bZcxImage33h(@@@@@@@@@@@@@@@K[Πi[AGŚYg`aCbcKImage34x( P@@@@@@@@@@@@@@ 虥KG;Anf`abc  Line35ȟsF9z*f2`K-ab Line36ZCDlcDYf2`=,a7b Line37:Dx%cf`-ab-c Line385PWWE`pf2`Z-ab Line39B ;B2@f2`=,a b Line40#| 42MSzf`-a b<c  Line41uh{EOz/f2`a-b Line428ڷ@6>f2` a.b Line43ovD$y.f` a-bc- Line443kD7sf2`a/b Line45M6JoKR1MFf2`a#(b Line46v³EA g` a'bZcxImage47h(@@@@@@@@K[@@@@@@@+eLx~D_16;g`av/bcKImage48x( P@@@@@@@@@@@@@@K[zfK9f` a2(bc Line49ϲs`H쭈ƒf2`a0b Line502vA95Kf2`a(b Line51EѨԟN=ߗg` a_(bZcxImage52h(@@@@@@@@@@@@@@@6sJ%H8$Ag`aH0bcKImage53x( P@@@@@@@@@@@@@@K[ ͘4~B&MPZ0f` a)bc Line54֛M.3Inf2`a,b Line55Jo@u f2`a2(b Line56t㗧P`2EI7'f` a2(bc Line57TOeC9f2`a&b Line58PCt'EDNf2`a#(b Line59/-֕O(t|g` a'bZcxImage60h(@@@@@@@@@@@@@@@롷@g`a&bcKImage61x( P@@@@@@@K[@@@@@@@[AtPB&cf` a&bc Line62;JYMRTpf2`aQ'b Line630 VfLp؂ ,f2`a(b Line64>Hk(7g` a_(bZcxImage65h(@@@@@@@@@@@@@@@<O>N-)S]9g`a&bcKImage66x( P@@@@@@K[@@@@@@@@1hCWyEf` a`'bc Line67C D xt&f2`sab Line68di5 DLs/ff2` awb Line69)"F#avB@L%wg` abZcxImage70h(@@@@@@@@@@@@@@@K[흼gG ^g`abcKImage71x( P@@@@@@@@@@@@@@Z$IXklf` a#b cc Line72#"I!f2`sab Line73DNԋ9f2` awb Line74ӊGLDD@g` abZcxImage75h(@@@@@@@@K[@@@@@@@aQI_g`a<bcKImage76x( P@@@@@@@@@@@@@@RÒºcpGif` ab c Line774dlI9f2`ab Line78"(BJdWxAf2`paAb Line79OkC.ăIg`abZcxImage80h(@@@@@@@@K[@@@@@@@gxLsN2uI'Lg`abcKImage81x( P@@@@@@@@@@@@@@k!">)Jf`Q ab7c Line82@|XNWĴ_Ipf2`ab Line83EG-J@:ʟg`abcKImage91x( P@@@@@@@K[@@@@@@@zŒIQ$af`Q aPb" c6 Line92&"Y@ֲf2`ab Line93J%š9FtՀFf2`F#aO b Line94+E1THM AAg`d#a bZcxImage95h(@@@@@@@@@@@@@@@VOi|AO0ig`aFbcKImage96x( P@@@@@@@K[@@@@@@@hIm@#1f`a^ bc` Line97C_OrUf2`ab Line98zHHOٰxf2`1 ab Line99BVI"N3HDKg`O a bZcxImage100h(@@@@@@@@@@@@@@@K[J63QGrsg`a:bcKImage101x( P@@@@@@@@@@@@@@Ix)`Hi>Cf` abLine102s=FBf2`abLine103TAYXp;Af2`a bLine104hLWnlg`a" bZcxImage105h(@@@@@@@@@@@@@@@K[~ilC:Tg` abcKImage106x( P@@@@@@@@@@@@@@G(qLJf f`a bc3 Line107nLDeO3Ēf2`a! bLine108~r(zAD%ff2`a bLine109VKLTg`a" bZcxImage110h(@@@@@@@@ K[@@@@@@@zrղG|cg`a bcKImage111x( P@@@@@@@@@@@@@@xe'ULffM@f`a bciLine112" #B@ /&@ f2`a bLine113dL2ʀ+f2`^abLine114qBMOUb r.g`|a[bZcxImage115h(@@@@@@@@!K[@@@@@@@R }AqLg`a bcKImage116x( P@@@@@@@@@@@@@@"K[ ;YI6N>=f`a bcLine117ץ!?ЋORer-f2` abLine118ARK$8jf2`a bLine119 y+ FsGg`a" bZcxImage120h(@@@@@@@@@@@@@@@SUmG>V߀g` aLbcKImage121x( P@@@@@@@@@@@@@@#K[{A1Cf`a bcLine122)Ar͵&M4P5f2`)abLine123LUKH@<߾5&f2`abLine124 @O?ɞg` a[bZcxImage125h(@@@@@@@@@@@@@@@-mSH 6srg`GabcKImage126x( P@@@@@@@$K[@@@@@@@HxLwf`ab-cLine127>EŐWLLi^Kf2`aubLine128Ɛ|cL9Sf2`a bLine129=뻋hCW!g`a" bZcxImage130h(@@@@@@@@@@@@@@@ jF-G<3g`a bcKImage131x( P@@@@@@@%K[@@@@@@@%OG d;}f`abcCLine132yܪQ Irf2` abLine133aTtAHf!f2`a bLine134ڬ"H@&g`a" bZcxImage135h(@@@@@@@@@@@@@@@&K[ɂO3I _}(g` aqbcKImage136x( P@@@@@@@@@@@@@@PGȢT2NЛf`abcLine137&?XoA'+f2`F#a bLine138!~I#J]bpf2`%abLine139-#v9QEk20vJg`%aJbZcxImage140h(@@@@@@@@@@@@@@@'K[=o] |@@30g`d#a\ bcKImage141x( P@@@@@@@@@@@@@@'{Fd {f`'$a bcLine142o vI/Wn07"aTbKcddecl0Value List߄"MarketPackage";"ProjectID";"Applicability";"Touched";"Comment";"" TahomaV#H?ES.d238"`Tajbcecltitle0&tblRegionalServices TahomajMAJhn07"abIcdlecl1Value List<"StakeholderID";"ElementID";"" Tahoma dыH 0Zd238"`ahbcecltitle1&tblStakeholderRoles Tahoma;2ItIEd5%n07"abIcSdlecl2Value Listz"StakeholderID";"StakeholderName";"StakeholderDescription";"" TahomaHůHh68(K[Td238"`ahbScecltitle2tblStakeholders TahomaqkaEۅ5ԅn07"a{bIcd&lecl3Value List"EntityID";"EntityAbbreviation";"EntityName";"EntityDescription";"EntityKind";"EntityClass";"EntityType";"" Tahomal8{7Dl0zqd238"`{ahbcecltitle3tblEntities TahomaIӑM^AB2n07"aibUcdlecl4Value List>"RegionalFlowID";"ProjectID";"" Tahoma`M?4d238"`iatbcecltitle4,tblProjectArchitecture TahomaK>N r`9'n07"alb cd&lecl5Value List"RegionalFlowID";"SourceElementID";"DestinationElementID";"FlowID";"InRegionalArchitecture";"FlowStatus";"Touched";"Comment";"" Tahoma47Fȯd238"`la bcecltitle5.tblRegionalArchitecture TahomayWOnqn07"a*bx-cCdlecl6Value Listߘ"WorkspaceModified";"CurrentTask";"CurrentArchitecture";"InterviewStatus";"" TahomaEJK$>U)d238"`*a,bCcecltitle6(tblApplicationStatus TahomahdLvPq,n07"a&bdElecl7Value Listߞ"FlowID";"FlowName";"FlowDescription";"FlowKind";"FlowFuturistic";"FlowType";"" TahomauBPa._)d238"`&abcecltitle7tblFlows TahomaηUaMn07"avb'cd lecl8Value List"QuestionCategory";"QuestionSequence";"QuestionNarrative";"QuestionHelp";"QuestionType";"ChoiceA";"ChoiceA2";"ActionA";"ArgumentA";"NarrativeBranchA";"ChoiceB";"ActionB";"ArgumentB";"NarrativeBranchB";"" Tahoma6PыF~y+d238"`va&bcecltitle8tblInterview TahomazI)W0A@n07"a b-cddl ecl9Value Listߌ"ActionID";"ActionStep";"ActionType";"ActionName";"ActionParameter";"" Tahoma:fNn6;fd238"` a,bcecltitle9&tblInterviewActions TahomavoLp LT1n07"a b/cdl ecl10Value Listx"QuestionCategory";"QuestionSequence";"CenterID";"Answer";"" Tahoma]4?A J!yd238"` a.bcecltitle10&tblInterviewAnswers TahomaB2N5Tn07"a b%&cdl ecl11Value Listp"CurrentCategory";"CurrentSequence";"CurrentCenterID";"" TahomaPG,)z.EH0O_d238"` aD%bcecltitle11$tblInterviewStatus TahomahJZ@W^n07"ay,bdl ecl12Value List:"EntityID";"OtherEntityID";"" Tahoma7mŰw+B35_d238"`y,abcecltitle12 tblOtherEntities Tahoma@ Lt'zn07"a*b&cdl ecl13Value List߀"RegionalArchitectureExists";"Regi)K[onName";"RegionDescription";"" TahomaET$yJۚmd238"`*a&bcecltitle13,tblRegionalInformation Tahoma-@D5OM%cn07"a.bdl ecl14Value List"EntityID";"EntityAbbreviation";"EntityName";"EntityDescription";"EntityKind";"EntityClass";"EntityType";"" Tahoma_G\D]#d238"`.abcecltitle14tblEntities_1 TahomaW_bDmIx in07"a'bIc dl ecl15Value ListR"SourceEntityID";"DestinationEntityID";"" Tahoma\tB CcAd238"`'ahb cecltitle15:tblStakeholderBoundInterfaces Tahoma@ lKIen07"am b[cdl ecl16Value ListV"SourceElementID";"DestinationElementID";"" Tahoma MEJId238"`m az bcecltitle160tblSelectedInterconnects TahomaNUB*  !n07"a b*c4dl ecl17Value List^"SegmentID";"SegmentName";"QuestionCategory";"" Tahoma-0{UdM Rjed238"` a*b4cecltitle17(tblInterviewSegments Tahomag[Co @n07"abcdl ecl18Value Listf"ElementID";"EntityID";"AutoGenerated";"Touched";"" TahomaBUw%ڈd238"`abcecltitle18"tblElementMapping Tahomaf;Jo4"yJn07"a bcdl ecl19Value List4"ElementID";"ProjectID";"" TahomaA7yBd238"` abcecltitle19$tblProjectElements Tahoma\ͼ]oE @ n07"ahb^ cddl ecl20Value Listߔ"ElementID";"ElementName";"ElementDescription";"ElementStatus";"Center";"" TahomaAE2id238"`ha} bcecltitle20tblElements TahomaR6)Aݵo n07"abddl ecl21Value Listߔ"ElementID";"ElementName";"ElementDescription";"ElementStatus";"Center";"" TahomalJiJ-ϛd238"`a bcecltitle21tblElements_1 Tahoma4![Omn07"a%bcEdl ecl22Value List2"EntityClass";"Select";"" Tahomaa+Q)JH`/dd238"`%abEcecltitle22,tblFilterEntityClasses Tahoma縺szJ`VK'3>8d238"`abcecltitle26*tblProjectInformation Tahoma`6LYg^n07"aTbc dl ecl27Value Listb"MarketPackage";"ElementID";"Select";"Touched";"" Tahomaf'Fm?d238"`Tab cecltitle270tblMarketPackageElements Tahoma 0hKS"nn07"abcCdl ecl28Value List߂"MarketPackage";"MarketPackageName";"MarketPackageDescription";"" Tahomap?ԢC 8م(d238"`a<bCcecltitle28"tblMarketPackages Tahoma ]Iu,B',F`PageFooterp$dFu$CmhKjYm`hReportFooterio,wHMOCZTypeInfo% BlobDeltaDirData!',PropData Line4f Line5f Line6f Line7f Line8fLine9fLine10fLine11fLine12gImage13gImage14fLine15fLine16fLine17gImage18gImage19fLine20fLine21fLine22gImage23gImage24fLine25fLine26f Line27g!Image28g"Image29f#Line30f$Line31f%Line32g&Image33g'Image34f(Line35f)Line36f*Line37f+Line38f,Line39f-Line40f.Line41f/Line42f0Line43f1Line44f2Line45f3Line46g4Image47g5Image48f6Line49f7Line50f8Line51g9Image52g:Image53f;Line54f<Line55f=Line56f>Line57f?Line58f@Line59gAImage60gBImage61fCLine62fDLine63fELine64gFImage65gGImage66fHLine67fILine68fJLine69gKImage70gLImage71fMLine72fNLine73fOLine74gPImage75gQImage76fRLine77fSLine78fTLine79gUImage80gVImage81fWLine82fXLine83fYLine84gZImage85g[Image86f\Line87f]Line88f^Line89g_Image90g`Image91faLine92fbLine93fcLine94gdImage95geImage96ffLine97fgLine98fhLine99giImage100gjImage101fkLine102flLine103fmLine104gnImage105goImage106fpLine107fqLine108frLine109gsImage110gtImage111fuLine112fvLine113fwLine114gxImage115gyImage116fzLine117f{Line118f|Line119g}Image120g~Image121fLine122fLine123fLine124gImage125gImage126fLine127fLine128fLine129gImage130gImage131fLine132fLine133fLine134gImage135g+K[Image136fLine137fLine138fLine139gImage140gImage141fLine142necl0decltitle0necl1decltitle1necl2decltitle2necl3decltitle3necl4decltitle4necl5decltitle5necl6decltitle6necl7decltitle7necl8decltitle8necl9decltitle9necl10decltitle10necl11decltitle11necl12decltitle12necl13decltitle13necl14decltitle14necl15decltitle15necl16decltitle16necl17decltitle17necl18decltitle18necl19decltitle19necl20decltitle20necl21decltitle21necl22decltitle22necl23decltitle23necl24decltitle24necl25decltitle25necl26decltitle26necl27decltitle27necl28decltitle28PageFooterReportFooterdgnddffggfffffffffggfffggfffggfffggfffggffffffffffffggfffggffffffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfndndndndndndndndndndndndndndndndndndndndndndndndndndndndnd&turbo data schema 0CB033!AutoNumFix () AutonumFix 0CB0Scripts 0,w P0*w w Blob +jBlobDeltaDirData)-PropData.PropDataCopyPropData 0CB0 1CB1,K[ijMSysDbDatabases/41w P032w w Blob DirDataCustomGroups5w w DataAccessPages w w -LVAL0~ V "  .hb~: qryASRequestFlowsAll.DestinationElementID=qryASResponseFlowsAll.SourceElementIDqryASRequestFlowsAll.ProjectID=qryASResponseFlowsAll.ProjectIDqryASRequestFlowsAll.FlowIDRequest(((tblRegionalArchitecture.SourceElementID) Is Null) AND ((tblRegionalArchitecture.DestinationElementID) Is Null) AND ((tblRegionalArchitecture.FlowID) Is Null))qryASRequestFlowsAll.SourceElementID=tblRegionalArchitecture.DestinationElementIDqryASRequestFlowsAll.DestinationElementID=tblRegionalArchitecture.SourceElementIDqryASRequestFlowsAll.FlowIDResponse=tblRegionalArchitecture.FlowIDqryASRequestFlowsAll.FlowIDResponseqryASRequestFlowsAll.SourceElementIDqryASRequestFlowsAll.DestinationElementID[qryASResponseFlowsNotIncludedRegion].[SourceElementID]=[tblRegionalArchitecture].[SourceElementID][qryASResponseFlowsNotIncludedRegion].[DestinationElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASResponseFlowsNotIncludedRegion].[FlowID]=[tblRegionalArchitecture].[FlowID][qryASResponseFlowsNotIncludedRegion].[FlowStatus](((qryASResponseFlowsNotIncludedProject.ProjectID)=[Project]))qryASResponseFlowsNotIncludedProject.FlowID = tblRegionalArchitecture.FlowIDqryASResponseFlowsNotIncludedProject.DestinationElementID = tblRegionalArchitecture.DestinationElementIDqryASResponseFlowsNotIncludedProject.SourceElementID = tblRegionalArchitecture.SourceElementIDqryASResponseFlowsNotIncludedProject.ProjectIDtblRegionalArchitecture.RegionalFlowIDqryASRequestFlowsNotIncludedRegion.FlowIDResponse = tblRegionalArchitecture.FlowIDqryASRequestFlowsNotIncludedRegion.DestinationElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsNotIncludedRegion.SourceElementID = tblRegionalArchitecture.DestinationElementID[qryASRequestFlowsNotIncludedProject].[FlowIDResponse]=[tblRegionalArchitecture].[FlowID][qryASRequestFlowsNotIncludedProject].[DestinationElementID]=[tblRegionalArchitecture].[SourceElementID]  @ @ @ @ @ @      !"#$%&'()*+,-./0 1!2"3#4$5%6&7'8(9):*;+<,=->S Y NBBY w Y (Y c Y 1 Y w Y (Id LValueObjectGuidObjectNameProperty ValuelrBCBDBEYYYId$ObjectGuidProperty$ObjectNamePropertyBHv1b  A A A.EZ"~) O % C `  v X : ^ 4 fzpR4h>\x.f,h>  G  G  G@G 'tblRegionalArchitecturetblProjectArchitecture@Gwk? ArrowStyle13%% oStatusID^@G-!! o tblRegionalArchitecture.FlowID= gX@G gN@G gL@G gtblProjectArchitecture=== tblRegionalArchitecture???  G  GX7YZ_____2v@G1% 7X7YZ_____1x@G1% 7 G  G  G DN@G / F@G gF@G gCountN@G' oqryAPFlowsRegionEnumerateCCC  G G  G qryAPFlowsRegionForqryAPFlowsRegionRevv@ Gi]7  qryAPFlowsRegionForqryAPFlowsRegionRevn@ Gi]7  qryAPFlowsRegionForqryAPFlowsRegionRev@ Gi]7  qryAPFlowsRegionForqryAPFlowsRegionRev@ Gi]7  ArrowStyle23%% o qryAPFlowsRegionFor.StatusID; g qryAPFlowsRegionFor.FlowID9 g P@ G g F@G g D@G g qryAPFlowsRegionRev777  qryAPFlowsRegionFor777   G  G    G tblFlows.FlowName0 ' F@G ' tblAPEntities_1.EntityOrder: ' tblAPEntities.EntityOrder8 ' ~@G ' qryAPFlowsRegionIDSelecttblAPEntities@Gg[A  qryAPFlowsRegionIDSelecttblAPEntities_1@Gk_A  tblFlowsqryAPFlowsRegionIDSelectb@G]Q!  B@G g data flowtblFlows.FlowNameB## o F@G g DestinationIDtblAPEntities_1.EntityOrderT++ o SourceIDtblAPEntities.EntityOrderH!! o qryAPFlowsRegionIDSelectAAA  tblAPEntitiestblAPEntities_1II+  tblAPEntities+++  tblFlows!!!   G  G    GLVALx < b * F l  0>H.T.qryAPFlowsRegionIDs.DestinationElementID = tblTmpSelectedElements_1.ElementIDqryAPFlowsRegionIDs.SourceElementID = tblTmpSelectedElements.ElementIDqryAPFlowsRegionIDs.DestinationElementIDqryAPFlowsRegionIDs.SourceElementIDSELECT * FROM qryAPFlowsRegionBoth((([Arch])=-1) AND ((tblRegionalArchitecture.InRegionalArchitecture)=True)) OR ((([Arch])>0) AND ((tblProjectArchitecture.ProjectID)=[Arch]))tblRegionalArchitecture.RegionalFlowID=tblProjectArchitecture.RegionalFlowIDIIf([Arch]=-1,[FlowStatus],[ProjectFlowStatus])tblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowIDSELECT qryAPFlowsRegionIDSelect.DestinationElementID AS ElementID, qryAPFlowsRegionIDSelect.FlowID, qryAPFlowsRegionIDSelect.SourceElementID AS OtherElement FROM qryAPFlowsRegionIDSelectSELECT qryAPFlowsRegionIDSelect.SourceElementID AS ElementID, qryAPFlowsRegionIDSelect.FlowID, qryAPFlowsRegionIDSelect.DestinationElementID AS OtherElement FROM qryAPFlowsRegionIDSelect Count(qryAPFlowsRegionEnumerate.FlowID)qryAPFlowsRegionEnumerate.ElementIDqryAPFlowsRegionEnumerate.ElementIDCount(qryAPFlowsRegionEnumerate.FlowID)qryAPFlowsRegionFor.StatusID = qryAPFlowsRegionRev.StatusIDqryAPFlowsRegionFor.FlowID = qryAPFlowsRegionRev.FlowIDqryAPFlowsRegionFor.DestinationElementID = qryAPFlowsRegionRev.SourceElementIDqryAPFlowsRegionFor.SourceElementID = qryAPFlowsRegionRev.DestinationElementIDqryAPFlowsRegionFor.DestinationElementIDqryAPFlowsRegionFor.SourceElementIDqryAPFlowsRegionFor.RegionalFlowIDqryAPFlowsRegionIDSelect.ArrowStyle(((tblAPEntities_1.EntityOrder)<[tblAPEntities].[EntityOrder]))qryAPFlowsRegionIDSelect.SourceElementID = tblAPEntities.ElementIDqryAPFlowsRegionIDSelect.DestinationElementID = tblAPEntities_1.ElementIDtblFlows.FlowID = qryAPFlowsRegionIDSelect.FlowIDqryAPFlowsRegionIDSelect.StatusIDqryAPFlowsRegionIDSelect.ArrowStyleLVALvp$~ jV$RCount(qryAPFlowsRegionShowAllEnumerate.FlowID)qryAPFlowsRegionShowAllIDSelect.ArrowStyle(((tblAPEntities_1.EntityOrder)<[tblAPEntities].[EntityOrder]))qryAPFlowsRegionShowAllIDSelect.DestinationElementID = tblAPEntities_1.ElementIDqryAPFlowsRegionShowAllIDSelect.SourceElementID = tblAPEntities.ElementIDtblFlows.FlowID = qryAPFlowsRegionShowAllIDSelect.FlowIDqryAPFlowsRegionShowAllIDSelect.StatusIDqryAPFlowsRegionShowAllIDSelect.ArrowStyle(((tblRegionalArchitecture.InRegionalArchitecture)=True) AND (([Arch])=-1)) OR ((([Arch])>0) AND ((tblProjectArchitecture.ProjectID)=[Arch]))tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowIDIIf([Arch]=-1,[FlowStatus],[ProjectFlowStatus])tblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.RegionalFlowID(((tblTmpSelectedElements.ElementShow)=Yes) AND ((tblTmpSelectedElements_1.ElementShow)=Yes) AND ((qryFilteredFlows.FlowShow)=Yes))qryFilteredFlows.RegionalFlowID = qryAPFlowsRegionIDs.RegionalFlowIDSELECT qryAPFlowsRegionFor.* FROM qryAPFlowsRegionFor LEFT JOIN qryAPFlowsRegionBoth ON (qryAPFlowsRegionFor.StatusID = qryAPFlowsRegionBoth.StatusID) AND (qryAPFlowsRegionFor.FlowID = qryAPFlowsRegionBoth.FlowID) AND (qryAPFlowsRegionFor.DestinationElementID = qryAPFlowsRegionBoth.DestinationElementID) AND (qryAPFlowsRegionFor.SourceElementID = qryAPFlowsRegionBoth.SourceElementID) WHERE (((qryAPFlowsRegionBoth.SourceElementID) Is Null)) UNION SELECT qryAPFlowsRegionRev.* FROM qryAPFlowsRegionRev LEFT JOIN qryAPFlowsRegionBoth ON (qryAPFlowsRegionRev.StatusID = qryAPFlowsRegionBoth.StatusID) AND (qryAPFlowsRegionRev.FlowID = qryAPFlowsRegionBoth.FlowID) AND (qryAPFlowsRegionRev.DestinationElementID = qryAPFlowsRegionBoth.SourceElementID) AND (qryAPFlowsRegionRev.SourceElementID = qryAPFlowsRegionBoth.DestinationElementID) WHERE (((qryAPFlowsRegionBoth.SourceElementID) Is Null)) @fH* ~ r ,  .  ~ ` B X . h~`B*tJYQ'q4^* D\@J / T@J gT@J gCount\@H' oqryAPFlowsRegionShowAllEnumerateQQQ  G G  G tblFlows.FlowName0 ' T@H ' tblAPEntities_1.EntityOrder: ' tblAPEntities.EntityOrder8 '~@H 'qryAPFlowsRegionShowAllIDSelecttblAPEntities_1@ HymO qryAPFlowsRegionShowAllIDSelecttblAPEntities@ HuiO tblFlowsqryAPFlowsRegionShowAllIDSelectp@ Hk_! P@ H gdata flowtblFlows.FlowNameB## oT@ H gDestinationIDtblAPEntities_1.EntityOrderT++ oSourceIDtblAPEntities.EntityOrderH!! oqryAPFlowsRegionShowAllIDSelectOOO tblAPEntitiestblAPEntities_1II+ tblAPEntities+++ tblFlows!!!  G G  G@H 'tblRegionalArchitecturetblProjectArchitecture@Hwk? ArrowStyle-15%% oStatusID^@H-!! o tblRegionalArchitecture.FlowID= gN@H gX@H gL@H gtblProjectArchitecture=== tblRegionalArchitecture???  G G  G  qryAPFlowsRegionIDs.ArrowStyle= '@H 'qryFilteredFlowsqryAPFlowsRegionIDs@HcW1 qryAPFlowsRegionIDstblTmpSelectedElements_1@Gsg7 qryAPFlowsRegionIDstblTmpSelectedElements@Goc7 qryAPFlowsRegionIDs.StatusID; g qryAPFlowsRegionIDs.ArrowStyle= gqryAPFlowsRegionIDs.FlowID9 gP@G gF@G gqryFilteredFlows111 tblTmpSelectedElementstblTmpSelectedElements_1mm= tblTmpSelectedElements=== qryAPFlowsRegionIDs777  G G  GX7YZ_____2D@G1% 7X7YZ_____1@H1% 7LVALXL X  | Z tVSELECT DISTINCT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, IIf([Arch]=-1,[tblStatus].[StatusOrder],[tblStatus_1].[StatusOrder]) AS StatusOrder FROM tblStatus AS tblStatus_1 RIGHT JOIN ((tblStatus RIGHT JOIN tblRegionalArchitecture ON tblStatus.StatusID = tblRegionalArchitecture.FlowStatus) LEFT JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID) ON tblStatus_1.StatusID = tblProjectArchitecture.ProjectFlowStatus WHERE (((tblRegionalArchitecture.InRegionalArchitecture)=Yes) AND (([Arch])=-1)) OR ((([Arch])=[ProjectID])) (((tblAPEntities_1.EntityOrder)<[tblAPEntities].[EntityOrder]))qryAPInterconnectsFiltered.DestinationElementID = tblAPEntities_1.ElementIDqryAPInterconnectsFiltered.SourceElementID = tblAPEntities.ElementIDqryAPInterconnectsFiltered.[data flow]qryAPInterconnectsFiltered.StatusID(((tblTmpSelectedElements.ElementShow)=Yes) AND ((qryFilteredFlows.FlowShow)=Yes)) OR (((tblTmpSelectedElements_1.ElementShow)=Yes) AND ((qryFilteredFlows.FlowShow)=Yes))qryFilteredFlows.RegionalFlowID = qryAPFlowsRegionIDs.RegionalFlowIDqryAPFlowsRegionIDs.DestinationElementID = tblTmpSelectedElements_1.ElementIDqryAPFlowsRegionIDs.SourceElementID = tblTmpSelectedElements.ElementIDqryAPFlowsRegionIDs.DestinationElementIDqryAPFlowsRegionIDs.SourceElementIDSELECT qryAPFlowsRegionShowAllIDSelect.DestinationElementID AS ElementID, qryAPFlowsRegionShowAllIDSelect.FlowID, qryAPFlowsRegionShowAllIDSelect.SourceElementID AS OtherElement FROM qryAPFlowsRegionShowAllIDSelectSELECT qryAPFlowsRegionShowAllIDSelect.SourceElementID AS ElementID, qryAPFlowsRegionShowAllIDSelect.FlowID, qryAPFlowsRegionShowAllIDSelect.DestinationElementID AS OtherElement FROM qryAPFlowsRegionShowAllIDSelect Count(qryAPFlowsRegionShowAllEnumerate.FlowID)qryAPFlowsRegionShowAllEnumerate.ElementIDqryAPFlowsRegionShowAllEnumerate.ElementIDIJ P N $ j " & B $  x @ 4 (=~@>zP2PvX:X7YZ_____2@ L1% 7X7YZ_____1@ L1% 7 G  G  G V@ L ' Dd@ L / V@L gElementIDV@L/## oCountd@L' oqryAPInterconnectsEnumerateGGG  G G  G X@L g N@L gMinStatusOrderP@L9-- oX@L gN@L gqryAPInterconnectsBasic???  G G  GX7YZ_____2@L1% 7X7YZ_____1@J1% 7 G  G  G tblAPEntities_1.EntityOrder: ' tblAPEntities.EntityOrder8 '~@J 'qryAPInterconnectsFilteredtblAPEntities_1@JocE qryAPInterconnectsFilteredtblAPEntities@ Jk_E ArrowStyle03%% oL@ J gF@ J gDestinationIDtblAPEntities_1.EntityOrderT++ oSourceIDtblAPEntities.EntityOrderH!! otblAPEntitiestblAPEntities_1II+ tblAPEntities+++ qryAPInterconnectsFilteredEEE  G G  G  qryAPFlowsRegionIDs.ArrowStyle= 'T@ J 'qryFilteredFlowsqryAPFlowsRegionIDs@ JcW1 qryAPFlowsRegionIDstblTmpSelectedElements_1@Jsg7 qryAPFlowsRegionIDstblTmpSelectedElements@Joc7 qryAPFlowsRegionIDs.StatusID; g qryAPFlowsRegionIDs.ArrowStyle= gqryAPFlowsRegionIDs.FlowID9 gP@J gF@J gqryFilteredFlows111 tblTmpSelectedElementstblTmpSelectedElements_1mm= tblTmpSelectedElements=== qryAPFlowsRegionIDs777  G G  GX7YZ_____2@J1% 7X7YZ_____1@J1% 7 G  G  GLVAL r " |  l ^ j(0$qryFilteredMarketPackageInterconnect.DestinationElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredElements_1.ElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredElements.ElementID = qryAPInterconnectsBasicMin.SourceElementIDtblFilterFlowDeployment.FlowDeployment = tblStatus.StatusIDqryAPInterconnectsBasicMin.MinStatusOrder = tblStatus.StatusOrdertblTmpSelectedElements.ElementID = qryAPInterconnectsBasicMin.SourceElementIDtblTmpSelectedElements_1.ElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredElements_1.ElementShowqryAPInterconnectsBasicMin.DestinationElementIDqryAPInterconnectsBasicMin.SourceElementIDSELECT qryAPInterconnectsFiltered.DestinationElementID FROM qryAPInterconnectsFilteredSELECT qryAPInterconnectsFiltered.SourceElementID FROM qryAPInterconnectsFiltered qryAPInterconnectsEnumerate.SourceElementIDCount(qryAPInterconnectsEnumerate.SourceElementID)qryAPInterconnectsEnumerate.SourceElementIDqryAPInterconnectsEnumerate.SourceElementIDCount(qryAPInterconnectsEnumerate.SourceElementID)qryAPInterconnectsBasic.DestinationElementIDqryAPInterconnectsBasic.SourceElementIDMin(qryAPInterconnectsBasic.StatusOrder)qryAPInterconnectsBasic.DestinationElementIDqryAPInterconnectsBasic.SourceElementIDSELECT DISTINCT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, IIf([Arch]=-1,[tblStatus].[StatusOrder],[tblStatus_1].[StatusOrder]) AS StatusOrder FROM tblStatus AS tblStatus_1 RIGHT JOIN ((tblStatus RIGHT JOIN tblRegionalArchitecture ON tblStatus.StatusID = tblRegionalArchitecture.FlowStatus) LEFT JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID) ON tblStatus_1.StatusID = tblProjectArchitecture.ProjectFlowStatus WHERE (((tblRegionalArchitecture.InRegionalArchitecture)=Yes) AND (([Arch])=-1)) OR ((([Arch])=[ProjectID]))E34` ` 6 m C + Q EekM/Aa7qx1 G G  G tblAPEntities_1.EntityOrder: ' tblAPEntities.EntityOrder8 '~@P 'qryAPInterconnectsShowAllFilteredtblAPEntities_1@P}qS qryAPInterconnectsShowAllFilteredtblAPEntities@PymS ArrowStyle03%% oZ@P gT@P gDestinationIDtblAPEntities_1.EntityOrderT++ oSourceIDtblAPEntities.EntityOrderH!! oqryAPInterconnectsShowAllFilteredSSS tblAPEntitiestblAPEntities_1II+ tblAPEntities+++  G G  G@P ' qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@P{G  qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@P{G qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@PY qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@LY qryFilteredElements_1qryAPInterconnectsBasicMin@L{o; qryFilteredElementsqryAPInterconnectsBasicMin@Lwk7 tblFilterFlowDeploymenttblStatusv@L]Q? qryAPInterconnectsBasicMintblStatus@LcWE tblTmpSelectedElementsqryAPInterconnectsBasicMin@L}q= tblTmpSelectedElements_1qryAPInterconnectsBasicMin@LuA B@L g!qryFilteredElements.ElementShow> gdata flow""3## otblStatus.StatusID1 g^@L gT@ L g tblStatus### qryAPInterconnectsBasicMinEEE tblTmpSelectedElementstblTmpSelectedElements_1mm= tblTmpSelectedElements=== tblFilterFlowDeployment??? qryFilteredElements777 qryFilteredElementsqryFilteredElements_1aa7 qryFilteredMarketPackageInterconnectYYY qryFilteredInteconnectTypesGGG  G G  GO @ @ @ @ @ @ @ @ @ @ @ @ @ @ F F F F F F F F F F F F F F F F  F  F  F  F F F F F F F F F F F F F F! F" F# F$ FF%F'F(F)F*F+ F, F-F&F.F0F1F2F3F/F4F6F7F8F9F:F;F<F=F>F?F@F5FAFCFDIIFBIIIIIII I I I I IIIII IIIIIIIIIIIIII I!II"I$I%I&I'I(I)I*I+I,I-I.I/I0I1I2 I3 I4 I5 I6I#I7I9I:I;I<I= I> I?I8KKKKKKKKK K K K K KKKKKKKKK KKKKKKKKKK K!K"K#K$K%K& K' K(KK)K+K,K-K.K*K/K1K2K3K4K5K6 K7 K8K0K9K;K<K=K>K? K@ KA KBK:KCKEKFKGKHKDMMMMMMKNU @ @ @ @ @ @ @ @ @ @ @ @ @ @I&I'I(I)I*I+I,I-I.I/I0I1I2 I3 I4 I5 I6I#I7I9I:I;I<I= I> I?I8KKKKKKKKK K K K K KKKKKKKKK KKKKKKKKKK K!K"K#K$K%K& K' K(KK)K+K,K-K.K*K/K1K2K3K4K5K6 K7 K8K0K9K;K<K=K>K? K@ KA KBK:KCKEKFKGKHKDMMMMMMMMM M M  M M MMMMMMMMMMMMM M MMMMM M!M"M#M$M%M&M'M(M)M*M+M, M- M.MM/M1M2QQQ Q QM0 Q Q Q Q Q Q!Q !Q !Q!Q!Q!Q!Q!Q!Q!Q!Q! Q!Q!Q!Q!Q!Q!Q!Q!Q!Q !Q!!Q"!Q#!Q$! Q%! Q&!Q'!Q "Q("Q*"Q+"Q,"Q-"Q)#Q.#Q0#Q1#Q2#Q3#Q4#Q/$Q5$Q7$Q8$T$T$Q6%T%TLVAL>z  X  .f2hJnqryFilteredElements.ElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredElements_1.ElementID = qryAPInterconnectsBasicMin.DestinationElementIDtblFilterFlowDeployment.FlowDeployment = tblStatus.StatusIDqryAPInterconnectsBasicMin.MinStatusOrder = tblStatus.StatusOrdertblTmpSelectedElements.ElementID = qryAPInterconnectsBasicMin.SourceElementIDtblTmpSelectedElements_1.ElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredMarketPackageInterconnect.MinOfMPFilterShowqryAPInterconnectsBasicMin.DestinationElementIDqryAPInterconnectsBasicMin.SourceElementIDSELECT qryAPInterconnectsShowAllFiltered.DestinationElementID FROM qryAPInterconnectsShowAllFilteredSELECT qryAPInterconnectsShowAllFiltered.SourceElementID FROM qryAPInterconnectsShowAllFiltered Count(qryAPInterconnectsShowAllEnumerate.SourceElementID)qryAPInterconnectsShowAllEnumerate.SourceElementIDqryAPInterconnectsShowAllEnumerate.SourceElementIDCount(qryAPInterconnectsShowAllEnumerate.SourceElementID)(((tblAPEntities_1.EntityOrder)<[tblAPEntities].[EntityOrder]))qryAPInterconnectsShowAllFiltered.DestinationElementID = tblAPEntities_1.ElementIDqryAPInterconnectsShowAllFiltered.SourceElementID = tblAPEntities.ElementIDqryAPInterconnectsShowAllFiltered.[data flow]qryAPInterconnectsShowAllFiltered.StatusID(((qryFilteredElements.ElementShow)=Yes) AND ((qryFilteredElements_1.ElementShow)=Yes) AND ((tblTmpSelectedElements_1.ElementShow)=True) AND ((tblTmpSelectedElements.ElementShow)=True) AND ((tblFilterFlowDeployment.[Select])=Yes) AND ((qryFilteredMarketPackageInterconnect.MinOfMPFilterShow)=Yes) AND ((qryFilteredInteconnectTypes.InterconnectShow)=Yes))qryFilteredInteconnectTypes.SourceElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredInteconnectTypes.DestinationElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredMarketPackageInterconnect.SourceElementID = qryAPInterconnectsBasicMin.SourceElementID9j.~`" l  n j n D  r Zt(|^ dp$ G$  G$ $ G#tblProjectElementstblApplicationStatus@Si]5 #ProjectStatus"tblProjectElements.ElementStatusY++ o#tblProjectElements.ElementID; g#tblApplicationStatus999 #tblProjectElements555 # # G"X7YZ_____2@S1% 7"X7YZ_____1f@S1% 7" G"  G" " G!@S '! qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@S{G ! qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@S{G !qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@SY !qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@SY !qryFilteredElementsqryAPInterconnectsBasicMin@Pwk7 !qryFilteredElements_1qryAPInterconnectsBasicMin@P{o; !tblFilterFlowDeploymenttblStatusv@P]Q? !qryAPInterconnectsBasicMintblStatus@PcWE !tblTmpSelectedElementsqryAPInterconnectsBasicMin@P}q= !tblTmpSelectedElements_1qryAPInterconnectsBasicMin@PuA !l@P g!data flow""3## o!tblStatus.StatusID1 g!^@P g!T@P g! tblStatus### !qryAPInterconnectsBasicMinEEE !tblTmpSelectedElementstblTmpSelectedElements_1mm= !tblTmpSelectedElements=== !tblFilterFlowDeployment??? !qryFilteredElementsqryFilteredElements_1aa7 !qryFilteredElements777 !qryFilteredMarketPackageInterconnectYYY !qryFilteredInteconnectTypesGGG ! G! G! ! G X7YZ_____2@P1% 7 X7YZ_____1@ P1% 7  G   G    G Dr@ P / d@ P gElementIDd@ P/## oCountr@ P' oqryAPInterconnectsShowAllEnumerateUUU i"eaOs Y UM E / +K  | xID0Fs;7D^ZAAA; ZR@; ZR@qryASResponseFlowsNotIncludedPrA2@U n@qryASResponseFlowsNotIncludedProject@@6@5vvjjjjjjjh @$?mJ@nXБ@0qryASResponseFlowsIncludeRegion@2@3xll```````^ @>7#3@ n@@qryASResponseFlowsIncludeProject@2@3znnbbbbbbb` @=jБ@$nБ@0qryASResponseFlowsExcludeRegion@2@1xll```````^ @<^5@ׯ:@qryASResponseFlowsExcludeProjectW@0@1znnbbbbbbb` @;~@= n@qryASResponseFlowsAll@0@1dXXLLLLLLLJ @$9d6Α@LS@qryASRequestFlowsNotIncludedRegion@.@/~rrfffffffd @8K"1@P n@qryASRequestFlowsNotIncludedProject@.@-tthhhhhhhf @7@B,@@qryASRequestFlowsMissingAppendI@,@-vjj^^^^^^^\ @6/Ϸ@=3gБ@0qryASRequestFlowsIncludeRegion@,@+vjj^^^^^^^\ @$4 \Б@y2@0qryASRequestFlowsExcludeRegion\@*@+vjj^^^^^^^\ @3!:@y:@qryASRequestFlowsExcludeProject@*@+xll```````^ @2ظ@kn@qryASRequestFlowsAll<@*@)bVVJJJJJJJH @1B7@/7@ qryASDeleteFlowsProjectx@*|@)h\\PPPPPPPN @0w7@hE#|7@qryArchStakeholdersConnectedwithGroupMembers@#@)zzzzzzzx @$.8,@?H,@qryArchStakeholdersCalculatedExpanded@'@(xxlllllllj @-$&,@',@qryArchStakeholdersCalculated@'@(thh\\\\\\\Z @,;OoW+@-w7@qryArchStakeholders@'@(`TTHHHHHHHF @$*,7@C ,7@qryArchMPSelectedElements@#@&l``TTTTTTTR @)0,5@ѹ,5@qryArchMarketPackagesRegion@#@&pddXXXXXXXV @(jt)m+@Fn,@qryArchMarketPackagesProjectE@#@&rffZZZZZZZX @' 6W,@Zz3@qryArchMarketPackages@#`@dXXLLLLLLLJ @$%Qt7@*j8@qryArchElementsRegionOrProject@`@ vjj^^^^^^^\ @$Ӎ6t7@6t7@qryArchElementsConnected@"`@ j^^RRRRRRRP @#.@.@qryArchElementsC@"@ XLL@@@@@@@> @"Gle,@7gk/3@qryArchAgreements@"@!\PPDDDDDDDB @  Fa@8Ga@qryAPInterconnectsShowAllEnumerate@`@ ~rrfffffffd @LVAL*h .j^tblMarketPackageProjects.ProjectStatustblMarketPackageProjects.MarketPackageIDSELECT * FROM qryArchMarketPackagesProjectSELECT ElementID, ProjectStatus from qryArchElementsSELECT tblElements.ElementID, tblElements.ElementStatus FROM tblElements, tblApplicationStatus WHERE (((tblApplicationStatus.CurrentArchitecture)=-1) AND ((tblElements.InRegion)=Yes)) SELECT qryArchFlowTriplets.DestinationElementID AS ElementID FROM qryArchFlowTripletsSELECT qryArchFlowTriplets.SourceElementID AS ElementID FROM qryArchFlowTriplets tblProjectElements.ProjectID=tblApplicationStatus.CurrentArchitectureSELECT tblAgreements.AgreementID from tblAgreements, tblApplicationStatus WHERE tblApplicationStatus.CurrentArchitecture=-1SELECT tblAgreementsProjects.AgreementID FROM tblAgreementsProjects INNER JOIN tblApplicationStatus ON tblAgreementsProjects.ProjectID = tblApplicationStatus.CurrentArchitecture (((qryFilteredMarketPackageInterconnect.MinOfMPFilterShow)=True) AND ((tblTmpSelectedElements_1.ElementShow)=True) AND ((tblFilterFlowDeployment.[Select])=True) AND ((qryFilteredElements.ElementShow)=True) AND ((qryFilteredElements_1.ElementShow)=True) AND ((qryFilteredInteconnectTypes.InterconnectShow)=True)) OR (((qryFilteredMarketPackageInterconnect.MinOfMPFilterShow)=True) AND ((tblFilterFlowDeployment.[Select])=True) AND ((qryFilteredElements.ElementShow)=True) AND ((qryFilteredElements_1.ElementShow)=True) AND ((qryFilteredInteconnectTypes.InterconnectShow)=True) AND ((tblTmpSelectedElements.ElementShow)=True))qryFilteredInteconnectTypes.SourceElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredInteconnectTypes.DestinationElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredMarketPackageInterconnect.SourceElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredMarketPackageInterconnect.DestinationElementID = qryAPInterconnectsBasicMin.DestinationElementIDEfH* rT6 ~ ` B $ l &  h $ g =   k9y[=bf ^@"f<tV.qryStakeholderRolesExpandedGGG .qryArchElementsRegionOrProjectMMM . G. . G-qryArchElementsRegionOrProjecttblStakeholderRoles@VsM -B@ V g-tblStakeholderRoles777 -qryArchElementsRegionOrProjectMMM - G- - G,tblStakeholderArchtblApplicationStatus@ Vi]5 ,"tblStakeholderArch.StakeholderID? g,tblApplicationStatus999 ,tblStakeholderArch555 , , G+tblApplicationStatustblRRAreaArchitectures@ Vqe9 +!tblRRAreaArchitectures.RRAreaID> g+tblRRAreaArchitectures=== +tblApplicationStatus999 + + G*V@ V '*tblMarketPackageElementsqryArchElementsRegionOrProject@ V}A *qryArchMarketPackagestblMarketPackageElements@Vwk; *D@V g*P@V g*qryArchElementsRegionOrProjectMMM *tblMarketPackageElementsAAA *qryArchMarketPackages;;; * * G)T@V ')tblMarketPackagestblRegionalServices@VeY3 )!tblMarketPackages.MarketPackage> g)tblRegionalServices777 )tblMarketPackages333 ) G) ) G(tblApplicationStatustblMarketPackageProjects@Vui9 (L@S g(P@ S g(tblMarketPackageProjectsAAA (tblApplicationStatus999 ( ( G'X7YZ_____2T@ S1% 7'X7YZ_____1@V1% 7' G'  G' ' G&X7YZ_____2f@V1% 7&X7YZ_____1@V1% 7& G&  G& & G%X7YZ_____2h@ S1% 7%X7YZ_____1t@ S1% 7% G%  G% % G$X7YZ_____2@ S1% 7$X7YZ_____1@S1% 7OY @ @ @ @ @ @ @ @ @ @ @ @ @ @MMM M M  M M MMMMMMMMMMMMM M MMMMM M!M"M#M$M%M&M'M(M)M*M+M, M- M.MM/M1M2QQQ Q QM0 Q Q Q Q Q Q!Q !Q !Q!Q!Q!Q!Q!Q!Q!Q!Q! Q!Q!Q!Q!Q!Q!Q!Q!Q!Q !Q!!Q"!Q#!Q$! Q%! Q&!Q'!Q "Q("Q*"Q+"Q,"Q-"Q)#Q.#Q0#Q1#Q2#Q3#Q4#Q/$Q5$Q7$Q8$T$T$Q6%T%T%T%T%T%T&T&T &T &T &T &T 'T'T'T'T'T'T(T(T(T(T(T(T(T)T)T)T)T)T )T!)T")T*T#*T%*T&*T'*T(*T)*T**T+*T,*T$+T-+T/+T0+T1+T2+T.,T3,T5,T6,T7,T8,T4-T9-T;-T<-T=-T>-T?-T:.T@.TB.TC.TD.W.W.TA/W/W/W/W/W/W/W /W0W 0W 0W 0W0W0W 1W1W1W1W1W1W1W2W2W2W2W2W2W2W2W2W 2W!2W"2W#2W$2W%2W&2W'2W(2WLVALZ \<T"0Z|tblStakeholderRoles.ElementID=qryArchElementsRegionOrProject.ElementIDqryArchStakeholders.StakeholderIDqryArchElementsRegionOrProject.ElementID=qryStakeholderRolesExpanded.ElementIDqryStakeholderRolesExpanded.StakeholderIDqryArchElementsRegionOrProject.ElementID=tblStakeholderRoles.ElementIDtblStakeholderRoles.StakeholderIDtblStakeholderArch.ArchitectureID=tblApplicationStatus.CurrentArchitecturetblApplicationStatus.CurrentArchitecture=tblRRAreaArchitectures.ArchitectureID(((tblMarketPackageElements.[Select])=Yes))tblMarketPackageElements.ElementID=qryArchElementsRegionOrProject.ElementIDqryArchMarketPackages.MarketPackageID=tblMarketPackageElements.MarketPackageIDtblMarketPackageElements.ElementIDtblMarketPackageElements.MarketPackageID(((tblRegionalServices.Applicability)<>0))tblMarketPackages.MarketPackageID=tblRegionalServices.MarketPackageIDtblApplicationStatus.CurrentArchitecture=tblMarketPackageProjects.ProjectIDSELECT MarketPackageID,Applicability as ProjectStatus FROM tblRegionalServices, tblApplicationStatus WHERE (((tblRegionalServices.Applicability)<>0) AND ((tblApplicationStatus.CurrentArchitecture)=-1)) SELECT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.FlowID, tblProjectArchitecture.ProjectFlowStatus AS Status FROM tblApplicationStatus INNER JOIN (tblRegionalArchitecture INNER JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID) ON tblApplicationStatus.CurrentArchitecture = tblProjectArchitecture.ProjectIDSELECT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.FlowID, tblRegionalArchitecture.FlowStatus AS Status FROM tblRegionalArchitecture, tblApplicationStatus WHERE (((tblRegionalArchitecture.InRegionalArchitecture)=Yes) AND ((tblApplicationStatus.CurrentArchitecture)=-1)) H9:v f x : X   L  Z0",lf&hJ,4qryASResponseFlowsNotIncludedRegionWWW 4 G4 4 G3qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@XY 3qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@XY 3qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@XY 3T@X g3d@X g3tblRegionalArchitecture??? 3qryASResponseFlowsNotIncludedProjectYYY 3 3 G2tblRegionalArchitecturetblProjectArchitecture@Xwk? 2tblElementMapping_1tblFlowRelationshipsx@Xk_7 2tblElementMapping_1tblRegionalArchitecture@Xqe7 2tblRegionalArchitecturetblFlowRelationships@Xsg? 2tblElementMappingtblFlowRelationshipsp@ Xg[3 2tblElementMappingtblRegionalArchitecture@ Xma3 2D@ X g2L@ X g2"tblProjectArchitecture.ProjectID? g2\@ X g2F@X g2D@X g2X@X g2N@X g2tblProjectArchitecture=== 2tblFlowRelationships999 2tblRegionalArchitecture??? 2tblElementMapping333 2tblElementMappingtblElementMapping_1YY3 2 2 G1X@X '1H@X g1tblProjectArchitecture.*7 g1tblProjectArchitecture=== 1 G1 1 G0X7YZ_____2T@X1% 70X7YZ_____1@X1% 70 G0  G0 0 G/qryArchStakeholderstblStakeholderRoles@Xi]7 /tblStakeholderRolesqryArchElementsRegionOrProject@Vs7 /B@V g/qryArchElementsRegionOrProjectMMM /tblStakeholderRoles777 /qryArchStakeholders777 / / G.qryArchElementsRegionOrProjectqryStakeholderRolesExpanded@VM .R@V gLVALz T V  p $ Z h \` Zf*qryASRequestFlowsNotIncludedProject.FlowID = tblRegionalArchitecture.FlowIDqryASRequestFlowsNotIncludedProject.ProjectIDtblRegionalArchitecture.RegionalFlowID[qryASResponseFlowsNotIncludedRegion].[FlowIDRequest]=[tblRegionalArchitecture].[FlowID][qryASResponseFlowsNotIncludedRegion].[DestinationElementID]=[tblRegionalArchitecture].[SourceElementID][qryASResponseFlowsNotIncludedRegion].[SourceElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASResponseFlowsNotIncludedProject].[SourceElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASResponseFlowsNotIncludedProject].[DestinationElementID]=[tblRegionalArchitecture].[SourceElementID][qryASResponseFlowsNotIncludedProject].[FlowIDRequest]=[tblRegionalArchitecture].[FlowID][tblRegionalArchitecture].[RegionalFlowID][qryASResponseFlowsNotIncludedProject].[ProjectID]tblRegionalArchitecture.RegionalFlowID=tblProjectArchitecture.RegionalFlowIDtblElementMapping_1.EntityID=tblFlowRelationships.EntityIDIFtblElementMapping_1.ElementID=tblRegionalArchitecture.DestinationElementIDtblFlowRelationships.FlowIDRequest=tblRegionalArchitecture.FlowIDtblElementMapping.EntityID=tblFlowRelationships.EntityIDtblElementMapping.ElementID=tblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.FlowStatustblRegionalArchitecture.RegionalFlowIDtblRegionalArchitecture.InRegionalArchitecturetblFlowRelationships.FlowIDResponsetblFlowRelationships.FlowIDRequesttblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementID((([tblProjectArchitecture].[ProjectID])=0))[tblProjectArchitecture].[ProjectID]SELECT * FROM qryArchStakeholdersConnectedSELECT tblStakeholderGroups.StakeholderID FROM qryArchStakeholdersConnected INNER JOIN tblStakeholderGroups ON qryArchStakeholdersConnected.StakeholderID = tblStakeholderGroups.GroupStakeholderID qryArchStakeholders.StakeholderID=tblStakeholderRoles.StakeholderIDU^ @ @ @ @ @ @ @ @ @ @ @ @ @ @%T%T%T%T&T&T &T &T &T &T 'T'T'T'T'T'T(T(T(T(T(T(T(T)T)T)T)T)T )T!)T")T*T#*T%*T&*T'*T(*T)*T**T+*T,*T$+T-+T/+T0+T1+T2+T.,T3,T5,T6,T7,T8,T4-T9-T;-T<-T=-T>-T?-T:.T@.TB.TC.TD.W.W.TA/W/W/W/W/W/W/W /W0W 0W 0W 0W0W0W 1W1W1W1W1W1W1W2W2W2W2W2W2W2W2W2W 2W!2W"2W#2W$2W%2W&2W'2W(2W)2W*2W+2W3W,3W.3W/3W03W13W23W33W43W-4W54W74W84Z4Z4Z4Z4Z4W65Z5Z5Z5Z 5Z 5Z 5Z 5Z 5Z5Z5Z5Z6Z6Z6Z6Z6Z6Z6Z6Z6Z6Z7Z7Z7Z7Z7Z 7Z!7Z"7Z#7Z$7Z%7Z&7Z'7Z(7Z8Z)8Z+8Z,8Z-8\8\8\8\8\8\8\8\8\8\ 8\ 8 \ 8 \ 8 \ 8\8\8\8\8\8\8\8\8\8Z*9\9\9\9\9\9\9\9\9\ 9\!9\"9\#9\$9\%9\&9\'9\(9 \)9 \*9\+9\#.* P 2  H z > v X :  nu=eg73iK 8tblElementstblElements_1AA' 8tblFlows!!! 8tblFlowstblFlows_155! 8 8 G7B@ [ '7qryASResponseFlowsAlltblRegionalArchitecture@ [ui; 7qryASResponseFlowsAlltblRegionalArchitecture@ [ui; 7qryASResponseFlowsAlltblRegionalArchitecture@ [ui; 7FlowStatus"qryASResponseFlowsAll.FlowStatusS% w7FlowIDF@ [) w7DestinationElementIDJ@[E9 w7SourceElementIDT@[;/ w7tblRegionalArchitecture??? 7qryASResponseFlowsAll;;; 7 G7tblRegionalArchitecture??? O7 7 G6qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@[U 6qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@[U 6qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@[U 6tblRegionalArchitecture.InRegionalArchitectureYes~m w6tblRegionalArchitecture.FlowStatusb@[aU w6tblRegionalArchitecture??? 6qryASRequestFlowsNotIncludedRegionUUU 6 G6 6 G5z@[ '5qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@[W 5qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@[W 5qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@XW 5ProjectIDZ@X/# w5RegionalFlowIDL@X9- w5tblRegionalArchitecture??? 5qryASRequestFlowsNotIncludedProjectWWW 5 G5tblProjectArchitecture=== O5 5 G4qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@XW 4qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@XW 4qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@XW 4tblRegionalArchitecture.InRegionalArchitectureNo}m w4tblRegionalArchitecture??? LVAL2x ` | T n&bz,tblRegionalArchitecture.SourceElementID(((qryASRequestFlowsAll.ProjectID) Is Null) And ((qryASRequestFlowsAll.SourceElementID) Is Null) And ((qryASRequestFlowsAll.DestinationElementID) Is Null) And ((qryASRequestFlowsAll.FlowIDRequest) Is Null))tblFlows_1.FlowID=qryASResponseFlowsAll.FlowIDResponsetblFlows.FlowID=qryASResponseFlowsAll.FlowIDRequesttblElements_1.ElementID=qryASResponseFlowsAll.SourceElementIDtblElements.ElementID=qryASResponseFlowsAll.DestinationElementIDqryASRequestFlowsAll.SourceElementID=qryASResponseFlowsAll.DestinationElementIDqryASRequestFlowsAll.DestinationElementID=qryASResponseFlowsAll.SourceElementIDqryASRequestFlowsAll.FlowIDRequest=qryASResponseFlowsAll.FlowIDRequestqryASRequestFlowsAll.ProjectID=qryASResponseFlowsAll.ProjectIDqryASResponseFlowsAll.FlowIDResponse(((tblRegionalArchitecture.SourceElementID) Is Null) AND ((tblRegionalArchitecture.DestinationElementID) Is Null) AND ((tblRegionalArchitecture.FlowID) Is Null))qryASResponseFlowsAll.SourceElementID=tblRegionalArchitecture.DestinationElementIDqryASResponseFlowsAll.DestinationElementID=tblRegionalArchitecture.SourceElementIDqryASResponseFlowsAll.FlowIDRequest=tblRegionalArchitecture.FlowIDqryASResponseFlowsAll.FlowIDRequestqryASResponseFlowsAll.SourceElementIDqryASResponseFlowsAll.DestinationElementID[qryASRequestFlowsNotIncludedRegion].[FlowID]=[tblRegionalArchitecture].[FlowID][qryASRequestFlowsNotIncludedRegion].[DestinationElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASRequestFlowsNotIncludedRegion].[SourceElementID]=[tblRegionalArchitecture].[SourceElementID][qryASRequestFlowsNotIncludedRegion].[FlowStatus](((qryASRequestFlowsNotIncludedProject.ProjectID)=[Project]))qryASRequestFlowsNotIncludedProject.SourceElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsNotIncludedProject.DestinationElementID = tblRegionalArchitecture.DestinationElementIDX0>  B  L 9 A [ !=E[d".9tblFlowstblRegionalArchitecture`@][O! 9tblElementstblRegionalArchitecture~@]aU' 9qryASResponseFlowsAlltblRegionalArchitecture@]ui; 9qryASResponseFlowsAlltblRegionalArchitecture@]ui; 9qryASResponseFlowsAlltblRegionalArchitecture@]ui; 9 CorrespondingFlowNametblFlows_1.FlowName\;; o9 CorrespondingFlowIDtblFlows_1.FlowIDV77 o9H@] g9"qryASResponseFlowsAll.FlowStatus? g9tblFlows.FlowName0 g9DestinationNametblElements_1.ElementNameV// o9SourceNametblElements.ElementNameJ%% o9 tblRegionalArchitecture.FlowID= g9X@] g9N@[ g9tblRegionalArchitecture??? 9qryASResponseFlowsAll;;; 9tblElements''' 9tblFlows!!! 9tblElementstblElements_1AA' 9tblFlowstblFlows_155! 9 G9 G9 9 G8@[ '8tblFlows_1qryASResponseFlowsAlll@[[O% 8tblFlowsqryASResponseFlowsAllf@[WK! 8tblElements_1qryASResponseFlowsAllz@[aU+ 8tblElementsqryASResponseFlowsAll@[]Q' 8qryASRequestFlowsAllqryASResponseFlowsAll@[oc9 8qryASRequestFlowsAllqryASResponseFlowsAll@[oc9 8qryASRequestFlowsAllqryASResponseFlowsAll@[oc9 8qryASRequestFlowsAllqryASResponseFlowsAll|@[oc9 8 !qryASResponseFlowsAll.ProjectID> g8 "qryASResponseFlowsAll.FlowStatus? g8 CorrespondingFlowNametblFlows_1.FlowName\;; o8CorrespondingFlowIDtblFlows_1.FlowIDV77 o8H@[ g8tblFlows.FlowName0 g8tblFlows.FlowID. g8DestinationNametblElements_1.ElementNameV// o8DestinationElementIDtblElements_1.ElementID^99 o8SourceNametblElements.ElementNameJ%% o8SourceElementIDtblElements.ElementIDR// o8qryASResponseFlowsAll;;; 8qryASRequestFlowsAll999 8tblElements''' xLVAL` : j X6ThfJ[qryASRequestFlowsNotIncludedProject].[SourceElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASRequestFlowsNotIncludedProject].[ProjectID][tblRegionalArchitecture].[RegionalFlowID]tblRegionalArchitecture.RegionalFlowID=tblProjectArchitecture.RegionalFlowIDtblFlowRelationships.FlowIDResponse=tblRegionalArchitecture.FlowIDtblElementMapping_1.ElementID=tblRegionalArchitecture.SourceElementIDtblElementMapping.ElementID=tblRegionalArchitecture.DestinationElementIDtblElementMapping_1.EntityID=tblFlowRelationships.EntityIDIFtblElementMapping.EntityID=tblFlowRelationships.EntityIDtblRegionalArchitecture.FlowStatustblRegionalArchitecture.RegionalFlowIDtblRegionalArchitecture.InRegionalArchitecturetblFlowRelationships.FlowIDRequesttblFlowRelationships.FlowIDResponsetblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementID(((qryASRequestFlowsNotIncludedProject.ProjectID)=[Project]) AND ((tblRegionalArchitecture.FlowStatus)=0))qryASRequestFlowsNotIncludedProject.FlowID=tblRegionalArchitecture.FlowIDqryASRequestFlowsNotIncludedProject.DestinationElementID=tblRegionalArchitecture.DestinationElementIDqryASRequestFlowsNotIncludedProject.SourceElementID=tblRegionalArchitecture.SourceElementIDqryASRequestFlowsNotIncludedProject.flowstatus(((tblRegionalArchitecture.InRegionalArchitecture)=False) AND ((qryASResponseFlowsAll.InRegionalArchitecture)=True))tblElements_1.ElementID = tblRegionalArchitecture.DestinationElementIDtblFlows_1.FlowID = qryASResponseFlowsAll.FlowIDResponsetblFlows.FlowID = tblRegionalArchitecture.FlowIDtblElements.ElementID = tblRegionalArchitecture.SourceElementIDqryASResponseFlowsAll.FlowIDRequest = tblRegionalArchitecture.FlowIDqryASResponseFlowsAll.DestinationElementID = tblRegionalArchitecture.SourceElementIDqryASResponseFlowsAll.SourceElementID = tblRegionalArchitecture.DestinationElementIDqryASResponseFlowsAll.FlowIDResponsetblRegionalArchitecture.DestinationElementIDYa @ @ @ @ @ @ @ @ @ @ @ @ @ @2W*2W+2W3W,3W.3W/3W03W13W23W33W43W-4W54W74W84Z4Z4Z4Z4Z4W65Z5Z5Z5Z 5Z 5Z 5Z 5Z 5Z5Z5Z5Z6Z6Z6Z6Z6Z6Z6Z6Z6Z6Z7Z7Z7Z7Z7Z 7Z!7Z"7Z#7Z$7Z%7Z&7Z'7Z(7Z8Z)8Z+8Z,8Z-8\8\8\8\8\8\8\8\8\8\ 8\ 8 \ 8 \ 8 \ 8\8\8\8\8\8\8\8\8\8Z*9\9\9\9\9\9\9\9\9\ 9\!9\"9\#9\$9\%9\&9\'9\(9 \)9 \*9\+9\,9\-9\.9\/9_9_9_9\:_:_:_:_:_:_ :_ :_ :_ :_;_ ;_;_;_;_;_;_;_;_;_;_;_;_;_;_;_;_;_;_ ;_!;_<_"<_$<_%<_&<_'<_(<_)<_*<_#=_+=_-=_.=_/=_0=_1=`=`=`=_,>`>`>`>`>`>` >` >` >` >` >`>`?`?`?`?`?`?`?`?`?`?`@`@`@`@`@`@`@` @`!@`"@`#@`$@`%@`&@`A`'A`)A`*A`+A`,A`-A`.AhAhAhAhAhA`(,2&> H b D X n D  zPdlhJ,|R(N0t(=tblRegionalArchitecture.InRegionalArchitectureNo}m w=tblRegionalArchitecture??? =qryASRequestFlowsNotIncludedRegionUUU = G= G= = G<qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@?W <qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@?W <qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@]W <b@] g<T@] g<tblRegionalArchitecture??? <qryASRequestFlowsNotIncludedProjectWWW < < G;tblRegionalArchitecturetblProjectArchitecture@]wk? ;tblFlowRelationshipstblRegionalArchitecture@]sg9 ;tblElementMapping_1tblRegionalArchitecture@]qe7 ;tblElementMappingtblRegionalArchitecture@]ma3 ;tblElementMapping_1tblFlowRelationshipsx@]k_7 ;tblElementMappingtblFlowRelationshipsp@]g[3 ;D@] g;L@] g;"tblProjectArchitecture.ProjectID? g;\@] g;D@] g;F@] g;X@] g;N@] g;tblProjectArchitecture=== ;tblRegionalArchitecture??? ;tblFlowRelationships999 ;tblElementMapping333 ;tblElementMappingtblElementMapping_1YY3 ; ; G:@] ':qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@ ]W :qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@ ]W :qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@ ]W :tblRegionalArchitecture.FlowStatus\@ ]aU w:tblRegionalArchitecture??? :qryASRequestFlowsNotIncludedProjectWWW : G: : G9@ ] '9tblElements_1tblRegionalArchitecture@]eY+ 9tblFlows_1qryASResponseFlowsAllp@][O% 4/d, " T  t J ,  @ G mO15e\> b.AqryASResponseFlowsAll;;; AqryASRequestFlowsAll999 AtblElements''' AtblElementstblElements_1AA' AtblFlows!!! AtblFlowstblFlows_155! A A G@B@? '@qryASRequestFlowsAlltblRegionalArchitecture@?sg9 @qryASRequestFlowsAlltblRegionalArchitecture@?sg9 @qryASRequestFlowsAlltblRegionalArchitecture@?sg9 @FlowStatus!qryASRequestFlowsAll.FlowStatusR% w@FlowIDF@?) w@DestinationElementIDH@?E9 w@SourceElementIDR@?;/ w@tblRegionalArchitecture??? @qryASRequestFlowsAll999 @ G@tblRegionalArchitecture??? O@ @ G?qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@?W ?qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@ ?W ?qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@ ?W ?tblRegionalArchitecture.InRegionalArchitectureYes~m w?tblRegionalArchitecture.FlowStatusd@ ?aU w?tblRegionalArchitecture??? ?qryASResponseFlowsNotIncludedRegionWWW ? G? ? G>|@ ? '>qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@ ?Y >qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@?Y >qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@?Y >ProjectID\@?/# w>RegionalFlowIDL@?9- w>tblRegionalArchitecture??? >qryASResponseFlowsNotIncludedProjectYYY > G>tblProjectArchitecture=== O> > G=qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@?U =qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@?U =qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@?U ^p @ @ @ @ @ @ @ @ @ @ @ @ @ @9\-9\.9\/9_9_9_9\:_:_:_:_:_:_ :_ :_ :_ :_;_ ;_;_;_;_;_;_;_;_;_;_;_;_;_;_;_;_;_;_ ;_!;_<_"<_$<_%<_&<_'<_(<_)<_*<_#=_+=_-=_.=_/=_0=_1=`=`=`=_,>`>`>`>`>`>` >` >` >` >` >`>`?`?`?`?`?`?`?`?`?`?`@`@`@`@`@`@`@` @`!@`"@`#@`$@`%@`&@`A`'A`)A`*A`+A`,A`-A`.AhAhAhAhAhAhAhAhA hA h A h Ah Ah Ah AhAhAhAhAhAhA`(BhBhBhBhBhBhBhBhBhBhBhBh Bh!Bh"Bh#Bh$Bh%B h&B h'Bh(Bh)Bh*Bh+Bh,Bh-Bh.Bh/BhCh0CdCdCdCdCdCdCdCdCdDd Dd Dd Dd DdDdDdDdDdDdDdDdDdDdDdDdDdDdDdDdDdDdDd Dd!Dd"Dd Ed#Ed%Ed&Ed'Ed(Ed$Fd)Fd+Fd,Fd-Fd.Fd/Fd0Fd1Fd2Fd3Fd4F d5F d6F d7F gFgFgFgFd*GgGg~LVALbT v  j  R .b2zJ\qryBatchSelectInterfacesBasic.SourceElementID = qryFilteredElements.ElementIDqryBatchSelectInterfacesBasic.SourceElementID = tblTmpBatch.ElementIDqryBatchSelectInterfacesBasic.DestinationElementIDqryBatchSelectInterfacesBasic.SourceElementID(((qryASResponseFlowsNotIncludedProject.ProjectID)=[Project]) AND ((tblRegionalArchitecture.FlowStatus)=0))qryASResponseFlowsNotIncludedProject.SourceElementID=tblRegionalArchitecture.SourceElementIDqryASResponseFlowsNotIncludedProject.DestinationElementID=tblRegionalArchitecture.DestinationElementIDqryASResponseFlowsNotIncludedProject.FlowID=tblRegionalArchitecture.FlowIDqryASResponseFlowsNotIncludedProject.FlowStatus(((tblRegionalArchitecture.InRegionalArchitecture)=False) AND ((qryASRequestFlowsAll.InRegionalArchitecture)=True))tblElements_1.ElementID = tblRegionalArchitecture.DestinationElementIDtblFlows_1.FlowID = qryASRequestFlowsAll.FlowIDRequesttblFlows.FlowID = tblRegionalArchitecture.FlowIDtblElements.ElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsAll.SourceElementID = tblRegionalArchitecture.DestinationElementIDqryASRequestFlowsAll.DestinationElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsAll.FlowIDResponse = tblRegionalArchitecture.FlowIDqryASRequestFlowsAll.FlowIDRequesttblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementID(((qryASResponseFlowsAll.ProjectID) Is Null) And ((qryASResponseFlowsAll.SourceElementID) Is Null) And ((qryASResponseFlowsAll.DestinationElementID) Is Null) And ((qryASResponseFlowsAll.FlowIDRequest) Is Null))tblFlows_1.FlowID=qryASRequestFlowsAll.FlowIDRequesttblFlows.FlowID=qryASRequestFlowsAll.FlowIDResponsetblElements_1.ElementID=qryASRequestFlowsAll.SourceElementIDtblElements.ElementID=qryASRequestFlowsAll.DestinationElementIDqryASRequestFlowsAll.FlowIDResponse=qryASResponseFlowsAll.FlowIDResponseqryASRequestFlowsAll.SourceElementID=qryASResponseFlowsAll.DestinationElementID_OaI  Mj " IS #G` E}'AT````HB ZR@HB ZR@qryCusTempAppendRegion`Wؐ@4qo3@qryCusTempAppendRegionInterconnectSupport@P|@Qtttttttr @_3Vؐ@Wxll```````^ @L@nIr.@[Nr.@qryCurrentArchExcludedStandardGroups@?@>vvjjjjjjjh @K.@0.@qryCurrentArchExcludedFlowStandards@=@>tthhhhhhhf @J%9@S)9@qryCurrentArchExcludedElementFlowStandardsW@=@<vvvvvvvt @I+L.@,0L.@qryCurrentArchElementsNotInRegionC@=@<|ppdddddddb @$Gz.@ǜ.@qryCurrentArchElementFlowStandardsHelper @;x @:~~rrrrrrrp @F Ӈ.@ P.@qryCurrentArchElementFlowStandardsk@8@9~rrfffffffd @EnGa@nGa@qryBatchSelectInterfacesBasic@8`@9thh\\\\\\\Z @DKGa@KGa@qryBatchSelectInterfaces'@8@ @9j^^RRRRRRRP @CzY;n@,Fn@0qryASResponseFlowsSetStatusProject*@8@7~rrfffffffd @$8^d | ^ @ " $ J  G  w2."nP2z\>^4 b8F @f gF b@f gF @f gF`@f gF`@f gFh@f gFl@f gFl@ e gFX@ e gFf@ e gFn@e gFqryCurrentArchExcludedElementFlowStandardseee FqryCurrentArchElementFlowStandardsHelperaaa F F GEX7YZ_____2@e1% 7EX7YZ_____1@e1% 7E GE  GE E GD@e 'DtblElementsqryBatchSelectInterfacesBasic@ema' DtblElements_1qryBatchSelectInterfacesBasic@eqe+ DqryBatchSelectInterfacesBasictblFilterFlowDeployment@eyK DqryBatchSelectInterfacesBasictblTmpBatch_1@eqeK DqryBatchSelectInterfacesBasicqryFilteredElements_1@euK DqryBatchSelectInterfacesBasicqryFilteredElements@b}qK DqryBatchSelectInterfacesBasictblTmpBatch@bmaK DtblTmpBatch_1.ElementShow8 gDtblTmpBatch.ElementShow6 gDDestinationNametblElements_1.ElementNameV// oDd@b gDSourceNametblElements.ElementNameJ%% oDZ@b gDtblElementstblElements_1AA' DtblElements''' DqryBatchSelectInterfacesBasicKKK DtblTmpBatchtblTmpBatch_1AA' DtblTmpBatch''' DqryFilteredElementsqryFilteredElements_1aa7 DqryFilteredElements777 DtblFilterFlowDeployment??? D GD GD D GC@b 'CqryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@bY CqryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@bY CqryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@bY CtblRegionalArchitecture.FlowStatus^@baU wCtblRegionalArchitecture??? CqryASResponseFlowsNotIncludedProjectYYY C GC LVAL X" T p bqryCurrentArchElementFlowStandardsHelper.StandardTitleqryCurrentArchElementFlowStandardsHelper.SDOqryCurrentArchElementFlowStandardsHelper.StandardIDqryCurrentArchElementFlowStandardsHelper.RegionalFlowIDSELECT DISTINCT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, tblStatus.StatusID FROM (tblStatus RIGHT JOIN tblRegionalArchitecture ON tblStatus.StatusID = tblRegionalArchitecture.FlowStatus) LEFT JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID WHERE ((((tblRegionalArchitecture.InRegionalArchitecture=Yes) AND ([Arch]=-1)) OR ([Arch]=[ProjectID])) AND (DestinationElementID<SourceElementID))SELECT DISTINCT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, tblStatus.StatusID FROM (tblStatus RIGHT JOIN tblRegionalArchitecture ON tblStatus.StatusID = tblRegionalArchitecture.FlowStatus) LEFT JOIN tblProjectArchitecture ON tblRegionalArchitecture.RegionalFlowID = tblProjectArchitecture.RegionalFlowID WHERE ((((tblRegionalArchitecture.InRegionalArchitecture=Yes) AND ([Arch]=-1)) OR ([Arch]=[ProjectID])) AND (SourceElementID<DestinationElementID)) (((qryFilteredElements.ElementShow)=Yes) AND ((qryFilteredElements_1.ElementShow)=Yes) AND ((tblTmpBatch.ElementShow)=Yes) AND ((tblFilterFlowDeployment.[Select])=Yes)) OR (((qryFilteredElements.ElementShow)=Yes) AND ((qryFilteredElements_1.ElementShow)=Yes) AND ((tblTmpBatch_1.ElementShow)=Yes) AND ((tblFilterFlowDeployment.[Select])=Yes))tblElements.ElementID = qryBatchSelectInterfacesBasic.SourceElementIDtblElements_1.ElementID = qryBatchSelectInterfacesBasic.DestinationElementIDqryBatchSelectInterfacesBasic.StatusID = tblFilterFlowDeployment.FlowDeploymentqryBatchSelectInterfacesBasic.DestinationElementID = tblTmpBatch_1.ElementIDqryBatchSelectInterfacesBasic.DestinationElementID = qryFilteredElements_1.ElementIDLVAL!,l  j  L Tb>(J(((tblElements.ParentID)=0) AND ((tblElements.InRegion)=False))tblStatus.StatusID=qryArchElements.ProjectStatusqryArchElements.ElementID=tblElements.ElementIDtblElements_1.ElementID=tblElements.ParentIDtblStatus.StatusID=qryArchElements.ProjectStatusqryArchElements.ElementID=tblElements.ElementID(((qryStdTempAllStandards.Include)=Yes))tblRegionalArchitecture.RegionalFlowID=tblProjectArchitecture.RegionalFlowIDtblApplicationStatus.CurrentArchitecture=tblProjectArchitecture.ProjectIDtblElements.ElementID=tblRegionalArchitecture.SourceElementIDtblFlowStandards.DestinationEntityID=tblElementMapping_1.EntityIDqryStdTempAllStandards.StandardID=tblFlowStandards.StandardIDtblRegionalArchitecture.DestinationElementID=tblElements_1.ElementIDtblFlowStandards.FlowID=tblFlows.FlowIDtblElementMapping.ElementID=tblRegionalArchitecture.SourceElementIDtblFlowStandards.FlowID=tblRegionalArchitecture.FlowIDtblFlowStandards.SourceEntityID=tblElementMapping.EntityIDqrystdtempAllstandards.userdefined Or tblFlowStandards.UserDefinedqryStdTempAllStandards.StandardDocIDqryStdTempAllStandards.StandardTitleqryStdTempAllStandards.StandardIDtblRegionalArchitecture.RegionalFlowID(((qryCurrentArchExcludedElementFlowStandards.RegionalFlowID) Is Null))qryCurrentArchElementFlowStandardsHelper.StandardID=qryCurrentArchExcludedElementFlowStandards.StandardIDqryCurrentArchElementFlowStandardsHelper.RegionalFlowID=qryCurrentArchExcludedElementFlowStandards.RegionalFlowIDqryCurrentArchElementFlowStandardsHelper.ShowqryCurrentArchElementFlowStandardsHelper.tblElements_1.ElementNameqryCurrentArchElementFlowStandardsHelper.FlowNameqryCurrentArchElementFlowStandardsHelper.tblElements.ElementNameqryCurrentArchElementFlowStandardsHelper.IsGroupqryCurrentArchElementFlowStandardsHelper.IncludeqryCurrentArchElementFlowStandardsHelper.UserDefinedqryCurrentArchElementFlowStandardsHelper.StandardDocID<4: 8 n @ F b 8  G  Kg!;Oew6j HtblStatusqryArchElements`@fMA# HqryArchElementstblElements^@fQE/ HtblStatus.StatusName3 gHqryArchElements.ProjectStatus< gHtblElements.ElementName6 gHtblElements.ElementID4 gHtblElements''' HqryArchElements/// HtblStatus### HtblElementstblElements_1AA' H H GGP@f 'G tblRegionalArchitecturetblProjectArchitecture@fwk? G tblApplicationStatustblProjectArchitecture@fqe9 GtblElementstblRegionalArchitecturez@faU' GtblFlowStandardstblElementMapping_1@fcW1 GqryStdTempAllStandardstblFlowStandardsz@fi]= GtblRegionalArchitecturetblElements_1@feY? GtblFlowStandardstblFlowsN@fMA1 GtblElementMappingtblRegionalArchitecture@fma3 GtblFlowStandardstblRegionalArchitecturel@fk_1 GtblFlowStandardstblElementMappingt@f_S1 G ShowYes* oG tblElements_1.ElementName8 gG tblFlows.FlowName0 gG tblElements.ElementName6 gG qryStdTempAllStandards.IsGroup= gGIncludeYes0 oGUserDefined@f3'' oGH@f gGH@ f gGqryStdTempAllStandards.SDO9 gGB@ f gGL@ f gG tblProjectArchitecture=== G tblApplicationStatus999 GtblElementMappingtblElementMapping_1YY3 GtblElementstblElements_1AA' GtblFlows!!! GtblRegionalArchitecture??? GtblElementMapping333 GtblFlowStandards111 GqryStdTempAllStandards=== GtblElements''' G GG G GF@ f 'FqryCurrentArchElementFlowStandardsHelperqryCurrentArchExcludedElementFlowStandards@ fa FqryCurrentArchElementFlowStandardsHelperqryCurrentArchExcludedElementFlowStandards@fa F Z@f g 1J|A , y  ! S iK Ys)o2Zqq5{C GB@b 'BtblElements_1tblRegionalArchitecture@beY+ BtblFlows_1qryASRequestFlowsAlll@bYM% BtblFlowstblRegionalArchitecture`@b[O! BtblElementstblRegionalArchitecture~@ baU' BqryASRequestFlowsAlltblRegionalArchitecture@ bsg9 BqryASRequestFlowsAlltblRegionalArchitecture@ bsg9 BqryASRequestFlowsAlltblRegionalArchitecture@ bsg9 B CorrespondingFlowNametblFlows_1.FlowName\;; oB CorrespondingFlowIDtblFlows_1.FlowIDV77 oBD@ b gB!qryASRequestFlowsAll.FlowStatus> gBtblFlows.FlowName0 gBDestinationNametblElements_1.ElementNameV// oBSourceNametblElements.ElementNameJ%% oB tblRegionalArchitecture.FlowID= gBX@b gBN@b gBtblRegionalArchitecture??? BqryASRequestFlowsAll999 BtblElements''' BtblFlows!!! BtblElementstblElements_1AA' BtblFlowstblFlows_155! B GB GB B GA@b 'AtblFlows_1qryASRequestFlowsAllh@bYM% AtblFlowsqryASRequestFlowsAllf@bUI! AtblElements_1qryASRequestFlowsAllx@b_S+ AtblElementsqryASRequestFlowsAll~@b[O' AqryASRequestFlowsAllqryASResponseFlowsAll@boc9 AqryASRequestFlowsAllqryASResponseFlowsAll@boc9 AqryASRequestFlowsAllqryASResponseFlowsAll@?oc9 AqryASRequestFlowsAllqryASResponseFlowsAll|@?oc9 A qryASRequestFlowsAll.ProjectID= gA CorrespondingFlowNametblFlows_1.FlowName\;; oA CorrespondingFlowIDtblFlows_1.FlowIDV77 oAD@? gA!qryASRequestFlowsAll.FlowStatus> gAtblFlows.FlowName0 gAtblFlows.FlowID. gADestinationNametblElements_1.ElementNameV// oADestinationElementIDtblElements_1.ElementID^99 oASourceNametblElements.ElementNameJ%% oASourceElementIDtblElements.ElementIDR// o\LVAL~p & 0 " ~ lbSELECT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, Min(tblRegionalArchitecture.InRegionalArchitecture) AS MinOfInRegionalArchitecture, Min(tblRegionalArchitecture.LastBuild) AS MinOfLastBuild FROM tblRegionalArchitecture GROUP BY tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID (((tblElements_1.ElementName)>[tblElements].[ElementName]))qryFilteredMarketPackageInterconnect.SourceElementID = qryCusTempAppendRegionInterconnectSupport.SourceElementIDqryFilteredMarketPackageInterconnect.DestinationElementID = qryCusTempAppendRegionInterconnectSupport.DestinationElementIDqryFilteredElements_1.ElementID = qryCusTempAppendRegionInterconnectSupport.DestinationElementIDqryFilteredElements.ElementID = qryCusTempAppendRegionInterconnectSupport.SourceElementIDqryCusTempAppendRegionInterconnectSupport.DestinationElementID = qryFilteredInteconnectTypes.DestinationElementIDqryCusTempAppendRegionInterconnectSupport.SourceElementID = qryFilteredInteconnectTypes.SourceElementIDqryCusTempAppendRegionInterconnectSupport.DestinationElementID = tblElements_1.ElementIDqryCusTempAppendRegionInterconnectSupport.SourceElementID = tblElements.ElementIDMin([InterconnectShow] And [MinOfMPFilterShow] And [qryFilteredElements].[ElementShow] And [qryFilteredElements_1].[ElementShow])Min(qryCusTempAppendRegionInterconnectSupport.MinOfLastBuild)Min(qryCusTempAppendRegionInterconnectSupport.MinOfInRegionalArchitecture)(((tblElements_1.ElementName)>tblElements.ElementName) And ((tblElements.InRegion)=Yes) And ((tblElements_1.InRegion)=Yes))qryCusTempAppendRegionInterconnectSupport.DestinationElementID=tblElements_1.ElementIDqryCusTempAppendRegionInterconnectSupport.SourceElementID=tblElements.ElementIDMin(qryCusTempAppendRegionInterconnectSupport.MinOfLastBuild)Min(qryCusTempAppendRegionInterconnectSupport.MinOfInRegionalArchitecture)(((tblElements.InRegion)=Yes) AND ((tblElements_1.InRegion)=Yes)).1j'`6 8  @ z  f >8 X:dF( pR4btblProjectArchitecture=== btblRegionalArchitecture??? b b GaX7YZ_____2@k1% 7aX7YZ_____1@k1% 7a Ga  Ga a G`X7YZ_____2@k1% 7`X7YZ_____1@i1% 7` G`  G` ` G_ v@i '_ tblElements_1.ElementName8 g_ tblElements.ElementName6 g_qryFilteredMarketPackageInterconnectqryCusTempAppendRegionInterconnectSupport@iY _qryFilteredMarketPackageInterconnectqryCusTempAppendRegionInterconnectSupport@iY _qryFilteredElements_1qryCusTempAppendRegionInterconnectSupport@i; _qryFilteredElementsqryCusTempAppendRegionInterconnectSupport@ i7 _qryCusTempAppendRegionInterconnectSupportqryFilteredInteconnectTypes@ ic _qryCusTempAppendRegionInterconnectSupportqryFilteredInteconnectTypes@ ic _qryCusTempAppendRegionInterconnectSupporttblElements_1@ i}c _qryCusTempAppendRegionInterconnectSupporttblElements@ iyc _Expr1Show@i/# _MinOfMinOfLastBuildLastBuildz@iUI7 _MinOfMinOfInRegionalArchitectureInArch@ii]Q _DestinationElementtblElements_1.ElementName\5 w_SourceElementtblElements.ElementNameP+ w_qryFilteredInteconnectTypesGGG _tblElementstblElements_1AA' _tblElements''' _qryCusTempAppendRegionInterconnectSupportccc _qryFilteredElements777 _qryFilteredElementsqryFilteredElements_1aa7 _qryFilteredMarketPackageInterconnectYYY _ G_tblTempCustomize111 O_ _ G^ @i '^ tblElements_1.InRegion5 g^ tblElements.InRegion3 g^ tblElements_1.ElementName8 g^ tblElements.ElementName6 g^qryCusTempAppendRegionInterconnectSupporttblElements_1@i}c LVAL0 \ : n Dr8d tblFlows.FlowType=tblFilterFlowTypes.FlowType[SourceElementShow] And [DestinationElementShow] And [FlowStatusShow] And [FlowFuturisticShow] And [FlowTypeShow] And [MPFilterShow] And [InterconnectShow]qryFilteredMarketPackages.MPFilterShowIIf(((tblFilterFlowFuturistic.[Select]=False) And (tblFlows.FlowFuturistic=True)),False,True)qryFilteredElements_1.ElementShowqryFilteredCurrentFlowStatus.RegionalFlowIDtblEntities.EntityType=tblFilterEntityTypes.EntityTypetblEntities.EntityClass=tblFilterEntityClasses.EntityClassIIf(tblFilterEntityClasses.[Select]>tblFilterEntityTypes.[Select],tblFilterEntityClasses.[Select],tblFilterEntityTypes.[Select])(((tblElementMapping.ElementID) Is Not Null))tblEntities.EntityID = tblElementMapping.EntityIDtblEntities.EntityType = tblFilterEntityTypes.EntityTypetblEntities.EntityClass = tblFilterEntityClasses.EntityClassMin(IIf([tblFilterEntityClasses].[Select]>[tblFilterEntityTypes].[Select],[tblFilterEntityClasses].[Select],[tblFilterEntityTypes].[Select]))tblRegionalArchitecture.RegionalFlowID=tblProjectArchitecture.RegionalFlowIDtblProjectArchitecture.ProjectID=tblApplicationStatus.CurrentArchitectureIIf(IsNull([CurrentArchitecture]),[FlowStatus],[ProjectFlowStatus])tblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowIDSELECT tblElements.ElementID, tblElements.ElementID FROM tblElementsSELECT tblElements.ElementID, tblElements.ParentID FROM tblElements WHERE (((tblElements.ParentID)<>0)) SELECT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, Min(tblRegionalArchitecture.InRegionalArchitecture) AS MinOfInRegionalArchitecture, Min(tblRegionalArchitecture.LastBuild) AS MinOfLastBuild FROM tblRegionalArchitecture GROUP BY tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID$O  M} G J b D@HuqEuCa_[BUgUa@s24@qryFunEPArchI@k|@hRFF:::::::8 @Ta@~-4@qryFunElementsRegion@k@jbVVJJJJJJJH @Ra@Ra@qryFunElementsProject'@k@jdXXLLLLLLLJ @pQa@%͕,@qryFunElementEPsRelated@k@jh\\PPPPPPPN @$xwPa@؂- ,@qryFunElementEPsAdditional@i@hnbbVVVVVVVT @~@Oa@ڬ,@qryFunElementEPs@i@hZNNBBBBBBB@ @}Ma@;HNa@qryFunAutoRemoveProject'@a@gh\\PPPPPPPN @${- >ؿ@%CCؿ@qryFunAutoPotentialProject]@e\ @fnbbVVVVVVVT @z/>ؿ@U?ؿ@qryFunAutoPotential@e@d`TTHHHHHHHF @yLa@La@qryFunAutoAddProject'@a@cbVVJJJJJJJH @$wKa@~-4@qryFunArchRequirementsKeysI@a@bnbbVVVVVVVT @v:X,@.Nw,@qryFunArchRequirementsInRegion@a|@bvjj^^^^^^^\ @u]XKa@65@qryFunArchRequirementsI@a|@bfZZNNNNNNNL @tp N@׮ N@qryFunArchEPElementReqsValid@a@brffZZZZZZZX @sN@N@0qryFunArchEPElementReqsInvalidMark @a@_~rrfffffffd @$q:4@"k4@qryFlowStandardsInclude@^@_h\\PPPPPPPN @p.@7Xz@qryFilteredMarketPackagesSupport2I@^@_|ppdddddddb @o--@?Ço*@qryFilteredMarketPackagesSupport1@^$ @]|ppdddddddb @n!R/@l+AZ-@qryFilteredMarketPackagesEntityFlows@\@]vvjjjjjjjh @$lJa@2F@qryFilteredMarketPackageInterconnectBasic@Y`@Vtttttttr @k_Ja@$a8@qryFilteredMarketPackageInterconnect @[|@Vvvjjjjjjjh @j!Ja@_Ja@qryFilteredInterconnectsInRegion@,`@Xznnbbbbbbb` @iq5z@F@qryFilteredInterconnects@[@Zj^^RRRRRRRP @ $g<|"6@)AD8@qryFilteredFlowsProject# @Y @Xh\\PPPPPPPN @fIa@H2\z@qryFilteredFlowsExpanded @W@Vj^^RRRRRRRP @eUX8@^8@qryFilteredFlows @U\ @TZNNBBBBBBB@ @d/7@"/7@qryFilteredEntitiesY@R@S`TTHHHHHHHF @cHa@Zz@qryFilteredElementss@R@Q`TTHHHHHHHF @ $a05@i25@qryElementRollup@P|@QZNNBBBBBBB@ @u8f<| z \ >  r > w A k M / k+#ou)<'eetblFlowsqryFilteredCurrentFlowStatusf@oeY! etblFlowstblFilterFlowTypesZ@kQE! eFlowShow6@k-!! oeL@k geFlowTypeShowtblFilterFlowTypes.[Select]R)) oeFlowFuturisticShow@kA55 oeFlowStatusShow"tblFilterFlowDeployment.[Select][-- oeDestinationElementShowB@kI== oeSourceElementShow!qryFilteredElements.ElementShow`33 oeV@k ge tblFilterFlowDeployment??? eqryFilteredInteconnectTypesGGG eqryFilteredMarketPackagesCCC eqryFilteredCurrentFlowStatusIII etblFilterFlowTypes555 etblFlows!!! eqryFilteredElements777 eqryFilteredElementsqryFilteredElements_1aa7 etblFilterFlowFuturistic??? e e GdtblEntitiestblFilterEntityTypesl@k[O' dtblEntitiestblFilterEntityClassest@k_S' dEntityShow@k1%% odtblEntities.EntityID3 gdtblFilterEntityTypes999 dtblFilterEntityClasses=== dtblEntities''' d Gd d Gc tblElementMapping.ElementID: 'c Z@k 'c tblElementMapping.ElementID: gctblEntitiestblElementMappingb@ kUI' ctblEntitiestblFilterEntityTypesp@ k[O' ctblEntitiestblFilterEntityClassesx@ k_S' cElementShow@ k3'' octblElementMapping.ElementID: gctblElementMapping333 ctblEntities''' ctblFilterEntityTypes999 ctblFilterEntityClasses=== c Gc Gc c GbtblRegionalArchitecturetblProjectArchitecture@ kwk? btblProjectArchitecturetblApplicationStatus@kqe= bCurrentFlowStatus@k?33 ob\@k gb tblRegionalArchitecture.FlowID= gbX@k gbN@k gbL@k gbtblApplicationStatus999  @ @ @ @ @ @ @ @ @ @ @ @ @ @cm cm cm cm cmcmcmcmcmcmcmcmc mc mc mcm dmdmdmdmdmdmdm dm!dm"dmem#em%em&em'em(em)em*em+em,e m-em.em/em0em1em2em3em4em5em6em7eeeeeeem$fff f f f f ffffffff f f f f fffffgg g!g"g#g$g%g&g'g(g)g *g +g ,g-g.g/g0g1gggggggggg g g  g  gh hhhhhhhhhhhhhhhhhii!i"i#i$i%i&i'i(i)i*i+iiiii jjjjj jk k k kkkkk k k llllllmmmmmm m!m"m#m$m%m&mn'n)n*n+n,n-n.n/n0n1n(o2o4o5o6o7o8o9o:o;oooooooooo o o3LVALd H R Z  4 .dj:<tblApplicationStatus.CurrentArchitecture = tblProjectArchitecture.ProjectIDqryFilteredInteconnectTypes.DestinationElementID = tblRegionalArchitecture.DestinationElementIDqryFilteredInteconnectTypes.SourceElementID = tblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowID = qryFilteredMarketPackages.RegionalFlowIDqryFilteredElements.ElementID = tblRegionalArchitecture.SourceElementIDqryFilteredElements_1.ElementID = tblRegionalArchitecture.DestinationElementIDtblFlows.FlowType = tblFilterFlowTypes.FlowType[SourceElementShow] And [DestinationElementShow] And [FlowStatusShow] And [FlowFuturisticShow] And [FlowTypeShow] And [MPFilterShow] And [InterconnectShow]qryFilteredMarketPackages.MPFilterShowIIf(((tblFilterFlowFuturistic.[Select]=False) And (tblFlows.FlowFuturistic=True)),False,True)qryFilteredElements_1.ElementShowtblRegionalArchitecture.RegionalFlowIDtblRegionalArchitecture.RegionalFlowID=qryFilteredFlows.RegionalFlowIDtblElements.ElementID=tblRegionalArchitecture.SourceElementIDtblFlows.FlowID=tblRegionalArchitecture.FlowIDtblRegionalArchitecture.DestinationElementID=tblElements_1.ElementIDtblRegionalArchitecture.LastBuildIIf([InRegionalArchitecture],[FlowStatus],0)tblRegionalArchitecture.FlowStatustblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.RegionalFlowIDqryFilteredCurrentFlowStatus.CurrentFlowStatus=tblFilterFlowDeployment.FlowDeploymentqryFilteredCurrentFlowStatus.DestinationElementID=qryFilteredInteconnectTypes.DestinationElementIDqryFilteredCurrentFlowStatus.SourceElementID=qryFilteredInteconnectTypes.SourceElementIDqryFilteredCurrentFlowStatus.RegionalFlowID=qryFilteredMarketPackages.RegionalFlowIDqryFilteredElements_1.ElementID=qryFilteredCurrentFlowStatus.DestinationElementIDqryFilteredElements.ElementID=qryFilteredCurrentFlowStatus.SourceElementIDtblFlows.FlowID=qryFilteredCurrentFlowStatus.FlowIDat @ @ @ @ @ @ @ @ @ @ @ @ @ @AhAhA hA h A h Ah Ah Ah AhAhAhAhAhAhA`(BhBhBhBhBhBhBhBhBhBhBhBh Bh!Bh"Bh#Bh$Bh%B h&B h'Bh(Bh)Bh*Bh+Bh,Bh-Bh.Bh/BhCh0CdCdCdCdCdCdCdCdCdDd Dd Dd Dd DdDdDdDdDdDdDdDdDdDdDdDdDdDdDdDdDdDdDd Dd!Dd"Dd Ed#Ed%Ed&Ed'Ed(Ed$Fd)Fd+Fd,Fd-Fd.Fd/Fd0Fd1Fd2Fd3Fd4F d5F d6F d7F gFgFgFgFd*GgGgGgGgGg Gg Gg Gg Gg GgG gG gGgGgGgGgGgGgGgGgG gG gG gG gGgGgGgGg Gg!Gg"Gg#Gg$G g%G g&Gg'GgHg(Hg*Hg+Hg,Hg-Hg.Hg/Hg0Hg1Hg2Hg3HqHqHg)IqIqIqIqIqIqIq Iq Iq Iq Iq IqJqJqJqJqJqJqJqKqKqKqKqKqKqKqKqKqKqKq Kq!KqLq"Lq$Lq%Lq&Lq'Lq#Mq(Mq*Mq+Mq,Mq-Mq)Nq.Nq0Nq1Nq2Nq3Nq4Nq5Nq6Nq7Nq8Nq9N q:N q;Nq/j<Z<~= q  q S O Q  w ,  x00f<>G) u)jb8N tblFlowStandards.UserDefined; gN V@ r gNtblFlowStandards.StandardID: gNL@ r gNtblFlowStandards.FlowID6 gNDestinationEntityNamel@ rG;; oNH@ r gNSourceEntityNameh@r=11 oN!tblFlowStandards.SourceEntityID> gN"tblFlowStandards.EntityFlowStdID? gNtblFlowStandards111 NqryStdTempEntitySelectProjectKKK N N GMtblApplicationStatustblStandardsArch@reY9 MtblStandardsArch.StandardID: gMtblStandardsArch111 MtblApplicationStatus999 M M GLtblStandardGroupsArchtblApplicationStatus@roc; LF@r gLtblApplicationStatus999 LtblStandardGroupsArch;;; L L GKtblApplicationStatustblFlowStandardsTailoring@rwk9 KtblFlowStandardstblFlowStandardsTailoring@roc1 KtblFlowStandards.UserDefined; gKtblFlowStandards.StandardID: gKtblFlowStandards.FlowID6 gKH@r gK!tblFlowStandards.SourceEntityID> gK"tblFlowStandards.EntityFlowStdID? gKtblFlowStandardsTailoringCCC KtblFlowStandards111 KtblApplicationStatus999 K K GJtblApplicationStatustblStandardsTailoring@roc9 J"tblStandardsTailoring.StandardID? gJH@r gJtblStandardsTailoring;;; JtblApplicationStatus999 J J GI~@ f 'ItblStatusqryArchElements`@fMA# IqryArchElementstblElements^@fQE/ ItblStatus.StatusName3 gIqryArchElements.ProjectStatus< gItblElements.ElementName6 gItblElements.ElementID4 gItblElements''' IqryArchElements/// ItblStatus### I I GH"(((tblElements.InRegion)=False))? 'HtblElements_1tblElementsX@fMA+ LVALB Z 0  r r .D&@&tblStandards.StandardID not in (select qryCurrentArchExcludedStandards.StandardID from qryCurrentArchExcludedStandards)(((tblStandardGroups.StandardGroup) Not In (select qryCurrentArchExcludedStandardGroups.StandardGroup from qryCurrentArchExcludedStandardGroups)))tblStandardGroups.StandardGroupNarrativetblStandardGroups.StandardGroupNametblStandardGroups.StandardGroupShortName(((qryRegionalArchStakeholders.StakeholderID) Is Null))tblStakeholders.StakeholderID=qryArchStakeholders.StakeholderIDqryRegionalArchStakeholders.StakeholderID=qryArchStakeholders.StakeholderIDqryArchStakeholders.StakeholderID(((qryRegionalArchRRAreas.RRAreaID) Is Null))qryArchRRAreas.RRAreaID=tblRRAreas.RRAreaIDqryArchRRAreas.RRAreaID=qryRegionalArchRRAreas.RRAreaID(((tblFlowStandards.EntityFlowStdID) Not In (SELECT qryCurrentArchExcludedFlowStandards.EntityFlowStdID FROM qryCurrentArchExcludedFlowStandards)))qryStdTempEntitySelectProject.SourceEntityID=tblFlowStandards.SourceEntityIDqryStdTempEntitySelectProject.DestinationEntityID=tblFlowStandards.DestinationEntityIDqryStdTempEntitySelectProject.FlowID=tblFlowStandards.FlowIDqryStdTempEntitySelectProject.StandardID=tblFlowStandards.StandardIDqryStdTempEntitySelectProject.StandardDocIDqryStdTempEntitySelectProject.FlowNameqryStdTempEntitySelectProject.tblEntities_1.EntityNametblFlowStandards.DestinationEntityIDqryStdTempEntitySelectProject.tblEntities.EntityNametblApplicationStatus.CurrentArchitecture=tblStandardsArch.ArchitectureIDtblStandardGroupsArch.ArchitectureID=tblApplicationStatus.CurrentArchitecturetblStandardGroupsArch.StandardGrouptblApplicationStatus.CurrentArchitecture=tblFlowStandardsTailoring.ArchitectureIDtblFlowStandards.EntityFlowStdID=tblFlowStandardsTailoring.EntityFlowStdIDtblFlowStandards.DestinationEntityIDtblApplicationStatus.CurrentArchitecture=tblStandardsTailoring.ArchitectureIDtblStandardsTailoring.RegionalFlowID =|t P  P Z <  J  kM/h'`6Et,~`B>9S tblElements.ElementName6 'StblElementstblProjectElementsd@uWK' StblApplicationStatustblProjectElements@ui]9 S"tblProjectElements.ElementStatus? gStblElements.ElementName6 gStblProjectElements.ElementID; gStblProjectElements555 StblApplicationStatus999 StblElements''' S S GR@r 'RtblStandards.Comment3 gRtblStandards.UserDefined7 gRtblStandards.StandardVersion; gRtblStandards.StandardType8 gRtblStandards.StandardDocID9 gRtblStandards.StandardTitle9 gRtblStandards.SDO/ gRtblStandards.StandardID6 gRtblStandards))) R R GQ$@r 'QtblStandardGroups.UserDefined< gQP@r gQF@r gQP@r gQtblStandardGroups.SDO4 gQ!tblStandardGroups.StandardGroup> gQtblStandardGroups333 Q GQ GQ Q GPn@r 'PtblStakeholdersqryArchStakeholders~@raU/ PqryRegionalArchStakeholdersqryArchStakeholders@rymG P"tblStakeholders.StakeholderGroup? gP!tblStakeholders.StakeholderName> gPB@r gPqryArchStakeholders777 PqryRegionalArchStakeholdersGGG PtblStakeholders/// P P GOZ@r 'OqryArchRRAreastblRRAreasV@rMA- OqryArchRRAreasqryRegionalArchRRAreasn@reY- OtblRRAreas.RRAreaName4 gOqryArchRRAreas.RRAreaID6 gOtblRRAreas%%% OqryRegionalArchRRAreas=== OqryArchRRAreas--- O O GN&@r 'NqryStdTempEntitySelectProjecttblFlowStandards@rwkK NqryStdTempEntitySelectProjecttblFlowStandards@rwkK NqryStdTempEntitySelectProjecttblFlowStandardsx@rwkK NqryStdTempEntitySelectProjecttblFlowStandards@ rwkK px @ @ @ @ @ @ @ @ @ @ @ @ @ @GgGgGg Gg Gg Gg Gg GgG gG gGgGgGgGgGgGgGgGgG gG gG gG gGgGgGgGg Gg!Gg"Gg#Gg$G g%G g&Gg'GgHg(Hg*Hg+Hg,Hg-Hg.Hg/Hg0Hg1Hg2Hg3HqHqHg)IqIqIqIqIqIqIq Iq Iq Iq Iq IqJqJqJqJqJqJqJqKqKqKqKqKqKqKqKqKqKqKq Kq!KqLq"Lq$Lq%Lq&Lq'Lq#Mq(Mq*Mq+Mq,Mq-Mq)Nq.Nq0Nq1Nq2Nq3Nq4Nq5Nq6Nq7Nq8Nq9N q:N q;NsNsNsNsNsNq/OsOsOsOs Os Os Os Os OsOsPsPsPsPsPsPsPsPsPsPsPsQsQsQsQsQsQs Qs!Qs"Qs#Qs$Qs%QsRs&Rs(Rs)Rs*Rs+Rs,Rs-Rs.Rs/Rs0Rs1Rs'Ss2Ss4Ss5Ss6Ss7Ss8Ss9Ss:Ss;S s6 B $  ^ 4 r H  R $ < Fs {=M\NxN0XtblElements''' XtblTempCustomize111 OX X GW@y 'WtblElementstblRegionalArchitecture~@ waU' WtblFlowstblRegionalArchitecture`@ w[O! WqryCusSelectCurrentProjectFlowstblStatus@ wmaO WqryCusCurrentProjectElements_1tblRegionalArchitecture@w{M WqryCusCurrentProjectElementstblRegionalArchitecture@wwI WtblRegionalArchitectureqryCusSelectCurrentProjectFlows@w}? WtblRegionalArchitecturetblElements_1@weY? W Comment!tblRegionalArchitecture.CommentL wW InRegionalArch\@w9- wWLastBuildB@w/# wWFlowStatusDisplayFlowStatusDisplayX@waU3 WFlowStatusb@w1% wWInArchInArchF@ u5) WFlowNametblFlows.FlowName@! wWDestinationElementtblElements_1.ElementName\5 wWSourceElementtblElements.ElementNameP+ wWRegionalFlowIDL@ u9- wWtblStatus### WqryCusSelectCurrentProjectFlowsOOO WtblElementstblElements_1AA' WtblRegionalArchitecture??? WqryCusCurrentProjectElementsIII WqryCusCurrentProjectElementsqryCusCurrentProjectElements_1I WtblFlows!!! WtblElements''' W GWtblTempCustomize111 OW W GV p@ u gV x@ u gV n@u gVp@u gVInProjectArcht@u7++ oVx@u gVn@u gVqryCusSelectCurrentProjectInterconnects___ V GV GV V GUX7YZ_____2 @w1% 7UX7YZ_____1 @u1% 7U GU  GU U GTtblApplicationStatustblProjectArchitecture@uqe9 TtblProjectArchitecture.*7 gTtblApplicationStatus999 TtblProjectArchitecture=== T GT GT T GLVAL *p.FJ^tblElements.ElementID = tblRegionalArchitecture.SourceElementIDtblFlows.FlowID = tblRegionalArchitecture.FlowIDqryCusSelectCurrentProjectFlows.ProjectFlowStatus = tblStatus.StatusIDqryCusCurrentProjectElements_1.ElementID = tblRegionalArchitecture.DestinationElementIDqryCusCurrentProjectElements.ElementID = tblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowID = qryCusSelectCurrentProjectFlows.RegionalFlowIDtblRegionalArchitecture.DestinationElementID = tblElements_1.ElementIDtblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.LastBuildIIf(IsNull([ProjectID]),32767,[StatusOrder])qryCusSelectCurrentProjectFlows.ProjectFlowStatusSELECT DISTINCT qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, IIf(IsNull([ProjectID]),False,True) AS InProjectArch, qryFilteredInterconnects.InterconnectShow FROM (((qryCusSelectCurrentProjectFlows RIGHT JOIN tblRegionalArchitecture ON qryCusSelectCurrentProjectFlows.RegionalFlowID = tblRegionalArchitecture.RegionalFlowID) LEFT JOIN qryFilteredInterconnects ON (tblRegionalArchitecture.DestinationElementID = qryFilteredInterconnects.SourceElementID) AND (tblRegionalArchitecture.SourceElementID = qryFilteredInterconnects.DestinationElementID)) LEFT JOIN qryCusCurrentProjectElements ON tblRegionalArchitecture.SourceElementID = qryCusCurrentProjectElements.ElementID) LEFT JOIN qryCusCurrentProjectElements AS qryCusCurrentProjectElements_1 ON tblRegionalArchitecture.DestinationElementID = qryCusCurrentProjectElements_1.ElementID WHERE (((qryFilteredInterconnects.SourceElementID) Is Not Null) AND ((qryFilteredInterconnects.DestinationElementID) Is Not Null) AND ((qryCusCurrentProjectElements.ElementID) Is Not Null)) OR (((qryFilteredInterconnects.SourceElementID) Is Not Null) AND ((qryFilteredInterconnects.DestinationElementID) Is Not Null) AND ((qryCusCurrentProjectElements_1.ElementID) Is Not Null))t @ @ @ @ @ @ @ @ @ @ @ @ @ @NsNsNsNsNq/OsOsOsOs Os Os Os Os OsOsPsPsPsPsPsPsPsPsPsPsPsQsQsQsQsQsQs Qs!Qs"Qs#Qs$Qs%QsRs&Rs(Rs)Rs*Rs+Rs,Rs-Rs.Rs/Rs0Rs1Rs'Ss2Ss4Ss5Ss6Ss7Ss8Ss9Ss:Ss;S s[tblElements].[ElementName]))qryCusTempAppendProjectInterconnectSupport.DestinationElementID = tblElements_1.ElementIDqryCusTempAppendProjectInterconnectSupport.SourceElementID = tblElements.ElementIDMin(qryCusTempAppendProjectInterconnectSupport.InRegionalArch)Min(qryCusTempAppendProjectInterconnectSupport.InProjectArch)Min(qryCusTempAppendProjectInterconnectSupport.MinOfLastBuild)(((qryCusCurrentProjectElements.ElementID) Is Not Null)) OR (((qryCusCurrentProjectElements_1.ElementID) Is Not Null))tblElements.ElementID=tblRegionalArchitecture.SourceElementIDtblFlows.FlowID=tblRegionalArchitecture.FlowIDtblRegionalArchitecture.RegionalFlowID=qryFilteredFlowsProject.RegionalFlowIDqryCusSelectCurrentProjectFlows.ProjectFlowStatus=tblStatus.StatusIDtblRegionalArchitecture.RegionalFlowID=qryFilteredFlows.RegionalFlowIDqryCusCurrentProjectElements_1.ElementID=tblRegionalArchitecture.DestinationElementIDqryCusCurrentProjectElements.ElementID=tblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowID=qryCusSelectCurrentProjectFlows.RegionalFlowIDtblRegionalArchitecture.DestinationElementID=tblElements_1.ElementIDtblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.LastBuildIIf(IsNull([ProjectID]),32767,[StatusOrder])qryCusSelectCurrentProjectFlows.ProjectFlowStatusIIf(IsNull([ProjectID]),False,True)tblRegionalArchitecture.RegionalFlowID(((qryCusCurrentProjectElements.ElementID) Is Not Null)) OR (((qryCusCurrentProjectElements_1.ElementID) Is Not Null))g,@P : . a q  R ,  J 7laYqryCusTempAppendProjectInterconnectSupporttblElements@y{e YMinOfInRegionalArchInRegionalArch|@y_S7 YShowShow Min(True)8! YMinOfInProjectArchInArchz@yMA5 YMinOfMinOfLastBuildLastBuild|@yUI7 YDestinationElementtblElements_1.ElementName\5 wYSourceElementtblElements.ElementNameP+ wYtblElementstblElements_1AA' YtblElements''' YqryCusTempAppendProjectInterconnectSupporteee Y GYtblTempCustomize111 OY Y GX@y 'X tblElementstblRegionalArchitecturez@yaU' XtblFlowstblRegionalArchitecture\@y[O! XtblRegionalArchitectureqryFilteredFlowsProject@ yym? XqryCusSelectCurrentProjectFlowstblStatus@ ymaO XtblRegionalArchitectureqryFilteredFlows@ yk_? XqryCusCurrentProjectElements_1tblRegionalArchitecture@ y{M XqryCusCurrentProjectElementstblRegionalArchitecture@ ywI XtblRegionalArchitectureqryCusSelectCurrentProjectFlows@y}? XtblRegionalArchitecturetblElements_1@yeY? X Show"qryFilteredFlowsProject.FlowShowG wX Comment!tblRegionalArchitecture.CommentL wX InRegionalArch\@y9- wXLastBuildB@y/# wXFlowStatusDisplayFlowStatusDisplayX@yaU3 XFlowStatusb@y1% wXInArchInArchF@y5) XFlowNametblFlows.FlowName@! wXDestinationElementtblElements_1.ElementName\5 wXSourceElementtblElements.ElementNameP+ wXRegionalFlowIDL@y9- wX qryFilteredFlowsProject??? X tblStatus### XqryFilteredFlows111 XqryCusSelectCurrentProjectFlowsOOO XtblElementstblElements_1AA' XtblRegionalArchitecture??? XqryCusCurrentProjectElementsIII XqryCusCurrentProjectElementsqryCusCurrentProjectElements_1I XtblFlows!!! */h%z< R  0   Z   :tFvX:d&Z \RegionalFlowIDL@ |9- w\tblStatus### \tblElementstblElements_1AA' \tblRegionalArchitecture??? \tblFlows!!! \tblElements''' \ G\tblTempCustomize111 O\ \ G[X7YZ_____2@1% 7[X7YZ_____1@|1% 7[ G[  G[ [ GZ n@| 'Z tblElements_1.ElementName8 gZ tblElements.ElementName6 gZqryCusTempAppendProjectInterconnectSupportqryFilteredInteconnectTypes@|e ZqryCusTempAppendProjectInterconnectSupportqryFilteredInteconnectTypes@|e ZqryCusTempAppendProjectInterconnectSupportqryFilteredMarketPackageInterconnect@|e ZqryCusTempAppendProjectInterconnectSupportqryFilteredMarketPackageInterconnect@|e ZqryCusTempAppendProjectInterconnectSupportqryFilteredElements_1@|e ZqryFilteredElementsqryCusTempAppendProjectInterconnectSupport@|7 ZqryCusTempAppendProjectInterconnectSupporttblElements_1@|e ZqryCusTempAppendProjectInterconnectSupporttblElements@y{e ZMinOfInRegionalArchInRegionalArch|@y_S7 ZExpr1Show@y/# ZMinOfInProjectArchInArchz@yMA5 ZMinOfMinOfLastBuildLastBuild|@yUI7 ZDestinationElementtblElements_1.ElementName\5 wZSourceElementtblElements.ElementNameP+ wZqryFilteredInteconnectTypesGGG ZqryFilteredMarketPackageInterconnectYYY ZqryFilteredElementsqryFilteredElements_1aa7 ZtblElementstblElements_1AA' ZtblElements''' ZqryCusTempAppendProjectInterconnectSupporteee ZqryFilteredElements777 ZtblTempCustomize111 OZ Z GY v@y 'Y tblElements_1.ElementName8 gY tblElements.ElementName6 gYqryCusTempAppendProjectInterconnectSupporttblElements_1@ye LVAL R  4 h ^tblRegionalArchitecture.FlowStatustblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.RegionalFlowIDSELECT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, Min(tblRegionalArchitecture.LastBuild) AS MinOfLastBuild, Min(IIf(IsNull([ProjectID]),False,True)) AS InProjectArch, Min([InRegionalArchitecture]) as InRegionalArch FROM ((tblRegionalArchitecture LEFT JOIN qryCusCurrentProjectElements ON tblRegionalArchitecture.SourceElementID = qryCusCurrentProjectElements.ElementID) LEFT JOIN qryCusCurrentProjectElements AS qryCusCurrentProjectElements_1 ON tblRegionalArchitecture.DestinationElementID = qryCusCurrentProjectElements_1.ElementID) LEFT JOIN qryCusSelectCurrentProjectFlows ON tblRegionalArchitecture.RegionalFlowID = qryCusSelectCurrentProjectFlows.RegionalFlowID GROUP BY tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, qryCusCurrentProjectElements.ElementID, qryCusCurrentProjectElements_1.ElementID HAVING (((qryCusCurrentProjectElements.ElementID) Is Not Null)) OR (((qryCusCurrentProjectElements_1.ElementID) Is Not Null)) (((tblElements_1.ElementName)>tblElements.ElementName))qryCusTempAppendProjectInterconnectSupport.SourceElementID=qryFilteredInteconnectTypes.SourceElementIDqryCusTempAppendProjectInterconnectSupport.DestinationElementID=qryFilteredInteconnectTypes.DestinationElementIDqryCusTempAppendProjectInterconnectSupport.SourceElementID=qryFilteredMarketPackageInterconnect.SourceElementIDqryCusTempAppendProjectInterconnectSupport.DestinationElementID=qryFilteredMarketPackageInterconnect.DestinationElementIDqryCusTempAppendProjectInterconnectSupport.DestinationElementID=qryFilteredElements_1.ElementIDqryFilteredElements.ElementID=qryCusTempAppendProjectInterconnectSupport.SourceElementIDqryCusTempAppendProjectInterconnectSupport.DestinationElementID=tblElements_1.ElementID~@   @@  @ @@ @kQJiMWhoQiYQk`dOJomdbo`SYumoiLdOJmJkMWQ`JJomdbo`SYuJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhivJfS^dskiQUYdbhivJfS^dskiQUYdbLdmWhivJfS^dskiQUYdbMdobmhivJfS^dskiQUYdbQbo`QiJmQhivJfS^dskiQUYdbSdihivJfS^dskiQUYdbYOkhivJfS^dskiQUYdbYOkQ^QMmhivJfS^dskiQUYdbiQqhivJfS^dskiQUYdbkWdsJ^^hivJfS^dskiQUYdbkWdsJ^^MdobmhivJfS^dskiQUYdbkWdsJ^^Qbo`QiJmQ hivJfS^dskiQUYdbkWdsJ^^YOkQ^QMm!hivJfYbmQiMdbbQMmk"hivJfYbmQiMdbbQMmkLJkYM#hivJfYbmQiMdbbQMmkLJkYM`Yb$hivJfYbmQiMdbbQMmkMdobm%hivJfYbmQiMdbbQMmkQbo`QiJmQ&hivJfYbmQiMdbbQMmkSY^mQiQO'hivJfYbmQiMdbbQMmkkWdsJ^^(hivJfYbmQiMdbbQMmkkWdsJ^^Mdobm)hivJfYbmQiMdbbQMmkkWdsJ^^Qbo`QiJmQRhivJfYbmQiMdbbQMmkkWdsJ^^SY^mQiQORhivJiMWJUiQQ`QbmkRhivJiMWQ^Q`QbmkRhivJiMWQ^Q`QbmkMdbbQMmQORhivJiMWQ^Q`QbmkiQUYdbdifid[QMmRhivJiMWS^dsmiYf^QmkRhivJiMW`Ji\QmfJM\JUQkRhivJiMW`Ji\QmfJM\JUQkfid[QMmRhivJiMW`Ji\QmfJM\JUQkiQUYdbR hivJiMW`fkQ^QMmQOQ^Q`QbmkR hivJiMWiiJiQJkR hivJiMWkmJ\QWd^OQikR hivJiMWkmJ\QWd^OQikMJ^Mo^JmQOR hivJiMWkmJ\QWd^OQikMJ^Mo^JmQOQufJbOQORhivJiMWkmJ\QWd^OQikMdbbQMmQORhivJiMWkmJ\QWd^OQikMdbbQMmQOsYmWUidof`Q`LQikRhivJkOQ^QmQS^dskfid[QMmRhivJkiQhoQkmS^dskJ^^RhivJkiQhoQkmS^dskQuM^oOQfid[QMmRhivJkiQhoQkmS^dskQuM^oOQiQUYdbRhivJkiQhoQkmS^dskYbM^oOQfid[QMmRhivJkiQhoQkmS^dskYbM^oOQiQUYdbRhivJkiQhoQkmS^dsk`YkkYbUJffQbORhivJkiQhoQkmS^dskbdmYbM^oOQOfid[QMmRhivJkiQhoQkmS^dskbdmYbM^oOQOiQUYdbRhivJkiQhoQkmS^dskkQmkmJmokfid[QMmRhivJkiQkfdbkQS^dskJ^^RhivJkiQkfdbkQS^dskQuM^oOQfid[QMmRhivJkiQkfdbkQS^dskQuM^oOQiQUYdbRhivJkiQkfdbkQS^dskYbM^oOQfid[QMmRhivJkiQkfdbkQS^dskYbM^oOQiQUYdbRhivJkiQkfdbkQS^dsk`YkkYbUJffQbOR hivJkiQkfdbkQS^dskbdmYbM^oOQOfid[QMmR!hivJkiQkfdbkQS^dskbdmYbM^oOQOiQUYdbchivJkiQkfdbkQS^dskkQmkmJmokfid[QMmchivLJmMWkQ^QMmYbmQiSJMQkchivLJmMWkQ^QMmYbmQiSJMQkLJkYMchivMoiiQbmJiMWQ^Q`QbmS^dskmJbOJiOkchivMoiiQbmJiMWQ^Q`QbmS^dskmJbOJiOkWQ^fQichivMoiiQbmJiMWQ^Q`QbmYbkmJbMQkbdmYbiQUYdbchivMoiiQbmJiMWQ^Q`QbmkbdmYbiQUYdbchivMoiiQbmJiMWQuM^oOQOQ^Q`QbmS^dskmJbOJiOkchivMoiiQbmJiMWQuM^oOQOS^dskmJbOJiOkc hivMoiiQbmJiMWQuM^oOQOkmJbOJiOUidofkc hivMoiiQbmJiMWQuM^oOQOkmJbOJiOkc hivMoiiQbmJiMWS^dskmJbOJiOkc hivMoiiQbmJiMWiiJiQJkbdmYbiQUYdbc hivMoiiQbmJiMWkmJ\QWd^OQikbdmYbiQUYdbchivMoiiQbmJiMWkmJbOJiOUidofkchivMoiiQbmJiMWkmJbOJiOkchivMokMoiiQbmfid[QMmQ^Q`QbmkchivMokkQ^QMmMoiiQbmfid[QMmS^dskchivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkchivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkobYhoQchivMokmQ`fJffQbOfid[QMmS^dskchivMokmQ`fJffQbOfid[QMmS^dskSY^mQichivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkchivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkSY^mQicJMMQkk^Jvdom`kvkOL}@@    @  @hivJkiQhoQkmS^dskQuM^oOQfid[QMmRhivJkiQhoQkmS^dskQuM^oOQiQUYdbRhivJkiQhoQkmS^dskYbM^oOQfid[QMmRhivJkiQhoQkmS^dskYbM^oOQiQUYdbRhivJkiQhoQkmS^dsk`YkkYbUJffQbORhivJkiQhoQkmS^dskbdmYbM^oOQOfid[QMmRhivJkiQhoQkmS^dskbdmYbM^oOQOiQUYdbRhivJkiQhoQkmS^dskkQmkmJmokfid[QMmRhivJkiQkfdbkQS^dskJ^^RhivJkiQkfdbkQS^dskQuM^oOQfid[QMmRhivJkiQkfdbkQS^dskQuM^oOQiQUYdbRhivJkiQkfdbkQS^dskYbM^oOQfid[QMmRhivJkiQkfdbkQS^dskYbM^oOQiQUYdbRhivJkiQkfdbkQS^dsk`YkkYbUJffQbOR hivJkiQkfdbkQS^dskbdmYbM^oOQOfid[QMmR!hivJkiQkfdbkQS^dskbdmYbM^oOQOiQUYdbchivJkiQkfdbkQS^dskkQmkmJmokfid[QMmchivLJmMWkQ^QMmYbmQiSJMQkchivLJmMWkQ^QMmYbmQiSJMQkLJkYMchivMoiiQbmJiMWQ^Q`QbmS^dskmJbOJiOkchivMoiiQbmJiMWQ^Q`QbmS^dskmJbOJiOkWQ^fQichivMoiiQbmJiMWQ^Q`QbmYbkmJbMQkbdmYbiQUYdbchivMoiiQbmJiMWQ^Q`QbmkbdmYbiQUYdbchivMoiiQbmJiMWQuM^oOQOQ^Q`QbmS^dskmJbOJiOkchivMoiiQbmJiMWQuM^oOQOS^dskmJbOJiOkc hivMoiiQbmJiMWQuM^oOQOkmJbOJiOUidofkc hivMoiiQbmJiMWQuM^oOQOkmJbOJiOkc hivMoiiQbmJiMWS^dskmJbOJiOkc hivMoiiQbmJiMWiiJiQJkbdmYbiQUYdbc hivMoiiQbmJiMWkmJ\QWd^OQikbdmYbiQUYdbchivMoiiQbmJiMWkmJbOJiOUidofkchivMoiiQbmJiMWkmJbOJiOkchivMokMoiiQbmfid[QMmQ^Q`QbmkchivMokkQ^QMmMoiiQbmfid[QMmS^dskchivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkchivMokkQ^QMmMoiiQbmfid[QMmYbmQiMdbbQMmkobYhoQchivMokmQ`fJffQbOfid[QMmS^dskchivMokmQ`fJffQbOfid[QMmS^dskSY^mQichivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkchivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkSY^mQichivMokmQ`fJffQbOfid[QMmYbmQiMdbbQMmkoffdimchivMokmQ`fJffQbOiQUYdbS^dskchivMokmQ`fJffQbOiQUYdbS^dskSY^mQichivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkchivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkSY^mQichivMokmQ`fJffQbOiQUYdbYbmQiMdbbQMmkoffdimchivQ^Q`Qbmid^^oflhivSY^mQiQOMoiiQbmS^dskmJmoklhivSY^mQiQOQ^Q`QbmklhivSY^mQiQOQbmYmYQklhivSY^mQiQOS^dsklhivSY^mQiQOS^dskQufJbOQOlhivSY^mQiQOS^dskfid[QMmlhivSY^mQiQOYbmQMdbbQMmmvfQklhivSY^mQiQOYbmQiMdbbQMmklhivSY^mQiQOYbmQiMdbbQMmkYbiQUYdbl hivSY^mQiQO`Ji\QmfJM\JUQYbmQiMdbbQMml hivSY^mQiQO`Ji\QmfJM\JUQYbmQiMdbbQMmLJkYMl hivSY^mQiQO`Ji\QmfJM\JUQkl hivSY^mQiQO`Ji\QmfJM\JUQkQbmYmvS^dskl hivSY^mQiQO`Ji\QmfJM\JUQkkoffdim8lhivSY^mQiQO`Ji\QmfJM\JUQkkoffdim:lhivS^dskmJbOJiOkYbM^oOQlhivSobJiMWQfQ^Q`QbmYbqJ^YO`Ji\lhivSobJiMWQfQ^Q`QbmiQhkYbqJ^YO`Ji\lhivSobJiMWQfQ^Q`QbmiQhkqJ^YOlhivSobJiMWiQhoYiQ`QbmklhivSobJiMWiQhoYiQ`QbmkYbiQUYdblhivSobJiMWiQhoYiQ`Qbmk\QvklhivSobJomdJOOlhivSobJomdJOOfid[QMmlhivSobJomdfdmQbmYJ^lhivSobJomdfdmQbmYJ^fid[QMmlhivSobJomdiQ`dqQlhivSobJomdiQ`dqQfid[QMmlhivSobQ^Q`QbmQfklhivSobQ^Q`QbmQfkJOOYmYdbJ^lhivSobQ^Q`QbmQfkYbiQUYdblhivSobQ^Q`QbmQfkiQ^JmQOl hivSobQ^Q`Qbmkfid[QMml!hivSobQ^Q`QbmkiQUYdbl"hivSobQfJiMWl#hivSobQfQ^Q`QbmkhivSobQfQ^Q`QbmkJOOYmYdbJ^hivSobQfQ^Q`QbmkJOOYmYdbJ^fid[QMmhivSobQfQ^Q`QbmkiQ^JmQOhivSobQfQ^Q`QbmkiQhoYiQ`QbmkiQ^JmQOhivSobQfkMoiiQbmJiMWJMMQkk^Jvdom`kvkOLLVALjph$l,tblElements.ElementID=tblRegionalArchitecture.SourceElementIDtblFlows.FlowID=tblRegionalArchitecture.FlowIDtblStatus.StatusID=tblRegionalArchitecture.FlowStatustblRegionalArchitecture.RegionalFlowID=qryFilteredFlows.RegionalFlowIDtblRegionalArchitecture.DestinationElementID=tblElements_1.ElementIDtblRegionalArchitecture.LastBuildIIf([InRegionalArchitecture],[StatusOrder],32767)tblRegionalArchitecture.FlowStatustblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.RegionalFlowID(((tblElements.InRegion)=Yes) AND ((tblElements_1.InRegion)=Yes))tblElements.ElementID = tblRegionalArchitecture.SourceElementIDtblFlows.FlowID = tblRegionalArchitecture.FlowIDtblRegionalArchitecture.FlowStatus = tblStatus.StatusIDtblRegionalArchitecture.DestinationElementID = tblElements_1.ElementIDtblRegionalArchitecture.LastBuildIIf([InRegionalArchitecture],[StatusOrder],32767)SELECT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, Min(tblRegionalArchitecture.LastBuild) AS MinOfLastBuild, Min(IIf(IsNull([ProjectID]),False,True)) AS InProjectArch, Min([InRegionalArchitecture]) as InRegionalArch FROM ((tblRegionalArchitecture LEFT JOIN qryCusCurrentProjectElements ON tblRegionalArchitecture.SourceElementID = qryCusCurrentProjectElements.ElementID) LEFT JOIN qryCusCurrentProjectElements AS qryCusCurrentProjectElements_1 ON tblRegionalArchitecture.DestinationElementID = qryCusCurrentProjectElements_1.ElementID) LEFT JOIN qryCusSelectCurrentProjectFlows ON tblRegionalArchitecture.RegionalFlowID = qryCusSelectCurrentProjectFlows.RegionalFlowID GROUP BY tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, qryCusCurrentProjectElements.ElementID, qryCusCurrentProjectElements_1.ElementID H