WPC k/@Iw=^mYtQsJX&t*ſn\r] v+bOqdL bVt&2T:bJhAO6o- SnpnK4, "vInjd'cXLW(hI\ƒwí_ѣx(6XJ5ьV d뒎Ԝ+We4 wd&>O&cmq&S`LOa 9u.*@?  0~ %  0d#!tP 0MfUNj 0 0X 1}U@C 0M 1 0 0 0Ew 0E 0 mlw@j 1- 1u 1? 0MK MO 0S 0n MC!^ G! 0KS! 0Kc! 06" 0!h"M" 0|" 0{#M $4$ 0E#$$ 0$ T% 0k2 1o2 0E 3 0d3 0E$4N4 0E4 B5 0E5 16 1m7M7 17 18]9 09 09 0x: 0<; 1W; B;M; 0;U+0<=U >= 1> 1> 1%? 1? 13@ 1@ 1AA 1A 1OB 1B 0R]C BC 1C 1SD 1D 1aE 1E 0oF 1GMG 01G 0=G 0H 0>H 0I 0I 0pJ 0L 0aL 0M 0M 09N 0N 02O 0O 0:P 0Q 0_Q 0 Q 0kR 0YT B* V D3JV C}V D+V 0V 0X 06pY 0Y 0:Z 0hZ 0FP[U6[U*[M[M[M[U~@\MB\MF\MJ\ 0N\ 0J\ 0N]Me]Mi] 0m]MD^MH^ML^ 1P^M^ 1^ 1b_ 1_ 1p` 1` 1~a 1b 1b 1c 1c 1!d 1d 0/e 15f 1f 1Cg 1g 1Qh 1h 1_i 1i 1mj 1j 1{k 1l 1l 1m 1m 1n 1n 1,o 1oU,:pMfpMjpMnp Crp Ap 1)qMq 1q 1;r 1r 0IsMht 1ltMtMtMtMtMuMuM uMuMu CKuMbubfuMju 1nuMuMuMuMvMvM vM vMvMv 1vMvMvMvUNvv\;wU@wMwMx CxB!x 0@cx xzxM:zUJ>zfz 0zf {{a| 1| 10} 1}M>~ CB~ 1\~ 1~ 1jaU<MAEzJMāMȁ 0́ʂ 0Ƅ 0ą 0N 0B 0:<Ev xfa >$"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 |D}D~ E EUD & '  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 ParaXXXXXXyY-( $ 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  b     \R3' Letter\ȄIPq(`  Z(CG Times Regulardmailto:sdwisstate@sdc-moses.com.(H$0   EXHIBITS p  TRX3' LetterX3' Letter3' Letter3' LetterT),h  Z2CG Times (W1) Regular`L(Z3/$ I!%%%%X'X%%  ݘ }    TRX3' LetterP$'3 Letter Landscape3' Letter'3 Letter LandscapeTTABLE D%-3579hiEGKOSW[_cAutoList65"""""""")1)a)%-3579hyEGKOSW[_cAutoList66"""""""")1)a)%-3579hEGKOSW[_cAutoList67"""""""")1)a)d%-3579`EGKOSW[_cAutoList68"!"""""")1)a)%-3579heEGKOSW[_cAutoList69!!!!!!!!)1)a)%-3579`YEGKOSW[_cAutoList70"!"""""")1)a)TABLE A<pZ$Avalon Regular p  TRX3' LetterP$'3 Letter Landscape3' Letter'3 Letter LandscapeT:`c81AutoList25  X   2(4 4 <DL!2     5+ 4 <DL!5      //&%%%%X'X%%  _ProjectPlanPCNsuseletterextensionstodenotetheversion.Theoriginal  wouldbeSDC00020XXXXXXXXThefirstrevisionorupdatedversionwouldbeSDC00020XXXXXXXXAThesecondrevisionorupdatedversionwouldbeSDC00020XXXXXXXBetc.PleaseensurethatthecorrectPCNappearsinthecoverpagesaswellastheheaderinthemainbodyofthedocument.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&'TABLE A&' I!%%%%X'X%%  _L M%-3579`3LI      X'XXX'D *VA ddd Xdd Xdd XD ($D ($, ," d +  )V  )#X'XXX'#XXXX'3UnitedStates d EnvironmentalProtectionAgency @V/!@V @33OfficeofGroundWaterandDrinkingWater0  0FT$T$ C9+@FT$FT$V ! C3J#XX3 SoftwareReleaseNotesfor F SDWIS/STATERelease8.0.3CumulativeforWindows2000andSQLServer <2 $  !   < D  3#XX##30 0 T$ T$0IT$T$0IT$IT$ContractNo.68W99002(%T$T$ 0 0 T$ T$0IT$T$0IT$IT$TaskOrderNo.017 T$T$ 0 0 T$ T$0IT$T$0IT$IT$ProductControlNo.SDC0002017JB5015 vl.)u&T$T$ _ V@37553x V@ v#X'XXX#XXXX'AhXX 39AV)6 + dE6 + AOctober25,2002 #XXAhf##X'XXXG#X'XXX' SID+(  V@37553  V@  S3)'+( x _   3#X'XXX'`#  ~.* D    1 !XX'  B SOFTWARERELEASENOTESFOR̀SDWIS/STATE#X'X ! 1m # 1 !XX'RELEASE8.0.3CUMULATIVE #X'X ! 1 #Ԁ 1 !XX'  x  FORWINDOWS2000ANDSQLSERVER #X'X ! 1S #    CONTRACTNO.68W99002   TASKORDERNO.002017     Preparedfor: 4 UnitedStatesEnvironmentalProtectionAgencyOfficeofGroundWaterandDrinkingWaterDrinkingWaterProtectionDivisionX'XXX'1200PennsylvaniaAve.,NW#X'XXX' # B Washington,DC20460X'XXX' 4 TaskOrderProjectOfficer:EdwardCottrill#X'XXX'q #    Preparedby: %r  SystemsDevelopmentCenterScienceApplicationsInternationalCorporation6565ArlingtonBoulevardFallsChurch,VA22042  ),$%     8$!%%dXXd8     CONTENTS   V  RX'XXX'   R0     1.00(#(#INTRODUCTION#""J(#.@ @ (#(##1R݌ z ЌX'XXX'  RX'XXX'   R0     2.00(#(#DESCRIPTIONOFSDWIS/STATERELEASE8.0.3CUMULATIVEFOR ^  WINDOWS2000ANDSQLServer#""J(#.*(#(##1R-݌ P  ЌX'XXX'  &/X'XXX'  &/a0  0` (#(#    2.1 ` DatabaseMaintenanceandSchemaMigrationScripts#""J(#.F` (#` (##1&/a݌ B  ЌX'XXX'  '  '0  0` (#(#0 ` (#` (# `   2.1.1_MODIFY_VTYPE_VTAA.SQL_#""J(#.1 (# (##2'݌ ,  Ќ  '  '0  0` (#(#0 ` (#` (# `   2.1.2 _UPDATE_TINLGENT.SQL_#""J(#., (# (##2'݌ j  Ќ  '  '0  0` (#(#0 ` (#` (# `   2.1.3 _UPDATE_TMNALRA.SQL_#""J(#.+ (# (##2'݌ T  Ќ  &/X'XXX'  &/0  0` (#(#    2.20` ` (#` (#SDWIS/STATEMSAccessDatabaseFiles#""J(#.  8` (#` (##2&/:݌ >  ЌX'XXX'  '  '<0  0` (#(#0 ` (#` (# `   2.2.10 (# (#CDSReports(CDSRPTS.MDB)#""J(#.4 (# (##2'<W݌ (  Ќ  '  'G0  0` (#(#0 ` (#` (# `   2.2.20 (# (#EnforcementReportsComplianceScheduleReport(_EBSRPTS.MDB_)   #""J(#.  (# (##3'Gb݌̌  &/X'XXX'  &/0  0` (#(#    2.30` ` (#` (#DescriptionofResolutionsforSDWIS/STATERelease8.0.3Cumulativefor   Windows2000andSQLServer#""J(#./` (#` (##3&/݌ | ЌX'XXX'  '  'I0  0` (#(#0 ` (#` (# `   2.3.1 MigrationtoSDWIS/STATE#""J(#.1 (# (##3'Id݌ f Ќ  '  'I0  0` (#(#0 ` (#` (# `   2.3.2 OnlineSDWIS/STATEComponents#""J(#.\\6 (# (##4'Id݌ P Ќ  '  'N0  0` (#(#0 ` (#` (# `   2.3.30 (# (#MigrationtoSDWIS/FED:Actions#""J(#.  8 (# (##7'Ni݌ : Ќ  RX'XXX'   R]0     3.00(#(#ADDITIONALINFORMATION#""J(#.%(#(##7R]݌ j ЌX'XXX'  &/X'XXX'  &/0  0` (#(#    3.10` ` (#` (#Advisory:SampleUniquenessinOnlineSampling#""J(#.C` (#` (##7&/݌ \ ЌX'XXX'  &/X'XXX'  &/ 0  0` (#(#    3.20` ` (#` (#Advisory:CDSSetupPostProcessingReport#""J(#.$$?` (#` (##8&/ !݌ F ЌX'XXX'  &/X'XXX'  &/ "0  0` (#(#    3.30` ` (#` (#Advisory:WaterSystemFacilityMaintenanceandSellerTreatment&/ "C"݌0` (#` (# ЌX'XXX'  &/X'XXX'  &/f#0  0` (#(#    0` ` (#` (#Indicator  #""J(#.8 8 ` (#` (##8&/f##݌  ЌX'XXX'  &/X'XXX'  &/$0  0` (#(#    3.40` ` (#` (#Advisory:DeterminingWaterSourceTypeforPurchasedWater#""J(#.22P` (#` (##8&/$%݌  ЌX'XXX'  &/X'XXX'  &/*&0  0` (#(#    3.5 ` Advisory:MigrationtoCCRWriter#""J(#.&&6` (#` (##9&/*&d&݌  ЌX'XXX'  &/X'XXX'  &/\'0  0` (#(#    3.6 ` Advisory:SizeofMSAccessDatabaseWindow#""J(#.@` (#` (##9&/\''݌  ЌX'XXX'  &/X'XXX'  &/(0  0` (#(#    3.70` ` (#` (#Advisory:InvalidSamplingPointWindow#""J(#.<<<` (#` (##9&/((݌ n  ЌX'XXX'  &/X'XXX'  &/)0  0` (#(#    3.80` ` (#` (#Discrepancy:Release8.0ODDViolationTypePermittedValues#""J(#.\\Q` (#` (##9&/)*݌ X! ЌX'XXX'  &/X'XXX'  &/-+0  0` (#(#    3.90` ` (#` (#Discrepancy:MigrationtoSDWIS/STATE:MBSsPNActivityModule#`"`"I(#.~ ~ S` (#` (##10&/-+g+݌ B" ЌX'XXX'  &/X'XXX'  &/,0  0` (#(#    3.100` ` (#` (#Discrepancy:MigrationtoSDWIS/STATE:MBSsComplianceSchedule ,#  Module#`"`"I(#. ` (#` (##10&/,,݌ $j! ЌX'XXX'  RX'XXX'   R.0     4.00(#(#INSTALLATIONINSTRUCTIONSANDFILELISTFORSDWIS/STATE %F # RELEASE8.0.3CUMULATIVEFORWINDOWS2000ANDSQLServer#`"`"I(#.4 4 G(#(##11R.>.݌ &8!$ ЌX'XXX'  &/X'XXX'  &//0  0` (#(#    4.1 ` DatabaseMaintenanceandSchemaMigrationScripts#`"`"I(#.PPE` (#` (##11&///݌ '*"% ЌX'XXX'  &/X'XXX'  &/00  0` (#(#    4.2 ` SDWIS/STATEMSAccessDatabaseFiles#`"`"I(#.  8` (#` (##12&/0 1݌ (#& ЌX'XXX'  &/X'XXX'  &/20  0` (#(#    4.3 ` ReplacementApplicationFiles#`"`"I(#.1` (#` (##12&/2A2݌ )#' ЌX'XXX'  '  '530  0` (#(#0 ` (#` (# `   4.3.1 InstallationInstructions#`"`"I(#...2 (# (##13'53P3݌ *$( Ќ  '  '740  0` (#(#0 ` (#` (# `   4.3.2 FileList#`"`"I(#.ll" (# (##13'74R4݌ ~+%) Ќ    <<TableofContentswillgeneratehere>>  R-'+ Ї   EXHIBITS   6 Exhibit1.0 ` DBAScriptsforRelease8.0.3CumulativeforWindows2000andSQL` (#` (# 0  0` (#(#Server#`"`"I(#.r r ` (#` (##1}1}~2~ z  Exhibit2.0 ` MSAccess2000DatabasesforSQLServer#`"`"I(#.DD;` (#` (##12 d    V    1.00  INTRODUCTION 7(#(# TheHX'XXX'SafeDrinkingWaterInformationSystem(SDWIS)/STATERelease8.0.3Cumulative#X'XXHX'U8#HX'XXX'Ԁfor  Windows2000andSQLServerreleaseincludesfixestoproblemsnotedinSDWIS/STATE r Release8.0andalsoimplementssomenewrequirementsmadetothesoftwaresincethereleaseof#X'XXHX'8#HX'XXX'SDWIS/STATERelease8.0forWindows2000andSQLServer#X'XXHX' :#HX'XXX'.#X'XXHX':#HX'XXX' F  #X'XXHX':#HX'XXX'#X'XXHX');#HX'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XXHX'o;#HX'XXX'includesthenewrequirementsandsoftwarefixesin  n #X'XXHX';#HX'XXX'SDWIS/STATE#X'XXHX'f<#ԀRelease8.0.2aswellasfixesandnewrequirementsimplementedsincethe  X releaseofthatpatch.(SDWIS/STATERelease8.0.1didnotapplytoSDWIS/STATERelease  B  8.0forWindows2000andSQLServer.) ,  YoumayinstallHX'XXX'ԀSDWIS/STATERelease8.0.3Cumulative#X'XXHX'=#Ԁafteryourstate/regionhaseither   successfullyschemamigratedfromSDWIS/STATERelease7.0toSDWIS/STATERelease8.0orsuccessfullycompletedanewstate/newregioninstallationofSDWIS/STATERelease8.0.HX'XXX'Thisdocumentincludesadescriptionofthe#X'XXHX'3?#HX'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XXHX'?#Ԁcontents > andinstructionsforfileinstallation.Foranswerstoquestionsyoumayhavethatarenotcoveredbythesereleasenotes,youmaycalltheSDWISUserSupportHotlineat703-292-6298orsendanemailto4 B O  5  sdwisstate@sdcmoses.com.6@O AЌ  7B;A P   2.00  HX'XXX'DESCRIPTIONOFSDWIS/STATERELEASE8.0.3CUMULATIVEFOR  WINDOWS2000ANDSQLServer AԀ#X'XXHX'A# X'XXX' (#(# ThissectioncontainsabriefdescriptionofwhatisincludedinSDWIS/STATERelease8.0.3  Cumulative.Thecontentsofthisreleaseincludefixesthathavebeenmadetoexisting r SDWIS/STATERelease8.0softwareaswellasnewrequirementsthathavebeenimplementedsincetheinitialreleaseofSDWIS/STATE8.0.#X'XX X'B# X'XXX'#X'XX X'uD#  2.1  DatabaseMaintenanceandSchemaMigrationScripts D "n  HX'XXX'#X'XXHX'2E#HX'XXX'CorrectionshavebeenmadetosomeDBAscriptsandnewrequirementsimplemented,as #J! discussedbelow.Forspecificinformationonwhetheryouneedtocopyascriptintoyourenvironment,aswellasinstructionsonhow/wheretodoso,seethematrixinExhibit1inSubsection4.1.#X'XXHX'uE# &!$  -n'+   2.1.1_MODIFY_VTYPE_VTAA.SQL_ GԀ   HX'XXX'  HX'XXHX'  G  New_TMNVTYPE_/_TMNVTAA_Ԁrecords,changestoexisting_TMNVTYPE_/_TMNVTAA_  records,anddeletionsfromthesetablestosupportrecentreportingguidanceforMicrobialDisinfectionByProducts(MDBP)ruleandInterimEnhancedSurfaceWaterTreatmentRule(_IESWTR_)areincludedinscript#X'XXHX'G#_MODIFY_VTYPE_VTAA.SQL_HX'XXX',tohelpusersmeetfederal F  reportingrequirementsforviolations.GG݌̌HX'XXHX'   #X'XXHX'1J#  2.1.2  _UPDATE_TINLGENT.SQL_ KԀ   X HX'XXX'Ascripttoupdate_TINLGENT.COUNTRY_CODE_ԀtoUSwhere_TINLGENT.ADDRESS_ZIP_CODE_Ԁisvaluedisincluded.Thisaddressesaproblem#X'XXHX'K#HX'XXX'MigrationtoSDWIS/FED:Inventory#X'XXHX'L#ԀhaswiththeA1andtheA3Form,whereifCountryCode   (C0140orC0314)isnotvalued,nostatecode(C0139orC0313)orzipcode(C0141orC0315)transactioniscreatedintheDTFfile.HX'XXX'MigrationtoSDWIS/FED:Inventory#X'XXHX'M#Ԁworks   correctlyiftheCountryCodeisvalued.  2.1.3  _UPDATE_TMNALRA.SQL_ N  F HX'XXX'Ascript#X'XXHX'O#Ԁisincludedtocorrectthecontentsoftwofieldsinonerecordoftable_TMNALRA_Ԁin "v thestartupdatabaseZZV80.Thisscriptshouldonlybeappliedbystates/regionswhohavejust  ` installedZZV80withtheintentofusingSDWIS/STATE8.0astheirproductiondatabase.If J youhaveschemamigratedfromyourproductionSDWIS/STATERelease7.0database,youdonotneedtoapplythisscript.  2.20  SDWIS/STATEMSAccessDatabaseFiles ;QԀ (#(# CorrectionshavebeenmadetosomepreviouslydeliveredMSAccessdatabases.Forspecificinformationonwhetheryouneedtocopyoneofthesedatabasesintoyourenvironment,aswellasinstructionsonhow/wheretodoso,seethematrixinExhibit2.TwoMSAccess2000databaseshavebeenmodifiedsinceRelease8.0.  8!   2.2.10  CDSReports(CDSRPTS.MDB)  S#h (#(#  TwominorchangesweremadetotwoCDSReportqueries,whichinconcertwiththechangestothePostCDSReportsLogfunction,enabletheresultsofapreviouslyrunLeadandCopperTapMonitoringandReporting(M&R)ComplianceReporttobeviewedaccuratelywhenreexecutedfromthePostCDSReportsLog. HX'XXX'  #X'XXHX'T#HX'XXX' '"% #X'XXHX'T#8K XX'H8K  8K *-~'+ #HX'X H8KYU##X'XXHX'xU#  2.2.20  EnforcementReportsComplianceScheduleReport(_EBSRPTS.MDB_) U (#(# ThesearchfunctionontheComplianceScheduleReport,whichispartoftheEnforcementReport,hasbeenclarified.(Thisfunctiondidnotworkasuserspreviouslyexpected).  2.30  DescriptionofResolutionsforSDWIS/STATERelease8.0.3Cumulativefor F  Windows2000andSQLServer _WԀ 8 (#(# ThefollowingitemsdescribeproblemsidentifiedsincethereleaseofSDWIS/STATE8.0andwhoseresolutionisincludedinSDWIS/STATERelease8.0.3CumulativeforWindows2000  R  andSQLServer. <    2.3.1  MigrationtoSDWIS/STATE YԀ    IssuesaddressedwithintheMigrationtoSDWIS/STATEcomponentaredescribedin   Subsections2.3.1.1and2.3.1.2. 2.3.1.1MigrationtoSDWIS/STATE:MDBPSummary  V Ѐ"0  Undersomescenarios,thesoftwarewasincorrectlycarryingforwardareferenced 2 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  l "0  AproblemintheHX'XXX'MigrationtoSDWIS/STATE:Monitoring#X'XXHX'<]#ԀViolationmodulethat H! affectedthe duplicatebydatacheckaswellasthe duplicatebynumbercheckwasfixedinRelease8.0.2. (#(# "0  AproblemthatmanifesteditselfinthescenariowheretheHX'XXX'MigrationtoSDWIS/STATE: $D" Monitoring#X'XXHX'^#ԀNonTotalColiformRule(TCR)Schedulemodulecreatedasample %. # schedulegroupwithanopenEffectiveEndDateandwasthenunabletosuccessfullycreateSamplingPointSubscheduleswhenthetextfiledataindicatedthattheyshouldbecreated,hasbeenaddressed.AsecondproblemthatoccurredwhenwithinthesametextfilethereexistedtwodifferentscheduleswhoseWaterSystemsweredifferentbutwhoseWaterSystemFacility(WSF)StateAsgndIDhappenedtobethesame,wasalsofixed.Inthiscase,thewatersystemfromthesecondschedulewasnotbeingpickedup.ThisproblemwasfixedinRelease8.0.2. (#(#  *-~'+ "0  TheHX'XXX'MigrationtoSDWIS/STATE:Monitoring#X'XXHX'a#ԀPackageSchedulemoduleerroneously  preventedthecreationofanon-TotalOrganicCarbon(TOC)package(onethatdoesnotinvolvea2920finishedschedule)ifthesupportingschedulewasforanalytecode2920,1067,or1927.ThisfunctionhasnowbeenfixedtoallowthesePackagedSchedules,justastheycanbeaddedusingonlineScheduleMaintenance.ThisproblemwasfixedinRelease8.0.2. (#(# "0  TheFacilityAnalyteLevelstructuresetallowsuserstoassociatetheFacilityAnalyte  f Level(_FANL_)totwoviolationtypes:oneforM&Rviolationsandoneforlevelviolations.Therearetwofieldstobeusedforeachassociation:theViolationTypeCode,andtheViolationType_IS_Number_.Ifthereismorethanonerecordin_TMNVTYPE_ԀofthesameViolationTypeCode,thesoftwarewillusetheViolationType_IS_Number_Ԁtochoosethecorrectrecordtoassociatetothe_FANL_.Theproblemwasthatthesoftwarewasassociatingthe_FANL_Ԁtothefirstrecordin_TMNVTYPE_ԀofthereferencedViolationTypeCodeandwasnotusingtheViolationType_IS_Number_todistinguishthecorrect_TMNVTYPE_Ԁrecord,whenthissecondstepwasneeded.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  TheViolationstructuresetandsoftwaremoduleincorrectlyindicatedthat,for  t violationsofviolationtype71and72,thenewCompliancePeriodBegindatewouldbeusedforaparticulardateedit,wheninfact,thedateeditshouldhaveusedtheViolationPeriodBegindate.ThiserrorhasbeencorrectedinRelease8.0.3.Advisory 2 Note:TheSDWISCOM.MDBerrormessagehasnotbeenchangedtoreferenceViolationPeriodBeginDateinsteadofCompliancePeriodBeginDate.Whenmigratingintype71and72violationsandoneofthemisflaggedorrejectedbecauseofanissuewithCompliancePeriodBegin/EndDate,theproblemisactuallywithViolationPeriodBegin/EndDate.p(#(#   2.3.2  OnlineSDWIS/STATEComponents kԀ  D IssuesaddressedwithinonlineSDWIS/STATEcomponentsaredescribedinSubsections2.3.2.1through2.3.2.8. 2.3.2.1OnlineSampling"SampleMaintenance  #2! OnanyoftheSampleMaintenancewindows(byLaborbyWaterSystem),ifyouattemptedtocreateanewsamplingpointbyenteringavalueinonlytheSampleLocationfield(withnovalueinSamplingPoint),thisactioncorrectlytriggeredtheInvalidSamplingPointdialogbox.YoucouldthenspecifyActivityStatusandDateandcreateasamplingpoint;butwhenexitingthedialogbox,thesoftwaredidnotsavethesamplelocationandactivitydateinformation.ThisproblemhasbeenfixedinRelease8.0.3.  -^'+  HX'XXX'2.3.2.2OnlineSampling"MDBPSummaryMaintenance #X'XXHX'n#  "0  WhenusingtheDistributionResidualDisinfectantConcentration(_RDC_)Changeor  AddwindowfromeithertheSamplingcomponents MDBPSummary/SWTR (Surface r WaterTreatmentRule)windowflowortheSamplingcomponents Sample d  Summaries/TCRSummary/SWTR_RDC_ buttonwindowflow,thecontrollevelthat V  wasdisplayedforthestateresidualwasnotcorrect.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  Iftherewasmorethanonetreatmentplantordistributionsystemforthe_MDPB_ Z  Summary'sreferencedWSF,theSWTRandMaximumResidualDisinfectantLevel(_MRDL_)windowflowdidnotallowtheentryofMDBPsummaries,eveniftheappropriate_FANLs_Ԁwereinplace.ThisproblemhasbeenfixedinRelease8.0.3. (#(#  2.3.2.3OnlineSampling"TCRSummaryMaintenance    WhenthesoftwareautomaticallyassociatedanewTCRSummarytoadistributionsystem(DS)(which_occured_ԀwhentherewasonlyoneDS)anduserssubsequentlyenteredtheMonitoringPeriodforthesummary,thesoftwareshould,atthatpoint,haveenabledthe SWTR_RDC_ and H  CL2_RDC_ buttons.However,usershadtoselecttheWSFStateAsgnID _GoTo_ buttonand : re-selectthedistributionsystemtoenablethesebuttons.ThisproblemhasbeenfixedinRelease8.0.3;the SWTR_RDC_ and CL2_RDC_ buttonsarenowenabledatthecorrectpoint. j  2.3.2.4OnlineEnforcement"EnforcementActionSearch F  AproblemwithdefaultdatesnotbeingproperlydisplayedintheEnforcementActionSearchdialogboxhasbeencorrectedinRelease8.0.3.Previously,ifusersdidnotenteranydatecriteriaintheEnforcementActionSearchdialogbox,itssearchlogicfunctionedasinpreviousreleases;i.e.,itsearchedforEnforcementActionswhoseStatusDatewas6monthspriortotoday'sdate.These defaultdatesdidnotappearonthewindow,however,eventhoughthesoftwarewasusingthem.ThedatedefaultsthatexistedwithRelease7.0andpriornowappearonthewindow.(StartDatedefaultstothedatethatis6monthspriortotodaysdate.EndDatedefaultstotodaysdate.) 2.3.2.5OnlineEnforcement"PNScheduleMaintenanceList %\"  AproblemwhereopenPublicNotification(PN)SchedulesdidnotfirstdisplayonthePNScheduleMaintenanceListhasbeencorrectedinRelease8.0.3.ThePNScheduleMaintenanceListnowcorrectlydisplaysallopenPNschedules,thatmeetthecriteriayouspecify,whenthelistisfirstdisplayed. J-'+  2.3.2.6OnlineMonitoringandNoncompliance"Violations   ThismodulehasbeenredeliveredsothatitusesthefixedViolation duplicatebydatacheckthatwasoriginallyfixedfortheMigrationtoSDWIS/STATEViolationmodule.Thiswasfixed r inRelease8.0.2. 2.3.2.7OnlineMonitoringandNoncompliance"MigrateCandidateCDSViolations B  Ӎ2.3.5..OnlineMonitoringandNoncompliance"MigrateCandidateCDSViolationsC   0  "0  ThismodulehasbeenredeliveredsothatitusesthefixedViolation duplicatebydata  ` checkthatwasoriginallyfixedfortheMigrationtoSDWIS/STATEViolationmodule.  J  ThisproblemwasfixedinRelease8.0.2. (#(# "0  MigrateCDSCandidateViolationswaspreviouslynotcarryingtheWSFreferencedby   thecandidateviolationintotheactualSDWIS/STATEviolation.ThisproblemhasbeenfixedandareferencedWSFinthecandidateviolationisnowcorrectlycarriedovertotheactualviolation.ThisproblemhasbeenfixedinRelease8.0.3. (#(# "0  AproblemwheresomePNcandidateviolationswerenotbeingcorrectlymigratedinto F theTMNVIOLtablehasbeencorrected.ThiswasactuallyaproblemwiththewaythePNComplianceReportclearedoutpreviouslycreatedviolationsfordifferentagencies.ThisproblemhasbeenfixedinRelease8.0.3. (#(#  2.3.2.8CDSSetup ,  "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 >+%) incorrectlyprovidinguserstheinternalsystemnumbersofuniqueidentifiers(suchasWaterSystemNo.,WSFStateAsgnID,etc.)ratherthantheactualWaterSystemNo., -f'+ AnalyteCode,etc.ThismadetheinformationforthisCDSSetupprocess  unnecessarilydifficulttoprocess.ThisproblemhasbeencorrectedinRelease8.0.3,andtheinformationforthisCDSSetupprocessisreportedintheCDSSetupProcessing  ReportinthesamewayasitisforallotherCDSSetupprocesses.j(#(#   2.3.30  MigrationtoSDWIS/FED:Actions _ > (#(# AproblemthathadgoneundiscoveredsincethedeliveryofSDWIS/STATERelease7.0hasbeenfixed.Thisproblemoccurredwhenanenforcementactionwasalsolinkedtoaviolationthatreferencedastate-ownedviolationtype(notreportabletoSDWIS/FED)aswellasbeinglinkedtoaviolationthatreferencedafederally-ownedviolationtype.InthisscenarioHX'XXX', ,  MigrationtoSDWIS/FED:Actions#X'XXHX'<#HX'XXX'Ԁincorrectlyunderstoodthatifoneviolationlinkedwasstate   owned,allviolationslinkedwerethenstate-owned.TheresultwasthesoftwaredidnotgenerateboththeE1formandtheY5000.#X'XXHX'#HX'XXX'MigrationtoSDWIS/FED:Actions#X'XXHX'Ҍ#Ԁhasbeenfixed   togenerateboththeE1formandtheY5000whentheenforcementactionislinkedtobothaviolationthatreferencesastate-ownedviolationtype(notreportabletoSDWIS/FED)ANDaviolationthatreferencesafederallyownedviolationtype(thatisreportedtoSDWIS/FED).ThishasbeenfixedinRelease8.0.3.  3.00  ADDITIONALINFORMATION P(#(# NotetheadvisoriesanddiscrepancylistedinSubsections3.1through3.10.  3.10  Advisory:SampleUniquenessinOnlineSampling O (#(# InresponsetoarecentUserSupportinquiry,itwasnotedthatsampleuniquenesscriteriaforasampleenteredusingoneoftheonlineSampleMaintenancewindowsarenotdocumentedineithertheUsersGuideoronlineHelpforthosewindows.SampleuniquenesscriteriafortheonlinesamplingwindowshavenotchangedsincetheSamplingcomponentwasoriginally F  introducedin1995.ThecriteriaforenteringasamplewhenusingonlineSamplingremains: 0! IfvaluingLabSampleNo.:0  WaterSystemplusLabplusLabSampleNo.plusCollectionDateplusSamplingPoint. (#(# IfleavingLabSampleNo.blank:0  WaterSystemplusLabplusCollectionDateplusSamplingPointandifsupplied,CollectionTime. (#(# ThesecriteriaaredifferentfromthecriteriaspecifiedforSamplingviaEDI/Migrationto >+%) SDWIS/STATE:Sampling,whicharestricter.Theabovecriteriawerespecifiedbyuserswho (,|&* attendedthetwoSamplingJADsinNovember1994andFebruary1995.Atthattime,there -f'+ wasanexplicitrequirementtobeabletocreateasamplewithoutusingaLabSampleNo.orStateSampleNo.TheuniquenesscriteriadescribedaboveappliedtoallSDWIS/STATEsamplesuntilSDWIS/STATERelease7.0.WithSDWIS/STATERelease7.0,sampleuniquenesscriteriaforSamplingviaEDI/MigrationtoSDWIS/STATE:Samplingwere j tightened,asdescribedinAppendixAoftheSystemAdministrationGuideandAppendixEof T  theUsersGuide.  3.20  Advisory:CDSSetupPostProcessingReport U  f(#(# WhenCDSSetupencountersaFinishedTOCSchedulepackagedwithasingleRaw  B  Schedule/ScheduleGroupforTOCorAlkalinity,thefollowingmessagemayappearinthePostCDSSetupProcessingReport: CannotcalculateaprecursorachievedremovalratiobecausethereisnotaRawAlkalinityScheduleassociatedwiththeFinishedTOCschedule.ThismessageappearswhennoprecursorachievedremovalratiocanbecalculatedforaSampleScheduleMonitoringPeriodAssignment(SSMPA)ApplicablePeriodBeginandEndDateRangeassociatedtotheFinishedTOCSchedule.Thismessagemayalsoappearasaduplicateadvisorymessageinthereport.Inreality,however,itisnotaduplicatemessage;itappearsthiswaybecausewhiletheinformationtoidentifytheScheduleissupplied,themonitoringperiodandSSMPAApplicablePeriodBeginandEndDateRangeisnotspecified.Eachtimethemessageappearsasaduplicate,itappliestoasecond,third,fourth,etc.,MonitoringPeriod(SSMPA)ApplicablePeriodRange"whichisnotsupplied.  3.30  Advisory:WaterSystemFacilityMaintenanceandSellerTreatmentIndicator  $(#(#  TheEnvironmentalProtectionAgency(EPA)requiresthatprimacyagenciesnotonlyindicatewhetherornotthesellertreatsthewater,butalsowhetherornotthatwaterisfiltered.OntheexistingWaterSystemFacilityMaintenancewindow,theSellerTreatmentIndicatorfieldhasbeenmodifiedtohaveanewpermittedvalueofF"Treatedbyseller"includingfiltration.IfthevalueinthisfieldforagivenfacilityneedstobechangedtoF,youeitherneedtoupdateitusingtheonlinesoftwareorsomeothertool.NotethatthisinformationisreportedtoSDWIS/FED.  3.40  Advisory:DeterminingWaterSourceTypeforPurchasedWater "P (#(#  EPAregulationsstatethatindeterminingthesourcetypeforconsecutiveconnections,thebuyerssourcetypemustfollowthesellerstype.Forexample,iftheselleris groundwaterundertheinfluenceofsurfacewater(GUI),thenthebuyer'sprimarysourcebecomes purchasedgroundwaterundertheinfluenceofsurfacewater(_GUP_)not PurchasedGroundwater(_GWP_).However,SDWIS/STATEdoesnotlookattheprimarysourcetypeofthesellerwatersystemwhendeterminingtheprimarysourcetypeofabuyer;itlooksatwhathasbeenenteredastheWaterTypefortheConsecutiveConnection(CC)forthebuyer.AusercanenterGroundwaterastheWaterTypeforaCCeveniftheCCislinkedtoasellerthatisaGUI.Toverifysourcetypesforpurchasedwater,youcancheckthe_WSFs_ԀoftypeCC.NotethatthisinformationisreportedtoSDWIS/FED. -f'+ Ї  3.5  Advisory:MigrationtoCCRWriter j    WhenusingMigrationtoCCRWriter(_CCRBRIG.MDB_),thiscomponentworkswithEPAs  productCCRWriterv.1.5,anMSAccess97basedfile,andthereforecannotbeinstalledusingMSAccess2000.Tocontinueusingthisdatabase,createafolderC:\CCRWriterandthen,fromtheCCRWriterinstallationdisk,copyfileCCRTBL.MDBintothisfolder.WhenopeningthisfileusingMSAccess2000,youwillbeaskedtoconvertit.Whenasked,renameitwithadifferentnameinordertocontinueusingit.  3.6  Advisory:SizeofMSAccessDatabaseWindow    J   Thesizeofthedatabasewindow,whenlaunchedfromanapplicationfile(e.g.,EBSReportsorMigrationtoSDWIS/STATE:MDBPSummaryImportTexttoStagingTable),maydifferfrom   oneusagetothenext.Youmayneedtoresizethedatabasewindowthatislaunchedbeforeusingit.  3.70  Advisory:InvalidSamplingPointWindow  d(#(# InattemptingtocreateanewsamplingpointbyenteringavalueinfieldSampleLocation(andnotfieldSamplingPoint),ifyouusethemousetomovetothenextentryfieldonthewindow(thefieldvarieswithsampletype),theInvalidSamplingPointdialogboxopensbehindthecurrent,SampleMaintenancewindow.TobringtheInvalidSamplingPointdialogboxtothefront,clickonthebuttonforInvalidSamplingPointwindowinthetoolbar.Youcanthenentertheactivitystatus/dateinformation.  3.80  Discrepancy:Release8.0ODDViolationTypePermittedValues - (#(# IntheRelease8.0OnlineDataDictionary(ODD),whenyouasktodisplaythepermittedvaluesforfieldsinViolationType(tableTMNVTYP),whentheFederalViolationType(TMNVTYP)Valueswindowisdisplayed,itdoesnotshowthefollowingnewRelease8.0fieldsonthewindow:"0  FEDReportingPeriodType(letsthesoftwareknowwhethertheviolations #h  CompliancePeriod(BeginandEndDates)ortheViolationPeriodBeginDateshouldbereportedtoSDWIS/FED)withthefollowingpermittedvalues: (#(# 0  0` (#(#CP"TheCompliancePeriodBeginandEndDateshouldbereportedto &!$ SDWIS/FEDforanyviolationusingthisViolationType. ` (#` (# 0  0` (#(#VP"TheViolationPeriodBeginDateshouldbereportedtoSDWIS/FEDfor z)#' anyviolationusingthisViolationType. ` (#` (# 0  0` (#(#RA"RunningAnnualAveragePeriod.8,&*` (#` (#  "-v'+ "0  ReportNumberofMissingSamplestoSDWIS/FED?(#(# L %-3579eh`M%-3579L0  0` (#(#Y/Yes"MigrationtoSDWIS/FEDshouldcreateatransactionthatreportsthe  numberofmissingsampleswiththeviolation(aspartoftheD1record). ` (#` (#   0  0` (#(#N/No"MigrationtoSDWIS/FEDshouldnotcreateatransactionthatreportsthe >  numberofmissingsampleswiththeviolation(aspartoftheD1record). ` (#` (# 0   (#(# 0  0` (#(#Spaces"Fielddoesnotapplytostateownedviolationtypes;so,shouldnotbe  P valuedinmostcases). ` (#` (# L %-3579Y`h%-3579L"0  ReportNumberofExceedencestoSDWIS/FED? (#(# 0  0` (#(#Y/Yes"MigrationtoSDWIS/FEDshouldcreateatransactionthatreportsthe   numberofexceedenceswiththeviolation(aspartoftheD1record). ` (#` (# 0  0` (#(#N/No"MigrationtoSDWIS/FEDshouldnotcreateatransactionthatreportsthe L numberofexceedenceswiththeviolation(aspartoftheD1record). ` (#` (# 0  0` (#(#Spaces"Fielddoesnotapplytostateownedviolationtypes;so,shouldnotbe  ^ valuedinmostcases. ` (#` (# "0  FedReportableContaminantCode"TellsSDWIS/STATEsoftwarewhethertheanalyte  coderecordedwiththeviolationoradifferentcode(theonespecifiedinthisfield)shouldbereportedtoSDWIS/FED. (#(# ThisinformationisavailablethroughRELATION.MDB,theonlineSystemAdministration p component,andtheViolationfunctioninonlineMonitoringandNoncompliance. Z   3.90  Discrepancy:MigrationtoSDWIS/STATE:MBSsPNActivityModule Q . (#(# TheMigrationtoSDWIS/_STATE:MBS_PNActivitymodulecanonlymigrate100PNactivity  "^ recordsatatime.Whileitisnotanticipatedthatastate/regionwouldnormallybemigratinginlargenumbersofPNactivityrecords,ifyoudoneedtomigrateinmorethan100PNactivityrecords,createtextfilesingroupsof100.  3.100  Discrepancy:MigrationtoSDWIS/STATE:MBSsComplianceScheduleModule e & $(#(# TheMigrationtoSDWIS/_STATE:MBS_ComplianceSchedulemodulecanonlymigrate100 x("& complianceschedulerecordsatatime.Youwillneedtocreateseveraltextfilesandmigratetheminseparatelyifthenumberofcomplianceschedulerecordstobemigratedexceeds100.   ,t&*   4.00  INSTALLATIONINSTRUCTIONSANDFILELISTFORSDWIS/STATE   RELEASE8.0.3CUMULATIVEFORWINDOWS2000ANDSQLServer j (#(# SDWIS/STATERelease8.0.3CumulativeforWindows2000andSQLServerisacombination z ofautomaticallyinstalledfilesandfilesthatyouwillneedtocopyfromtheinstallationpackage,basedontheneedofyourlocationsoperatingenvironment.Wheremanualcopyoffilesisnecessary(inSubsections4.1and4.2),detaileddecisionmatrixesaresuppliedtoassistyouindecidingwhetherornotyoumayneedtocopyaparticularfile. %3   %32Y"3  0    Y"meansYes,youshouldinstallit.%3J݌ J (#(# Ќ   %3   %32Y"3  0    N"meansNo,youdontneedtoinstallitbecauseyoualreadyhaveoritdoesnotapply 4  toyourlocation.%3$݌ (#(# Ќ  ̀Forautomaticallyinstalledfiles,seeinstructionsinSubsection4.3.FromEPAsSDWIS/STATEwebsite,downloadfile8.0.3_sql.zip.Using_WinZip_,extracttoafolderyouname/create,suchasEXTRACT_803_SQL.Whenyouopenthisfolder,youwillseethefollowingfoldersandfiles:Access_2000_MDBs_DBA_Scripts_SQL_Sdwis80xuuxAppl803_Files.LSTAppl803_SQL.INFINSTALL_Appl803SQL.EXEyuuy  4.1  DatabaseMaintenanceandSchemaMigrationScripts Ԁ   Exhibit1liststhedatabasescriptsdeliveredwithHX'XXX'SDWIS/STATERelease8.0.3Cumulative#X'XXHX'# \ HX'XXX'Windows2000andSQLServer.Manuallycopythescriptslistedinthismatrix.#X'XXHX'J#ԀUsethe F  decisioncolumnsinthematrixtohelpdecideifyouneedtocopyascript.Thelastcolumnofthematrixspecifiesthefolderintowhichyoushouldcopyagivenscript.HX'XXX'Toruneachscript, "n loginastheDBAuserandrunitusingSQLQueryAnalyzer.#X'XXHX'# #X  Toaccessandrunthescripts,openfolder_DBA_Scripts_SQL_.zzXZEXXX'@~  T*$(      TRX3' LetterX3' Letter3' Letter3'T   ~~ T*$( ~*xVdA d " d " V(#(#x,4dd ,dd ,dd ,dd ,dd ,dd ,dd +  *  *  #X'XXXZE# EXHIBITSExhibit1. DBAScriptsforRelease8.0.3CumulativeforWindows2000andSQLServer "EXHIBITS" >4)d    >d:XX'yName 'w 'Release 'w 'FileDate 'w 'Size 'w 'Have applied:NoPatch? ' V 'Have w  applied:Patch8.0.2? '   'CopytoFolder: w  _MODIFY_VTYPE_VTAA.SQL_   V 8.0.3   V 10/21/200204:15p 8.   @13669@813,669 8., V @13669 @ 8Y   V Y   V SDWIS_MIGRATE70TO80   V _UPDATE_TINLGENT.SQL_   J 8.0.3   J 10/21/200204:13p 7-  @1727@71,727 7-+ J @1727 @ 7Y   J Y   J SDWIS_MIGRATE70TO80   J _UPDATE_TMNALRA.SQL_ >   ThisscriptisforNEWStates {  usingZZV80only! * 1 XX *8.0.3 * > ! *10/22/200211:34A MC{ # *@11860*@M1,1860 I?=> $ *@11860 *@ IN"SchemaMigrated8.0User  + ' N"SchemaMigrated8.0User#X'Xd:#d:XX'  + * SDWIS_MIGRATE70TO80 * > + *   ~ +    ~ +    ~ +    ~ + Y"New8.0Startup   - Y"New8.0Startup   /  ~ /   #X'Xd:#{{  4.2  SDWIS/STATEMSAccessDatabaseFiles VԀ  \0 Exhibit2liststheMSAccessdatabasefilesdeliveredwithSDWIS/STATERelease8.0.3 82 CumulativeforWindows2000andSQLServer.YouwillneedtomanuallycopytheMS "3 Accessdatabaseslistedinthissection.Usethedecisioncolumnsinthematrixtohelpyoudecideifyouneedtocopyoneormoreofthedatabasefilessupplied;thelastcolumnofthematrixspecifiesintowhichfoldertocopythedatabase.Exhibit2liststheMSAccess2000versiondatabasefilesthathavebeenmodifiedandredeliveredsubsequenttoRelease8.0.Toaccessthesedatabases,openfolderAccess_2000_MDBs.eXZEXXX'<7*Vdd4dd 4dd dd dd dd dd dd V(#(#,Fdd ,dd ,dd ,dd ,9dd ,9dd ,dd +  % \< %  #X'XXXZES# EXHIBITSExhibit2. MSAccess2000DatabasesforSQLServer "EXHIBITS"Ԁ 9/$M =  98K XX'WName '!F> 'Release !F? Version '"@ 'Date/TimeGroup '!FA 'Size '!FB 'Have !FC applied:NoPatch? '1$F 'Have !FG applied:Patch8.0.2? '1$J 'CopytoFolder:#X'X 8K?#&%XX' '!FK '#X'X%&#d:XX'CDSRPTS.MDB %L 8.0.2  %M 07/08/2002@05:35P :0 %N XEA2797568XEA:2,797,568 :0.%O XEA2797568 XEA :Y  %P N  %Q C:\SDWIS\CDS  %R  _EBSRPTS.MDB_ &F S _EBSRPTS.HLP_ ' T 8.0.38.0.3  ' V 10/22/2002@05:00P10/07/2002@12:26P >4 ' X *B 57286425691*B>572,86425,691 >42' Z *B 57286425691 *B >YY  ' \ YY  ' ^ C:\SDWIS\EBSC:\SDWIS\EBS#X'Xd:#d:XX'Ԁ#X'Xd:# ' `    4.3  ReplacementApplicationFiles    M)"a AllSDWIS/STATE8.0Windows2000/SQLServerusersneedtoinstalltheapplicationfiles. ThefileslistedunderSubsection4.3.2replaceexistingfilesinthefolderinwhichyoukeep ,%d  @7   TRX3' LetterX3' Letter3' Letter3' LetterT b  TRX3' LetterX3' Letter3' Letter3' LetterT   yourSDWIS/STATE8.0applicationsoftware.Pleaserefrainfromaccessingtheapplication ' whilethefilesarebeingupdated.    4.3.1  InstallationInstructions 7   ClickonfileINSTALL_Appl803SQL.EXE.Pressthe InstallSystem button.Youwillbe   askedtoconfirmwheretheapplicationfilesshouldbeinstalled.SelectthesamefolderwhereyourSDWIS/STATE8.0applicationfilesreside.(Thefilesincludedin X'XXX'SDWIS/STATE  v Release8.0.3Cumulative#X'XX X'#ԀwilloverwriteexistingfilesinstalledwithSDWIS/STATE8.0and  ` 8.0.2.)Press OK .Oncetheinstallationiscomplete,youwillreceiveaconfirmationdialog qJ  boxtellingyouthattheinstallationwassuccessful.Press OK .Press OK intheInstallation c<  Completedialogbox.Register.exewillautomaticallyrunandregisteryourfiles.Whencompleted,pressanykeytoexit.||  4.3.2  FileList     ThefollowingfilesareincludedwithSDWIS/STATERelease8.0.3CumulativeforWindows  2000andSQLServer.  Ѐ$ VDX$07/25/2002 09:00pJJ#V3,717 D CDS0010S.DDE  07/25/2002 09:02p!V425,984 D CDS0010S.DLL x 06/07/2002 06:15p"V53,248 D CDS0010S.EXE b 07/25/2002 09:01pJJ#V1,295 D CDS0010S.REG sL 10/02/2002 03:55p%V564 D CDS0011S.DDE ]6 10/02/2002 03:56p!V327,680 D CDS0011S.DLL G  06/07/2002 06:15p"V53,248 D CDS0011S.EXE 1  10/02/2002 03:55pJJ#V1,295 D CDS0011S.REG  09/05/2002 11:02a%V334 D CDS0012S.DDE  09/05/2002 11:03a!V417,792 D CDS0012S.DLL  06/07/2002 06:15p"V53,248 D CDS0012S.EXE   09/05/2002 11:02aJJ#V1,295 D CDS0012S.REG ! 10/04/2002 02:35p!V136,907 D EBS0200E.DDE " 10/04/2002 02:36pV1,073,152 D EBS0200E.DLL #p  06/07/2002 06:15p"V53,248 D EBS0200E.EXE $Z! 10/04/2002 03:08p"V50,699 D EBS0200E.HLP k%D" 10/04/2002 02:35pJJ#V1,295 D EBS0200E.REG U&. # 10/10/2002 12:20p"V89,284 D EBS0500E.DDE ?'!$ 10/10/2002 12:21p!V565,248 D EBS0500E.DLL )("% 06/07/2002 06:15p"V53,248 D EBS0500E.EXE )"& 10/10/2002 01:59p"V42,339 D EBS0500E.HLP )#' 10/10/2002 12:20pJJ#V1,295 D EBS0500E.REG *$( 10/04/2002 02:34p!V109,581 D _EBSMAIN.DDE_ +%) 10/04/2002 02:35pV1,097,728 D _EBSMAIN.DLL_ ,&* <   TRX3' LetterX3' Letter3' Letter3' LetterT   06/07/2002 06:15p"V53,248 D _EBSMAIN.EXE_ ' 10/04/2002 03:13p"V38,407 D _EBSMAIN.HLP_  10/04/2002 02:34pJJ#V1,284 D _EBSMAIN.REG_  10/07/2002 12:22p"V25,731 D EBSRPTS1._HLP_  10/02/2002 01:24p"V50,218 D GEN0200E.DDE   10/02/2002 01:25p!V643,072 D GEN0200E.DLL   06/07/2002 06:15p"V53,248 D GEN0200E.EXE  | 10/03/2002 02:00p"V21,428 D GEN0200E.HLP  f 10/02/2002 01:24pJJ#V1,295 D GEN0200E.REG w P 07/16/2002 06:18p!V116,861 D MBS0200E.DDE a:  07/16/2002 06:24pV2,396,160 D MBS0200E.DLL K$  06/07/2002 06:15p"V53,248 D MBS0200E.EXE 5  07/17/2002 10:19a"V70,291 D MBS0200E.HLP   07/16/2002 06:20pJJ#V1,295 D MBS0200E.REG    07/16/2002 06:19p"V94,956 D MBS0300E.DDE   07/16/2002 06:27p!V495,616 D MBS0300E.DLL   06/07/2002 06:15p"V53,248 D MBS0300E.EXE  07/17/2002 10:21a"V46,204 D MBS0300E.HLP  07/16/2002 06:26pJJ#V1,295 D MBS0300E.REG t 07/16/2002 06:19p!V100,095 D MBS0300S.DDE ^ 07/16/2002 06:26pV2,113,536 D MBS0300S.DLL oH 06/07/2002 06:15p"V53,248 D MBS0300S.EXE Y2 07/16/2002 06:24pJJ#V1,295 D MBS0300S.REG C 07/16/2002 06:19p!V232,630 D MBS0301E.DDE - _07/16/2002 06:28pV1,089,536 D MBS0301E.DLL  06/07/2002 06:15p"V53,248 D MBS0301E.EXE  07/22/2002 03:32p!V126,815 D MBS0301E.HLP  07/16/2002 06:28pJJ#V1,295 D MBS0301E.REG  07/16/2002 06:19p"V30,755 D MBS0301S.DDE  07/16/2002 06:28p!V823,296 D MBS0301S.DLL   06/07/2002 06:15p"V53,248 D MBS0301S.EXE !l 07/16/2002 06:27pJJ#V1,295 D MBS0301S.REG }"V 10/02/2002 03:46p!V102,269 D MBS1300E.DDE g#@  10/02/2002 03:48pV1,638,400 D MBS1300E.DLL Q$*! 06/07/2002 06:15p"V53,248 D MBS1300E.EXE ;%" 10/03/2002 02:01p"V51,193 D MBS1300E.HLP %&# 10/02/2002 03:46pJJ#V1,295 D MBS1300E.REG ' $ 10/02/2002 03:49p"V10,562 D MBS1900E.DDE '!% 10/02/2002 03:49p!V569,344 D MBS1900E.DLL ("& 06/07/2002 06:15p"V53,248 D MBS1900E.EXE )#' 10/03/2002 01:45p"V22,863 D MBS1900E.HLP *$( 10/02/2002 03:49pJJ#V1,295 D MBS1900E.REG +z%) 10/02/2002 03:58p"V35,641 D MIG0200E.DDE ,d&* 10/02/2002 04:03pV3,448,832 D MIG0200E.DLL u-N'+ 06/07/2002 06:15p"V53,248 D MIG0200E.EXE ' 10/03/2002 02:03p"V29,539 D MIG0200E.HLP  10/02/2002 03:59pJJ#V1,295 D MIG0200E.REG  10/18/2002 11:53aJJ#V8,552 D MIG0500E.DDE  10/18/2002 11:54a!V516,096 D MIG0500E.DLL   06/07/2002 06:15p"V53,248 D MIG0500E.EXE   10/18/2002 11:54a"V25,871 D MIG0500E.HLP  | 10/18/2002 11:53aJJ#V1,295 D MIG0500E.REG  f 04/24/2002 04:45p"V49,152 D REGISTER.EXE w P 10/17/2002 10:37a"V24,752 D SBS0300E.DDE a:  10/17/2002 10:39a!V135,168 D SBS0300E.DLL K$  06/07/2002 06:15p"V53,248 D SBS0300E.EXE 5  10/17/2002 11:51a"V21,474 D SBS0300E.HLP   10/17/2002 10:39aJJ#V1,295 D SBS0300E.REG    10/17/2002 12:54p!V142,625 D SBS0800E.DDE   10/17/2002 12:56pV1,409,024 D SBS0800E.DLL   06/07/2002 06:15p"V53,248 D SBS0800E.EXE  10/17/2002 01:03p"V52,795 D SBS0800E.HLP  10/17/2002 12:54pJJ#V1,295 D SBS0800E.REG t 07/18/2002 11:51a!V108,015 D SBS1700E.DDE ^ 07/18/2002 11:52aV1,085,440 D SBS1700E.DLL oH 06/07/2002 06:15p"V53,248 D SBS1700E.EXE Y2 07/18/2002 12:51p"V45,928 D SBS1700E.HLP C 07/18/2002 11:51aJJ#V1,295 D SBS1700E.REG - 07/18/2002 11:51a"V83,207 D SBS1800E.DDE  07/18/2002 11:52a!V495,616 D SBS1800E.DLL  06/07/2002 06:15p"V53,248 D SBS1800E.EXE  07/18/2002 12:55p"V47,315 D SBS1800E.HLP  07/18/2002 11:52aJJ#V1,295 D SBS1800E.REG  10/07/2002 02:35p"V29,945 D SBS1900E.DDE   10/07/2002 02:36p!V221,184 D SBS1900E.DLL !l 06/07/2002 06:15p"V53,248 D SBS1900E.EXE }"V 10/07/2002 03:00p"V15,673 D SBS1900E.HLP g#@  10/07/2002 02:35pJJ#V1,295 D SBS1900E.REG Q$*! 10/22/2002 01:45p!V357,505 D SBS2800E.DDE ;%" 10/22/2002 01:47pV2,838,528 D SBS2800E.DLL %&# 06/07/2002 06:15p"V53,248 D SBS2800E.EXE ' $ 10/22/2002 02:27p!V128,196 D SBS2800E.HLP '!% 10/22/2002 01:46pJJ#V1,295 D SBS2800E.REG ("& 10/22/2002 02:30pV3,191,356 D SDWIS.HLP )#' 10/02/2002 04:15p%V873 D _SQLNET.LOG_ *$( ̀109File(s)30,999,484bytes̀