Data Management Software

1
Data Management Software

• Louise Hogan
• Little Rock Wastewater Utility

2
Its all about experience
3
Lots of Options
4
In The Beginning

• What Do You Want?????
• What Is The Problem????
• Are You Wasting Time With Your Methods?
• Do some brainstorming

5
LRWUs Process

• Ability to schedule routine events
• One location to store information
• Report options for certain criteria
• Create custom reports
• Fats, Oils, Grease tracking
• Surveyed User tracking
• Diversion meter tracking

6
LRWUs Process

• Analysis data tracking
• Create COC forms
• Noncompliance alerts
• Adequate security
• User friendly interface
• Upgrade options
• Accessible tech support

7
LRWUs Process

• Flexible
• Customizable

8
Technical Needs

• Discuss your needs with your computer gurus
• They can help with database type, size, and other
  technical stuff you might never think of.
• Keep them on your good side for now, you WILL
  need them later on in this process!!

9
Databases

• Oracle
• Access
• Hansen
• SQL
• Crystal Reports

10
MONEY
11
Our Review Process

• Picked 3 or 4 programs that looked like they
  would meet our criteria
• Received demos of the programs
• Had fun!!!

12
The Decision

• We finally picked a product that worked best for
  us.

13
The Software Package
14
FOG Module
15
Lab Assistant
16
Permit Writer
17
Surcharge Assistant
18
Sampling Assistant
19
Training
20
Testing

• Consistency
• Format Specifications
• Standard Operating Instructions

21
Open Test
Data Tracking
Permits
IUSM Sampling
Save the Dolphins
McDonalds
Inspections
Protocols
Reports
Collection System
Hospitals
Personnel
Grease Interceptors
SIC Codes
Discharge Limits
Categorical Standards
22
Limited Test
Permits
Data Tracking
IUSM Sampling
Save the Dolphins
McDonalds
Protocols
Inspections
Hospitals
Reports
Collection System
Grease Interceptors
Categorical Standards
Personnel
Discharge Limits
SIC Codes
23
Production
Permits
Data Tracking
McDonalds
IUSM Sampling
Protocols
Inspections
Collection System
Hospitals
Personnel
Grease Interceptors
Discharge Limits
Reports
Categorical Standards
SIC Codes
24
How Do You Get Consistency?

• How do you get everyone to do things the same
  way?
• Take away their lunch money?
• Why do you want consistency?

25
Why?

• Because I said so..
• Queries
• Reports

26
Example

• SIU-XYZ
• STR-PS
• SIU-XYZ
• SIU-STR

27
Teamwork
28
Tables

• We created lots of tables
• Industry Number
• Facility Number
• Industry Classification
• Facility Classification
• Secondary Classification
• Note Types
• Wastewater Types
• Sample Frequency

29
Definitions for Industry Number
30
Definitions for FOG Facility Number
31
Classification Types
32
Violation Types
33
Security !!!!!

• Security is very important to protect your data.

34
Problems We Encountered
35
Quick Review

• Adequate security
• Adaptability
• Support
• User Friendly
• Know what you need from the program
• Be consistent with data entry
• Try it before you buy it.

36
Vendor Information
Linko Data Systems Toll Free 1-877-LINKO-99 Phone
303-275-9968 Fax [phone] requests_at_linkodat
asystems.com
OPS Systems, Inc. Toll Free 800-OPS-0067 Ph
505-892-6700 Fax [phone] sales_at_opssys.com
AllMax Professional Solutions, Inc. Phone (419)
673-8863 Toll Free 800-670-1867 Fax (419)
673-8864 sales_at_allmaxsoftware.com
Cochrane Associates, Inc. Toll Free
1-(800)-4TRECOM Or 1-(800)-487-3266 Fax
1-(617)-247-2785 cochrane_at_CAIboston.com
37
Vendors
ChemSW Inc. Phone [phone] Fax (707)
864-2815 info_at_chemsw.com
CAPTAINS / COPS Phone [phone] Fax (864)
882-0851 info_at_goldieassociates.com
Enfotech Phone [phone] Fax
1-609-896-2555
Dynamic Databases Phone [phone] Fax
405-282-5203 lims_at_dynamicdatabases.com
RJ Lee Solutions, LLC Phone [phone] Fax 
509-735-1002 infolims_at_rjls.com
LabLite, LLC Phone [phone] Fax
860-354-9484 info_at_lablite.com
Any Questions?