WPC +V AJG9<I+mDMTVo aI _hZ˶UAX!UфkB [ۭZޑh!v\_ Z Dz>+Cmf~] _:t Ek7DX^R38'hꆠZ5)$ E/KVcȣ9vsA+]!̐,޿?IBBjV^s8e N6IfjpŰ1 N۱aWkr\ Nz3i3 X:'ܔ$ p̞B=]Kخ3[V1IIVJ0Do= yYSx^2'QlR9u!AIo&V1Z0e:94ASP!4̟4؊Vo 0B % 0d#!8PY 0M*UN. 0| 0Xb 1AU@ 0GMI 1M 0 0 0EwG 0EH 0J m0w@Gj 1 1u 1 0 M!M! 0! 0n!M"^ " 0K" 0lcb" 0<" 0*hW#M# 0|# 0?$M$4$ 0E$% 0% & 0k2 133 0E3 0d4 0E4N5 0E5 B6 0E6 17 118M8 18 1C9]9 09 0: 0xg; 0<; 1< B<M< 0<U10==U >> 1> 1b? 1? 1p@ 1@ 1~A 1B 1B 1C 1C 0R!D B sD 1D 1E 1E 1%F 1F 03G 1GMdH 01hH 0=H 0H 0>I 0I 0J 0pZK 0L 0a~M 0M 0N 09GO 0O 02\P 0P 0:Q 0Q 0_IR 0 R 0kS 0U B*V D3W CAW D+[W 0W 0MY 064Z 0jZ 0:r[ 0h[ 0F\U6Z\U*\M\M\M\U@\M]M ]M] 0] 0J] 0N]M)^M-^ 01^M_M _M_ 1_M_ 1_ 1&` 1` 14a 1a 1Bb 1b 1Pc 1c 1^d 1d 1le 0e 1f 1g 1h 1h 1i 1i 1#j 1j 11k 1k 1?l 1l 1Mm 1m 1[n 1n 1io 1o 1wpU,pM*qM.qM2q C6q APq 1qMtr 1xr 1r 1s 0 tM,u 10uMuMuMuMuMuMuMuMuMu CKuM&vb*vM.v 12vMvMvMvMvMvMvMvMvMv 1vMdwMhwMlwUNpwwwU@w~(x~x C$yB>y 0@y yy~gz~zfc{ 0e{UJ{f1|a3| 1G| 1| 1U}f} C} 1} 1~ 1MM~(M?MC 0GME 0I 0G 0у 0ń 0:\Uf׆aنfaaa%U<;w|Ex zMMM >$"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 $%Q&Q'Q(Q)[*[+[,[-U & '  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 ParaXXXXXXDY-( $ 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.bndV 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)(9 Z6Times New Roman Regular      (`  Z(CG Times Regular t    \R3' Letter\ t    \R3' Letter\dmailto:sdwisstate@sdc-moses.com.(H$0   EXHIBITS  $     \R'3 Letter Landscape\ t    \R'3 Letter Landscape\ t    \R3' Letter\`L(Z3/$ I!%%%%X'X%%  ),h  Z2CG Times (W1) RegularTABLE D%-3579hiEGKOSW[_cAutoList65"""""""")1)a)%-3579hyEGKOSW[_cAutoList66"""""""")1)a)%-3579hEGKOSW[_cAutoList67"""""""")1)a)`Ld%-3579`EGKOSW[_cAutoList68"!"""""")1)a)%-3579heEGKOSW[_cAutoList69!!!!!!!!)1)a)%-3579`YEGKOSW[_cAutoList70"!"""""")1)a)    t    \R3' Letter\  r :`c81AutoList25  X   2(4 4 <DL!2     5+ 4 <DL!5    6Pw4Body 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       \R3' Letter\HeIPqeHeTABLE A /(%%%%X'X%%  _d:XX'  SDC0002017JB5015  October25,2002#X'Xd:i#cTABLE BTABLE ATABLE D   <pZ$Avalon Regular  //&%%%%X'X%%  _ProjectPlanPCNsuseletterextensionstodenotetheversion.Theoriginal  wouldbeSDC00020XXXXXXXXThefirstrevisionorupdatedversionwouldbeSDC00020XXXXXXXXAThesecondrevisionorupdatedversionwouldbeSDC00020XXXXXXXBetc.PleaseensurethatthecorrectPCNappearsinthecoverpagesaswellastheheaderinthemainbodyofthedocument.&'&' I!%%%%X'X%%  _L M%-3579`3LI      X'XXX'D *V A ddd Xdd Xdd XD ($D ($, ," d +  )V  )#X'XXX'#XyXXX'3UnitedStates d EnvironmentalProtectionAgency @V/!@V @33OfficeofGroundWaterandDrinkingWater0  0FT$T$ C9+@FT$FT$V ! C3JYXXy3 SoftwareReleaseNotesfor F SDWIS/STATERelease8.0.3CumulativeforWindows98andOracle <2  ^  !   < D  3#XyXY#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'XXXy#XyXXX'XXy 33AV)6 + dE6 + AOctober25,2002 #XyX`##X'XXXyA#X'XXX' SID+(  V@37553  V@  S3)'+( x _   3#X'XXX'Z#  ~.* D    1 !XX'   SOFTWARERELEASENOTESFORҀSDWIS/STATE#X'X ! 1 # 1 !XX'RELEASE8.0.3CUMULATIVE #X'X ! 1 #Ԁ 1 !XX'    FORWINDOWS98ANDORACLE #X'X ! 1w # $   CONTRACTNO.68W99002   TASKORDERNO.002017     Preparedfor:  UnitedStatesEnvironmentalProtectionAgencyOfficeofGroundWaterandDrinkingWaterDrinkingWaterProtectionDivisionX'XXX'1200PennsylvaniaAve.,NW#X'XXX' # VB Washington,DC20460X'XXX' H4 TaskOrderProjectOfficer:EdwardCottrill#X'XXX' #  !  Preparedby: &r  SystemsDevelopmentCenterScienceApplicationsInternationalCorporation6565ArlingtonBoulevardFallsChurch,VA22042  @+,$%     8$!%%dXXd8 CONTENTS     RX'XXX'   R0     1.00(#(#INTRODUCTION#""J(#.4 4 (#(##1R-݌   ЌX'XXX'  RX'XXX'   R0     2.00(#(#DESCRIPTIONOFSDWIS/STATERELEASE8.0.3CUMULATIVEFOR   WINDOWS98ANDORACLE#""J(#.zz#(#(##1RD݌   ЌX'XXX'  &/X'XXX'  &/r0  0T (#(#    2.1 T DatabaseMaintenanceandSchemaMigrationScripts#""J(#.~~ET (#T (##1&/r݌   ЌX'XXX'  '  '0  0T (#(#0 T (#T (# T   2.1.10 (# (#_POSTSM_FIX.SQL_#""J(#.& (# (##2'݌  Ќ  '  '0  0T (#(#0 T (#T (# T   2.1.2 MAP_DATAMIGRATION.SQLandMAP_MSACCESS.SQL#""J(#.B (# (##2'݌ ~j  Ќ  '  '0  0T (#(#0 T (#T (# T   2.1.3 RESET_USER.SQL#""J(#.22& (# (##2'݌ hT  Ќ  '  '0  0T (#(#0 T (#T (# T   2.1.40 (# (#_MODIFY_VTYPE_VTAA.SQL_#""J(#.  - (# (##2'݌ R>  Ќ  '  '0  0T (#(#0 T (#T (# T   2.1.5 _UPDATE_TINLGENT.SQL_#""J(#.+ (# (##3'݌ <(  Ќ  '  '0  0T (#(#0 T (#T (# T   2.1.6 _UPDATE_TMNALRA.SQL_#""J(#.* (# (##3'6݌ &  Ќ  &/X'XXX'  &/50  0T (#(#    2.20T T (#T (#SDWIS/STATEMSAccessDatabaseFiles#""J(#.7T (#T (##3&/5o݌   ЌX'XXX'  '  'q0  0T (#(#0 T (#T (# T   2.2.10 (# (#NewMSAccess2000Databases#""J(#.4 (# (##3'q݌   Ќ  '  '}0  0T (#(#0 T (#T (# T   2.2.20 (# (#RevisionstoPreviouslyDeliveredMSAccess97Databases#""J(#.P (# (##4'}݌  Ќ  &/X'XXX'  &/0  0T (#(#    2.30T T (#T (#DescriptionofResolutionsforSDWIS/STATERelease8.0.3Cumulativefor  Windows98andOracle#""J(#.(T (#T (##4&/݌  ЌX'XXX'  '  '/0  0T (#(#0 T (#T (# T   2.3.1 MigrationtoSDWIS/STATE#""J(#.0 (# (##4'/J݌  Ќ  '  '/0  0T (#(#0 T (#T (# T   2.3.2 OnlineSDWIS/STATEComponents#""J(#.PP5 (# (##6'/J݌ x Ќ  '  '4 0  0T (#(#0 T (#T (# T   2.3.30 (# (#MigrationtoSDWIS/FED:Actions#""J(#.7 (# (##9'4 O ݌ vb Ќ  RX'XXX'   RC!0     3.00(#(#ADDITIONALINFORMATION#`"`"I(#.$(#(##10RC!!݌ R> ЌX'XXX'  &/X'XXX'  &/f"0  0T (#(#    3.10T T (#T (#Advisory:SampleUniquenessinOnlineSampling#`"`"I(#.BT (#T (##10&/f""݌ D0 ЌX'XXX'  &/X'XXX'  &/#0  0T (#(#    3.20T T (#T (#Advisory:CDSSetupPostProcessingReport#`"`"I(#.>T (#T (##11&/##݌ . ЌX'XXX'  &/X'XXX'  &/$0  0T (#(#    3.30T T (#T (#Advisory:SpecifyingDSNontheODBCDataAdministratorWindow#`"`"I(#. RT (#T (##11&/$,%݌  ЌX'XXX'  &/X'XXX'  &/J&0  0T (#(#    3.40T T (#T (#Advisory:WaterSystemFacilityMaintenanceandSellerTreatment &/J&&݌ T (#T (# ЌX'XXX'    &/X'XXX'    &/'0  0T (#(#    0T T (#T (# Indicator!   !#`"`"I(#., , T (#T (##11&/''݌   ЌX'XXX'  &/X'XXX'  &/)0  0T (#(#    3.50T T (#T (#Advisory:""DeterminingWaterSourceTypeforPurchasedWater#`"`"I(#.&&OT (#T (##11&/)R)݌ ! ЌX'XXX'  &/X'XXX'  &/*0  0T (#(#    3.6 T Advisory:MigrationtoCCRWriter#`"`"I(#.5T (#T (##12&/**݌ " ЌX'XXX'  &/X'XXX'  &/+0  0T (#(#    3.7 T Advisory:SizeofMSAccessDatabaseWindow#`"`"I(#.?T (#T (##12&/++݌ # ЌX'XXX'  &/X'XXX'  &/,0  0T (#(#    3.80T T (#T (#Advisory:InvalidSamplingPointWindow#`"`"I(#.00;T (#T (##12&/,+-݌ $  ЌX'XXX'  &/X'XXX'  &/2.0  0T (#(#    3.90T T (#T (#Discrepancy:InstallationPackageandMigrationtoSDWIS/STATEProgram ~%j! Group#`"`"I(#.Z Z T (#T (##12&/2.l.݌ h&T" ЌX'XXX'  &/X'XXX'  &//0  0T (#(#    3.100T T (#T (#Discrepancy:Release8.0ODDViolationTypePermittedValues#`"`"I(#.PPPT (#T (##13&///݌ R'> # ЌX'XXX'  &/X'XXX'  &/ 10  0T (#(#    3.110T T (#T (#Discrepancy:##MigrationtoSDWIS/STATE:MBSsPNActivityModule#`"`"I(#. ST (#T (##14&/ 1C1݌ <((!$ ЌX'XXX'  &/X'XXX'  &/z20  0T (#(#    3.120T T (#T (#Discrepancy:$$MigrationtoSDWIS/STATE:MBSsComplianceSchedule &)"% Module#`"`"I(#. T (#T (##14&/z22݌ *"&  X'XXX'  RX'XXX'  *#'        R40     4.00(#(#INSTALLATIONINSTRUCTIONSANDFILELISTFORSDWIS/STATE   RELEASE8.0.3CUMULATIVEFORWINDOWS98ANDORACLE#`"`"I(#.@(#(##14R44݌  ЌX'XXX'  &/X'XXX'  &/50  0T (#(#    4.1 T DatabaseMaintenanceandSchemaMigrationScripts#`"`"I(#.DDDT (#T (##15&/576݌  ЌX'XXX'  &/X'XXX'  &/?70  0T (#(#    4.2 T SDWIS/STATEMSAccessDatabaseFiles#`"`"I(#.7T (#T (##18&/?7y7݌  ЌX'XXX'  &/X'XXX'  &/t80  0T (#(#    4.3 T ReplacementApplicationFiles#`"`"I(#.0T (#T (##21&/t88݌  ЌX'XXX'  '  '90  0T (#(#0 T (#T (# T   4.3.1 InstallationInstructions#`"`"I(#.""1 (# (##21'99݌   Ќ  '  ':0  0T (#(#0 T (#T (# T   4.3.2 FileList#`"`"I(#.``! (# (##21'::݌ x  Ќ     EXHIBITS  6 J  ;  H  H<0     ) )Exhibit1.) )%0T (#(#%DBASCRIPTSforRelease8.0.3CumulativeforWindows98and-H</<݌& T (#T (# Ќ  _H  H==0     _0(#(#0T (#(#-LANBasedOracle#`"`"I(#.ll#T (#T (##16H==X=݌   Ќ  H  H:>0     * *Exhibit2.* *&0T (#(#&DBASCRIPTSforRelease8.0.3CumulativeforWindows98andPersonal   EditionOracle#`"`"I(#. !T (#T (##17H:>U>݌   Ќ  + +H  Hݢ?0     Exhibit3.+ +'0T (#(#'MSAccess2000DatabasesforOracle#`"`"I(#.6T (#T (##19Hݢ??݌   Ќ  H  Hݬ@0     , ,Exhibit4., ,(0T (#(#(MsAccess97DatabasesforOracle#`"`"I(#.4T (#T (##20Hݬ@@݌  Ќ  <     @U PP51.00  INTRODUCTION  B(#(# TheHX'XXX'SafeDrinkingWaterInformationSystem(SDWIS)/STATERelease8.0.3Cumulative#X'XXHX'A#HX'XXX'Ԁfor  Windows98andOraclereleaseincludesfixestoproblemsnotedinSDWIS/STATERelease   8.0andalsoimplementssomenewrequirementsmadetothesoftwaresincethereleaseof#X'XXHX'SB#HX'XXX'SDWIS/STATERelease8.0forWindows98andOracle#X'XXHX'vC#HX'XXX'Ԁand#X'XXHX'C#HX'XXX'ԀSDWIS/STATERelease8.0for   Windows98andOraclePersonalEdition.#X'XXHX'5D#HX'XXX'   #X'XXHX'D#HX'XXX'#X'XXHX')E#HX'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XXHX'oE#HX'XXX'includesthenewrequirementsandsoftwarefixesin lX #X'XXHX'E#HX'XXX'SDWIS/STATERelease8.0.1#X'XXHX'fF#andSDWIS/STATERelease8.0.2aswellasfixesandnew VB  requirementsimplementedsincethereleaseofthosetwopatches. @,  YoumayinstallHX'XXX'ԀSDWIS/STATERelease8.0.3Cumulative#X'XXHX'G#Ԁafteryourstate/regionhaseither   successfullyschemamigratedfromSDWIS/STATERelease7.0toSDWIS/STATERelease8.0orhassuccessfullycompletedanewstate/newregioninstallationofSDWIS/STATERelease8.0.HX'XXX'Thisdocumentincludesadescriptionofthe#X'XXHX'H#HX'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XXHX'NI#Ԁcontents  andinstructionsforfileinstallation.Foranswerstoquestionsyoumayhavethatarenotcoveredbythesereleasenotes,youmaycalltheSDWISUserSupportHotlineat703-292-6298orsendanemailto4 6 O  5  sdwisstate@sdcmoses.com.6JOJЌ  76J dP   2.00  HX'XXX'DESCRIPTIONOFSDWIS/STATERELEASE8.0.3CUMULATIVEFOR " WINDOWS98ANDORACLE zKԀ#X'XXHX'K# X'XXX' (#(# ThissectioncontainsabriefdescriptionofwhatisincludedinSDWIS/STATERelease8.0.3  Cumulative.Thecontentsofthisreleaseincludefixesthathavebeenmadetoexisting  SDWIS/STATERelease8.0softwareaswellasnewrequirementsthathavebeenimplementedsincetheinitialreleaseofSDWIS/STATE8.0.#X'XX X'KL#  2.1  DatabaseMaintenanceandSchemaMigrationScripts N #n  HX'XXX'#X'XXHX'N#HX'XXX'CorrectionshavebeenmadetosomeDBAscriptsandnewrequirementsimplemented,as ^%J! discussedbelow.Forspecificinformationonwhetheryouneedtocopyoneofthesescriptsintoyourenvironment,aswellasinstructionsonhow/wheretodoso,seethematrixesinExhibit1andExhibit2inSubsection4.1.#X'XXHX'N#ԀNotethattherearetwoseparatefoldersforthe (!$ scripts:onesupportingusersofLANbasedOracle,theothersupportingOraclePersonalEditionusers. +$( Ї  2.1.10  _POSTSM_FIX.SQL_ (Q (#(# _POSTSM_FIX.SQL_Ԁshouldberunonlyonceperproductiondatabaseatyourlocation.Ifeither  ofthefollowingtwoconditionsapplytoyourRelease7.0productiondatabase,thefollowingrevisedscriptsshouldbeused: %3   %3R2"3  0    YourSDWIS/STATERelease7.0dataschemacontainschemical,radionuclide,and/or   leadandcopperScheduleGroups,andthereforemonitoringrequirementsthatreferenceanalytegroups.%3RR݌ (#(# Ќ   %3   %33T2"3  0    YouusedRelease7.0ComplianceDecisionSupport(CDS)Setup,andyourdatabase @,  containsmonitoringperiodaverage(TMNMPAVG)andcalculatedMaximumContaminantLevel(MCL)value(TMNCMCLV)records.%33T^T݌ (#(# Ќ  NotethatyoushouldnotrunthisscriptonceyouhavebegunusingtheonlineResultsAverages   function,asitcallsscriptUPDATE_RESULTS_AVG.SQL,whichupdatesthevalueinthe_D_USERID_CODE_fieldofallSDWIS/STATE8.0TMNMPAVGandTMNCMCLVtablesto   _CDSSETUP_.YourdatabasewillthenlosethemarkerthatindicatesthatCDSSetupshouldnotupdatethem. |   2.1.2  MAP_DATAMIGRATION.SQLandMAP_MSACCESS.SQL WԀ  dP DatabasemaintenancefilesMAP_DATAMIGRATION.SQLandMAP_MSACCESS.SQLhavebeenmodifiedtofacilitateuseofastate/regionselectedUserIDandpassword.Theintroductorycommentsinsideeachscriptclarifythattheyarenotpartoftheschemamigrationscriptsandthateachmaybeusedanytimeafterschemamigrationhasbeenrun. HX'XXX'  2.1.3  RESET_USER.SQL YԀ #X'XXHX'Y#    Atypographicalerrorincorrectlyreferencingtable TMGVIOSDinDBAMaintenancescriptRESET_USER.SQLhasbeencorrectedtoreference TMNVIOSD.  2.1.40  _MODIFY_VTYPE_VTAA.SQL_ ZԀl$X (#(#  HX'XXX'  HX'XXHX'  u[  NewTMNVTYPE/TMNVTAArecords,changestoexistingTMNVTYPE/TMNVTAA H&4" records,anddeletionsfromthesetablestosupportrecentreportingguidanceforMicrobialDisinfectionByProducts(MDBP)ruleandInterimEnhancedSurfaceWaterTreatmentRule(IESWTR)areincludedinscript#X'XXHX'U[#_MODIFY_VTYPE_VTAA.SQL_HX'XXX'Ԁtohelpusersmeetfederal )!% reportingrequirementsforviolations.u[[݌̌HX'XXHX'    +$( #X'XXHX'\]#  2.1.5  _UPDATE_TINLGENT.SQL_ ]^Ԁ   HX'XXX'AscripttoupdateTINLGENT.COUNTRY_CODEtoUSwhereTINLGENT.ADDRESS_ZIP_CODEisvaluedisincluded.Thisaddressesaproblem#X'XXHX'^#HX'XXX'MigrationtoSDWIS/FED:Inventory#X'XXHX'_#ԀhaswiththeA1andtheA3Form,where,ifCountry   Code(C0140orC0314)isnotvalued,nostatecode(C0139orC0313)orzipcode(C0141orC0315)transactioniscreatedintheDTFfile.HX'XXX'MigrationtoSDWIS/FED:Inventory#X'XXHX'`#Ԁworks   correctlyiftheCountryCodeisvalued.  2.1.6  _UPDATE_TMNALRA.SQL_ a  VB  Ascriptisincludedtocorrectthecontentsoftwofieldsinonerecordoftable_TMNALRA_ԀinthestartupdatabaseZZV80.Thisscriptshouldbeappliedonlybystates/regionswhohavejust   installedZZV80withtheintentofusingSDWIS/STATE8.0astheirproductiondatabase.If   youhaveschemamigratedfromyourproductionSDWIS/STATE7.0database,youdonotneedtoapplythisscript.  2.20  SDWIS/STATEMSAccessDatabaseFiles cԀ (#(# CorrectionshavebeenmadetosomepreviouslydeliveredMSAccessdatabases,andnewrequirementsimplemented,asdiscussedbelow.Forspecificinformationonwhetheryouneedtocopyoneofthesedatabasesintoyourenvironment,aswellasinstructionsonhow/wheretodoso,seethematrixinExhibit3(forMSAccess2000versionsofthesedatabases)andinExhibit4(forMSAccess97versionsofthesedatabases).  2   2.2.10  NewMSAccess2000Databases fԀ (#(# HX'XXX'AtEPAsrequest,10MSAccessdatabasesthatweredeliveredwithRelease8.0usingMS  Access97,werealsodeliveredsubsequenttoRelease8.0asMSAccess2000databases.#X'XXHX'}f# %3   %3g2"3  0    PRECOMP.MDB.%3gg݌"(#(# Ќ   %3   %3Fh2"3  0    RELATION.MDB.%3Fhqh݌#~(#(# Ќ   %3   %3i2"3  0    EBSRPTS.MDB.%3i2i݌|$h (#(# Ќ   %3   %3i2"3  0    CDSRPTS.MDB.%3ii݌f%R!(#(# Ќ   %3   %3j2"3  0    CCRBRIG.MDB.%3jj݌P&<"(#(# Ќ   %3   %3Gk2"3  0    SDWISCOM.MDB.%3Gkrk݌:'& #(#(# Ќ   %3   %3l2"3  0    DATAMIG.MDB.%3l3l݌$(!$(#(# Ќ   %3   %3l2"3  0    DATAMIGW.MDB.%3ll݌)!%(#(# Ќ   %3   %3m2"3  0    SDWISEDI.MDB.%3mm݌)"&(#(# Ќ   %3   %3Jn2"3  0    _SDWISODD.MDB_.%3Jnun݌*#'(#(# Ќ   +$(   2.2.20  RevisionstoPreviouslyDeliveredMSAccess97Databases Co(#(#  TwoMSAccess97databaseshavebeenmodifiedsinceRelease8.0.   2.2.2.10  CDSReport(CDSRPTS.MDB) (#(#  TwominorchangesweremadetotwoCDSReportqueries,whichinconcertwiththechangestothePostCDSReportsLogfunction,enabletheresultsofapreviouslyrunLeadandCopperTapMonitoringandReporting(M&R)ComplianceReporttobeviewedaccuratelywhenreexecutedfromthePostCDSReportsLog.HX'XXX' nZ  #X'XXHX'q#8VXX'H8V8V#HX'XH8Vr##X'XXHX'r# 2.2.2.20  EnforcementReportsComplianceScheduleReport  (#(# HX'XXX'ThesearchfunctionontheComplianceScheduleReport,whichispartoftheEnforcement   Report,hasbeenclarified.(Thisfunctiondidnotworkasuserspreviouslyexpected).#X'XXHX'r#Ԁ     2.30  DescriptionofResolutionsforSDWIS/STATERelease8.0.3Cumulativefor  Windows98andOracle tԀ (#(# ThefollowingitemsdescribeproblemsidentifiedsincethereleaseofSDWIS/STATE8.0andwhoseresolutionisincludedinSDWIS/STATERelease8.0.3CumulativeforWindows98and p\ Oracle. ZF   2.3.1  MigrationtoSDWIS/STATE uԀ  . IssuesaddressedwithintheMigrationtoSDWIS/STATEcomponentaredescribedin   subsections2.3.1.1and2.3.1.2. 2.3.1.1MigrationtoSDWIS/STATE:MDBPSummary    Ѐ"0  Undersomescenarios,thesoftwarewasincorrectlycarryingforwardareferenced " SamplingPointfromajustprocessedstructuresettextfilerecordandapplyingittothenextMDBPSummaryinthestagingtablewhenthatrecorddidnotreferenceasamplingpoint.ThisproblemwasfixedinRelease8.0.2. (#(# "0  Undersomescenarios,valuesforMDBPSummaryfieldsPERCENT_SAMPLES_ 6'" # BEYOND_MSR_LVLandMDBPSummaryPERCENT_SAMPS_BYND_MSR_LVL_TXTwerenotbeingcalculated.ThisproblemwasfixedinRelease8.0.2. (#(#  +$(  2.3.1.2MigrationtoSDWIS/STATE:Monitoring   "0  AproblemintheHX'XXX'MigrationtoSDWIS/STATE:Monitoring#X'XXHX'y#ԀViolationmodulethat  affectedthe duplicatebydatacheckaswellasthe duplicatebynumbercheckwasfixedinRelease8.0.2. (#(# "0  AproblemthatmanifesteditselfinthescenariowheretheHX'XXX'MigrationtoSDWIS/STATE:   Monitoring#X'XXHX'o{#ԀNonTotalColiformRule(TCR)Schedulemodulecreatedasample  n schedulegroupwithanopenEffectiveEndDateandwasthenunabletosuccessfullycreateSamplingPointSubscheduleswhenthetextfiledataindicatedthattheyshouldbecreated,hasbeenaddressed.Asecondproblemthatoccurredwhen,withinthesametextfile,thereexistedtwodifferentscheduleswhoseWaterSystemsweredifferentbutwhoseWaterSystemFacility(WSF)StateAsgndIDhappenedtobethesame,wasalsofixed.Inthiscase,thewatersystemfromthesecondschedulewasnotbeingpickedup,butthisproblemwasfixedinRelease8.0.2. (#(# "0  TheHX'XXX'MigrationtoSDWIS/STATE:Monitoring#X'XXHX'~#ԀPackageSchedulemoduleerroneously  preventedthecreationofanon-TotalOrganicCarbon(TOC)package(onethatdoesnotinvolvea2920finishedschedule)ifthesupportingschedulewasforanalytecode2920,1067,or1927.ThisfunctionhasnowbeenfixedtoallowthesePackagedSchedules,justastheycanbeaddedusingonlineScheduleMaintenance.ThisproblemwasfixedinRelease8.0.2. (#(# "0  TheFacilityAnalyteLevelstructuresetallowsuserstoassociatetheFacilityAnalyte " Level(_FANL_)totwoviolationtypes:oneforM&Rviolations,andoneforlevelviolations.Therearetwofieldstobeusedforeachassociation:theViolationTypeCodeandtheViolationTypeIS_Number.IfthereismorethanonerecordinTMNVTYPEofthesameViolationTypeCode,thesoftwareistousetheViolationTypeIS_Numbertochoosethecorrectrecordtoassociatetothe_FANL_.TheproblemwasthatthesoftwarewasassociatingtheFANLtothefirstrecordinTMNVTYPEofthereferencedViolationTypeCodeandwasnotusingtheViolationTypeIS_NumbertodistinguishthecorrectTMNVTYPErecord,whenthissecondstepwasneeded.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  TheViolationstructuresetandsoftwaremoduleincorrectlyindicatedthatforviolations 0&" ofviolationtype71and72,thenewCompliancePeriodBegindatewouldbeusedforaparticulardateedit,wheninfactthedateeditshouldhaveusedtheViolationPeriodBegindate.ThiserrorhasbeencorrectedinRelease8.0.3.AdvisoryNote:The (!% SDWISCOM.MDBerrormessagehasnotbeenchangedtoreferenceViolationPeriodBeginDateinsteadofCompliancePeriodBeginDate.Whenyouaremigratingintype71and72violations,andoneofthemisflaggedorrejectedbecauseofanissuewith +$( P      CompliancePeriodBegin/EndDate,theproblemisactuallywithViolationPeriodBegin/EndDate.(#(#   2.3.2  OnlineSDWIS/STATEComponents Ԁ    IssuesaddressedwithinonlineSDWIS/STATEcomponentsaredescribedinsubsections2.3.2.1through2.3.2.11. 2.3.2.1OnlineSampling"ResultsAverageMaintenance  lX "0  Theerrormessage PrecursorRemovalRatioCannotbeBlankwaserroneously H4  displayedwhenyouattemptedtosaveaResultsAveragesrecordwithoutavalueintheoptionalPrecursorRemovalRatiofield,availableinboththeMonitoringPeriodAverage(MPA)andRunningAnnualAverage(RAA)groupboxes.Youhadtoenter0inthefieldtosavetherecord.Thesoftwarenolongerrequiresyoutoenteravalueintheseoptionalfields.ThiswasfixedinRelease8.0.2. (#(# "0  ThesoftwarehasbeenfixedsothatitvaluesMonitoringPeriodAverage.DUserid  CodeandMCLValue.DUseridCodefromfieldUSERIDinTINUSER,asspecifiedintheRelease8.0DesignDocument.ThiswasfixedinRelease8.0.2. (#(#  2.3.2.2OnlineSampling"SampleMaintenance  VB "0  OntheTCRSampleMaintenancebyWaterSystemwindow,previouslyyouwerenot 2 abletosavechangestoFieldResults.ThiswasfixedinRelease8.0.2. (#(# "0  OntheFieldResultsdialogboxwhenitwasdisplayedfromeithertheGeneral  MicrobiologicalSamplebyWaterSystemwindowortheGeneralMicrobiologicalSamplebyLaboratorywindow,ifyouenteredavalueintheFlowRatefield,itwasnotbeingsaved.ThiswasfixedinRelease8.0.2. (#(# "0  OntheChemicalandRadionuclideResultsMaintenancewindows,aproblemwherethe #n softwarehadalwaysautomaticallydisplayedtheanalytesRegulatoryMinimumDetectionLimit(RMDL)value,butwasnolongerdoingso,hasbeenfixed.ThesoftwarenowdisplaystheanalytesRMDLvalueasitalwayshas.ThiswasfixedinRelease8.0.2. (#(#  %3   %32"3  0    OnanyoftheSampleMaintenancewindows(byLaborbyWaterSystem),ifyou (!% attemptedtocreateanewsamplingpointbyenteringavalueinonlytheSampleLocationfield(withnovalueinSamplingPoint),thisactioncorrectlytriggeredtheInvalidSamplingPointdialogbox.YoucouldthenspecifyActivityStatusandDate +$( andcreateasamplingpoint,butwhenyouexitedthedialogbox,thesoftwaredidnotsavethesamplelocationandactivitydateinformation.ThisproblemhasbeenfixedinRelease8.0.3.%3B݌ (#(# Ќ  HX'XXX'2.3.2.3OnlineSampling"MDBPSummaryMaintenance #X'XXHX'#   "0  WhenusingtheDistributionResidualDisinfectantConcentration(_RDC_)ChangeorAdd   windowfromeithertheSamplingcomponents MDBPSummary/SWTR (Surface  n WaterTreatmentRule)windowflowortheSamplingcomponents Sample t` Summaries/TCRSummary/SWTRRDC buttonwindowflow,thecontrollevelthat fR  wasdisplayedforthestateresidualwasnotcorrect.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  Iftherewasmorethanonetreatmentplantordistributionsystemforthe_MDPB_   Summary'sreferencedWSF,theSWTRandMaximumResidualDisinfectantLevel(_MRDL_)windowflowdidnotallowtheentryofMDBPsummaries,eveniftheappropriateFANLswereinplace.ThisproblemhasbeenfixedinRelease8.0.3. (#(#  2.3.2.4OnlineSampling"TCRSummaryMaintenance   WhenthesoftwareautomaticallyassociatedanewTCRSummarytoadistributionsystem(DS)(which_occured_ԀwhentherewasonlyoneDS)andyousubsequentlyenteredtheMonitoringPeriodforthesummary,thesoftwareshouldthenhaveenabledthe SWTRRDC and CL2 XD RDC buttons.However,youhadtoselecttheWSFStateAsgnID GoTo buttonandre-select J6 thedistributionsystemtoenablethesebuttons.ThisproblemhasbeenfixedinRelease8.0.3,andthe SWTRRDC and CL2RDC buttonsarenowenabledatthecorrectpoint. &  2.3.2.5OnlineEnforcement"EnforcementActionSearch    AproblemwithdefaultdatesnotbeingproperlydisplayedintheEnforcementActionSearchdialogboxhasbeencorrectedinRelease8.0.3.Previously,ifyoudidnotenteranydatecriteriaintheEnforcementActionSearchdialogbox,itssearchlogicfunctionedasinpreviousreleases;i.e.,itsearchedforEnforcementActionswhoseStatusDatewas6monthspriortotoday'sdate.These defaultdatesdidnotappearonthewindow,however,eventhoughthesoftwarewasusingthem.ThedatedefaultsthatexistedwithRelease7.0andpriornowappearonthewindow.(StartDatedefaultstothedatethatis6monthspriortotodaysdate.EndDatedefaultstotodaysdate.)̀ +$(  2.3.2.6OnlineEnforcement"PNScheduleMaintenanceList   AproblemwhereopenPublicNotification(PN)SchedulesdidnotfirstdisplayonthePNScheduleMaintenanceListhasbeencorrectedinRelease8.0.3.ThePNScheduleMaintenanceListnowcorrectlydisplaysallopenPNschedulesthatmeettheuserspecifiedcriteriawhenthelistisfirstdisplayed. 2.3.2.7OnlineMonitoringandNoncompliance"ValidatePositiveTCRResults   n TheproblemwherethesoftwarewasincorrectlycreatingapreliminaryacuteviolationwhenitencounteredonlyonepositiveTCRandfecalcoliformsample,butnopositiverepeatsample,hasbeenfixed.ThesoftwarenowcorrectlysearchesforapositiverepeatTCRsamplealongwithapositiveroutineTCRandeitherfecalcoliformorHX'XXX'E.coli#X'XXHX'#Ԁsamplepriortocreatingthe   preliminaryacuteviolation.ThisproblemwasfixedinRelease8.0.2. 2.3.2.8OnlineMonitoringandNoncompliance"Violations    ThismodulehasbeenredeliveredsothatitusesthefixedViolation duplicatebydatacheckthatwasoriginallyfixedfortheMigrationtoSDWIS/STATEViolationmodule.Thisproblem  wasfixedinRelease8.0.2. 2.3.2.9OnlineMonitoringandNoncompliance"MigrateCandidateCDSViolations B  Ӎ2.3.5..OnlineMonitoringandNoncompliance"MigrateCandidateCDSViolationsC   ^J "0  ThismodulehasbeenredeliveredsothatitusesthefixedViolation duplicatebydata :& checkthatwasoriginallyfixedfortheMigrationtoSDWIS/STATEViolationmodule. $ ThiswasfixedinRelease8.0.2. (#(# "0  MigrateCDSCandidateViolationswaspreviouslynotcarryingtheWSFreferencedby  thecandidateviolationintotheactualSDWIS/STATEviolation.ThisproblemhasbeenfixedandareferencedWSFinthecandidateviolationisnowcorrectlycarriedovertotheactualviolation.ThishasbeenfixedinRelease8.0.3. (#(# "0  AproblemwheresomePNcandidateviolationswerenotbeingcorrectlymigratedinto t$`  theTMNVIOLtablehasbeencorrected.ThiswasactuallyaproblemwiththewaythePNComplianceReportclearedoutpreviouslycreatedviolationsfordifferentagencies.ThisproblemhasbeenfixedinRelease8.0.3. (#(#  +$( P     _ 2.3.2.10OnlineMonitoringandNoncompliance"PostCDSReportsLog   "0  CandidateType43violationsthatdisplayedwhenyourantheCDSSWTRCompliance  ReportwerenotshowingupwhenyoulaterrequestedthedatafromthesamereportusingthePostCDSReportsLog.ThisproblemwasfixedinRelease8.0.2. (#(# "0  AproblemwiththePostCDSReportsLogwasfixedinRelease8.0.2,enablingthe   displayofallinformationforapreviouslyrunLeadandCopperTapM&RComplianceReport. (#(#  2.3.2.11CDSSetup @,   "0  UnderthescenariowherethereisafinishedTOCschedulepackagedwitharawTOC   andrawalkalinityscheduleandwherethevalueinMonitoringPeriodAverageNUMB_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.ThismadetheinformationforthisCDSSetupprocessunnecessarily "| difficulttoprocess.ThisproblemhasbeencorrectedinRelease8.0.3,andtheinformationforthisCDSSetupprocessisreportedintheCDSSetupProcessingReport d$P  inthesamewayasitisforallotherCDSSetupprocesses.N%:!(#(#   2.3.30  MigrationtoSDWIS/FED:Actions ۱ "' #(#(# AproblemthathadgoneundiscoveredsincethedeliveryofSDWIS/STATERelease7.0hasbeenfixed.Thisproblemoccurredwhenanenforcementactionwasalsolinkedtoaviolationthatreferencedastate-ownedviolationtype(notreportabletoSDWIS/FED)aswellasbeinglinkedtoaviolationthatreferencedafederally-ownedviolationtype.Inthis_scenarioHX'XXX', +$( MigrationtoSDWIS/FED:Actions#X'XXHX'ȳ#HX'XXX'Ԁincorrectlyunderstoodthatifoneviolationlinkedwasstate  owned,allviolationslinkedwerethenstate-owned.TheresultwasthesoftwaredidnotgenerateboththeE1formandtheY5000.#X'XXHX'B#HX'XXX'MigrationtoSDWIS/FED:Actions#X'XXHX'^#Ԁhasbeenfixed  togenerateboththeE1formandtheY5000whentheenforcementactionislinkedtobothaviolationthatreferencesastate-ownedviolationtype(notreportabletoSDWIS/FED)ANDaviolationthatreferencesafederallyownedviolationtype(thatisreportedtoSDWIS/FED).ThishasbeenfixedinRelease8.0.3.  3.00  ADDITIONALINFORMATION  dP(#(# NotetheadvisoriesanddiscrepancylistedinSubsections3.1through3.10.  3.10  Advisory:SampleUniquenessinOnlineSampling ڷ  (#(# InresponsetoarecentUserSupportinquiry,itwasnotedthatsampleuniquenesscriteriaforasampleenteredusingoneoftheonlineSampleMaintenancewindowsisnotdocumentedineithertheUsersGuideoronlineHelpforthosewindows.SampleuniquenesscriteriafortheonlinesamplingwindowshasnotchangedsincetheSamplingcomponentwasoriginally  introducedin1995.ThecriteriaforenteringasamplewhenusingonlineSamplingremains:  IfvaluingLabSampleNo.:0  WaterSystemplusLabplusLabSampleNo.plusCollectionDateplusSamplingPoint. (#(# IfleavingLabSampleNo.blank:0  WaterSystemplusLabplusCollectionDateplusSamplingPointandifsupplied,CollectionTime. (#(# ThesecriteriaaredifferentthanthecriteriaspecifiedforSamplingviaEDI/Migrationto ! SDWIS/STATE:Sampling,whichisstricter.Theabovecriteriawerespecifiedbyuserswho "| attendedthetwoSamplingJADsinNovember1994andFebruary1995.Atthattime,there z#f wasanexplicitrequirementtobeabletocreateasamplewithoutusingaLabSampleNo.orStateSampleNo.TheuniquenesscriteriadescribedaboveappliedtoallSDWIS/STATEsamplesuntilSDWIS/STATERelease7.0.WithSDWIS/STATERelease7.0,sampleuniquenesscriteriaforSamplingviaEDI/MigrationtoSDWIS/STATE:Samplingwere "' # tightened,asdescribedinAppendixAoftheSystemAdministrationGuideandAppendixEof  ( $ theUsersGuide. +$( _  3.20  Advisory:CDSSetupPostProcessingReport  (#(# WhenCDSSetupencountersaFinishedTOCSchedulepackagedwithasingleRaw  Schedule/ScheduleGroupforTOCorAlkalinity,thefollowingmessagemayappearinthePostCDSSetupProcessingReport: CannotcalculateaprecursorachievedremovalratiobecausethereisnotaRawAlkalinityScheduleassociatedwiththeFinishedTOCschedule.ThismessageappearswhennoprecursorachievedremovalratiocanbecalculatedforaSampleScheduleMonitoringPeriodAssignment(SSMPA)ApplicablePeriodBeginandEndDateRangeassociatedtotheFinishedTOCSchedule.Thismessagemayalsoappearasaduplicateadvisorymessageinthereport.Inreality,however,itisnotaduplicatemessage;itappearsthiswaybecausewhiletheinformationtoidentifytheScheduleissupplied,themonitoringperiodandSSMPAApplicablePeriodBeginandEndDateRangearenotspecified.Eachtimethemessageappearsasaduplicate,itappliestoasecond,third,fourth,etc.,MonitoringPeriod(SSMPA)ApplicablePeriodRange"whichisnotsupplied.  3.30  Advisory:SpecifyingDSNontheODBCDataAdministratorWindow   (#(# IntheRelease8.0InstallationGuide,inthechapterthatcoversinstallingSDWIS/STATE  application/clientsoftwarefiles,Phase6ODBCAdministration,notethataftertheODBCDataAdministratorwindowappears,youmaywishtoselecttheSystemDSNtabratherthantheUserDSNtab.TheGuidedoesnotspecifywhichtabtouseinthedocumentation(eitherUserDSNorSystemDSN),becausethisisgenerallyunderstoodtobeauserpreference.UserDSNwouldmeanthatsomeoneelseloggingintoyourmachinewouldneedtocreatetheirowndatasource.Forthisreason,youmaywanttospecifySystemDSNsothatanyoneloggingintotheworkstationcanusethedatasource.IfyoudorecreatetheOracledatasourceunderSystemDSN,youshouldremoveitfromtheUserDSN.  3.40  Advisory:WaterSystemFacilityMaintenanceandSellerTreatmentIndicator q(#(#  TheEnvironmentalProtectionAgency(EPA)requiresthatprimacyagenciesnotonlyindicatewhetherornotthesellertreatsthewater,butalsowhetherornotthatwaterisfiltered.OntheexistingWaterSystemFacilityMaintenancewindow,theSellerTreatmentIndicatorfieldhasbeenmodifiedtohaveanewpermittedvalueofF"Treatedbyseller"includingfiltration.IfthevalueinthisfieldforagivenfacilityneedstobechangedtoF,youeitherneedtoupdateitusingtheonlinesoftwareorsomeothertool.NotethatthisinformationisreportedtoSDWIS/FED.  3.50  Advisory:DeterminingWaterSourceTypeforPurchasedWater V(!%(#(#  EPAregulationsstatethatindeterminingthesourcetypeforconsecutiveconnections,thebuyerssourcetypemustfollowthesellerstype.Forexample,iftheselleris groundwater +$( undertheinfluenceofsurfacewater(GUI),thenthebuyer'sprimarysourcebecomes purchasedgroundwaterundertheinfluenceofsurfacewater(_GUP_),not PurchasedGroundwater(_GWP_).SDWIS/STATE,however,doesnotlookattheprimarysourcetypeofthesellerwatersystemwhendeterminingtheprimarysourcetypeofabuyer;itlooksattheinformationenteredastheWaterTypefortheConsecutiveConnection(CC)forthebuyer.AusercanenterGroundwaterastheWaterTypeforaCCeveniftheCCislinkedtoasellerthatisaGUI.Toverifysourcetypesforpurchasedwater,checkthe_WSFs_ԀoftypeCC.NotethatthisinformationisreportedtoSDWIS/FED.  3.6  Advisory:MigrationtoCCRWriter   N:   WhenusingMigrationtoCCRWriter(_CCRBRIG.MDB_),thiscomponentworkswithEPAs 2  productCCRWriterv.1.5,whichisanMSAccess97basedfileandthereforecannotbeinstalledusingMSAccess2000.Tocontinueusingthisdatabase,createafolderC:\CCRWriterandthen,fromtheCCRWriterinstallationdisk,copyfile_CCRTBL.MDB_Ԁintothisfolder.WhenyouopenthisfileusingMSAccess2000,youwillbeaskedtoconvertit.Whenasked,youwillneedtorenameitwithadifferentnameinordertocontinueusingit.  3.7  Advisory:SizeofMSAccessDatabaseWindow    Thesizeofthedatabasewindow,whenlaunchedfromanapplicationfile(e.g.,EBSReportsorMigrationtoSDWIS/STATE:MDBPSummaryImportTexttoStagingTable),maydifferfrom ^J oneusagetothenext.Youmayneedtoresizethedatabasewindowthatislaunchedbeforeusingit.  3.80  Advisory:InvalidSamplingPointWindow I (#(# InattemptingtocreateanewsamplingpointbyenteringavalueinfieldSampleLocation(andnotfieldSamplingPoint),ifyouusethemousetomovetothenextentryfieldonthewindow(thefieldvarieswithsampletype),theInvalidSamplingPointdialogboxopensbehindthecurrent,SampleMaintenancewindow.TobringtheInvalidSamplingPointdialogboxtothefront,clickonthebuttonforInvalidSamplingPointwindowinthetoolbar.Youcanthenentertheactivitystatus/dateinformation.  3.90  Discrepancy:InstallationPackageandMigrationtoSDWIS/STATEProgram P&<" Group  (#(#  TheinstallationpackagesforSDWIS/STATERelease8.0forWindows98andOracleaswellas ) "% theoneforSDWIS/STATERelease8.0forWindows98andOraclePersonalEditionhaveeach *"& beenfoundtohaveaminorbug;ifyouselect NowhenyouareaskedwhetherornotyouwishtoinstalltheMigrationtoSDWIS/STATEProgramGroup,theinstallationpackage +$( incorrectlycreatestheMigrationtoSDWIS/STATEProgramGroup.Ininstanceswhereyoudo  notwishtohaveitinstalled,youwillneedtomanuallyremoveitfromthedesktop.  3.100  Discrepancy:Release8.0ODDViolationTypePermittedValues   (#(# IntheRelease8.0OnlineDataDictionary(ODD),whenyouasktodisplaythepermittedvaluesforfieldsinViolationType(tableTMNVTYP),whentheFederalViolationType(TMNVTYP)Valueswindowisdisplayed,itdoesnotshowthefollowingnewRelease8.0fieldsonthewindow:"0  FEDReportingPeriodType(letsthesoftwareknowwhethertheviolations H4  CompliancePeriod(BeginandEndDates)ortheViolationPeriodBeginDateshouldbereportedtoSDWIS/FED)withthefollowingpermittedvalues: (#(# 0  0T (#(#CP"TheCompliancePeriodBeginandEndDateshouldbereportedto   SDWIS/FEDforanyviolationusingthisViolationType. T (#T (# 0  0T (#(#VP"TheViolationPeriodBeginDateshouldbereportedtoSDWIS/FEDfor  anyviolationusingthisViolationType. T (#T (# 0  0T (#(#RA"RunningAnnualAveragePeriod.lXT (#T (# "0  ReportNumberofMissingSamplestoSDWIS/FED?@,(#(# L %-3579eh`M%-3579L0  0T (#(#Y/Yes"MigrationtoSDWIS/FEDshouldcreateatransactionthatreportsthe  numberofmissingsampleswiththeviolation(aspartoftheD1record). T (#T (#   0  0T (#(#N/No"MigrationtoSDWIS/FEDshouldnotcreateatransactionthatreportsthe  numberofmissingsampleswiththeviolation(aspartoftheD1record). T (#T (# 0   (#(# 0  0T (#(#Spaces"Fielddoesnotapplytostateownedviolationtypessoshouldnotbe "| valuedinmostcases. T (#T (# L %-3579Y`h%-3579L"0  ReportNumberofExceedencestoSDWIS/FED?N%:!(#(# 0  0T (#(#Y/Yes"MigrationtoSDWIS/FEDshouldcreateatransactionthatreportsthe "' # numberofexceedenceswiththeviolation(aspartoftheD1record). T (#T (# 0  0T (#(#N/No"MigrationtoSDWIS/FEDshouldnotcreateatransactionthatreportsthe )"& numberofexceedenceswiththeviolation(aspartoftheD1record). T (#T (# _ +$( @U  T   TRX3' LetterX3' Letter3' Letter3'T   0  0T (#(#Spaces"Fielddoesnotapplytostateownedviolationtypesandtherefore  shouldnotbevaluedinmostcases. T (#T (# "0  FedReportableContaminantCode"TellsSDWIS/STATEsoftwarewhethertheanalyte   coderecordedwiththeviolationoradifferentcode(theonespecifiedinthisfield)shouldbereportedtoSDWIS/FED. (#(# ThisinformationisavailablethroughRELATION.MDB,theonlineSystemAdministration z f component,andtheViolationfunctioninonlineMonitoringandNoncompliance. dP   3.110  Discrepancy:MigrationtoSDWIS/STATE:MBSsPNActivityModule  8$ (#(# TheMigrationtoSDWIS/_STATE:MBS_PNActivitymodulecanonlymigrate100PNactivity   recordsatatime.Whileitisnotanticipatedthatastate/regionwouldnormallybemigratinginlargenumbersofPNactivityrecords,ifyoudoneedtomigrateinmorethan100PNactivityrecords,youwillneedtocreatetextfilesingroupsof100.  3.120  Discrepancy:MigrationtoSDWIS/STATE:MBSsComplianceScheduleModule  (#(# TheMigrationtoSDWIS/_STATE:MBS_ComplianceSchedulemodulecanonlymigrate100 n complianceschedulerecordsatatime.Youwillneedtocreateseveraltextfilesandmigratetheminseparatelyifthenumberofcomplianceschedulerecordstobemigratedexceeds100.  4.00  INSTALLATIONINSTRUCTIONSANDFILELISTFORSDWIS/STATE  RELEASE8.0.3CUMULATIVEFORWINDOWS98ANDORACLE  (#(# SDWIS/STATERelease8.0.3CumulativeforWindows98andOracleisacombinationof  automaticallyinstalledfilesandfilesthatyouwillneedtocopyfromtheinstallationpackage,basedontheneedofyourlocationsoperatingenvironment.Wheremanualcopyoffilesisnecessary(inSubsections4.1and4.2),detaileddecisionmatrixesaresuppliedtoassistyouindecidingwhetherornotyoumayneedtocopyaparticularfile."0  Y"meansYes,youshouldinstallit.^%J!(#(# "0  N"meansNo,youdonotneedtoinstallitbecauseyoualreadyhaveoritdoesnot H&4" applytoyourlocation. (#(# Forautomaticallyinstalledfiles,seeinstructionsinSubsection4.3.  )"& 5   TRX3' LetterX3' Letter3' Letter3' LetterT   FromEPAsSDWIS/STATEwebsite,downloadfile8.0.3_Win98.zip.Using_WinZip_,  extracttoafolderyouname/create,suchas  8VXX'J>38VEXTRACT_803_98 +$( #X'X8V##X'XXJXZ#.Whenyouopenthisfolder,  youwillseethefollowingfoldersandfiles: 8VXX'J>38VAccess_2000_MDBs?+ 4 <DL!X?Access_97_MDBs_DBA_Scripts_LAN__DBA_Scripts_PC__Sdwis80_Appl803_Files.LSTAppl803_Win98._INF_INSTALL_Appl803Win98.EXE#X'X8V##X'XXJXZ#  4.1  DatabaseMaintenanceandSchemaMigrationScripts Ԁ    ThematrixesinExhibit1andExhibit2listallthedatabasescriptsdeliveredwithHX'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XXHX'#ԀHX'XXX'Windows98andOracle.Youwillneedtomanually  copythescriptslistedinthissection.#X'XXHX'-#ԀUsethedecisioncolumnsineachmatrixtohelpyou  decideifyouneedtocopyascript.Thelastcolumnofthematrixspecifiesthefolderintowhichyoushouldcopyagivenscript.8VXX'H8V8V#HX'XH8V##X'XXHX'#HX'XXX'Toruneachscript,loginastheDBAuser(e.g.,SYSTEM)andrunitinSQL*Plus.#X'XXHX';# * Notethatifyouhaveschemamigratedfromyour7.0toyournew8.0SDWIS/STATEdatabasebuthavenotyetrunscript_POSTSM_FIX.SQL_HX'XXX',inordertorunit,bothyour8.0data  schemaand7.0dataschemamustbepresentandavailableinyourOracledatabaseinstance,asthisscriptreadstablesinyour7.0schemaandupdatestablesinthe8.0schema.#X'XXHX'#  ToaccessandruntheLANbasedOraclescripts,openfolder_DBA_Scripts_LAN_.ToaccessandruntheOraclePersonalEditionscripts,openfolder_DBA_Scripts_PC_.  z!f XZXXX' o 5ijTRP$'3 Letter LandscapeX3' Letter'3 Letter Landscape3' LetterT*xVdA d " d " V ..x, dd ,*dd ,dd ,dd ,dd ,dd ,dd ,k dd +  *   *  #X'XXXZ# EXHIBITS8VXX'Exhibit1.DBASCRIPTSforRelease8.0.3CumulativeforWindows98andLANBasedOracle#X'X8V8# "EXHIBITS" >4)d    >XX'Name ' 'Release  Version ' r 'FileDate ' 'Size ' 'Have  applied:NoPatches? ':   'Have   applied:Patch8.0.1? ':   'Have   applied:Patches8.0.1&8.0.2? ' j 'CopytoFolder: " " * _POSTSM_FIX.SQL_ Thisscript   shouldberunONETIMEOnly! * n N *8.0.1 *   *05/22/20024:32P MCh H B@15492B@M15,492 I?=  B@15492 B@ IY"SchemaMigrated8.0User    N"SchemaMigrated8.0User    N"SchemaMigrated8.0User   ! SDWIS_MIGRATE70TO80 *  " *  "   "   "   " N"New8.0Startup  $ N"New8.0Startup  & N"New8.0Startup  (   ( MAP_DATAMIGRATION.SQL   ) 8.0.2   * 07/12/200209:25A 7-  , <@8312<@78,312 7-+ - <@8312 <@ 7Y   . Y   / N   0 SDWIS_MIGRATE70TO80\DBA_SCRIPTS   1 MAP_MSACCESS.SQL  2 8.0.2   3 07/12/200209:29A 8. r 5 J@28968J@828,968 8., 6 J@28968 J@ 8Y   7 Y   8 N   9 SDWIS_MIGRATE70TO80\DBA_SCRIPTS   : RESET_USER.SQL  ; 8.0.2   < 06/20/200204:53P 8. jJ> @20246@820,246 8., ? @20246 @ 8Y   @ Y   A N   B SDWIS_MIGRATE70TO80\DBA_SCRIPTS   C _MODIFY_VTYPE_VTAA.SQL_  D 8.0.3  E 10/21/200204:15p 8. B"G @13669@813,669 8.,H @13669 @ 8Y  I Y  J Y  K SDWIS_MIGRATE70TO80  L _UPDATE_TINLGENT.SQL_  xXM 8.0.3  xXN 10/21/200204:13p 7- P @1727@71,727 7-+xXQ @1727 @ 7Y  xXR Y  xXS Y  xXT SDWIS_MIGRATE70TO80  xXU _UPDATE_TMNALRA.SQL_󀄀 This P0V scriptisforNEWStatesusingZZV80only! * XFF *8.0.3 * P0Y *10/22/200211:34A MC[ *@11860*@M1,1860 I?=P0\ *@11860 *@ IN"SchemaMigrated8.0User  t_ N"SchemaMigrated8.0User  tb N"SchemaMigrated8.0User  te SDWIS_MIGRATE70TO80 * P0f *  fFf   fFf   fFf   fFf Y"New8.0Startup  lLh Y"New8.0Startup  lLj Y"New8.0Startup  lLl fFl  #X'X5# * Bothyour8.0dataschemaand7.0dataschemamustbepresentinyourOracledatabaseinstance,asthisscriptreadstablesin 0m your7.0schemaandupdatestablesinthe8.0schema. * n ij  r   * V d d dd  *dd *dd dd dd dd dd k dd k V.., dd ,9dd ,dd ,dd ,dd ,dd ,dd , dd +  3   3 EXHIBITS8VXX'Exhibit2.DBASCRIPTSforRelease8.0.3CumulativeforWindows98andPersonalEditionOracle#X'X8VO# "EXHIBITS1" 5+)d"   5d:XX'   Name   l Release  Version    FileDate ' 'Size ' 'Have  applied:NoPatches? '   'Have   applied:Patch8.0.1? '  'Have  applied:Patches8.0.2&8.0.1? '  'CopytoFolder: " " * _POSTSM_FIX.SQL_ Thisscript   shouldberunONETIMEOnly! *  G *8.0.1 *  H *05/22/20025:25P MC I ;@15478;@M15,478 I?= J ;@15478 ;@ IY"SchemaMigrated8.0User  l N"SchemaMigrated8.0User  l  N"SchemaMigrated8.0User  l# SDWIS_MIGRATE70TO80 *  $N *  rR$   rR$   rR$   rR$ N"New8.0Startup  l & N"New8.0Startup  l ( N"New8.0Startup  l *   rR* MAP_DATAMIGRATION.SQL   + 8.0.2   , 07/12/200209:26A 7- l . @8162@78,162 7-+ / @8162 @ 7Y   0 Y   1 N   2 SDWIS_MIGRATE70TO80\DBA_SCRIPTS   3 MAP_MSACCESS.SQL  4 8.0.2   5 07/12/200209:31A 8. l 7 2@288742@828,874 8., 8 2@28874 2@ 8Y   9 Y   : N   ; SDWIS_MIGRATE70TO80\DBA_SCRIPTS   < _MODIFY_VTYPE_VTAA.SQL_  = 8.0.3  > 10/21/200204:15p 8. l@ @13669@813,669 8.,A @13669 @ 8Y  B Y  C Y  D SDWIS_MIGRATE70TO80\DBA_SCRIPTS  E _UPDATE_TINLGENT.SQL_  F 8.0.3  G 10/21/200204:13p 7- lI @1727@71,727 7-+J @1727 @ 7Y  K Y  L Y  M SDWIS_MIGRATE70TO80  N _UPDATE_TMNALRA.SQL_󀄀 This O scriptisforNEWStatesusingZZV80only! * J*Qaa` *8.0.3 * Ra *10/22/200211:34A LBlTb @1860@L1,860 H><Uc @1860 @ HN"SchemaMigrated8.0User  B"X N"SchemaMigrated8.0User  B"[ N"SchemaMigrated8.0User  B"^ SDWIS_MIGRATE70TO80 * _g *  (_   (_   (_   (_ Y"New8.0Startup  B"a Y"New8.0Startup  B"c Y"New8.0Startup  B"e (e  #X'Xd:J# * Bothyour8.0dataschemaand7.0dataschemamustbepresentinyourOracledatabaseinstance,asthisscriptreadstablesin f your7.0schemaandupdatestablesinthe8.0schema.  g 5   TRX3' LetterP$'3 Letter Landscape3' Letter'3 Letter LandscapeT    4.2  SDWIS/STATEMSAccessDatabaseFiles V&Ԁ    Exhibit3andExhibit4listalltheMSAccessdatabasefilesdeliveredwithSDWIS/STATE  Release8.0.3CumulativeforWindows98andOracle.Youwillneedtomanuallycopythe   MSAccessdatabaseslistedinthissection.Usethedecisioncolumnsinthematrixtohelpyoudecideifyouneedtocopyoneormoreofthedatabasefilessupplied;thelastcolumnofthematrixspecifiesintowhichfolderyoushouldcopythedatabase.NotethatifyouareusingOraclePersonalEdition,youwillneedtoremovethealiasfromtheServiceNamefieldintheOracle8ODBCDriverConnectwindowandrelinkalllinkedtables.Exhibit3listsallthenewMSAccess2000versiondatabasefilesthathavebeendeliveredsubsequenttoRelease8.0.Toaccessthesedatabases,openfolderAccess_2000_MDBs.Exhibit4listsalltheMSAccess97versiondatabasefilesthathavebeenmodifiedandredeliveredsubsequenttoRelease8.0.Toaccessthesedatabases,openfolderAccess_97_MDBs.   e  TRP$'3 Letter LandscapeX3' Letter'3 Letter Landscape3' LetterT5XZXXX'z5*Vd d dd  9dd 9dd dd dd dd dd  dd V ..,?dd ,dd , dd ,dd ,~dd ,6dd ,dd ,dd ,>dd ,dd , dd ,dd ,|dd ,4dd ,dd ,dd ,;dd ,dd , dd ,dd ,ydd ,2dd ,dd ,dd ,:dd ,dd , dd ,dd ,xdd ,0dd ,dd ,dd ,7dd ,dd , dd ,dd ,udd ,-dd ,dd , dd +  %  %  #X'XXXZj,# EXHIBITSExhibit3.MSAccess2000DatabasesforOracle "EXHIBITS~2"Ԁ 9/$d  98VXX'L2Name ' 'Release  Version ']  'Date/TimeGroup ' 'Size ' 'Have  applied:NoPatches '/   'Have   applied:Patch8.0.1 '/   'Haveapplied:   Patches8.0.2&8.0.1 '/  'CopytoFolder:   * _PRECOMP.MDB_    8.0.1    05/28/2002@04:40P 9/    ,A921600 ,A9921,600 9/-   ,A921600  ,A 9Y    N    N    C:\SDWIS\DATA     * RELATION.MDB   b 8.0.1   b 05/21/2002@02:11P :0  b BA2457600BA:2,457,600 :0. b BA2457600 BA :Y   b N   b N   b C:\SDWIS\MSA_VIEW   b   * _CCRBRIG.MDB_ a! 8.0.1  a" 05/21/2002@02:00P :0 a#  ?A2039808 ?A:2,039,808 :0.a$  ?A2039808  ?A :Y  a% N  a& N  a' C:\SDWIS\CCRBRIG  a( SDWISCOM.MDB . ) 8.0.1  . * 05/21/2002@02:13P 9/ . + "A610304"A9610,304 9/-. , "A610304 "A 9Y  . - N  . . N  . / C:\SDWIS\MIGRATE  . 0  * _DATAMIG.MDB_ ' 1 8.0.1  ' 2 05/30/2002@02:30P :0 ' 3 JA3493888JA:3,493,888 :0.' 4 JA3493888 JA :Y  ' 5 N  ' 6 N  ' 7 C:\SDWIS\MIGRATE  ' 8  * _DATAMIGW.MDB_  9 8.0.1   : 05/30/2002@02:30P :0  ;  N   ? C:\SDWIS\MDB   @ SDWISEDI.MDB Z A 8.0.1  Z B 05/212002@02:14P 9/ Z C A487424A9487,424 9/-Z D A487424 A 9Y  Z E N  Z F N  Z G C:\SDWIS\EDIDATA  Z H _SDWISODD.MDB_ SI 8.0.1  SJ 05/21/2002@02:15P :0 SK OA4157440OA:4,157,440 :0.SL OA4157440 OA :Y  SM N  SN N  SO C:\SDWIS\ODD  SP *CDSRPTS.MDB Q 8.0.2  R 07/08/2002@05:35P :0 S XEA2797568XEA:2,797,568 :0.T XEA2797568 XEA :Y  U Y  V N  W C:\SDWIS\CDS # X ?# * _EBSRPTS.MDB_ zY _EBSRPTS.HLP_ LZ 8.0.38.0.3  F\ 10/16/2002@02:45P10/07/2002@12:09P <2 F^ lA 255226180lA<2,55226,180 <20F` lA 255226180 lA <YY  Fb YY  Fd YY  Ff C:\SDWIS\EBSC:\SDWIS\EBS#X'X8V*3#&#%XX'Fh ?  #X'X#%&NC#* Note:IfyouareusingOraclePersonalEdition,youwillneedtoremovethealiasfromtheServiceNameFieldintheOracle8 5i ODBCDriverConnectwindowandrelinkalllinkedtablestousethisDatabase.&#%XX'  /j?  z $  TRP$'3 Letter LandscapeP$'3 Letter Landscape'3 Letter Landscape'3 Letter LandscapeT   TRP$'3 Letter LandscapeP$'3 Letter Landscape'3 Letter Landscape'3 Letter LandscapeT      0'*V d d7dd 7dd  dd dd udd u-dd -dd  dd  V..,jdd ,/dd ,Ldd ,dd ,dd ,dd ,dd ,dd +  %  %  #X'X#%&D# EXHIBITSExhibit4.MsAccess97DatabasesforOracle "EXHIBITSGJ"Ԁ&#%XX' 9/$Yd  9JName '  'Release   Version '  'Date/TimeGroup '  'Size '  'Have   applied:NoPatches '   'Have    applied:Patch8.0.1 '   'Haveapplied:   Patches8.0.2&8.0.1 '  'CopytoFolder: '  ' * CDSRPTS.MDB  8.0.2   07/08/2002@05:30P :0  AA2228224AA:2,228,224 :0. AA2228224 AA :Y   Y   N   C:\SDWIS\CDS    * _EBSRPTS.MDB_  _EBSRPTS.HLP_ s~ 8.0.38.0.3#X'X#%&J#&#%XX'  mx 10/16/2002@1:45P10/07/2002@12:09P <2 mx ¡A 934626180¡A<9,34626,180 <20mx! ¡A 934626180 ¡A <YY#X'X#%&DO#&#%XX'  mx# YY#X'X#%&EP#&#%XX'  mx% YY#X'X#%&P#&#%XX'  mx' C:\SDWIS\EBSC:\SDWIS\EBS#X'X#%&P#&#%XX' mx)   #X'X#%&mQ#* Note:IfyouareusingOraclePersonalEdition,youwillneedtoremovethealiasfromtheServiceNameFieldintheOracle8 cn * ODBCDriverConnectwindowandrelinkalllinkedtablestousethisDatabase. 8 55 0'   TRX3' LetterP$'3 Letter Landscape3' Letter'3 Letter LandscapeT   TRX3' LetterX3' Letter3' Letter3' LetterT  $     4.3  ReplacementApplicationFiles %V  r AllSDWIS/STATE8.0Windows98/Oracleusersmustinstalltheapplicationfiles.ThefileslistedunderSubsection4.3.2replaceexistingfilesinthefolderinwhichyoukeepyourSDWIS/STATE8.0applicationsoftware.Pleaserefrainfromaccessingtheapplicationwhilethefilesarebeingupdated.     4.3.1  InstallationInstructions W  n  ClickonfileINSTALL_Appl803Win98.EXE.Pressthe InstallSystem button.Youwillbe J  askedtoconfirmwheretheapplicationfilesshouldbeinstalled.YoushouldselectthesamefolderwhereyourSDWIS/STATE8.0applicationfilesreside.(Thefilesincludedin X'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XX X'[Y#Ԁwilloverwriteexistingfilesthatwereinstalledwith   SDWIS/STATE8.0,8.0.1,and8.0.2.)Press OK .Oncetheinstallationiscomplete,youwill l  receiveaconfirmationdialogboxtellingyouthattheinstallationwassuccessful.Press OK . ^  Press OK intheInstallationCompletedialogbox.Register.exewillautomaticallyrunand P  registeryourfiles.Whencompleted,pressanykeytoexit.  4.3.2  FileList [   ThefollowingfilesareincludedwithSDWIS/STATERelease8.0.3CumulativeforWindows98  andOracle. r $ VDX$07/25/2002 09:16pxx$J3,720 8 CDS0010S.DDE F 07/25/2002 09:25p"J430,080 8 CDS0010S.DLL 0 07/25/2002 09:19p#J20,480 8 CDS0010S.EXE  07/25/2002 09:18pxx$J1,291 8 CDS0010S.REG v 10/02/2002 05:14p&J563 8 CDS0011S.DDE ` 10/02/2002 05:26p"J344,064 8 CDS0011S.DLL J  10/02/2002 05:20p#J20,480 8 CDS0011S.EXE 4! 10/02/2002 05:19pxx$J1,291 8 CDS0011S.REG " 10/02/2002 05:15p&J334 8 CDS0012S.DDE # 10/02/2002 05:46p"J434,176 8 CDS0012S.DLL #  10/02/2002 05:43p#J20,480 8 CDS0012S.EXE $j! 10/02/2002 05:43pxx$J1,291 8 CDS0012S.REG %T" 10/04/2002 03:06p"J136,915 8 EBS0200E.DDE &> # 10/04/2002 03:15p   J1,101,824 8 EBS0200E.DLL '(!$ 10/04/2002 03:10p#J81,920 8 EBS0200E.EXE ("% 10/07/2002 01:01p#J50,707 8 EBS0200E.HLP n)"& 10/04/2002 03:09pxx$J1,291 8 EBS0200E.REG X*#' 10/10/2002 01:37p#J89,290 8 EBS0500E.DDE B+$( 10/10/2002 01:45p"J585,728 8 EBS0500E.DLL r 10/10/2002 01:41p#J77,824 8 EBS0500E.EXE \ 10/10/2002 04:49p#J42,347 8 EBS0500E.HLP F 10/10/2002 01:40pxx$J1,291 8 EBS0500E.REG 0  10/04/2002 03:06p"J109,579 8 _EBSMAIN.DDE_   10/04/2002 03:23p   J1,146,880 8 _EBSMAIN.DLL_   10/04/2002 03:19p#J98,304 8 _EBSMAIN.EXE_  | 10/07/2002 01:03p#J37,959 8 _EBSMAIN.HLP_  f 10/04/2002 03:18pxx$J1,280 8 _EBSMAIN.REG_  P 10/07/2002 12:07p#J25,741 8 EBSRPTS1._HLP_ :  10/03/2002 11:46a#J50,227 8 GEN0200E.DDE $  10/03/2002 11:57a"J659,456 8 GEN0200E.DLL   10/03/2002 11:50a#J28,672 8 GEN0200E.EXE j  10/03/2002 02:40p#J21,428 8 GEN0200E.HLP T  10/03/2002 11:49axx$J1,291 8 GEN0200E.REG >  07/16/2002 06:44p"J116,859 8 MBS0200E.DDE (  07/16/2002 07:10p   J2,457,600 8 MBS0200E.DLL  07/16/2002 06:49p#J61,440 8 MBS0200E.EXE  07/18/2002 10:05a#J70,291 8 MBS0200E.HLP t 07/16/2002 06:48pxx$J1,291 8 MBS0200E.REG ^ 07/16/2002 05:02p#J94,963 8 MBS0300E.DDE H 07/16/2002 06:42p"J483,328 8 MBS0300E.DLL 2 07/16/2002 06:42p#J69,632 8 MBS0300E.EXE  07/18/2002 10:07a#J46,204 8 MBS0300E.HLP x 07/16/2002 06:41pxx$J1,291 8 MBS0300E.REG b 07/16/2002 05:01p"J100,110 8 MBS0300S.DDE L 07/16/2002 05:29p   J2,297,856 8 MBS0300S.DLL 6 07/16/2002 05:09p#J20,480 8 MBS0300S.EXE   07/16/2002 05:08pxx$J1,291 8 MBS0300S.REG   07/16/2002 05:03p"J232,642 8 MBS0301E.DDE   07/16/2002 05:48p   J1,089,536 8 MBS0301E.DLL !l 07/16/2002 05:45p"J176,128 8 MBS0301E.EXE "V 07/22/2002 01:38p"J126,815 8 MBS0301E.HLP #@  07/16/2002 05:44pxx$J1,291 8 MBS0301E.REG $*! 07/16/2002 05:02p#J30,758 8 MBS0301S.DDE %" 07/16/2002 05:42p"J835,584 8 MBS0301S.DLL p&# 07/16/2002 05:37p#J20,480 8 MBS0301S.EXE Z' $ 07/16/2002 05:36pxx$J1,291 8 MBS0301S.REG D(!% 10/02/2002 05:14p"J102,277 8 MBS1300E.DDE .)"& 10/02/2002 05:40p   J1,757,184 8 MBS1300E.DLL *#' 10/02/2002 05:29p#J57,344 8 MBS1300E.EXE +$( 10/03/2002 02:42p#J51,802 8 MBS1300E.HLP +z%) _10/02/2002 05:28pxx$J1,291 8 MBS1300E.REG r 07/08/2002 01:56p__#J51,827__Ԉ 8 MBS1500E.DDE_ \ _07/08/2002 02:29p__"J724,992__Ԉ 8 MBS1500E.DLL_ F _07/08/2002 02:23p__#J53,248__Ԉ 8 MBS1500E.EXE_ 0  _07/08/2002 03:47p__#J34,905__Ԉ 8 MBS1500E.HLP_   _07/08/2002 02:22p__xx$J1,291__Ԉ 8 MBS1500E.REG_   _10/09/2002 11:28a__#J10,559__Ԉ 8 MBS1900E.DDE_  | _10/09/2002 05:57p__"J630,784__Ԉ 8 MBS1900E.DLL_  f _10/09/2002 05:52p__#J53,248__Ԉ 8 MBS1900E.EXE_  P _10/10/2002 04:51p__#J22,863__Ԉ 8 MBS1900E.HLP_ :  _10/09/2002 05:52p__xx$J1,291__Ԉ 8 MBS1900E.REG_ $  _10/02/2002 05:15p__#J35,641__Ԉ 8 MIG0200E.DDE_   _10/03/2002 10:56a__   J3,620,864__Ԉ 8 MIG0200E.DLL_ j  _10/03/2002 10:56a__#J32,768__Ԉ 8 MIG0200E.EXE_ T  _10/03/2002 02:44p__#J29,539__Ԉ 8 MIG0200E.HLP_ >  _10/03/2002 10:55a__xx$J1,291__Ԉ 8 MIG0200E.REG_ (  _10/18/2002 05:19p__xx$J8,550__Ԉ 8 MIG0500E.DDE_  _10/18/2002 05:31p__"J520,192__Ԉ 8 MIG0500E.DLL_  _10/18/2002 05:25p__#J28,672__Ԉ 8 MIG0500E.EXE_ t _10/21/2002 11:04a__#J25,871__Ԉ 8 MIG0500E.HLP_ ^ _10/18/2002 05:24p__xx$J1,291__Ԉ 8 MIG0500E.REG_ H _04/24/2002 04:45p__#J49,152__Ԉ 8 REGISTER.EXE_ 2 _10/18/2002 05:21p__#J24,753__Ԉ 8 SBS0300E.DDE_  _10/18/2002 05:48p__"J139,264__Ԉ 8 SBS0300E.DLL_ x _10/18/2002 05:46p__#J28,672__Ԉ 8 SBS0300E.EXE_ b _10/21/2002 11:22a__#J21,474__Ԉ 8 SBS0300E.HLP_ L _10/18/2002 05:45p__xx$J1,291__Ԉ 8 SBS0300E.REG_ 6 _10/18/2002 05:22p__"J142,629__Ԉ 8 SBS0800E.DDE_   _10/18/2002 05:58p__   J1,409,024__Ԉ 8 SBS0800E.DLL_   _10/18/2002 05:51p__#J90,112__Ԉ 8 SBS0800E.EXE_   _10/21/2002 11:23a__#J52,795__Ԉ 8 SBS0800E.HLP_ !l _10/18/2002 05:50p__xx$J1,291__Ԉ 8 SBS0800E.REG_ "V _07/17/2002 10:46a__"J108,015__Ԉ 8 SBS1700E.DDE_ #@  _07/17/2002 10:57a__   J1,114,112__Ԉ 8 SBS1700E.DLL_ $*! _07/17/2002 10:50a__#J61,440__Ԉ 8 SBS1700E.EXE_ %" _07/19/2002 03:50p__#J47,486__Ԉ 8 SBS1700E.HLP_ p&# _07/17/2002 10:49a__xx$J1,291__Ԉ 8 SBS1700E.REG_ Z' $ _07/17/2002 10:47a__#J83,207__Ԉ 8 SBS1800E.DDE_ D(!% _07/17/2002 11:00a__"J495,616__Ԉ 8 SBS1800E.DLL_ .)"& _07/17/2002 11:00a__#J61,440__Ԉ 8 SBS1800E.EXE_ *#' _07/19/2002 03:53p__#J48,947__Ԉ 8 SBS1800E.HLP_ +$( _07/17/2002 10:59a__xx$J1,291__Ԉ 8 _SBS1800E.REG +z%) 10/07/2002 01:48p#J29,945 8 SBS1900E.DDE r 10/07/2002 01:55p"J221,184 8 SBS1900E.DLL \ 10/07/2002 01:51p#J24,576 8 SBS1900E.EXE F 10/07/2002 05:05p#J15,673 8 SBS1900E.HLP 0  10/07/2002 01:51pxx$J1,291 8 SBS1900E.REG   07/08/2002 02:55p"J223,707 8 SBS2000E.DDE   07/08/2002 03:12p   J2,027,520 8 SBS2000E.DLL  | 07/08/2002 03:01p#J77,824 8 SBS2000E.EXE  f 07/19/2002 03:54p#J57,356 8 SBS2000E.HLP  P 07/08/2002 03:00pxx$J1,291 8 SBS2000E.REG :  07/08/2002 02:57p#J91,410 8 SBS2300E.DDE $  07/08/2002 03:22p"J905,216 8 SBS2300E.DLL   07/08/2002 03:20p#J61,440 8 SBS2300E.EXE j  07/08/2002 04:00p#J39,577 8 SBS2300E.HLP T  07/08/2002 03:19pxx$J1,291 8 SBS2300E.REG >  07/08/2002 02:58p#J71,313 8 SBS2500E.DDE (  07/08/2002 03:37p"J421,888 8 SBS2500E.DLL  07/08/2002 03:37p#J57,344 8 SBS2500E.EXE  07/08/2002 04:05p#J38,989 8 SBS2500E.HLP t 07/08/2002 03:36pxx$J1,291 8 SBS2500E.REG ^ 10/18/2002 05:20p"J357,551 8 SBS2800E.DDE H 10/18/2002 05:42p   J2,854,912 8 SBS2800E.DLL 2 10/18/2002 05:34p"J184,320 8 SBS2800E.EXE  10/21/2002 11:24a"J128,196 8 SBS2800E.HLP x 10/18/2002 05:33pxx$J1,291 8 SBS2800E.REG b 07/08/2002 02:57p"J104,772 8 SBS2900E.DDE L 07/08/2002 03:33p"J765,952 8 SBS2900E.DLL 6 07/08/2002 03:29p#J77,824 8 SBS2900E.EXE   07/08/2002 04:06p#J56,296 8 SBS2900E.HLP   07/08/2002 03:28pxx$J1,291 8 SBS2900E.REG   10/21/2002 11:28a   J3,195,933 8 SDWIS.HLP !l Ѐ0 133File(s)37,906,716bytes  (# (# Ѐ