121442 O5 Attachment A - Revised.docx

Attachment A DWEE IIS Modernization

The DWEE Integrated Information System (IIS) is an internally developed application that provides consistent facility and non-facility level information across all agency programs. For facilities, it provides a single source of descriptive and location information about each facility. This is shared across all programs/sections of the agency. It incorporates locational information for facilities and businesses in order to integrate program data with the agency GIS. It is used to provide information for individuals within our agency credentialing programs, tracking applications, exams and continuing education. For both facility and non-facility items, additional data tracking may include related permits, events, fees paid and document indexing.

The modernization project consists of 17 menus and approximately 400 programs. Attachment B shows the relationship between each Menu Program, Sub-file program and corresponding displays.

Below is a list of each menu with the number of items on each menu that will need to be converted:

DWEE IIS File Maintenance Menu – IISMUR02 - 23 options

· Facilities – IISIIR02

· Municipalities – IISIIR21

· Counties – IISIIR23

· States – IISIIR31

· Hydrologic Units – IISIIRK8

· Natural Resources Districts – IISIIRL3

· People Firm and Organizations – IISIIRA9

· Work with DWEE Programs – IISIIR33 - Menu w/ 11 options

· Chemigation – CHMMUR02 - Menu w/ 3 options

· Enter Applications – CHMIUR01

· Search for Applicators – CHMIIR01

· Print Certificates Issued

· Database Administration – DBAMUR01 - Menu w/ 2 options

· Tier II Facility Updates – DBAIUR01

· Tier II Contact Updates – DBAIUR02

· Environmental Safety Program – ESPMUR01 - Menu w/ 7 options

· Pool/Spa Details – ESPIIR01

· Recreational Camp Details – ESPIIR06

· Mobile Home Park Details – ESPIIR10

· Inspectors – ESPMTR01

· Sanitizers – ESPMTR02

· Filter Makes & Models – ESPMTR03

· Pump Makes – ESPMTR04

· Fiscal Services – FSMUR01 - Menu w/ 13 options

· Create New e-Receipts – FSIUR01

· Work with e-Receipts – FSIIR04

· Internal Billing – FSIIR22

· Wire Transfers – FSIIR25

· Online Payments – FSIIR26

· Create Deposit Report – FSIIR01

· Reprint Deposit Report – FSIIR27

· Work with Revenue Sources – FSIIR06

· Work with Fund Deposits – FSIIR05

· Work with Invoices – FSIIR10

· Unpaid Invoices – FSIIR13

· Overpaid Invoices – FSIIR23

· Next Invoice Numbers – FSIUR05

· Leaking Storage Tanks – SPLMUR02 - Menu w/ 6 options

· Add New Spill and Actions – SPLMUR03

· Update Spill and Actions – SMPLMUR03

· Delete Entire Spill – SPLIUR03

· Actions Only – SPLIUR05

· Spill Number Transfer – SPLIUR07

· LUST Prioritization – SPLIUR11

· Livestock Waste Control – LWCMUR02 - Menu / 4 options

· Work with Livestock Operations – LWCIIR01

· Livestock Permits – LWCMUR03

· NPDES Livestock Operations – LWCIIR13

· NPDES General Permits – LWCIIR13

· Operating– LWCIIR13

· Construction / Operating – LWCIIR13

· NPDES or Operating or Construction / Operating – LWCIIR13

· Construction Approvals with No Permit – LWCIIR13

· Permitted Animals w/ No Active Permit – LWCIIR15

· Permitted Facilities w/ No Permitted Animals – LWCIIR18

· Permit Fees – LWCMUR04 - Menu w/ 2 options

· Projected Annual Permit Fees – LWCIIR14

· Fees Billed by Species – LWCIIR17

· Onsite Wastewater Treatment – OWTMUR02 – Menu w/ 8 options

· Onsite Wastewater Treatment Sites – OWTMUR04 – Menu w/ 9 options

· All Treatment Sites - OWTIIR08

· Alternative Systems - OWTIIR08

· Holding Tanks - OWTIIR08

· Lagoons - OWTIIR08

· Mound Systems - OWTIIR08

· Septic Systems - OWTIIR08

· Construction Permit Only - OWTIIR08

· Individual Operating Permit - OWTIIR08

· All Permitted OWT Systems - OWTIIR08

· Subdivision Reviews – OWTIIR13

· OWT System Professionals – OWTIIR14

· OWT System Businesses – OWTIIR01

· Professional Engineers and Environmental Health Specialists – OWTIIR12

· Journeymen without Masters – OWTIIR16

· Training and Education – OWTIIR26

· Certification Tests – OWTIIR30

· Add Test Events – OWTIUR03

· Operator Certification – OCPMUR03 - Menu w/ 11 options

· Waste Water Treatment Facilities – OCPIIR03

· Need Certificated Operator – OCPIIR05

· Need OCP Rating – OCPIIR04

· 4-Year Exemptions – OCPIIR06

· Eligible for 4-Year Extension – OCPIIR07

· Expire Next Quarter – OCPIIR38

· Expire This Quarter – OCPIIR39

· Expired Last Quarter – OCPIIR40

· WWTF Operators – OCPIIR32

· Training and Education – OCPIIR26

· Certification Tests – OCPIIR30

· Pool Operator Certification – POCMUR01 - Menu w/ 2 options

· Operators – POCIIR01

· Certification Exams – POCIIR03

· Public Water Operator – PWOMUR01 - Menu w/ 6 options

· Operators – PWOIIR01

· Training and Education – PWOIIR06

· Course Books – PWOIIR14

· License Exams – PWOIIR08

· Business and Employers – PWOIIR11

· Add Exam Events – PWOIUR15

· Water Well Professional – Menu w/ 6 options

· Professionals - WWPIIR01

· Training and Education – WWPIIR06

· License Exams – WWPIIR08

· Business and Employers – WWPIIR09

· Exam Reviews – WWPIIR14

· Add Exam Events – WWPIUR12

· Locate File – IISIIRL8

· Locate Document – IISIIRD1

· Locate Feature – IISIIRG7

· General Permits – IISIIRL4

· Responsible Parties – IISIIRA2

· Events – IISIIR84

· Permits – IISIIRB9

· Classifications – IISIIRG4

· Regulatory Requirements – IISIIRB7

· Groundwater Monitoring Sites – IISIIRL6

· NAC Regulations – IISIIRL5

· Permitting Activity – IISIIRC3

· Borrowed Files – IISIIRC7

· Scheduled Milestone Events – IISIIRF2

· Program Administrative – IISMUR04 - Menu w/ 3 options ** NEW – due to moving options from other locations **

· Air Fees

· Training Providers

· Training Events

There are 14 working libraries that source and datafiles reside in.

Once you select one of the options above, there could be one to many programs made accessible from that select. All programs and screens behind each of those options need to be converted. Many programs can be accessed from multiple programs throughout all the menu options and/or program options.

A more detailed list of programs and how they interact with other programs is included in Attachment B – DWEE IIS Modernization Overview.xlsx.

A large percentage of the programs behind all of these options are Subfile programs. Within each program there are specific options and function key options available, so ALL programs and screens for both will also need to be converted. Function keys may be converted to a “button” format.

“F4=Prompt” can be available from one-to-many times on any given screen. Some “Prompt Lists” are reused within various programs. Any “Prompt” can be converted into a dropdown list if possible. These programs are not defined in Attachment B due to the exact program not needing to be converted. They are listed as indication as to which programs call the “Prompt” lists.

Due to having other programs, service programs and/or stored procedures that are not a part of this modernization project, but reference our current DB2 database files, we will not be converting the DB2 database.