Standard Jet DBµnb` ĀUé©gr@?œ~Ÿ’…š1Åyŗķ0¼ßĢcŁäƟFūŠ¼NĶaģ7ŽœśÄ(ęX,Š`{6¾čß±?@ABCDEFGH I!J"K#L$M%N&O'P(Q)R*S+T,U-V.W/XYZ[\]^_`a b c d e fghijklmnopqrstuvwxyz{|}~€ ‚ ƒ „ … †‡ˆ‰Š‹ŒŽ‘’“”•–—˜"™"š"›"œ""ž"Ÿ" "”" ¢" £" ¤" „" ¦"§"Ø"©"Ŗ"«"¬"­"®"Æ"°"±"²"³"“"µ"¶"·"ø" ¹"!ŗ+»+¼+½+¾+æ+Ą+Į+Ā+Ć+ Ä+ Å+ Ę+ Ē+ Č+É+Ź+Ė+Ģ+Ķ+Ī+Ļ+Š+Ń+Ņ+#Ó+$Ō+%Õ+&Ö+'×+(Ų+)Ł+*Ś++Ū+,Ü/Ż/Ž/ß/ą/į/ā/ć/ä/å/ ę/ ē/ č/ é/ ź/ė/ģ/ķ/ī/ļ/š/ń/ņ/ó/ō/õ/ö/÷/ų/ł/ś/ū/ü/ ż/!ž/"’/#/$/%/&/'/(/)/*/+/, /- /. // Y YYYYYYYYY Y Y Y Y Y€€€€€2+€6+€:+€@+€y+€~+€ƒ+€‡+€ź+ €#+!€&+"€BY€EY€IY€LY€bY€nY€tY€}Y€ƒY€‡Y€‹Y€ŽY€“Y€—Y€œYł   €K®¼•» ½ąŃ?Ņ                         $ %  &  '  (  )  *  +  ,  -  .  /  0  1  2  3  4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P¦¦¦¦¦¦¦¦¦¦ ¦ ¦ ¦ ¦ ¦¦¦¦¦¦¦¦¦¦¦¦ ¦ ¦ ¦!¦!¦!¦"¦ "¦!"¦"#¦##¦$#¦%$¦&$¦'$¦(%¦)%¦*%¦+&¦,&¦-&¦.'¦/'¦0'¦1(¦2(¦3(¦4)¦5)¦6)¦7*¦8*¦9*¦:+¦;+¦<+¦=,¦>,¦?,¦@-¦A-¦B-¦C.¦D.¦E.¦F/¦G/¦H/¦I0¦J0«0«1«1«1«2«2«2«3«3« 3« 4« 4« 4« 5«5«5«6«6«6«7«7«7«8«8«8«9«9«9«:«:«:«;« ;«!;«"<«#<«$<«%=«&=«'=«(>«)>«*>«+?«,?«-?«.@«/@«0@«1A«2A«3A«4B«5B«6B«7C«8C«9C«:D«;D«<D«=E«>E«?E«@F«AF«BF«CG«DG«EG«FH«GH«HH«II«JI®I®J®J®J®K®K®K®L®L® L® M® M® M® N®N®N®O®O®O®P®P®P®Q®Q®Q®R®R®R®S®S®S®T® T®!T®"U®#U®$U®%V®&V®'V®(W®)W®*W®+X®,X®-X®.Y®/Y®0Y®1Z®2Z®3Z®4[®5[®6[®7\®8\®9\®:]®;]®<]®=^®>^®?^®@_®A_®B_®C`®D`®E`®Fa®Ga®Ha®Ib®Jb¹b¹c¹c¹c¹d¹d¹d¹e¹e¹ e¹ f¹ f¹ f¹ g¹g¹g¹h¹h¹h¹h¹i¹i¹i¹i¹j¹j¹j¹j¹k¹k¹k¹l¹ l¹!l¹"m¹#m¹$m¹%n¹&n¹'n¹(o¹)o¹*o¹+p¹,p¹-p¹.q¹/q¹0q¹1r¹2r¹3r¹4s¹5s¹6s¹7t¹8t¹9t¹:u¹;u¹<u¹=v¹>v¹?v¹@w¹Aw¹Bw¹Cx¹Dx¹Exŗyŗyŗyŗzŗzŗzŗ{ŗ{ŗ{ŗ |ŗ |ŗ |ŗ }ŗ }ŗ}ŗ~ŗ~ŗ~ŗŗŗŗ€ŗ€ŗ€ŗŗŗŗ‚ŗ‚ŗ‚ŗƒŗƒŗ ƒŗ!„ŗ"„ŗ#„ŗ$…ŗ%…ŗ&…ŗ'†ŗ(†ŗ)†ŗ*‡ŗ+‡ŗ,‡ŗ-ˆŗ.ˆŗ/ˆŗ0‰ŗ1‰ŗ2‰ŗ3Šŗ4Šŗ5Šŗ6‹ŗ7‹ŗ8‹ŗ9Œŗ:Œŗ;Œŗ<ŗ=ŗ>ŗ?Žŗ@ŽŗAŽŗBŗCŗDŗEŗFŗGŗH‘ŗI‘ŗJ            ! " #^ ] @€ @€w$‰;œK#®()æ*,Ķ-0.Ń0 1Ō)1*×,-ä20ź473ī68ņ9B:ų=>’’@HSQ T:U\8[ZZZZZ Z’[![#[$[%[&['[’"\(\*\+\,\-\.\’)]/]1]2]3]4]5]’0^6^8^9^:^;^’7_<_>_?_@_A_’=`B`D`E`F`G`H`’CaIaKaLaMaNa Oa’JbPbRbSbTbUb’QcVcXcc’Wdddd’eeee’f f f f ff f’ gggggg g’hhhhhh h’ii i!i"i#i’j$j&j'j(j)j *j’%k+k-k.k/k0k 1k’,l2l4l5l6l7l8l’3m9m;mm?m’:n@nBnCnDnEn’AoFoHoIoJoKo’GpLpNpOpPpQpRp’MqSqUqqqq q’Trrrrr r’s s s sss’ tttttt’uuuuuu u’vvv v!v"v #v’w$M   x0µd “_» Z ż “ g  Ķ ‚ ~K ¼ e ­ ©IF ėˆ!ŗ¶GOč‰.ĶplEłš?܁(ĶÉBp°Mźę@''€€€#ÕoIć@#ÕoIć@frmParticipatingStatesDisplayZZZZZZZZZZZ #Y&€€€ć`%-ć@ć`%-ć@frmParmStatee)š@ØFFF:::::::8 ’@%€€€!0_%-ć@!0_%-ć@frmParametere).@ØFFF:::::::8 ’@$€€€ä]%-ć@ä]%-ć@frmImportMenue)T@¢HHH<<<<<<<: ’@#€€€_UZ%-ć@_UZ%-ć@frmImpHue)`@Ø>>>22222220 ’@"€€€ėX%-ć@ėX%-ć@frmImpHe)–@Ø<<<0000000. ’@"Y €€€pĮS%-ć@pĮS%-ć@frmImpAue)`@§>>>22222220 ’@€€€VŠQ%-ć@VŠQ%-ć@frmImpAe)l@§<<<0000000. ’@€€€”O%-ć@”O%-ć@frmHomeUe)b@§>>>22222220 ’@€€€žÆM%-ć@žÆM%-ć@frmHomeEditse)ś@§FFF:::::::8 ’@€€€ä¾K%-ć@ä¾K%-ć@frmHomeCe)Ą@§>>>22222220 ’@€€€ÉĶI%-ć@ÉĶI%-ć@frmHomeAlle)”@§BBB66666664 ’@€€€OÖZ;µEć@ P<µEć@frmExportValidateOrge)@„VVVJJJJJJJH ’@!Y€€€ėŻF%-ć@ėŻF%-ć@frmErrIDse)T@¢@@@44444442 ’@€€€Š”4Óż=ć@Š”4Óż=ć@frmDataItrke)¶@„DDD88888886 ’@€€€ō*E%-ć@ō*E%-ć@frmDataIe)®@„>>>22222220 ’@€€€Ś9C%-ć@Ś9C%-ć@frmContacte)b@„BBB66666664 ’@€€€›lŪ+ć@›lŪ+ć@frmCommentsUwHe)š@¤JJJ>>>>>>>< ’@€€€jÕK+ć@jÕK+ć@frmCommentsUwAe)š@¤JJJ>>>>>>>< ’@ Y€€€yé&I,ć@yé&I,ć@frmCommentsClHe)H@¤JJJ>>>>>>>< ’@€€€”/1,ć@”/1,ć@frmCommentsClAe)H@¤JJJ>>>>>>>< ’@€€€šBē*ć@šBē*ć@frmCommentCoe)Č@¢FFF:::::::8 ’@€€€ć†A%-ć@ć†A%-ć@frmAutoUe)b@£>>>22222220 ’@ €€€@%-ć@@%-ć@frmAutoEditse)ś@£FFF:::::::8 ’@Y €€€‹f=%-ć@‹f=%-ć@frmAutoAlle)”@£BBB66666664 ’@ €€€Ś/<%-ć@Ś/<%-ć@fCoInfoe)č@¢<<<0000000. ’@ €€€”³;%-ć@”³;%-ć@DataYre)T@¢:::......., ’@€ €ÅĢR"-ć@ÅĢR"-ć@UserDefinede)A@¢DDD88888886 ’@€ €ÅĢR"-ć@M®(Mć@SummaryInfoe) @¢DDD88888886 ’@Y€č S"-ć@č S"-ć@SysRele).........., ’€č S"-ć@č S"-ć@Scriptse)0000000000. ’€ÅĢR"-ć@ÅĢR"-ć@Reportse)0000000000. ’€č S"-ć@č S"-ć@Modulese)0000000000. ’€ÅĢR"-ć@ÅĢR"-ć@Formse),,,,,,,,,,* ’€č S"-ć@č S"-ć@DataAccessPagese)@@@@@@@@@@> ’¢ŽR"-ć@¢ŽR"-ć@€MSysRelationshipsd+DDDDDDDDDDB ’¢ŽR"-ć@¢ŽR"-ć@€MSysQueriesd+88888888886 ’¢ŽR"-ć@¢ŽR"-ć@€MSysACEsd+22222222220 ’¢ŽR"-ć@¢ŽR"-ć@€MSysObjectsd+88888888886 ’¢ŽR"-ć@>ŠoIć@€MSysDbe)}@¢:::......., ’@¢ŽR"-ć@¢ŽR"-ć@€Relationshipsd+<<<<<<<<<<: ’¢ŽR"-ć@¢ŽR"-ć@€Databasesd+44444444442 ’¢ŽR"-ć@¢ŽR"-ć@€Tablesd+.........., ’'0üOŸ@Ū|Nø ] £ F ė ēKŒ + Ą s  „ ”I: ÓlØC?Gą…*ĻtEøUī‘*ŪŒAź›PLA•W€FWÕoIć@FWÕoIć@~sq_W€śź–-šDć@fN—-šDć@~sq_cfrmAutoAll~sq_ccmbStatee)4€MR2€KeepLocal TšššZZZZZZZX ’@*YU€€€ÆhÆ%-ć@ÆhÆ%-ć@SetObje).........., ’T€€€øµ­%-ć@øµ­%-ć@ResetObje)22222222220 ’S€€€H;[EµEć@H;[EµEć@mcrDltandAdde)::::::::::8 ’R€€€īŖ%-ć@īŖ%-ć@Macro1e).........., ’Q€€€#f§%-ć@#f§%-ć@AutoKeyse)22222222220 ’P€€€Āų¤%-ć@Āų¤%-ć@AutoExece)22222222220 ’O€€€.˜åØĖEć@ŪTĶEć@STreportHBasePe)(¶Ģč-JJJ>>>>>>>< ’@N€€€, ĢĢĖEć@gx‹PĶEć@STreportHe)ś“Ģč-@@@44444442 ’@M€€€åOUŽĖEć@sF»TĶEć@StreportABasePe)’²Ģč-JJJ>>>>>>>< ’@L€€€įž%-ć@įž%-ć@STreportAalle) @ÆFFF:::::::8 ’@K€€€r÷›%-ć@3cQĶEć@STreportAe)d°Āč-@@@44444442 ’@)YI€€€„‘˜%-ć@„‘˜%-ć@rptSubCoe)T@¬>>>22222220 ’@H€€€Ž–%-ć@Ž–%-ć@rptSub2He)T@¬>>>22222220 ’@G€€€_%•%-ć@_%•%-ć@rptSub2Ae)T@¬>>>22222220 ’@F€€€hr“%-ć@hr“%-ć@rptSub1He)T@„>>>22222220 ’@E€€€”ż‘%-ć@”ż‘%-ć@rptSub1Ae)T@£>>>22222220 ’@D€€€WĪ%-ć@WĪ%-ć@rptSStatese)ś@­BBB66666664 ’@(YB€€€Ņ"%-ć@Ņ"%-ć@rptErrorsAutoe),@­HHH<<<<<<<: ’@A€€€•óŠ%-ć@•óŠ%-ć@rptErrorse)€@­@@@44444442 ’@@€€€B·kĪć@B·kĪć@rptCommentsUwHe)€@­JJJ>>>>>>>< ’@?€€€¦}$+Ķć@¦}$+Ķć@rptCommentsUwAe)€@­JJJ>>>>>>>< ’@>€€€ž‡ŠjĪć@ž‡ŠjĪć@rptCommentsClHe)ž@­JJJ>>>>>>>< ’@=€€€øSĶć@øSĶć@rptCommentsClAe)ž@¬JJJ>>>>>>>< ’@'Y;€€€+I;ģĢć@+I;ģĢć@rptCommentCoe)Č@£FFF:::::::8 ’@:€€€ä¼‰%-ć@伉%-ć@rprErrorsAutoAlle)T@£NNNBBBBBBB@ ’@9€€€ØI“%-ć@ØI“%-ć@PubDefse)0000000000. ’8€€€`‡%-ć@`‡%-ć@tSStates subforme)ž@ ¢NNNBBBBBBB@ ’@7€€€Ņź‚%-ć@Ņź‚%-ć@MainFormOlde)@¬DDD88888886 ’@6€€€z*Eć@z*Eć@MainForme)@¬>>>22222220 ’@&Y4€€€¦U}%-ć@¦U}%-ć@fSStatese):@¬>>>22222220 ’@3€€€Ečz%-ć@Ečz%-ć@frmSubPSte)T@¢@@@44444442 ’@2€€€{Ąw%-ć@{Ąw%-ć@frmSub2HUe)ī@¬@@@44444442 ’@1€€€œŠt%-ć@œŠt%-ć@frmSub2AUe)ī@Ŗ@@@44444442 ’@0€€€ŅØq%-ć@ŅØq%-ć@frmSub1He)¶@Ŗ>>>22222220 ’@/€€€*æn%-ć@*æn%-ć@frmSub1Ae)J@Ŗ>>>22222220 ’@%Y-€€€‘<źŹ3ć@‘<źŹ3ć@frmRatiosHalle)0@ØHHH<<<<<<<: ’@,€€€Šg92ć@Šg92ć@frmRatiosHe)@ØBBB66666664 ’@+€€€ųōė™3ć@ųōė™3ć@frmRatiosAalle)0@©HHH<<<<<<<: ’@*€€€²¦02ć@²¦02ć@frmRatiosAe)0@©BBB66666664 ’@)€€€Ūėh%-ć@Ūėh%-ć@frmPChoHSe)F@©@@@44444442 ’@$YYāĘZžą²w<õ ŗ œ ~ R &  Č ž € b 6 ģ ¬ ‚ d F  ī Š  f H * ž Ņ “ t J ,  ā¶˜X.ņĘš|<ōÖŖŒJ ėĶ”ƒAćÅ›Zßš|^0õŗs8üĢ®r/óÕc€  Gc€’ c€ Gb€€’ž([__LinkKey] = StPrKey)6 'b€tPCauASfrmAutoC// b€  Gb€__LinkKey### Ob€’ b€ Ga€ €’žtSStates.StName. 'a€€’ž(((tSStates.StStatus)="A")): 'a€€’žtSStates.StName. ga€€’žtSStates.StAbbr. ga€tSStates!!! a€’ a€ G`€€’ž(((Left([CvgID],1))="A"))8 '`€€’žCvgIDs.CvgDsc, g`€Cvg€’žRight([CvgID],1)5 o`€LOB€’žLeft([CvgID],1)4 o`€CvgIDs `€’ `€ G_€€’ž([__State] = StAbbr)3 '_€tSStatesfrmAutoAll55! _€  G_€__State O_€’ _€ G^€€’ž([__State] = AUState)4 '^€tPCauASufrmAutoAll55! ^€  G^€__State O^€’ ^€ G]€\@ ']€tPCauASfrmAutoAll33 ]€  G]€__Prod6 O]€__State O]€’ ]€ G\€\@ '\€tPCauASfrmAutoAll33 \€  G\€__Prod5 O\€__State O\€’ \€ G[€\@ '[€tPCauASfrmAutoAll33 [€  G[€__Prod4 O[€__State O[€’ [€ GZ€\@ 'Z€tPCauASfrmAutoAll33 Z€  GZ€__Prod3 OZ€__State OZ€’ Z€ GY€\@ 'Y€tPCauASfrmAutoAll33 Y€  GY€__Prod2 OY€__State OY€’ Y€ GX€\@ 'X€tPCauASfrmAutoAll33 X€  GX€__Prod1 OX€__State OX€’ X€ GW€ €’žtSStates.StName. 'W€€’ž(((tSStates.StStatus)="A")): 'W€€’žtSStates.StName. gW€€’žtSStates.StAbbr. gW€tSStates!!! W€’ W€ GV€€’ž[tStates].[StName]1 gV€€’ž[tStates].[StAbbr]1 gV€tStates V€’ V€ GŽ EAO†Ė ĒM Q MLž šKć * &Jm ®ŖHå GeaF¦ėēD8…CŹ B0,Aw€w€ŌOÖoIć@ŌOÖoIć@~sq_cfrmParw€ŌOÖoIć@ŌOÖoIć@~sq_cfrmParticipatingStatesDisplay~sq_csubfrmSStatesˆˆˆˆˆˆˆˆˆˆˆ øv€ąŁY.šDć@ąŁY.šDć@~sq_cfrmParticipatingStatesDisplay~sq_ccmbStAbre)4€MR2€KeepLocal TĄĄĄ€€€€€€€~ ’@ øt€<® “Gć@<® “Gć@~sq_cfrmParameter~sq_cPPAtypee)4€MR2€KeepLocal Tœœœ\\\\\\\Z ’@s€<® “Gć@ƒŸ® “Gć@~sq_cfrmParameter~sq_cHOtypee)4€MR2€KeepLocal TšššZZZZZZZX ’@øq€Ļ–Į…*Eć@Ļ–Į…*Eć@~sq_cfrmHomeC~sq_ccmbStatee)4€MR2€KeepLocal T–––VVVVVVVT ’@p€Ļ–Į…*Eć@Ļ–Į…*Eć@~sq_cfrmHomeC~sq_ccmbLOBe)4€MR2€KeepLocal T’’’RRRRRRRP ’@øn€qtZµ”ć@qtZµ”ć@~sq_cfrmHomeAll~sq_cSfrmSub2HUe)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@m€”²Zµ”ć@”²Zµ”ć@~sq_cfrmHomeAll~sq_cSfrmSub1Hbe)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@øk€9 5DļDć@„o5DļDć@~sq_cfrmHomeAll~sq_ccmbStatee)4€MR2€KeepLocal TšššZZZZZZZX ’@øi€T»%<µEć@æ&<µEć@~sq_cfrmExportValidateOrg~sq_cList2e)4€MR2€KeepLocal TØØØhhhhhhhf ’@h€æ&<µEć@æ&<µEć@~sq_cfrmExportValidateOrg~sq_cList0e)4€MR2€KeepLocal TØØØhhhhhhhf ’@øf€ĶqäuĶEć@ĶqäuĶEć@~sq_cfrmExportValidate~sq_cList0e)4€MR2€KeepLocal T¢¢¢bbbbbbb` ’@e€ƒ…Dø-ć@¦ĆDø-ć@~sq_cfrmCommentsClH~sq_chPrIDe)4€MR2€KeepLocal Tœœœ\\\\\\\Z ’@øc€IśÆ-ć@IśÆ-ć@~sq_cfrmCommentsClA~sq_cAPrIDe)4€MR2€KeepLocal Tœœœ\\\\\\\Z ’@b€@ę‡*Eć@¬ję‡*Eć@~sq_cfrmAutoC~sq_cSfrmPCauASe)4€MR2€KeepLocal TšššZZZZZZZX ’@ø`€¬ję‡*Eć@¬ję‡*Eć@~sq_cfrmAutoC~sq_ccmbLOBe)4€MR2€KeepLocal T’’’RRRRRRRP ’@ø^€ś-‰e{>ć@ś-‰e{>ć@~sq_cfrmAutoAll~sq_cSfrmSub2AUe)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@]€ś-‰e{>ć@l‰e{>ć@~sq_cfrmAutoAll~sq_cSfrmSub1Afe)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@ø[€@Ŗ‰e{>ć@@Ŗ‰e{>ć@~sq_cfrmAutoAll~sq_cSfrmSub1Ade)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@Z€@Ŗ‰e{>ć@dč‰e{>ć@~sq_cfrmAutoAll~sq_cSfrmSub1Ace)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@+YX€‡&Še{>ć@‡&Še{>ć@~sq_cfrmAutoAll~sq_cSfrmSub1Aae)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@ĢLVAL¤Hģ4Ų h ų Š . Ņ r¶Zž¢P[Parameter].[State]=[tPCauASu].[AUState][tPCauASu].[AUState]=[tPChoHSu].[hUState](([__State] = hState)) AND ([__Prod1] = hPrID)(([__State] = hState)) AND ([__Prod2] = hPrID)(([__State] = hState)) AND ([__Prod1] = hPrID)(([__State] = hState)) AND ([__Prod2] = hPrID)SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; (([__State] = hState)) AND ([__Prod2] = hPrID)(([__State] = hState)) AND ([__Prod1] = hPrID)(((tSStates.StEmail)=No) And ((tSStates.StStatus)="A"))(((tSStates.StEmail)=Yes) And ((tSStates.StStatus)="A"))(((tSStates.StEmail)=Yes) And ((tSStates.StStatus)="A"))(([__State] = AState)) AND ([__Prod6] = APrID)(([__State] = AState)) AND ([__Prod5] = APrID)(([__State] = AState)) AND ([__Prod4] = APrID)(([__State] = AState)) AND ([__Prod3] = APrID)(([__State] = AState)) AND ([__Prod2] = APrID)(([__State] = AState)) AND ([__Prod1] = APrID)VŅ“–xJ,šĀ¤†Xą ¶ { ] ?  Ö › T  ū Ż Æ t 7 Ņ “ – h - š Ę Ø Š \ ! ęŸdF(śæ„=äĘšnPęČŖ~R4ōŹ¬ŽbDĮ£…Y;ł¹›}SŠ†A#×q€tSStates!!! q€’ q€ Gp€€’ž(((Left([CvgID],1))="H"))8 'p€sCvgDsc€’žLeft([CvgDsc],9)= op€Cvg€’žRight([CvgID],1)5 op€LOB€’žLeft([CvgID],1)4 op€CvgIDs p€’ p€ Go€€’ž([__State] = StAbbr)3 'o€tSStatesfrmHomeAll55! o€  Go€__State Oo€’ o€ Gn€€’ž([__State] = hUState)4 'n€tPChoHSufrmHomeAll55! n€  Gn€__State On€’ n€ Gm€\@  'm€tPChoHSfrmHomeAll33 m€  Gm€ __Prod2 Om€__State Om€’ m€ Gl€\@  'l€tPChoHSfrmHomeAll33 l€  Gl€ __Prod1 Ol€__State Ol€’ l€ Gk€ €’žtSStates.StName. 'k€€’ž(((tSStates.StStatus)="A")): 'k€€’žtSStates.StName. gk€€’žtSStates.StAbbr. gk€tSStates!!! k€’ k€ Gj€ €’žtSStates.StName. 'j€€’ž(((tSStates.StStatus)="A")): 'j€€’žtSStates.StName. gj€€’žtSStates.StAbbr. gj€tSStates!!! j€’ j€ Gi€n@ 'i€€’žtSStates.StStatus0 gi€€’žtSStates.StName. gi€tSStates!!! i€’ i€ Gh€ €’žtSStates.StName. 'h€p@ 'h€€’žtSStates.StStatus0 gh€€’žtSStates.StName. gh€tSStates!!! h€’ h€ Gg€ €’žtSStates.StName. 'g€€’ž(((tSStates.StStatus)="A")): 'g€€’žtSStates.StName. gg€€’žtSStates.StAbbr. gg€tSStates!!! g€’ g€ Gf€ €’žtSStates.StName. 'f€p@ 'f€€’žtSStates.StStatus0 gf€€’žtSStates.StName. gf€tSStates!!! f€’ f€ Ge€tLPrdIDs!!! e€  Ge€’ e€ Gd€tLPrdIDs!!! d€  Gd€’ d€ Gc€tLPrdIDs!!! 3TÅŠCźĢœ~B’ į Ć ™ O  Ī ° ’ h  å   a 3 ų ½ v ;  ’ Ń – [  Ł»kM墄fHüŽ“–ZüŽ“–ZüŽ“–ZüŽ“–ZüŽ²qS5 ėÆoQ3é€  G€__State O€’ € G~€€’ž([__State] = StAbbr)3 '~€STreportAr@/# 7~€  G~€__State O~€’ ~€ G}€€’ž[tCoInfo].[CoComment]4 g}€tCoInfo }€’ }€ G|€€’ž([__lnkF] = StPrKey)3 '|€STreportA`@/# 7|€  G|€__lnkF O|€’ |€ G{€€’ž([__lnkE] = StPrKey)3 '{€STreportA`@/# 7{€  G{€__lnkE O{€’ {€ Gz€€’ž([__lnkD] = StPrKey)3 'z€STreportA`@ /# 7z€  Gz€__lnkD Oz€’ z€ Gy€€’ž([__lnkC] = StPrKey)3 'y€STreportA`@ /# 7y€  Gy€__lnkC Oy€’ y€ Gx€tLPrdIDs!!! x€  Gx€’ x€ Gw€€’ž([__cmbStAbr] = StAbbr)6 'w€tSStatesfrmParticipatingStatesDisplay[[! w€  Gw€__cmbStAbr%%% Ow€’ w€ Gv€ €’žtSStates.StName. 'v€€’ž(((tSStates.StStatus)="A")): 'v€€’žtSStates.StName. gv€€’žtSStates.StAbbr. gv€tSStates!!! v€’ v€ Gu€ €’žtSStates.StName. 'u€€’ž(((tSStates.StStatus)="A")): 'u€€’žtSStates.StName. gu€€’žtSStates.StAbbr. gu€tSStates!!! u€’ u€ Gt€€’ž(((CvgIDs.CvgID) Like "A*")); 't€€’žCvgIDs.CvgDsc, gt€CvgType€’žRight([CvgID],1)= ot€CvgIDs t€’ t€ Gs€€’ž(((CvgIDs.CvgID) Like "H*")); 's€€’žCvgIDs.CvgDsc, gs€CvgType€’žRight([CvgID],1)= os€CvgIDs s€’ s€ Gr€€’ž([__LinkKey] = StPrKey)6 'r€tPChoHSfrmHomeC// r€  Gr€__LinkKey### Or€’ r€ Gq€ €’žtSStates.StName. 'q€€’ž(((tSStates.StStatus)="A")): 'q€€’žtSStates.StName. gq€€’žtSStates.StAbbr. g @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€VVVVV’WWWW W W  W’X XXXXXX’ YYYYYYY’ZZZZZZ Z’[![#[$[%[&['[’"\(\*\+\,\-\.\’)]/]1]2]3]4]5]’0^6^8^9^:^;^’7_<_>_?_@_A_’=`B`D`E`F`G`H`’CaIaKaLaMaNa Oa’JbPbRbSbTbUb’QcVcXcc’Wdddd’eeee’f f f f ff f’ gggggg g’hhhhhh h’ii i!i"i#i’j$j&j'j(j)j *j’%k+k-k.k/k0k 1k’,l2l4l5l6l7l8l’3m9m;mm?m’:n@nBnCnDnEn’AoFoHoIoJoKo’GpLpNpOpPpQpRp’MqSqUqqqq q’Trrrrr r’s s s sss’ tttttt’uuuuuu u’vvv v!v"v #v’w$M# @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @€ @w&w'w(w)w’%x*x,x-x’+y.y0y1y2y3y’/z4z6z7z8z9z’5{:{<{={>{?{’;|@|B|C|D|E|’A}F}H}I}’G~J~L~M~N~O~’KPRS’Q€€€€€€’    ’ ‚‚‚‚‚‚’ƒƒƒƒ’„„„„„„’…… …!…"…#…’†$†&†'†(†)†’%‡*‡,‡-‡.‡/‡’+ˆ0ˆ2ˆ3ˆ4ˆ5ˆ’1‰6‰8‰9‰:‰;‰’7Š<Š>Š?Š@ŠAŠ’=‹B‹D‹E‹F‹G‹’CŒHŒJŒKŒLŒMŒ’INPQ’OŽRŽTŽUŽVŽWŽ’SX’Y ’‘ ‘ ‘ ‘‘‘’ ’’’’’’’““““““’””””’• •"•#•$•%•’!–&–(–)–*–+–’'—,—.—/—0—1—’-˜2˜4˜5˜6˜7˜’3™8™:™;™<™=™’9š>š@šAš’?›B›D›E›F›G›’CœHœJœ’I!  GCOŽŁ ÕM MQ œ ˜Kį * &Ji ®ŖHļėG0soF²õńD2soC°éåAY———€„/iĶEć@„/iĶEć@~sq_dSTreportABaseP~sq_dSrptSub1e)4€MR2€KeepLocal T¢¢¢bbbbbbb` ’@–€lĻ,iĶEć@lĻ,iĶEć@~sq_dSTreportABaseP~sq_dSrptCommentsUwAe)4€MR2€KeepLocal T°°°pppppppn ’@¾”€Ų2-iĶEć@Ų2-iĶEć@~sq_dSTreportABaseP~sq_drptCommentCoe)4€MR2€KeepLocal TŖŖŖjjjjjjjh ’@“€­P.iĶEć@­P.iĶEć@~sq_dSTreportABaseP~sq_dChild108e)4€MR2€KeepLocal T¢¢¢bbbbbbb` ’@ø‘€­P.iĶEć@­P.iĶEć@~sq_dSTreportABaseP~sq_dChild104e)4€MR2€KeepLocal T¢¢¢bbbbbbb` ’@€“.iĶEć@“.iĶEć@~sq_dSTreportABaseP~sq_dChild102e)4€MR2€KeepLocal T¢¢¢bbbbbbb` ’@øŽ€Čųl *ć@Čųl *ć@~sq_dSTreportAall~sq_dSrptSubSte)4€MR2€KeepLocal T   ```````^ ’@€ė6m *ć@ė6m *ć@~sq_dSTreportAall~sq_dSrptSubCoe)4€MR2€KeepLocal T   ```````^ ’@ø‹€y/n *ć@y/n *ć@~sq_dSTreportAall~sq_dSrptSub1be)4€MR2€KeepLocal T   ```````^ ’@Š€y/n *ć@œmn *ć@~sq_dSTreportAall~sq_dSrptSub1e)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@øˆ€um *ć@um *ć@~sq_dSTreportAall~sq_dChild106e)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@ø†€Uńm *ć@Uńm *ć@~sq_dSTreportAall~sq_dChild102e)4€MR2€KeepLocal Tžžž^^^^^^^\ ’@…€M2K ĖEć@‚K ĖEć@~sq_dSTreportA~sq_dsubErrorRptAe)4€MR2€KeepLocal T   ```````^ ’@øƒ€īņK ĖEć@īņK ĖEć@~sq_dSTreportA~sq_dSrptSubCoe)4€MR2€KeepLocal TšššZZZZZZZX ’@‚€īņK ĖEć@īņK ĖEć@~sq_dSTreportA~sq_dSrptSub2Ae)4€MR2€KeepLocal TšššZZZZZZZX ’@ø€€Ž³L ĖEć@Ž³L ĖEć@~sq_dSTreportA~sq_dSrptSub1e)4€MR2€KeepLocal T˜˜˜XXXXXXXV ’@€M2K ĖEć@M2K ĖEć@~sq_dSTreportA~sq_dSrptCommentsUwAe)4€MR2€KeepLocal T¦¦¦fffffffd ’@ ø}€M2K ĖEć@M2K ĖEć@~sq_dSTreportA~sq_drptCommentCoe)4€MR2€KeepLocal T   ```````^ ’@ ø{€ZVL ĖEć@ZVL ĖEć@~sq_dSTreportA~sq_dChild106e)4€MR2€KeepLocal T˜˜˜XXXXXXXV ’@z€ZVL ĖEć@ZVL ĖEć@~sq_dSTreportA~sq_dChild104e)4€MR2€KeepLocal T˜˜˜XXXXXXXV ’@ øx€øSĶć@AöSĶć@~sq_dfrmCommentsClA~sq_dAPrIDe)4€MR2€KeepLocal Tœœœ\\\\\\\Z ’@ @ @€€@€€@@   € €€@@ @€€@€@@OJmJviSMdYbSdSi`JomdJ^^Si`JomdMSi`JomdQOYmkSi`JomdoSi`Md``QbmMdSi`Md``QbmkM^JSi`Md``QbmkM^WSi`Md``QbmkosSi`Md``QbmkosJSi`Md``QbmkosWSi`MdbmJMmSi`OJmJYSi`OJmJYmi\Si`QiiYOk Si`QufdimqJ^YOJmQ!Si`QufdimqJ^YOJmQdiU"Si`Wd`QJ^^#Si`Wd`QM$Si`Wd`QQOYmk%Si`Wd`Qo&Si`Y`fJ'Si`Y`fJo(Si`Y`fMd)Si`Y`fW*Si`Y`fWo+Si`Y`fdim`Qbo,Si`fJiJ`QmQi-Si`fJi`kmJmQ.Si`fJimYMYfJmYbUkmJmQkOYkf^Jv/Si`fMJoJkSi`fMWdWkSi`iJmYdkJSi`iJmYdkJJ^^Si`iJmYdkWSi`iJmYdkWJ^^Si`kkmJmQkOYkf^JvSi`koL8JSi`koL8WSi`koL:Jo Si`koL:Wo Si`koLfkm SkkmJmQk SkmJLLi `JYbSdi``JYbSdi`d^OmkkmJmQkkoLSdi`foLOQSkifiQiidikJomdJ^^ifmMd``QbmMdifmMd``QbmMdWifmMd``QbmkM^JifmMd``QbmkM^WifmMd``QbmkosJifmMd``QbmkosWifmQiidikifmQiidikJomdifmQiidikWd`QifmkkmJmQkifmkoL8JifmkoL8WifmkoL:JifmkoL:W ifmkoLMd!ifmkoLkm"kmiQfdimJ#kmiQfdimJJ^^$kmiQfdimJLJkQf%kmiQfdimW&kmiQfdimWLJkQf'JomdQuQM(Jomd\Qvk)`JMid8*`MiO^mJbOJOO+iQkQmdL[,kQmdL[-OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSMdYbSd+kh+MMdkmJmQ.+kh+MSi`JomdJ^^+kh+MM`LkmJmQ/+kh+MSi`JomdJ^^+kh+MkSi`koL8JJ+kh+MSi`JomdJ^^+kh+MkSi`koL8JL+kh+MSi`JomdJ^^+kh+MkSi`koL8JM+kh+MSi`JomdJ^^+kh+MkSi`koL8JO+kh+MSi`JomdJ^^+kh+MkSi`koL8JQ+kh+MSi`JomdJ^^+kh+MkSi`koL8JS+kh+MSi`JomdJ^^+kh+MkSi`koL:Jo+kh+MSi`JomdJ^^+kh+MkSi`koLkm+kh+MSi`JomdM+kh+MM`L^dL+kh+MSi`JomdM+kh+MM`LkmJmQ +kh+MSi`JomdM+kh+MkSi`fMJoJk +kh+MSi`Md``QbmkM^J+kh+MJfiYO +kh+MSi`Md``QbmkM^J+kh+MWfiYO +kh+MSi`Md``QbmkM^W+kh+MWfiYO +kh+MSi`QufdimqJ^YOJmQ+kh+M^Ykm6+kh+MSi`QufdimqJ^YOJmQ+kh+MkmJmQ+kh+MSi`QufdimqJ^YOJmQdiU+kh+M^Ykm6+kh+MSi`QufdimqJ^YOJmQdiU+kh+M^Ykm:+kh+MSi`QufdimqJ^YOJmQdiU+kh+MkmJmQ+kh+MSi`Wd`QJ^^+kh+MM`LkmJmQ+kh+MSi`Wd`QJ^^+kh+MkSi`koL8W+kh+MSi`Wd`QJ^^+kh+MkSi`koL8WL+kh+MSi`Wd`QJ^^+kh+MkSi`koL:Wo+kh+MSi`Wd`QJ^^+kh+MkSi`koLkm+kh+MSi`Wd`QM+kh+MM`L^dL+kh+MSi`Wd`QM+kh+MM`LkmJmQ+kh+MSi`Wd`QM+kh+MkSi`fMWdWk+kh+MSi`fJiJ`QmQi+kh+MWdmvfQ+kh+MSi`fJiJ`QmQi+kh+MffJmvfQ+kh+MSi`fJi`kmJmQ+kh+MkmJmQ^Ykm+kh+MSi`fJimYMYfJmYbUkmJmQkOYkf^Jv+kh+MM`LkmJLi+kh+MSi`fJimYMYfJmYbUkmJmQkOYkf^Jv+kh+MkoLSi`kkmJmQk+kh+OSi`Md``QbmkM^J+kh+OJfiYO`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOń& €@€€ €@€@  €€kvkiQ^ mJL^Qk+kh+MSMdYbSd+kh+MMdkmJmQ.+kh+MSi`JomdJ^^+kh+MM`LkmJmQ/+kh+MSi`JomdJ^^+kh+MkSi`koL8JJ+kh+MSi`JomdJ^^+kh+MkSi`koL8JL+kh+MSi`JomdJ^^+kh+MkSi`koL8JM+kh+MSi`JomdJ^^+kh+MkSi`koL8JO+kh+MSi`JomdJ^^+kh+MkSi`koL8JQ+kh+MSi`JomdJ^^+kh+MkSi`koL8JS+kh+MSi`JomdJ^^+kh+MkSi`koL:Jo+kh+MSi`JomdJ^^+kh+MkSi`koLkm+kh+MSi`JomdM+kh+MM`L^dL+kh+MSi`JomdM+kh+MM`LkmJmQ +kh+MSi`JomdM+kh+MkSi`fMJoJk +kh+MSi`Md``QbmkM^J+kh+MJfiYO +kh+MSi`Md``QbmkM^J+kh+MWfiYO +kh+MSi`Md``QbmkM^W+kh+MWfiYO +kh+MSi`QufdimqJ^YOJmQ+kh+M^Ykm6+kh+MSi`QufdimqJ^YOJmQ+kh+MkmJmQ+kh+MSi`QufdimqJ^YOJmQdiU+kh+M^Ykm6+kh+MSi`QufdimqJ^YOJmQdiU+kh+M^Ykm:+kh+MSi`QufdimqJ^YOJmQdiU+kh+MkmJmQ+kh+MSi`Wd`QJ^^+kh+MM`LkmJmQ+kh+MSi`Wd`QJ^^+kh+MkSi`koL8W+kh+MSi`Wd`QJ^^+kh+MkSi`koL8WL+kh+MSi`Wd`QJ^^+kh+MkSi`koL:Wo+kh+MSi`Wd`QJ^^+kh+MkSi`koLkm+kh+MSi`Wd`QM+kh+MM`L^dL+kh+MSi`Wd`QM+kh+MM`LkmJmQ+kh+MSi`Wd`QM+kh+MkSi`fMWdWk+kh+MSi`fJiJ`QmQi+kh+MWdmvfQ+kh+MSi`fJiJ`QmQi+kh+MffJmvfQ+kh+MSi`fJi`kmJmQ+kh+MkmJmQ^Ykm+kh+MSi`fJimYMYfJmYbUkmJmQkOYkf^Jv+kh+MM`LkmJLi+kh+MSi`fJimYMYfJmYbUkmJmQkOYkf^Jv+kh+MkoLSi`kkmJmQk+kh+OSi`Md``QbmkM^J+kh+OJfiYO+kh+OkmiQfdimJ+kh+OMWY^O86:+kh+OkmiQfdimJ+kh+OMWY^O86>+kh+OkmiQfdimJ+kh+OMWY^O86B+kh+OkmiQfdimJ+kh+OMWY^O86F+kh+OkmiQfdimJ+kh+OifmMd``QbmMd+kh+OkmiQfdimJ+kh+OkifmMd``QbmkM^J+kh+OkmiQfdimJ+kh+OkifmMd``QbmkosJ+kh+OkmiQfdimJ+kh+OkifmkoL8+kh+OkmiQfdimJ+kh+OkifmkoL8L +kh+OkmiQfdimJ+kh+OkifmkoL:J +kh+OkmiQfdimJ+kh+OkifmkoLMd +kh+OkmiQfdimJ+kh+OkifmkoLkm +kh+OkmiQfdimJ+kh+OkoLQiidiifmJ +kh+OkmiQfdimJJ^^+kh+OMWY^O86:+kh+OkmiQfdimJJ^^+kh+OMWY^O86>+kh+OkmiQfdimJJ^^+kh+OMWY^O86B+kh+OkmiQfdimJJ^^+kh+OMWY^O86F+kh+OkmiQfdimJJ^^+kh+OkifmkoL8+kh+OkmiQfdimJJ^^+kh+OkifmkoL8L+kh+OkmiQfdimJJ^^+kh+OkifmkoL:J+kh+OkmiQfdimJJ^^+kh+OkifmkoLMd+kh+OkmiQfdimJJ^^+kh+OkifmkoLkm+kh+OkmiQfdimJJ^^+kh+OkoLQiidiifmJ+kh+OkmiQfdimJLJkQf+kh+OMWY^O86:+kh+OkmiQfdimJLJkQf+kh+OMWY^O86>+kh+OkmiQfdimJLJkQf+kh+OMWY^O86B+kh+OkmiQfdimJLJkQf+kh+OMWY^O86F+kh+OkmiQfdimJLJkQf+kh+OifmMd``QbmMd+kh+OkmiQfdimJLJkQf+kh+OkifmMd``QbmkM^J+kh+OkmiQfdimJLJkQf+kh+OkifmMd``QbmkosJ+kh+OkmiQfdimJLJkQf+kh+OkifmkoL8+kh+OkmiQfdimJLJkQf+kh+OkifmkoL8L"+kh+OkmiQfdimJLJkQf+kh+OkifmkoL:J"+kh+OkmiQfdimJLJkQf+kh+OkifmkoLMd"+kh+OkmiQfdimJLJkQf+kh+OkifmkoLkm"+kh+OkmiQfdimJLJkQf+kh+OkoLQiidiifmJ"+kh+OkmiQfdimW+kh+OMWY^OFH"+kh+OkmiQfdimW+kh+OifmMd``QbmMd"+kh+OkmiQfdimW+kh+OkifmMd``QbmkM^W"`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOØLVAL  @ĪźœZĢ€.ŽNŅ[AUaIfEn]+[AUpIfEn]+[AUpWn]+[AUpWa]+[AUpNRn]+[AUc60n]+[AUc59n]tPCauASu.AUState=tPChoHSu.hUState[Parameter].[State]=[tSStates].[StAbbr][Parameter].[State]=[tPCauASu].[AUState][tPCauASu].[AUState]=[tPChoHSu].[hUState][tPCauAS].[AState]=[tSStates].[StAbbr][Parameter].[State]=[tPCauAS].[AState]tPCauASu.AUState=tPChoHSu.hUStatetPCauASu.AUState=tPChoHSu.hUState[Parameter].[State]=[tSStates].[StAbbr]SELECT [tPCauASu].[AUcomment], [tPChoHSu].[hUcomment], [tSStates].[StName], [tSStates].[StAbbr] FROM (tPCauASu INNER JOIN tPChoHSu ON [tPCauASu].[AUState]=[tPChoHSu].[hUState]) INNER JOIN tSStates ON [tPChoHSu].[hUState]=[tSStates].[StAbbr]; SELECT [tPCauAS].[APrID], [tPCauAS].[AScID], [tPCauAS].[ACcomment], [tSStates].[StName], [tSStates].[StAbbr] FROM tPCauAS INNER JOIN tSStates ON [tPCauAS].[AState]=[tSStates].[StAbbr]; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; #ZÄ„fHÄ„fHÄ „ f H  ž ¾ } _ A # ÷ Ł »  q 1 ń Ó µ ‰ k # ē É «  c ! įĆ„{]Ū½ŸuWÕ·™oQĻ±“iK É«cEĆ„‡Y;õ³•wY-ńŧa!叀’ € GŽ€€’ž([__State] = StAbbr)3 'Ž€tSStatesSTreportAall99! Ž€  GŽ€__State OŽ€’ Ž€ G€tCoInfo €  G€’ € GŒ€€’ž([__StAbbr] = AUState)5 'Œ€tPCauASuSTreportAall99! Œ€  GŒ€__StAbbr!!! OŒ€’ Œ€ G‹€€’ž([__lnkB] = StPrKey)3 '‹€STreportAall`@5) 7‹€  G‹€__lnkB O‹€’ ‹€ GŠ€€’ž([__lnkA] = StPrKey)3 'Š€STreportAall`@5) 7Š€  GŠ€__lnkA OŠ€’ Š€ G‰€€’ž([__lnkF] = StPrKey)3 '‰€STreportAall`@5) 7‰€  G‰€__lnkF O‰€’ ‰€ Gˆ€€’ž([__lnkE] = StPrKey)3 'ˆ€STreportAall`@5) 7ˆ€  Gˆ€__lnkE Oˆ€’ ˆ€ G‡€€’ž([__lnkD] = StPrKey)3 '‡€STreportAall`@5) 7‡€  G‡€__lnkD O‡€’ ‡€ G†€€’ž([__lnkC] = StPrKey)3 '†€STreportAall`@5) 7†€  G†€__lnkC O†€’ †€ G…€€’ž([__State] = St)/ '…€qryAutoEditsSTreportA;;) …€  G…€__State O…€’ …€ G„€€’ž([__State] = StAbbr)3 '„€tSStatesSTreportA33! „€  G„€__State O„€’ „€ Gƒ€tCoInfo ƒ€  Gƒ€’ ƒ€ G‚€€’ž([__State] = AUState)4 '‚€tPCauASuSTreportA33! ‚€  G‚€__State O‚€’ ‚€ G€€’ž([__lnkB] = StPrKey)3 '€STreportA`@/# 7€  G€__lnkB O€’ € G€€€’ž([__lnkA] = StPrKey)3 '€€STreportA`@/# 7€€  G€€__lnkA O€€’ €€ G€€’ž([__State] = StAbbr)3 '€STreportAä@/# 7ŌLVAL   @ąŠ@ņ RōqAutoCi_Crosstab.AState=qHomeCi_Crosstab.hStateqAutoCi_Crosstab.AState=tSStates.StAbbrqAutoCi_Crosstab.ACoCode=qAutoUi.AUCoCodeqAutoCi_Crosstab.AState=qAutoUi.AUStateqDataCompleteA.AState=tSStates.StAbbrqDataCompleteA.AState=qDataCompleteH.hStateSELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; LVAL  @ą~0Žb[NAICnamesCO].[SHORT_COMPANY_NAME][hUaIfEn]+[hUpIfEn]+[hUpWn]+[hUpWa]+[hUpNRn]+[hUc60n]+[hUc59n]qHomeCi_Crosstab.hCoCode=qHomeUi.hUCoCodeqHomeCi_Crosstab.hState=qHomeUi.hUStateqAutoCi_Crosstab.ACoCode=qHomeCi_Crosstab.hCoCodeSELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; ōLVAL   @ąŽLž°d[tPCauASu].[AUState]=[Parameter].[State][tPCauAS].[AState]=[Parameter].[State][tPChoHS].[hState]=[tPChoHSu].[hUState][tPCauAS].[AState]=[tPCauASu].[AUState]Parameter.State = tSStates.StAbbr[zCoInfo].[CoCode]=[NAICnamesCO].[COCODE]SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; SELECT [tPCauAS].[ACoCode], [tPCauAS].[AState], [tPCauAS].[APrID], [tPCauAS].[StPrKey], [tPCauAS].[AScID], [tPCauAS].[AClCtTp], [tPCauAS].[AClOBn], [tPCauAS].[AClODn], [tPCauAS].[AClCPn], [tPCauAS].[AClCDn], [tPCauAS].[AClPty], [tPCauAS].[AClMdn], [tPCauAS].[AClS30n], [tPCauAS].[AClS60n], [tPCauAS].[AClS90n], [tPCauAS].[AClS180n], [tPCauAS].[AClS365n], [tPCauAS].[AClS366n], [tPCauAS].[ACrMdn], [tPCauAS].[ACsBn], [tPCauAS].[ACsCn], [tPCauAS].[ACsEn], DLookUp("CvgDsc","CvgIDs","CvgID = 'A" & [APrID] & "'") AS Coverage, [tPCauAS].[ACcomplete] FROM tPCauAS; 3XŅ“f) ķĆ„_ć ¹ › U  ÷ Ł Æ ‘ K ķ Ļ „ ‡ A  ć Å ™ X :  š Ņ Œ L .  äĘ€@"Ś¼v6śŠ²l,šÄ¦\żßĮ•wY-Å…gI’­qS5 ŻæƒY;ńž€tCoInfo ž€’ ž€ G€\@  '€STreportH`@!/# 7€  G€__Prod2 O€__State O€’ € Gœ€€’ž([__State] = St)/ 'œ€qryAutoEditsSTreportABasePEE) œ€  Gœ€__State Oœ€’ œ€ G›€€’ž([__State] = StAbbr)3 '›€tSStatesSTreportABaseP==! ›€  G›€__State O›€’ ›€ Gš€tCoInfo š€  Gš€’ š€ G™€€’ž([__State] = AUState)4 '™€tPCauASuSTreportABaseP==! ™€  G™€__State O™€’ ™€ G˜€€’ž([__lnkB] = StPrKey)3 '˜€STreportABaseP`@!9- 7˜€  G˜€__lnkB O˜€’ ˜€ G—€€’ž([__lnkA] = StPrKey)3 '—€STreportABaseP`@!9- 7—€  G—€__lnkA O—€’ —€ G–€€’ž([__State] = StAbbr)3 '–€STreportABasePä@!9- 7–€  G–€__State O–€’ –€ G•€€’ž([__State] = StAbbr)3 '•€STreportABasePr@ 9- 7•€  G•€__State O•€’ •€ G”€€’ž[tCoInfo].[CoComment]4 g”€tCoInfo ”€’ ”€ G“€€’ž([__lnkF] = StPrKey)3 '“€STreportABaseP`@ 9- 7“€  G“€__lnkF O“€’ “€ G’€€’ž([__lnkE] = StPrKey)3 '’€STreportABaseP`@ 9- 7’€  G’€__lnkE O’€’ ’€ G‘€€’ž([__lnkD] = StPrKey)3 '‘€STreportABaseP`@ 9- 7‘€  G‘€__lnkD O‘€’ ‘€ G€€’ž([__lnkC] = StPrKey)3 '€STreportABaseP`@9- 7€  G€__lnkC O€’