Standard Jet DBnb` Ugr@?~1y0̝cßFNm7}Ҝ(3 `t{6߱WbC93y[#|*|"4~f_Љ$g'DeFx -bT4.0?` YArchitS  Y   Y Y  Y Y  Y  Y  Y   Y u Y o Y n Y z Y 2lY  Y  z Y  pY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeni EeitnYYIdParentIdName        OY[|@ |@ |@ SY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId Y'|@ |@ |@ S'Y  Y @Y Y  Y | Y @Y  Y  |AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order| @| @ |@Y"ObjectIdAttribute -Y7ArchitS7Y Y Y  Y e Y  Y   Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationshipaa o e Y/   Fwas YYYszObject$szReferencedObjectszRelationshipGx3 d  P <  x r-^J  @ BAD!""D!!"IQI)bRI$P)J 5"I@**T(JJI)THcU&T`@2@@@@@@V  P"TPAw֚ZZUZYM(BR`Tago1$U)d@BRbR$Xi)Te?@ @ @@  hivJkiQkfdbkQS^dskYbM^oOQfid[QMmQhivSobQ^Q`Qbmkfid[QMmmhivYbmQiqYQsMQbmQikLvkQU`QbmbfhiviQfdim`fkd^OhiviikmJ\QiQ^JmQOhivkoffdimQObJmYdbJ^S^dsk + :FDJBLOL>@B8H:D:BQ?Q@mAmBmCmDmEmFmGmHmIm Jm Km Lm Mm NmOmPmQmRmSmTmUmVmWmXmYmZm[m\m]m^m_m`m am!bm"cdefghijkl m n o p qrstuvwxyz{|}~ bbbbbbbbbb b b b b bbbbbbbbbbbbbbbbbbb   !"#  !"#      !      !"# $ % & ' ()*+,-./0123456789:;<=>?@A B C D E FGHIJKLMNOA#(-05:<?EKsz !&"*#.$2%68;8A8E8I8N8v8888 8 8 8 8 8888888888(8-8N8S8W8\8`888 8!8"8#8$8%8&8'      #-39@DIMPW\aek s!v"{#$%  J*+F,",WN     $%&'() * + , 7 8 9 : ; < = > ?       !"#$%&'()*+,-./0123456789:;<=>?@A B C D!E!F!G"H"I"J###$$$%%%& & & ' ' '((()))***+++,,,--- .!.".#/$/%/&0'0(0)1*1+1,2-2.2/303132434445565758696:6;7<7=7>8?8@8A9B9C9D:E:F:G;H;I;J<<<===>>>? ? ? @ @ @AAABBBCCCDDDEEEFFF G!G"G#H$H%H&I'I(I)J*J+J,K-K.K/L0L1L2M3M4M5N6N7N8O9O:O;P<P=P>Q?Q@QARBRCRDSESFSGTH-./012 3 4 5!6!7!8"9":";#<#=#>$?$@$A%B%C%D&E&F&G'H'I'J(K(L(M)N)O)***+++,,, - - - . ..///00011122233344 4!5"5#5$6%6&6'7(7)7*8+8,8-9.9/90:1:2:3;4;5;6<7<8<9=:=;=<>=>>>??@?A?B@C@D@EAFAGAHBIBJBCCCDDDEEE F F F G GGHHHIIIJJJKKKLLLMM M!N"N#N$O%O&O'P(P)P*Q+Q,Q-R.R/R0S1S2S3T4T5T6GH@ABCADAEAF  !"#  @ @ @ @ @I$NMO$TU+ YZ3]_9<>?ijDo(qJt4vSz.{X~]g0n uy| (cg9( 79 % 27     &F=F>F?F@FAF5FBFDFEIIFCIIIIIII 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:KCKEKFKGKHKDMMMMMK@@@@@@@@@@@@@+ 6@SDMHMMQDD>FJ:>Q@LO6QD@BSMDL+ +;K[+ 8QMSLMOHDDJH>SO8J>LB8JJOMHBBB86L>QD6JJDLQLFQ@DQ>LLQM+ +;K[+ :FDJBLOL>@B8H:D:B>HJJFL><@68L8DQJH@>O+ +;K[+ 68Q@: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^Jf^YbQkmv^QmL^Q^Q`QbmkmL^Jf^YbQkmv^QmL^fid[QMmYbSdi`JmYdb mL^Jf^YbQkmv^QmL^iQUYdbJ^kQiqYMQk mL^Jf^YbQkmv^QmL^iiJiQJkmJ\QWd^OQikiik mL^Q^Q`QbmkmL^QfJiMW mL^Q^Q`QbmkmL^QfQ^Q`QbmkiQhoYiQ`Qbmk mL^Q^Q`QbmkmL^kQ^QMmQOYbmQiMdbbQMmkmL^Q^Q`QbmkmL^kQ^QMmQOYbmQiMdbbQMmk8mL^QbmYmYQkmL^S^dsiQ^JmYdbkWYfkmL^QbmYmYQkmL^S^dsiQ^JmYdbkWYfk8mL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^QfJiMWiQhoYiQ`QbmkmL^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`fkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQQ^Q`QbmkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQfid[QMmkmL^`Ji\QmfJM\JUQkmL^iQUYdbJ^kQiqYMQkmL^`Ji\QmfJM\JUQkmL^iiJiQJ`fkmL^fid[QMmYbSdi`JmYdbmL^JUiQQ`Qbmkfid[QMmk 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^OQikmL^kmJ\QWd^OQikmL^JUiQQ`QbmkkmJ\QWd^OQikmL^kmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQikY@ @ @  @@@@@@@mL^JUiQQ`Qbmkfid[QMmkmL^JUiQQ`Qbmkfid[QMmk mL^JUiQQ`QbmkkmJ\QWd^OQikmL^JUiQQ`QbmkkmJ\QWd^OQikmL^Q^Q`Qbm`JffYbUmL^Q^Q`Qbm`JffYbUmL^Q^Q`QbmkmL^QfJiMW mL^QfJiMWmL^QfJiMWiQhoYiQ`QbmkmL^QfJiMWiQhoYiQ`Qbmk mL^QfQ^Q`QbmkiQhoYiQ`Qbmk mL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^Qf`fkmL^Qf`fkmL^QfiQhoYiQ`QbmkmL^SY^mQiQbmYmvM^JkkQkmL^SY^mQiQbmYmvmvfQkmL^SY^mQiS^dsSomoiYkmYMmL^SY^mQiS^dsmvfQk mL^S^dsiQ^JmYdbkWYfkmL^S^dsiQ^JmYdbkWYfkmL^YbmQiqYQsMQbmQikLvkQU`QbmmL^`Ji\QmfJM\JUQQ^Q`Qbmk mL^`Ji\QmfJM\JUQQ^Q`QbmkmL^`Ji\QmfJM\JUQfid[QMmkmL^`Ji\QmfJM\JUQfid[QMmkmL^dmWQiQbmYmYQkmL^dmWQiQbmYmYQk mL^fid[QMmJiMWYmQMmoiQ mL^fid[QMmJiMWYmQMmoiQmL^fid[QMmQ^Q`QbmkmL^fid[QMmQ^Q`QbmkmL^fid[QMmYbSdi`JmYdb mL^iQUYdbJ^JiMWYmQMmoiQmL^iQUYdbJ^JiMWYmQMmoiQ mL^iQUYdbJ^JiMWYmQMmoiQmL^iQUYdbJ^kQiqYMQk mL^iQUYdbJ^kQiqYMQkmL^iiJiQJ`fkmL^iiJiQJ`fk mL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQikmL^iiJiQJkmJ\QWd^OQikiik mL^iiJiQJkmJ\QWd^OQikiik mL^kQ^QMmQOYbmQiMdbbQMmkmL^kQ^QMmQOYbmQiMdbbQMmkmL^kmJ\QWd^OQiLdobOYbmQiSJMQkmL^kmJ\QWd^OQiLdobOYbmQiSJMQkmL^kmJ\QWd^OQiid^QkmL^kmJ\QWd^OQiid^QkmL^oOQbmYmvS^dskmL^oOQbmYmvS^dskmL^oOQbmYmvS^dsk  @@@@@@@@    @mL^JUiQQ`QbmkmL^JUiQQ`QbmkmL^Jf^YbQkmv^QmL^Jf^YbQkmv^Q mL^Jf^YbQkmv^Q mL^Jf^YbQkmv^Q mL^Q^Q`QbmkmL^Q^Q`Qbmk mL^Q^Q`Qbmk mL^Q^Q`QbmkmL^Q^Q`QbmkmL^Q^Q`QbmkmL^Q^Q`Qbmk mL^Q^Q`Qbmk mL^Q^Q`QbmkmL^Q^Q`QbmkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQk mL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QbmYmYQkmL^QfQ^Q`QbmkiQhoYiQ`QbmkmL^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\JUQkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQkmL^`Ji\QmfJM\JUQkmL^fid[QMmYbSdi`JmYdbmL^fid[QMmYbSdi`JmYdbmL^fid[QMmYbSdi`JmYdbmL^fid[QMmYbSdi`JmYdb mL^fid[QMmYbSdi`JmYdb mL^iQUYdbJ^JiMWYmQMmoiQ mL^iiJiQJk mL^iiJiQJkmL^iiJiQJkmJ\QWd^OQik mL^iiJiQJkmJ\QWd^OQikiik mL^kmJ\QWd^OQikmL^kmJ\QWd^OQikmL^kmJ\QWd^OQik-*d _ Z g  ~K _ V HzztpFlXTDD40Bpp@pTFa@}Fa@qryAPInterconnectsShowAllT@@l``TTTTTTTR @Ȥ6@6@qryAPInterconnectsFilteredT@\ @nbbVVVVVVVT @Ea@1Ea@qryAPInterconnectsEnumerateT@|@pddXXXXXXXV @Ea@Ea@qryAPInterconnectsBasicMinT'@|@nbbVVVVVVVT @Da@Da@qryAPInterconnectsBasicT@@h\\PPPPPPPN @Da@Da@qryAPInterconnectsT@@^RRFFFFFFFD @]NDa@]NDa@qryAPFlowsRegionShowAllIDSelectTY@@xll```````^ @Ca@Ca@qryAPFlowsRegionShowAllCountT'@ |@rffZZZZZZZX @Ca@Ca@qryAPFlowsRegionShowAllT@ @h\\PPPPPPPN @fBa@fBa@qryAPFlowsRegionRevT'@ @`TTHHHHHHHF @C]Ba@fBa@qryAPFlowsRegionIDSelectTY@@j^^RRRRRRRP @Aa@ Ba@qryAPFlowsRegionForT'@@`TTHHHHHHHF @٢Aa@٢Aa@qryAPFlowsRegionEnumerateT@`@l``TTTTTTTR @dAa@٢Aa@qryAPFlowsRegionCountTY@|@dXXLLLLLLLJ @&Aa@dAa@qryAPFlowsRegionBothT'@@bVVJJJJJJJH @ o@a@&Aa@qryAPFlowsRegionT@@ZNNBBBBBBB@ @,?q1@@q1@MSysAccessObjectsTDDDDDDDDDDB   HĔӇ@ ;`@AdminT/:@8,,,,,,,,,*  xH@xH@AutonumFixT66666666664  &e@&e@turbo data schemaTDDDDDDDDDDB  7ee@7ee@modSearchQueriesTBBBBBBBBBB@ עI@עI@modAutoNumFixT<<<<<<<<<<: e@e@Search QueriesTT@JJJ>>>>>>>< @Z@Z@SysRelT.........., Z@Z@ScriptsT0000000000. Z@Z@ReportsT0000000000. Z@Z@ModulesT0000000000. Z@Z@FormsT,,,,,,,,,,* Z@Z@DataAccessPagesT@@@@@@@@@@> c@c@MSysRelationshipsVDDDDDDDDDDB c@c@MSysQueriesV88888888886 c@c@MSysACEsV22222222220 c@c@MSysObjectsV88888888886 c@c@MSysDbTx@:::......., @c@c@RelationshipsV<<<<<<<<<<: c@c@DatabasesV44444444442 c@c@TablesV..........,  Y*   N**Y Y DataID @YAOIndexv1K[n7 w0ctLLS@LL0 P\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\` MSysAccounts xx`{pzxyMSysObjects^_TpT      xx^K[ࡱ> 45 '& !"#$%&(-)*+,./2013'.789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entryw LVBA w VBAProject  w VBA w dir_VBA_PROJECTFOHNFTHTMVZCIEJTACFTNBKRSJGN:BJRMVVPBLQMAEODKXFMRXDRLXLQUL:M  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLNOPQRSTUVWXYZ[\]^_`abcdfghijklmnopqrstuvwxyz{|}~鳀0* pHdblank back endD@  = Vz Z@A 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р[ Y25EY00-5O,'Shared\\dao360.dll# 3.6-,[X>(ZXQZ6*w[UZn7^ZCGZx*@" Ext.W7 for DDL and SecuritDZ,modNumFiPxG3mdauoNumFix@FOHNFTHTMVZCIEJTACFTNBKRSJGN2,8ApH@FTHMVZCIEJANB@KRS@G A@ 1`B,.@!+BForm_Search QueriesGT&Fr_ earcQ s Qei`usJRMVVPBLQMAEODKXFMRXDRLXLQULFJVP@LUM%EDX$M XoRLX`QUFa`H "B({4f ;5S RVLNFHCXKKKZEEFREWPFDGRFCONR3L/F@/CK`K6E5FEWF*GF7OLɯ 5f=5am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\ProK[gram Files\Microsoft Office\Office\MSACC9.OLB#Microsoft Access 9.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.7#0#C:\Program Files\Common Files\System\ado\msadox.dll#Microsoft ADO Ext. 2.7 for DDL and Security ZA8FOHNFTHTMVZCIEJTACFTNBKRSJGN0141b59292modAutoNumFix@8JRMVVPBLQMAEODKXFMRXDRLXLQUL0241b59292U&Form_Search Queriesa8RVLNFHCXKKKZEEFREWPFDGRFCONL0341b59292b modSearchQueriesf=0 P0C"GF[ʶxI 킺 x'z@rYf{+_09;h,AccessVBAWin16~Win32MacVBA6#blank back endstdole`ADODBsDAOADOX modAutoNumFix _Evaluate AutoNumFixcatJ}Catalog#tblPTablecolHColumnivarMaxIDL "!l @*Is seed negative or below existing values?Seed "%>'(r[ "!][ ,]$B'&e ( ( &rog 'Offer the next available value above 0.a &$D '*Pro * l'*agak ,Get confirmation before changing this table.rl\ $$$'$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 ",>o 2 '2$&Write a trail in the Immediate Window.a\[ , "! ( => *.COkkky!#Table can have only one AutoNumber.E;kp Next columnSkPkH)If the user chose Cancel, no more tables. 0 RIEyk Next table.Clean up.".. 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 K[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 ME (S<S<S<<N0{A4338A1F-8E86-4DEA-9CB8-BE0F93AFB9BC}x Vh@%@@  "   0@X `pxx X(ZZC `$^'\I \RL Not Found'\@k  X(ZonAttribute VB_Name = "Form_Search Queries" Bas0{A4338A1F-8E86-4DEA-9CB8-BE0F93AFB9BC} |@GlobalSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDqvCustomizD$Option Comp@ DT Priv+ Sub cmdFind_Click()  Screen.MousePo inter`11txtResults ( #&#If "" Then"3Not FoundǁEnd IffC T$  1  f=xRVLNFHCXKKKZEEFREWPFDGRFCONL:e PROJECT PROJECTwmAcessVBADataK[ME(<<< <Xj+^@(id fx% h%X, FB PXh  p    n $P "x  ,  H ( BH  L    ( 8 @ ` x   X  $ @ ` px?Searches stored SQL (procedures/queries) for a specified string]`$l.f h f!n act h!r'p p d ^ h! 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 Ifi8Attribute VB_Name = "modSearchQueries" Option Compare Database 'Zes stored SQL (procedures/q) for a specifiPsng Public Fun6cg ~(% A(s S2)  Dim db!DAO., qdfyDef0On Err!Resu{Next Set(= CurrentDb() FEach-Inz.-sHZ= . If Inc(1,r ) Then%Ћ&0݀& vbCrLpEnd Ip ' thellowing ADO code didn't work as well because only soKtydefs Aclasst "views" byA 'c!grstbDB.Record se\intC olumn IntegerlGoTon_JB nAoProject.Conn.OpenSchema(adV.y$o While Not .EOFD"4 q@("VIEW_DEFINITION")u') r= &("TABLE_NAME") Gx)xH$.Move| Loop@7 Hh@@Ex|itp`@dK-:a'clean u MsgBox ("Ck" .Number": eDes(criÊ&in="1 -0 Is2e 6nC` !%E am  ID="{9F1F7BA8-C5D3-41E6-BE60-F49CDAAB6B9C}" Module=modAutoNumFix DocClass=Form_Search Queries/&H00000000 Module=modSearchQueries Name="blank back end" HelpContextID="0" VersionCompatible32="393222000" CMG="474505C00B405644564456445644" DPB="8E8CCC8954979A989A989A" GC="D5D7975E99A49AA49A5B" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VK[BE;&H00000000 [Workspace] modAutoNumFix=44, 44, 719, 513, Z Form_Search Queries=0, 0, 0, 0, C modSearchQueries=22, 29, 760, 442, C $P+modAutoNumFixmodAutoNumFixForm_Search QueriesForm_Search QueriesmodSearchQueriesmodSearchQueriesere `*,`. tab`00289=Babc`e ghij k ](Forms w w 0w w Blob  PropData@sBc .  USearch Queries Arial8 h\\RONS LAPTOP\HP4P4C odXXLetterDINU"4z==*HP LaserJet 4P\\RONS LAPTOP\HP4P\\RONS LAPTOP\HP4Pd2 Tahomahgh Tahomam45 Tahoma`h Detail+!Au3+m7UF`a,b,c,txtFind^t{NlBqnd5U`a,b+c Label1 Find: Y(kIvm27WF`aHb(c ktxtResultsFr>UfK}Ed5]`aHbc Label3Results:쉆CJhVdh1U`da,bNcnicmdFindFind"[Event Procedure]Quit App$ Oc8\np Next columnSkPkHͬ3MDetailmtxtFindTypeInfoBlobDelta[DirData &PropDataK[d Label1mtxtResultsd Label3h cmdFind{00020430-0000-0000-C000-0000dhmmdmdhb#OLE Automation Search Queries000-0010-8000 0CB0D2EA4}#2.1#0#C:\Program ommon Files\system\ado\mslb#Microsoft ActiveX DataCmdbarsw w Modules 'w w 0w w PropData PropDataCopy1w w PropData PropDataCopyDirDataJPropDataPropDataCopyReports%w w modAutoNumFix$modSearchQueries 0CB0 1CB0C 0CB0ʶxI 킺 x'z@rYf{+_9;h,AccessVBAWin16~WͬHRBvZXReportHeaderdLabel201dLabel202PageHeaderDetailfLine0fLine1gImage2gImage3f0"w w Blob 6PropData!# TypeInfo$       !"#$%()*+,-/2014356K[0:<=Babc3e ghXiJj18k6$cFV@ U8Relationships for turbo data Arial834hHP LaserJet 4P@gXXLetter 8 1/2 x 11 in@MSUDHP LaserJet 4P<d < winspoolHP LaserJet 4PLPT1:d28 Arialg37n7 Arial`ReportHeaderd8"bceLabel2018Relationships for turbo datadabcLabel202.Thursday, July 29, 1999`PageHeader`4 Detailf2`sab Line0f2`a b Line1g`a" bZcx Image2h(@@@@@@@@@@@@@@@g`a}bcK Image3x( P@@@@@@@K[@@@@@@@f`a b c. Line4f2`$a$ b Line5f2`#ab Line6f`#abcX Line7f2`$a/ b Line8f2`#ab Line9f`#abc Line10f2`+a5b Line11f2`#ab Line12g`7#a bZcxImage13h(@@@@@@@@@@@@@@@g`+abcKImage14x( P K[@@@@@@@@@@@@@@f`#abc Line15f2`2ab Line16f2`--aZb Line17g`Z-abZcxImage18h(@@@@@@@@@@@@@@@ K[g`72abcKImage19x( P@@@@@@@@@@@@@@f`--abcS Line20f2`'ab Line21f2`#ab Line22g`7#a bZcxImage23h(@@@@@@@@@@@@@@ K[@g`3'a:bcKImage24x( P@@@@@@@@@@@@@@f`#ab Line25f2`1aub Line26f2`--aZb Line27g`Z-abZcxImage28h(@@@@@@@@ K[@@@@@@@g`1a bcKImage29x( P@@@@@@@@@@@@@@f`--abFc Line30f2`ab Line31f2`ab Line32g`a bZcxImage33h(@@@@@@@@ K[@@@@@@@g`aCbcKImage34x( P@@@@@@@@@@@@@@K[f`abc  Line35f2`K-ab Line36f2`=,a7b Line37f`-ab-c Line38f2`Z-ab Line39f2`=,a b Line40f`-a b<c  Line41f2`a-b Line42f2` a.b Line43f` a-bc- Line44f2`a/b Line45f2`a#(b Line46g` a'bZcxImage47h(@@@@@@@@@@@@@@@g`av/bcKImage48x( P@@@@@@@@@@@@@K[@f` a2(bc Line49f2`a0b Line50f2`a(b Line51g` a_(bZcxImage52h(@@@@@@@@@@@@@@@g`aH0bcKImage53x( P@@@@@@@K[@@@@@@@f` a)bc Line54f2`a,b Line55f2`a2(b Line56f` a2(bc Line57f2`a&b Line58f2`a#(b Line59g` a'bZcxImage60h(@@@@@@@@@@@@@@@g`a&bcKImage61x( P@@@@@@@K[@@@@@@@f` a&bc Line62f2`aQ'b Line63f2`a(b Line64g` a_(bZcxImage65h(@@@@@@@@@@@@@@@K[g`a&bcKImage66x( P@@@@@@@@@@@@@@f` a`'bc Line67f2`sab Line68f2` awb Line69g` abZcxImage70h(@@@@@@@@@@@@@@@K[g`abcKImage71x( P@@@@@@@@@@@@@@f` a#b cc Line72f2`sab Line73f2` awb Line74g` abZcxImage75h(@@@@@@@@K[@@@@@@@g`a<bcKImage76x( P@@@@@@@@@@@@@@f` ab c Line77f2`ab Line78f2`paAb Line79g`abZcxImage80h(@@@@@@@@K[@@@@@@@g`abcKImage81x( P@@@@@@@@@@@@@@K[f`Q ab7c Line82f2`ab Line83f2`paAb Line84g`abZcxImage85h(@@@@@@@@@@@@@@@g` aTbcKImage86x( P@@@@@@@@@@@@@@K[f`abic Line87f2`sawb Line88f2`paAb Line89g`abZcxImage90h(@@@@@@@@@@@@@@@g`abcKImage91x( P@@@@@@@K[@@@@@@@f`Q aPb" c6 Line92f2`ab Line93f2`F#aO b Line94g`d#a bZcxImage95h(@@@@@@@@@@@@@@@g`aFbcKImage96x( P@@@@@@@K[@@@@@@@f`a^ bc` Line97f2`ab Line98f2`1 ab Line99g`O a bZcxImage100h(@@@@@@@@@@@@@@@g`a:bcKImage101x( P@@K[@@@@@@@@@@@@f` abLine102f2`abLine103f2`a bLine104g`a" bZcxImage105h(@@@@@@@@@@@@@@@K[g` abcKImage106x( P@@@@@@@@@@@@@@f`a bc3 Line107f2`a! bLine108f2`a bLine109g`a" bZcxImage110h(@@@@@@@@@@@@@@@K[g`a bcKImage111x( P@@@@@@@@@@@@@@f`a bciLine112f2`a bLine113f2`^abLine114g`|a[bZcxImage115h(@@@@@@@@K[@@@@@@@g`a bcKImage116x( P@@@@@@@@@@@@@@f`a bcLine117f2` abLine118f2`a bLine119g`a" bZcxImage120h(@@@@@@@@K[@@@@@@@g` aLbcKImage121x( P@@@@@@@@@@@@@@K[f`a bcLine122f2`)abLine123f2`abLine124g` a[bZcxImage125h(@@@@@@@@@@@@@@@g`GabcKImage126x( P@@@@@@@@@@@@@@ K[f`ab-cLine127f2`aubLine128f2`a bLine129g`a" bZcxImage130h(@@@@@@@@@@@@@@@g`a bcKImage131x( P@@@@@@@!K[@@@@@@@f`abcCLine132f2` abLine133f2`a bLine134g`a" bZcxImage135h(@@@@@@@@@@@@@@@g` aqbcKImage136x( P@@@@@@@"K[@@@@@@@f`abcLine137f2`F#a bLine138f2`%abLine139g`%aJbZcxImage140h(@@@@@@@@@@@@@@@#K[g`d#a\ bcKImage141x( P@@@@@@@@@@@@@@f`'$a bcLine142n07"aTbKcddecl0Value List߄"MarketPackage";"ProjectID";"Applicability";"Touched";"Comment";"" Tahomad238"`Tajbcecltitle0&tblRegionalServices Tahoman07"abIcdlecl1Value List<"StakeholderID";"ElementID";"" Tahomad238"`ahbcecltitle1&tblStakeholderRoles Tahoman07"abIcSdlecl2Value Listz"StakeholderID";"StakeholderName";"StakeholderDescription";"" Tahomad238"`ahbScecltitle2tblStakeholders Tahoman07"a{bIcd&lecl3Value List"EntityID";"EntityAbbreviation";"EntityName";"EntityDescription";"EntityKind";"EntityClass";"EntityType";"" Tahomad238"`{ahbcecltitle3tblEntities Tahoman07"aibUcdlecl4Value List>"RegionalFlowID";"ProjectID";"" Tahomad238"`iatbcecltitle4,tblProjectArchitecture Tahoman07"alb cd&lecl5Value List"RegionalFlowID";"SourceElementID";"DestinationElementID";"FlowID";"InRegionalArchitecture";"FlowStatus";"To$K[uched";"Comment";"" Tahomad238"`la bcecltitle5.tblRegionalArchitecture Tahoman07"a*bx-cCdlecl6Value Listߘ"WorkspaceModified";"CurrentTask";"CurrentArchitecture";"InterviewStatus";"" Tahomad238"`*a,bCcecltitle6(tblApplicationStatus Tahoman07"a&bdElecl7Value Listߞ"FlowID";"FlowName";"FlowDescription";"FlowKind";"FlowFuturistic";"FlowType";"" Tahomad238"`&abcecltitle7tblFlows Tahoman07"avb'cd lecl8Value List"QuestionCategory";"QuestionSequence";"QuestionNarrative";"QuestionHelp";"QuestionType";"ChoiceA";"ChoiceA2";"ActionA";"ArgumentA";"NarrativeBranchA";"ChoiceB";"ActionB";"ArgumentB";"NarrativeBranchB";"" Tahomad238"`va&bcecltitle8tblInterview Tahoman07"a b-cddl ecl9Value Listߌ"ActionID";"ActionStep";"ActionType";"ActionName";"ActionParameter";"" Tahomad238"` a,bcecltitle9&tblInterviewActions Tahoman07"a b/cdl ecl10Value Listx"QuestionCategory";"QuestionSequence";"CenterID";"Answer";"" Tahomad238"` a.bcecltitle10&tblInterviewAnswers Tahoman07"a b%&cdl ecl11Value Listp"CurrentCategory";"CurrentSequence";"CurrentCenterID";"" Tahomad238"` aD%bcecltitle11$tblInterviewStatus Tahoman07"ay,bdl ecl12Value List:"EntityID";"OtherEntityID";"" Tahomad238"`y,abcecltitle12 tblOtherEntities Tahoman07"a*b&cdl ecl13Value List߀"RegionalArchitectureExists";"RegionName";"RegionDescription";"" Tahomad238"`*a&bcecltitle13,tblRegionalInformation Tahoman07"a.bdl ecl14Value List"EntityID";"EntityAbbreviation";"EntityName";"EntityDescription";"EntityKind";"EntityClass";"EntityType";"" Tahomad238"`.abcecltitle14tblEntities_1 Tahoman07"a'bIc dl ecl15Value ListR"SourceEntityID";"DestinationEntityID";"" Tahomad238"`'ahb cecltitle15:tblStakeholderBoundInterfaces Tahoman07"am b[cdl ecl16Value ListV"SourceElementID";"DestinationElementID";"" Tahomad238"`m az bcecltitle160tblSelectedInterconnects Tahoman07"a b*c4dl ecl17Value List^"SegmentID";"SegmentName";"QuestionCategory";"" Tahomad238"` a*b4cecltitle17(tblIntervie%K[wSegments Tahoman07"abcdl ecl18Value Listf"ElementID";"EntityID";"AutoGenerated";"Touched";"" Tahomad238"`abcecltitle18"tblElementMapping Tahoman07"a bcdl ecl19Value List4"ElementID";"ProjectID";"" Tahomad238"` abcecltitle19$tblProjectElements Tahoman07"ahb^ cddl ecl20Value Listߔ"ElementID";"ElementName";"ElementDescription";"ElementStatus";"Center";"" Tahomad238"`ha} bcecltitle20tblElements Tahoman07"abddl ecl21Value Listߔ"ElementID";"ElementName";"ElementDescription";"ElementStatus";"Center";"" Tahomad238"`a bcecltitle21tblElements_1 Tahoman07"a%bcEdl ecl22Value List2"EntityClass";"Select";"" Tahomad238"`%abEcecltitle22,tblFilterEntityClasses Tahoman07"a%b crdl ecl23Value List0"EntityType";"Select";"" Tahomad238"`%a brcecltitle23(tblFilterEntityTypes Tahoman07"a,.bdl ecl24Value List8"FlowFuturistic";"Select";"" Tahomad238"`,.abcecltitle24.tblFilterFlowFuturistic Tahoman07"a;.bdl ecl25Value List,"FlowType";"Select";"" Tahomad238"`;.abcecltitle25$tblFilterFlowTypes Tahoman07"abcdl ecl26Value List߂"ProjectID";"ProjectName";"ProjectDescription";"ProjectStatus";"" Tahomad238"`abcecltitle26*tblProjectInformation Tahoman07"aTbc dl ecl27Value Listb"MarketPackage";"ElementID";"Select";"Touched";"" Tahomad238"`Tab cecltitle270tblMarketPackageElements Tahoman07"abcCdl ecl28Value List߂"MarketPackage";"MarketPackageName";"MarketPackageDescription";"" Tahomad238"`a<bCcecltitle28"tblMarketPackages Tahoma`PageFooter`hReportFooter      !"#$%&'()- Line4f Line5f Line6f Line7f Line8fLine9fLine10fLine11fLine12gIm&K[age13gImage14fLine15fLine16fLine17gImage18gImage19fLine20fLine21fLine22gImage23gImage24fLine25fLine26f 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~Image121fLine122fLine123fLine124gImage125gImage126fLine127fLine128fLine129gImage130gImage131fLine132fLine133fLine134gImage135gImage136fLine137fLine138fLine139gImage140gImage141fLine142necl0decltitle0necl1decltitle1necl2decltitle2necl3decltitle3necl4decltitle4necl5decltitle5necl6decltitle6necl7decltitle7necl8decltitle8necl9decltitle9necl10decltitle10necl11decltitle11necl12decltitle12necl13decltitle13necl14decltitle14necl15decltitle15necl16decltitle16necl17decltitle17necl18decltitle18necl19decltitle19necl20decltitle20necl21decltitle21necl22decltitle22necl23decltitle23necl24decltitle24necl25decltitle25necl26decltitle26necl27decltitle27necl28decltitle28PageFooterReportFooterbbreviation";"EntityName"dgnddffggfffffffffggfffggfBlobDeltaDirData &*,PropData+Scripts/+w w ffggfff'K[ggfffggffffffffffffggfffggffffffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfffggfndndndndndndndndndndndndndndndndndndndndndndndndndndndndnd;"ChoiceA2";"ActionA";"Argume&turbo data schema";"ChoiceB 0CB0onB";"ArgumentB";"Narrati33!AutoNumFix () erview TahoAutonumFixcl9Value Listߌ"A 0CB0;"ActionStep";"ActionTyp0)w w Blob *,jBlobDeltaDirData(,.PropData-/PropDataCopy0PropData1Databases.30w w  0CB0 1CB1e List߀"RegionalArcijists";"RegionName";"RMSysDbption";"" Tahomad238"`*a&bcecltitle13,tblRegionalInformation Tahoman07"a.bdl ecl14Value List"EntityID";"EntityAbbreviation";"EntityName";"EntityDescription";"EntityKind";"En021w w Blob DirData2CustomGroups4w w DataAccessPages w w (K[0:<=Babc3e ghXiJj18k6$cFV@ U8Relationships for turbo data Arial834hHP LaserJet 4P@gXXLetter 8 1/2 x 11 in@MSUDHP LaserJet 4P<d < winspoolHP LaserJet 4PLPT1:d28 Arialg37n7 Arial`ReportHeaderd8"bceLabel2018Relationships for turbo datadabcLabel202.Thursday, July 29, 1999`PageHeader`4 Detailf2`sab Line0f2`a b Line1g`a" bZcx Image2h(@@@@@@@@@@@@@@@g`a}bcK Image3x( P@@@@@@@)LVAL*l H  j H *,FMin(qryCusSelectCurrentProjectInterconnects.InProjectArch)qryCusSelectCurrentProjectInterconnects.DestinationElementIDqryCusSelectCurrentProjectInterconnects.SourceElementIDtblApplicationStatus.CurrentArchitecture = tblProjectArchitecture.ProjectIDtblElements.ElementID = tblProjectElements.ElementIDtblApplicationStatus.CurrentArchitecture = tblProjectElements.ProjectIDSELECT 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.ElementIDqryBatchSelectInterfacesBasic.SourceElementID = qryFilteredElements.ElementIDqryBatchSelectInterfacesBasic.SourceElementID = tblTmpBatch.ElementIDqryBatchSelectInterfacesBasic.DestinationElementIDqryBatchSelectInterfacesBasic.SourceElementID(((qryASResponseFlowsNotIncludedProject.ProjectID)=[Project]) AND ((tblRegionalArchitecture.FlowStatus)=0))H?vj Z z \ > h J  F  ) n$f( DX.V(fv<RegionalFlowIDT@?9- w<qryCusSelectCurrentProjectFlowsOOO <tblElementstblElements_1AA' <tblRegionalArchitecture??? <qryCusCurrentProjectElementsIII <qryCusCurrentProjectElementsqryCusCurrentProjectElements_1I <tblStatus### <tblFlows!!! <tblElements''' <tblTempCustomize111 O< < G; p@? g; x@= g; n@= g;p@= g;InProjectArcht@;7++ o;x@; g;n@; g;qryCusSelectCurrentProjectInterconnects___ ; G; G; ; G:X7YZ_____2 @?1% 7:X7YZ_____1 @=1% 7: G:  G: : G9tblApplicationStatustblProjectArchitecture@;qe9 9tblProjectArchitecture.*7 g9tblApplicationStatus999 9tblProjectArchitecture=== 9 G9 G9 9 G8 tblElements.ElementName6 '8tblElementstblProjectElementsh@ ;WK' 8tblApplicationStatustblProjectElements@ ;i]9 8tblElements.ElementName6 g8tblProjectElements.ElementID; g8tblElements''' 8tblApplicationStatus999 8tblProjectElements555 8 G8 G8 8 G7X7YZ_____2@=1% 77X7YZ_____1@ ;1% 77 G7  G7 7 G6@ ; '6tblElementsqryBatchSelectInterfacesBasic@ ;ma' 6tblElements_1qryBatchSelectInterfacesBasic@;qe+ 6qryBatchSelectInterfacesBasictblFilterFlowDeployment@;yK 6qryBatchSelectInterfacesBasictblTmpBatch_1@;qeK 6qryBatchSelectInterfacesBasicqryFilteredElements_1@;uK 6qryBatchSelectInterfacesBasicqryFilteredElements@;}qK LVAL DfqryCusSelectCurrentProjectInterconnects.DestinationElementIDqryCusSelectCurrentProjectInterconnects.SourceElementIDqryCusSelectCurrentProjectInterconnects.InterconnectShowSELECT 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.SourceElementID = qryFilteredInterconnects.SourceElementID) AND (tblRegionalArchitecture.DestinationElementID = 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)) SELECT 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))_j @ @ @ @ @ @ @ @ @ @ @ @ @ @3]3]3]3]3]3 ] 3 ]!3 ]"3]#3]$3]%3]&3]'3](3])3]*3]+3]4],4].4]/4]04]14]24`4`4`4`4`4`4`4`4`4` 4` 4 ` 4 ` 4` 4`4`4`4`4`4`4`4]-5`5`5`5`5`5`5`5`5`5`6`6`!6`"6`#6`$6`%6`&6`'6`(6`)6`*6`+6`,6`-6`.6`/6`06`16<6<6<6<6<6<6<6` 7<7< 7< 7< 7< 7<8< 8<8<8<8<8<8<8<8<8<8 <8<9<9<9<9<9<9<9< 9<:<a<a<a<a<a<a<a< a< a<a <a <a <a <a <a<a<a<<4=a=a=a=a=a=a=a=a=a=a=a= a=a=a=a =a!=a"=a#=a$=a%= a&= a'= a(=a)=a*=a+=a,=i=i=i=i=i=a>i>i>i>i >i >i >i >i >i>i>i>i>i>i> i> i> i>i?i?i?i?i?i?iLVAL *f |2>qryCusCurrentProjectElements_1.ElementID=[tblRegionalArchitecture].[DestinationElementID][qryCusCurrentProjectElements].[ElementID]=[tblRegionalArchitecture].[SourceElementID][tblRegionalArchitecture].[RegionalFlowID]=[qryCusSelectCurrentProjectFlows].[RegionalFlowID][tblRegionalArchitecture].[DestinationElementID]=tblElements_1.ElementID[tblRegionalArchitecture].[Comment][tblRegionalArchitecture].[InRegionalArchitecture][tblRegionalArchitecture].[LastBuild]IIf(IsNull([ProjectID]),32767,[StatusOrder])[tblRegionalArchitecture].[FlowStatus]IIf(IsNull([ProjectID]),False,True)[tblRegionalArchitecture].[RegionalFlowID]qryCusSelectCurrentProjectInterconnects.InterconnectShowSELECT 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))  @ @ @ @ @      !"#$%&'()*+,-./0 1!2"3#4$5%6&7'8(9):S YAccessNBBY  Y Y  Y  Y  Y LId LValueObjectGuidObjectNameProperty ValueBCBDBEYYYId$ObjectGuidProperty$ObjectNamePropertyBHv1b  A A AFZ"~) O % C `  v X : ^ 4 fzpR4h>\ZHJ  G  G  G @G 'tblRegionalArchitecturetblProjectArchitecture@Gwk? ArrowStyle13%% oStatusIDD@G-!! o tblRegionalArchitecture.FlowID= gX@G gN@G gL@G g tblProjectArchitecture===  tblRegionalArchitecture???  G G   G X7YZ_____2v@G1% 7 X7YZ_____1x@G1% 7 G  G   G 6@DN@G / @F@G g@F@G g@CountN@G' o6@qryAPFlowsRegionEnumerateCCC @ G@ G6@ @ GqryAPFlowsRegionForqryAPFlowsRegionRevv@ Gi]7 qryAPFlowsRegionForqryAPFlowsRegionRevn@ Gi]7 qryAPFlowsRegionForqryAPFlowsRegionRev@ Gi]7 qryAPFlowsRegionForqryAPFlowsRegionRev@ Gi]7 ArrowStyle23%% oqryAPFlowsRegionFor.StatusID; gqryAPFlowsRegionFor.FlowID9 gP@ G gF@G gD@G gqryAPFlowsRegionRev777 qryAPFlowsRegionFor777  G G  G 6@tblFlows.FlowName0 ' 6@F@G ' 6@tblAPEntities_1.EntityOrder: ' 6@tblAPEntities.EntityOrder8 ' 6@~@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 6@qryAPFlowsRegionIDSelectAAA  6@tblAPEntitiestblAPEntities_1II+  6@tblAPEntities+++  6@tblFlows!!!  @ G @ G 6@  @ GLVALx < b * F l  0>^DjDqryAPFlowsRegionIDs.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.RegionalFlowIDtblRegionalArchitecture.FlowStatustblRegionalArchitecture.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$~:0p>lCount(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.RegionalFlowIDtblRegionalArchitecture.FlowStatustblRegionalArchitecture.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%% oStatusIDD@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 tV<FqryAPInterconnectsBasic.SourceElementIDMin(qryAPInterconnectsBasic.StatusOrder)qryAPInterconnectsBasic.DestinationElementIDqryAPInterconnectsBasic.SourceElementIDSELECT DISTINCT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, tblStatus.StatusOrder 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])) (((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@J gMinStatusOrderP@J9-- oX@J gN@J 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  GLVALf  T D >XDBTTqryAPInterconnectsShowAllFiltered.[data flow]qryAPInterconnectsShowAllFiltered.StatusIDqryFilteredInteconnectTypes.SourceElementID=qryAPInterconnectsBasicMin.SourceElementIDqryFilteredInteconnectTypes.DestinationElementID=qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredMarketPackageInterconnect.SourceElementID=qryAPInterconnectsBasicMin.SourceElementIDqryFilteredMarketPackageInterconnect.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.DestinationElementIDSELECT DISTINCT tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementID, tblStatus.StatusOrder 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]))3R~: * ~ T  a I o ckM_ UO1u qryAPInterconnectsShowAllEnumerateUUU   G  G    G tblAPEntities_1.EntityOrder: ' tblAPEntities.EntityOrder8 '~@P 'qryAPInterconnectsShowAllFilteredtblAPEntities_1@P}qS qryAPInterconnectsShowAllFilteredtblAPEntities@PymS ArrowStyle03%% oZ@L gT@L gDestinationIDtblAPEntities_1.EntityOrderT++ oSourceIDtblAPEntities.EntityOrderH!! oqryAPInterconnectsShowAllFilteredSSS tblAPEntitiestblAPEntities_1II+ tblAPEntities+++  G G  G@P ' qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@L{G  qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@L{G qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@LY qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@LY qryFilteredElements_1qryAPInterconnectsBasicMin@L{o; qryFilteredElementsqryAPInterconnectsBasicMin@Lwk7 tblFilterFlowDeploymenttblStatusr@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  GO @ @ @ @ @ @ @ @ @ @ @ @ @ @ F F F F F F F F F F F F F F F F  F  F  F  F FFFFFFFFFFFF F!F"F#F$FF%F'F(F)F*F+ F, F-F&F.F0F1F2F3F/F4F6F7F8F9F:F;F<F=F>F?F@FAF5FBFDFEIIFCIIIIIII 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:KCKEKFKGKHKDMMMMMKNU @ @ @ @ @ @ @ @ @ @ @ @ @ @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:KCKEKFKGKHKDMMMMMMMMM M  M M M MMMMMMMMMMMM M MMMMMM M!M"M#M$M%M&M'M(M)M*M+ M, M-M M. M0 M1 M2 R R  R  R M/!R!R!R!R!R !R"R "R "R "R"R"R"R"R"R"R"R" R"R"R"R"R"R"R"R"R"R"R "R!"R""R#" R$" R%"R&"R #R'#R)#R*#R+#R,#R-#R($R.$R0$R1$R2$R3$R4$R5$R6$R7$R8$T$T$T$R/vLVAL<   J  L.jR&vqryFilteredInteconnectTypes.DestinationElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredInteconnectTypes.SourceElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredMarketPackageInterconnect.DestinationElementID = qryAPInterconnectsBasicMin.DestinationElementIDqryFilteredMarketPackageInterconnect.SourceElementID = qryAPInterconnectsBasicMin.SourceElementIDqryFilteredElements.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.ElementID(((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))X miOK 7 L z B >J & eaG%rnD4AQ??} p@} p@@qryCusTempAppendProje?9<@x<@@qryCusTempAppendProjectInterconnectsFilterTw@$ @vvvvvvvt @>RTؐ@/ڐ@@qryCusTempAppendProjectInterconnectsT@@vvjjjjjjjh @ <Fx@]۴@@qryCusTempAppendProjectFlowsT@@ @rffZZZZZZZX @;جHa@Ha@qryCusSelectCurrentProjectInterconnectsUniqueT@|@|||||||z @:جHa@جHa@qryCusSelectCurrentProjectInterconnectsT@@||pppppppn @9nHa@Hِ@qryCusSelectCurrentProjectFlowsT@@xll```````^ @ 7nGa@nGa@qryBatchSelectInterfacesBasicT@`@thh\\\\\\\Z @6KGa@KGa@qryBatchSelectInterfacesT'@@ @j^^RRRRRRRP @5zY;n@,Fn@0qryASResponseFlowsSetStatusProjectT*@@~rrfffffffd @4iAΑ@ VaQS@qryASResponseFlowsNotIncludedRegionTl@@tthhhhhhhf @32@U n@qryASResponseFlowsNotIncludedProjectT@@@vvjjjjjjjh @1mJ@nXБ@0qryASResponseFlowsIncludeRegionT@@xll```````^ @07#3@ n@@qryASResponseFlowsIncludeProjectT@@znnbbbbbbb` @/jБ@$nБ@0qryASResponseFlowsExcludeRegionT@@xll```````^ @.^5@ׯ:@qryASResponseFlowsExcludeProjectTW@@znnbbbbbbb` @-~@= n@qryASResponseFlowsAllT@@dXXLLLLLLLJ @+d6Α@LS@qryASRequestFlowsNotIncludedRegionT@@~rrfffffffd @*K"1@P n@qryASRequestFlowsNotIncludedProjectT@@tthhhhhhhf @)@)Б@@qryASRequestFlowsMissingAppendT@@vjj^^^^^^^\ @(/Ϸ@=3gБ@0qryASRequestFlowsIncludeRegionT@@vjj^^^^^^^\ @& \Б@y2@0qryASRequestFlowsExcludeRegionT\@@vjj^^^^^^^\ @%!:@y:@qryASRequestFlowsExcludeProjectT@@xll```````^ @$ظ@kn@qryASRequestFlowsAllT<@@bVVJJJJJJJH @#B7@/7@ qryASDeleteFlowsProjectTx@|@h\\PPPPPPPN @" :@H:@qryAPInterconnectsShowAllFilteredT@\ @|ppdddddddb @ Fa@Fa@qryAPInterconnectsShowAllCountT'@|@vjj^^^^^^^\ @9f:F(  < $ | > F LZ0b8P&Z>$F@S g$D@S g$X@S g$N@S g$tblProjectArchitecture=== $tblFlowRelationships999 $tblRegionalArchitecture??? $tblElementMapping333 $tblElementMappingtblElementMapping_1YY3 $ $ G#X@S '#H@S g#tblProjectArchitecture.*7 g#tblProjectArchitecture=== # G# # G"@S '" qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@P{G " qryFilteredInteconnectTypesqryAPInterconnectsBasicMin@P{G "qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@PY "qryFilteredMarketPackageInterconnectqryAPInterconnectsBasicMin@PY "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" qryFilteredInteconnectTypesGGG "qryFilteredMarketPackageInterconnectYYY "qryFilteredElementsqryFilteredElements_1aa7 "qryFilteredElements777 "tblFilterFlowDeployment??? "qryAPInterconnectsBasicMinEEE "tblStatus### "tblTmpSelectedElementstblTmpSelectedElements_1mm= "tblTmpSelectedElements=== " G" G" " G!X7YZ_____2@ P1% 7!X7YZ_____1@P1% 7! G!  G! ! G Dr@P / d@P g ElementIDd@P/## o Countr@P' o^LVAL 2 P dnXH :j[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](((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 ((tblTmpSelectedElements.ElementShow)=True) AND ((qryFilteredInteconnectTypes.InterconnectShow)=True)).`6H J N 0  ` 6 l ,  n"\8j$J(n(tblRegionalArchitecture.FlowStatusb@VaU w(tblRegionalArchitecture??? (qryASRequestFlowsNotIncludedRegionUUU ( G( ( G'z@V ''qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@VW 'qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@VW 'qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@VW 'ProjectIDZ@V/# w'RegionalFlowIDL@V9- w'tblRegionalArchitecture??? 'qryASRequestFlowsNotIncludedProjectWWW ' G'tblProjectArchitecture=== O' ' G&qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@VW &qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@SW &qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@SW &tblRegionalArchitecture.InRegionalArchitectureNo}m w&tblRegionalArchitecture??? &qryASResponseFlowsNotIncludedRegionWWW & G& & G%qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@SY %qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@SY %qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@SY %T@S g%d@S g%tblRegionalArchitecture??? %qryASResponseFlowsNotIncludedProjectYYY % % G$tblRegionalArchitecturetblProjectArchitecture@Swk? $tblElementMapping_1tblFlowRelationshipsx@Sk_7 $tblElementMapping_1tblRegionalArchitecture@ Sqe7 $tblRegionalArchitecturetblFlowRelationships@ Ssg? $tblElementMappingtblFlowRelationshipsp@ Sg[3 $tblElementMappingtblRegionalArchitecture@ Sma3 $D@ S g$L@S g$"tblProjectArchitecture.ProjectID? g$\@S gOZ @ @ @ @ @ @ @ @ @ @ @ @ @ @MMMM M  M M M MMMMMMMMMMMM M MMMMMM M!M"M#M$M%M&M'M(M)M*M+ M, M-M M. M0 M1 M2 R R  R  R M/!R!R!R!R!R !R"R "R "R "R"R"R"R"R"R"R"R" R"R"R"R"R"R"R"R"R"R"R "R!"R""R#" R$" R%"R&"R #R'#R)#R*#R+#R,#R-#R($R.$R0$R1$R2$R3$R4$R5$R6$R7$R8$T$T$T$T$T$T$T$T$T$T $R/%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-(W(W(W(W(T))W)W)W)W)W )W )W )W )W )W)W)W)W*W*W*W*W*W*W*W*W*W*W*W*W*W*W*W * W!* W"* W#*W$*W%*W&*W'*W(*W)*W**W+*W,*W+W-+Y+Y+Y+Y+Y+Y+Y+Y+Y+Y +Y +Y +Y +Y +Y+Y+W.LVALPF   t  x04NTtblFlows.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].[DestinationElementID][qryASResponseFlowsAll].[DestinationElementID]=[tblRegionalArchitecture].[SourceElementID][qryASResponseFlowsAll].[FlowIDRequest]=[tblRegionalArchitecture].[FlowID][qryASResponseFlowsAll].[FlowStatus][qryASResponseFlowsAll].[FlowIDRequest][qryASResponseFlowsAll].[SourceElementID][qryASResponseFlowsAll].[DestinationElementID][qryASRequestFlowsNotIncludedRegion].[FlowID]=[tblRegionalArchitecture].[FlowID][qryASRequestFlowsNotIncludedRegion].[DestinationElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASRequestFlowsNotIncludedRegion].[SourceElementID]=[tblRegionalArchitecture].[SourceElementID][qryASRequestFlowsNotIncludedRegion].[FlowStatus](((qryASRequestFlowsNotIncludedProject.ProjectID)=[Project]))qryASRequestFlowsNotIncludedProject.SourceElementID = tblRegionalArchitecture.SourceElementIDqryASRequestFlowsNotIncludedProject.DestinationElementID = tblRegionalArchitecture.DestinationElementIDqryASRequestFlowsNotIncludedProject.FlowID = tblRegionalArchitecture.FlowIDqryASRequestFlowsNotIncludedProject.ProjectIDtblRegionalArchitecture.RegionalFlowID[qryASResponseFlowsNotIncludedRegion].[FlowIDRequest]=[tblRegionalArchitecture].[FlowID]/u= e  = w s I  S UL(V+ + G*@X '*tblFlows_1qryASResponseFlowsAlll@X[O% *tblFlowsqryASResponseFlowsAllf@VWK! *tblElements_1qryASResponseFlowsAllz@VaU+ *tblElementsqryASResponseFlowsAll@V]Q' *qryASRequestFlowsAllqryASResponseFlowsAll@Voc9 *qryASRequestFlowsAllqryASResponseFlowsAll@Voc9 *qryASRequestFlowsAllqryASResponseFlowsAll@Voc9 *qryASRequestFlowsAllqryASResponseFlowsAll|@Voc9 * !qryASResponseFlowsAll.ProjectID> g* "qryASResponseFlowsAll.FlowStatus? g* CorrespondingFlowNametblFlows_1.FlowName\;; o*CorrespondingFlowIDtblFlows_1.FlowIDV77 o*H@V g*tblFlows.FlowName0 g*tblFlows.FlowID. g*DestinationNametblElements_1.ElementNameV// o*DestinationElementIDtblElements_1.ElementID^99 o*SourceNametblElements.ElementNameJ%% o*SourceElementIDtblElements.ElementIDR// o*qryASResponseFlowsAll;;; *qryASRequestFlowsAll999 *tblElements''' *tblElementstblElements_1AA' *tblFlows!!! *tblFlowstblFlows_155! * * G)Z@V ')qryASResponseFlowsAlltblRegionalArchitecture@Vui; )qryASResponseFlowsAlltblRegionalArchitecture@Vui; )qryASResponseFlowsAlltblRegionalArchitecture@Vui; )FlowStatusH@V1% w)FlowIDN@ V) w)DestinationElementIDR@ VE9 w)SourceElementID\@ V;/ w)tblRegionalArchitecture??? )qryASResponseFlowsAll;;; )tblRegionalArchitecture??? O) ) G(qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@ VU (qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@ VU (qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@VU (tblRegionalArchitecture.InRegionalArchitectureYes~m wLVAL R b 2 T X p^.BV*tblElementMapping_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.DestinationElementIDtblRegionalArchitecture.SourceElementID(((qryASRequestFlowsAll.ProjectID) Is Null) And ((qryASRequestFlowsAll.SourceElementID) Is Null) And ((qryASRequestFlowsAll.DestinationElementID) Is Null) And ((qryASRequestFlowsAll.FlowIDRequest) Is Null))tblFlows_1.FlowID=qryASResponseFlowsAll.FlowIDResponseq44> I ] 3 g c s 1ISmOcyO%[-tblElementMappingtblFlowRelationshipsp@Xg[3 -D@X g-L@X g-"tblProjectArchitecture.ProjectID? g-\@X g-D@X g-F@X g-X@X g-N@X g-tblProjectArchitecture=== -tblRegionalArchitecture??? -tblFlowRelationships999 -tblElementMapping333 -tblElementMappingtblElementMapping_1YY3 - - G,@X ',qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@XW ,qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@XW ,qryASRequestFlowsNotIncludedProjecttblRegionalArchitecture@XW ,tblRegionalArchitecture.FlowStatus\@ XaU w,tblRegionalArchitecture??? ,qryASRequestFlowsNotIncludedProjectWWW , G, , G+@ X '+tblElements_1tblRegionalArchitecture@ XeY+ +tblFlows_1qryASResponseFlowsAllp@ X[O% +tblFlowstblRegionalArchitecture`@ X[O! +tblElementstblRegionalArchitecture~@XaU' +qryASResponseFlowsAlltblRegionalArchitecture@Xui; +qryASResponseFlowsAlltblRegionalArchitecture@Xui; +qryASResponseFlowsAlltblRegionalArchitecture@Xui; + CorrespondingFlowNametblFlows_1.FlowName\;; o+ CorrespondingFlowIDtblFlows_1.FlowIDV77 o+H@X g+"qryASResponseFlowsAll.FlowStatus? g+tblFlows.FlowName0 g+DestinationNametblElements_1.ElementNameV// o+SourceNametblElements.ElementNameJ%% o+ tblRegionalArchitecture.FlowID= g+X@X g+N@X g+tblRegionalArchitecture??? +qryASResponseFlowsAll;;; +tblElements''' +tblFlows!!! +tblElementstblElements_1AA' +tblFlowstblFlows_155! + G+ GU_ @ @ @ @ @ @ @ @ @ @ @ @ @ @$T$T$T$T$T$T $R/%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-(W(W(W(W(T))W)W)W)W)W )W )W )W )W )W)W)W)W*W*W*W*W*W*W*W*W*W*W*W*W*W*W*W * W!* W"* W#*W$*W%*W&*W'*W(*W)*W**W+*W,*W+W-+Y+Y+Y+Y+Y+Y+Y+Y+Y+Y +Y +Y +Y +Y +Y+Y+ Y+ Y+Y+Y+Y+Y+Y+Y+Y+Y+W.,Y,Y,Y,Y,Y,Y ,Y!,Y",Y#,Y-Y$-Y&-Y'-Y(-Y)-Y*-Y+-Y,-Y--Y.-Y/-Y0-Y1-Y2-Y3-[-[-[-[-[-Y%.[.[.[.[ .[ .[ .[ .[ .[/[/[/[/[/[/[/[/[/[/[0[0[0[0[0[0[0[0[ 0[!0["0[#0[1[$1[&1['1[(1[)1[*1[+1]1]1[%2]2]2]2]2]2]2] 2] 2] 2] 2] 2]2]2]3]3]3]3]3]3]3]3]3]3], n P v L  r T 6  L &hJRv6 N k1qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@\W 1tblRegionalArchitecture.InRegionalArchitectureYes~m w1tblRegionalArchitecture.FlowStatusd@\aU w1tblRegionalArchitecture??? 1qryASResponseFlowsNotIncludedRegionWWW 1 G1 1 G0|@\ '0qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@\Y 0qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@ \Y 0qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@ \Y 0ProjectID\@ \/# w0RegionalFlowIDL@ \9- w0tblRegionalArchitecture??? 0qryASResponseFlowsNotIncludedProjectYYY 0 G0tblProjectArchitecture=== O0 0 G/qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@ \U /qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@\U /qryASRequestFlowsNotIncludedRegiontblRegionalArchitecture@\U /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@Xqe7 -tblElementMappingtblRegionalArchitecture@Xma3 -tblElementMapping_1tblFlowRelationshipsx@Xk_7 LVAL|.^  X h Plft,^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][qryASRequestFlowsNotIncludedProject].[SourceElementID]=[tblRegionalArchitecture].[DestinationElementID][qryASRequestFlowsNotIncludedProject].[ProjectID][tblRegionalArchitecture].[RegionalFlowID]tblRegionalArchitecture.RegionalFlowID=tblProjectArchitecture.RegionalFlowIDtblFlowRelationships.FlowIDResponse=tblRegionalArchitecture.FlowID3b< D ] ] w 5  ? As8#pxJ~`B4tblFlows!!! 4tblElementstblElements_1AA' 4tblFlowstblFlows_155! 4 G4 G4 4 G3@ ^ '3tblFlows_1qryASRequestFlowsAllh@ ^YM% 3tblFlowsqryASRequestFlowsAllf@^UI! 3tblElements_1qryASRequestFlowsAllx@^_S+ 3tblElementsqryASRequestFlowsAll~@^[O' 3qryASRequestFlowsAllqryASResponseFlowsAll@^oc9 3qryASRequestFlowsAllqryASResponseFlowsAll@^oc9 3qryASRequestFlowsAllqryASResponseFlowsAll@^oc9 3qryASRequestFlowsAllqryASResponseFlowsAll|@^oc9 3 qryASRequestFlowsAll.ProjectID= g3 CorrespondingFlowNametblFlows_1.FlowName\;; o3 CorrespondingFlowIDtblFlows_1.FlowIDV77 o3D@^ g3!qryASRequestFlowsAll.FlowStatus> g3tblFlows.FlowName0 g3tblFlows.FlowID. g3DestinationNametblElements_1.ElementNameV// o3DestinationElementIDtblElements_1.ElementID^99 o3SourceNametblElements.ElementNameJ%% o3SourceElementIDtblElements.ElementIDR// o3qryASResponseFlowsAll;;; 3qryASRequestFlowsAll999 3tblElements''' 3tblElementstblElements_1AA' 3tblFlows!!! 3tblFlowstblFlows_155! 3 3 G2B@^ '2qryASRequestFlowsAlltblRegionalArchitecture@\sg9 2qryASRequestFlowsAlltblRegionalArchitecture@\sg9 2qryASRequestFlowsAlltblRegionalArchitecture@\sg9 2FlowStatus!qryASRequestFlowsAll.FlowStatusR% w2FlowIDF@\) w2DestinationElementIDH@\E9 w2SourceElementIDR@\;/ w2tblRegionalArchitecture??? 2qryASRequestFlowsAll999 2 G2tblRegionalArchitecture??? O2 2 G1qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@\W 1qryASResponseFlowsNotIncludedRegiontblRegionalArchitecture@\W LVALz ` 2 < n |$X .6P^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.DestinationElementIDqryASRequestFlowsAll.DestinationElementID=qryASResponseFlowsAll.SourceElementIDqryASRequestFlowsAll.ProjectID=qryASResponseFlowsAll.ProjectIDqryASRequestFlowsAll.FlowIDRequest(((tblRegionalArchitecture.SourceElementID) Is Null) AND ((tblRegionalArchitecture.DestinationElementID) Is Null) AND ((tblRegionalArchitecture.FlowID) Is Null))Z> @ @ @ @ @ @ @ @ @ @ @ @ @ @+ Y+Y+Y+Y+Y+Y+Y+Y+Y+W.,Y,Y,Y,Y,Y,Y ,Y!,Y",Y#,Y-Y$-Y&-Y'-Y(-Y)-Y*-Y+-Y,-Y--Y.-Y/-Y0-Y1-Y2-Y3-[-[-[-[-[-Y%.[.[.[.[ .[ .[ .[ .[ .[/[/[/[/[/[/[/[/[/[/[0[0[0[0[0[0[0[0[ 0[!0["0[#0[1[$1[&1['1[(1[)1[*1[+1]1]1[%2]2]2]2]2]2]2] 2] 2] 2] 2] 2]2]2]3]3]3]3]3]3]3]3]3]3]3]3]3]3]3]3 ] 3 ]!3 ]"3]#3]$3]%3]&3]'3](3])3]*3]+3]4],4].4]/4]04]14]24`4`4`4`4`4`4`4`4`4` 4` 4 ` 4 ` 4` 4`4`4`4`4`4`4`4]-5`5`5`5`5`5`5`5`5`5`6`6`!6`"6`#6`$6`%6`&6`'6`(6`)6`*6`+6`,6`-6`.6`/6`06`16<6<6<6<6<6<6<6` 7<7< 7< 7< 7< 7<8< 8<8<8<8<8<8<8<8<8<8 <8<9<9<9<9<9<9<42:E Z 0 d d v  6 LRjL.85 e 6qryBatchSelectInterfacesBasictblTmpBatch@;maK 6tblTmpBatch_1.ElementShow8 g6tblTmpBatch.ElementShow6 g6DestinationNametblElements_1.ElementNameV// o6d@; g6SourceNametblElements.ElementNameJ%% o6Z@; g6tblElementstblElements_1AA' 6tblElements''' 6qryBatchSelectInterfacesBasicKKK 6tblTmpBatchtblTmpBatch_1AA' 6tblTmpBatch''' 6qryFilteredElementsqryFilteredElements_1aa7 6qryFilteredElements777 6tblFilterFlowDeployment??? 6 G6 G6 6 G5@; '5qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@^Y 5qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@^Y 5qryASResponseFlowsNotIncludedProjecttblRegionalArchitecture@^Y 5tblRegionalArchitecture.FlowStatus^@^aU w5tblRegionalArchitecture??? 5qryASResponseFlowsNotIncludedProjectYYY 5 G5 5 G4@^ '4tblElements_1tblRegionalArchitecture@^eY+ 4tblFlows_1qryASRequestFlowsAlll@^YM% 4tblFlowstblRegionalArchitecture`@^[O! 4tblElementstblRegionalArchitecture~@^aU' 4qryASRequestFlowsAlltblRegionalArchitecture@^sg9 4qryASRequestFlowsAlltblRegionalArchitecture@^sg9 4qryASRequestFlowsAlltblRegionalArchitecture@^sg9 4 CorrespondingFlowNametblFlows_1.FlowName\;; o4 CorrespondingFlowIDtblFlows_1.FlowIDV77 o4D@ ^ g4!qryASRequestFlowsAll.FlowStatus> g4tblFlows.FlowName0 g4DestinationNametblElements_1.ElementNameV// o4SourceNametblElements.ElementNameJ%% o4 tblRegionalArchitecture.FlowID= g4X@ ^ g4N@ ^ g4tblRegionalArchitecture??? 4qryASRequestFlowsAll999 4tblElements''' ^-6e u = 5  ? k -  y+aU?Z=qryCusCurrentProjectElements_1tblRegionalArchitecture@ h{M =qryCusCurrentProjectElementstblRegionalArchitecture@ hwI =tblRegionalArchitectureqryCusSelectCurrentProjectFlows@ h}? =tblRegionalArchitecturetblElements_1@ heY? = ShowqryFilteredFlows.FlowShow@ w= Comment!tblRegionalArchitecture.CommentL w= InRegionalArch\@ h9- w=LastBuildB@h/# w=FlowStatusDisplayFlowStatusDisplayX@haU3 =FlowStatusD@h1% w=InArchInArchF@h5) =FlowNametblFlows.FlowName@! w=DestinationElementtblElements_1.ElementName\5 w=SourceElementtblElements.ElementNameP+ w=RegionalFlowIDL@h9- w= tblStatus### =qryFilteredFlows111 =qryCusSelectCurrentProjectFlowsOOO =tblElementstblElements_1AA' =tblRegionalArchitecture??? =qryCusCurrentProjectElementsIII =qryCusCurrentProjectElementsqryCusCurrentProjectElements_1I =tblFlows!!! =tblElements''' = G=tblTempCustomize111 O= = G<@h '<tblElementstblRegionalArchitecture@haU' <tblFlowstblRegionalArchitecturel@h[O! <tblStatustblRegionalArchitecturez@h]Q# <qryCusCurrentProjectElements_1tblRegionalArchitecture@ ?{M <qryCusCurrentProjectElementstblRegionalArchitecture@ ?wI <tblRegionalArchitectureqryCusSelectCurrentProjectFlows@ ?}? <tblRegionalArchitecturetblElements_1@ ?eY? < CommentF@?+ w< InRegionalArchd@?9- w<LastBuildJ@?/# w<FlowStatusDisplayFlowStatusDisplayX@?aU3 <FlowStatusL@?1% w<InArchInArchF@?5) <FlowName[tblFlows].[FlowName]D! w<DestinationElementtblElements_1.ElementName\5 w<SourceElement[tblElements].[ElementName]T+ wo!i] M? + JH 6 H o1-Fv`\CR@@p@p@qryReportDiscontinuedJJJJJJJJJJJ ,a@ja@qryReportChangeLogsT'@$|@%`TTHHHHHHHF @za@za@qryReportArchSummaryPart2T@$`@%l``TTTTTTTR @1a@1a@qryReportArchSummaryPart1TY@$@%l``TTTTTTTR @a@a@qryReportArchSummaryTY@$@!bVVJJJJJJJH @⽸a@0)@qryReportArchitectureNamesT@`@!nbbVVVVVVVT @a@a@qryReportAgreementsProjectsT'@@!pddXXXXXXXV @a@a@qryReportAgreementsByTypeT'@@ l``TTTTTTTR @a@1Oa@qryReportAgreementsByTitleT'@@ nbbVVVVVVVT @g'a@ea@qryReportAgreementsByNumberT'@`@ pddXXXXXXXV @a@{a@qryReportAgreementsByLeadStakeholderT'@@ vvjjjjjjjh @M,a@pja@qryReportAgreementsByAssociatedProjectT'@@zznnnnnnnl @za@@qryReportAdditionalProjectOptions2T@@~rrfffffffd @됛a@ .@qryReportAdditionalProjectOptions1T@@~rrfffffffd @Ca@Ca@qryReportAdditionalIntegrationOptionsT'@|@xxlllllllj @a@;Pa@qryMPElementsSelectValidTN@@j^^RRRRRRRP @!_a@!_a@qryMPElementsSelectInvalidT-@@nbbVVVVVVVT @*a@*a@qryMarketPackageEntitiesT@`@j^^RRRRRRRP @ٴa@ٴa@qryInterviewSelectStakeholderUniqueT@@tthhhhhhhf @a@Na@qryInterviewIdentifyCenterStakeholdersTz@@zznnnnnnnl @]a@]a@qryInterviewGenerateElementMappingRSTN@`@vvjjjjjjjh @٪a@٪a@qryInterviewCentersBySegmentT@@rffZZZZZZZX @a@a@0qryInitRegionalServicesT@|@h\\PPPPPPPN @p@bq@qryImportStakeholderRolesTD@@l``TTTTTTTR @Sa@Sa@qryImportReqTextTruncateLocalT'@|@thh\\\\\\\Z @ba@ڠa@qryImportReqTextCompareT_@@h\\PPPPPPPN @I Q@d` @qryImportElementMappingsTk@@j^^RRRRRRRP @}a@TI.@qryGenSelectAllValidProjectFlowsT @@znnbbbbbbb` @ @ @ @ @ @ @ @ @ @ @ @ @ @ @                  !"#$%&'( ) * + , -                   "#$%&'!(*+,-./0)               ! " # $ % & '(*+,-.ee)eeeeeee e e e e eeeeeeeeeeeeeeeeeeee e"e#e$e%e&e'e(e)e!e*e,e-e.e/e0e1e+e2e4e5e6e7e8e3e9e;e<e=e>gggggggggg g g g g e:pLVAL8 L 2 j "^0JfFtblInterviewEtypeEntity.ElementType = tblInterviewCurrentInfo.ElementTypetblInterviewEtypeEntity.EntityID = tblInterviewActionEntities.EntityIDtblInterviewActionEtypes.ElementType = tblInterviewEtypeEntity.ElementTypetblInterviewAnswers.QuestionSequence = tblInterviewActionEtypes.QuestionSequencetblInterviewAnswers.QuestionCategory = tblInterviewActionEtypes.QuestionCategorytblInterviewAnswers.QuestionSequence = tblInterviewActionEntities.QuestionSequencetblInterviewAnswers.QuestionCategory = tblInterviewActionEntities.QuestionCategorytblInterviewCurrentInfo.ElementIDtblElements.ElementID = tblInterviewCentersBySegment.CenterIDtblInterviewCentersBySegment.SegmentID(((tblTempImportElements.ElementID)<>0) AND ((tblTempImportStakeholderRoles.StakeholderID)<>0))tblTempImportStakeholderRoles.ImportElementID = tblTempImportElements.ImportElementIDtblTempImportStakeholderRoles.StakeholderIDtblTempImportEPElementsRequirements.ImportRequirementIDtblTempImportEPElementsRequirements.EquipmentPackageIDtblEPRequirements.EquipmentPackageIDqryImportReqTextTruncateLocal.RequirementLength = qryImportReqTextTruncateRemote.RequirementLengthqryImportReqTextTruncateLocal.TruncatedRequirement = qryImportReqTextTruncateRemote.TruncatedRequirementqryImportReqTextTruncateLocal.EquipmentPackageID = qryImportReqTextTruncateRemote.EquipmentPackageIDqryImportReqTextTruncateLocal.RequirementIDqryImportReqTextTruncateRemote.ImportRequirementIDqryImportReqTextTruncateLocal.EquipmentPackageID(((tblTempImportElements.ElementID)<>0) AND ((tblTempImportElementMapping.EntityID)<>0))tblTempImportElementMapping.ImportElementID=tblTempImportElements.ImportElementIDtblTempImportElementMapping.AutoGeneratedtblTempImportElementMapping.EntityID(((tblElements_1.ElementID)<>tblElements.ElementID) And ((qryCusCurrentProjectElements.ElementID) Is Not Null)) Or (((tblElements_1.ElementID)<>tblElements.ElementID) And ((qryCusCurrentProjectElements_1.ElementID) Is Not Null))?vL.|"  d j L , l N +kMb8bD&VpR[1tblInterviewActionEntitiesEEE tblInterviewAnswers777 tblInterviewSegmentCategoriesKKK  G  GtblElementstblInterviewCentersBySegmentz@dk_' tblElements.ElementName6 gL@d gtblInterviewCentersBySegmentIII tblElements'''   GtblRegionalServices.TouchedNoWG wtblRegionalServices.Comment""WG wtblRegionalServices.Applicability0aS wtblRegionalServices777  G G  G@d 'tblTempImportStakeholderRolestblTempImportElements@duK V@d g!tblTempImportElements.ElementID> gtblTempImportElements;;; tblTempImportStakeholderRolesKKK  G G  GRequirementLengthLen(Trim([Requirement]))Y33 oTruncatedRequirementLeft([Requirement],255)^99 on@ d gl@ d gtblTempImportEPElementsRequirementsWWW  G G  GRequirementLengthLen(Trim([Requirement]))Y33 oTruncatedRequirementLeft([Requirement],255)^99 o!tblEPRequirements.RequirementID> gH@ d gtblEPRequirements333  G G  GqryImportReqTextTruncateLocalqryImportReqTextTruncateRemote@ dK qryImportReqTextTruncateLocalqryImportReqTextTruncateRemote@ dK qryImportReqTextTruncateLocalqryImportReqTextTruncateRemote@dK V@d gd@d g`@d gqryImportReqTextTruncateRemoteMMM qryImportReqTextTruncateLocalKKK  G G  G@d 'tblTempImportElementMappingtblTempImportElements@d}qG   @ @  @@ hivSobQ^Q`QbmkiQUYdbmhivSobQfJiMWmhivSobQfQ^Q`Qbmkm hivSobQfQ^Q`QbmkJOOYmYdbJ^m!hivSobQfQ^Q`QbmkJOOYmYdbJ^fid[QMmm"hivSobQfQ^Q`QbmkiQ^JmQOhivSobQfQ^Q`QbmkiQhoYiQ`QbmkiQ^JmQOhivSobQfkMoiiQbmJiMWhivSobQfkMoiiQbmJiMWbdmYbiQUYdbhivSobQfkMoiiQbmJiMWbdmYbiQUYdbSJkdb^vhivSobQfkMoiiQbmJiMWbdmYbiQUYdbkfQ^^QOdomhivSobQfkfid[QMmhivSobQfkiQUYdbhivSobiQhMoiiQbmJiMWhivSobiQhMoiiQbmJiMWbdmYbiQUYdb hivSobiQhMoiiQbmJiMWbdmYbiQUYdb\Qvk hivSobiQhoYiQ`QbmkJffQbO hivSobkJqQJOO hivSobkJqQJiMWJOO hivSobkJqQJiMWkQmOQ^QmQhivSobkJqQofOJmQhivUQbJ^^dmWQiQbmYmvQbmiYQkhivUQbJffQbOJ^^qJ^YOS^dskhivUQbJffQbOJ^^qJ^YOS^dskMdbkQiqJmYqQhivUQbJffQbOJ^^qJ^YOS^dsk`dOQiJmQhivUQbJffQbOJ^^qJ^YOS^dsk`dOQiJmQkoffdimhivUQbJffQbOJ^^qJ^YOS^dskkoffdimhivUQbJffQbOJ^^qJ^YOS^dskkoffdim:hivUQbJffQbOJ^^qJ^YOS^dskkoffdim<hivUQbJffQbOJ^^qJ^YOfid[QMmS^dskhivUQbJffQbOJ^^qJ^YOfid[QMmS^dskMdbkQiqJmYqQhivUQbJffQbOJ^^qJ^YOfid[QMmS^dsk`dOQiJmQhivUQbJffQbOJ^^qJ^YOfid[QMmS^dsk`dOQiJmQkoffdimhivUQbJffQbOJ^^qJ^YOfid[QMmS^dskkoffdimhivUQbJffQbOJ^^qJ^YOfid[QMmS^dskkoffdim:hivUQbJffQbOJ^^qJ^YOfid[QMmS^dskkoffdim<hivUQbMoiiQbmfid[QMm`fkhivUQbbQsdmWQiQbmYmvQbmiYQk hivUQbkQ^QMmJ^^qJ^YOfid[QMmS^dskbhivY`fdimQ^Q`Qbm`JffYbUkbhivY`fdimiQhmQumMd`fJiQbhivY`fdimiQhmQummiobMJmQ^dMJ^bhivY`fdimiQhmQummiobMJmQiQ`dmQbhivY`fdimkmJ\QWd^OQiid^QkbhivYbYmiQUYdbJ^kQiqYMQkbhivYbmQiqYQsMQbmQikLvkQU`QbmbhivYbmQiqYQsUQbQiJmQQ^Q`Qbm`JffYbUikbhivYbmQiqYQsYOQbmYSvMQbmQikmJ\QWd^OQikb hivYbmQiqYQsbQskmJ\QWd^OQiid^Qkb hivYbmQiqYQskQ^QMmkmJ\QWd^OQiobYhoQb hiv`Ji\QmfJM\JUQQbmYmYQkb hiv`fQ^Q`QbmkkQ^QMmYbqJ^YOb hiv`fQ^Q`QbmkkQ^QMmqJ^YObhiv`ffid[QMmkob`JffQObhiviQfdimJOOYmYdbJ^YbmQUiJmYdbdfmYdbkbhiviQfdimJOOYmYdbJ^fid[QMmdfmYdbk8bhiviQfdimJOOYmYdbJ^fid[QMmdfmYdbk:bhiviQfdimJUiQQ`QbmkLvJkkdMYJmQOfid[QMmbhiviQfdimJUiQQ`QbmkLvJkkdMYJmQOkmJ\QWd^OQibhiviQfdimJUiQQ`QbmkLv^QJOkmJ\QWd^OQibhiviQfdimJUiQQ`QbmkLvbo`LQibhiviQfdimJUiQQ`QbmkLvmYm^QbhiviQfdimJUiQQ`QbmkLvmvfQbhiviQfdimJUiQQ`Qbmkfid[QMmkbhiviQfdimJUiQQ`QbmkkmJ\QWd^OQikbhiviQfdimJiMWYmQMmoiQbJ`QkbhiviQfdimJiMWko``JivbhiviQfdimJiMWko``JivfJim8bhiviQfdimJiMWko``JivfJim:bhiviQfdimMWJbUQ^dUkbhiviQfdimOYkMdbmYboQOb hiviQfdimQ^Q`QbmJiMWYmQMmoiQkhiviQfdimQ^Q`Qbmfid[QMmbJ`QkhiviQfdimQ^Q`Qbmfid[QMmkhiviQfdimQ^Q`QbmkmJ\QWd^OQihiviQfdimQ^Q`QbmkmJ\QWd^OQibJ`QkhiviQfdimQumQbkYdbkhiviQfdimQumQbkYdbkfJim8hiviQfdimSY^mQikQbmYmvM^JkkhiviQfdimSY^mQikQbmYmvmvfQhiviQfdimSY^mQikS^dsOQf^dv`Qbm hiviQfdimSY^mQikS^dsSomoiYkmYM hiviQfdimSY^mQikS^dsmvfQ hiviQfdimSY^mQikYbmQiMdbbQMmk hiviQfdimSY^mQik`f hiviQfdimSobhiviQfdimSobJiMWQ^Q`QbmQbmYmYQkhiviQfdimSobJiMWQ^Q`QbmQbmYmYQkQfhiviQfdimSobJiMWQ^Q`QbmQfhiviQfdimSobJiMWQ^Q`QbmiQhhiviQfdimYbmQiMdbbQMmkJMMQkk^Jvdom`kvkOL@2fl4 , ,   ^bD&x,Z<h(rHJZ@ gR@ gtblStakeholderRoles777 qryInterviewNewStakeholderRolesOOO  G G  G &@ ' F@  g B@  gtblInterviewCurrentInfotblElementMappingz@ ma? qryInterviewIdentifyCenterStakeholderstblInterviewCurrentInfo@ ] StakeholderIDt@ 7++ oB@ gtblElementMapping333 tblInterviewCurrentInfo??? qryInterviewIdentifyCenterStakeholders]]]   Gd@ 'tblInterviewCurrentInfotblStakeholderRoles@qe? B@ g"tblInterviewCurrentInfo.CenterID? gtblStakeholderRoles777 tblInterviewCurrentInfo???  G G  G"(tblInterviewAnswers.Answer > 0)? ' tblInterviewSegmentCategoriestblInterviewCurrentInfo@yK  tblInterviewSegmentCategoriestblInterviewActionEntities@K  tblInterviewSegmentCategoriestblInterviewAnswers@}qK  tblInterviewSegmentCategoriestblInterviewActionEtypes@{K tblInterviewAnswerstblInterviewCurrentInfo~@qe7 tblInterviewEtypeEntitytblInterviewCurrentInfo@dym? tblInterviewActionEntitiestblInterviewEtypeEntity@dsE tblInterviewActionEtypestblInterviewEtypeEntity@d{oA tblInterviewAnswerstblInterviewActionEtypes@dsg7 tblInterviewAnswerstblInterviewActionEtypes@dsg7 tblInterviewAnswerstblInterviewActionEntities@dwk7 tblInterviewAnswerstblInterviewActionEntities@dwk7 Expr2No+ oExpr1No+ o"tblInterviewEtypeEntity.EntityID? gB@d gtblInterviewCurrentInfo??? tblInterviewEtypeEntity??? tblInterviewActionEtypesAAA LVAL P n , D H XljBLZMin(qryCusTempAppendProjectInterconnectSupport.InRegionalArch)Min([InterconnectShow] And [MinOfMPFilterShow] And qryFilteredElements.ElementShow And qryFilteredElements_1.ElementShow)Min(qryCusTempAppendProjectInterconnectSupport.InProjectArch)Min(qryCusTempAppendProjectInterconnectSupport.MinOfLastBuild)(((tblElements_1.ElementName)>[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))tblStatus.StatusID = tblRegionalArchitecture.FlowStatustblElements.ElementID = tblRegionalArchitecture.SourceElementIDtblFlows.FlowID = tblRegionalArchitecture.FlowIDtblRegionalArchitecture.RegionalFlowID = qryFilteredFlows.RegionalFlowIDqryCusCurrentProjectElements_1.ElementID = tblRegionalArchitecture.DestinationElementIDqryCusCurrentProjectElements.ElementID = tblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowID = qryCusSelectCurrentProjectFlows.RegionalFlowIDtblRegionalArchitecture.DestinationElementID = tblElements_1.ElementIDtblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.LastBuildIIf(IsNull([ProjectID]),32767,[StatusOrder])tblRegionalArchitecture.FlowStatusIIf(IsNull([ProjectID]),False,True)tblRegionalArchitecture.RegionalFlowID((([qryCusCurrentProjectElements].[ElementID]) Is Not Null)) Or (((qryCusCurrentProjectElements_1.ElementID) Is Not Null))[tblElements].[ElementID]=[tblRegionalArchitecture].[SourceElementID][tblFlows].[FlowID]=[tblRegionalArchitecture].[FlowID][tblStatus].[StatusID]=[tblRegionalArchitecture].[FlowStatus]+ H  5 j  _ 3 cEQaJ%}Q?qryCusTempAppendProjectInterconnectSupportqryFilteredElements_1@ke ?qryFilteredElementsqryCusTempAppendProjectInterconnectSupport@k7 ?qryCusTempAppendProjectInterconnectSupporttblElements_1@ke ?qryCusTempAppendProjectInterconnectSupporttblElements@k{e ?MinOfInRegionalArchInRegionalArch|@h_S7 ?Expr1Show@h/# ?MinOfInProjectArchInArchz@hMA5 ?MinOfMinOfLastBuildLastBuild|@hUI7 ?DestinationElementtblElements_1.ElementName\5 w?SourceElementtblElements.ElementNameP+ w?qryFilteredInteconnectTypesGGG ?qryFilteredMarketPackageInterconnectYYY ?qryFilteredElementsqryFilteredElements_1aa7 ?tblElementstblElements_1AA' ?tblElements''' ?qryCusTempAppendProjectInterconnectSupporteee ?qryFilteredElements777 ?tblTempCustomize111 O? ? G> v@h '> tblElements_1.ElementName8 g> tblElements.ElementName6 g>qryCusTempAppendProjectInterconnectSupporttblElements_1@he >qryCusTempAppendProjectInterconnectSupporttblElements@h{e >MinOfInRegionalArchInRegionalArch|@h_S7 >ShowShow Min(True)8! >MinOfInProjectArchInArchz@hMA5 >MinOfMinOfLastBuildLastBuild|@hUI7 >DestinationElementtblElements_1.ElementName\5 w>SourceElementtblElements.ElementNameP+ w>tblElementstblElements_1AA' >tblElements''' >qryCusTempAppendProjectInterconnectSupporteee > G>tblTempCustomize111 O> > G=@h '=tblStatustblRegionalArchitecturen@h]Q# =tblElementstblRegionalArchitecture~@haU' =tblFlowstblRegionalArchitecture`@h[O! =tblRegionalArchitectureqryFilteredFlows@hk_? >q @ @ @ @ @ @ @ @ @ @ @ @ @ @9< 9<:<a<a<a<a<a<a<a< a< a<a <a <a <a <a <a<a<a<<4=a=a=a=a=a=a=a=a=a=a=a= a=a=a=a =a!=a"=a#=a$=a%= a&= a'= a(=a)=a*=a+=a,=i=i=i=i=i=a>i>i>i>i >i >i >i >i >i>i>i>i>i>i> i> i> i>i?i?i?i?i?i?i?i?i?i ?i!?i"?i#?i$?i%?i&?i'?i(?i)?i*?l?l?l?l? l? l? l?i@l@l @l @l @l @lAl AlAlAlAlAlAlAlAlAlAlAlAlAlAlA lAlAlAl Al!AlBl"Bl$Bl%Bl&Bl'Bl(Bl)Bl*Bl+Bl,Bl-Bl.Bl/Bl0Bl1Bl2B l3BoBoBoBoBoBl#CoCoCoCo Co Co Co Co CoCoCoCoC oC oC oCoDoDoDoDoDoDoDoDoDoDoDo Do!Do"Do#Do$Do%Do&Do'DoLVAL `D R t Z ftblRegionalArchitecture.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.ElementIDqryCusTempAppendProjectInterconnectSupport.SourceElementID=tblElements.ElementID4:t Z <  f H * > z  g1I~> `2ZJB Show[qryFilteredFlows].[FlowShow]D wBLastBuildJ@ n/# wBFlowStatusDisplayFlowStatusDisplayb@ naU3 BFlowStatusL@ n1% wBInArchd@ n) wBFlowName[tblFlows].[FlowName]D! wBDestinationElementtblElements_1.ElementName\5 wBSourceElement[tblElements].[ElementName]T+ wBRegionalFlowIDT@ n9- wBqryFilteredFlows111 BtblElementstblElements_1AA' BtblRegionalArchitecture??? BtblFlows!!! BtblElements''' BtblStatus### BtblTempCustomize111 OB B GAtblRegionalArchitecturetblStatusj@n]Q? AtblElementstblRegionalArchitecturez@naU' AtblFlowstblRegionalArchitecture\@n[O! AtblRegionalArchitecturetblElements_1@neY? A Comment!tblRegionalArchitecture.CommentL wALastBuildB@n/# wAFlowStatusDisplayFlowStatusDisplayb@naU3 AFlowStatusD@n1% wAInArch\@n) wAFlowNametblFlows.FlowName@! wADestinationElementtblElements_1.ElementName\5 wASourceElementtblElements.ElementNameP+ wARegionalFlowIDL@ k9- wAtblStatus### AtblElementstblElements_1AA' AtblRegionalArchitecture??? AtblFlows!!! AtblElements''' AtblTempCustomize111 OA A G@X7YZ_____2@n1% 7@X7YZ_____1@ k1% 7@ G@  G@ @ G? n@k '? tblElements_1.ElementName8 g? tblElements.ElementName6 g?qryCusTempAppendProjectInterconnectSupportqryFilteredInteconnectTypes@ke ?qryCusTempAppendProjectInterconnectSupportqryFilteredInteconnectTypes@ke ?qryCusTempAppendProjectInterconnectSupportqryFilteredMarketPackageInterconnect@ke ?qryCusTempAppendProjectInterconnectSupportqryFilteredMarketPackageInterconnect@ke .#UQOr LN : J g ?;H#ECAbbDp@Dp@qrybzXa@zXa@qryFunEPElementsAdditionalProjectT'@@|ppdddddddb @aTCWa@TCWa@qryFunEPElementsAdditionalT'@@nbbVVVVVVVT @_Ua@Ua@qryFunEPArchT'@|@RFF:::::::8 @^Ta@Ta@qryFunElementsRegionT'@@bVVJJJJJJJH @]Ra@Ra@qryFunElementsProjectT'@@dXXLLLLLLLJ @\pQa@pQa@qryFunElementEPsRelatedT'@@h\\PPPPPPPN @Z@Oa@@Oa@qryFunElementEPsT'@@ZNNBBBBBBB@ @YMa@;HNa@qryFunAutoRemoveProjectT'@@h\\PPPPPPPN @XgLa@gLa@qryFunAutoRemoveT'@@ZNNBBBBBBB@ @WDLa@DLa@qryFunAutoPotentialProjectTy@$ @nbbVVVVVVVT @ULa@La@qryFunAutoAddProjectT'@@bVVJJJJJJJH @TKa@Ka@qryFunAutoAddT'@@THH<<<<<<<: @SKa@Ka@qryFunArchRequirementsKeysT'@@nbbVVVVVVVT @R]XKa@Ka@qryFunArchRequirementsT'@|@fZZNNNNNNNL @Q.@7Xz@qryFilteredMarketPackagesSupport2TI@@|ppdddddddb @O!R/@`R/@qryFilteredMarketPackagesEntityFlowsT[@@vvjjjjjjjh @N" ,@YM@qryFilteredMarketPackagesT@@l``TTTTTTTR @MJa@2F@qryFilteredMarketPackageInterconnectBasicT@`@tttttttr @L_Ja@!1@qryFilteredMarketPackageInterconnectT @|@vvjjjjjjjh @ Jq5z@F@qryFilteredInterconnectsT@@j^^RRRRRRRP @I4Xؐ@e Е@qryFilteredInteconnectTypesT@@pddXXXXXXXV @HIa@H2\z@qryFilteredFlowsExpandedT @@j^^RRRRRRRP @GW3z@lYM@qryFilteredFlowsT @\ @ZNNBBBBBBB@ @ EWؐ@Wؐ@qryCusTempAppendRegionInterconnectSupportTH@|@tttttttr @D3Vؐ@W L   C Z<h$2@r*xDqryFilteredElementsqryCusTempAppendRegionInterconnectSupport@ p7 DqryCusTempAppendRegionInterconnectSupportqryFilteredInteconnectTypes@ pc DqryCusTempAppendRegionInterconnectSupportqryFilteredInteconnectTypes@ pc DqryCusTempAppendRegionInterconnectSupporttblElements_1@ p}c DqryCusTempAppendRegionInterconnectSupporttblElements@ pyc DExpr1Show@p/# DMinOfMinOfLastBuildLastBuildz@pUI7 DMinOfMinOfInRegionalArchitectureInArch@pi]Q DDestinationElementtblElements_1.ElementName\5 wDSourceElementtblElements.ElementNameP+ wDqryFilteredInteconnectTypesGGG DtblElementstblElements_1AA' DtblElements''' DqryCusTempAppendRegionInterconnectSupportccc DqryFilteredElements777 DqryFilteredElementsqryFilteredElements_1aa7 DqryFilteredMarketPackageInterconnectYYY D GDtblTempCustomize111 OD D GC v@p 'C tblElements_1.ElementName8 gC tblElements.ElementName6 gCqryCusTempAppendRegionInterconnectSupporttblElements_1@p}c CqryCusTempAppendRegionInterconnectSupporttblElements@pyc CMinOfMinOfLastBuildLastBuildz@pUI7 CMinOfMinOfInRegionalArchitectureInArch@pi]Q CDestinationElementtblElements_1.ElementName\5 wCSourceElementtblElements.ElementNameP+ wCtblElementstblElements_1AA' CtblElements''' CqryCusTempAppendRegionInterconnectSupportccc C GCtblTempCustomize111 OC C GBtblStatustblRegionalArchitecturez@p]Q# BtblElementstblRegionalArchitecture@naU' BtblFlowstblRegionalArchitecturel@n[O! BtblRegionalArchitectureqryFilteredFlows@nk_? BtblRegionalArchitecturetblElements_1@neY? LVALx &  N ,8XSELECT 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]))qryCusTempAppendRegionInterconnectSupport.DestinationElementID = tblElements_1.ElementIDqryCusTempAppendRegionInterconnectSupport.SourceElementID = tblElements.ElementIDMin(qryCusTempAppendRegionInterconnectSupport.MinOfLastBuild)Min(qryCusTempAppendRegionInterconnectSupport.MinOfInRegionalArchitecture)[tblStatus].[StatusID]=[tblRegionalArchitecture].[FlowStatus]jv @ @ @ @ @ @ @ @ @ @ @ @ @ @?i?i?i ?i!?i"?i#?i$?i%?i&?i'?i(?i)?i*?l?l?l?l? l? l? l?i@l@l @l @l @l @lAl AlAlAlAlAlAlAlAlAlAlAlAlAlAlA lAlAlAl Al!AlBl"Bl$Bl%Bl&Bl'Bl(Bl)Bl*Bl+Bl,Bl-Bl.Bl/Bl0Bl1Bl2B l3BoBoBoBoBoBl#CoCoCoCo Co Co Co Co CoCoCoCoC oC oC oCoDoDoDoDoDoDoDoDoDoDoDo Do!Do"Do#Do$Do%Do&Do'Do(Do)DrDrDrD rD rD rDoErErEr Er Er ErFr FrFrFrFrFrFrFrFrFrFrFrF rF rF rFr GrGrGrGr Gr!Gr"Gr#Gr$Gr%G r&Gr'Gr(Gr)Gr*Gr+Gr,Gr-Gr.Gr/Gr0Gr1Gr2Gr3GtGtGtGrHtHtHtHtHtHt Ht Ht Ht Ht HtHtHtHtH tH tH tH tH tHtHtHtHtHtItItItItIt It!It"It#It$It%It&It'It(It)It*It+It,ItJt-Jt/Jt0Jt1Jt2Jt3Jt.L4Z J  j ,  j $ i ) U ;_1_U+Cj0PLGtblRegionalArchitectureqryFilteredMarketPackages@s}q? GtblFilterFlowDeploymenttblRegionalArchitecture@sym? GqryFilteredElementstblRegionalArchitecture@sqe7 GqryFilteredElements_1tblRegionalArchitecture@sui; GtblFlowstblFilterFlowTypesj@ sQE! GFlowShow6@ s-!! oGT@ s gGFlowTypeShow[tblFilterFlowTypes].[Select]T)) oGFlowFuturisticShow@ sA55 oGFlowStatusShowD@ s9-- oGDestinationElementShowB@sI== oGSourceElementShowF@s?33 oGT@s gG qryFilteredMarketPackagesCCC GtblRegionalArchitecture??? GqryFilteredElementsqryFilteredElements_1aa7 GqryFilteredElements777 GtblFilterFlowDeployment??? GtblFilterFlowTypes555 GtblFlows!!! GqryFilteredInteconnectTypesGGG GtblFilterFlowFuturistic??? G G GF tblElementMapping.ElementID: 'F Z@s 'F tblElementMapping.ElementID: gFtblEntitiestblElementMappingb@sUI' FtblEntitiestblFilterEntityTypesp@s[O' FtblEntitiestblFilterEntityClassesx@s_S' FElementShow@s3'' oFtblElementMapping.ElementID: gFtblElementMapping333 FtblEntities''' FtblFilterEntityTypes999 FtblFilterEntityClasses=== F GF GF F GEX7YZ_____2@s1% 7EX7YZ_____1@p1% 7E GE  GE E GD v@p 'D tblElements_1.ElementName8 gD tblElements.ElementName6 gDqryFilteredMarketPackageInterconnectqryCusTempAppendRegionInterconnectSupport@pY DqryFilteredMarketPackageInterconnectqryCusTempAppendRegionInterconnectSupport@pY DqryFilteredElements_1qryCusTempAppendRegionInterconnectSupport@p; LVAL0  . r  R 8^"z6tblRegionalArchitecture.FlowStatustblRegionalArchitecture.InRegionalArchitecturetblRegionalArchitecture.RegionalFlowID[qryFilteredInteconnectTypes].[DestinationElementID]=[tblRegionalArchitecture].[DestinationElementID][qryFilteredInteconnectTypes].[SourceElementID]=[tblRegionalArchitecture].[SourceElementID][tblFlows].[FlowID]=[tblRegionalArchitecture].[FlowID][tblRegionalArchitecture].[RegionalFlowID]=[qryFilteredMarketPackages].[RegionalFlowID][tblFilterFlowDeployment].[FlowDeployment]=[tblRegionalArchitecture].[FlowStatus][qryFilteredElements].[ElementID]=[tblRegionalArchitecture].[SourceElementID]qryFilteredElements_1.ElementID=[tblRegionalArchitecture].[DestinationElementID][tblFlows].[FlowType]=[tblFilterFlowTypes].[FlowType][SourceElementShow] And [DestinationElementShow] And [FlowStatusShow] And [FlowFuturisticShow] And [FlowTypeShow] And [MPFilterShow] And [InterconnectShow][qryFilteredMarketPackages].[MPFilterShow]IIf((([tblFilterFlowFuturistic].[Select]=False) And ([tblFlows].[FlowFuturistic]=True)),False,True)[tblFilterFlowDeployment].[Select]qryFilteredElements_1.ElementShow[qryFilteredElements].[ElementShow][tblRegionalArchitecture].[RegionalFlowID](((tblElementMapping.ElementID) Is Not Null))tblEntities.EntityID = tblElementMapping.EntityIDtblEntities.EntityType = tblFilterEntityTypes.EntityTypetblEntities.EntityClass = tblFilterEntityClasses.EntityClassMin(IIf([tblFilterEntityClasses].[Select]>[tblFilterEntityTypes].[Select],[tblFilterEntityClasses].[Select],[tblFilterEntityTypes].[Select]))SELECT tblRegionalArchitecture.DestinationElementID, tblRegionalArchitecture.SourceElementID, Min(tblRegionalArchitecture.InRegionalArchitecture) AS MinOfInRegionalArchitecture, Min(tblRegionalArchitecture.LastBuild) AS MinOfLastBuild FROM tblRegionalArchitecture GROUP BY tblRegionalArchitecture.SourceElementID, tblRegionalArchitecture.DestinationElementIDE5 |^@  D  I f < m " 9 cAu5{1UkM/WJqryFilteredElements777 JqrySelectUniqueInterconnectsIII JqryFilteredMarketPackageInterconnectYYY JqryFilteredInteconnectTypesGGG J GJ GJ J GIqrySelectAllInterconnectstblElementMapping@uqeC IqrySelectAllInterconnectstblElementMapping_1@ uuiC ItblEntitiestblElementMapping_1j@ uYM' ItblEntities_1tblElementMappingj@ uYM+ ItblFilterInterconnectstblEntities_1@ ucW= ItblFilterInterconnectstblEntities@ u_S= IInterconnectShowB@u=11 oId@u gIZ@u gItblElementMappingtblElementMapping_1YY3 ItblElementMapping333 ItblEntitiestblEntities_1AA' ItblEntities''' ItblFilterInterconnects=== IqrySelectAllInterconnectsCCC I GI I GHtblRegionalArchitectureqryFilteredFlows@uk_? HtblElementstblRegionalArchitecturez@uaU' HtblFlowstblRegionalArchitecture\@u[O! HtblRegionalArchitecturetblElements_1@ueY? H ShowqryFilteredFlows.FlowShow@ oH B@u gH !tblRegionalArchitecture.Comment> gH tblFlows.FlowDescription7 gH TouchedFalse2 oHFlowStatusDisplayX@u?33 oHD@s gHtblFlows.FlowKind0 gHtblFlows.FlowName0 gHDestinationElementtblElements_1.ElementName\55 oHSourceElementtblElements.ElementNameP++ oHInArch\@s) oHL@s gHqryFilteredFlows111 HtblElementstblElements_1AA' HtblRegionalArchitecture??? HtblFlows!!! HtblElements''' H H GGqryFilteredInteconnectTypestblRegionalArchitecture@suG GqryFilteredInteconnectTypestblRegionalArchitecture@suG GtblFlowstblRegionalArchitecturel@s[O! LVALf| " | v  h LHn8[qryFilteredMarketPackagesSupport2].[RegionalFlowID]qryFilteredMarketPackageInterconnectBasic.DestinationElementIDqryFilteredMarketPackageInterconnectBasic.SourceElementIDMin(qryFilteredMarketPackageInterconnectBasic.MPFilterShow)qryFilteredMarketPackageInterconnectBasic.DestinationElementIDqryFilteredMarketPackageInterconnectBasic.SourceElementIDqryFilteredInteconnectTypes.SourceElementID = qrySelectUniqueInterconnects.SourceElementIDqryFilteredInteconnectTypes.DestinationElementID = qrySelectUniqueInterconnects.DestinationElementIDqryFilteredMarketPackageInterconnect.DestinationElementID = qrySelectUniqueInterconnects.DestinationElementIDqryFilteredMarketPackageInterconnect.SourceElementID = qrySelectUniqueInterconnects.SourceElementIDqrySelectUniqueInterconnects.DestinationElementID = qryFilteredElements_1.ElementIDqrySelectUniqueInterconnects.SourceElementID = qryFilteredElements.ElementIDqryFilteredElements.ElementShow And qryFilteredElements_1.ElementShow And [minofMPFilterShow] And qryFilteredInteconnectTypes.InterconnectShow[qrySelectAllInterconnects].[SourceElementID]=[tblElementMapping].[ElementID][qrySelectAllInterconnects].[DestinationElementID]=tblElementMapping_1.ElementID[tblEntities].[EntityID]=tblElementMapping_1.EntityIDtblEntities_1.EntityID=[tblElementMapping].[EntityID][tblFilterInterconnects].[EntityClass]=tblEntities_1.EntityClass[tblFilterInterconnects].[EntityClass2]=[tblEntities].[EntityClass][tblFilterInterconnects].[Select][qrySelectAllInterconnects].[DestinationElementID][qrySelectAllInterconnects].[SourceElementID]tblRegionalArchitecture.RegionalFlowID=qryFilteredFlows.RegionalFlowIDtblElements.ElementID=tblRegionalArchitecture.SourceElementIDtblFlows.FlowID=tblRegionalArchitecture.FlowIDtblRegionalArchitecture.DestinationElementID=tblElements_1.ElementIDtblRegionalArchitecture.LastBuildIIf([InRegionalArchitecture],[FlowStatus],0)q{ @ @ @ @ @ @ @ @ @ @ @ @ @ @Do)DrDrDrD rD rD rDoErErEr Er Er ErFr FrFrFrFrFrFrFrFrFrFrFrF rF rF rFr GrGrGrGr Gr!Gr"Gr#Gr$Gr%G r&Gr'Gr(Gr)Gr*Gr+Gr,Gr-Gr.Gr/Gr0Gr1Gr2Gr3GtGtGtGrHtHtHtHtHtHt Ht Ht Ht Ht HtHtHtHtH tH tH tH tH tHtHtHtHtHtItItItItIt It!It"It#It$It%It&It'It(It)It*It+It,ItJt-Jt/Jt0Jt1Jt2Jt3Jt4JwJwJwJwJwJwJwJwJwJt.Kw Kw Kw Kw KwKw LwLwLwLwLwLwLwL wL wLwMwMwMwMwMwMwNwNw!Nw"Nw#Nw$Nw%Nw&Nw'Nw(Nw)Nw*Nw+Nw Ow,Ow.Ow/Ow0Ow1Ow2Ow3Ow4Ow5Ow6Ow-Pw7Pw9Pw:PzPzPzPzPzPzPzPzPzPz Pz Pz Pz Pz PzPzPzPzPzPzPzPw8QzQzQzQzQzQzQzQzQzQzQ z Q z!Q z"Q z#Q z$QzRz%Rz'Rz(Rz)Rz*Rz+Rz&Sz,Sz-;Hv @ f H * r T 6  ` 6 xZ<fH^4 BvX:tJ b8PtblTmpSelectedMP111 P GP P GO,@y 'OtblMarketPackagestblMarketPackageFlows@yi]3 OtblMarketPackageFlows.FlowID; gOR@y gOH@y gOtblMarketPackageFlows;;; OtblMarketPackages333 OtblTmpSelectedMP111 O GO O GNqryFilteredMarketPackagesSupport2qryFilteredMarketPackagesSupport1@yS NqryFilteredMarketPackagesSupport2qryFilteredMarketPackagesSupport1@yS NqryFilteredMarketPackagesSupport2qryFilteredMarketPackagesSupport1@xS NMPFilterShowl@x5)) oNX@x gNt@x gNj@x gNh@u gNqryFilteredMarketPackagesSupport1SSS NqryFilteredMarketPackagesSupport2SSS N GN N GMX7YZ_____2`@x1% 7MX7YZ_____1b@x1% 7M GM  GM M GL |@u gL r@u gLMinOfMPFilterShowv@u?33 oL|@u gLr@u gLqryFilteredMarketPackageInterconnectBasicccc L GL GL L GKX7YZ_____2@x1% 7KX7YZ_____1@x1% 7K GK  GK K GJqryFilteredInteconnectTypesqrySelectUniqueInterconnects@uG JqryFilteredInteconnectTypesqrySelectUniqueInterconnects@uG JqryFilteredMarketPackageInterconnectqrySelectUniqueInterconnects@uY JqryFilteredMarketPackageInterconnectqrySelectUniqueInterconnects@uY JqrySelectUniqueInterconnectsqryFilteredElements_1@usI JqrySelectUniqueInterconnectsqryFilteredElements@u{oI JInterconnectShow@u=11 oJ qrySelectUniqueInterconnects.*= gJqryFilteredElementsqryFilteredElements_1aa7 LVAL z<x[qryFilteredMarketPackagesSupport2].[SourceElementID]=[qryFilteredMarketPackagesSupport1].[SourceElementID]IIf(IsNull([MPShowOverall]),[ShowAll],[MPShowOverall])[qryFilteredMarketPackagesSupport2].[FlowID][qryFilteredMarketPackagesSupport2].[DestinationElementID][qryFilteredMarketPackagesSupport2].[SourceElementID]SELECT DISTINCT qryFilteredMarketPackages.DestinationElementID, qryFilteredMarketPackages.SourceElementID,qryFilteredMarketPackages.MPFilterShow FROM qryFilteredMarketPackagesSELECT DISTINCT qryFilteredMarketPackages.SourceElementID, qryFilteredMarketPackages.DestinationElementID,qryFilteredMarketPackages.MPFilterShow FROM qryFilteredMarketPackages SELECT qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, qryFilteredInterconnects.InterconnectShow,Min(tblRegionalArchitecture.InRegionalArchitecture) AS InRegion, Min(tblRegionalArchitecture.LastBuild) AS LastBuild FROM qryFilteredInterconnects LEFT JOIN tblRegionalArchitecture ON (qryFilteredInterconnects.DestinationElementID = tblRegionalArchitecture.DestinationElementID) AND (qryFilteredInterconnects.SourceElementID = tblRegionalArchitecture.SourceElementID) GROUP BY qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, qryFilteredInterconnects.InterconnectShowSELECT qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, qryFilteredInterconnects.InterconnectShow,Min(tblRegionalArchitecture.InRegionalArchitecture) AS InRegion, Min(tblRegionalArchitecture.LastBuild) AS LastBuild FROM qryFilteredInterconnects LEFT JOIN tblRegionalArchitecture ON (qryFilteredInterconnects.DestinationElementID = tblRegionalArchitecture.SourceElementID) AND (qryFilteredInterconnects.SourceElementID = tblRegionalArchitecture.DestinationElementID) GROUP BY qryFilteredInterconnects.SourceElementID, qryFilteredInterconnects.DestinationElementID, qryFilteredInterconnects.InterconnectShow LVAL d D  > j @ XR`Th  (((tblEPArchRequirements.ArchitectureID)=[Arch]))tblEPElementsRequirements.EPElementReqID = tblEPArchRequirements.EPElementReqIDtblEPArchRequirements.ArchitectureIDtblEPElementsRequirements.RequirementIDtblEPElementsRequirements.ElementIDtblEPElementsRequirements.EquipmentPackageID(((tblEPArchRequirements.ArchitectureID)=[ArchID]))tblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowIDtblRegionalArchitecture.DestinationElementIDtblRegionalArchitecture.SourceElementIDtblRegionalArchitecture.RegionalFlowID((([tblMarketPackageElements].[Select])=Yes) And ((tblMarketPackageElements_1.[Select])=Yes))[tblTmpSelectedMP].[MarketPackageID]=[tblMarketPackages].[MarketPackageID][tblMarketPackages].[MarketPackageID]=[tblMarketPackageElements].[MarketPackageID][tblMarketPackageElements].[ElementID]=[tblElementMapping].[ElementID]tblMarketPackageElements_1.ElementID=tblElementMapping_1.ElementIDtblMarketPackageElements_1.MarketPackageID=[tblMarketPackages].[MarketPackageID][tblMarketPackages].[MarketPackage]=[tblMarketPackageFlows].[MarketPackage][tblMarketPackageFlows].[DestinationEntityID]=tblElementMapping_1.EntityID[tblMarketPackageFlows].[SourceEntityID]=[tblElementMapping].[EntityID]tblMarketPackageElements_1.[Select][tblMarketPackageElements].[Select]tblMarketPackageElements_1.ElementID[tblMarketPackageElements].[ElementID](((tblTmpSelectedMP.ShowAll)=True)) Or (((tblMarketPackages.MarketPackageID)=tblTmpSelectedMP.MarketPackageID) And ((tblTmpSelectedMP.ShowAll)=False))tblMarketPackages.MarketPackage=tblMarketPackageFlows.MarketPackagetblMarketPackageFlows.DestinationEntityIDtblMarketPackageFlows.SourceEntityID[qryFilteredMarketPackagesSupport2].[FlowID]=[qryFilteredMarketPackagesSupport1].[FlowID][qryFilteredMarketPackagesSupport2].[DestinationElementID]=[qryFilteredMarketPackagesSupport1].[DestinationElementID]?0h h      iK-[1yO%mO1j@"x0~`TtblEquipmentPackages999 TtblElements''' TqryFunAutoPotential777 T GT GT T GSb@y 'StblEPElementsRequirementstblEPArchRequirements@yymC SH@y gSN@y gSF@y gSX@y gStblEPArchRequirements;;; StblEPElementsRequirementsCCC S GS GS S GRf@y 'RtblEPArchRequirements.*6 gRtblEPArchRequirements;;; R GR GR R GQ tblTmpSelectedMP.ShowAll7 gQ  tblRegionalArchitecture.FlowID= gQ X@y gQ N@y gQ L@y gQtblTmpSelectedMP.ShowAll7 gQ tblRegionalArchitecture.FlowID= gQX@y gQN@y gQL@y gQtblRegionalArchitecture??? QtblTmpSelectedMP111 Q GQ GQ Q GP@y 'PtblTmpSelectedMPtblMarketPackages@y_S1 PtblMarketPackageElementstblMarketPackages@yocA PtblMarketPackageElementstblElementMapping@yocA PtblMarketPackageElements_1tblElementMapping_1@ywkE PtblMarketPackageElements_1tblMarketPackages@ ysgE PtblMarketPackagestblMarketPackageFlows@ yi]3 PtblMarketPackageFlowstblElementMapping_1@ yma; PtblMarketPackageFlowstblElementMapping@ yi]; PF@ y gPF@y gPMPShowOverallYes<++ oP"[tblMarketPackageFlows].[FlowID]? gPDestinationElementIDH@yE99 oPSourceElementIDL@y;// oPtblElementMappingtblElementMapping_1YY3 PtblElementMapping333 PtblMarketPackageFlows;;; PtblMarketPackages333 PtblMarketPackageElementstblMarketPackageElements_1uuA PtblMarketPackageElementsAAA v @ @ @ @ @ @ @ @ @ @ @ @ @ @JwJwJwJwJwJwJwJwJwJt.Kw Kw Kw Kw KwKw LwLwLwLwLwLwLwL wL wLwMwMwMwMwMwMwNwNw!Nw"Nw#Nw$Nw%Nw&Nw'Nw(Nw)Nw*Nw+Nw Ow,Ow.Ow/Ow0Ow1Ow2Ow3Ow4Ow5Ow6Ow-Pw7Pw9Pw:PzPzPzPzPzPzPzPzPzPz Pz Pz Pz Pz PzPzPzPzPzPzPzPw8QzQzQzQzQzQzQzQzQzQzQ z Q z!Q z"Q z#Q z$QzRz%Rz'Rz(Rz)Rz*Rz+Rz&Sz,Sz.Sz/Sz0Sz1Sz2Sz3Sz4Sz5Sz6Sz7Sz-Tz8Tz:Tz;TzT|T|T|T|T|T|T|T|T|T| T| T| T| T | T |T |T |T |Tz9U|U|U|U|U|U|U|U|U|U|U|U|U|U| U|!U|"U|#U|$U|%U|&U |'U |(U |)U |*U |+U|V|,V|.V|/V|0V|1V|2V|3V|4V|5V|6V|7V|8V|9V|:V|-W|;W~W~W~W~W~W~W~W~W~W~ W~ W~ W~ W~ W~W~W~W~W~W~W~W|