1 / 27

Rhode Island UST Program

Rhode Island UST Program. Implementing ERP Using Tablet PC Technology. RI Department of Environmental Management www.dem.ri.gov. TOPICS. RI UST ERP DATABASE DEVELOPMENT UST INSPECTION WORK FLOW STATISTICAL ANALYSIS. TOPICS. RI UST ERP. RI UST ERP. EPA Technical Assistance Contract

willis
Download Presentation

Rhode Island UST Program

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Rhode Island UST Program Implementing ERP Using Tablet PC Technology RI Department of Environmental Management www.dem.ri.gov

  2. TOPICS • RI UST ERP • DATABASE DEVELOPMENT • UST INSPECTION WORK FLOW • STATISTICAL ANALYSIS

  3. TOPICS • RI UST ERP

  4. RI UST ERP • EPA Technical Assistance Contract • 6 Stakeholder meetings - Spring/Summer 2003 • Completed Work Book and Check List • 100 Baseline Inspections - Summer 2004 • Regulatory Change Making ERP Mandatory - Late Fall 2004 • Self-Certifications Sent January 2005

  5. RI UST ERP (con’t) • Certifications due June 31, 2005 • 461 Certifications received • Warning Letters sent to non-responders • 607/664 Certifications Received (91%) • 526 Deficiency Letters Issued • 761 RTCs received as of July 1, 2005

  6. TOPICS • RI UST ERP • DATABASE DEVELOPMENT

  7. Project Overview Project Management Methodology • Analysis • Design • Development • Deliverables • Extranet • Quality Assurance • Training / Documentation • Issue Tracking

  8. Mobile Inspection Solution Process Scheduling Pre-Inspection Inspection Post-Inspection Bring facilities into compliance with environmental regs Assess facility compliance with environmental regs Collect all available facility data (permits, violations, etc.) Designate facilities for inspection and assign to staff Purpose Compliance docs… and a cleaner environment! Inspection summary report and a list of violations Outputs A strategy for the inspection Scheduled (“tagged”) facilities Data transfer to Central Database. Finalization of Investigation compliance docs Actions Entry and management of complaints and inspections Auto-Transfer of all available info, including GIS maps, and attachments for an inspection Record data into consistent forms and checklists with validation logic. Print Copy Value Provides visibility, thereby reducing risk of missing inspections; Reduces the time required for research; ensures comprehensive data for all inspectors, Ensures consistency and complete inspections; data provides foundation for analytics and automated post-inspection activities Provides managerial review; efficiently generates docs; ensures visibility and performance of inspection follow-up

  9. TOPICS • RI UST ERP • DATABASE DEVELOPMENT • UST INSPECTION WORKFLOW

  10. Application Support Site – Step 1 Document Repository on DEM Intranet holds Inspections and supporting documentation for each facility.

  11. Department builds “target list” from repository of available facilities.

  12. Building Target List (Continued)

  13. Tablet Inspectors choose which inspections to view in detail. Inspectors create local list by selection from central list

  14. Each facility record includes current, as well as past inspection records, supporting documentation and reference materials as selected by the department. Multiple inspection forms and types can be supported with the same system.

  15. Inspection Forms are pre-populated with data from the supporting department information systems.

  16. Tablet Drawing Capabilities

  17. When complete the inspector makes a recommendation, adds comments and checks the inspection into the central repository.

  18. Supervisors come back to the intranet and review inspector’s recommendations, then make final approvals.

  19. TOPICS • RI UST ERP • DATABASE DEVELOPMENT • UST INSPECTION WORK FLOW • STATISTICAL ANALYSIS

  20. Report Selection Screen The screen below is the entrypoint for the reporting process, enabling a user to select the desired report:

  21. Report 1: Fisher’s Exact Test Results • This report determines the fisher exact test results for the • difference in compliance proportions of the identified Environmental Business Practice Indicators (EBPIs).

  22. Report 2: Bonferroni ReportThis report applies the Bonferroni Correction to the Fisher Exact Results

  23. Report 3: Confidence Interval ReportThis report gives upper and lower confidence intervals (at 95%) to the percent change in compliance to each indicator

  24. Report 4: Return to Compliance ReportThis report gives a count of the number of return to compliance plans submitted for a given EBPI and date range.

  25. EBPIsThe following table represents the EBPIs that will be available in the 4 reports described above:

  26. MORE INFORMATION • Microsoft Case Study http://www.microsoft.com/resources/casestudies/CaseStudy.asp?CaseStudyID=16986 • Tellus Report on MA DEP Website • http://www.mass.gov/dep/erp/erprepts.htm • RI Website - Auto Body Statistical Analysis Report http://www.dem.ri.gov/programs/benviron/assist/abdycert/abdycert.htm http://www.dem.ri.gov/programs/benviron/assist/usterp/index.htm

More Related