WPC "Agd1;Ҍ|!"(P^W1V(!aA&2*-vBt:i_iJoҠ36 b`f >8p?{׍)\)|W}RrNX  N/~"HC+ֶJ~yO?d,qOuЌZUcYsfܘNRVaozs@WzcQÿ *]3wS_ic< -*F`s /FP06,Cj2:$Hnjxi;r''>sF=4#!!,E j]mTlMR_XM}7U1G.Md5X\u(.hߧe&[*č]%ʷx_w54 --଼.|=߶lmþDABjm\ 0 %l 0dr#!P 0GMUN 0 0X 1XU @ 0M 1 0r 0c 0Ew 0E\ 0 mw@j% 1 1u, 1 0( M M 0 0n7!M!^ ! 0K! 0lc" 0<c" 0*h"M]# 0|a# 0#Mm$4q$ 0E$%% 04%^% 0k6 16 0E7 0d7 0E48N8 0E8 B9 0E9 1: 1};M< 1< 1<]= 0%= 0> 0x> 0<+? 1g? B?M @ 0@U30@AU >A 1'B 1B 15C 1C 1CD 1D 1QE 1E 1_F 1F 0RmG BG 1G 1cH 1H 1qI 1I 0J 1)KMK 01K 0=K 0"L 0>L 0(M 0M 0pN 0P 0aP 0+Q 0Q 09R 0R 02S 0S 0:T 0U 0_U 0 U 0kV 0iX B*0Z D3ZZ CZ D+Z 0Z 0\ 06] 0] 0:^ 0h^ 0F`_U6_U*_M`M `M`U @`MR`MV`MZ` 0^` 0J` 0N'aMuaMya 0}aMTbMXbM\b 1`bMb 1b 1rc 1c 1d 1e 1e 1f 1f 1#g 1g 11h 1h 0?i 1Ej 1j 1Sk 1k 1al 1l 1om 1m 1}n 1o 1o 1p 1p 1 q 1q 1.r 1r 1 0:8U<rfaɋÌEMaŎَM >$"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 DD EUD 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 POSTSM_FIX.SQLTMNMPAVG0UPDATE_RESULTS_AVG.SQLD_USERID_CODECDSSETUPUserID.MODIFY_VTYPE_VTAA.SQLTMNVTYPETMNVTAAIESWTR*UPDATE_TINLGENT.SQL.TINLGENT.COUNTRY_CODE6TINLGENT.ADDRESS_ZIP_CODE(UPDATE_TMNALRA.SQLTMNALRAPRECOMP.MDBEBSRPTS.MDBCCRBRIG.MDBDATAMIG.MDBDATAMIGW.MDBSDWISODD.MDB FANLIS_Number RDC MDPB MRDLFANLs GoTo GUP GWP WSFsCCRTBL.MDBMTS:MBS DBA_Scripts_NTEDIDATAEBSRPTS.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)(9 Z6Times New Roman Regular }    TRX3' LetterX3' Letter3' Letter3'T(`  Z(CG Times Regular 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%%  &'TABLE 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)),h  Z2CG Times (W1) RegularHeIPqeHe p  TRX3' LetterP$'3 Letter Landscape3' Letter'3 Letter LandscapeT:`c81AutoList25  X   2(4 4 <DL!2     5+ 4 <DL!5    TABLE A6Pw4Body 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<pZ$Avalon Regular TABLE A /(%%%%X'X%%  _d:XX'  SDC0002017JB5015  October25,2002#X'Xd:i#  //&%%%%X'X%%  _ProjectPlanPCNsuseletterextensionstodenotetheversion.Theoriginal  wouldbeSDC00020XXXXXXXXThefirstrevisionorupdatedversionwouldbeSDC00020XXXXXXXXAThesecondrevisionorupdatedversionwouldbeSDC00020XXXXXXXBetc.PleaseensurethatthecorrectPCNappearsinthecoverpagesaswellastheheaderinthemainbodyofthedocument.TABLE D   &' I!%%%%X'X%%  _L M%-3579`3LI      X'XXX'D *VA ddd Xdd Xdd XD ($D ($, ," d +  )V  )#X'XXX'#XsXXX'3UnitedStates d EnvironmentalProtectionAgency @V/!@V @33OfficeofGroundWaterandDrinkingWater0  0FT$T$ C9+@FT$FT$V ! C3JYXXs3 SoftwareReleaseNotesfor F SDWIS/STATERelease8.0.3CumulativeforWindowsNTandOracle <2  ^  !   < D  3#XsXY#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'XXXs#XsXXX'XXs 33AV )6 + dE6 + AOctober25,2002 #XsX`##X'XXXsA#X'XXX' SID+(  V@37553  V@  S3)'+( x _   3#X'XXX'Z#  ~.* D    1 !XX'  n SOFTWARERELEASENOTESFOR̀SDWIS/STATE#X'X ! 1 # 1 !XX'RELEASE8.0.3CUMULATIVE #X'X ! 1 #Ԁ 1 !XX'    FORWINDOWSNTANDORACLE #X'X ! 1i #    CONTRACTNO.68W99002   TASKORDERNO.002017     Preparedfor: ` UnitedStatesEnvironmentalProtectionAgencyOfficeofGroundWaterandDrinkingWaterDrinkingWaterProtectionDivisionX'XXX'1200PennsylvaniaAve.,NW#X'XXX' # B Washington,DC20460X'XXX'  4 TaskOrderProjectOfficer:EdwardCottrill#X'XXX' #     Preparedby: J&r  SystemsDevelopmentCenterScienceApplicationsInternationalCorporation6565ArlingtonBoulevardFallsChurch,VA22042  +,$%     8$!%%dXXd8 CONTENTS     RX'XXX'   R0     1.00(#(#INTRODUCTION#""J(#.@ @ (#(##1R݌   ЌX'XXX'  RX'XXX'   R0     2.00(#(#DESCRIPTIONOFSDWIS/STATERELEASE8.0.3CUMULATIVEFOR   WINDOWSNTANDORACLE#""J(#.$(#(##1R%݌ |  ЌX'XXX'  &/X'XXX'  &/S0  0` (#(#    2.1 ` DatabaseMaintenanceandSchemaMigrationScripts#""J(#.F` (#` (##1&/S݌ n  ЌX'XXX'  '  '0  0` (#(#0 ` (#` (# `   2.1.10 (# (#POSTSM_FIX.SQL#""J(#.&&' (# (##2'݌ X Ќ  '  '0  0` (#(#0 ` (#` (# `   2.1.2 MAP_DATAMIGRATION.SQLandMAP_MSACCESS.SQL#""J(#.C (# (##2'݌ Bj  Ќ  '  '0  0` (#(#0 ` (#` (# `   2.1.3 RESET_USER.SQL#""J(#.>>' (# (##2'݌ ,T  Ќ  '  '0  0` (#(#0 ` (#` (# `   2.1.40 (# (#MODIFY_VTYPE_VTAA.SQL#""J(#.. (# (##2'݌ >  Ќ  '  '0  0` (#(#0 ` (#` (# `   2.1.5 UPDATE_TINLGENT.SQL#""J(#., (# (##3'݌ (  Ќ  '  '0  0` (#(#0 ` (#` (# `   2.1.6 UPDATE_TMNALRA.SQL#""J(#., (# (##3'݌   Ќ  &/X'XXX'  &/0  0` (#(#    2.20` ` (#` (#SDWIS/STATEMSAccessDatabaseFiles#""J(#.  8` (#` (##3&/݌   ЌX'XXX'  '  '0  0` (#(#0 ` (#` (# `   2.2.10 (# (#NewMSAccess2000Databases#""J(#.**5 (# (##3'݌   Ќ  '  '0  0` (#(#0 ` (#` (# `   2.2.20 (# (#RevisionstoPreviouslyDeliveredMSAccess97Databases#""J(#.Q (# (##4'݌  Ќ  &/X'XXX'  &/0  0` (#(#    2.30` ` (#` (#DescriptionofResolutionsforSDWIS/STATERelease8.0.3Cumulativefor  WindowsNTandOracle#""J(#.XX)` (#` (##4&/A݌ | ЌX'XXX'  '  '0  0` (#(#0 ` (#` (# `   2.3.1 MigrationtoSDWIS/STATE#""J(#.1 (# (##4'݌ f Ќ  '  '0  0` (#(#0 ` (#` (# `   2.3.2 OnlineSDWIS/STATEComponents#""J(#.\\6 (# (##6'݌ Px Ќ  '  '0  0` (#(#0 ` (#` (# `   2.3.30 (# (#MigrationtoSDWIS/FED:Actions#`"`"I(#.  8 (# (##10'݌ :b Ќ  RX'XXX'   R 0     3.00(#(#ADDITIONALINFORMATION#`"`"I(#.%(#(##10R ݌ > ЌX'XXX'  &/X'XXX'  &/!0  0` (#(#    3.10` ` (#` (#Advisory:SampleUniquenessinOnlineSampling#`"`"I(#.C` (#` (##10&/!"݌ 0 ЌX'XXX'  &/X'XXX'  &/#0  0` (#(#    3.20` ` (#` (#Advisory:CDSSetupPostProcessingReport#`"`"I(#.$$?` (#` (##11&/#K#݌  ЌX'XXX'  &/X'XXX'  &/U$0  0` (#(#    3.30` ` (#` (#Advisory:SpecifyingDSNontheODBCDataAdministratorWindow#`"`"I(#. S` (#` (##11&/U$$݌  ЌX'XXX'  &/X'XXX'  &/%0  0` (#(#    3.40` ` (#` (#Advisory:WaterSystemFacilityMaintenanceandSellerTreatment&/%%݌` (#` (# ЌX'XXX'  &/X'XXX'  &/'0  0` (#(#    0` ` (#` (#Indicator   #`"`"I(#.8 8 ` (#` (##11&/'D'݌   ЌX'XXX'  &/X'XXX'  &/g(0  0` (#(#    3.50` ` (#` (#Advisory:DeterminingWaterSourceTypeforPurchasedWater#`"`"I(#.22P` (#` (##12&/g((݌ ! ЌX'XXX'  &/X'XXX'  &/)0  0` (#(#    3.6 ` Advisory:MigrationtoCCRWriter#`"`"I(#.&&6` (#` (##12&/) *݌ " ЌX'XXX'  &/X'XXX'  &/+0  0` (#(#    3.7 ` Advisory:SizeofMSAccessDatabaseWindow#`"`"I(#.@` (#` (##12&/+=+݌ n# ЌX'XXX'  &/X'XXX'  &/@,0  0` (#(#    3.80` ` (#` (#Advisory:InvalidSamplingPointWindow#`"`"I(#.<<<` (#` (##12&/@,z,݌ X$  ЌX'XXX'  &/X'XXX'  &/-0  0` (#(#    3.90` ` (#` (#Discrepancy:InstallationPackageandMigrationtoSDWIS/STATEProgram B%j! Group#`"`"I(#.f f ` (#` (##13&/--݌ ,&T" ЌX'XXX'  &/X'XXX'  &//0  0` (#(#    3.100` ` (#` (#Discrepancy:Release8.0ODDViolationTypePermittedValues#`"`"I(#.\\Q` (#` (##13&//;/݌ '> # ЌX'XXX'  &/X'XXX'  &/X00  0` (#(#    3.110` ` (#` (#Discrepancy:MigrationtoSDWIS/STATE:MBSsPNActivityModule#`"`"I(#. T` (#` (##14&/X00݌ ((!$ ЌX'XXX'  &/X'XXX'  &/10  0` (#(#    3.120` ` (#` (#Discrepancy:MigrationtoSDWIS/STATE:MBSsComplianceSchedule ("% Module#`"`"I(#. ` (#` (##14&/11݌ )"&  X'XXX'  RX'XXX'  *#'   R830     4.00(#(#INSTALLATIONINSTRUCTIONSANDFILELISTFORSDWIS/STATE   RELEASE8.0.3CUMULATIVEFORWINDOWSNTANDORACLE#`"`"I(#.A(#(##14R833݌  ЌX'XXX'  &/X'XXX'  &/40  0` (#(#    4.1 ` DatabaseMaintenanceandSchemaMigrationScripts#`"`"I(#.PPE` (#` (##15&/45݌  ЌX'XXX'  &/X'XXX'  &/"60  0` (#(#    4.2 ` SDWIS/STATEMSAccessDatabaseFiles#`"`"I(#.  8` (#` (##17&/"6\6݌   ЌX'XXX'  &/X'XXX'  &/W70  0` (#(#    4.3 ` ReplacementApplicationFiles#`"`"I(#.1` (#` (##20&/W77݌   ЌX'XXX'  '  '80  0` (#(#0 ` (#` (# `   4.3.1 InstallationInstructions#`"`"I(#...2 (# (##20'88݌ z  Ќ  '  '90  0` (#(#0 ` (#` (# `   4.3.2 FileList#`"`"I(#.ll" (# (##20'99݌ d  Ќ    <<TableofContentswillgeneratehere>> z   EXHIBITS  "J  M; Exhibit1.0 ` DBAScriptsforRelease8.0.3CumulativeforWindowsNTand& ` (#` (# 0  0` (#(#Oracle#`"`"I(#.z z ` (#` (##16    Exhibit2.0 ` MSAccess2000DatabasesforOracle#`"`"I(#.7` (#` (##18    Exhibit3.0 ` MSAccess97DatabasesforOracle #`"`"I(#.  6` (#` (##19      1.00  INTRODUCTION =(#(# TheHX'XXX'SafeDrinkingWaterInformationSystem(SDWIS)/STATERelease8.0.3Cumulative#X'XXHX'=#HX'XXX'Ԁfor  WindowsNTandOraclereleaseincludesfixestoproblemsnotedinSDWIS/STATERelease   8.0andalsoimplementssomenewrequirementsmadetothesoftwaresincethereleaseof#X'XXHX'{>#HX'XXX'SDWIS/STATERelease8.0forWindowsNTandOracle#X'XXHX'?#HX'XXX'Ԁand#X'XXHX'@#HX'XXX'ԀSDWIS/STATERelease8.0for r  WindowsNTandOraclePersonalEdition.#X'XXHX']@#HX'XXX' \  #X'XXHX'@#HX'XXX'#X'XXHX'QA#HX'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XXHX'A#HX'XXX'includesthenewrequirementsandsoftwarefixesin 0X #X'XXHX'B#HX'XXX'SDWIS/STATERelease8.0.1#X'XXHX'B#andSDWIS/STATERelease8.0.2aswellasfixesandnew B  requirementsimplementedsincethereleaseofthosetwopatches. ,  YoumayinstallHX'XXX'ԀSDWIS/STATERelease8.0.3Cumulative#X'XXHX'C#Ԁafteryourstate/regionhaseither   successfullyschemamigratedfromSDWIS/STATERelease7.0toSDWIS/STATERelease8.0;orsuccessfullycompletedanewstate/newregioninstallationofSDWIS/STATERelease8.0.HX'XXX'Thisdocumentincludesadescriptionofthe#X'XXHX'E#HX'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XXHX'sE#Ԁcontents j andinstructionsforfileinstallation.Foranswerstoquestionsyoumayhavethatarenotcoveredbythesereleasenotes,youmaycalltheSDWISUserSupportHotlineat703-292-6298orsendanemailto4 B O  5  sdwisstate@sdcmoses.com.6FOFЌ  7B G (P   2.00  HX'XXX'DESCRIPTIONOFSDWIS/STATERELEASE8.0.3CUMULATIVEFOR  WINDOWSNTANDORACLE GԀ#X'XXHX'G# X'XXX' (#(# ThissectioncontainsabriefdescriptionofwhatisincludedinSDWIS/STATERelease8.0.3  Cumulative.Thecontentsofthisreleaseincludefixesthathavebeenmadetoexisting  SDWIS/STATERelease8.0softwareaswellasnewrequirementsthathavebeenimplementedsincetheinitialreleaseofSDWIS/STATE8.0.#X'XX X'pH# X'XXX'#X'XX X'=J#  2.1  DatabaseMaintenanceandSchemaMigrationScripts J F#n  HX'XXX'#X'XXHX'J#HX'XXX'CorrectionshavebeenmadetosomeDBAscriptsandnewrequirementsimplemented,as "%J! discussedbelow.Forspecificinformationonwhetheryouneedtocopyoneofthesescriptsintoyourenvironment,aswellasinstructionsonhow/wheretodoso,seethematrixinExhibit1,Subsection4.1.#X'XXHX'=K# '!$  +$(   2.1.10  POSTSM_FIX.SQL L (#(# POSTSM_FIX.SQLshouldberunonlyonceperproductiondatabaseatyourlocation.Ifeither  ofthefollowingtwoconditionsapplytoyourRelease7.0productiondatabase,thefollowingrevisedscriptsshouldbeused: %3   %3:N2"3  0    YourSDWIS/STATERelease7.0dataschemacontainschemical,radionuclide,and/or \  leadandcopperScheduleGroups,andthereforemonitoringrequirementsthatreferenceanalytegroups.%3:NeN݌ (#(# Ќ   %3   %3O2"3  0    YouusedRelease7.0ComplianceDecisionSupport(CDS)Setup,andyourdatabase ,  containsmonitoringperiodaverage(TMNMPAVG)andcalculatedMaximumContaminantLevel(MCL)value(TMNCMCLV)records.%3OO݌ (#(# Ќ  NotethatyoushouldnotrunthisscriptonceyouhavebegunusingtheonlineResultsAverages   function,asitcallsscriptUPDATE_RESULTS_AVG.SQL,whichupdatesthevalueintheD_USERID_CODEfieldofallSDWIS/STATE8.0TMNMPAVGandTMNCMCLVtablesto   CDSSETUP.YourdatabasewillthenlosethemarkerthatindicatesthatCDSSetupshouldnotupdatethem. T|   2.1.2  MAP_DATAMIGRATION.SQLandMAP_MSACCESS.SQL RԀ  (P DatabasemaintenancefilesMAP_DATAMIGRATION.SQLandMAP_MSACCESS.SQLhavebeenmodifiedtofacilitateuseofastate/regionselectedUserIDandpassword.Theintroductorycommentsinsideeachscriptclarifythattheyarenotpartoftheschemamigrationscriptsandthateachmaybeusedanytimeafterschemamigrationhasbeenrun. HX'XXX'  2.1.3  RESET_USER.SQL TԀ #X'XXHX'T#    Atypographicalerrorincorrectlyreferencingtable TMGVIOSDinDBAMaintenancescriptRESET_USER.SQLhasbeencorrectedtoreference TMNVIOSD.  2.1.40  MODIFY_VTYPE_VTAA.SQL  VԀ0$X (#(#  HX'XXX'  HX'XXHX'  V  NewTMNVTYPE/TMNVTAArecords,changestoexistingTMNVTYPE/TMNVTAA  &4" records,anddeletionsfromthesetablestosupportrecentreportingguidanceforMicrobialDisinfectionByProducts(MDBP)ruleandInterimEnhancedSurfaceWaterTreatmentRule(IESWTR)areincludedinscript#X'XXHX'sV#MODIFY_VTYPE_VTAA.SQLHX'XXX'Ԁtohelpusersmeetfederal (!% reportingrequirementsforviolations.VV݌̌HX'XXHX'    +$( #X'XXHX'ZX#  2.1.5  UPDATE_TINLGENT.SQL [YԀ   HX'XXX'AscripttoupdateTINLGENT.COUNTRY_CODEtoUSwhereTINLGENT.ADDRESS_ZIP_CODEisvaluedisincluded.Thisaddressesaproblem#X'XXHX'Y#HX'XXX'MigrationtoSDWIS/FED:Inventory#X'XXHX'|Z#ԀhaswiththeA1andtheA3Form,whereifCountryCode   (C0140orC0314)isnotvalued,nostatecode(C0139orC0313)orzipcode(C0141orC0315)transactioniscreatedintheDTFfile.HX'XXX'MigrationtoSDWIS/FED:Inventory#X'XXHX'[#Ԁworks \  correctlyiftheCountryCodeisvalued.  2.1.6  UPDATE_TMNALRA.SQL g\ B  AscriptisincludedtocorrectthecontentsoftwofieldsinonerecordoftableTMNALRAinthestartupdatabaseZZV80.ThisscriptshouldbeonlyHX'XXX'Ԁappliedbystates/regionswhohavejust   installedZZV80withtheintentofusingSDWIS/STATE8.0astheirproductiondatabase.If   youhaveschemamigratedfromyourproductionSDWIS/STATE7.0database,youdonotneedtoapplythisscript.#X'XXHX'Y]#  2.20  SDWIS/STATEMSAccessDatabaseFiles ^Ԁ r(#(# CorrectionshavebeenmadetosomepreviouslydeliveredMSAccessdatabases,andnewrequirementsimplemented,asdiscussedbelow.Forspecificinformationonwhetheryouneedtocopyoneofthesedatabasesintoyourenvironment,aswellasinstructionsonhow/wheretodoso,seethematrixinExhibit2(forMSAccess2000versionsofthesedatabases)andinExhibit3(forMSAccess97versionsofthesedatabases).     2.2.10  NewMSAccess2000Databases `Ԁ (#(# HX'XXX'AtEPAsrequest,10MSAccessdatabasesthatweredeliveredwithRelease8.0usingMS  Access97werealsodeliveredsubsequenttoRelease8.0asMSAccess2000databases.#X'XXHX'ba# %3   %3jb2"3  0    PRECOMP.MDB.%3jbb݌l"(#(# Ќ   %3   %3*c2"3  0    RELATION.MDB.%3*cUc݌V#~(#(# Ќ   %3   %3c2"3  0    EBSRPTS.MDB.%3cd݌@$h (#(# Ќ   %3   %3d2"3  0    CDSRPTS.MDB.%3dd݌*%R!(#(# Ќ   %3   %3ke2"3  0    CCRBRIG.MDB.%3kee݌&<"(#(# Ќ   %3   %3+f2"3  0    SDWISCOM.MDB.%3+fVf݌&& #(#(# Ќ   %3   %3f2"3  0    DATAMIG.MDB.%3fg݌'!$(#(# Ќ   %3   %3g2"3  0    DATAMIGW.MDB.%3gg݌(!%(#(# Ќ   %3   %3mh2"3  0    SDWISEDI.MDB.%3mhh݌)"&(#(# Ќ   %3   %3.i2"3  0    SDWISODD.MDB.%3.iYi݌*#'(#(# Ќ   +$(   2.2.20  RevisionstoPreviouslyDeliveredMSAccess97Databases j(#(#  TwoMSAccess97databaseshavebeenmodifiedsinceRelease8.0.   2.2.2.1CDSReports(CDSRPTS.MDB) TwominorchangesweremadetotwoCDSReportqueries,whichinconcertwiththechangestothePostCDSReportsLogfunction,enabletheresultsofapreviouslyrunLeadandCopperTapMonitoringandReporting(M&R)ComplianceReporttobeviewedaccuratelywhenreexecutedfromthePostCDSReportsLog. HX'XXX'  #X'XXHX'Hl#HX'XXX' 2Z  #X'XXHX'l#8VXX'H8V8V#HX'XH8Vl##X'XXHX'm# 2.2.2.20  EnforcementReportsComplianceScheduleReport  (#(# HX'XXX'ThesearchfunctionontheComplianceScheduleReport,whichispartoftheEnforcement   Report,hasbeenclarified.(Thisfunctiondidnotworkasuserspreviouslyexpected).#X'XXHX'm#Ԁ     2.30  DescriptionofResolutionsforSDWIS/STATERelease8.0.3Cumulativefor | WindowsNTandOracle oԀ n(#(# ThefollowingitemsdescribeproblemsidentifiedsincethereleaseofSDWIS/STATE8.0andwhoseresolutionisincludedinSDWIS/STATERelease8.0.3CumulativeforWindowsNTand 4\ Oracle. F   2.3.1  MigrationtoSDWIS/STATE pԀ   IssuesaddressedwithintheMigrationtoSDWIS/STATEcomponentaredescribedin  Subsections2.3.1.1through2.3.1.3. 2.3.1.1MigrationtoSDWIS/STATE:MDBPSummary    Ѐ"0  Undersomescenarios,thesoftwarewasincorrectlycarryingforwardareferenced h" SamplingPointfromajustprocessedstructuresettextfilerecordandapplyingittothenextMDBPSummaryinthestagingtablewhenthatrecorddidnotreferenceasamplingpoint.ThisproblemwasfixedinRelease8.0.2. (#(# "0  Undersomescenarios,valuesforMDBPSummaryfieldsPERCENT_SAMPLES_ &" # 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't#ԀViolationmodulethat  affectedthe duplicatebydatacheckaswellasthe duplicatebynumbercheckwasfixedinRelease8.0.2. (#(# "0  AproblemthatmanifesteditselfinthescenariowheretheHX'XXX'MigrationtoSDWIS/STATE: \  Monitoring#X'XXHX'dv#ԀNonTotalColiformRule(TCR)Schedulemodulecreatedasample F n schedulegroupwithanopenEffectiveEndDateandwasthenunabletosuccessfullycreateSamplingPointSubscheduleswhenthetextfiledataindicatedthattheyshouldbecreated,hasbeenaddressed.Asecondproblemthatoccurredwhen,withinthesametextfile,thereexistedtwodifferentscheduleswhoseWaterSystemsweredifferentbutwhoseWaterSystemFacility(WSF)StateAsgndIDhappenedtobethesame,wasalsofixed.Inthiscase,thewatersystemfromthesecondschedulewasnotbeingpickedup;thisproblemwasfixedinRelease8.0.2. (#(# "0  TheHX'XXX'MigrationtoSDWIS/STATE:Monitoring#X'XXHX'y#Ԁ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_NumbertodistinguishthecorrectTMNVTYPErecordwhenthissecondstepwasneeded.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  TheViolationstructuresetandsoftwaremoduleincorrectlyindicatedthatforviolations %" ofviolationtype71and72thenewCompliancePeriodBegindatewouldbeusedforaparticulardateedit,wheninfact,thedateeditshouldhaveusedtheViolationPeriodBegindate.ThiserrorhasbeencorrectedinRelease8.0.3.AdvisoryNote:The (!% SDWISCOM.MDBerrormessagehasnotbeenchangedtoreferenceViolationPeriodBeginDateinsteadofCompliancePeriodBeginDate.Whenyouaremigratingintype71and72violationsandoneofthemisflaggedorrejectedbecauseofanissuewith p+$( CompliancePeriodBegin/EndDate,theproblemisactuallywithViolationPeriodBegin/EndDate.(#(#  2.3.1.3MigrationtoSDWIS/STATE:Sampling     X'XXX'TheMigrationtoSDWIS/STATE:Samplingcomponentdeliveredwith#X'XX X'b#SDWIS/STATERelease r  8.0forWindowsNTandOracle X'XXX'ԀinserteddatainSDWISCOM.MDBinsteadof \  SDWISEDI.MDBasrequired.ThisproblemwasfixedinRelease8.0.1.#X'XX X'5# F n   2.3.2  OnlineSDWIS/STATEComponents Ԁ  B  IssuesaddressedwithinonlineSDWIS/STATEcomponentsaredescribedinSubsections2.3.2.1through2.3.2.12. 2.3.2.1OnlineSampling"ResultsAverageMaintenance    "0  Theerrormessage PrecursorRemovalRatioCannotbeBlankwaserroneously  displayedwhenyouattemptedtosaveaResultsAveragesrecordwithoutavalueintheoptionalPrecursorRemovalRatiofield,availableinboththeMPAandRAAgroupboxes.Youhadtoenter 0"inthefieldtosavetherecord.Thesoftwarenolongerrequiresyoutoenteravalueintheseoptionalfields.ThiswasfixedinRelease8.0.2. (#(# "0  ThesoftwarehasbeenfixedsothatitvaluesMonitoringPeriodAverage.DUserid  4 CodeandMCLValue.DUseridCodefromfieldUSERIDinTINUSER,asspecifiedintheRelease8.0DesignDocument.ThisproblemwasfixedinRelease8.0.2. (#(#  2.3.2.2OnlineSampling"SampleMaintenance   "0  OntheTCRSampleMaintenancebyWaterSystemwindow,previouslyyouwerenot   abletosavechangestoFieldResults.ThiswasfixedinRelease8.0.2. (#(# "0  OntheFieldResultsdialogboxwhenitwasdisplayedfromeithertheGeneral N#v MicrobiologicalSamplebyWaterSystemwindowortheGeneralMicrobiologicalSamplebyLaboratorywindow,ifyouenteredavalueintheFlowRatefield,itwasnotbeingsaved.ThisproblemwasfixedinRelease8.0.2. (#(# "0  OntheChemicalandRadionuclideResultsMaintenancewindows,aproblemwherethe '!$ softwarehadalwaysautomaticallydisplayedtheanalytesRegulatoryMinimumDetectionLimit(RMDL)value,butwasnolongerdoingso,hasbeenfixed.ThesoftwarenowdisplaystheanalytesRMDLvalueasitshould.ThisproblemwasfixedinRelease8.0.2.+$((#(# Ї %3   %3d2"3  0    OnanyoftheSampleMaintenancewindows(byLaborbyWaterSystem),attemptsto  createanewsamplingpointbyenteringavalueinonlytheSampleLocationfield(withnovalueinSamplingPoint),thisactioncorrectlytriggeredtheInvalidSamplingPointdialogbox.YoucouldthenspecifyActivityStatusandDateandcreateasamplingpoint;butwhenyouexitedthedialogbox,thesoftwaredidnotsavethesamplelocationandactivitydateinformation.ThisproblemhasbeenfixedinRelease8.0.3.%3d݌ (#(# Ќ  HX'XXX'2.3.2.3OnlineSampling"MDBPSummaryMaintenance #X'XXHX'$# > f "0  WhenusingtheDistributionResidualDisinfectantConcentration(RDC)Changeor B  AddwindowfromeithertheSamplingcomponents MDBPSummary/SWTR (Surface ,  WaterTreatmentRule)windowflowortheSamplingcomponents Sample   Summaries/TCRSummary/SWTRRDC buttonwindowflow,thecontrollevelthat   wasdisplayedforthestateresidualwasnotcorrect.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  IftherewasmorethanonetreatmentplantordistributionsystemfortheMDPB  Summary'sreferencedWSF,theSWTRandMaximumResidualDisinfectantLevel(MRDL)windowflowdidnotallowtheentryofMDBPsummaries,eveniftheappropriateFANLswereinplace.ThisproblemhasbeenfixedinRelease8.0.3. (#(#  2.3.2.4OnlineSampling"TCRSummaryMaintenance  *R WhenthesoftwareautomaticallyassociatedanewTCRSummarytoadistributionsystem(DS)(whichoccurredwhentherewasonlyoneDS)anduserssubsequentlyenteredtheMonitoringPeriodforthesummary,thesoftwareshould,atthatpoint,haveenabledthe SWTRRDC and   CL2RDC buttons.However,usershadtoselecttheWSFStateAsgnID GoTo buttonand  re-selectthedistributionsystemtoenablethesebuttons.ThisproblemhasbeenfixedinRelease8.0.3,andthe SWTRRDC and CL2RDC buttonsarenowenabledatthecorrect   point. 2.3.2.5OnlineEnforcement"EnforcementActionSearch n#  AproblemwithdefaultdatesnotbeingproperlydisplayedintheEnforcementActionSearchdialogboxhasbeencorrectedinRelease8.0.3.Previously,ifyoudidnotenteranydatecriteriaintheEnforcementActionSearchdialogbox,itssearchlogicfunctionedasinpreviousreleases;thatis,itsearchedforEnforcementActionswhoseStatusDatewas6monthspriortotoday'sdate.However,these defaultdatesdidnotappearonthewindow,eventhoughthesoftwarewasusingthem.ThedatedefaultsthatexistedwithRelease7.0andpriornowappearonthewindow.(StartDatedefaultstothedatethatis6monthspriortotodaysdate.EndDatedefaultstotodaysdate.) +$( Ї 2.3.2.6OnlineEnforcement"PNScheduleMaintenanceList   AproblemwhereopenPublicNotification(PN)SchedulesdidnotfirstdisplayonthePNScheduleMaintenanceListhasbeencorrectedinRelease8.0.3.ThePNScheduleMaintenanceListnowcorrectlydisplaysallopenPNschedules,thatmeettheuserspecifiedcriteriawhenthelistisfirstdisplayed. 2.3.2.7OnlineMonitoringandNoncompliance"ValidatePositiveTCRResults  F n TheproblemwherethesoftwarewasincorrectlycreatingapreliminaryacuteviolationwhenitencounteredonlyonepositiveTCRandfecalcoliformsample,butnopositiverepeatsample,hasbeenfixed.ThesoftwarenowcorrectlysearchesforapositiverepeatTCRsamplealongwithapositiveroutineTCRandeitherfecalcoliformorHX'XXX'E.coli#X'XXHX's#Ԁsamplepriortocreatingthe   preliminaryacuteviolation.ThisproblemwasfixedinRelease8.0.2. 2.3.2.8OnlineMonitoringandNoncompliance"NonTCRSchedule     X'XXX'AchangeonthenonTCRSampleSchedulewindowmadeto#X'XX X'#SDWIS/STATERelease8.0for z WindowsNTandOracle X'XXX'Ԁtoaddressaminorfunctionalbugresultedinchangesmadeinthe d secondgroupboxintheNonTCRSampleSchedulewindownotbeingcommitted.ThisproblemwasfixedinRelease8.0.1.#X'XX X'Y# 8`  2.3.2.9OnlineMonitoringandNoncompliance"Violations   4 ThismodulehasbeenredeliveredsothatitusesthefixedViolation duplicatebydatacheckoriginallyfixedfortheMigrationtoSDWIS/STATEViolationmodule.Thiswasfixedin  Release8.0.2. 2.3.2.10OnlineMonitoringandNoncompliance"MigrateCandidateCDSViolations B  Ӎ2.3.5..OnlineMonitoringandNoncompliance"MigrateCandidateCDSViolationsC     "0  ThismodulehasbeenredeliveredsothatitusesthefixedViolation duplicatebydata l" checkoriginallyfixedfortheMigrationtoSDWIS/STATEViolationmodule.This V#~ problemwasfixedinRelease8.0.2. (#(# "0  MigrateCDSCandidateViolationswaspreviouslynotcarryingtheWSFreferencedby &<" thecandidateviolationintotheactualSDWIS/STATEviolation.Thisproblemhasbeenfixed,andareferencedWSFinthecandidateviolationisnowcorrectlycarriedovertotheactualviolation.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  AproblemwheresomePNcandidateviolationswerenotbeingcorrectlymigratedinto *#' theTMNVIOLtablehasbeencorrected.Thiswasactuallyaproblemwiththewaythe +$( PNComplianceReportclearedoutpreviouslycreatedviolationsfordifferentagencies.ThisproblemhasbeenfixedinRelease8.0.3. (#(#  2.3.2.11OnlineMonitoringandNoncompliance"PostCDSReportsLog    "0  CandidateType43violationsthatdisplayedwhenyourantheCDSSWTRCompliance r  ReportwerenotshowingupwhenyoulaterrequestedthedatafromthesamereportusingthePostCDSReportsLog.ThisproblemwasfixedinRelease8.0.2. (#(# "0  AproblemwiththePostCDSReportsLogwasfixedinRelease8.0.2,enablingthe B  displayofallinformationforapreviouslyrunLeadandCopperTapM&RComplianceReport. (#(#  2.3.2.12CDSSetup    "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.ThisproblemwasfixedinRelease8.0.2. (#(# "0  AproblemthathadgoneundiscoveredsincethedeliveryofSDWIS/STATERelease  7.0where,underaparticularscenario,candidateMCLviolationswerebeingcreated/deletedattheWaterSystemlevelratherthanattheWSFlevel,hasbeencorrected.Theyarenowconsistentlyclearedout/createdattheWSFlevel.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  TheCDSSetupProcessingReportfortheCalculateMCLValueprocesswas ($P  incorrectlyprovidinguserstheinternalsystemnumbersofuniqueidentifiers(suchasWaterSystemNo.,WSFStateAsgnID,etc.)ratherthantheactualWaterSystemNo.,AnalyteCode,etc.ThismadetheinformationforthisCDSSetupprocess & # unnecessarilydifficulttoprocess.ThisproblemhasbeencorrectedinRelease8.0.3,andtheinformationforthisCDSSetupprocessisreportedintheCDSSetupProcessing (!% ReportinthesamewayasitisforallotherCDSSetupprocesses.)"&(#(#  x+$(   2.3.30  MigrationtoSDWIS/FED:Actions  (#(# 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'#HX'XXX'MigrationtoSDWIS/FED:Actions#X'XXHX'$#Ԁhasbeenfixed 0X togenerateboththeE1formandtheY5000whentheenforcementactionislinkedtobothaviolationthatreferencesastate-ownedviolationtype(notreportabletoSDWIS/FED)ANDaviolationthatreferencesafederallyownedviolationtype(thatisreportedtoSDWIS/FED).ThishasbeenfixedinRelease8.0.3.  3.00  ADDITIONALINFORMATION  (#(# NotetheadvisoriesanddiscrepancylistedinSubsections3.1through3.12.  3.10  Advisory:SampleUniquenessinOnlineSampling  Fn(#(# InresponsetoarecentUserSupportinquiry,itwasnotedthatsampleuniquenesscriteriaforasampleenteredusingoneoftheonlineSampleMaintenancewindowsisnotdocumentedineithertheUsersGuideoronlineHelpforthosewindows.SampleuniquenesscriteriafortheonlinesamplingwindowshasnotchangedsincetheSamplingcomponentwasoriginally  introducedin1995.ThecriteriaforenteringasamplewhenusingonlineSamplingremains:  IfvaluingLabSampleNo.:0  WaterSystemplusLabplusLabSampleNo.plusCollectionDateplusSamplingPoint. (#(# IfleavingLabSampleNo.blank:0  WaterSystemplusLabplusCollectionDateplusSamplingPointandifsupplied,CollectionTime. (#(# ThesecriteriaaredifferentfromthosecriteriaspecifiedforSamplingviaEDI/Migrationto '!$ SDWIS/STATE:Sampling,whicharestricter.Theabovecriteriawerespecifiedbyuserswho (!% attendedthetwoSamplingJADsinNovember1994andFebruary1995.Atthattime,there )"& wasanexplicitrequirementtobeabletocreateasamplewithoutusingaLabSampleNo.orStateSampleNo.TheuniquenesscriteriadescribedaboveappliedtoallSDWIS/STATE +$( samplesuntilSDWIS/STATERelease7.0.WithSDWIS/STATERelease7.0,sampleuniquenesscriteriaforSamplingviaEDI/MigrationtoSDWIS/STATE:Samplingwas  tightened,asdescribedinAppendixAoftheSystemAdministrationGuideandAppendixEof  theUsersGuide.  3.20  Advisory:CDSSetupPostProcessingReport  j (#(# WhenCDSSetupencountersaFinishedTOCSchedulepackagedwithasingleRaw F n Schedule/ScheduleGroupforTOCorAlkalinity,thefollowingmessagemayappearinthePostCDSSetupProcessingReport: CannotcalculateaprecursorachievedremovalratiobecausethereisnotaRawAlkalinityScheduleassociatedwiththeFinishedTOCschedule.ThismessageappearswhennoprecursorachievedremovalratiocanbecalculatedforaSampleScheduleMonitoringPeriodAssignment(SSMPA)ApplicablePeriodBeginandEndDateRangeassociatedtotheFinishedTOCSchedule.Thismessagemayalsoappearasaduplicateadvisorymessageinthereport.Inreality,however,itisnotaduplicatemessage;itappearsthiswaybecause,whiletheinformationtoidentifytheScheduleissupplied,themonitoringperiodandSSMPAApplicablePeriodBeginandEndDateRangeisnotspecified.Eachtimethemessageappearsasaduplicate,itappliestoasecond,third,fourth,etc.,MonitoringPeriod(SSMPA)ApplicablePeriodRange(whichisnotsupplied).  3.30  Advisory:SpecifyingDSNontheODBCDataAdministratorWindow p (P(#(# IntheRelease8.0InstallationGuide,inthechapterthatcoversinstallingSDWIS/STATE , application/clientsoftwarefiles,Phase6ODBCAdministration,notethataftertheODBCDataAdministratorwindowappears,youmaywishtoselecttheSystemDSNtabratherthantheUserDSNtab.TheGuidedoesnotspecifywhichtabtouseinthedocumentation(eitherUserDSNorSystemDSN)becausethisisgenerallyunderstoodtobeauserpreference.UserDSNwouldmeanthatsomeoneelseloggingintoyourmachinewouldneedtocreatetheirowndatasource.Forthisreason,youmaywanttospecifySystemDSNsothatanyoneloggingintotheworkstationcanusethedatasource.IfyoudorecreatetheOracledatasourceunderSystemDSN,youshouldremoveitfromtheUserDSN.  3.40  Advisory:WaterSystemFacilityMaintenanceandSellerTreatmentIndicator '($P (#(#  TheEnvironmentalProtectionAgency(EPA)requiresthatprimacyagenciesnotonlyindicatewhetherornotthesellertreatsthewater,butalsowhetherornotthatwaterisfiltered.OntheexistingWaterSystemFacilityMaintenancewindow,theSellerTreatmentIndicatorfieldhasbeenmodifiedtohaveanewpermittedvalueofF"Treatedbyseller"includingfiltration.IfthevalueinthisfieldforagivenfacilityneedstobechangedtoF,updateitusingtheonlinesoftwareorsomeothertool.NotethatthisinformationisreportedtoSDWIS/FED. +$(   3.50  Advisory:DeterminingWaterSourceTypeforPurchasedWater  (#(#  EPAregulationsstatethatindeterminingthesourcetypeforconsecutiveconnections,thebuyerssourcetypemustfollowthesellerstype.Forexample,iftheselleris groundwaterundertheinfluenceofsurfacewater(GUI),thenthebuyer'sprimarysourcebecomes purchasedgroundwaterundertheinfluenceofsurfacewater(GUP)not PurchasedGroundwater(GWP).However,SDWIS/STATEdoesnotlookattheprimarysourcetypeofthesellerwatersystemwhendeterminingtheprimarysourcetypeofabuyer;itlooksatinformationenteredastheWaterTypefortheConsecutiveConnection(CC)forthebuyer.AusercanenterGroundwaterastheWaterTypeforaCC,eveniftheCCislinkedtoasellerthatisaGUI.Toverifysourcetypesforpurchasedwater,checktheWSFsoftypeCC.NotethatthisinformationisreportedtoSDWIS/FED.  3.6  Advisory:MigrationtoCCRWriter      WhenusingMigrationtoCCRWriter(CCRBRIG.MDB),thiscomponentworkswithEPAs   productCCRWriterv.1.5,whichisanMSAccess97basedfileandthereforecannotbeinstalledusingMSAccess2000.Tocontinueusingthisdatabase,youneedtocreateafolderC:\CCRWriterandthenfromtheCCRWriterinstallationdisk,copyfileCCRTBL.MDBintothisfolder.WhenyouopenthisfileusingMSAccess2000,youwillbeaskedtoconvertit.Whenasked,youwillneedtorenameitwithadifferentnameinordertocontinueusingit.  3.7  Advisory:SizeofMSAccessDatabaseWindow   4  Thesizeofthedatabasewindow,whenlaunchedfromanapplicationfile(e.g.,EBSReportsorMigrationtoSDWIS/STATE:MDBPSummaryImportTexttoStagingTable),maydifferfrom  oneusagetothenext.Youmayneedtoresizethedatabasewindowthatislaunchedbeforeusingit.  3.80  Advisory:InvalidSamplingPointWindow P z!(#(# InattemptingtocreateanewsamplingpointbyenteringavalueinfieldSampleLocation(andnotfieldSamplingPoint),ifyouusethemousetomovetothenextentryfieldonthewindow(thefieldvarieswithsampletype),theInvalidSamplingPointdialogboxopensbehindthecurrent,SampleMaintenancewindow.TobringtheInvalidSamplingPointdialogboxtothefront,clickonthebuttonforInvalidSamplingPointwindowinthetoolbar.Youcanthenentertheactivitystatus/dateinformation.  +$(   3.90  Discrepancy:InstallationPackageandMigrationtoSDWIS/STATEProgram  Group  (#(#  TheinstallationpackagesforSDWIS/STATERelease8.0forWindowsNTandOracleaswell   astheoneforSDWIS/STATERelease8.0forWindowsNTandOraclePersonalEditionhave   eachbeenfoundtocontainaminorbug.Ifyouselect NowhenyouareaskedwhetherornotyouwishtoinstalltheMigrationtoSDWIS/STATEProgramGroup,theinstallation d  packageincorrectlycreatestheMigrationtoSDWIS/STATEProgramGroup.Ifyoudonot N v wishtohaveitinstalled,youwillneedtomanuallyremoveitfromthedesktop.  3.100  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 *R SDWIS/FEDforanyviolationusingthisViolationType. ` (#` (# 0  0` (#(#VP"TheViolationPeriodBeginDateshouldbereportedtoSDWIS/FEDfor  anyviolationusingthisViolationType. ` (#` (# 0  0` (#(#RA"RunningAnnualAveragePeriod.` (#` (# "0  ReportNumberofMissingSamplestoSDWIS/FED?z!(#(# L %-3579eh`M%-3579L0  0` (#(#Y/Yes"MigrationtoSDWIS/FEDshouldcreateatransactionthatreportsthe N#v numberofmissingsampleswiththeviolation(aspartoftheD1record). ` (#` (#   0  0` (#(#N/No"MigrationtoSDWIS/FEDshouldnotcreateatransactionthatreportsthe  &4" numberofmissingsampleswiththeviolation(aspartoftheD1record). ` (#` (# 0   (#(# 0  0` (#(#Spaces"Fielddoesnotapplytostateownedviolationtypes;so,shouldnotbe (!% valuedinmostcases). ` (#` (# L %-3579Y`h%-3579L"0  ReportNumberofExceedencestoSDWIS/FED?+$((#(# Ї0  0` (#(#Y/Yes"MigrationtoSDWIS/FEDshouldcreateatransactionthatreportsthe  numberofexceedenceswiththeviolation(aspartoftheD1record). ` (#` (# 0  0` (#(#N/No"MigrationtoSDWIS/FEDshouldnotcreateatransactionthatreportsthe   numberofexceedenceswiththeviolation(aspartoftheD1record). ` (#` (# 0  0` (#(#Spaces"Fielddoesnotapplytostateownedviolationtypes;so,shouldnotbe T | valuedinmostcases. ` (#` (# "0  FedReportableContaminantCode"TellsSDWIS/STATEsoftwarewhethertheanalyte :  coderecordedwiththeviolationoradifferentcode(theonespecifiedinthisfield)shouldbereportedtoSDWIS/FED. (#(# ThisinformationisavailablethroughRELATION.MDB,theonlineSystemAdministration   component,andtheViolationfunctioninonlineMonitoringandNoncompliance.     3.110  Discrepancy:MigrationtoSDWIS/STATE:MBSsPNActivityModule  x(#(# TheMigrationtoSDWIS/_STATE:MBS_PNActivitymodulecanonlymigrate100PNactivity T| recordsatatime.Whileitisnotanticipatedthatastate/regionwouldnormallybemigratinginlargenumbersofPNactivityrecords,ifyoudoneedtomigrateinmorethan100PNactivityrecords,youwillneedtocreatetextfilesingroupsof100.  3.120  Discrepancy:MigrationtoSDWIS/STATE:MBSsComplianceScheduleModule < (#(# TheMigrationtoSDWIS/_STATE:MBS_ComplianceSchedulemodulecanonlymigrate100  complianceschedulerecordsatatime.Youwillneedtocreateseveraltextfilesandmigratetheminseparatelyifthenumberofcomplianceschedulerecordstobemigratedexceeds100.  4.00  INSTALLATIONINSTRUCTIONSANDFILELISTFORSDWIS/STATE T"| RELEASE8.0.3CUMULATIVEFORWINDOWSNTANDORACLE $ F#n(#(# Asexplainedinthissection,SDWIS/STATERelease8.0.3CumulativeforWindowsNTand "%J! Oracleisacombinationofautomaticallyinstalledfilesandfilesthatyouwillneedtocopy  &4" fromtheinstallationpackage,basedontheneedofyourlocationsoperatingenvironment.Wheremanualcopyoffilesisnecessary(inSubsections4.1and4.2),detaileddecisionmatrixesaresuppliedtoassistyouindecidingwhetherornotyoumayneedtocopyaparticularfile. +$( "0  Y"meansYes,youshouldinstallit.(#(# "0  N"meansNo,youdonotneedtoinstallitbecauseyoualreadyhaveoritdoesnot  applytoyourlocation. (#(# Forautomaticallyinstalledfiles,seeinstructionsinSubsection4.3.FromEPAsSDWIS/STATEwebsite,downloadfile8.0.3_nt.zip.Using_WinZip_,extracttoafolderyouname/create,suchas_EXTRACT_803_ SQL  NT ._ԀWhenyouopenthisfolder,youwillseethefollowingfoldersandfiles:8VXX'J\)8VAccess_2000_MDBs?+ 4 <DL!X?Access_97_MDBsDBA_Scripts_NTSdwis80Appl803_Files.LSTAppl803_NT.INFInstall_Appl803NT.EXE#X'X8V,##X'XXJXZ;#  4.1  DatabaseMaintenanceandSchemaMigrationScripts Ԁ  Lt ThematrixinExhibit1listsallthedatabasescriptsdeliveredwithHX'XXX'SDWIS/STATERelease (P 8.0.3Cumulative#X'XXHX'#ԀHX'XXX'WindowsNTandOracle.Youwillneedtomanuallycopythescriptslisted : inthismatrix.#X'XXHX',#ԀUsethedecisioncolumnsinthematrixtohelpyoudecideifyouneedtocopya $ script.Thelastcolumnofthematrixspecifiesthefolderintowhichyoushouldcopyagivenscript.HX'XXX'Toruneachscript,loginastheDBAuser(e.g.,SYSTEM)andrunitinSQL*Plus.#X'XXHX'#HX'XXX'  Notethatifyouhaveschemamigratedfromyour7.0toyournew8.0SDWIS/STATEdatabasebuthavenotyetrunscript #X'XXHX'G#HX'XXX' POSTSM_FIX.SQL#X'XXHX'#HX'XXX',inordertorunit,bothyour8.0data b! schemaand7.0dataschemamustbepresentandavailableinyourOracledatabaseinstance,sincethisscriptreadstablesinyour7.0schemaandupdatestablesinthe8.0schema.#X'XXHX'j# 6#^ ToaccessandruntheLANbasedOraclescripts,openfolderDBA_Scripts_NT.   %2! XZXXX' o @TRP$'3 Letter LandscapeX3' Letter'3 Letter Landscape3'T*xVdA d " d " V..x, dd ,dd ,dd ,dd ,dd ,dd ,dd , dd +  *  *  #X'XXXZ# EXHIBITS8VXX'Exhibit1.DBAScriptsforRelease8.0.3CumulativeforWindowsNTandOracle#X'X8V#XX' "EXHIBITSl" >4)Hd    >:Name ' 'Release ' 'FileDate ' 'Size ' 'Haveapplied:  NoPatches? 'V r 'Haveapplied:  Patch8.0.1? 'V r  'Haveapplied:   Patches8.0.1&8.0.2? '   'CopytoFolder: "  " * POSTSM_FIX.SQL Thisscript : V shouldberunONETIMEOnlyperProductionDatabase! *  FF *8.0.1 * : V *05/22/20024:32P MC  B@15492B@M15,492 I?=: V B@15492 B@ IY"SchemaMigrated8.0User  ~  N"SchemaMigrated8.0User  ~  N"SchemaMigrated8.0User  ~  SDWIS_MIGRATE70TO80 * : V *  P l   P l   P l   P l N"New8.0Startup  Vr  N"New8.0Startup  Vr" N"New8.0Startup  Vr$   P l$ MAP_DATAMIGRATION.SQL  % 8.0.2  & 07/12/200209:25A 7- .J ( <@8312<@78,312 7-+) <@8312 <@ 7Y  * Y  + N  , SDWIS_MIGRATE70TO80\DBA_SCRIPTS  .J . MAP_MSACCESS.SQL d / 8.0.2  d 0 07/12/200209:29A 8. " 2 J@28968J@828,968 8.,d 3 J@28968 J@ 8Y  d 4 Y  d 5 N  d 6 SDWIS_MIGRATE70TO80\DBA_SCRIPTS  " 8 RESET_USER.SQL <X 9 8.0.2  <X : 06/20/200204:53P 8.  < @20246@820,246 8.,<X = @20246 @ 8Y  <X > Y  <X ? N  <X @ SDWIS_MIGRATE70TO80\DBA_SCRIPTS   B MODIFY_VTYPE_VTAA.SQL  0C 8.0.3  0D 10/21/200204:15p 8. F @13669@813,669 8.,0G @13669 @ 8Y  0H Y  0I Y  0J SDWIS_MIGRATE70TO80  0K UPDATE_TINLGENT.SQL  L 8.0.3  M 10/21/200204:13p 7- O @1727@71,727 7-+P @1727 @ 7Y  Q Y  R Y  S SDWIS_MIGRATE70TO80  T UPDATE_TMNALRA.SQL󀄀 This U scriptisforNEWStatesusingZZV80only! * 0WFF *8.0.3 * X *10/22/200211:34A MCfZ *@11860*@M1,1860 I?=[ *@11860 *@ IN"SchemaMigrated8.0User#X'X#XX'  $^ N"SchemaMigrated8.0User#X'X #XX'  $a N"SchemaMigrated8.0User#X'X}#XX'  $d SDWIS_MIGRATE70TO80 * e *  e   e   e   e Y"New8.0Startup  g Y"New8.0Startup  i Y"New8.0Startup  k k  #X'X# * Bothyour8.0dataschemaand7.0dataschemamustbepresentinyourOracledatabaseinstance,asthisscriptreadstablesin l your7.0schemaandupdatestablesinthe8.0schema.XZXXX' m   o      TRX3' LetterP$'3 Letter Landscape3' Letter'3 Letter LandscapeT   #X'XXXZa #  4.2  SDWIS/STATEMSAccessDatabaseFiles  Ԁ   Exhibit2andExhibit3listalltheMSAccessdatabasefilesdeliveredwithSDWIS/STATE  Release8.0.3CumulativeforWindowsNTandOracle.Youwillneedtomanuallycopythe   MSAccessdatabaseslistedinthissection.Usethedecisioncolumnsinthematrixestohelpyoudecideifyouneedtocopyoneormoreofthedatabasefilessupplied;thelastcolumnofthematrixspecifiesintowhichfolderyoushouldcopythedatabase.Exhibit2listsallthenewMSAccess2000versiondatabasefilesthathavebeendeliveredsubsequenttoRelease8.0.Toaccessthesedatabases,openfolderAccess_2000_MDBs.Exhibit3listsalltheMSAccess97versiondatabasefilesthathavebeenmodifiedandredeliveredsubsequenttoRelease8.0.Toaccessthesedatabases,openfolderAccess_97_MDBs.    @   TRX3' LetterX3' Letter3' Letter3' LetterT   e  TRP$'3 Letter LandscapeX3' Letter'3 Letter Landscape3' LetterT5XZXXX'z5*Vd d dd  dd dd dd dd dd dd  dd V..,fdd ,*dd ,dd ,dd ,dd ,\dd ,dd ,dd ,fdd ,*dd ,dd ,dd ,dd ,\dd ,dd ,dd ,fdd ,*dd ,dd ,dd ,dd ,\dd ,dd ,dd ,fdd ,*dd ,dd ,dd ,dd ,\dd ,dd ,dd ,fdd ,*dd ,dd ,dd ,dd ,\dd ,dd ,dd +  %  %  #X'XXXZ# EXHIBITSExhibit2.MSAccess2000DatabasesforOracle "EXHIBITS"Ԁ 9/$d  98VXX'cName ' 'Release  Version ']  'Date/TimeGroup ' 'Size ' 'Have  applied:NoPatches? '/   'Have   applied:Patch8.0.1? '/   'Haveapplied:   Patches8.0.2&8.0.1? '/  'CopytoFolder:#X'X8VA#   8VXX'PRECOMP.MDB    8.0.1    #X'X8V#8VXX'05/28/2002@04:40P#X'X8V&#8VXX' 9/    ,A921600 ,A9921,600 9/-   ,A921600  ,A 9Y    N    N    #X'X8Vz#8VXX'C:\SDWIS\DATA#X'X8Vw#8VXX'    #X'X8V# 8VXX'RELATION.MDB#X'X8V&#&%XX'   \ 8.0.1   \ #X'X%&w#8VXX'05/21/2002@02:11P#X'X8V#&%XX' :0  \ BA2457600BA:2,457,600 :0. \ BA2457600 BA :Y   \ N   \ N   \ #X'X%&<#8VXX'C:\SDWIS\MSA_VIEW#X'X8V> #&%XX'   \   #X'X%& #8VXX'CCRBRIG.MDB#X'X8V #&%XX' i! 8.0.1  i" #X'X%&D!#8VXX'05/21/2002@02:00P#X'X8V!#&%XX' :0 i#  ?A2039808 ?A:2,039,808 :0.i$  ?A2039808  ?A :Y  i% N  i& N  i' #X'X%&"#8VXX'C:\SDWIS\CCRBRIG#X'X8V##&%XX'  i( #X'X%&e##8VXX'SDWISCOM.MDB#X'X8V##&%XX' D ) 8.0.1  D * #X'X%&$#8VXX'05/21/2002@02:13P#X'X8V$#&%XX' 9/ D + "A610304"A9610,304 9/-D , "A610304 "A 9Y  D - N  D . N  D / #X'X%&$#8VXX'C:\SDWIS\MIGRATE#X'X8V%#&%XX'  D 0  D#X'X%&0&#8VXX'ATAMIG.MDB#X'X8V&#&%XX' Q 1 8.0.1  Q 2 #X'X%&&#8VXX'05/30/2002@02:30P#X'X8V]'#&%XX' :0 Q 3 JA3493888JA:3,493,888 :0.Q 4 JA3493888 JA :Y  Q 5 N  Q 6 N  Q 7 #X'X%&'#8VXX'C:\SDWIS\MIGRATE#X'X8V(#&%XX'  Q 8  #X'X%&)#8VXX'DATAMIGW.MDB#X'X8Vj)#&%XX' , 9 8.0.1  , : #X'X%&)#8VXX'05/30/2002@02:30P#X'X8V2*#&%XX' :0 , ;  N  , ? #X'X%&*#8VXX'C:\SDWIS\MDB#X'X8V+#&%XX'  , @ SDWISEDI.MDB 9 A 8.0.1  9 B #X'X%&+#8VXX'05/212002@02:14P#X'X8V},#&%XX' 9/ 9 C A487424A9487,424 9/-9 D A487424 A 9Y  9 E N  9 F N  9 G #X'X%&,#8VXX'C:\SDWIS\EDIDATA#X'X8V-#&%XX'  9 H SDWISODD.MDB I 8.0.1  J #X'X%&.#8VXX'05/21/2002@02:15P#X'X8V.#&%XX' :0 K OA4157440OA:4,157,440 :0.L OA4157440 OA :Y  M N  N N  O #X'X%&/#8VXX'C:\SDWIS\ODD#X'X8V0#&%XX'  P #X'X%&f0#&%XX'CDSRPTS.MDB#X'X%&0#&%XX' !Q 8.0.2  !R #X'X%&1#8VXX'07/08/2002@05:35P#X'X8V1#&%XX' :0 !S XEA2797568XEA:2,797,568 :0.!T XEA2797568 XEA :Y  !U Y  !V N  !W #X'X%&1#8VXX'C:\SDWIS\CDS#X'X8V2#&%XX' # !X ?# #X'X%&:3#&%XX' EBSRPTS.MDB#X'X%&3#&%XX' Y EBSRPTS.HLP uZ 8.0.38.0.3  u\ #X'X%&3#8VXX'10/16/2002@02:45P#X'X8V4#&%XX' ] #X'X%&4#8VXX'10/07/2002@12:09P#X'X8VC5#&%XX' <2 a^ lA 255226180lA<_2,552#X'X%&5#8VXX'26,180_ <20u` lA 255226180 lA <YY  ab YY  ad YY  af C:\SDWIS\EBSC:\SDWIS\EBSah ?  &%8V  <i?  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 dfdd f*dd *dd dd dd \dd \dd dd V..,qdd ,7dd ,Rdd ,dd ,dd ,dd ,dd ,dd +  %  %  #8V%&%7# EXHIBITSExhibit3.MSAccess97DatabasesforOracle "EXHIBITS<"Ԁ&%8V 9/$Yd  9<Name '  'Release   Version '  'Day/TimeGroup '  'Size '  'Have   applied:NoPatches? '   'Have    applied:Patch8.0.1? 'q |  '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 _j EBSRPTS.HLP ?J 8.0.38.0.3  ?J 10/16/2002@1:45P10/07/2002@12:19P <2 ?J ͠A 934625691͠A<_9,34625,691_ <20?J! ͠A 934625691 ͠A <YY  ?J# YY  ?J% YY  ?J' C:\SDWIS\EBSC:\SDWIS\EBS#8V%&E=#&%8VԀ ?J)   #8V%&B#   < 55 0'   TRX3' LetterP$'3 Letter Landscape3' Letter'3 Letter LandscapeT   TRX3' LetterX3' Letter3' Letter3' LetterT  $     X'X8V4.3  ReplacementApplicationFiles H  r AllSDWIS/STATE8.0WindowsNT/Oracleusersneedtoinstalltheapplicationfiles.ThefileslistedunderSubsection4.3.2replaceexistingfilesinthefolderinwhichyoukeepyourSDWIS/STATE8.0applicationsoftware.Pleaserefrainfromaccessingtheapplicationwhilethefilesarebeingupdated.     4.3.1  InstallationInstructions TJ  n  ClickonfileINSTALL_Appl803NT.EXE.Pressthe InstallSystem button.Youwillbe J  askedtoconfirmwheretheapplicationfilesshouldbeinstalled.YoushouldselectthesamefolderwhereyourSDWIS/STATE8.0applicationfilesreside.(Thefilesincludedin X'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XX X'K#Ԁ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 1N   ThefollowingfilesareincludedwithSDWIS/STATERelease8.0.3CumulativeforWindows  NTandOracle. r $ VDX$04/29/2002 09:06a$V1,300 D CDS0009S.REG F 07/25/2002 09:25p$V3,720 D CDS0010S.DDE 0 07/25/2002 09:26p"V430,080 D CDS0010S.DLL  09/01/2000 07:12p  #V40,960 D CDS0010S.EXE v 07/24/2002 06:10p$V1,300 D CDS0010S.REG ` 10/03/2002 12:21p**&V563 D CDS0011S.DDE J  10/03/2002 12:42p"V344,064 D CDS0011S.DLL 4! 09/01/2000 07:12p  #V40,960 D CDS0011S.EXE " 10/03/2002 12:42p$V1,300 D CDS0011S.REG # 10/03/2002 12:22p**&V334 D CDS0012S.DDE #  10/03/2002 12:42p"V434,176 D CDS0012S.DLL $j! 09/01/2000 07:12p  #V40,960 D CDS0012S.EXE %T" 10/03/2002 12:42p$V1,300 D CDS0012S.REG &> # 10/06/2002 08:48p"V136,915 D EBS0200E.DDE '(!$ 10/06/2002 08:49p V1,101,824 D EBS0200E.DLL ("% 09/01/2000 07:12p  #V40,960 D EBS0200E.EXE n)"& 10/07/2002 01:20p  #V50,707 D EBS0200E.HLP X*#' 10/06/2002 08:48p$V1,300 D EBS0200E.REG B+$( 10/10/2002 12:21p  #V89,290 D EBS0500E.DDE ,,%) 10/10/2002 12:21p"V585,728 D EBS0500E.DLL r 09/01/2000 07:12p  #V40,960 D EBS0500E.EXE \ 10/10/2002 01:32p  #V42,347 D EBS0500E.HLP F 10/10/2002 12:21p$V1,300 D EBS0500E.REG 0  10/06/2002 08:48p"V109,579 D _EBSMAIN.DDE_   10/06/2002 08:49p V1,146,880 D _EBSMAIN.DLL_   09/01/2000 07:12p  #V40,960 D _EBSMAIN.EXE_  | 10/07/2002 01:21p  #V37,899 D _EBSMAIN.HLP_  f 10/06/2002 08:49p$V1,289 D _EBSMAIN.REG_  P 10/07/2002 12:16p  #V25,763 D EBSRPTS1._HLP_ :  10/03/2002 01:30p  #V50,227 D GEN0200E.DDE $  10/03/2002 01:32p"V659,456 D GEN0200E.DLL   09/01/2000 07:12p  #V40,960 D GEN0200E.EXE j  10/07/2002 01:26p  #V21,428 D GEN0200E.HLP T  10/03/2002 01:31p$V1,300 D GEN0200E.REG >  07/17/2002 10:19a"V116,859 D MBS0200E.DDE (  07/17/2002 10:30a V2,457,600 D MBS0200E.DLL  09/01/2000 07:12p  #V40,960 D MBS0200E.EXE  07/18/2002 02:44p  #V70,291 D MBS0200E.HLP t 07/17/2002 10:29a$V1,300 D MBS0200E.REG ^ 07/17/2002 10:20a  #V94,963 D MBS0300E.DDE H 07/17/2002 10:30a"V483,328 D MBS0300E.DLL 2 09/01/2000 07:12p  #V40,960 D MBS0300E.EXE  07/18/2002 02:46p  #V46,204 D MBS0300E.HLP x 07/17/2002 10:30a$V1,300 D MBS0300E.REG b 07/17/2002 10:20a"V100,110 D MBS0300S.DDE L 07/17/2002 10:25a V2,297,856 D MBS0300S.DLL 6 09/01/2000 07:12p  #V40,960 D MBS0300S.EXE   07/17/2002 10:24a$V1,300 D MBS0300S.REG   07/17/2002 10:21a"V232,642 D MBS0301E.DDE   07/17/2002 10:26a V1,089,536 D MBS0301E.DLL !l 09/01/2000 07:12p  #V40,960 D MBS0301E.EXE "V 07/22/2002 03:27p"V126,815 D MBS0301E.HLP #@  07/17/2002 10:26a$V1,300 D MBS0301E.REG $*! 07/17/2002 10:21a  #V30,758 D MBS0301S.DDE %" 07/17/2002 10:26a"V835,584 D MBS0301S.DLL p&# 09/01/2000 07:12p  #V40,960 D MBS0301S.EXE Z' $ 07/17/2002 10:25a$V1,300 D MBS0301S.REG D(!% 05/24/2002 04:41p"V395,986 D MBS0600E.DDE .)"& 05/24/2002 04:48p V5,238,784 D MBS0600E.DLL *#' 05/28/2002 02:06p"V169,134 D MBS0600E.HLP +$( 05/24/2002 04:48p$V1,300 D MBS0600E.REG +z%) _10/03/2002 12:22p__"V102,277__Ԉ D MBS1300E.DDE_ r _10/03/2002 12:42p__ V1,757,184__Ԉ D MBS1300E.DLL_ \ _09/01/2000 07:12p__  #V40,960__Ԉ D MBS1300E.EXE_ F _10/07/2002 01:29p__  #V51,193__Ԉ D MBS1300E.HLP_ 0  _10/03/2002 12:42p__$V1,300__Ԉ D MBS1300E.REG_   _07/08/2002 02:54p__  #V51,827__Ԉ D MBS1500E.DDE_   _07/08/2002 02:55p__"V724,992__Ԉ D MBS1500E.DLL_  | _09/01/2000 07:12p__  #V40,960__Ԉ D MBS1500E.EXE_  f _07/08/2002 03:32p__  #V34,905__Ԉ D MBS1500E.HLP_  P _07/08/2002 02:54p__$V1,300__Ԉ D MBS1500E.REG_ :  _10/08/2002 04:09p__  #V10,559__Ԉ D MBS1900E.DDE_ $  _10/08/2002 04:10p__"V630,784__Ԉ D MBS1900E.DLL_   _09/01/2000 07:12p__  #V40,960__Ԉ D MBS1900E.EXE_ j  _10/09/2002 01:35p__  #V22,863__Ԉ D MBS1900E.HLP_ T  _10/08/2002 04:09p__$V1,300__Ԉ D MBS1900E.REG_ >  _10/03/2002 12:22p__  #V35,641__Ԉ D MIG0200E.DDE_ (  _10/03/2002 12:48p__ V3,620,864__Ԉ D MIG0200E.DLL_  _09/01/2000 07:12p__  #V40,960__Ԉ D MIG0200E.EXE_  _10/07/2002 01:32p__  #V29,539__Ԉ D MIG0200E.HLP_ t _10/03/2002 12:48p__$V1,300__Ԉ D MIG0200E.REG_ ^ _05/24/2002 02:03p__ V1,863,680__Ԉ D MIG0300E.DLL_ H _10/17/2002 05:12p__$V8,550__Ԉ D MIG0500E.DDE_ 2 _10/17/2002 05:15p__"V520,192__Ԉ D MIG0500E.DLL_  _09/01/2000 07:12p__  #V40,960__Ԉ D MIG0500E.EXE_ x _10/17/2002 05:15p__$V1,300__Ԉ D MIG0500E.REG_ b _04/24/2002 04:45p__  #V49,152__Ԉ D REGISTER.EXE_ L _04/29/2002 09:27a__$V1,300__Ԉ D SBS0200E.REG_ 6 _10/16/2002 01:10p__  #V24,753__Ԉ D SBS0300E.DDE_   _10/16/2002 01:10p__"V139,264__Ԉ D SBS0300E.DLL_   _09/01/2000 07:12p__  #V40,960__Ԉ D SBS0300E.EXE_   _10/18/2002 11:10a__  #V21,474__Ԉ D SBS0300E.HLP_ !l _10/17/2002 12:33p__"V142,629__Ԉ D SBS0800E.DDE_ "V _10/17/2002 12:35p__ V1,409,024__Ԉ D SBS0800E.DLL_ #@  _09/01/2000 07:12p__  #V40,960__Ԉ D SBS0800E.EXE_ $*! _10/18/2002 11:16a__  #V52,795__Ԉ D SBS0800E.HLP_ %" _10/17/2002 12:34p__$V1,300__Ԉ D SBS0800E.REG_ p&# _07/17/2002 08:44a__"V108,015__Ԉ D SBS1700E.DDE_ Z' $ _07/17/2002 08:46a__ V1,163,264__Ԉ D SBS1700E.DLL_ D(!% _09/01/2000 07:12p__  #V40,960__Ԉ D SBS1700E.EXE_ .)"& _07/19/2002 03:57p__  #V47,490__Ԉ D SBS1700E.HLP_ *#' _07/17/2002 08:44a__$V1,300__Ԉ D SBS1700E.REG +$( 07/17/2002 08:44a  #V83,207 D _SBS1800E.DDE +z%) 07/17/2002 08:46a"V495,616 D SBS1800E.DLL r 09/01/2000 07:12p  #V40,960 D SBS1800E.EXE \ 07/19/2002 03:59p  #V49,032 D SBS1800E.HLP F 07/17/2002 08:46a$V1,300 D SBS1800E.REG 0  10/06/2002 09:48p  #V29,945 D SBS1900E.DDE   10/06/2002 09:48p"V221,184 D SBS1900E.DLL   09/01/2000 07:12p  #V40,960 D SBS1900E.EXE  | 10/07/2002 01:35p  #V15,673 D SBS1900E.HLP  f 10/06/2002 09:48p$V1,300 D SBS1900E.REG  P 07/02/2002 11:19p"V223,707 D SBS2000E.DDE :  07/02/2002 11:22p V2,027,520 D SBS2000E.DLL $  09/01/2000 07:12p  #V40,960 D SBS2000E.EXE   07/19/2002 04:00p  #V57,356 D SBS2000E.HLP j  07/02/2002 11:21p$V1,300 D SBS2000E.REG T  07/02/2002 11:20p  #V91,410 D SBS2300E.DDE >  07/02/2002 11:22p"V905,216 D SBS2300E.DLL (  09/01/2000 07:12p  #V40,960 D SBS2300E.EXE  07/03/2002 03:40p  #V39,577 D SBS2300E.HLP  07/02/2002 11:22p$V1,300 D SBS2300E.REG t 07/02/2002 11:20p  #V71,313 D SBS2500E.DDE ^ 07/02/2002 11:24p"V421,888 D SBS2500E.DLL H 09/01/2000 07:12p  #V40,960 D SBS2500E.EXE 2 07/03/2002 03:42p  #V38,989 D SBS2500E.HLP  07/02/2002 11:23p$V1,300 D SBS2500E.REG x 10/17/2002 12:32p"V357,551 D SBS2800E.DDE b 10/17/2002 12:34p V2,842,624 D SBS2800E.DLL L 09/01/2000 07:12p  #V40,960 D SBS2800E.EXE 6 10/18/2002 11:36a"V128,196 D SBS2800E.HLP   10/17/2002 12:33p$V1,300 D SBS2800E.REG   07/02/2002 11:20p"V104,772 D SBS2900E.DDE   07/02/2002 11:23p"V765,952 D SBS2900E.DLL !l 09/01/2000 07:12p  #V40,960 D SBS2900E.EXE "V 07/03/2002 03:44p  #V56,296 D SBS2900E.HLP #@  07/02/2002 11:22p$V1,300 D SBS2900E.REG $*! 10/18/2002 11:38a V3,195,278 D SDWIS.HLP %" Ѐ0 138File(s)45,046,251bytes  (# (# Ѐ