WPC݆ LZdwweMt[Y²a8-mq2_ .zg^ᵳҭnklb gg>N ti%}ibCfDFq&9бyF'y|,W7Uy%Ba(#OGw&'2G/)~]F-,@K{m;趛I!q gum,t,{hNBM4 *NKTiW y+gG"{\QyhLGz^ت ͋J>w?p%Ou!xFeekqNo;O!t)5FYezؠ:c=DWߞPZҶ,Tׅw!9wU_Ƌu$1k jW$#gԬ<1F#\//a,ai,ˆ6|A jh3r\! 0T % 0d#!JPk 0M<UN@ 0 0Xt 1SU@ 0YM[ 1_ 0 0 0EwY 0EZ 0\ mBw@Yj 1 1u 1 0M! M% 0) 0n M!^ ! 0K)! 0Ect! 03! 0hi"M" 0|" 0Q#M#4# 0E#$ 0$ *% 0k2 1/3 0E3 0d4 0E4N5 0E5 B6 0E6 17 1-8M8 18 1?9]9 09 0: 0xc; 0<; 1< B<M< 0<U0==U >> 1> 1^? 1? 1l@ 1@ 1zA 1B 1B 1C 1C 0RD BoD 1D 1E 1E 1!F 1F 0/G 1GM`H 01dH 0=H 0H 0>I 0I 0J 0pVK 0L 0azM 0M 0N 09CO 0|O 02XP 0P 0:Q 0Q 0_ER 0 R 0kS 0U B*V D3 W C=W D+WW 0W 0IY 060Z 0fZ 0:n[ 0h[ 0F\U6V\U*\M\M\M\Un@\M]M]M ] 0] 0J] 0N]M%^M)^ 0-^M_M_M _ 1_M_ 1_ 1"` 1` 10a 1a 1>b 1b 1Lc 1c 1Zd 1d 1he 0e 1f 1|g 1h 1h 1i 1i 1j 1j 1-k 1k 1;l 1l 1Im 1m 1Wn 1n 1eo 1o 1spU,pM&qM*qM.q C2q ALq 1qMpr 1tr 1r 1s 0 tM(u 1,uMuMuMuMuMuMuMuMuMu CKuM"vb&vM*v 1.vMvMvMvMvMvMvMvMvMv 1vM`wMdwMhw\;lwMwzwU@%yMey~iy CyBzMCz GzMXzM\zM`zUJdz 0zf0{a2{U<F{ 1{ 1 | 1|} C} 16} 1} 1D~~MǀEˀf̀MπMӀM׀ 0ۀaف 0 0 0u 0i 0:c/ ̆>$"Small Circle X X% %"0  X X% %%&>I$%-%%%XYiX%%-HP LaserJet 8000 Series0M:\apps32\corel\wp8\Template\report.wpt(Y2@$ I!%%%%X'X%%  x9 Z 6Times New Roman Regular\C6D6_Subhead 4Subheading Level 4U`%%   "U`%% (^B$0  8 %-3579`jEGKOSW[_cAutoList25"22""""")1)a)Level 1Level 2Level 3Level 4Level 5)L  Z (CG Times Regular\QDD_6_Subhead 2Subheading Level 2%%    "%%  (UhCEKQW]cioAutoList31.1.1.1.1.1.1.1.\QDDZk6_Subhead 1Subheading Level 1%%   %%  (Z3/$ I!%%%%X'X%%  (O;$0  2#  a  .3  0` (#(#(b$0  0` (#(#2#   .3  0 ` (#` (#\C6D 6_Subhead 3Subheading Level 3XX%%   "XX%% U у҃ ӃEԃ Ճ[փE׃E؃UكDڃD & '  0 .   (5hCEOYcmwAutoList11.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 3#37=CIQYag1.a.i.(1)(a)(i)1)a)%-3579xJEGIKMOQSUAutoList16"")1)a)(#"R$XKeX%% 0 ` XKeX%% (Z3/$ I!%%%%X'X%%  <:Default ParaXXXXXXY-( $ Figure  1  (;3$2#  0  .3  0  (,/$XKeX%%0 0 (# (# XKeX%%(@$0  0` (#(#0 ` (#` (# ` (T$0  0` (#(#0 ` (#` (#0 (# (# (hJ$0  0` (#(#0 ` (#` (#0 (# (#0h(#(#  @$:i+00(xir$0  0` (#(#0 ` (#` (#2#(  0  )3  0 (# (#3|xڃ(Z3/$ I!%%%%X'X%%   SDWISFISCAL_YEAR SDC IEFCottrillLocationalPNTSASMN CompRP FIPS EDIAnalytelocational PWSanalytesanalytedropdown TCRcoliformRadionuclideDateTimeStampTSAANLYT CCR NCD tblContactInfo DTF DMS OCCT LSLR WQPTPprecompliance Viospeciated WSF AsgnremigrateremigratingSETEISN.SQLradionuclideSDWIS.INI&B_Locational_DataTMGLOC"LL_COLLECT_DATETMGLOC_Ora6B_Annual_Operating_PeriodAsgndTINPVALSTINLOCTMNVIOLTFRMEVNTTMGVIOLCP_PRD_END_DTTMNMPRD(TMNSASCH_IS_NUMBERTMNSASCH_STTMNSASCHTMNSAOPATMNSSDAT$TMNSASCH_ST_CODESDWISCOM.MDBSDWISEDI.MDBDESCTABL ODBCRelation.MDBSDWISEDI2B_Sample_Sample_Summary$B_Sampling_Point$B_State_Asgnd_ID SIRs MBS DBA.MAP_DATAMIGRATION.SQL$MAP_MSACCESS.SQL RESET_USER.SQLSTATE:MDBPCDSREPORT.MDBCDSReport.mdbTMGVIOSDTMNVIOSD MDBP MSR LVLSAMPS BYND TXTSubschedules TOC RAAAverage.DUserid MCLValue.DTINUSER RMDL SWTR&NUMB_RESULTS_USEDTMNCMCLV(PRC_ACH_RMVL_RA_NO(PRC_ACH_RMVL_RA_TX:TMNCMCLV.PRC_ACH_RMVL_RA_NO:TMNCMCLV.PRC_ACH_RMVL_RA_TX:TCDSVIOL.SSMPA_APPER_END_DT(LOG_LCR_VIO_MR_TAP:TCDSRLOG.SSMPA_APPER_END_DT,TCDSRLOG.SSMPA_APPEREND_DT LCR MTS JADsDBA_ScriptsAppl_FilesCDS_ReportRegister.exeOracle_LANOracle_PCSDWIS.HLP bnd bind_files.lstCDSMCLPR.bndCHECKCUR.bndDUPCHECK.bndDUPLICAT.bndMTSSCHED.bndUPMPAAND.bndCDSRPTS.MDBTMNVTYPExceedencesexceedences DSNSSMPACDSCALPR.bnd FANLIS_NumberTMNVTYPE RDC GoTo GUP GWP WSFsCCRBRIG.MDBCCRTBL.MDBEBSRPTS.MDBEBSRPTS.HLPV 8Document[5]Document Style0..(EhCEOYcmwAutoList21.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 ($0  0` (#(#0 ` (#` (#0 (# (#2#(  a  )3  0h(#(#(V$ @DD/D  A (F$0  0` (#(#0 ` (#` (#0 (# (#0h(#(#2#(   )3  0h(#h(#($0  0` (#(#0 ` (#` (#0 (# (#0h(#(#0h(#h(#2#  0  )3  0(#(#% %d({$0  0` (#(#0 ` (#` (#0 (# (#0h(#(#0h(#h(#0(#(#2#  a  )3  0p(#(#%-3579xGagmsyBullet ListBullets List1.1.1.1.1.1.1.1.%-3579`iCEIMQUY]aAutoList422222222i)1)a)%-3579hyCEIMQUY]aAutoList522222222i)1)a)%-3579hCEIMQUY]aAutoList622222222i)1)a)ort.ast<QQD:QuickFormat1 X[ X%% XRX XX[ X[ X%% XRX XX[<::D:QuickFormat2 XX X   XX X  V4Heading 1Centered Heading@..  <:HEADING 1 01%-3579hCEIMQUY]aAutoList7""""""""i)1)a)K KdP<*textTimes New Roman 12%$!%%%X3X%%$!1  1>0    * `CG Times @'%%%%X'X%%  _d:XX'  SDC0002017JB5015  October25,2002\  `&Times New Roman%-3579hiEGKOSW[_cAutoList19"""""""")1)a)%-3579hCEIMQUY]aAutoList8""""""""i)1)a)%-3579`CEIMQUY]aAutoList9"2""""""i)1)a)%-3579`EGKOSW[_cAutoList10"""""""")1)a)%-3579hEGKOSW[_cAutoList11"""""""")1)a)%-3579hEGKOSW[_cAutoList12"""""""")1)a)%-3579h EGKOSW[_cAutoList13"""""""")1)a)%-3579hEGKOSW[_cAutoList14"""""""")1)a)%-3579h)EGKOSW[_cAutoList15"""""""")1)a)%-3579hEGKOSW[_cAutoList2022222222)1)a)(W$     d%-3579h)EGKOSW[_cAutoList2122222222)1)a)%-3579hIEGKOSW[_cAutoList17"""""""")1)a)%-3579hYEGKOSW[_cAutoList18"""""""")1)a)%-3579h9EGKOSW[_cAutoList22"""""""")1)a)%-3579hIEGKOSW[_cAutoList2322222222)1)a)<77@:QuickFormat3HXXX  HXXX  %-3579hYEGKOSW[_cAutoList24"""""""")1)a)0.Normal<:Definition T<GD:Definition L , ;1` hp x (#;  8.` hp x (#886Definition('z&H1      XXX(o&H2  XXX&$_  X 5+4 4 <DL!5EH2 `CG TimesE  5+ 4 <DL!5SJ\  `&Times New RomanS  (o&H3  XXX(&H4 XXX XXX(o&H5  XXX(o&H6  XXX20Address8SP6Blockquote , , ;1` hp x (#;   8.` hp x (#8,*CITE,dl*CODEK<6X9`(Courier NewKXXXSJ\  `&Times New RomanS42Emphasis6&)4Hyperlink            <:FollowedHype    4go2Keyboard K<6X9`(Courier NewK XXXSJ\  `&Times New RomanS<:Preformatted/%  ,Kk (#/K<6X9`(Courier NewKXXXSJ\  `&Times New RomanS/%  ,Kk (#/<:zBottom of Iuv4$ ** ddI  B    ?%2A`Arial?9wv*  dd9  XXXSJ\  `&Times New RomanS  &0 d dtttt'dxddd'dxd<:zTop of ForIuv4$** ddI  B    ?%2A`Arial?9wv*  dd9  XXXSJ\  `&Times New RomanS  0Kl.SampleK<6X9`(Courier NewKSJ\  `&Times New RomanS0.Strong 8dl6TypewriterK<6X9`(Courier NewKXXXSJ\  `&Times New RomanS42Variable:8HTML MarkupB      2 0CommentB  <6X9`(Courier New%2A`Arial(I Z(CG Times Regular<!!:TOC Subhead  .  ! ! . 64Subhead 1 (O$<MM:Text bullets , 5+ 4 <DL!5   5+ 4 <DL!5  %-3579hEGKOSW[_cAutoList63!!!!!!!!)1)a)%-3579hyEGKOSW[_cAutoList2622222222)1)a)%-3579hEGKOSW[_cAutoList2722222222)1)a)%-3579`EGKOSW[_cAutoList2822222222)1)a)%-3579hEGKOSW[_cAutoList2922222222)1)a)%-3579hYEGKOSW[_cAutoList3022222222)1)a)%-3579`iEGKOSW[_cAutoList31""2""""")1)a)%-3579`iEGKOSW[_cAutoList32222!2222)1)a)%-3579`EEGKOSW[_cAutoList33!!!!!!!!)1)a)%-3579hUEGKOSW[_cAutoList34!!!!!!!!)1)a)%-3579heEGKOSW[_cAutoList35!!!!!!!!)1)a)%-3579huEGKOSW[_cAutoList36!!!!!!!!)1)a)%-3579hEGKOSW[_cAutoList37"""""""")1)a)6R}4Subhead 2  A $AvalonA SJ\  `&Times New RomanS  %-3579hEGKOSW[_cAutoList3822222222)1)a)%-3579hEGKOSW[_cAutoList3922222222)1)a)%-3579hEGKOSW[_cAutoList4022222222)1)a)%-3579`EGKOSW[_cAutoList4122222222)1)a)%-3579hEGKOSW[_cAutoList4222222222)1)a)%-3579hEGKOSW[_cAutoList4322222222)1)a)%-3579`EGKOSW[_cAutoList44"2"""""")1)a)%-3579hEGKOSW[_cAutoList4522222222)1)a)%-3579hEGKOSW[_cAutoList4822222222)1)a)%-3579h)EGKOSW[_cAutoList4922222222)1)a)%-3579hEGKOSW[_cAutoList4622222222)1)a)%-3579h EGKOSW[_cAutoList4722222222)1)a)%-3579hEGKOSW[_cAutoList5022222222)1)a)%-3579`EGKOSW[_cAutoList51"2"""""")1)a) EGMSY_ekqAutoList531.1.1.1.1.1.1.1.%-3579hEGKOSW[_cAutoList52"""""""")1)a)(EGMSY_ekqAutoList541.1.1.1.1.1.1.1.(%EGMSY_ekqAutoList551.1.1.1.1.1.1.1.%-3579h)EGKOSW[_cAutoList61"""""""")1)a) $Avalon d $w I&mage <=8C HKKKK%-3579h9EGKOSW[_cAutoList5622222222)1)a)%-3579hIEGKOSW[_cAutoList5722222222)1)a)%-3579hYEGKOSW[_cAutoList5822222222)1)a)%-3579hiEGKOSW[_cAutoList59"""""""")1)a)8ow6Plain Text  K<6X9`(Courier NewKXXXSJ\  `&Times New RomanS  %-3579hEGKOSW[_cAutoList60"""""""")1)a)G,(Rectangular Gradientdd  %-3579h9EGKOSW[_cAutoList62"""""""")1)a)%-3579hEGKOSW[_cAutoList64!!!!!!!!)1)a)IPq p  TRX3' LetterX3' Letter3' Letter3'T(`  Z(CG Times Regular t    \R3' Letter\dmailto:sdwisstate@sdc-moses.com.&'),h  Z2CG Times (W1) Regular(Z3/$ I!%%%%X'X%%  ݘTABLE A<pZ$Avalon Regular%-3579hiEGKOSW[_cAutoList65"""""""")1)a)%-3579hyEGKOSW[_cAutoList66"""""""")1)a)%-3579hEGKOSW[_cAutoList67"""""""")1)a)d%-3579`EGKOSW[_cAutoList68"!"""""")1)a)%-3579heEGKOSW[_cAutoList69!!!!!!!!)1)a)%-3579`YEGKOSW[_cAutoList70"!"""""")1)a)  //&%%%%X'X%%  _ProjectPlanPCNsuseletterextensionstodenotetheversion.Theoriginal  wouldbeSDC00020XXXXXXXXThefirstrevisionorupdatedversionwouldbeSDC00020XXXXXXXXAThesecondrevisionorupdatedversionwouldbeSDC00020XXXXXXXBetc.PleaseensurethatthecorrectPCNappearsinthecoverpagesaswellastheheaderinthemainbodyofthedocument.`L:`c81AutoList25  X   2(4 4 <DL!2     5+ 4 <DL!5    TABLE D6Pw4Body Text  EH2 `CG TimesESJ\  `&Times New RomanS  :8Body Text 2  X 5+4 4 <DL!5 EH2 `CG TimesE  5+ 4 <DL!5 SJ\  `&Times New RomanS  &Sz$1  EH2 `CG TimesE SJ\  `&Times New RomanS  0;.footer   !XXX   !:8page number %    &' I!%%%%X'X%%  _L M%-3579`3LI      X'XXX'D *VA ddd Xdd Xdd XD ($D ($, ," d +  )V  )#X'XXX'#XXXX'3UnitedStates d EnvironmentalProtectionAgency @V/!@V @33OfficeofGroundWaterandDrinkingWater0  0FT$T$ C9+@FT$FT$V ! C3J9XX3 SoftwareReleaseNotesfor F SDWIS/STATERelease8.0.3CumulativeforWindowsNTandDB2 <2  ^  !   < D  3#XX9#30 0 T$ T$0IT$T$0IT$IT$ContractNo.68W99002(%T$T$ 0 0 T$ T$0IT$T$0IT$IT$TaskOrderNo.017 T$T$ 0 0 T$ T$0IT$T$0IT$IT$ProductControlNo.SDC0002017JB5015 vl.)u&T$T$ _ V@37553x V@ v#X'XXX#XXXX'[jXX 30AV)6 + dE6 + AOctober25,2002 #XX[j]##X'XXX>#X'XXX' SID+(  V@37553  V@  S3)'+( x _   3#X'XXX'W#  ~.* D e   1 !XX'  n SOFTWARERELEASENOTESFOR̀SDWIS/STATE#X'X ! 1 # 1 !XX'RELEASE8.0.3CUMULATIVE #X'X ! 1 #Ԁ 1 !XX'    FORWINDOWSNTANDDB2 #X'X ! 1f #    CONTRACTNO.68W99002   TASKORDERNO.002017     Preparedfor: ` UnitedStatesEnvironmentalProtectionAgencyOfficeofGroundWaterandDrinkingWaterDrinkingWaterProtectionDivisionX'XXX'1200PennsylvaniaAve.,NW#X'XXX' # B Washington,DC20460X'XXX'  4 TaskOrderProjectOfficer:#X'XXX'{ #X'XXX'EdwardCottrill #X'XXX' #    Preparedby: J&r  SystemsDevelopmentCenterScienceApplicationsInternationalCorporation6565ArlingtonBoulevardFallsChurch,VA22042  +,$%     8$!%%dXXd8     @CONTENTS   ҃҃҃҃ԃ  RX'XXX'   R50     1.00(#(#INTRODUCTION#""J(#.@ @ (#(##1R5s݌   ЌX'XXX'  RX'XXX'   RL0     2.00(#(#DESCRIPTIONOFSDWIS/STATERELEASE8.0.3CUMULATIVEFOR   WINDOWSNTANDDB2#""J(#.!(#(##1RL݌ |  ЌX'XXX'  &/X'XXX'  &/0  0` (#(#    2.10` ` (#` (#RevisionstoPreviouslyDeliveredMSAccess97Databases#""J(#.llL` (#` (##1&/݌ n  ЌX'XXX'  '  '0  0` (#(#0 ` (#` (# `   2.1.10 (# (#ԃփԃԃԃԃփՃԃ ԃՃԃCDSReports(CDSRPTS.MDB)ԃՃԃ ԃՃԃ#""J(#.2 (# (##1' ݌ X Ќ  '  'p0  0` (#(#0 ` (#` (# `   2.1.20 (# (#ԃ׃ԃԃԃԃ׃ԃEnforcementReportsComplianceScheduleReport#""J(#.((H (# (##2'p݌ Bj  Ќ  &/X'XXX'  &/0  0` (#(#    2.20` ` (#` (#DescriptionofResolutionsforSDWIS/STATERelease8.0.3Cumulativefor ,T  WindowsNTandDB2#""J(#.&` (#` (##2&/݌ >  ЌX'XXX'  '  'C0  0` (#(#0 ` (#` (# `   2.2.1 MigrationtoSDWIS/STATE#""J(#.1 (# (##2'C^݌ (  Ќ  '  'C0  0` (#(#0 ` (#` (# `   2.2.2 OnlineSDWIS/STATEComponents#""J(#.\\6 (# (##3'C^݌   Ќ  '  'H0  0` (#(#0 ` (#` (# `   2.2.30 (# (#MigrationtoSDWIS/FED:Actions#""J(#.  8 (# (##7'Hc݌   Ќ  RX'XXX'   RW0     3.00(#(#ADDITIONALINFORMATION#""J(#.%(#(##7RW݌  ЌX'XXX'  &/X'XXX'  &/y0  0` (#(#    3.10` ` (#` (#Advisory:SampleUniquenessinOnlineSampling#""J(#.C` (#` (##7&/y݌  ЌX'XXX'  &/X'XXX'  &/0  0` (#(#    3.20` ` (#` (#Advisory:CDSSetupPostProcessingReport#""J(#.$$?` (#` (##8&/݌  ЌX'XXX'  &/X'XXX'  &/0  0` (#(#    3.30` ` (#` (#Advisory:SpecifyingDSNontheODBCDataAdministratorWindow#""J(#. S` (#` (##8&/=݌ v ЌX'XXX'  &/X'XXX'  &/Z0  0` (#(#    3.40` ` (#` (#Advisory:WaterSystemFacilityMaintenanceandSellerTreatmentԃ؃&/Z݌`` (#` (# ЌX'XXX'  ؃؃&/X'XXX'  ؃؃&/ 0  0` (#(#    0` ` (#` (#؃ԃIndicatorԃكԃ Jr ԃكԃ#""J(#.8 8 ` (#` (##8&/ ݌ Jr ЌX'XXX'  &/X'XXX'  &/"0  0` (#(#    3.50` ` (#` (#Advisory:DeterminingWaterSourceTypeforPurchasedWater#""J(#.22P` (#` (##9&/"M"݌ 4\ ЌX'XXX'  &/X'XXX'  &/g#0  0` (#(#    3.6 ` Advisory:MigrationtoCCRWriter#""J(#.&&6` (#` (##9&/g##݌ F ЌX'XXX'  &/X'XXX'  &/$0  0` (#(#    3.7 ` Advisory:SizeofMSAccessDatabaseWindow#""J(#.@` (#` (##9&/$$݌ 0 ЌX'XXX'  &/X'XXX'  &/%0  0` (#(#    3.80` ` (#` (#Advisory:InvalidSamplingPointWindow#""J(#.<<<` (#` (##9&/%&݌  ЌX'XXX'  &/X'XXX'  &/'0  0` (#(#    3.90` ` (#` (#Discrepancy:Release8.0ODDViolationTypePermittedValues#""J(#.\\Q` (#` (##9&/'O'݌  ЌX'XXX'  &/X'XXX'  &/j(0  0` (#(#    3.100` ` (#` (#Discrepancy:MigrationtoSDWIS/STATE:MBSsPNActivityModule#`"`"I(#. T` (#` (##11&/j((݌  ЌX'XXX'  &/X'XXX'  &/)0  0` (#(#    3.110` ` (#` (#Discrepancy:MigrationtoSDWIS/STATE:MBSsComplianceSchedule   Module#`"`"I(#. ` (#` (##11&/)*݌ ! ЌX'XXX'  RX'XXX'   R@+0     4.00(#(#INSTALLATIONINSTRUCTIONSANDFILELISTFORSDWIS/STATE v# RELEASE8.0.3CUMULATIVEFORWINDOWSNTANDDB2#`"`"I(#.88>(#(##11R@+~+݌ h$  ЌX'XXX'  &/X'XXX'  &/,0  0` (#(#    4.1 ` SDWIS/STATEMSAccessDatabaseFiles#`"`"I(#.  8` (#` (##12&/,-݌ Z%! ЌX'XXX'  &/X'XXX'  &/-0  0` (#(#    4.2 ` ReplacementApplicationFiles#`"`"I(#.1` (#` (##12&/-6.݌ D&l" ЌX'XXX'  '  '*/0  0` (#(#0 ` (#` (# `   4.2.1 InstallationInstructions#`"`"I(#...2 (# (##12'*/E/݌ .'V # Ќ  '  ',00  0` (#(#0 ` (#` (# `   4.2.2 FileList#`"`"I(#.ll" (# (##13',0G0݌ (@!$ Ќ  '  '10  0` (#(#0 ` (#` (# `   4.2.3BindFileList#`"`"I(#.dd+ (# (##15'191݌ )*"% Ќ  )ԃӃ҃  <<҃҃Table҃҃of҃҃Contents҃҃will҃҃generate҃҃here҃҃>>҃҃ ?҃Ӄ +$( @       EXHIBIT   F3 Exhibit1.0 ` MSAccess97DatabasesforDB2#`"`"I(#...2` (#` (##1Ѓσ3σЃу2у      &4  1.00  INTRODUCTION y4 (#(# TheSafeDrinkingWaterInformationSystem(SDWIS)/STATERelease8.0.3Cumulativefor  WindowsNTandDB2releaseincludesfixestoproblemsnotedinSDWIS/STATERelease8.0   andalsoimplementssomenewrequirementsmadetothesoftwaresincethereleaseofSDWIS/STATERelease8.0forWindowsNTandDB2. r  SDWIS/STATERelease8.0.3Cumulativeincludesthenewrequirementsandsoftwarefixesin F n SDWIS/STATERelease8.0.2aswellasfixesandnewrequirementsimplementedsincethat 0X patch.(SDWIS/STATERelease8.0.1didnotapplytoSDWIS/STATERelease8.0forWindows B  NTandDB2.) ,  YoumayinstallSDWIS/STATERelease8.0.3Cumulativeafteryourstate/regionhaseither   successfullyschemamigratedfromSDWIS/STATERelease7.0toSDWIS/STATERelease8.0orsuccessfullycompletedanewstate/newregioninstallationofSDWIS/STATERelease8.0.ThisdocumentincludesadescriptionoftheSDWIS/STATERelease8.0.3Cumulativecontents j andinstructionsforfileinstallation.Foranswerstoquestionsyoumayhavethatarenotcoveredbythesereleasenotes,youmaycalltheSDWISUserSupportHotlineat703-292-6298orsendanemailto4 B O  5  sdwisstate@sdcmoses.com.62:OF:Ќ  7Bt: (P   2.00  DESCRIPTIONOFSDWIS/STATERELEASE8.0.3CUMULATIVEFOR  WINDOWSNTANDDB2  ; (#(# ThissectioncontainsabriefdescriptionofwhatisincludedinSDWIS/STATERelease8.0.3  Cumulative.Thecontentsofthisreleaseincludefixesthathavebeenmadetoexisting  SDWIS/STATERelease8.0softwareaswellasnewrequirementsthathavebeenimplementedsincetheinitialreleaseofSDWIS/STATE8.0.  2.10  RevisionstoPreviouslyDeliveredMSAccess97Databases $=Ԁ F#n(#(# CorrectionshavebeenmadetotwopreviouslydeliveredMSAccessdatabasesasdiscussedbelow.  2.1.1 0  CDSReports(CDSRPTS.MDB) > '!$(#(# TwominorchangesweremadetotwoCDSReportqueries,whichinconcertwiththechangestothePostCDSReportsLogfunction,enabletheresultsofapreviouslyrunLeadandCopperTapMonitoringandReporting(M&R)ComplianceReporttobeviewedaccuratelywhenreexecutedfromthePostCDSReportsLog. HX'XXX' z,%) _#X'XXHX'?#  2.1.20  EnforcementReportsComplianceScheduleReport  @ (#(# HX'XXX'ThesearchfunctionontheComplianceScheduleReport,whichispartoftheEnforcement  Report,hasbeenclarified.(Thisfunctiondidnotworkasuserspreviouslyexpected).#X'XXHX'@#     2.20  DescriptionofResolutionsforSDWIS/STATERelease8.0.3Cumulativefor r  WindowsNTandDB2 AԀ d (#(# ThefollowingitemsdescribeproblemsidentifiedsincethereleaseofSDWIS/STATE8.0andwhoseresolutionisincludedinSDWIS/STATERelease8.0.3CumulativeforWindowsNTand *R  DB2. <    2.2.1  MigrationtoSDWIS/STATE oCԀ    IssuesaddressedwithintheMigrationtoSDWIS/STATEcomponentaredescribedin   Subsections2.2.1.1and2.2.1.2. 2.2.1.1MigrationtoSDWIS/STATE:MDBPSummary   Ѐ"0  Undersomescenarios,thesoftwarewasincorrectlycarryingforwardareferenced ^ SamplingPointfromajustprocessedstructuresettextfilerecordandapplyingittothenextHX'XXX'MicrobialDisinfectionByProducts#X'XXHX'~E#(MDBP)Summaryinthestagingtablewhen 2Z thatrecorddidnotreferenceasamplingpoint.ThisproblemwasfixedinRelease8.0.2. (#(# "0  Undersomescenarios,valuesforMDBPSummaryfieldsPERCENT_SAMPLES_  BEYOND_MSR_LVLandMDBPSummaryPERCENT_SAMPS_BYND_MSR_LVL_TXTwerenotbeingcalculated.ThisproblemwasfixedinRelease8.0.2. (#(#  2.2.1.2MigrationtoSDWIS/STATE:Monitoring  ! "0  AproblemintheHX'XXX'MigrationtoSDWIS/STATE:Monitoring#X'XXHX' H#ԀViolationmodulethat ^# affectedthe duplicatebydatacheckaswellasthe duplicatebynumbercheckwasfixedinRelease8.0.2. (#(# "0  AproblemthatmanifesteditselfinthescenariowheretheHX'XXX'MigrationtoSDWIS/STATE: '. # Monitoring#X'XXHX'I#ԀNonTotalColiformRule(TCR)Schedulemodulecreatedasample '!$ schedulegroupwithanopenEffectiveEndDateandwasthenunabletosuccessfullycreateSamplingPointSubscheduleswhenthetextfiledataindicatedthattheyshouldbecreated,hasbeenaddressed.Asecondproblemthatoccurredwhen,withinthesametextfile,thereexistedtwodifferentscheduleswhoseWaterSystemsweredifferentbutwhoseWaterSystemFacility(WSF)StateAsgndIDhappenedtobethesame,wasalso ,%) fixed.Inthiscase,thewatersystemfromthesecondschedulewasnotbeingpickedup;thisproblemwasfixedinRelease8.0.2. (#(# "0  TheHX'XXX'MigrationtoSDWIS/STATE:Monitoring#X'XXHX'L#ԀPackageSchedulemoduleerroneously   preventedthecreationofanon-TotalOrganicCarbon(TOC)package(onethatdoesnotinvolvea2920finishedschedule)ifthesupportingschedulewasforanalytecode2920,1067,or1927.ThisfunctionhasnowbeenfixedtoallowthesePackagedSchedules,justastheycanbeaddedusingonlineScheduleMaintenance.ThisproblemwasfixedinRelease8.0.2. (#(# "0  TheFacilityAnalyteLevelstructuresetallowsuserstoassociatetheFacilityAnalyte $  Level(FANL)totwoviolationtypes:oneforM&Rviolations,andoneforlevelviolations.Therearetwofieldstobeusedforeachassociation:theViolationTypeCode,andtheViolationTypeIS_Number.IfthereismorethanonerecordinTMNVTYPEofthesameViolationTypeCode,thesoftwareistousetheViolationTypeIS_NumbertochoosethecorrectrecordtoassociatetotheFANL.TheproblemwasthatthesoftwarewasassociatingtheFANLtothefirstrecordinTMNVTYPEofthereferencedViolationTypeCodeandwasnotusingtheViolationTypeIS_NumbertodistinguishthecorrectTMNVTYPErecord,whenthissecondstepwasneeded.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  TheViolationstructuresetandsoftwaremoduleincorrectlyindicatedthatforviolations  2 ofviolationtype71and72thenewCompliancePeriodBegindatewouldbeusedforaparticulardateedit,wheninfactthedateeditshouldhaveusedtheViolationPeriodBegindate.ThiserrorhasbeencorrectedinRelease8.0.3.AdvisoryNote:The  SDWISCOM.MDBerrormessagehasnotbeenchangedtoreferenceViolationPeriodBeginDateinsteadofCompliancePeriodBeginDate.Whenyouaremigratingintype71and72violationsandoneofthemisflaggedorrejectedbecauseofanissuewithCompliancePeriodBegin/EndDate,theproblemisactuallywithViolationPeriodBegin/EndDate.Z!(#(#   2.2.2  OnlineSDWIS/STATEComponents 9UԀ  .#V IssuesaddressedwithinonlineSDWIS/STATEcomponentsaredescribedinSubsections2.2.2.1through2.2.2.11. 2.2.2.1OnlineSampling"ResultsAverageMaintenance  ' $ "0  Theerrormessage PrecursorRemovalRatioCannotbeBlankwaserroneously )"& displayedwhenyouattemptedtosaveaResultsAveragesrecordwithoutavalueintheoptionalPrecursorRemovalRatiofield,availableinboththeMonitoringPeriodAverage(MPA)andRunningAnnualAverage(RAA)groupboxes.Youhadtoenter b,%)  0inthefieldtosavetherecord.Thesoftwarenolongerrequiresyoutoenteravalueintheseoptionalfields.ThisproblemwasfixedinRelease8.0.2. (#(# "0  ThesoftwarehasbeenfixedsothatitvaluesMonitoringPeriodAverage.DUserid   CodeandMaximumContaminantLevel(MCL)Value.DUseridCodefromfieldUSERIDinTINUSER,asspecifiedintheRelease8.0DesignDocument.ThisproblemwasfixedinRelease8.0.2. (#(#  2.2.2.2OnlineSampling"SampleMaintenance  (P OnanyoftheSampleMaintenancewindows(byLaborbyWaterSystem),ifyouattemptedtocreateanewsamplingpointbyenteringavalueinonlytheSampleLocationfield(withnovalueinSamplingPoint),thisactioncorrectlytriggeredtheInvalidSamplingPointdialogbox.YoucouldthenspecifyActivityStatusandDateandcreateasamplingpoint;butwhenexitingthedialogbox,thesoftwaredidnotsavethesamplelocationandactivitydateinformation.ThisproblemhasbeenfixedinRelease8.0.3. HX'XXX'2.2.2.3OnlineSampling"MDBPSummaryMaintenance #X'XXHX'/\# j "0  WhenusingtheDistributionResidualDisinfectantConcentration(RDC)Changeor Fn AddwindowfromeithertheSamplingcomponents MDBPSummary/SWTR (Surface 0X WaterTreatmentRule)windowflowortheSamplingcomponents Sample "J Summaries/TCRSummary/SWTRRDC buttonwindowflow,thecontrollevelthat < wasdisplayedforthestateresidualwasnotcorrect.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  IftherewasmorethanonetreatmentplantordistributionsystemfortheMDPB  Summary'sreferencedWSF,theSWTRandMaximumResidualDisinfectantLevel(MRDL)windowflowdidnotallowtheentryofMDBPsummaries,eveniftheappropriateFANLswereinplace.ThisproblemhasbeenfixedinRelease8.0.3. (#(#  2.2.2.4OnlineSampling"TCRSummaryMaintenance  V#~ WhenthesoftwareautomaticallyassociatedanewTCRSummarytoadistributionsystem(DS)(whichhappenedwhentherewasonlyoneDS)anduserssubsequentlyenteredtheMonitoringPeriodforthesummary,thesoftwareshould,atthatpoint,haveenabledthe SWTRRDC and '. #  CL2RDC buttons.However,usershadtoselecttheWSFStateAsgnID GoTo buttonand ' !$ re-selectthedistributionsystemtoenablethesebuttons.ThisproblemhasbeenfixedinRelease8.0.3,andthe SWTRRDC and CL2RDC buttonsarenowenabledatthecorrect )"& point.  +$(  2.2.2.5OnlineEnforcement"EnforcementActionSearch   AproblemwithdefaultdatesnotbeingproperlydisplayedintheEnforcementActionSearchdialogboxhasbeencorrectedinRelease8.0.3.Previously,ifusersdidnotenteranydatecriteriaintheEnforcementActionSearchdialogbox,itssearchlogicfunctionedasinpreviousreleases;i.e.,itsearchedforEnforcementActionswhoseStatusDatewas6monthspriortotoday'sdate.These defaultdatesdidnotappearonthewindow,however,eventhoughthesoftwarewasusingthem.ThedatedefaultsthatexistedwithRelease7.0andpriornowappearonthewindow.(StartDatedefaultstothedatethatis6monthspriortotodaysdate.EndDatedefaultstotodaysdate). 2.2.2.6OnlineEnforcement"PNScheduleMaintenanceList    AproblemwhereopenPublicNotification(PN)SchedulesdidnotfirstdisplayonthePNScheduleMaintenanceListhasbeencorrectedinRelease8.0.3.ThePNScheduleMaintenanceListnowcorrectlydisplaysallopenPNschedules,meetingtheuserspecifiedcriteriawhenthelistisfirstdisplayed. 2.2.2.7OnlineMonitoringandNoncompliance"ValidatePositiveTCRResults  \ TheproblemwherethesoftwarewasincorrectlycreatingapreliminaryacuteviolationwhenitencounteredonlyonepositiveTCRandfecalcoliformsample,butnopositiverepeatsample,hasbeenfixed.ThesoftwarenowcorrectlysearchesforapositiverepeatTCRsamplealongwithapositiveroutineTCRandeitherfecalcoliformorHX'XXX'E.coli#X'XXHX'i#Ԁsamplepriortocreatingthe  preliminaryacuteviolation.ThisproblemwasfixedinRelease8.0.2. 2.2.2.8OnlineMonitoringandNoncompliance"Violations   ThismodulehasbeenredeliveredsothatitusesthefixedViolation duplicatebydatacheckthatwasoriginallyfixedfortheMigrationtoSDWIS/STATEViolationmodule.Thisproblem z! wasfixedinRelease8.0.2. 2.2.2.9OnlineMonitoringandNoncompliance"MigrateCandidateCDSViolations  8$`  "0  ThismodulehasbeenredeliveredsothatitusesthefixedViolation duplicatebydata &<" checkoriginallyfixedfortheMigrationtoSDWIS/STATEViolationmoduleinRelease && # 8.0.2. (#(# "0  MigrateCDSCandidateViolationswaspreviouslynotcarryingtheWSFreferencedby )"& thecandidateviolationintotheactualSDWIS/STATEviolation.Thisproblemhasbeenfixed,andareferencedWSFinthecandidateviolationisnowcorrectlycarriedovertotheactualviolation.ThisproblemhasbeenfixedinRelease8.0.3.z,%)(#(# Ї"0  AproblemwheresomePNcandidateviolationswerenotbeingcorrectlymigratedinto  theTMNVIOLtablehasbeencorrected.ThiswasactuallyaproblemwiththewaythePNComplianceReportclearedoutpreviouslycreatedviolationsfordifferentagencies.ThisproblemhasbeenfixedinRelease8.0.3. (#(#  2.2.2.10OnlineMonitoringandNoncompliance"PostCDSReportsLog  j  "0  CandidateType43violationsthatdisplayedwhenusersrantheCDSSWTR F n ComplianceReportwerenotshowingupwhentheylaterrequestedthedatafromthesamereportusingthePostCDSReportsLog.ThisproblemwasfixedinRelease8.0.2. (#(# "0  AproblemwiththePostCDSReportsLogwasfixedinRelease8.0.2,enablingthe   displayofallinformationforapreviouslyrunLeadandCopperTapM&RComplianceReport. (#(#  2.2.2.11CDSSetup   "0  UnderthescenariowherethereisafinishedTOCschedulepackagedwitharawTOC \ andrawalkalinityschedule,andwherethevalueinMonitoringPeriodAverageNUMB_RESULTS_USEDfieldforboththerawandfinishedschedulesis0,whilethenumericvaluecalculatedforMCLValue(tableTMNCMCLV)fieldPRC_ACH_RMVL_RA_NOiscorrect,thevalueinitsequivalenttextfield,PRC_ACH_RMVL_RA_TX(andthefieldthatisdisplayedontheResultsAveragesMaintenancewindow),wasincorrectwhenTMNCMCLV.PRC_ACH_RMVL_RA_NOwasvaluedwith0.Inthisscenario,thesoftwarewassettingTMNCMCLV.PRC_ACH_RMVL_RA_TXto1.00.ThiswasfixedinRelease8.0.2. (#(# "0  AproblemthathadgoneundiscoveredsincethedeliveryofSDWIS/STATE7.0where,   underaparticularscenario,candidateMCLviolationswerebeingcreated/deletedattheWaterSystemlevelratherthanattheWSFlevel,hasbeencorrected.Theyarenowconsistentlyclearedout/createdattheWSFlevel.ThishasbeenfixedinRelease8.0.3. (#(# "0  TheCDSSetupProcessingReportfortheCalculateMCLValueprocesswas %:! incorrectlyprovidinguserstheinternalsystemnumbersofuniqueidentifiers(suchasWaterSystemNo.,WSFStateAsgnID,etc.)ratherthantheactualWaterSystemNo.,AnalyteCode,etc.ThismadetheinformationforthisCDSSetupprocess ' $ unnecessarilydifficulttoprocess.ThisproblemhasbeencorrectedinRelease8.0.3,andtheinformationforthisCDSSetupprocessisreportedintheCDSSetupProcessing )"& ReportinthesamewayasitisforallotherCDSSetupprocesses.*#'(#(#  b,%)   2.2.30  MigrationtoSDWIS/FED:Actions y (#(#   AproblemthathadgoneundiscoveredsincethedeliveryofSDWIS/STATERelease7.0hasbeenfixed.Thisproblemoccurredwhenanenforcementactionwasalsolinkedtoaviolationthatreferencedastate-ownedviolationtype(notreportabletoSDWIS/FED)aswellasbeinglinkedtoaviolationthatreferencedafederally-ownedviolationtype.InthisscenarioHX'XXX', r  MigrationtoSDWIS/FED:Actions#X'XXHX'{#HX'XXX'Ԁincorrectlyunderstoodthatifoneviolationlinkedwasstate \  owned,allviolationslinkedwerethenstate-owned.TheresultwasthesoftwaredidnotgenerateboththeE1formandtheY5000.#X'XXHX'6|#HX'XXX'MigrationtoSDWIS/FED:Actions#X'XXHX'R}#Ԁhasbeenfixed 0X togenerateboththeE1formandtheY5000whentheenforcementactionislinkedtobothaviolationthatreferencesastate-ownedviolationtype(notreportabletoSDWIS/FED)ANDaviolationthatreferencesafederallyownedviolationtype(thatisreportedtoSDWIS/FED).ThishasbeenfixedinRelease8.0.3.  3.00  ADDITIONALINFORMATION  (#(# Notetheadvisories/discrepancieslistedinSubsections3.1through3.9.  3.10  Advisory:SampleUniquenessinOnlineSampling  Fn(#(# InresponsetoarecentUserSupportinquiry,itwasnotedthatsampleuniquenesscriteriaforasampleenteredusingoneoftheonlineSampleMaintenancewindowsarenotdocumentedineithertheUsersGuideoronlineHelpforthosewindows.SampleuniquenesscriteriafortheonlinesamplingwindowshavenotchangedsincetheSamplingcomponentwasoriginally  introducedin1995.ThecriteriaforenteringasamplewhenusingonlineSamplingremain:  IfvaluingLabSampleNo.:0  WaterSystemplusLabplusLabSampleNo.plusCollectionDateplusSamplingPoint. (#(# IfleavingLabSampleNo.blank:0  WaterSystemplusLabplusCollectionDateplusSamplingPointandifsupplied,CollectionTime. (#(# ThesecriteriaaredifferentthanthosecriteriaspecifiedforSamplingviaEDI/Migrationto '!$ SDWIS/STATE:Sampling,whichisstricter.Theabovecriteriawerespecifiedbyuserswho (!% attendedthetwoSamplingJADsinNovember1994andFebruary1995.Atthattime,there )"& wasanexplicitrequirementtobeabletocreateasamplewithoutusingaLabSampleNo.orStateSampleNo.TheuniquenesscriteriadescribedaboveappliedtoallSDWIS/STATEsamplesuntilSDWIS/STATERelease7.0.WithSDWIS/STATERelease7.0,sample j,%) uniquenesscriteriaforSamplingviaEDI/MigrationtoSDWIS/STATE:Samplingwere  tightened,asdescribedinAppendixAoftheSystemAdministrationGuideandAppendixEof  theUsersGuide.  3.20  Advisory:CDSSetupPostProcessingReport   (#(# WhenCDSSetupencountersaFinishedTOCSchedulepackagedwithasingleRaw \  Schedule/ScheduleGroupforTOCorAlkalinity,thefollowingmessagemayappearinthePostCDSSetupProcessingReport: CannotcalculateaprecursorachievedremovalratiobecausethereisnotaRawAlkalinityScheduleassociatedwiththeFinishedTOCschedule.ThismessageappearswhennoprecursorachievedremovalratiocanbecalculatedforaSampleScheduleMonitoringPeriodAssignment(SSMPA)ApplicablePeriodBeginandEndDateRangeassociatedtotheFinishedTOCSchedule.Thismessagemayalsoappearasaduplicateadvisorymessageinthereport.Inreality,however,itisnotaduplicatemessage;itappearsthiswaybecausewhiletheinformationtoidentifytheScheduleissupplied,themonitoringperiodandSSMPAApplicablePeriodBeginandEndDateRangeisnotspecified.Eachtimethemessageappearsasaduplicate,itappliestoasecond,third,fourth,etc.,MonitoringPeriod(SSMPA)ApplicablePeriodRange"whichisnotsupplied.  3.30  Advisory:SpecifyingDSNontheODBCDataAdministratorWindow  >f(#(# IntheRelease8.0InstallationGuides,inthechapterthatcoversinstallingSDWIS/STATE B application/clientsoftwarefiles,Phase6ODBCAdministration,notethataftertheODBCDataAdministratorwindowappears,youmaywishtoselecttheSystemDSNtabratherthantheUserDSNtab.TheGuidedoesnotspecifywhichtabtouseinthedocumentation(eitherUserDSNorSystemDSN),becausethisisgenerallyunderstoodtobeauserpreference.UserDSNwouldmeanthatsomeoneelseloggingintoyourmachinewouldneedtocreatetheirowndatasource.Forthisreason,youmaywanttospecifySystemDSNsothatanyoneloggingintotheworkstationcanusethedatasource.IfyoudorecreatethedatasourceunderSystemDSN,youshouldremoveitfromtheUserDSN.  3.40  Advisory:WaterSystemFacilityMaintenanceandSellerTreatmentIndicator N >#f(#(# EPArequiresthatprimacyagenciesnotonlyindicatewhetherornotthesellertreatsthewater,butalsowhetherornotthatwaterisfiltered.OntheexistingWaterSystemFacilityMaintenancewindow,theSellerTreatmentIndicatorfieldhasbeenmodifiedtohaveanewpermittedvalueofF"Treatedbyseller"includingfiltration.Ifthevalueinthisfieldforagivenfacilityneedstobechangedto F,youeitherneedtoupdateitusingtheonlinesoftwareorsomeothertool.NotethatthisinformationisreportedtoSDWIS/FED. j,%)   3.50  Advisory:DeterminingWaterSourceTypeforPurchasedWater +(#(#  EnvironmentalProtectionAgency(EPA)regulationsstatethatindeterminingthesourcetypeforconsecutiveconnections,thebuyerssourcetypemustfollowthesellerstype.Forexample,iftheselleris groundwaterundertheinfluenceofsurfacewater(GUI),thenthebuyer'sprimarysourcebecomes purchasedgroundwaterundertheinfluenceofsurfacewater(GUP)not PurchasedGroundwater(GWP).However,SDWIS/STATEdoesnotlookattheprimarysourcetypeofthesellerwatersystemwhendeterminingtheprimarysourcetypeofabuyer;itlooksatwhatwasenteredastheWaterTypefortheConsecutiveConnection(CC)forthebuyer.AusercanenterGroundwaterastheWaterTypeforaCCeveniftheCCislinkedtoasellerthatisaGUI.Toverifysourcetypesforpurchasedwater,checktheWSFsoftypeCC.NotethatthisinformationisreportedtoSDWIS/FED.  3.6  Advisory:MigrationtoCCRWriter F     WhenusingMigrationtoCCRWriter(CCRBRIG.MDB),thiscomponentworkswithEPAs   productCCRWriterv.1.5,whichisanMSAccess97basedfileandthereforecannotbeinstalledusingMSAccess2000.Tocontinueusingthisdatabase,createafolderC:\CCRWriterandthen,fromtheCCRWriterinstallationdisk,copyfileCCRTBL.MDBintothisfolder.WhenopeningthisfileusingMSAccess2000,youwillbeaskedtoconvertit.Whenasked,youwillneedtorenameitwithadifferentnameinordertocontinueusingit.  3.7  Advisory:SizeofMSAccessDatabaseWindow   4  Thesizeofthedatabasewindow,whenlaunchedfromanapplicationfile(e.g.,EBSReportsorMigrationtoSDWIS/STATE:MDBPSummaryImportTexttoStagingTable),maydifferfrom  oneusagetothenext.Youmayneedtoresizethedatabasewindowthatislaunchedbeforeusingit.  3.80  Advisory:InvalidSamplingPointWindow  z!(#(# InattemptingtocreateanewsamplingpointbyenteringavalueinfieldSampleLocation(andnotfieldSamplingPoint),ifyouusethemousetomovetothenextentryfieldonthewindow(thefieldvarieswithsampletype),theInvalidSamplingPointdialogboxopensbehindthecurrent,SampleMaintenancewindow.TobringtheInvalidSamplingPointdialogboxtothefront,clickonthebuttonforInvalidSamplingPointwindowinthetoolbar.Youcanthenentertheactivitystatus/dateinformation.  3.90  Discrepancy:Release8.0ODDViolationTypePermittedValues  )"&(#(# IntheRelease8.0OnlineDataDictionary(ODD),whenyouasktodisplaythepermittedvaluesforfieldsinViolationType(tableTMNVTYP),whentheFederalViolationType ,%) (TMNVTYP)Valueswindowisdisplayed,itdoesnotshowthefollowingnewRelease8.0fieldsonthewindow:"0  FEDReportingPeriodType(letsthesoftwareknowwhethertheviolations   CompliancePeriod(BeginandEndDates)ortheViolationPeriodBeginDateshouldbereportedtoSDWIS/FED)withthefollowingpermittedvalues: (#(# 0  0` (#(#CP"TheCompliancePeriodBeginandEndDateshouldbereportedto > f SDWIS/FEDforanyviolationusingthisViolationType. ` (#` (# 0  0` (#(#VP"TheViolationPeriodBeginDateshouldbereportedtoSDWIS/FEDfor $  anyviolationusingthisViolationType. ` (#` (# 0  0` (#(#RA"RunningAnnualAveragePeriod. ` (#` (# "0  ReportNumberofMissingSamplestoSDWIS/FED? (#(# L %-3579eh`M%-3579L0  0` (#(#Y/Yes"MigrationtoSDWIS/FEDshouldcreateatransactionthatreportsthe b numberofmissingsampleswiththeviolation(aspartoftheD1record). ` (#` (#   0  0` (#(#N/No"MigrationtoSDWIS/FEDshouldnotcreateatransactionthatreportsthe  H numberofmissingsampleswiththeviolation(aspartoftheD1record). ` (#` (# 0   (#(# 0  0` (#(#Spaces"Fielddoesnotapplytostateownedviolationtypessoshouldnotbe  valuedinmostcases). ` (#` (# L %-3579Y`h%-3579L"0  ReportNumberofExceedencestoSDWIS/FED?(#(# 0  0` (#(#Y/Yes"MigrationtoSDWIS/FEDshouldcreateatransactionthatreportsthe p  numberofexceedenceswiththeviolation(aspartoftheD1record). ` (#` (# 0  0` (#(#N/No"MigrationtoSDWIS/FEDshouldnotcreateatransactionthatreportsthe .#V numberofexceedenceswiththeviolation(aspartoftheD1record). ` (#` (# 0  0` (#(#Spaces"Fielddoesnotapplytostateownedviolationtypes;therefore,should %" notbevaluedinmostcases. ` (#` (# "0  FedReportableContaminantCode"TellsSDWIS/STATEsoftwarewhethertheanalyte (!% coderecordedwiththeviolationoradifferentcode(theonespecifiedinthisfield)shouldbereportedtoSDWIS/FED. (#(# _ R,z%) ThisinformationisavailablethroughRELATION.MDB,theonlineSystemAdministration  component,andtheViolationfunctioninonlineMonitoringandNoncompliance.    3.100  Discrepancy:MigrationtoSDWIS/STATE:MBSsPNActivityModule U  (#(# TheMigrationtoSDWIS/_STATE:MBS_PNActivitymodulecanonlymigrate100PNactivity r  recordsatatime.Whileitisnotanticipatedthatastate/regionwouldnormallybemigratinginlargenumbersofPNactivityrecords,ifyoudoneedtomigrateinmorethan100PNactivityrecords,createtextfilesingroupsof100.  3.110  Discrepancy:MigrationtoSDWIS/STATE:MBSsComplianceScheduleModule k , (#(# TheMigrationtoSDWIS/_STATE:MBS_ComplianceSchedulemodulecanonlymigrate100   complianceschedulerecordsatatime.Youwillneedtocreateseveraltextfilesandmigratetheminseparatelyifthenumberofcomplianceschedulerecordstobemigratedexceeds100.  4.00  INSTALLATIONINSTRUCTIONSANDFILELISTFORSDWIS/STATE r RELEASE8.0.3CUMULATIVEFORWINDOWSNTANDDB2 S d(#(# Asexplainedinthissection,SDWIS/STATERelease8.0.3CumulativeforWindowsNTand @h DB2isacombinationofautomaticallyinstalledfilesandfilesthatyouwillneedtocopyfrom *R theinstallationpackage,basedontheneedofyourlocationsoperatingenvironment.Wheremanualcopyoffilesisnecessary(inSubsection4.1),adetaileddecisionmatrixissuppliedtoassistyouindecidingwhetherornotyoumayneedtocopyaparticulardatabase."0  Y"meansYes,youshouldinstallit.(#(# "0  N"meansNo,youdonotneedtoinstallitbecauseyoualreadyhaveoritdoesnot  applytoyourlocation. (#(# Forautomaticallyinstalledfiles,seeinstructionsinSubsection4.2.FromEPAsSDWIS/STATEwebsite,downloadfile8.0.3_DB2.zip.Using_WinZip_,extracttoafolderyouname/create,suchas_ڃC:\ڃEXTRACT_803_DB2._ԀWhenyouopenthisfolder,youwillseethefollowingfoldersandfiles:Access_97_MDBsBindFilesSdwis80Appl803_DB2._INF_Appl803_Files.LSTINSTALL_Appl803DB2.EXE r,%) Ї  4.1  SDWIS/STATEMSAccessDatabaseFiles Ԁ   Exhibit1listsalltheMSAccessdatabasefilesdeliveredwithSDWIS/STATERelease8.0.3 i CumulativeforWindowsNTandDB2.YouwillneedtomanuallycopyboththeMSAccess S  databaseslistedinthismatrix.Thelastcolumnofthematrixspecifiesintowhichfolderyoushouldcopythedatabase.Toaccessthesedatabases,openfolderAccess_97_MDBs.e:>5*xVdA d " d " V(#(#x,Fdd ,9dd ,dd ,dd ,dd ,dd ,dd +  %  n %  Exhibit1.MSAccess97DatabasesforDB2 9/$_   98VXX'Name 'X  'Release X  Version '"  'Date/Time X  Group '"  'Size 'X 'Have X applied:NoPatch? 'C  'Have X applied:Patch8.0.2? 'C  'CopytoFolder:#X'X8V#8VXX' 'X 'CDSRPTS.MDB   8.0.2    07/08/2002@05:30P :0 g  AA2228224AA:2,228,224 :0.  AA2228224 AA :Y    N    C:\SDWIS\CDS#X'X8V #    8VXX'EBSRPTS.MDB 4  EBSRPTS.HLP#X'X8V#8VXX' M" 8.0.38.0.3#X'X8V#8VXX'  M% 10/16/2002@2:30P10/07/2002@12:06P <2 ) ʠA 934625685ʠA<#X'X8V#8VXX'9,346 4* #X'X8V>#8VXX'25,685 <20M, ʠA 934625685 ʠA <YY#X'X8V#8VXX'  M/ Y#X'X8V##8VXX'Y#X'X8V|#8VXX'  M2 C:\SDWIS\EBS#X'X8V# 43 8VXX'C:\SDWIS\EBS#X'X8V<# M5    4.2  ReplacementApplicationFiles   f6 Installtheapplicationfiles.ThefileslistedunderSubsection4.2.2replaceexistingfilesinthefolderinwhichyoukeepyourSDWIS/STATERelease8.0applicationsoftware.Pleaserefrainfromaccessingtheapplicationwhilethefilesarebeingupdated. :   4.2.1  InstallationInstructions . w<  ClickonfileINSTALL_Appl803DB2.EXE.Pressthe InstallSystem button.Youwillbe S > askedtoconfirmwheretheapplicationfilesshouldbeinstalled.SelectthesamefolderwhereyourSDWIS/STATERelease8.0applicationfilesreside.(Thefilesincludedin X'XXX'SDWIS/STATERelease8.0.3Cumulativewilloverwriteexistingfilesthatwereinstalledwith #A SDWIS/STATE8.0and8.0.2.)Press OK .Oncetheinstallationiscomplete,youwillreceive $vB aconfirmationdialogboxtellingyouthattheinstallationwassuccessful.Press OK .Press $hC  OK intheInstallationCompletedialogbox.Register.exewillautomaticallyrunandregister %ZD yourfiles.Whencompleted,pressanykeytoexit. U,%K 5   TRX3' LetterX3' Letter3' Letter3'T    4.2.2  FileList    ThefollowingfilesareincludedwithSDWIS/STATERelease8.0.3CumulativeforWindows q NTandDB2. [     $ VDX$07/24/2002 06:17p!V356,352 D CDS0010S.DLL /  07/24/2002 06:17pJJ#V1,274 D CDS0010S.REG   10/02/2002 05:03p%V563 D CDS0011S.DDE  v 10/02/2002 05:30p!V278,528 D CDS0011S.DLL  ` 10/02/2002 05:29pJJ#V1,274 D CDS0011S.REG J  10/02/2002 05:03p%V334 D CDS0012S.DDE 4  10/02/2002 05:30p!V385,024 D CDS0012S.DLL   10/02/2002 05:30pJJ#V1,274 D CDS0012S.REG   10/04/2002 02:40p!V962,560 D EBS0200E.DLL   10/04/2002 02:40pJJ#V1,274 D EBS0200E.REG i  10/10/2002 12:54p!V540,672 D EBS0500E.DLL S  10/10/2002 12:54pJJ#V1,274 D EBS0500E.REG = 10/04/2002 02:46p!V978,944 D EBSMAIN.DLL ' 10/04/2002 02:40pJJ#V1,263 D EBSMAIN.REG  10/07/2002 12:13p"V25,735 D EBSRPTS1.HLP n 10/02/2002 06:38p"V50,227 D GEN0200E.DDE X 10/02/2002 06:39p!V602,112 D GEN0200E.DLL B 10/03/2002 03:00p"V21,428 D GEN0200E.HLP , 10/02/2002 06:39pJJ#V1,274 D GEN0200E.REG  07/16/2002 06:23p!V116,859 D MBS0200E.DDE  07/17/2002 10:35aV2,125,824 D MBS0200E.DLL w 07/18/2002 10:36a"V70,291 D MBS0200E.HLP a 07/17/2002 10:35aJJ#V1,274 D MBS0200E.REG K 07/16/2002 06:24p"V94,963 D MBS0300E.DDE 5  07/17/2002 10:35a!V475,136 D MBS0300E.DLL ! 07/18/2002 10:42a"V46,204 D MBS0300E.HLP  "| 07/17/2002 10:35aJJ#V1,274 D MBS0300E.REG "f 07/16/2002 06:24p!V100,110 D MBS0300S.DDE #P  07/17/2002 10:35aV1,683,456 D MBS0300S.DLL $:! 07/17/2002 10:35aJJ#V1,274 D MBS0300S.REG %$" 07/16/2002 06:25p!V232,642 D MBS0301E.DDE & # 07/17/2002 10:34aV1,089,536 D MBS0301E.DLL ' $ 07/22/2002 03:29p!V126,815 D MBS0301E.HLP o(!% 07/17/2002 10:34aJJ#V1,274 D MBS0301E.REG Y)"& 07/16/2002 06:24p"V30,758 D MBS0301S.DDE C*#' 07/17/2002 10:34a!V655,360 D MBS0301S.DLL -+$( 07/17/2002 10:34aJJ#V1,274 D MBS0301S.REG ,%) :>   TRX3' LetterX3' Letter3' Letter3' LetterT   10/02/2002 04:15p!V102,277 D MBS1300E.DDE  10/02/2002 05:30pV1,433,600 D MBS1300E.DLL w 10/03/2002 03:02p"V51,193 D MBS1300E.HLP a 10/02/2002 05:30pJJ#V1,274 D MBS1300E.REG K  07/05/2002 11:58a"V51,827 D MBS1500E.DDE 5  07/08/2002 05:56p!V667,648 D MBS1500E.DLL   07/09/2002 10:49a"V34,905 D MBS1500E.HLP  | 07/08/2002 05:56pJJ#V1,280 D MBS1500E.REG  f 10/09/2002 11:19a!V557,056 D MBS1900E.DLL  P 10/09/2002 11:18aJJ#V1,274 D MBS1900E.REG :  10/02/2002 04:20p"V35,641 D MIG0200E.DDE $  10/02/2002 05:31pV2,985,984 D MIG0200E.DLL   10/03/2002 03:04p"V29,539 D MIG0200E.HLP   10/02/2002 05:30pJJ#V1,274 D MIG0200E.REG o  10/18/2002 04:20pJJ#V8,550 D MIG0500E.DDE Y  10/18/2002 04:53p!V479,232 D MIG0500E.DLL C  10/21/2002 11:06a"V25,871 D MIG0500E.HLP - 10/18/2002 04:53pJJ#V1,274 D MIG0500E.REG  04/24/2002 04:45p"V49,152 D REGISTER.EXE t 10/18/2002 04:20p"V24,753 D SBS0300E.DDE ^ 10/18/2002 04:51p!V131,072 D SBS0300E.DLL H 10/21/2002 11:07a"V21,474 D SBS0300E.HLP 2 10/18/2002 04:51pJJ#V1,274 D SBS0300E.REG  10/18/2002 04:20p!V142,629 D SBS0800E.DDE  10/18/2002 04:51pV1,298,432 D SBS0800E.DLL } 10/21/2002 11:09a"V52,795 D SBS0800E.HLP g 10/18/2002 04:51pJJ#V1,274 D SBS0800E.REG Q 10/22/2002 04:25p"V20,817 D SBS1000E.DDE ; 10/22/2002 04:27p!V172,032 D SBS1000E.DLL %  10/22/2002 04:54p"V17,105 D SBS1000E.HLP ! 10/22/2002 04:27pJJ#V1,274 D SBS1000E.REG !l 07/17/2002 10:13a!V108,015 D SBS1700E.DDE "V 07/17/2002 10:34a!V999,424 D SBS1700E.DLL #@  07/18/2002 10:58a"V45,928 D SBS1700E.HLP $*! 07/17/2002 10:34aJJ#V1,274 D SBS1700E.REG %" 07/17/2002 10:14a"V83,207 D SBS1800E.DDE &# 07/17/2002 10:34a!V495,616 D SBS1800E.DLL u' $ 07/18/2002 10:59a"V47,315 D SBS1800E.HLP _(!% 07/17/2002 10:34aJJ#V1,274 D SBS1800E.REG I)"& 10/07/2002 12:24p!V204,800 D SBS1900E.DLL 3*#' 10/07/2002 12:24pJJ#V1,274 D SBS1900E.REG +$( 10/18/2002 04:20p!V357,551 D SBS2800E.DDE ,z%) 10/22/2002 01:10pV2,674,688 D SBS2800E.DLL  10/21/2002 11:10a!V128,196 D SBS2800E.HLP w 10/22/2002 01:09pJJ#V1,274 D SBS2800E.REG a 07/05/2002 12:27p!V104,772 D SBS2900E.DDE K  07/05/2002 04:58p!V733,184 D SBS2900E.DLL 5  07/09/2002 10:52a"V56,296 D SBS2900E.HLP   07/05/2002 04:58pJJ#V1,280 D SBS2900E.REG  | 10/22/2002 04:57pV3,191,018 D SDWIS.HLP  f ̀87File(s)28,705,878bytes  ˃˃  4.2.3BindFileList OԀ      HX'XX X'    CopythefollowingfilesfromtheBindFilesdirectorytowhereyourexisting.bndfilesare w  located:#X'XXHX'#HX'XXX'݌ a  Ќ X'XXHX'   10/02/2002 05:30p"V34,687 D A4777733.bnd 5 10/18/2002 04:53p"V13,791 D A7481263.bnd  10/02/2002 05:30pJJ#V9,345 D A8510840.bnd  | 10/14/2002 05:45p"V25,300 D bind_files.lst f 07/24/2002 06:17p"V62,589 D CDSCALPR.bnd P 10/03/2002 10:54a"V60,222 D CDSCLEA1.bnd : 07/22/2002 10:19p"V18,583 D CDSMCLPR.bnd $ 10/02/2002 05:29p"V41,806 D CDSRAASU.bnd  06/24/2002 02:39p"V16,928 D CHECKCUR.bnd  10/09/2002 11:19a"V52,457 D CRCANDID.bnd o 06/24/2002 02:39p"V57,002 D DETERMI4.bnd Y 07/16/2002 06:17p"V86,388 D DUPCHECK.bnd C 07/16/2002 06:17p"V13,134 D DUPLICAT.bnd -  10/02/2002 05:30p"V24,458 D IDENTFYE.bnd ! 10/02/2002 05:30p"V45,186 D IMP49843.bnd "t 10/18/2002 04:52p"V26,790 D IMP66622.bnd "^ 07/16/2002 06:28p"V13,161 D IMP88650.bnd #H  10/02/2002 06:39p"V31,469 D IMP95689.bnd $2! 10/04/2002 02:43p!V196,360 D LISTVIOS.bnd %" 07/16/2002 06:17p"V58,470 D MTSSCHED.bnd & # 10/18/2002 04:52p"V47,033 D RDFORTPL.bnd }' $ 10/18/2002 04:52p"V57,908 D RDSWTRSU.bnd g(!% 10/02/2002 05:28pJJ#V8,939 D RDWSFACI.bnd Q)"& 07/05/2002 04:55p"V22,148 D UPMPAAND.bnd ;*#' ̀24File(s)1,024,154bytes#X'XX X'#HX'XXX' ,%) ЇThen,followtherebindinginstructionsinthe#X'XXHX'#InstallationGuidefor&  SDWIS/STATERelease8.0  forWindowsNTandDB2'HX'XXX'.SomeDB2databasebufferparametersmayneedtobeincreasedto w runbindfilessuccessfullyandalsoforoptimalperformanceoftheSDWIS/STATEapplications.Severalparameterstoconsiderare:applicationheapsize,statementheapsize,logfilesize,numberofprimarylogfiles,sortheapsize,andbufferpoolsize.#X'XXHX'#HX'XXX'