sdwis edv release notes

SDWIS/eDV 1.0 Release Notes United States Environmental Protection Agency Office of Ground Water and Drinking Water CONTRACT NO. EPA BPA OARMSC-SYS-04 SDWIS Project Product Control No. Systalex-SDWIS-01-5-d1c July 31, 2007 Systalex-SDWIS-01-5.d1c July 31, 2007 SDWIS/eDV 1.0 RELEASE NOTES CONTRACT NO. EPA BPA OARMSC-SYS-04 SDWIS PROJECT Prepared for: United States Environmental Protection Agency Office of Ground Water and Drinking Water Drinking Water Protection Division 1200 Pennsylvania Ave., NW Washington, DC 20460 Contracting Officer Representative Edward Cottrill Prepared by: SAIC Solutions Delivery Center Science Applications International Corporation 6565 Arlington Boulevard Falls Church, VA 22042 Systalex-SDWIS-01-5.d1c July 31, 2007 CONTENTS 1.0 INTRODUCTION..............................................................................................................1 1.1 Document Overview ................................................................................................1 1.2 User Support ............................................................................................................1 SUMMARY OF FUNCTIONALITY ...............................................................................2 NOTES AND ADVISORIES ............................................................................................2 SDWIS/EDV 1.0 INSTALLATION PACKAGE ............................................................3 ADDITIONAL CROSS-APPLICATION FUNCTIONALITY .....................................4 Section 508 of the Rehabilitation Act Summarization of Implementation 2.0 3.0 4.0 5.0 APPENDIX A EXHIBITS Exhibit 1. SDWIS/eDV Program Files ......................................................................................... 4 iii Systalex-SDWIS-01-5.d1c July 31, 2007 1.0 INTRODUCTION The SDWIS/eDV 1.0 is deployed as a web-based, platform-independent application. SDWIS/eDV 1.0 supports the EPA Data Verification process by automating the identification of violations and comparing those violations to the Primacy Agency’s database and the SDWIS/ODS Quality Assurance (QA) Extract to identify discrepancies where the mismatches occur. SDWIS/eDV 1.0 targets a SDWIS/STATE Web Release 1.0 database architecture. 1.1 Document Overview This document contains Release Notes for SDWIS/eDV 1.0 software. Users should refer to the SDWIS/eDV 1.0 Installation Guide (Systalex-SDWIS-01-5.d1e, July 31, 2007) and to the SDWIS/eDV 1.0 User Guide (Systalex-SDWIS-01-5.d1f, July 31, 2007) for installation and user instructions.      Section 1.0, Introduction, describes the content of the document and user support procedures. Section 2.0, Summary of Functionality, lists functionality implemented in this release. Section 3.0, Notes and Advisories, lists notes and advisories identified during development and testing. Section 4.0, SDWIS/eDV 1.0 Installation Package, describes the folders and software used by the SDWIS/eDV application. Section 5.0, Additional Cross-Application Functionality, describes the incorporation of Section 508 requirements in the SDWIS/eDV application. User Support 1.2 As a representative of a primacy agency or the Environmental Protection Agency, you may call the SDWIS User Support Hotline at (703) 292-6298 or e-mail SDWIS User Support at sdwis@saic.com. The hotline/e-mail account is intended as a technical support tool for the operation and functionality of SDWIS products such as SDWIS/eDV. A SDWIS team member answers calls to the hotline between 8 a.m. and 5 p.m., Eastern Standard Time (EST), on weekdays (except federal holidays) and offers immediate user support when possible. During evenings, weekends, or those times when the support personnel are temporarily not available, callers may leave a detailed message. Questions requiring the expertise of other team members, such as developers or subject matter experts, are documented in the Events Tracking System, forwarded to those individuals, and answered as soon as possible. 1 Systalex-SDWIS-01-5.d1c July 31, 2007 2.0 SUMMARY OF FUNCTIONALITY SDWIS/eDV automates the Data Verification process by generating a list of candidate violations using the SDWIS/STATE Web Release 1.0 compliance determination processes. It then compares these candidate violations with those found by the Primacy Agency and those reported to SDWIS/ODS. Where matches are not found, discrepancies are identified and reported for further analysis. The following list summarizes the functionality of SDWIS/eDV 1.0:       SDWIS/eDV captures the data verification periods for each EPA Rule as specified by the user. SDWIS/eDV creates an extract file of a primacy agency’s SDWIS/STATE Web Release 1.0 database. SDWIS/eDV imports an extracted primacy agency’s SDWIS/STATE Web Release 1.0 database. SDWIS/eDV imports an extracted SDWIS/ODS QA Extract. SDWIS/eDV executes the SDWIS/STATE Web Release 1.0 compliance processes for the data verification periods established by the user. SDWIS/eDV compares violations in the three data sources and generates an eDV Discrepancy report rendered in the Jasper Intelligence online analytical processing (OLAP) tool. NOTES AND ADVISORIES 3.0 Advisory items noted during the development and testing of SDWIS/eDV 1.0 are listed below:  Integration testing was conducted using Internet Explorer 6.0 with successful results. However, using Mozilla Firefox, some pages did not render successfully. It is recommended that Internet Explorer be used with SDWIS/eDV 1.0. When you launch SDWIS/eDV using Start>Programs>SDWIS_eDV>Open eDV, it will attempt to reuse an existing Internet Explorer browser session. This may result in loss of data in that browser session. If an Internet Explorer browser session is not currently active, SDWIS/eDV will start one. On the Perform eDV page, the check box selections are not saved after you leave the page. On the Perform eDV page, all check boxes should be selected prior to providing a file name in either the SDWIS/STATE or SDWIS/ODS import function. Failure to do this results in the file names being removed when the check boxes are selected. SDWIS/eDV 1.0 reuses the SDWIS/STATE Web Release 1.0 compliance processes. Primacy agencies may see differences in the number of violations assessed if they were     2 Systalex-SDWIS-01-5.d1c July 31, 2007 not fully using the SDWIS/State compliance utilities during the DV verification period.  The presence of hard returns (carriage returns) in the .csv file causes the SDWIS/eDV 1.0 import to fail. To prevent this failure and simultaneously accommodate the situation where some primacy agencies may have hard returns in text fields (e.g., Comments, description, memo, etc.), SDWIS/eDV 1.0 does not extract data from the following columns: Tenactyp.Comment_Text Tenasact.Descrip_Text Tenenact.Remarks_Text Tenpnact.Comment_Txt Tenschat.Comment_Txt Tenschd.Descrip_Txt Tindefcy.Comments Tinlgent_Comment_Txt Tinpvals.Description Tinvisit_Comment_Text Tinwash.Comment_Text Tinwsf_Pump_Description Tinwsf.Directions_Txt Tinwsys_Memo_Txt Tmncmclv.Comment_Txt Tmnmnr.Description_Text Tmnmpavg.Comment_Text Tmnsasch.Reason_Text Tmnssgrp.Reason_Text Tmnviol.Remarks_Text Tsaanalyt.Comment_Text Tsamdbps.Comment_Text Tsasampl.Comment.Text Tsasar.Data_Qty_Rsn_Txt Tsasmppt.Activity_Rsn_Txt Tsasmppt.Description_Text Tsasmppt Note_1 Tsasmppt Note_2 Tsasmppt Note_3 Tsasmpsm.Comment_Text Should the import of the .csv file fail, it is possible there may be a hard return in an additional text column not listed above. These hard returns should be removed from the .csv file. Please contact SDWIS User Support for assistance.  SDWIS/eDV 1.0 assumes that all TCR repeat schedules have been established in the primacy agency database. These TCR repeat schedules will exist in the source SDWIS/STATE database where positive TCR sample results for a water system have been validated. SDWIS/EDV 1.0 INSTALLATION PACKAGE 4.0 The SDWIS/eDV 1.0 installation package is: SDWIS_eDV-1.0.EXE 08/02/2007 03:16 PM 168,264,878 The SDWIS/eDV 1.0 installation package creates an eDV folder under C:\Program Files and installs all of the software necessary to enable SDWIS/eDV. Exhibit 1 lists the folders in that directory after the installation of SDWIS/eDV 1.0. 3 Systalex-SDWIS-01-5.d1c July 31, 2007 Exhibit 1. SDWIS/eDV Program Files SDWIS/eDV will install its own versions of:       Apache Tomcat – to use for all eDV web server processing. SDWIS/eDV application – which contains the SDWIS/eDV interface and the implementation of the SDWIS/STATE Web Release 1.0 Compliance Processes. Apache Derby – a relational database used for all of the SDWIS/eDV compliance processes. Pentaho Kettle Extraction/Transformation/Load Tool – used to export a primacy agency SDWIS/STATE database and to import both a SDWIS/STATE extract and a SDWIS/ODS QA Extract. Jasper Intelligence – to present the interactive eDV Discrepancy report. MySQL – used by Jasper Intelligence. 5.0 ADDITIONAL CROSS-APPLICATION FUNCTIONALITY Section 508 of the Rehabilitation Act of 1973 requires that Federal Agencies’ electronic and information technology be accessible to persons with disabilities. SDWIS/eDV 1.0 incorporates 4 Systalex-SDWIS-01-5.d1c July 31, 2007 many changes that respond to Section 508 specifications. Appendix A contains a matrix listing each of these implementations beside the technical specification to which it applies. The SDWIS team used SSB Technology's Infocus 508 Evaluation tool to make preliminary assessments as to where changes need to be made. To simulate as closely as possible the operation of a visually impaired user, the testing was performed with IBM Home Page Reader (HPR) 3.0. For adherence to Section 508 specifications, SDWIS/eDV 1.0 was tested against EPA's prioritized level of importance as listed in A Plain Language Overview of the 16 Technical Specifications for Section 508 Accessibility (Jeff Morin, March 2001). 5 This page is intentionally left blank. APPENDIX A Section 508 of the Rehabilitation Act Summarization of Implementation This page is intentionally left blank. Systalex-SDWIS-01-5.d1c July 31, 2007 SUMMARY OF 508 TESTING Technical Specification of §1194.22 (a) A text equivalent for every non-text element shall be provided (e.g., via "alt", "long desc", or in element content). (c) Web pages shall be designed so that all Information conveyed with color is also available without color, for example from context or markup. (e) Redundant text links shall be provided for each active region of a server-side image map. (f) Client-side image maps shall be provided instead of server-side image maps except where the regions cannot be defined with an available geometric shape. (k) A text-only page, with equivalent information or functionality, shall be provided to make a web site comply with the provisions of this part, when compliance cannot be accomplished in any other way. The content of the text-only page shall be updated whenever the primary page changes. (m) When a web page requires that an applet, plugin or other application be present on the client system to interpret page content, the page must provide a link to a plug-in or applet that complies with 1194.21 (a) through (l). (d) Documents shall be organized so they are readable without requiring an associated style sheet. (g) Row and column headers shall be identified for data tables. (h) Markup shall be used to associate data cells and header cells for data tables that have two or more logical levels of row or column headers. Implementation EPA HIGH PRIORITY (1) A text description has been implemented for the faucet image. SDWIS/eDV contains no pages where color by itself conveys information. Not applicable. SDWIS/eDV does not use server-side image maps. Not applicable. SDWIS/eDV does not use server-side image maps. Screen Reader Test Result All images and graphical buttons located either in the navigation bar or the main pages were read by the screen reader. Not Applicable. Not applicable. Not applicable. Not applicable. Not applicable. Not applicable. SDWIS/eDV does not require applets or plug-ins to interpret page content. Not applicable. EPA MEDIUM PRIORITY All pages are readable without a style sheet. HTML tags for row and column headers were added Tags were added for row and column headers. SDWIS/eDV web pages were read without any problem when the style sheet is removed. IBM Home Page Reader (HPR) successfully reads header column and row information, as expected. IBM Home Page Reader (HPR) successfully reads header column and row information for each data cell, as expected. A-1 Systalex-SDWIS-01-5.d1c July 31, 2007 Technical Specification of §1194.22 (l) When pages use scripting languages to display content, or to create interface elements, the information provided by the script shall be identified with functional text that can be read by assistive technology. (n) When electronic forms are designed to be completed on-line, the form shall allow people using assistive technology to access the information, field elements, and functionality required for completion and submission of the form, including all directions and cues. (o) A method shall be provided that permits users to skip repetitive navigation links. (b) Equivalent alternatives for any multimedia presentation shall be synchronized with the presentation. (i) Frames shall be titled with text that facilitates frame identification and navigation. (j) Pages shall be designed to avoid causing the screen to flicker with a frequency greater than 2 Hz and lower than 55 Hz. (p) When a timed response is required, the user shall be alerted and given sufficient time to indicate more time is required. Implementation Not applicable, SDWIS/eDV does not use scripting Screen Reader Test Result Not applicable. Assistive technologies/screen readers such as IBM Home Page Reader was used to verify that the information. Not applicable. There are no electronic forms to be filled on-line in this website. Not applicable, the navigation links are unique for each page. Not applicable. EPA LOW PRIORITY Not applicable. SDWIS/eDV does not have nor use multimedia content. Two frames are rendered, a navigation and application frame, and both frames are identified appropriately. Not applicable. SDWIS/eDV does not have content that will cause the screen to flicker. Not applicable. SDWIS/eDV does not require timed responses. Not applicable. The screen reader identifies the start and the end of each of the two frames, as expected. Not applicable. Not applicable. A-2