EPA-R5-73-020
July 1973
Socioeconomic Environmental Studies Series
Michigan Water Resources
Enforcement and
Information System
Office of Research and Monitoring
U.S. Environmental Protection Agency
Washington, O.C. 2046Q
-------
RESEARCH REPORTING SERIES
Research reports of the Office of Research and
Monitoring, Environmental Protection Agency, have
been grouped into five series. These five broad
categories were established to facilitate further
development and application of environmental
technology. Elimination of traditional grouping
was consciously planned to foster technology
transfer and a maximum interface in related
fields. The five series are:
1. Environmental Health Effects Research
2. Environmental Protection Technology
3. Ecological Research
1. Environmental Monitoring
5. Socioeconomic Environmental Studies
This report has been assigned to the SOCIOECONOMIC
ENVIRONMENTAL STUDIES series. This series
describes research on the socioeconomic impact of
environmental problems. This covers recycling and
other recovery operations with emphasis on
monetary incentives. The non-scientific realms of
legal systems, cultural values, and business
systems are also involved. Because of their
interdisciplinary scope, system evaluations and
environmental management reports are included in
this series.
-------
EPA-R5-73-020
July 1973
MICHIGAN WATER RESOURCES
ENFORCEMENT AND INFORMATION SYSTEM
Gary Guenther
Daniel Mincavage
Fred Morley
Michigan Water Resources Commission
Lansing, Michigan 48926
Project 16090 FSR
Project Officer
Phillip L. Taylor
Monitoring and Data Support Division
Office of Air and Water Programs
Environmental Protection Agency
Washington, D.C. 20460
Prepared for
OFFICE OF RESEARCH AND MONITORING
U.S. ENVIRONMENTAL PROTECTION AGENCY
WASHINGTON, D.C. 20460
For snlc by the Superintendent of Documents, U.S. Government Printing Office, Washington, D.C. 2W02 - Prico $1.75
-------
EPA REVIEW NOTICE
This report has been reviewed by the Environmental Protection
Agency and approved for publication. Approval does not signify
that the contents necessarily reflect the views and policies of
the Environmental Protection Agency, nor does mention of trade
names or commercial products constitute endorsement or recom-
mendation for use.
ii
-------
ABSTRACT
The project was implemented through a Federal grant from the
Environmental Protection Agency (EPA) to the Michigan Water Resources
Commission, who engaged Ernst & Ernst to conduct it.
The result is a workable interactive Federal/State water-pollution
control, enforcement, and information system. The project demonstrated
interactive computer graphics as a method of output presentation.
Two systems were interfacedMichigan's Water Information System for
Enforcement (WISE) and EPA's STORE! system. The WISE system is used to
alert enforcement personnel to problems through exception reporting, and
to provide follow-up information on these problems. STORET is utilized
as a storage and retrieval system for water quality and inventory infor-
mation. As information enters WISE, certain inputs are coded for
storage in STORET. The interface mechanism is a common numbering system.
Because WISE is modular in design, it can be used in part or in total
by other agencies.
s
Careful consideration should be given to the information that will
comprise the computer file. Administrative, procedural, and auditing
techniques should be completely set down before proceeding with
management's commitment to the system. Microfilm should be used when
feasible, both as Computer Output Microfilm (COM) and in manual files.
This report was submitted in fulfillment of Project Grant #16090 FSR
under the sponsorship of the Office of Research and Development,
Environmental Protection Agency.
iii
-------
CONTENTS
Section Page
I Conclusions 1
II Recommendations 3
III A Description of the System 5
IV WISE - Management Reports 41
V Operational Procedures and Equipment 63
VI WISE - Procedural Controls 73
VII System Coding Structures 115
VIII WISE Input Documents and Input Systems 133
IX Acknowledgments 161
-------
EXHIBITS
PAGE
1 REFERENCE MAP OF MICHIGAN 11
2 EXAMPLE OF INSET BLOW-UP 12
3 EXAMPLE OF FULL-SCREEN BLOW-UP 13
4 HURON BASIN MAP SHOWING EFFLUENT STATIONS 14
5 HURON BASIN MAP SHOWING GEOGRAPHIC DETAIL 16
6 MAP SHOWING LOCATION OF ONE COMPANY'S OUTFALLS 17
7 MAP SHOWING LOCATION OF WATER QUALITY STATIONS 18
8 INFORMATION ABOUT ORGANIZATION QUERIED 19
9 INFORMATION PLACED IN REPORT FORMAT 20
10 AERIAL VIEW - UPPER REACH 22
11 AERIAL VIEW - MIDDLE REACH 23
12 SCIENTIFIC GRAPH OF ANNUAL PARAMETER VARIATION 24
13 DISPLAY-COPY GRAPHICS EQUIPMENT 25
14 BLOCK DIAGRAM OF SYSTEM 27
15 MAN-HOURS REQUIRED TO SET UP INITIAL 2,000-RECORD MASTER FILE 32
16 WISE OPERATIONAL COSTS 37
17 MONTHLY PERFORMANCE AND ACTION REPORT 42
18 MONTHLY OPERATING REPORT (INFORM) 48
19 WISE - FILE DUMP 49
20 WISE - PERFORMANCE DUE LETTER 53
21 WISE - AUDIT LIST 54
22 PARTIAL INFORMATION CONTAINED ON HAIR RETRIEVAL REPORT ,56
23 MONITORING PROGRAMS MONTHLY SAMPLE REPORT '57'
24 PRIORITY POINT CALCULATION INPUT FORM 59
vi
-------
PAGE
25 PRIORITY LISTING 60
26 FACILITY GRADING LIST 61
27 ESTIMATED COSTS - MICROFILM JACKETS 70
28 MICROFILM - CONVERSION TIMING AND COST ESTIMATES 71
29 STATEMENT ON NEW OR INCREASED USE OF WATERS OF THE STATE
FOR WASTE DISPOSAL PURPOSES 78
30 SAMPLE REQUEST FOR STATION NUMBER 81
31 STATION NUMBER CONTROL FLOW CHART 83
32 NEW STATION SET-UP SHEET 84
33 USER INFORMATION AND STATION DATA FORM 85
34 MWRC STATION NUMBERS SHEET 87
35 MWRC STATION LIST 88
36 ANNUAL STATION NUMBER AUDIT 90
37 MWRC STATION LIST - ALPHABETIC SEQUENCE 91
30 FLOW CHART - MICROFILM ENFORCEMENT FILES MAINTENANCE 92
39 FLOW CHART - MICROFILM ENFORCEMENT FILES DATA RETRIEVAL 93
40 SAMPLE MICROFILM JACKET 94
41 MICROFILM BARCH CONTROL 95
42 FLOW CHART - OPERATING REPORT PROCESSING 98
43 INFORM CORRECTION FORM 102
44 MONTHLY OPERATING REPORT i(INFORM) 104
45 REVERSE SIDE OF MONTHLY OPERATING REPORT (INFORM) 105
46 CERTIFIED OPERATOR LETTER 107
47 REQUEST FOR FILE FORM 108
48 OUT-FILE CARD 109
49 DAILY INPUT BATCH LOG FORM HI
50 DAILY INPUT BATCH TRANSMITTAL FORM 112
vii
-------
PAGE
51 STANDARD INDUSTRIAL CLASSIFICATION CODE (PARTIAL LIST) 122
52 TERMINAL STREAM NUMBERS (PARTIAL LIST) 123
53 MICHIGAN MUNICIPAL CLASSIFICATION (MMC) 124
54 COMPARISON OF CODING SYSTEMS 125
55 ABBREVIATED STORET PARAMETER LIST 126
56 MAP - MICHIGAN ENFORCEMENT DISTRICTS 130
57 MAP - MINOR RIVER BASINS IN MICHIGAN 131
58 MAP - STORET SYSTEM COUNTY CODE NUMBERS IN MICHIGAN 132
59 MONTHLY REPORT OF FIELD SURVEY 141
60 DISTRICT FIELD VISITS 143
61 ANNUAL RATINGS AND TAX EXEMPTION STATUS 145
62 MONTHLY REPORT OF COMMISSION ACTION 148
63 MONTHLY REPORT OF JUDICIAL PROCEEDINGS 150
64 MONTHLY REPORT OF PERFORMANCE SCHEDULED 152
65 MONTHLY REPORT OF PERFORMANCE COMPLETED 154
66 REPORT TITLES 156
67 CERTIFIED WASTE TREATMENT PLANT OPERATORS 157
68 ORGANIZATION AND OUTFALL DESCRIPTION CARD 158
69 ADDRESS CORRECTION CARD 159
70 RIVER BASIN AND ORGANIZATION CARD 160
viii
-------
SECTION I
CONCLUSIONS
1. The Water Information System for Enforcement (WISE), interfaced with
STORET, is a workable system for the storage and retrieval of enforce-
ment, water quality, and inventory information.
2. Interactive computer graphics, a demonstration phase of this project,
should be pursued to the operational point and interfaced with both WISE
and STORET.
3. The annual operating costs per facility of the WISE system are
approximately as follows: key-punching and staff maintenance, $28.25;
computer costs, $5.17; equipment rental, $2.25; report distribution,
$2.22; microfilming, $0.55; and other costs, $0.71. This is an
approximate annual operating cost per facility of $40. The estimated
time to maintain each facility is approximately eight man-hours per year.
4. The WISE system was structured to provide a modular design, and is
made up of several subsystems that can be removed from the total system
when they are not required. For example, if another state does not need
the Performance Due Letter module, that module can be readily removed
from the total system without affecting the operation of the other
modules. Should another state or agency have requirements in addition
to those described in WISE, the modular design structure permits
additional modules to be interfaced with the WISE structure. Therefore,
the modular design of the WISE system readily allows a small or large
agency to use the system according to its own capability and desire.
5. Very careful consideration should be given to the items of data
which will be taken from manual files and placed in two computer files.
Definite, exact, demonstrative, and procedural controls, including
methods for auditing the master file, should be established prior to
initiating any data input to the system.
6. It is essential that the user agency's staff at all levels have
the proper training. Upper management should be familiar with the
system and support it. Regular training sessions are necessary for
clerical and other personnel who will be involved with direct input
to the system.
7. It was found that STORET storage should be done by punched cards
through the EPA Regional Office, and that STORET retrievals should be
made over a low-speed terminal.
8. Microfilm should be extensively used for manual files and computer
output, for reduced costs, and for ease of retrievals from the system.
-------
SECTION II
RECOMMENDATIONS
The following recommendations are based on the review of the actual
system in operation over a period of several months, and on the results
of several individual analyses to develop improved procedural controls.
It is recommended that future users of this system design a common data
base of water resource information within the system that is sufficiently
generalized to be used by multiple agencies. The system should be devel-
oped to utilize compatible coding structures that interface with the
Federal government's STORET water management information system. The
ease with which information can be assembled for input, stored in the
system, and retrieved in the required report formats leaves no more
effective alternative than duplicating the entire computer system.
Duplication of the programs was not considered necessary since STORET
is functioning effectively.
A new system should be responsive to user needs, flexible, and easy to
operate. It must provide easily understood reports and immediate access
to information from various remote locations. On-line remote access to
the STORET and WISE data bases is recommended because of the requirement
to review an organization's record as field activities dictate. To
simplify the collection of water quality management data, the user should
establish a pattern of uniform terminology and data classification codes.
The water quality data base and enforcement system should permit the user
to measure performance.
As a new system is updated and modified, design considerations should
include data processing equipment and techniques. Users should also
ensure that a new system can continue to serve as a basis for program
planning and evaluation of progress.
The system should be designed and modified to permit the constant
efficient handling of a large volume of data. Although the present
input volume of the Michigan Water Resources Commission is not large
enough to require an optical character reader, it is recommended that
the OCR be considered if volume increases. Until that time it is recom-
mended that the Commission continue to use computer-prepared documents
for the Monthly Operating Report and expand their use to include labora-
tory documents.
Microfilm jackets are recommended to users as a means of retaining an
accurate enforcement file with the capability to print copies.
It is highly recommended that future users utilize interactive computer
graphics. This is an extremely effective method of demonstrating a
comparative representation of pollution activity throughout a state.
The objective is to provide a flexible means of communicating variable
and .complex information in an illustrated format. Through the use of
computer graphics, the information for maps, charts, and trends can be
presented on a simplified and timely basis.
-------
SECTION III
A DESCRIPTION OF THE SYSTEM
Recently, the Michigan system for enforcement and inventory data was
manually processed and was rapidly becoming obsolete. The increased
activities of Federal, state, local, and private groups for the measure-
ment and control of water pollution produced large quantities of data.
Such data was often duplicated, poorly coordinated, and ineffectively
used, because manual control is too slow and cumbersome. The need for
more efficient data handling became obvious with the increased volume of
activities. Because there were not sufficient staff to review, analyze,
and take appropriate action, and because the Michigan Water Resources
Commission (MWRC) was not financially able to implement a large-scale
data processing facility, a system was designed, developed and imple-
mented which utilized existing programs and computer facilities available
through the Federal EPA-STORET system as well as supplemental computer
capabilities furnished on a local time-sharing system.
Time-sharing allows many different and independent operators to use one
central computer at the same time. This permits maximum utilization of a
computer through inexpensive remote terminals, and the central computer
cost is shared by all users. This type of system does not require the
users to maintain a large operating and maintenance staff, and gives
excellent flexibility for changing equipment to keep pace in this rapidly
expanding field. The Michigan system for enforcement and inventory data
has made use of the central state computer facility located in the State
Highway Department. Computer usage is charged on the basis of time used,
with no fixed cost if the computer is not used. This reduced the cost
during implementation to a minimum. As phases of the program were imple-
mented, minimal costs were absorbed based on limited computer usage.
The computer programs for the implementation of this system were written
in a universal language (COBOL). The result is a package system avail-
able to states or other potential users who do not have a computerized
water management system.
Michigan's area is approximately 40% water surface, and the State is
surrounded on three sides by the Great Lakes. Its fresh water resource
is shared directly with seven other states and Canada, and indirectly
with millions who come to use it. Cooperative management of this
resource is needed and must start with the basic data which describes it.
A common data system useful to all, yet adaptable to individual needs,
was needed to serve Michigan's multiple interests. Resource management
includes more than a measurement of quantity and quality characteristics.
Enforceable regulations are also required, and continuous follow-up is
necessary. In addition, each state or Federal organization involved in
this process is faced with inventory requirements. Thus, a general pur-
pose computer system has been developed and implemented which combines
three systems: 1) the storage of quality and quantity data in STORET, 2)
the storage of State inventory data, and 3) the utilization of the above
-------
data in an enforcement information system called WISE (Water Information
System - Enforcement). The utility of the system is such that it can
serve multiple agency requirements and thus, eliminate duplication.
The common data system permits the user to locate and identify informa-
tion sources, whether they are water intake, enforcement districts, or
political bodies, by a geo-political method. The system utilizes the
basic STORET station identifiers:
Primary station number
River mile index system
Latitude and longitude
Political code plus a modification for state enforcement districts
All stations will receive as many of these four as apply. This permits
any information which is developed for WISE to be input to the STORET
system, and will allow full utilization of STORET. These station identi-
ties can be established by using a computer and digital graphics
technique. Once the information source identifier (label) has been
established, the user may input a variety of information under that
label. The Michigan program currently accepts the following main infor-
mation items:
Operating reports for organizations concerning quality and
quantity of effluent or intake
Reports of staff visits
Reports of staff surveys at which quality and quantity data
were collected
Reports of property tax exemption status for pollution control
devices
« Reports of annual performance rating (given to each organization
in the State on an annual basis)
Report of all Commission actions concerning hearings and orders
Reports of performance due, such as date of start of construction
Reports of judicial action, such as filing of briefs
The WISE data processing system utilizes batch and on-line processing
techniques to maintain the master file and prepare the various management
and operating reports. In addition, the system is designed to provide
on-line retrieval of data through remote terminals.
The master file retains data on enforcement follow-up and water pollutant
parameters by which the effectiveness of an organization's waste water
control program is measured. This file is the main body of information
retained by the system.
The processing of data within the system is performed in a monthly cycle
with data retrievals processed on demand. The monthly processing proceeds
through the following steps:
There are two main sources of input: (1) The Performance and Action
Report input forms (Exhibits 30 to 33 and 59 to 70) are filled out
by.MWRC personnel, and may be used to set up a new station, record
-------
a field visit, or indicate survey data. (2) The Monthly Operating
Report (Exhibit 18) contains outfall parameter values taken and
recorded by a station's Certified Operator on a daily basis and
submitted to the MWRC on a monthly basis.
The system receives the above information and stores it in a data
base (one common all-purpose file). The system provides for the
proper processing of information. It compares operating reports
to preprogram standards, and prints all organizations not meeting
standards or not submitting reports as ordered. It also allows
remote access for instantaneous retrieval of this data to loca-
tions throughout the State.
In making information retrievals from the WISE system by remote terminal,
connect times will vary considerably depending on the complexity of the
retrieval, the load on the system, the type of system, the size of the
master file, and other factors. The investigating agency's experience,
using the computer configuration described in this report with tapes, was
that a retrieval of one record by station number took about 15 minutes.
It is recommended that if remote retrieval capability is essential,
random access disk capability should be investigated. By utilizing
direct access disk storage in the system, as demonstrated by the investi-
gating agency, the connect time would be shortened, if other factors
remain the same.
Two methods of STORET retrieval were used to compare the time elapsed in
obtaining data. One method consisted of using a low-speed terminal (LST)
to initiate the data retrieval, having the hard copy printed at the
computer center, and having this mailed to the user. The second method
was to punch a deck of retrieval cards and mail them to the EPA Regional
Office. EPA personnel used the card deck to initiate the retrieval. The
data was printed on the Regional Office printer, and the hard copy was
mailed to the user. Five retrievals were made using both methods. The
following results of the experiment demonstrate that the use of an LST
and direct mail from the computer center saves a considerable amount of
time.
Days Elapsed Days Elapsed
Retrieval No. Date Initiated with LST with Cards
1 1-14-72 4 18
2 1-18-72 3 14
3 1-19-72 , 5 13
4 1-20-72 3 12
5 1-21-72 3 11
As the system was implemented, the large volume of data processed
resulted in a cumbersome presentation of pollution activities, despite
the fact that exception-reporting was being used. It was decided that
the reporting system would be enhanced if technical information were
presented in a more understandable graphic format, which would permit
quick response to pollution problems. It was also desired that the
system measure and forecast water quality trends. Computer graphics
offered the possibility of presenting this large volume of information in
a form that emphasized:
-------
- Target and trends: projected, past, and current
- Comparative analysis of these trends
- Geographical presentation of the problems
Through the use of a visual display graphics terminal on a time-sharing
computer system, the program enables one to display on a map of arbitrary
scale the locations of water quality and industrial/municipal effluent
monitoring stations within any river basin in the State. The Huron River
Basin has been used as an example for this demonstration program. The
geographic data base consists of coastline coordinates, county line loca-
tions, and center line coordinates for the State's major rivers. For the
Huron Basin, details such as riverbank contours, streams, and municipal
boundaries are included. Station data fall into two major categories:
water quality and industrial/municipal effluent. The program allows the
user to select any station, either by name or by locating it geograph-
ically, and interrogate a data file for information about that station.
This interrogation can take two basic forms, narrative and graphical,
depending upon the type of station selected.
A newly-developed computer graphics program was demonstrated to the MWRC.
The purpose of its development was to demonstrate the feasibility of
displaying on a geographic background the location and nature of certain
occurrences which are important to the control of water resource quality.
The original project was enhanced by extending the capability of computer
use. This was accomplished by retrieving stored data and converting it
into the form of a graphical display shown on a remote terminal device.
This technique enables Commission members to see maps, charts, and trends
on a timely basis, and immediately grasp the overall results of actions
by multiple agencies with water resource responsibility.
In brief, the computer graphics program permits a user to see patterns of
water quality degradation and pollution violations against a geographic
background, and to immediately discern relationships which might other-
wise be impossible, or at best, time-consuming to discover.
Through the implementation of the WISE system and its interface with the
Federal STORET system, the enforcement capabilities of the Michigan Water
Resources Commission have been improved. The functions and favorable
results of certain system capabilities are described here.
Through its exception-reporting principle, the program module which
provides a performance analysis report (PAR) has enabled enforcement
personnel to concentrate on problem areas, rather than manually review
all information on all facilities. In accordance with legislation
requiring Certified Industrial Waste Treatment Operators and effluent
quality reporting, PAR has provided automatic computer review of the
monthly summaries from effluent quality reports. Thus, reports need not
be reviewed manually. Staff members can review their own performance of
"visiting organizations at least every 12 months," because organizations
not visited in the previous 12 months are printed on the exception report.
-------
Combined with another program module, PAR has enabled enforcement staff
to handle performance due more rapidly. One month in advance, the
program module named TICKLE generates a letter to be sent to organiza-
tions with performance due. Organizations that are behind in performance
due dates are printed on the exception report, and thus, enforcement
staff can follow up on organizations not meeting their waste water control
responsibility.
The program module named HAIR is utilized to obtain enforcement follow-up
data and to disseminate data to other agencies and the public. The 64
hierarchies in which data can be sorted and retrieved allow many various
distributions of the data base. This information has many uses to the
enforcement staff and others, and the computer sorts eliminate manual
searches of large amounts of data.
The program module named INFORM, which prints the Monthly Operating
Reports, and the program module named LABEL, which prints mailing labels,
have freed the staff from much typing, and permit a more timely distribu-
tion of forms.
In general, the WISE system has focused staff attention on certain key
information, and has improved enforcement capabilities by eliminating the
need to review an organization's entire manual file.
DATA BASE DESCRIPTIONS
Geographic Data
Geographic data is in the form of absolute longitudes and latitudes.
Shoreline data for the State of Michigan was obtained from a tape pro-
vided by the U. S. Geological Survey, while interior details, such as
county and municipal boundaries, river course descriptions, and basin
details were obtained by digitizing appropriate maps. Since absolute
coordinates have been used throughout, all data is compatible and can be
arbitrarily scaled by the main program. Furthermore, the display organ-
ization and underlying algorithms of the program are general enough to be
used with any geographic data base which is organized in the manner
described above.
Water Quality Data
For this demonstration, a special file was prepared by MWRC staff which
provides information on 23 water quality stations in the Huron Basin.
This file includes the primary station number for each station (county
number plus 4-digit sequence number), the absolute latitude and longi-
tude, and the data on flow, temperature, and the concentrations of
chloride, DO, and BOD for a twelve-month period. This information is
selectively extracted by the program and, at the user's option, displayed
in a variety of ways.
-------
Industrial/Municipal Outfall Data
The entire contents of the MWRC master file for one month for the Huron
Basin was provided for the demonstration program. This file was trans-
ferred from magnetic tape to a direct access storage device for use by
the program. Through the facilities of the main program, a unique
logical connection can be made between a selected station and a location
in the file, giving the user access to all the data that exists there for
that outfall. For purposes of this demonstration, only certain selected
items of data can be displayed, but this was an arbitrary choice.
PROGRAM DESCRIPTION
Cartographic Display
The user's primary orientation to the geographic data base is through the
reference map, shown in Exhibit 1. This is a large-scale map of the
State of Michigan, showing county boundaries and the mean courses of
major rivers in the lower peninsula. Whether or not to display county
boundaries is the user's option; he can suppress them if he wishes.
Using this map as the initial reference, the user has several inquiry
options available. He can request that selected portions of the map be
expanded in order to examine certain regions in more detail than is
possible with the large scale map. The resultant expanded area can be
displayed in either the inset mode (Exhibit 2) or the full-screen mode,
shown in Exhibit 3. The advantage of the inset mode is that the expanded
area is shown in reference to the large-scale map and is useful for
initial exploration of regions of interest. A scale of miles (or feet,
if appropriate) accompanies each expansion in order to give some feeling
for the size of the area being examined. The full-screen mode, of course,
provides greater magnification and is the mode most often used during the
data retrieval process.
Detailed inquiry is accomplished by outlining an area of the map and
requesting the desired mode of expansion. The degree of magnification is
a function of the size of the area specified by the user, so that area
expansion may be accomplished in several steps, or by requesting it imme-
diately. Once the desired area has been outlined by the user, a windowing
algorithm in the program discards all parts of the map which fall outside
of the requested area. The degree of magnification which can be obtained
is theoretically unlimited; only the completeness of the geographic data
base determines how far one can practically go.
When the user requests it, the program will display the location of all
effluent monitoring stations within a given basin. The small triangles
in Exhibit 4 show the locations of such stations in the Huron Basin, 144
in all. Once these locations have been displayed, the user can once
again zoom in on a portion of the basin in order to isolate or better
resolve the location of stations. At this point, he is in a position to
request information about these stations, which he does by enclosing
several stations in a rectangle, and entering a code which signifies a
request for data. This procedure will be amplified later in the report.
10
-------
EXHIBIT 1
REFERENCE MAP OF MICHIGAN
11
-------
EXHIBIT 2 EXAMPLE OF INSET BLOW-UP
84 MILES
-------
EXHIBIT 3 EXAMPLE OF FULL-SCREEN BLOW-UP
76 MILES
-------
EXHIBIT 4 HURON BASIN MAP SHOWING EFFLUENT STATION
48 MILES
-------
There are additional features available to the user in the cartographic
display portion of the program. When the degree of magnification becomes
great enough, it is appropriate to display more detail than is evident in,
say Exhibit 4. Such detail is normally suppressed in the interest of
efficiency and speed, but when the user requests it, he can obtain the
sort of geographic detail which is evident in Exhibit 5. Here, riverbank
contours, creek outlines, and major municipal boundaries are shown. When
portions of this map are expanded, the greater interior detail provides
geographic reference points, even for amplification down to several
hundred feet full-scale.
Another feature of the program allows the user to request a map display
in the environment of specified outfalls. That is, he can request by
name that the location of all outfalls belonging to Company X be dis-
played cartographically. Since the data base described previously
contains outfall names and addresses, the file can be searched according
to that attribute, and the corresponding latitude-longitude and terminal
stream descriptor can be retrieved for each file entry which satisfies
the name request. The program selects the geographic data for the appro-
priate basin, displays that portion of the basin or basins which contain
the requested outfalls, and marks the stations with a special symbol, a
star in this case. Exhibit 6 shows the map resulting from a request to
display all outfalls belonging to a large company in the Huron Basin.
There are a total of six such outfalls, but on the scale shown in
Exhibit 6, the five stations in the Walled Lake area (northeast part of
the Basin) all appear to coincide. Incidentally, even if they do coin-
cide, they can be distinguished by their unique primary station number.
Finally, one can request that the location of all water quality stations
in a given basin be displayed. Exhibit 7 shows square symbols denoted by
the location of 23 water quality stations in the Huron Basin.
DATA RETRIEVAL
Industrial/Municipal Stations
Once the outfall locations have been displayed (Exhibit 4) the user can
retrieve certain data about any of the stations shown. As stated earlier,
he simply outlines a group of stations and enters the interrogate mode.
The program assigns identifier tags to the selected stations, with which
the user can refer to individual outfalls. A sub-menu of commands then
becomes available to the user with which he can ask for the following:
I
Primary station number, outfall's division name, mailing address,
and responsible officer
Parent corporation name and address, responsible officer and
organization name for Monthly Operating Report
Outfall name for monthly report and any outfall orders and their
corresponding dates
Names of all parameters monitored at the selected outfall
Again, these data have been arbitrarily selected; in principle, any
portion of the file could be accessed. Exhibits 8 and 9 show the dis-
plays resulting from a retrieval of data on outfalls.
15
-------
EXHIBIT 5 HURON BASIN MAP SHOWING GEOGRAPHIC DETAIL
20 MILES
-------
EXHIBIT 6 MAP SHOWING LOCATION OF ONE COMPANY'S OUTFALLS
4O MILES
-------
EXHIBIT 7
MAP SHOWING LOCATION OF WATER QUALITY STATION
40 MILES
-------
EXHIBIT 8
INFORMATION ABOUT ORGANIZATION QUERIED
8100SS
OUTDOOR MFG. CORPORATION
CHARLEST.CONSULTANT
WYANDOTTE, MICHIGAN 48230
^organization
TRAILERS GALORE COMPANY
1123 W.CAMP STREET
BUTTE, MONTANA 70152
OUTDOOR MFG. CORPORATION
WYANDOTTE (CUPOLA FURNACE)
^outfall information
6' COOLING WATER TO HURON
00144
OS70
fr parameters
TEMPH20F . FLOW-USD . &OD-5
PH , SOU£>SUS,OIL-GRSE
CE-hG/U
(3)
810O54
OUTDOOR MFG. CORPORATION
CHARLES T, CONSULTANT
WYANDOTTE, MICHIGAN 49230
^outfall information
18' PIPE TO HURON RIVER
00144
0570
^parameters
TEMPH20F FLOW-M6D.60D-5
PH SOLJDSUS.OIL-GRSE
C6-MG/L
(4J
810065
CHROMKJM CEREALS COMPANY
2 PEACHTREE STREET
WYANDOtf E, MICHIGAN
CHROMIUM CEREALS - WYANDOTTE
PRETREATED DISCHARGE To SANI
^outfall information
SEWER SYSTEM-YPSILANTI TWP.
^-parameters
IHO PATA)
( ) => name,address
F *> outfall info.
0 => oream'zqtlon
P => parawetera
C -> cle«r
-------
EXHIBIT 9
INFORMATION PLACED IN REPORT FORMAT
HONTMCY PERFORMANCE -OPERATING REPORT
STATION
NUMBER
e 2ooo»
YR.
ASSC
60
S. I.C
CODE
542
ORGANIZATION NAME
STORET -ARAMETER
NUMBER
OUTDOOR T
OUTFAL
NAME
/IANUFACTURI1
L NO. 2
OIL
ACTUAL VALUE
AVERAGE
JG COMPANY
ISMG./L
LIM] T
DTERAT.
REPORTS
.AS
BTO
M
'?
kpTs
r»lfl
M
DATE OF
FIELD AC
su*V Vii
WYR
12&0
flflYft
0269
RATINtl
LAST L.
VCMS
E,
R
rx
A
>
\
D
e
-------
Water Quality Stations
Data on water quality is obtained in a graphical, rather than a narrative
form. There are two forms of graphical display available to the user.
One form involves conventional scientific graphs, while the second is a
new type of display, developed specifically for this project. This is
referred to in the program as the "aerial mode," and involves a perspec-
tive display of selected reaches of a river, as they would appear if one
were in an aircraft looking along the river. Superimposed on this aerial
view are vertical lines which rise from the ground at water quality
station locations and whose heights are proportional to the magnitude of
their parameter measurements. The user can select any basin, or any
stretch of that basin and show for a specified month how any chosen param-
eter varies along the entire reach of the river. The user can even choose
a vantage altitude above the river to optimize the information content of
the display. The great advantage of this type of presentation lies in its
ability to convey a large amount of information at one time. One sees
immediately how a water quality measurement varies along the length of
river miles, but at the same time, the relationship of station locations
to geographic features, like municipalities and tributaries, is clearly
evident. Examples of this type of display are shown in Exhibits 10
and 11.
After obtaining an overview of water quality with an aerial mode display,
one can proceed to the scientific graph mode, where greater detail on
parameter data can be obtained. This mode is entered from a cartographic
display, after a request that the location of water quality stations be
shown. One outlines on the map a group of stations for which data is to
be retrieved. At this point, a request for scientific graphs causes the
program to assign identifier flags to the stations and prompt the user
for the station and parameter he wishes to see presented. A dynamically
scaled graph of that parameter variation throughout the year is displayed,
as well as a sub-menu of further display options that the user can invoke.
For example, he can overlay the measurements obtained at other stations
on the same grid, he can insert labels or remarks on the graph, or he can
request that the entire graph be saved in a direct access file for viewing
at a subsequent time. An example of this type of graph is shown in
Exhibit 12.
DISPLAY EQUIPMENT AND FACILITIES
Time-Sharing Facility
The demonstration computer program has been developed and operated on the
University of Michigan's IBM 360/67 time-sharing system. The program and
data bases reside in disk file devices which can be accessed from any
telephone line. In order to be able to operate at a high-data rate, a
special modem has been used, which allows data to be transmitted to the
terminal at the rate of 120 characters per second. Such a modem
(modulator-demodulator) typically costs $1,000. A picture is shown in
Exhibit 13.
21
-------
EXHIBIT 10 AERIAL VIEW-UPPER REACH
DO-mg/
APRIL
10
N>
r
2C 0
10 0
0.
-------
EXHIBIT 11 AERIAL VIEW - MIDDLE REACH
TEMPERATURE-C
AUGUST
CO
30 0
IS 0
0
-------
EXHIBIT 12 SCIENTIFIC GRAPH OF ANNUAL PARAMETER VARIATION
to
B
0
D
m
Q
/
1
10.0
8.0
6.0
4.0
2.0
0.0
4 =>
1 =>
5 =>
810073
810046
810071
0.0 2.0 4 0
o.O
8
ICO \2 0
MONTH
-------
EXHIBIT 13 DISPLAY-COPY GRAPHICS EQUIPMENT
-------
Display Terminal
The display device which has been used in the demonstration project is a
direct-view storage tube CRT terminal. There are several such terminals
on the market that are relatively inexpensive, and have no local computing
power, i.e., they are passive display devices. Specifically, for this /
project a Computek 400/20 terminal has been used, which has a nominal co^t
of $10,000. Recently, both Computek and Tektronix, Inc. have announced/
the availability of terminals with comparable characteristics with costs
of about $4,000. The interactive display program could be operated from
such low-cost terminals.
Hard Copy Device
Any visual display terminal can be equipped with a hard copy unit which
allows the user to copy the contents of the screen to obtain permanent
records of the session. The Tektronix 4601 has been used in this project,
and costs roughly $4,000. Within eight seconds, a dry, ready-to-use copy
can be obtained at a cost of about seven cents.
Scan Converter
When an interactive terminal session is to be viewed by a large group of
people, i.e., more than three or four, the screen of the display terminal
is too small to permit everyone to see what is being plotted. For about
$2,500 one can obtain a Tektronix 4501 scan converter which attaches to
the terminal and converts the screen's contents to a standard video
format. The video signal can be sent to a group of monitors or a large
screen projector, permitting hundreds of people, if necessary, to view
the program evolution.
A block diagram showing the hardware/software system components can be
found in Exhibit 14.
COMPUTER CONFIGURATION
The WISE system is processed on a Burroughs model B5500 computer operated
by the Michigan State Highway Department. Several factors entered into
the decision to utilize this computer:
The B5500 computer capacity was large enough to handle the data
base and programs planned.
The B5500 software provided the sophistication required for batch
and telecommunication processing.
The particular installation had available time to handle the WISE
processing requirements.
The cost per operational hour and per disk storage segment used
represented the lowest cost for a computer of this size,
configuration, and capability.
The installation was physically very close to the MWRC staff
offices, providing an excellent turnaround and scheduling
capability.
26
-------
BLOCK DIAGRAM OF SYSTEM
GEOGRAPHIC DATA
WATER RESOURCE
DATA
INTERACTIVE
DISPLAY PROGRAM
~1
IBM 360/67 COMPUTER
I I
t f
PHONE LINE
I
COMPUTEK 400/20
TERMINAL
'"I
I
TEKTRONIX 4601
COPIER
m
X
I
CO
-------
The configuration of the B5500 computer used was:
1 - Burroughs B5500 processor
8 - Memory modules (4,096 words/module)
3 - Input/output channels
2 - Disk electronic units
9 - Disk modules (9.6 million characters per module)
6 - Magnetic tape drives
1 - Card reader
1 - Card punch
1 - Data communications control unit
7 - Data communications line adapters
2 - High-speed printers
1 - Supervisory printer
ESTIMATED DIRECT COSTS - INITIAL MASTER FILE SETUP
Prior to beginning the setup of the master file, a thorough investigation
of data sources should be made. All data that will be put into the
master file should be readily available. Generally, the data will be
contained in an existing manual file system or will be available from
enforcement personnel. After exhausting these sources, additional infor-
mation can be obtained from the industry, municipality, or commercial
enterprise. The investigating agency, for example, mailed questionnaires
to organizations to obtain additional data pertaining to the exact
geographical location of outfalls and intakes. After exploiting these
sources, actual on-site inspection by staff personnel will be necessary,
where information is still lacking.
It is important that the mechanics of extracting data from various
sources be determined before the researching and coding process is begun.
Standard practice procedures should be written so that clerical personnel
can make basic determinations without consulting someone for each minor
decision. (See Section VI.) When problems with, or exceptions to,
existing written procedures are encountered, modifications to the proce-
dures should be made to keep them up-to-date.
Depending on the comprehensiveness of the desired master file, certain
information should be known prior to initiating the coding process. The
following items are the information which the master file will accomodate:
*1. The complete mailing address of the highest ownership for a
particular file record.
*2. The complete mailing address of the plant, division, or
outfall.
*3. Information regarding the geographic location of the enter-
prise and its individual outfalls and/or intakes.
4. Exception code, basic criteria for determining the reason(s)
for a record to except.
28
-------
5. Type code, basic criteria for determining this code.
6. SIC code, enough information to properly code this item.
7. Organization code, a logical scheme for assignment of this
code.
8. Identifier: intake (01 - 49), company (50), and outfall
(51 - 99), numbers should be properly used.
9. Date established coded.
*10. Last survey date.
*11. Last visit date.
*12. Tax exemption status.
*13. Order numbers and data pertaining to them.
*14. Judicial action.
*15. Parameter information.
The above items with an asterisk (*) are items of data that will have to
be extracted from available sources of information. Those without an
asterisk are items that will depend on information extracted from other
data sources. These latter items should have procedures clearly outlined
for making coding decisions. (See Section VII.)
To give an estimate of the cost and time needed to establish the master
file, a hypothetical master file and its STORET station setup was made.
The general assumptions made for this hypothetical case are listed first;
other assumptions are included in the sections where they apply. All
assumptions are based on the experience of the investigating agency.
The following general assumptions are applicable to the hypothetical case
here offered:
I. All 15 information items previously enumerated are readily
available and complete, and can be extracted from existing
records by clerical personnel.
II. The master file will have 2,000 records.
III. The records within the master file will be as follows:
A. 300 industries at 5 records each.
1. One site record per industry, with 2 parameters.
2. Four active outfalls or intakes per industry,
with 5 parameters.
29
-------
B. 100 municipalities at 2 records each.
1. One site record per municipality, with no parameters.
2. One active outfall record per municipality, with 10
parameters.
C. 125 commercial establishments at 2 records each.
1. One site record per commercial enterprise, with no
parameters.
2. One active outfall record per establishment, with 4
parameters.
3. 75. of the 125 commercial establishments will have
groundwater discharges.
D. 50 inactive or inventory records, with no parameters.
IV. The only computer time involved will be the initial update and
3 subsequent updates, utilizing the program FAR.
V. Costs do not reflect the setting up of written detailed proce-
dures for the specific situations encountered by other agencies.
VI. Computer and keypunch costs are based on the use of other
agencies' equipment and are being charged back on the actual
time used on a variable pro rata share.
VII. Estimated hourly labor rates include fringe benefits.
VIII. Costs for transferring or modifying load decks and documentation
have not been included in these costs. These one-time costs
will vary by installation.
SUPPLIES REQUIRED TO CREATE MASTER FILE
The following rationale was used in creating this master file, and also
applies to STORET station setup. The following list are those items
assumed to be included on initial setup:
One station setup sheet per record input to the master file. This
includes the following cards with their respective information:
10 card - highest ownership
11 card - highest ownership address
20 card - plant name
21 card - plant mailing address
60 card - key location information, codes, and plant report name
61 card - continuation of plant report name
70 card - outfall name
80 card - parameter information
Commission Action Form @ 20 cards per sheet.
64 card - organization level - 1 per record
84 card - parameter level - 1 per parameter
30
-------
Performance Dates Forms @ 20 cards per sheet.
66 card - performance scheduled - 1 per company record
67 card - performance completed - 1 per company record
Pollution Status and Tax Exemption Form @ 20 cards per sheet.
68 card - rating and tax exemption - 10 per company record
STORET Station Setup:
Forms
Surface water discharge - 3-1/2 forms per station
Groundwater discharge - 2-1/2 forms per station
Cards
Surface water discharge - 8 cards per station
Groundwater discharge - 7 cards per station
STORET setup for stations with parameters only.
Summary of the setup forms to be completed and cards to be punched and
verified:
Forms Cards
rpe of Record
Industrial
Municipal
Commercial
Inventory
Master File
2,025
315
359
59
STORET
5,250
350
363
0
Master File
27,600
4,700
4,375
500
STORET
12,000
800
925
0
ESTIMATED TOTAL 2,758 5,963 37,175 13,725
LABOR COSTS
Labor costs will be the major cost involved in setting up the master file.
If procedures are clearly outlined, if the clerical personnel doing the
researching and coding are chosen with care, and if the files from which
data is to be extracted are in good order, this cost will be minimized.
The supervisor of the personnel doing the actual coding should be the
same person to make decisions regarding items not specified in written
procedures. Exhibit 15 shows the man-hours required to initially set up
a 2,000-record master file.
i
Clerical Personnel
The following estimates are given for researching, coding, and other
clerical time necessary for station setup:
31
-------
EXHIBIT 15
MAN-HOURS REQUIRED TO SET UP
INITIAL 2000-RECORD MASTER FILE
200
400
600
800
1000
1200
1400
1600
MAN-HOURS
-------
Industrial: 3 man-hours per industry
Municipal: 2 man-hours per municipality
Commercial: 1 man-hour per establishment
Inventory: 1/2 man-hour per establishment
The total man-hours would be as follows, for researching, coding, and
other clerical time:
Industrial: 300 industries @ 3 hours = 900 man-hours
Municipal: 100 municipalities @ 2 hours = 200 man-hours
Commercial: 125 establishments @ 1 hour = 125 man-hours
Inventory: 50 establishments @ 1/2 hour = 25 man-hours
TOTAL FACILITIES: 575 TOTAL 1,250 man-hours
for clerical
personnel
Nonclerical or Supervisory Personnel
Nonclerical personnel time is estimated at 20% of the clerical time.
Total nonclerical time is: 20% of 1,250 or 250 man-hours.
Key-punching and Verifying Personnel
Estimated
Operation Total Cards Rate & Cards/hr. Total Hours
Punching 50,900 200
Verifying 50,900 200
TOTAL 509 hours
COMPUTER COSTS
It is assumed that the only computer costs involved during the setup
period will be the cost of updating a master file four times. Each run
will consist of the setting up of 500 new master file records on a batch
run system basis.
The computer costs to other agencies may be quite different from those
encountered by the investigating agency. The "estimated charge time" is
the sum of the process and channel times. For purposes of this computa-
tion, a fixed rate of utilization is assumed. The investigating agency
is charged on the basis of total system operation cost for a particular
month. This cost represents hardware, operator labor, and overhead.
Each user of the system is charged his proportionate share of the entire
cost, based on a ratio of his process and channel time to the total
system process and channel time.
33
-------
File Size Records
Initial 500
1,000
1,500
2,000
Charge Time
Minutes
24
36
48
60
TOTAL 168 Minutes of Computer
Usage
REPORT DISTRIBUTION
It is assumed that the reports will be distributed in the DUMP format,
one record per page. Three copies of each report will be reproduced and
distributed. A separate report will be distributed after each computer
update to allow review of information by staff personnel.
Report Number
1
2
3
4
EQUIPMENT RENTAL
500
1,000
1,500
2,000
Copies
3
3
3
3
Total Pages
1,500
3,000
4,500
6,000
TOTAL
15,000 Pages
rhe only equipment rental that will be necessary for the initial estab-
lishment of the master file will be key punch and key verify machines.
Operation
Punching
Verifying
TOTAL
Total Hours
254.5
254.5
509 Hours
SUMMARY - DIRECT ESTIMATED COSTS - INITIAL MASTER FILE SETUP
Supplies - Cards and Forms
Item
Cards
Forms
Estimated Total
Number
50,900
8,721
Estimated
Rate Per 1.000
$0.89
7.00
Estimated
Total Cost
$ 45
61
Estimated Supplies Cost $106
34
-------
Labor Costs
Type
Clerical
Nonclerical
Key Punch Verify
Computer Costs
File Size Records
Initial 500
1,000
1,500
2,000
Total Man-Hours
1,250
250
509
Estimated
Rate Per Hour1
$3.74
8.92
4.60
Estimated
Total Cost
$4,675
2,230
2,342
Estimated Labor Cost $9,247
Estimated Charge
Time - Min.
24
36
48
60
Estimated
Rate Per Minute2
$1.00
1.00
1.00
1.00
.mated Corn-outer Cot
Estimated
Total Cost
$ 24
36
48
60_
st $168
Report Distribution
Estimated Number
of Pages
15,000
Equipment Rental
Estimated Reproduction Estimated
Rate Per Page Total Cost
$0.02 $300
Estimated Report Distribution Cost $300
Equipment Total Hours Used
Key Punch/Verify
Rate Per Hour
Machine
509 $0.50
Estimated Equipment Rental Cost-
Estimated
Total Cost
$255
-$255
1 The rate is 115% of hourly wage rate for retirement and fringe
benefits.
2 The estimated rate per minute includes hardware, operator labor,
and overhead costs, as computed by the providing agency.
35
-------
TOTAL ESTIMATED COSTS - INITIAL MASTER FILE SETUP
Item Cost
Supplies $ 106
Labor Costs 9,247
Computer Costs 168
Report Distribution 300
Equipment Rental 255
Total Estimated Cost $10,076
For the sake of giving an average cost per record for station setup, the
following calculation is given. It should be emphasized, however, that
the cost of setup will vary according to the time required for research,
the type and extent of the information being set up, and other factors.
Average Cost per Record Setup = $10,076 = $5/record for Initial
2,000 File Setup of 2,000 records
WISE OPERATIONAL COSTS - ESTIMATED ANNUAL COSTS FOR OTHER INSTALLATIONS
The costs of operating the WISE system on an annual basis are estimated
below. These estimates are based on costs to the investigating agency,
and do not necessarily represent costs if the system were installed in
another agency. However, where possible, parameters such as computer
time, man-hours and numbers of forms are given so that hopefully actual
costs for other agencies can be readily computed.
These estimates are based on a master file in the WISE system of approxi-
mately 3,000 records. Using the same ratio of records to facilities that
was used in the previous section on the initial setup, 3,000 records
represent approximately 863 facilities. At various places in the cost
breakdown, other bases for estimation are given. Costs generally will be
given on a monthly estimate. In those cases where an operation is not
carried on monthly, the time period will be indicated, so that an annual
cost may be obtained.
SUPPLIES
Cards - Monthly Basis
No. of Cards Rate/1,000 Cards Cost/Month
8,800 $1.00 $9
Forms - Monthly Basis
Number of
Operator Forms Rate/1,000 Forms Cost/Month
1,000 $19.00 $19
36
-------
WISE OPERATIONAL COSTS
ESTIMATED ANNUAL COSTS FOR OTHER INSTALLATIONS
Month
Number
M 1
M 2
QM 3
M 4
M 5
QM 6
M 7
M 8
QM 9
M 10
M 11
AQM 12
TOTAL
*Cost per
Facility
Supplies
$ 32
32
32
32
32
32
32
32
32
32
32
32
$384
$0.45
* Based on servicing 863
Labor
$ 2,364
2,364
2,367
2,364
2,364
2,367
2,364
2,364
2,367
2,364
2,364
2,375
$28,388
$32.89
facilities
Computer
$ 349
349
394
349
349
394
349
349
394
349
349
490
$4,464
$5.17
Report
Distribution
$ 160
160
160
160
160
160
160
160
160
160
160
160
$1,920
$2.22
Equipment
Rental Charge
$ 169
169
169
169
169
169
169
169
169
169
169
169
$2,028
$2.35
Micro filming
$ 40
40
40
40
40
40
40
40
40
40
40
40
$480
$0.56
Total
$ 3,114
3,114
3,162
3,114
3,114
3,162
3,114
3,114
3,162
3,114
3,114
3,266
$37,664
$43.64
EXHIBIT
-------
Number of
Other Forms
400
Rate/Form
$0.01
Cost/Month
$4
SUPPLIES - Cost per month $32
LABOR
Clerical Labor - Monthly Basis (2 full-time clerks)
Estimated
Man-Hours
350
Rate/Hour
$3.74
Cost/Month
$1,309
Nonclerical or Supervisory Labor - Monthly Basis (20% of clerical time)
Estimated
Man-Hours
70
Rate/Hour
$8.92
Cost/Month
$624
Key-Punch and Key-Verify Labor
Estimated
Man-Hours Rate/Hour
88 $4.60
Cost/Month
$405
Program Maintenance Labor (Programming)
Program Time Per
Runs No. of Jobs Job/Hrs.
Monthly 10
Quarterly 11
Annually 14
0.5
0.5
0.5
Total
Hours
5.0
5.5
7.0
Hourly
Rate
$5.24
5.24
5.24
Cost/Month
$26
29
37
LABOR - Cost per month:
When only monthly reports are prepared $2,364 (M)
When monthly and quarterly reports are prepared $2,367 (QM)
When monthly, quarterly, and annual reports are prepared$2,375(AQM)
-38
-------
COMPUTER
Monthly
Program Run
PAR
TICKLE
HAIR
REMAIN
CERTOP
INFORM
LABEL
AUDIT
SAMPLE
PRIORITY
Runs/Time
Period
1
1
1
1
1
1
1
1
1
1
Chargeable
Computer Time/Min.
90
1
170
22
1
12
1
5
45
2
COMPUTER - Cost per month when only monthly
reports are prepared
Quart erly
Program Run
Runs/Time
Period
DUMP
Chargeable
Computer Time/Min.
45
COMPUTER - Cost per month when monthly and
quarterly reports are prepared
Annual
Program Run
INFORM
LABEL
PRIORITY
Runs/Time
Period
1
1
1
Chargeable
Computer Time/Min.
80
1
15
Cost/Time Period
<§ $1.00/Min.
-$349 (M)
Cost/Time Period
@ $1.00/Min.
$ 45
$394 (QM)
Cost/Time Period
@ $1.00/Min.
COMPUTER - Cost per month when monthly, quarterly,
and annual reports are prepared
REPORT DISTRIBUTION
Monthly Basis
Pages Distributed
8,000
Reproduction
Cost/Page
$0.02
Reproduction
Cost/Month
$160
Report Distribution - Cost per month $160
39
-------
EQUIPMENT RENTAL
Equipment Item Cost/Month
Terminal (LST-ASR 33) $ 65
Key-Punch Machine (88 hours @ $0.50/hour) 44
Microfilm Equipment (Reader/Printer) 60
Equipment Rental - Cost per month $169
MICROFILMING (On job basis by another agency)
Monthly Basis
Estimated Estimated Estimated
Item Description Quantity Rate Cost
Labor Filming & Proofreading 5 hours $6/hour $30
Film Roll Silver 1 roll 4/roll 4
Film Silver Processing 1 roll 6/roll 6
Microfilming - Cost per month $40
WISE OPERATIONAL MAN-HOURS
The estimated man-hours necessary to maintain a 3,000 record (863
facilities) master file are summarized below:
Labor Category Man-Hours/Month Man-Hours/Year
Clerical 350.0 4,200
Nonclerical or Supervisory 70.0 840
Key-Punch/Verify 88.0 1,056
Program Maintenance
Monthly reports (8 times) 5.0 40
Quarterly reports (3 times) 5.5 17
Annual report (1 time) 7.0 7_
TOTAL MAN-HOURS ANNUALLY 6,160
Therefore, the above annual projection represents approximately 8.0 man-
hours /facili ty.
40
-------
SECTION IV
WISE - MANAGEMENT REPORTS
This section describes the management reports prepared by the WISE system,
their use, advantages, and contents. The reports described have been
designed to aid in decision-making, and to help reduce the manual efforts
in paperwork processing. Report features that meet these objectives are:
Performance measurement of waste water treatment plants to help
determine Commission action.
Identification of exceptions (e.g., over standard) to help
determine various district actions.
Capability to selectively retrieve data from the master file
according to the user's need.
Preparation of returnable documents to reduce clerical effort
and provide more accurate input data.
The reports or documents described in detail in the following pages are:
Monthly Performance and Action Report (Exhibit 17)
Monthly Operating Report (Exhibit 18)
WISE - File Dump (Exhibit 19)
WISE - Performance Due Letter (Exhibit 20)
WISE - Audit List (Exhibit 21)
WISE - HAIR Report (Exhibit 22)
WISE - SAMPLE Report (Exhibit 23)
WISE - PRIORITY (Exhibits 24 and 25)
WISE - Facility Grading List (Exhibit 26)
MONTHLY PERFORMANCE AND ACTION REPORT (PAR) (EXHIBIT 17)
Report Use
TheXMonthly Performance and Action Report reflects the decisions of the
Commission and the activities of its personnel concerning specific sur-
veillance and enforcement activities with involved organizations. The
primary use of the PAR report is to identify and report the exceptions
detected in an organization's performance. The factors reviewed for
exception-reporting are: ,
The number of times that parameter tests were over-standard during
the last twelve months.
The parameter tests that did not meet standards.
The parameters that were not reported.
Organizations not visited recently by district staff.
Organizations which have failed to meet performance due dates.
Advantages
The format of the PAR report is based upon the coding structure described
in Section VII. The major code is the primary station number, which
identifies the particular station. The primary station number is a
41
-------
MONTHLY PERFORMANCE ANB ACTION REPORT FOR 1 qTI
STATION
NUMBER
79000(
37000<
370007
820215
26000S
090002
-
Yfi
SET
UP
71
70
70
70
70
69
SI.C.
CODE
621
820
820
281
400
982
P
C
n
f
N
N
N
P
P
F
S
P
ORGANIZATION NAME
STOHET PARAMETER
NUMBER
NAME
F.NFORCEMENT F
ORDER LIMITS
AVERAGE
IEGION I
LIMIT
FIELD ENF. DISTRICT 2 (LANSING)
SAGINAW RIVER
CLARx! PICKLE C
M^.SON
OHPANY INC
r
CLARK] PICKLE cb. ALL OUTfALLS
FORE FARMS INCL 1
MT. PI.EASAHT i 1
PORE
FORE
FARMS AW,
|
OUTFALLS
1
FARMS INC). '
WT. PI-EASANT i 1
SPRAY IRRIGATION TO GROUlmHATER
00630 NO 2 & No 3 j< 1.0
009401 CL 1 < 150
50050J FLOW-MGh '
SCRAPER CHEMICAL CORP.
WESTP
HAT.IA T)IV
IV PtPE TO SC
i
TOOL CR,
00400 |PH l> 6.5|< 9.5
ooS30isoLinsusl « 35
122->0 CE-MG/T, 1 k 15
S0050 FLOW-MODI 1
85003 PHENOWDi* 12 K ?0
I.I i
JONES) HICK AUJ-O. LAUNDRY
GtiArrtVIH 1
DISCHARGE TO G (tOUNDWATE'? j
OSKAR! CITV OF
WASTEWATER TREATMENT PLJU
1
I
OSKARlw.W.T.P. JAC.L OUTFAtlM
1
1
1
1
1
1
1
|
I
1
1
1
i
1
1
1
1
1
1
1
1
1
1
l
OftOTlON
OPRT'O
JIEPORT5.
FOR
LAST 12
MOS
STD
+
o o o
0
1
12
0
12
VK
SUB
(H (D CD
12
'2
IS
i2
'2
DATEOFLAST
FIELD ACTION
sun-
VET
MO|TR
VISIT
uoprR
1.20
n.O
'00
080
090
XXX
120
ANNUAL
RATINGS
A
X
f
X
LAST
S TEARS
-Z
E
A
A
L
I
f
A
E
C
F
r
p
E
COMMISSION
ACTION
T
t
T
F
F
F
F
F
NUMBER
0140<
01441
01.441
01441
01.441.
01.468
DATE
MO|YR
q
1 1
'l
11
M
?
Tr
""1
70
70
70
6->
S
S!
C
C
C
C
C
C
A
S
(
C
C
PERPDmUMCE DUEOATEt
PRELIMINARY
BCO **
uofra
O^i
uofrn
N
FINAL
UOtTR
031
069
Mir 1
uofrR
N
N
START
uofrR
041
089
uo)rR
XX)
N
COMPLETE
jofm
09'
101
TOP
k*OffR
JJ
N
LEOAL
ACTION
DATE
MO |VR
0170
»w
14 H
"T
A"
-------
fundamental part of both the WISE and STORE! systems, and provides the
interface between them. The direct results of this interface are the
following advantages of the PAR program and report.
The PAR program develops actual performance data by comparing
operating data against standards established by the MWRC and
staff. The parameters compared are the STORET pollutant param-
eter codes.
Input is developed for the STORET system as a by-product of the
PAR program.
The PAR program provides analysis for short-range (monthly) use,
while the same input data is retained in the STORET system for
long-term performance analysis.
The PAR report is a management exception report in which varia-
tions from accepted performance are isolated.
The report has been designed and structured for computer prepara-
tion rather than for storage and retrieval through manual
methods.
The report is designed to report Commission actions, construction
plans, and legal actions in a codified and concise manner for
management review.
PAR Report Content
Station
Number: Six-digit Primary Station Number - input to STORET
system.
Yr. Set Up: Last two digits of the year in which the Station Number
was assigned.
S.I.C. Code: Standard Industrial Classification code describing type
of industry. (See Section VII)
Performance Code
One of three codes will precede the STORET parameter code number and
signify:
P - Parameter tested and meets standard.
N - Parameter not tested that month.
F - Parameter tested and fails to meet standard.
The decision to print "P," "N," or "F" will be made by the computer
programs. (Late reports will show parameter as not tested.)
Organization Name
Thirty-four characters have been reserved on each of three successive
lines to record the name of the organization and its outfall description.
If the outfall description is preceded by an asterisk, it signifies that
the current pollution status rating (current year just ended) fell below
the annual rating for the previous year.
43
-------
STORET Parameter Code: The five-digit parameter code followed by the
eight-digit alphabetic abbreviation and by a
five-position field to indicate the value of
the standard assigned to each parameter by
Commission order or other legal action. Such
standard value is displayed as the "average"
as well as the "limit."
The organization is required to submit a Monthly Operating Report
(Exhibit 18) which:
(1) Permits a review by MWRC of the Monthly Operating Report and
records a summary of the organization's performance.
(2) Serves as an input document to the STORET computer program. (The
input to STORET is prepared as a by-product of the PAR program.)
Organization Operating Report
Last 12 Months: Accumulated performance for the last 12 consecutive
months.
Over Standard: Number of months within the last 12 months that the
standard has been violated. Violation of standard
occurs when either the average or limit values have
been exceeded.
Reports Submitted: Number of times within the last 12 months that
operating reports were submitted. Late reports are
charged against the organization. Two reports may
be submitted in the following month to correct the
omission. Such reports must be dated with the
month for which they are submitted.
Date of Last Field Action
Last Survey Date: Month and year of last survey conducted by MWRC
staff.
Last Visit Date: Month and year of last visit by a District Engineer
or other MWRC staff member. Where applicable, the
survey or visit can be associated with a particular
parameter code.
Annual Ratings
Tax Exemption Status code is shown for each organization as:
N - None in effect - eligibility not known.
Y - Eligible to date - in effect.
R - Eligible but rescinded.
44
-------
Annual ratings are shown for each organization (and/or parameter code if
applicable) for the past three years. The computer will retain the
ratings for the past 10 years, and they can be printed upon special
request.
Commission Action
This block of information reflects the action of MWRC in relation to a
particular organization. All Commission actions are initiated with an
order number. This is a sequential number to serve as an index to the
actions taken and to permit the computer to make a mechanical association
between a given order and the incoming field or office reports relevant
to that order.
Order Status: The order may be in one of two conditions, which signify.
R - Staff personnel have been requested on the indicated date to
initiate preparation of the data necessary to support MWRC
action. In this instance, the order number begins with a
letter followed by four numbers (sequential) to indicate a
file has been initiated. This number will be replaced by
the regular MWRC order number at the appropriate time.
C - The data assembled for the order is complete and the file
has been presented to the Commission for action on the date
indicated. This date will not change.
Date: Two dates will be shown affecting the file or the order:
(1) The date on which a District Engineer was given a file and
requested to obtain more information.
(2) The Commission order date (replacing the above information).
This date is permanent and will not change.
Type: Describes one of five types of action that may have been
initiated.
S - Statutory Hearing - Although statutory hearings are, by law,
open to the public, no special notices are served to anyone
other than the affected parties.
0 - Open Hearing - The matter has been deemed of sufficient public
interest to suggest that an open hearing is in order. Interested
parties will be advised of the matter at hand by the appropriate
authority.
V - Voluntary Stipulation - The organization signed a formal agree-
ment accepting the Commission's program and schedule for
corrective action.
45
-------
D - Order of Determination - Used whenever the MWRC receives a
Statement of New or Increased Use.
F - Final Order - Issued by the MWRC:
(1) Where there has been a default in Voluntary Stipulation either
as to schedule or to performance level of facilities.
(2) To abate or correct an existing water pollution problem.
(Public Acts of 1929, Act 245, Sec. 7.)
Performance Due Dates
Action: Three codes indicate the kind of action that initiated
the construction plans.
C - Commission Action (original).
M - Modified Commission Action which indicates a change has been made
to the original required dates.
J - A court order has established the dates.
Preliminary-Final
Start-Complete: These columns show the month and year the construc-
tion activity is required and the date performance
is accepted by MWRC. In the column titled "Actual"
one of three codes indicates:
xxx - One month prior to the required date.
N - In following months, prints until the Commission has accepted
the action of the organization.
129 - The date of acceptance, as December, 1969.
Legal Action
Legal action is initiated when the case has been referred to the Attorney
General. The trial counsel representing the Commission can be either the
Attorney General (handling enforcement or violation of Commission orders)
or a local prosecutor (handling all criminal court actions for violations
of court orders). Applicable law determines when a Commission order is
subject to either administrative or criminal action.
Date: Month and year the Commission received notice of the indicated
action.
Who: Indicates by a letter which office is representing the
Commission.
A - State of Michigan Attorney General.
P - Local prosecutor.
46
-------
What: Indicates the type of legal action.
P - Petition the court for a trial.
T - Case has received a date for trial.
A - Organization has appealed the trial court verdict.
C - Case decided for Commission.
D - Case decided for defendant.
MONTHLY OPERATING REPORT (EXHIBIT 18)
Report Use
The Monthly Operating Report is described in Section VIII, WISE Input
Documents. This report is computer-prepared as a turn-around document
for recording parameter measurements. In addition, it serves as a notice
to the waste treatment plant operator of the required reporting and the
parameters to be reported for that plant.
Advantages
The design of the report as a turn-around document provides the major
advantages of controlled accuracy of input data and reduction of manual
effort for report preparation.
Report Content
See Section VI, Procedure Number 6.
WISE - FILE DUMP (EXHIBIT 19)
Report Use
The File Dump is a report that lists all the data recorded in the PAR
file for an individual organization. The report is used to review and
verify data that was processed against the master file. Since this
report is the only WISE system report with all of the record data, an
additional use is to review historical data in the file.
Advantages
Provides complete information recorded for an organization.
« Provides the last ten years of performance rating codes.
Provides an easy method for information search.
--'' t
Report Content
Location (Code 1)
Region
District
Basin
Enforcement Region
Enforcement District
Muskegon River
1-digit code to designate enforcement region.
2-digit code to designate enforcement district,
7-digit code to describe river basin: (2)
major, (2) minor, (3) terminal stream.
'Same as region.
Same as district.
Name of the river basin (terminal stream).
47
-------
|~FLY ROD AND REEL CORP.
CHIEF EXECUTIVE OFFICER
11 IN. REACH BLVD.
MUSKEGON, MICHIGAN 44444
~1
REEL PLANT NO. 1
JOE LINE
11IS. REACH BLVD.
L_S. MUSKEGON. MICHIGAN 44«5 |
MONTHLY OPERATING REPORT FOR .
THIS IS YOUR MONTHLY REPORT FORM FOR
SEE REVERSE SIDE FOR RETURN MAIL
TO: STATE OF MICHIGAN
WATER RESOURCES COMMISSION
PIMM oMncvro ml *tf!*h OM eopv of ttitt lorm
M UM Mid of wdi fnentti. Tfita raport tiMiM f*Mft
ow LwnJnf offlo* by itw Odi of HM month.
(S4IN COOLING WATER OUTFALL I
FLY ROD AND REEL CORP.-
REEL PLANT NO. 1
If dm is collected onoa daily, enter the value n i DAILY
AVERAGE. II dau a collected more frenantly. compute the
DAILY AVERAGE (arithmetic] ind recort it- In addition
record tho highest velue and lovntt vain* found «di MONTH SUMMARY.
ORDER NO.
PARAM. NO.
NAME
UNITS
^"-v^STD.
:=>
18
19
20
ai
22
23
24
as
2a
27
28
2fl
30
31
MONTH
SUMMARY
< 9-13) 11111
(14-1 Bt 00720
CYANIDE
MG/
0.05
190-M]
1 L 1 1 1 1 1
X
0.15
X
MONTH DAY YEAR
(7B-7«» (7T>7*| <7«-aO)
1 »I3) 11111
114 18) 01025
CADMIUM
UG/L
B
(08^41
1 1 1 1 1 1 1
X
10
X
OUP PUNCH 1M«
13) 11111
MiB) 01040
COPPER
UG/L
IS
[0«-«l
1 i i ( i I i
X
X
X
DUr PUNCH 75-BO
1 >t3) 11111
HUB) 50O60
FLOW MGD.
M6D
OM
{Be«4>
1 1 1 1 1 1 1
X
0.10
X
DUP PUNCH 7WKJ
1 9-131
C14-H)
(BC«41
1 1 1 1 1 1 1
X
X
OUT PUNCH TfrOO
H-131
i«-ta)
1 1 1 1 1 1 1
X
X
Our PUNCH 7B-tM
»-13|
14 IS)
t««-«*i
I i i p i i f
X
X
DUT PUNCH 7»«0
SIGNATURE OF CERTIFIED OPERATOR
CERTIFICATION NUMBER
Z3456789ZY
-------
WISE - FILE DUMP
REGION:
DISTRICT:
BASIN:
1
2
04
0829002
ENFORCEMENT REGION 2
FIELD ENF. DISTRICT 4
MUSKEGON RIVER
PRIMARY STATION NUMBER:
ORGANIZATION NAME:
ORGANIZATION NAME:
OUTFALL NAME:
610001
FLY ROD AND REEL CORP.-
REEL PLANT NO. 1
54IN COOLING WATER OUTFALL
CORPORATE OR HIGHEST NAME
RESPONSIBLE OFFICER:
STREET ADDRESS:
CITY, STATE & ZIP:
FLY ROD AND REEL CORP.
CHIEF EXECUTIVE OFFICER
111 N. BEACH BLVD.
MUSKEGON, MICHIGAN 44444
DIVISION. PLANT OR OUTFALL: REEL PLANT NO. 1
RESPONSIBLE OFFICER: JOE LINE
STREET ADDRESS: 111 S. BEACH BLVD.
CITY, STATE & ZIP: S. MUSKEGON, MICHIGAN 44445
ORC. AND OUT. INFORMATION SECONDARY STATION CODE = 8 2 150 FRRC1 50
- 6 B T MIC CO-NO 10
DATE ESTABLISHED
7
01 70
MD YR
3
*60&10-21
* 60
* 60&61
* 70
*
* 10
4 10
* 11
* u
*
* 20
* 20
* 21
* 21
*******
60&70
8
LAST LAST TAX LAST 10 YR
SURV. VISIT EX. RATINGS
9 10 11 12
ORG
OUT
PAR IB
00720
CYANIDE
01025
CADMIUM
01040
COPPER
50050
FLOH MGD
01
01
02
00
00
00
70
70
70
00
00
00
02
00
00
00
00
00
70
00
00
00
00
00
Y
0
0
0
0
0
AOOOOOOOOO
0000000000
0000000000
0000000000
0000000000
0000000000
ACT & ORD ACT. i
S-T-NUMB DATE *
13 14
C F 11111 01 70
C F 11111 01 70
o o mil oo oo-
o o mn oo oo
o o mil oo oo
o o mil oo oo j
* A
k C
15
c
0
0
0
0
0
**********************************************************************************
PLANS DUE CONSTRUCTION *JUDICL*
PRELIM FINAL START FINISH *WMOYRW*
16
0270 0270 0870 OOOO
0000 0000 0000 0000
* 17 *
0970 OOOO 0671 0000*P0470P*
* *
OOOO OOOO OOOO 0000*000000*
19
AVERAGE LIMIT
R R
20
ST-RS
+ 12
OOOO OOOO OOOO OOOO OOOO OOOO OOOO 0000*000000*
0000 OOOO OOOO OOOO OOOO OOOO OOOO 0000*000000*
0.05
0000 0000 0000 0000
0000 0000 0000 0000
oooo oooo oooo 0000*000000*
* *
* *R
OOOO OOOO OOOO 0000*000000*
0.08
0.15 NN 00
+ 12
10 NN 00
+ 12
30 NN 00
+ 12
0.10 NN 00
************************************************************************************************************************************
oil * 63 * 62 ** 68 ** 64 *** 66 * 67 * 66 * 67 ** 66 * 67 * 66 * 67 * 65 * 80 *
21 * 73 * 72 ** 78 ** 74 *** 76 * 77 * 76 * 77 ** 76 * 77 * 76 * 77 * 75 * *
* 83 * 82
**
**
88
84
*** 86 * 87 * 86 * 87 ** 86 * 87 * 86 * 87 * 85 *
-------
Organization (Code 2)
Primary Station
Number
Organization Name
Outfall Name
Card Number (Code 3)
Corporate Name (Code 4)
Corporate or Highest
Name Responsible
Officer
Street Address
City, State, and
Zip Code
Division Name (Code 5)
Division, Plant, or
Outfall Responsible
Officer
Street Address
City, State, and
Zip Code
6-digit code that identifies the county (2)
and the station (4).
Name of industrial firm or municipality.
Name of the individual outfall for the
organization.
2-digit code that denotes the type of punched
card transaction that produced this data.
Name of corporation. Name of company official.
Address of organization.
Name of city, state, and zip code.
Name of plant. Name of plant official.
Address of plant.
Name of city, state, and zip code for the
plant.
Secondary Station Code (Code 6)
B
T
SIC
CO-NO
I/O
1-digit staff exception code.
1-digit type of owner code.
3-digit Standard Industrial Classification
Code.
5-digit organization identification number.
2-digit code to designate an intake, outfall,
or plant.
Date Established (Code 7)
MO YR
Card, Number (Code 8)
The month and year that this organization was
established on the master file.
2-digit code that denotes the type of punched
card transaction that produced this data.
Organization and Outfall Information (Codes 10, 11, 12, 13)
Last Surv. (9) Month and year of last field survey.
Last Visit (10) Month and year of last field visit.
50
-------
Tax Ex.
(ID
Last 10-Year
Ratings (12)
Action and
Order
S (13)
(13)
NUMB (13)
Act. Date (14)
AC (15)
Plans Due
Preliminary (16)
Final
(16)
Construction (16)
Start (16)
Finish
Judicial
W
(16)
(17)
MO YR
W
Par (18)
Average-Limit (19)
Tax exemption code:
N - None in effect.
Y - Eligible to date in effect.
R - Eligible but rescinded.
Pollution status rating codes for the last 10
years.
Commission action.
Order status:
R - File has been initialed.
C - File has been presented to the
Commission.
Type of action:
S - Statutory hearing.
0 - Open hearing.
V - Voluntary stipulation.
D - Order of determination.
F - Final orders.
5-digit order number.
Month and year of action taken.
Code to indicate the kind of action that
initiated the construction plans:
C - Commission action.
M - Modified commission action.
J - A court order has modified the dates.
Month and year of required and actual due
dates.
Month and year of required and actual due
dates.
Month and year of required and actual due
dates.
Month and year of required and actual due
dates.
Date and codes to indicate what legal action
has been taken.
Code to indicate what action has been taken:
P - Petition the court for a trial.
T - Case has received a date for trial.
A - Organization has appealed the trial
court verdict.
C - Case decided for Commission.
D - Case decided for defendant.
Date of legal action.
Code to indicate which office is representing
the Commission:
A - State of Michigan Attorney General.
P - Local prosecutor.
Parameter code and name for a water pollutant
parameter for this station.
Pollutant parameter standards for each param-
eter indicated for the organization.
51
-------
ST (20) A 2-digit numeric quantity that indicates the
number of months that standards have been
exceeded.
RS (20) A 2-digit numeric quantity that indicates the
number of times during the last 12 months
that reports were submitted.
Card Number (21) A 2-digit code that indicates the type of
punched card transaction that produced
this data.
WISE - PERFORMANCE DUE LETTER (EXHIBIT 20)
Report Use
This document is a computer-printed letter that is sent to an organiza-
tion one month prior to a required performance due date as a reminder of
required action. During the following month, if a report of performance
completed has not been submitted, a PAR exception report is printed and
sent to the District Engineer for follow-up.
Advantage
This letter provides automatic notification and follow-up on performance
due. The notification is based on dates supplied to the WISE system by
MWRC staff.
Content
Mailing address of organization
Month of performance due
Primary station number
Organization name and location
Outfall name
MWRC order number
WISE - AUDIT LIST (EXHIBIT 21)
Report Use
This report is a proof list of the punched cards read into the Audit
program. The Audit program is an edit of the agency, parameter, and
laboratory cards prepared for the STORET system. The Audit List provides
a listing of the cards read with appropriate error messages based on the
edits.
Advantage
The primary benefit for listing these cards is to detect and correct
errors in the cards before mailing them to the STORET system.
52
-------
WXSE - PEKFOBMANCE DIJE, L
EXHIBIT 20
UATUKAl MiCHJICEl COMMISSION
I M. UITAIA
Chairman
CAtl T JOHNSON
lOBttl C. MclAUC-HIIN
AUGUST SCHOUE
HA«RT H. WHITtlEY
STATE OF MICHIGAN
WIUIAM C. MILUKEN, Governor
DEPARTMENT OF NATURAL RESOURCES
ST6VENS T. MASON BUILDING. LANSING, MICHIGAN 43926
RAEPH A. HACMUIU.N. Dir.Ooj
V/ATE9 MSOURCES COMMISSION
JOI'N I. VOGT
Choirmon
STANLEY QIMCKEHBUSM
Vie* Choirmon
OEBAID £. (001
JOHN P. WOOOfORD
)IM GHMQRE
GCO«G£ F. IIODU
JOHN H. KITCHEl, M.D.
CONSOLIDATED FOODS COW.
JOHN DOE
135 S. LASALLE
CHICAGO, ILLINOIS 60603
DEAR SIR:
THIS IS TO REMIND YOU THAT ORDER NO. V00164 OF THE
MICHIGAN WATER RESOURCES COMMISSION HAS REQUIRED YOU TO
START CONSTRUCTION DURING THE MONTH OF APRIL,
1971 OF WASTE CONTROL FACILITIES FOR:
PRIMARY STATION NUMBER:
ORGANIZATION NAME:
OUTFALL NAME:
C300?0
MICHIGAN BANANA PROCESSORS, INC.
ANYCITY
MICH. BANANA PROCESSORS, INC. - ALL OUTFLS
PLEASE PRESENT THE REQUIRED INFORMATION TO:
MICHIGAN WATER RESOURCES COMMISSION
STEVENS T. MASON BUILDING
LANSING, MICHIGAN 48926
THANK YOU FOR YOUR ATTENTION.
VERY TRULY YOURS,
MICHIGAN WATER RESOURCES COMMISSION
MIC'MI.G'AW
-
....
CHIAI I
iA«r ^>
F. B. FROST
CHIEF ENGINEER
53
-------
WISE - AUDIT LIST
JOB CONTROL CARD
COLUMN ERRORS UNDERSCORED
THIS IS A JOB CARD WITH ERRORS
1 .... 2 .. .3 . 4 . .
XX XXXXXX X XXX XX
6 .
FIRST CARD ASSUMED JOB CARD WITH ERRORS
AGENCY CARD
PARAMETER CARD
THIS IS AN AGENCY CARD. DESIGNATED BY COLUMN 80
.1... .2... . 3 . . . . 4 . . ..5. ...6. ...7...
:?:, 0001000300003100040000500005300051500535000950067100665006200061000605
1 2. 3. 4. .5 6. 7
14
10
0
300
0
310
0
400
0
PARAMETER CARD, CONTINUED
500
0
530
0
515
0
535
0
95
0
671
0
665
0
620
0
610
0
605
0
00410009000094000070009150092500930009350104500945009500105532730010320106500720
1 .2 3 . 4. .5 6 7 .8
30
10 300
900 940
310
70
400
915
500
925
530
930
515
935
535
1045
95
945
671
950
665
1055
620
32730
610
1032
605
1065
410
720
DIP CARD
D:,:490006:
1
,7003301200.1.12.9.3.3.7.7.16'. 59,105.30 160,0.01,11 0.20.
2 3. .4. ..5. .6. 7
DIP CARD, CONTINUED
13 6 12.000 610.000
14 47 12.000 605.000
22 51 12.000 935.000
30 25 23.000 720.000
PARAMETER VALUK(S) EXCEED BOUNDS 610
DIP CARD :D:,:770003:
0.07.0.5.80.95,2.23,..
0.000 9.900
0.000 9.000
0.000 9.000
0.000 0.990
605, 935, 720,
,7003301345,1,10.8,3.6.7.6.129,19,110,14,170,0.01,0.03,0.15,
.2. .3. .4.. 5. .6. 7 .8
DIP CARD, CONTINUED
13 6
14 47
22 51
30 25
PARAMETER VALUE(S) EXCEED BOUNDS 610,
DIP CARD :D:,:210010:
1 .
12.000
12.000
12.000
6.500
0.07,0.5,72,95,2,6.5 24,. ,00
610.000
605.000
935.000
720.000
0.000 9.900-
0.000 9.000
0.000 9.000
0.000 0.990
605, 935, 720,
,7003301430,1,12.9,2.6,7.9.174,4,170,,260,0.01,0.03,0.25,
2. 3. ..4. .5. .6. 7
DIP CARD, CONTINUED
13 6
14 47
22 51
27 50
30 25
0.11,0.2,120,125,1,2.0,,
12.000 610.000 0.000
12.000 605.000 0.000
12.000 935.000 0.000
120.000 32730.000 0.000
2.000 720.000 0.000
PARAMETER VALUE(S) EXCEED BOUNDS 610, 605.
DIP CARD :D:,:210011:
9.900
9.000
9.000
99.000
0.990
935, 32730, 720,
.7003301500,3,13.5.4.7,7.9,150,5,145,.210,0.00.0.03,0.25.
-------
WISE - HAIR REPORT (EXHIBIT 22)
Report Use
The HAIR (Hierarchical Information Retrieval) program provides for data
retrieval based on combinations of the 64 retrieval codes. The program
provides reports in three formats:
PAR - Report (Exhibit 17)
WISE - File Dump (Exhibit 19)
HAIR - Time-Sharing Retrieval Report (Exhibit 22)
All of the three reports have the same general use, which is to provide
selective retrievals of data from the master file.
Advantages
The advantages of the three reports are more accurately described as the
advantages of the HAIR program.
Selective extraction and printing of data from the master file.
Conditional analysis listing based on retrieval codes.
Capability to select all records or parts of records that match
a variety of codes input by the user.
The amount of printing can be controlled by the user to limit
the printing of bulky reports.
The method of operation provides for on-line printing, if needed.
WISE - SAMPLE (EXHIBIT 23)
SAMPLE is the name given to the program module which checks those
stations (pre-established, fixed-point sampling stations) not sampled
according to a pre-established time schedule.
In the investigating agency's monitoring programs, there are stations
that are sampled monthly, quarterly, twice annually, and annually. Moni-
toring stations that are to be sampled require a periodic response. In
this way, if a sampler does not enter a visit card for a station he
samples, the following month when the SAMPLE master file is updated, that
station will except.
SAMPLE input documents are the'same format as those used for the
Performance and Action Report.. The output report is shown in Exhibit 23.
WISE - PRIORITY
PRIORITY is the name given to the program module of the WISE system that
calculates the Municipal Construction Grant priorities for the Sewage
Works Construction Grant Program under the Federal Water Pollution Act of
1966, as amended, and under the State of Michigan Act 329, Public Acts of
1966, as amended.
55
-------
EXHIBIT 22
PARTIAL INFORMATION CONTAINED ON HAIR RETRIEVAL REPORT
(FROM AN ASR-33 TERMINAL IN CONVERSATIONAL MODE)
GOOD AFTERNOON.
YOU ARE NOW CONNECTED TO THE MICHIGAN WATER RESOURCES COMMISSION
ENFORCEMENT INFORMATION SYSTEM - HAIR - (H)IER (A)RCHICAL (I)NFORMATION
(R)ETRIEVAL.
AFTER EACH QUESTION MARK YOU MUST TYPE THE REQUIRED ANSWER AND FOLLOW
IT BY PRESSING THE LEFT ARROW. IF FOR ANY REASON YOU MISH TO ABORT,
AND THE TERMINAL IS TYPING, USE THE BREAK KEY. IF THE TERMINAL IS NOT
TYPING PRESS THE CONTROL SHIFT KEY AND TYPE THE LETTER E. IF YOU MAKE
A TYPING ERROR YOU MAY DELETE CHARACTERS BY TYPING A SINGLE QUOTE
(SHIFT 7) FOR EACH CHARACTER YOU WISH TO DELETE. AN ENTIRE LINE MAY BE
DELETED BY ENTERING AN EXCLAMATION POINT (SHIFT 1).
DO YOU WISH INSTRUCTION ON THE USE OF HAIR (YES OR NO).
?NO-
DO YOU WISH TABLE OF SUPPRESSION CODES (SO TO BE
TYPED (YES OR NO).
?YES*
(00) H EADING AN D DATE
(00) PRIMARY STATION NUMBER, OUTFALL, NAME, ORGANIZATION NAME
OPTIONAL ORGANIZATION NAME, DATE ESTABLISHED.
(10) MAILING ADDRESS (OWNER, RESPONSIBLE PERSON, STREET ADDRESS,
CITY, STATE AND ZIP CODE).
(20) OUTFALL MAILING ADDRESS (OUTFALL MAI LTD, ATTENTION OF STREET
ADDRESS, CITY, STATE AND ZIP CODE).
(30) PRIMARY STATION NUMBER, RIVER BASIN NUMBER, SECONDARY STATION,
REGION NAME, DISTRICT NAME, RIVEfl BASIN NAME.
(40) ORGANIZATION NAME, OPTIONAL ORGANIZATION NAME.
(41) LAST VISIT DATE, LAST SURVEY DATE, ANNUAL RATINGS
FOR LAST TEN YEARS TAX EXEMPTION.
(42) ORDER TYPE, ORDER NUMBER, DATE OF ORDER, STATUS OF
ORDER.
(43) PERFORMANCE DUE DATES, WHO SET DATES, PRELIMINARY
PLANS (REQUIRED, ACTUAL), FINAL PLANS (REQUIRED,
ACTUAL), START CONSTRUCTION (REQUIRED, ACTUAL),
FINISH CONSTRUCTION (REQUIRED, ACTUAL).
(44) LEGAL ACTION WHO INITIATED, WHAT LEGAL ACTION,
DATE OF LEGAL ACTION.
(50) OUTFALL NAME, ORGANIZATION NAME, OPTIONAL ORGANIZATION NAME:
(51) LAST VISIT DATE, LAST SURVEY DATE, ANNUAL RATINGS
FOR LAST TEN YEARS TAX EXEMPTION.
(52) ORDER TYPE, ORDER NUMBER, DATE OF ORDER, STATUS OF
ORDER.
(53) PERFORMANCE DUE DATES, WHO SET DATES, PRELIMINARY
PLANS (REQUIRED, ACTUAL), FINAL PLANS (REQUIRED,
ACTUAL), START CONSTRUCTION (REQUIRED, ACTUAL),
FINISH CONSTRUCTION (REQUIRED, ACTUAL).
(54) LEGAL ACTION WHO INITIATED, WHAT LEGAL ACTION,
DATE OF LEGAL ACTION.
(60) PARAMETER INFORMATION:
(61) PARAMETER NUMBER, PARAMETER NAME, LIMIT AVERAGE,
56
-------
MONITORING PROGRAMS MONTHLY SAMPLE REPORT
1971. DECEMBER
STATION
NUMBER
580073
a
ye
₯
13
c
ui
a.
N
N
N
N
N
N
N
N
N
N
STATION NAME
PA^AMEETEft WATER °»AL.TY LIMITS
NUMBER
NAME AVERAGE LIMIT
ENFORCEMENT REGION 1
FIELD ENF. DISTRICT 1
BASIN NUMBER 0836100
OTTER C
R. AT GOUIZ ROAD BRIDGE
BACKGROUND WATER QUALITY
YEARLY
00010
00310
TEMPH200
BUD-S
00400 PH
00530
00665
00720
008-10
01032
01090
31504
SOLIDSUS
P-TOT
CYANIDE
CL
CR6-UG/L
ZINCUG/L
CULI-TMF
0
O
0
0
0
0
0
0
0
0
11
11
11
11
IT
11
IT
11
11
11
3ATE OF LAST
FIELD ACTION
VISIT
MOJYR
XXX
z
; In QUARTER
* HEO
MOJYF
ACT
MO|Y
PERFORMANCE DATES
2nd QUARTER
REQ
MO
Y
ACT
MO|Y
3rd QUARTER
REQ
MO|Y
ACT
MO|Y
4th QUARTER
HEQ
MO|Y
ACT
MOJY
m
X
5
-------
Under Act 329, the investigating agency is charged with the responsi-
bility of assigning the priorities for construction grants. This law
sets down the methodology for computation of the priorities. The essen-
tial input to the calculation of the priority points is shown on the
computer input document (Exhibit 24).
The computation of the priority points is independent of other elements
of the WISE system. Applications for grants are received, along with
supporting documents, by agency staff. A considerable amount of staff
time is spent investigating the data submitted. When all the investiga-
tive steps are completed, the data for each application necessary for
calculation of the priority points assembled and priority points are
assigned in accordance with Act 329. When the priority points have been
calculated and final points set, the agency must submit to the Legislature
by January 15, those sewage treatment projects eligible for grants, and
the points and priorities assigned.
After approval of the list of eligible projects by the Legislature,
monies available, both Federal and State, are distributed to the various
eligible projects on the basis of the approved list.
In working with the grant applications, it is necessary to have various
cross-references to the priority list. These are added features of
reports produced by PRIORITY.
Actual computer runs of PRIORITY are made as applications are processed,
so that a current list of completed applications is available throughout
the year. (See Exhibit 25.) Since the final date for submission of
applications is September 15, computer runs of PRIORITY are made between
September 15 and the legislative deadline, January 15.
PRIORITY is a fairly uncomplicated program, and will be useful to the
investigating agency because it eliminates tedious, repetitious calcula-
tions .
FACILITY GRADING SYSTEM
This program module is used to search the past history performance by an
organization, and assign points based on this performance for the develop-
ment of a letter grade. The District Engineer has the opportunity to
adjust the computed points based on his knowledge and judgment of the
organization. After the District Engineers have reviewed the listing
(Exhibit 26) and adjusted points accordingly, the letter grade is deter-
mined and assigned to the organization.
This program performs the clerical work of reviewing an organization
usually done by the District Engineer. Each outfall is examined for the
following:
Water quality
. Number of parameters examined
. Number of parameters failed
Flow violations
Number of Monthly Operating Reports not submitted
Performance on required construction dates
Past three years' performance
The results are computed to provide the points for each outfall.
58
-------
EXHIBIT 24
PRIORITY POINT CALCULATION INPUT FORM
WPC - MICH! i_
PRIORITY POINT CALCULATIONS . 1
PRIMARY STATION NUMBER I I
NAME
12
LOCATION I i i i i i i i i i
« go; 71
A. POINTS ON BASIS OF FINANCIAL NEED; 0 (CARD 2. DUP. COL. 1 - 5)
(1) TREATMENT WORKS CONSTRUCTION COST/CAPITA
ESTIMATED PROJECT COST $ I i i i I - $ PER/CAPITA
DESIGN POPULATION
-
$5.00 $5.00
(2) DEBT OBLIGATIONS/CAPITA
x 0.2
DEBT - $ I 'I =$ DEBT/CAPITA
1970 POPULATION L
33
DEBT/CAPITA x 02 = $-
n
$5.00 $5.00
(A) SUBTOTAL
B. POINTS ON BASIS OF WATER POLLUTION CONTROL NEEDS:
(1) TOTAL ELIMINATION OF WASTEWATER DISPOSAL TO WATERS OF THE STATE.
(2) POLLUTION CAUSED INJURY WHICH WILL BE CORRECTED OR SUBSTANTIALLY
LESSENED BY PROJECT.
d. PUBLIC HEALTH. SAFETY OR WELFARE BUT NOT INCLUDING BATHING. Q
b. PUBLIC WATER SUPPLY FOR DOMESTIC USE. O
^. WATER SUPPLY FOR COMMERCIAL OR INDUSTRIAL USE. CH
d. IRRIGATION OR LIVESTOCK WATER SUPPLY FOR AGRICULTURE USE. LZ1
a. ORGANIZED PUBLIC RECREATIONAL USE INCLUDING BATHING. [ZJ
f. AESTHETIC VALUE OR UTILITY OF RIPARIAN LANDS. [ZJ
g. WATER SUPPLY FOR WILD ANIMALS, BIRDS, FISH AND ADVERSE EFFECTS ,,
ON AQUATIC LIFE OR PLANTS LJ
h. USEFULNESS OF FISH OR GAME FOR HUMAN CONSUMPTION. LJ
(3) ORDER STATUS:
COURT ORDER. ADMINISTRATIVE ORDER. STIPULATION OR AGREEMENT LZ1
61
(B) SUBTOTAL
B2 B3 '80'
I , I (RESET PRIORITY WITHIN TIE) 0] TOTAL POINTS
59
-------
PRIORITY LISTING
ORDER
OF
PRIORITY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
PROJECT
NUMBER
WPC-MICH
0012
0018
0004
0015
0009
0020
0011
0017
0001
0010
0019
0005
0014
0007
0002
0003
0008
0013
0016
0006
APPLICANT
MUNICIPAL TREATMENT PLANT-MUDV
MCDONALD MIXER-LIBERTY PA
FREUS OFFICE-COMPREHENSIVE STU
BUCHKO BLENDER-KRAKOW
SCHAFER SILO-WESTPHALIA
LAST ONE-RIGHT HERE
GRIMACE EXCHANGE-NORTH AMERICA
DROSTE DRAIN-LANSING
VILLAGE OF MELANCHOLIA-NAUSEA
LONG BINH CONNEXION-VIET NAM
WWTP-CITY, STATE, ZIP
CITY OF SYNTAX-ORIGINATION-CLA
MORLEY MIXER-OESTERLES PASTURE
THOMPSON CESSPOOL-OUTER SLABOV
MALAISE-ENNUI COUNTY
BIG DEAL-4TH FLOOR MASON BLDG.
BIG INTERCEPTOR-BIG TOWN, USA
GEUNTHER GRINDER-MICHIGAN
ZOLLNERS ZENITH-ZURICK
CHOMSKY DRAIN-BOLIVIA
$
$
$
$
$
$
$
$913
$
$ 7
$
$
$
$
$
$ 4
$123
$
$ 4
$
rKUjn,^ J
COST
ESTIMATE
937,129
971,296
7,123
19,763
312
35
12,976
,417,965
237,422
,934,611
471,939
12,345
1,979
10,000
79,132
,121,279
,456,789
631,792
,712,932
123
FINANCIAL
A
135.8
27.9
284.9
0.0
6.2
0.2
17.3
91.3
12,9
9.8
188.7
4.0
4.1
0.4
0.2
1.2
6.2
0.1
4.2
0.0
1
0
0
77
999
706
0
0
0
1
1
0
1
2
0
0
0
0
0
0
fKlUKllY r U 1 N T 5
NEED SUB POLLUTION NEED
B
.0
.0
.4
.7
.9
.1
.4
.0
.=>
.4
.7
.4
.6
. 5
.0
.0
.0
.0
.4
.0
TOTAL
15.0M
15. OM
15. OM
15. OM
1 5 . OM
15.0M
1 5 . OM
15. OM
13.5
11.3
15. OM
4.4
5.7
2.9
0.2
1.2
6.2
0.1
4.6
0.0
C
1
1
1
2
0
1
1
0
0
2
1
2
1
2
0
1
0
0
0
0
D
10
11
9
7
8
8
8
7
7
9
7
12
9
16
7
5
/!_
6
0
0
E
2
I
1
1
1
1
I
1
2
1
0
3
2
2
3
3
0
1
1
0
F
2
1
1
1
2
0
0
1
I
0
0
I
1
1
0
0
0
2
1
4
SUB
TOTAL
15
14
12
11
11
10
in
9
10
12
8
15
13
15
10
9
4
9
2
4
C RAND
TOTAL
30.0
29.0
27.0
26.0
26.0
25.0
25.0
24.0
23.5
23.3
23.0
19.4
18.7
17.9
10.2
10.2
10.2
9. 1
6.6
4.0
STATE OF MICHIGAN
WATER RESOURCES COMMISSION
SEWAGE WORKS CONSTRUCTION GRANT PROGRAM UNDER THE
FEDERAL WATER POLLUTION CONTROL ACT, AS AMENDED
AND
ACT 329, PUBLIC ACTS OF 1966, AS AMENDED
1970-71
PRIORITY ASSIGNMENT IN ORDER OF PRIORITY
DECEMBER 27, 1971
* * * * ****** ft ******** 4
KEY TO POINTS FOR FINANCIAL NEEDS:
COLUMN A - PROJECT CONSTRUCTION COST PER CAPITA
COLUMN B - DEBT PER CAPITA
KEY TO POINTS FOR POLLUTION CONTROL NEEDS:
COLUMN C - TOTAL ELIMINATION OF WASTEWATER
DISPOSAL TO SURFACE WATERS
COLUMN D - POLLUTION INJURY CREATED
COLUMN E - ORDER STATUS
COLUMN F - VOLUNTARILY ADVANCED PROJECT
i
-------
FACILITY GRADING LIST
STA NO OUTFALL NAME
060020 POND, J. , DBA POND INC.
060021 SMITH, K. , CAR WASH
060022 TOVID, CITY OF
060023 SCHAFER, C. LAUNDROMAT
060024 GUENTHER DAIRY CO.
070009 MCCRACKEN CORP.-OSLAR
070010 BUDA POWER COMPANY
070014 BUDA POWER COMPANY
070015 MCCRACKEN CORP.-OSKAR
070016 BITTNER, VILLAGE OF
070017 FERRIO, VILLAGE OF
070018 BUDA POWER COMPANY
070019 BUDA POWER COMPANY
070020 BUDA POWER COMPANY
070021 BITTNER, VILLAGE OF
080003 HINSHCN, R. -THOMPSON
080004 THOMPSON ALUMINUM PRODUCTS INC.
080005 THOMPSON MANUFACTURING COMPANY
080007 CHAFFIN CORP. -IONIA
080008 KENNEDY, G. LAUNDRY
080009 JONES, M., CARWASH, THOMPSON
080010 CLARK & CHENEY
080012 HINSHOK R. - THOMPSON
080013 THOMPSON MANUFACTURING COMPANY
080014 THOMPSON MANUFACTURING COMPANY
080015 THOMPSON MANUFACTURING COMPANY
WATER
SUB
20
11
6
3
10
6
13
6
QUALITY FLOW VIOL MISSED RPTS PERFORM DATES
FAILS PTS HUM PTS NUM PTS MISSED POINTS
100
100
100 1 -25
100
100
100
100
11 45 5 -15 4 -10
100
100 6 -15 1 -25
100 6 -15 I -25
100 1 -2
100
100 3 -7
100 3 -7
100
100
100
100
100
100
100
100 2 -5
100 6 -15
I 92 17 -42
100 6 -15
HIST TOT ADJ FIN'AL
PTS PTS PTS PTS
100
100
75
100
100
100
100
20
100
60
60
98
100
93
93
100
-5 95
100
-5 95
100
100
-5 95
95 r
)
85 j
50 <
85
-------
SECTION V
OPERATIONAL PROCEDURES AND EQUIPMENT
COMPUTER-PREPARED DOCUMENTS
Computer-prepared documents are reports that have been printed by the
computer and are subsequently used as input documents. The benefits
gained in the use of these "turn-around" documents are the procedural
control and the reduction of clerical effort.
Procedural control is established by:
Document controls that provide a check on the number of reports
issued and the number of reports returned. An indication of
missing reports is developed by processing the input documents
against the master file.
The preprinting of nonvariable headings data for the computer-
prepared documents. Major control is exercised over the
accuracy of input data by reducing the amount of posting,
recording, and transcription of data.
Clerical effort is greatly reduced through the same process by the
reduction of the amount of data to be recorded on the documents and by
the elimination of the look-up of various codes, user numbers, names,
addresses, etc.
An additional possibility for computer-prepared documents is the capa-
bility to read the documents back into the computer through optical
character reading (OCR) equipment. The data to be read, however, must
be of a type font acceptable to the OCR reader. The present B5500 high-
speed printer type font cannot be read by the OCR reader available. An
OCR equipment evaluation is documented in this Section.
The MWRC's method for reporting industrial and municipal effluent quan-
tity and quality is part of the computerized WISE system. This reporting
requires the standardization and recording of document format. The
Monthly Operating Report (Exhibit 18) has been designed as a "turn-around"
document to control the accuracy of input. This document has the fol-
lowing information preprinted on it by the computer:
Organization name and address
Primary station number
Secondary station number
Enforcement district number
Order number
Parameter number
Parameter name (abbreviation)
Parameter units of measurement
Parameter standards
Certified operator name
Certification number
63
-------
The Certified Operator records the water quality measurements for the
station parameter and returns the document by mail. The document is
audited for errors and omissions, keypunched, and processed against the
PAR master file. An exception report is immediately printed for stations
not reporting, parameters not tested, and parameters tested that exceeded
standards. The Monthly Operating Report is operational for both indus-
trial and municipal reporting, and has proven successful in controlling
the accuracy of input data.
OPTICAL CHARACTER READING
The laboratory input documents from water quality monitoring programs and
Monthly Operating Reports have been reviewed from two major aspects:
The capability of using computer-prepared, "turn-around" documents,
preprinted with all the static data fields, for easy reference
and reduction of manual effort. Variable data would then be
added to the forms returned to data processing.
The capability of using optical character reading (OCR) techniques
to process the major source documents, thereby eliminating the
transcription of documents to punched cards.
The OCR installation at the Michigan Department of State was reviewed to
obtain the following information:
Type of equipment in use
Reading techniques available
Cost of processing
Special requirements of their OCR equipment
The Department of State is using Recognition Equipment Inc. readers and
peripheral equipment. The entire system is linked together as an input
processing system where input documents scanned are placed on magnetic
tape for computer processing. During the reading-scanning process the
records are edited according to programs supplied for each record type.
The complete input processing system consists of the following equipment:
Document reader
Page reader
Magnetic tape output
High-speed printer
SDS-910 - 32,000 byte computer for editing
Typewriter console for input control
The equipment has the capability of reading typed documents in the
following sizes:
Documents - 4-1/2 X 8-1/2 - 2 lines per document
Forms - 8-1/2 X 11 - 40 lines per form
« Free-form typing - 8-1/2 X 11 - 20 lines per form
64
-------
The reading capacity per line is 96 characters. The effective reading
speed per type of document is estimated to be:
600 documents per minute (4-1/2 X 8-1/2 size)
1,100 preprinted forms per hour
700 free-form documents per hour
This system has the additional capability to read mark-sensed cards;
however, this feature is not currently in use.
The cost of processing on a service bureau basis at this OCR installation
has been quoted as approximately $100 per hour for machine time to read
the forms and write them on magnetic tape. This fee does not include any
specialized edit programs or forms cost.
This system requires that all input documents and forms be typed on an
IBM Selectric typewriter because of the type font used. The B5500 high-
speed printer type cannot be read by this system. If mark-sense cards
were used, the system would require testing and checking to ensure that
this equipment feature is functional.
While the use of OCR equipment requires that specific input machines and
techniques be used (Selectric typewriters with 1403-22 type font) the
benefits are also very specific. The benefits are lower cost, lower
error rate, and high-speed data conversion. The optimum use of OCR is
derived when computer-prepared "turn-around" documents are read back
through the OCR reader with the variable data entered. Because of OCR
requirements, it is recommended that the Commission use OCR equipment
only if the following conditions exist:
MWRC volume is large enough to justify their own readera volume of
approximately 10-15 key punchers and key verifiers.
The equipment capabilities of either the B5500 high-speed printer
or the Michigan Department of State OCR reader were changed to
read the high-speed printer characters. The variable data would
be typed by an IBM Selectric typewriter with the same type font
as the printer.
KEY-TO-TAPE
-^~-«___ i
Another alternative input system reviewed was the keyboard-to-tape input
system. This system provides for key-encoding from original source docu-
ments and transferring the data to magnetic tape. The review covered
only the key-to-tape units since this unit is most adaptable to low-volume
installations. Characteristics of the key-to-tape system are:
Variable record size (i.e., over 80 characters)
Capability to verify, search, and read the tape
Program control for formatting
Hard copy output (some machines)
Magnetic tape output
CRT displays (some machines)
65
-------
The costs of the different units reviewed range in purchase price from
$5,000 to $9,500, and in monthly lease price from $50 to $195 per unit.
The major .advantages of the key-to-tape unit over the key-punch unit are
the increased efficiency (up to 30%), variable record size, and the quiet
operation where noise is a problem.
Since the input data volume is not large at the present time, it is
recommended that the Commission continue to use key-punching as the input
means. As the key-punch volume expands beyond the capacity of one girl
per month, the key-totape method of input is recommended to gain the
increased capacity and speed.
ENFORCEMENT FILES
Present Filing System
Enforcement files on waste water discharges are now maintained for
correspondence, field trips, field operating reports, and actions taken
by the MWRC. The files are maintained in alphabetic sequence and sub-
divided into the following groups:
Industrial ,
Miscellaneous, schools, Federal
Drains, parks
Municipalities
Commercial
Lakes and streams
Litigation
Industrial blueprints
The file volume is large, with an estimated 250,000 documents in the
files and an estimated 1,000 documents added each work day. The ^active
files are purged into the historical files in a three-year cycle.
Because of the volume of daily filing, filing media is usually back-
logged, and filing errors are common. The size of many individual files
makes duplication or copying very difficult and expensive. Because this
file is access-oriented and approximately 100 staff personnel have access
to the files, there is a problem in controlling materials removed from
the file. As a result, confidence in the accuracy of the enforcement
files is low. Administrative procedures for file control of documents
removed or referenced are needed.
Microfilm Systems
A microfilm system is a means of eliminating problems in controlling the
materials. To be adaptable to the particular requirement of the enforce-
ment files, the type of microfilm must have the following advantages:
Capability to update and add to an individual file. ,
o Capability to retrieve any or all documents from an individual file.
66
-------
Capability to easily duplicate the files for district office use.
Capability to reduce filing errors and eliminate the problem of
lost documents or files.
Capability to provide sufficient confidence in the microfilm file
to eliminate the manual files entirely after an appropriate
backup period.
Capability to print a hard copy from a microfilm file.
Other features, such as space reduction, are not especially critical to
this application. The types of microfilm reviewed were:
Roll film
Cartridges
Microfilm jackets
Microfiche
Aperture cards
Microfilm jackets and aperture cards are the only types adaptable to
selective updating, which is a major requirement for this file.
Microfilm Jackets
Microfilm jackets are 4X6 clear mylar covers that retain 40 images or
documents per jacket. Other sizes and capacities are available. Micro-
film jackets would provide all of the features described plus the
permanent protection for the film offered by the jacket cover. In
addition, file security is provided by the capability to easily retain
a duplicate file. The processing steps for microfilm jackets would
involve:
Filing media preparation.
Filming and developing at the Record Center.
Viewer-filler insertion of microfilm in jackets.
Duplication of jackets.
Manual filing of jackets.
Emphasis must be placed on administrative control of the microfilm files
to ensure continued accuracy in the clerical filing operation. Proce-
dures have been documented for this purpose.
Aperture Cards
Aperture cards are punched cards with a 35mm film insert to retain 1, 8,
or 16 document images. Aperture cards would provide the necessary
features plus automatic retrieval when punched-card equipment is used.
However, because the aperture card would hold a maximum of sixteen docu-
ments, the number of aperture cards would be approximately three times
greater than the number of microfilm jackets. Although the processing
time and cost is less than microfilm, the initial equipment is more
expensive because a special camera must be purchased. In addition,
individual aperture cards cannot be updated. A new card is created for
67
-------
the documents to be filed that day, and this would create even more cards,
since new material cannot be added to a card with a single document, once
filmed. Aperture cards are most applicable when a single document or
engineering print is being microfilmed. It would seem that aperture cards
are not the most adaptable for this application.
Microfilm
The benefits of using microfilm for retention of the enforcement files
are summarized here as a basis for the recommendations that follow:
1. The microfilm jacket is the modern file folder because of its capa-
bilities to save space, maintain file integrity, and provide random
access to the file.
2. The microfilm jacket is a file folder that permanently protects and
provides a means to reproduce its indexing and all of its contents.
3. The microfilm jacket and contents are inexpensively duplicated and
the master jacket never leaves the file, thus providing complete file
control.
4. Although file space is not a major factor, the microfilm jackets will
reduce file space requirements by approximately 98%.
5. Jackets handle like cards, and are easily retrieved by manual methods,
or by electro-mechanical equipment.
6. Jackets provide rapid filing and updating of the file with filler
rates estimated at up to 10,000 documents per hour.
7. Microfilm jackets are flat, providing high-quality viewing or
duplication.
8. Jackets are versatile; the 4X6 size can accommodate 16mm and 35mm
film.
9. Microfilm jackets represent an inexpensive method for filing.
10. The index on each jacket provides rapid indexing which can be adapted
to many index techniques.
11. The MWRC department personnel will benefit from the knowledge that
the enforcement files on microfilm are up-to-date and completely
accurate.
Recommendations
The following recommendations are directed at the selection of the most
effective type of microfilm, and the development of a plan to convert and
implement the selected system.
68
-------
1. It is recommended that microfilm jackets be used as the microfilm
media, because they would offer the required features plus a smaller file
size than the aperture card system.
2. A timetable for the conversion of the existing files should be devel-
oped and mutually agreed upon with the Record Center, due to the size of
the file to be converted.
3. An administrative control procedure should be used to update and
maintain the existing manual files. This procedure would assist in
updating the files before microfilming (See Procedure 5.)
4. A similar control procedure should also be used to retain the
continued integrity of the microfilm file.
5. A file control unit should be established to control and maintain
the manual file and to process, file, and maintain the microfilm files.
A new procedure has been developed to describe the microfilm processing.
(See Procedure 8.)
6. As the volume of the enforcement file grows (to approximately five
times the current volume), automatic retrieval equipment should be
reviewed as a means of speeding up the record access time.
7. The costs for materials, processing, and equipment have been computed
as part of the original test. (See Exhibit 27.) A review confirmed that
these estimated costs are still in effect. These costs would provide an
average cost per microfilm image or per document of four cents. Based on
the estimated annual volume to be microfilmed, annual operating costs are
estimated to be approximately $10,000. (See Exhibit 28.)
8. The conversion processing time (Exhibit 28) has been estimated to be
approximately 1,600 hours based on an estimated volume of 250,000 docu-
ments. This will require scheduled processing through the Record Center
to provide ample time for the processing.
69
-------
EXHIBIT 27
ESTIMATED COSTS - MICROFILM JACKETS
MATERIALS COST
Microfiche jackets $1.07 per 1M (4 X 6)
Roll film - 16mm - 1,600 images per roll
(Film cost is included in processing.)
PROCESSING COST (Record Center)
Labor rate $5.75 per hour
Processing - developing $5.55 per roll
Duplicate copies of film $3.73 per roll
Insertion in jackets (4 hrs. $5.75) $23.00 per roll
(Insertion should be performed by lower-cost employees.)
EQUIPMENT COST (Purchase)
Viewer - filler $1,350.00
Reader - Printers 1 1,600.00
Readers only 6 @ $400 2,400.00
Storage cabinet (5 drawers with dividers) 345.00
Microfiche duplicator (fire-resistant) 1,100.00
$6,795.00
AVERAGE COST PER IMAGE
Jackets (40 images each) $1.07 * 40,000 = .002$
Filming (6 hrs. X $5.75 + 1,600) = 2.156
Processing Roll ($5.55 * 1,600) = .346
Insertion in jackets
(4 hrs. X $5.75 * 1,600) = 1.437
Cost per image 3.941$
$0.04
70
-------
EXHIBIT 28
MICROFILM - CONVERSION TIMING AND COST ESTIMATES
TIMING ESTIMATES
CONVERSION
250,000 documents * 1,600 images = 157 rolls
157 rolls X 10 hours = 1,570 hours
(time for filming, processing, inserting)
DAILY PROCESS TIME
1,000 documents * 1,600 documents per roll X 10 hrs. per roll = 6.2 hrs,
(time for filming, processing, inserting)
COST ESTIMATES
CONVERSION
66 file drawers X 24" long - 30% of capacity
for lost space X 240 pieces per inch = 250,000 pieces
$0.04 per image X 250,000 pieces = $10,000
ANNUAL OPERATION COST
1,000 pieces per day X 250 working days = 250,000 pieces/year
$0.04 per image X 250,000 pieces = $10,000
71
-------
SECTION VI
WISE - PROCEDURAL CONTROLS
The development of a large automated information system with its inherent
sophistication and the use of new techniques require the parallel develop-
ment of administrative and procedural controls. The development and the
documentation of procedures benefit system users by:
Explaining how specific functions work.
Describing specific work tasks and forms to be used for clerical
personnel.
Providing continuity through the capability to retain documenta-
tion if personnel changes occur.
Providing a check on the accuracy and integrity of the total
system.
Providing a training tool for other users whether in Michigan or
in other states.
Ensuring that MWRC policies are known and followed.
Providing a central control over all input-output processing to
and from the data processing department.
The major recommendation to all users resulting from the analyses and
development of the various procedures is that procedural control func-
tions should be administered from a central group. This has been
accomplished in Michigan through the establishment of the Central
Administrative Control (CAC) group. Other recommendations pertinent to
the individual analyses and procedures are indicated in the following
sub-sections:
Administrative Control of Station Numbers.
o Administrative Control of Users' Numbers.
Enforcement Files.
Input Systems - OCR.
Input Systems - Turn-around Documents.
Input Systems - Key-to-tape.
Procedures.
ADMINISTRATIVE CONTROL OF STATION NUMBERS
To properly develop and utilize its own water management information
system and to interface with the STORET system, a state agency will find
it necessary to establish stations and an associated station number code
for each data collection point in the State. Station numbers and station
data are coded to facilitate retrieval and reporting. Since station
numbers represent the major reference to computer files and reports, the
administrative control of the number assignment is very important to the
accurate operation of the system.
73
-------
A six-digit station number reference file is required to:
Assign the next station number in sequence.
Control the number assignment to avoid, duplication.
Provide a reference to the data stored in the computer.
Findings
The investigating agency's analysis covered the use of:
Card files maintained in numeric and organization name sequence.
Computer-printed labels to update card files.
Various card storage devices.
County books for station numbers. (The first two digits of
each primary station number designate the county.)
The various card file methods require clerical effort for record main-
tenance . Computer-printed labels require an additional computer program
and modification of the remote file maintenance program to print the
correction labels.
The proposed system of county books involves the visual look-up of the
last number assigned for that particular county. The next number in
sequence is then assigned to a new request for station number. Station
number assigned, and organization name and address are recorded on the
station forms, and filed in the county book. File maintenance beyond the
original recording is eliminated. To make this system a continuing opera-
tion, the administrative procedures and forms used have been documented.
(See Procedure Number 2.)
Recommendations
It is recommended that a control function be established to process the
setup sheets for new stations, and to assign the numbers as requested.
Additional responsibilities would consist of controlling and reviewing
the forms sent to data processing.
74
-------
A computer-prepared listing of organizations in alphabetic sequence
should be prepared monthly. This listing would provide reference to a
station number by company name. New organizations would be added manu-
ally to the listing until the next computer print-out was received.
It is recommended that computer lists of station numbers and organiza-
tions be prepared in numeric sequence and alphabetic sequence annually.
These lists would be used to perform an audit of the station numbers.
ADMINISTRATIVE CONTROL OF USER NUMBERS
User codes are assigned to provide unique identification of an industrial
firm, commercial firm, or a municipality, and to identify ownership of
the outfall or intake. The character structure for industrial and
commercial firms appears as AM 001, where AM represents the firm name
(AJAX MANUFACTURING CO.) and 001 represents the first location for that
firm. The number system for municipalities is the five-digit number
assigned by the U. S. Bureau of the Census.
Findings
The number for municipalities is already assigned and is subject to very
few control problems. The number for industrial and commercial firms is
assigned and recorded for the first time when a new station is set up.
Without procedural control over the user code assignment, duplicate codes
are possible.
Recommendations
The control and assignment of user codes should be the responsibility of
the Central Administrative Control unit.
It is also recommended that a reference list for user codes and user
names be maintained in user code sequence to provide proper assignment of
the next code. The look-up and number assignment would become a part of
the Station Number Control. (See Procedure Number 3.)
75
-------
MWRC CENTRAL ADMINISTRATIVE CONTROL PROCEDURES MANUAL
Procedure 1
SUBJECT: Completing Statement of New or Increased Use of Waters of
the State for Waste Disposal Purposes
PURPOSE: The purpose of the statement is to present concise informa-
tion on a proposed new or increased use of waters of the
State for waste disposal purposes. The statement is required
by Section 8(b), Act 245, Public Acts of 1929, as amended,
which reads as follows:
GENERAL: Section 8(b). On and after May 18, 1949, any person
requiring a new or substantial increase over and above the
present use now made of the waters of the State for sewage
or waste disposal purposes shall file with the Commission a
written statement setting forth the nature of the enterprise
or development contemplated, the amount of water required to
be used, its source, the proposed point of discharge of the
wastes into the waters of the State, the estimated amount so
to be discharged, and a fair statement setting forth the
expected bacterial, physical, chemical and other known char-
ateristics of the wastes. Within 60 days of receipt of the
statement, the Commission shall make an order stating such
minimum restrictions as in the judgment of the Commission
may be necessary to guard adequately against such unlawful
uses of the waters of the State as are set forth in Section
6. If the order is not acceptable to the user, he may
request a hearing on the matter involved, following which
the Commission's final order of determination in this con-
nection shall be conclusive unless reviewed in accordance
with the provisions of the administrative procedures of Act
No. 197 of the Public Acts of 1952, as amended, being
Sections 24.101 to 24.110 of the Compiled Laws of 1948, or
any amendment thereto, in the Circuit Court for the County
of Ingham, or for the county in which the user resides, or
for the county in which the use is contemplated, upon peti-
tion therefor, filed within 15 days after service upon said
user of the final order of determination.
EXHIBIT 29:
PROCEDURE:
The word "person" as used herein means any individual,
municipality, industry, public or private corporation,
copartnership, firm, or any other entity whatsoever.
Statement on New or Increased Use of Waters of the State for
Waste Disposal Purposes
Give name of person proposing to make the new or increased
use. Give mailing address where person proposing to make
the new or increased use may be reached.
76
-------
1. State whether person proposing to make the new or
increased use is doing so as in individual, partnership,
corporation (public or private), governmental board or
agency or other legal entity.
2. If person proposing to make the new or increased use is
a private corporation, name state in which articles of incor-
poration are filed.
3. Characterize proposed enterprise on the basis of its
principal function.
Example: cannery, oil refinery, chemical manufacturing,
metal plating, automatic laundry, fruit or
vegetable freezing, shopping center, hospital, etc.
Describe location of proposed enterprise. Be specific.
Wherever possible use street or road names and numbers, and
name of political subdivision (city, village, township). If
necessary, attach a sketch or map showing location.
4. With respect to the location described in Item 3, state
whether proposed enterprise is a new development or an
expansion of an existing development.
5. Water supply and use information.
Describe water supply source (well or wells, surface water,
public supply). If source is surface water, give name of
lake or stream involved. If source is public supply, give
name of owner, i.e., city, village, township, etc. Give
separate estimates of the amounts of water to be used for
various purposes, i.e., manufacturing process, cooling and
condensing, sanitary, etc. Amounts should be expressed in
terms of time, for example: gallons per minute, hour, day,
week, etc.
6. List estimated daily volume of wastes to be discharged.
Indicate whether discharge is over 1 shift (8 hours), 2
shifts (16 hours), or 3 shifts (24 hours). With respect to
periodic batch discharges, indicate volume and frequency.
7. Describe point or points of waste discharge. If dis-
charge is to public sewer, give name of owner and state
whether sewer is of the sanitary, storm or combined type.
If discharge is to county or intercounty drain, give name of
drain and state whether it is open or closed. (Information
on drains may be obtained from appropriate county drain
commissioner.)
77
-------
EXHIBIT 29
STATE OF MICHIGAN
WATER RESOURCES COMMISSION
STATEMENT ON NEW OR INCREASED USE OF WATERS OF THE STATE FOR
WASTE DISPOSAL PURPOSES
Name
Address
1. Type of legal entity
(individual, partnership, corporation)
2. State of incorporation
3. Nature and location of enterprise
4. Development contemplated
(expansion, new development)
5. Water requirements:
Source Amount Use
6. Type and daily volume of wastes to be discharged:
a. Process waste
b. Cooling and condensing water
c. Sanitary sewage
d. Other
7. Proposed points of waste discharge: (Municipal sewer, county drain,
lake, river, leaching pit or injection well, etc. Give name; of
drain, lake or river.)
a. Process waste
b. Sanitary sewage
c. Cooling and condensing water
78
-------
EXHIBIT 29
Continued
8. Expected Characteristics of Wastes:
Process Waste Cooling and Sanitary Other
Condensing Sewage
a. Bacterial
b. Physical
c. Chemical
d. Other
Description of treatment or control facilities (if applied to accom-
plish waste characteristics set forth in paragraph 8). If discharge
is to underground by injection well, complete data as to depth and
diameter of well, materials and details of construction, date of
drilling, screen data and proposed operations of injection well
should be included on fly sheet with this statement and question
No. 11 should be completed.
10. Proposed date of completion of disposal facility
11. Distance from nearest private well is feet.
Distance from nearest municipal well is feet.
12. If leaching pit or oxidation pond is proposed, distance to nearest
surface-water course is feet. (Complete question
No. 11 also.)
Submitted in accordance with Section 8b, Act 245, Public Acts of 1929,
as amended by Act 117, Public Acts of 1949.
Date
Signature
**If signed by an agent, authorization therefore must accompany this
statement. If a partnership, all partners must sign.
79
-------
If discharge is to surface water, give name of receiving
stream or lake. If discharge is to underground waters
through an injection well, complete Item 9.
8. List significant bacterial, physical, or chemical waste
characteristics.
Example: color, turbidity, temperature, biochemical oxygen
demand, chemical oxygen demand, toxic components,
alkalinity or acidity, taste- and odor-producing
components, radioactivity, etc.
9. Self-explanatory.
10. Self-explanatory.
11. Self-explanatory.
12. Self-explanatory.
* * * *
Procedure 2
SUBJECT: Request for Station Number
PURPOSE: To document the procedure for requesting a primary station
number for new water users.
GENERAL: Requests are usually filed by the District Engineer when new
firms are formed or expanded.
EXHIBIT 30: Sample Request for Station Number
PROCEDURE:
District Engineer
1.1 Fill in the form 'Request for Station Number1 as completely as
possible. Indicate:
Company name
Street address
City or town
Product or service produced
Manufacturing processes
Primary number (if already assigned)
Secondary number (if already assigned)
SIC Code number
Descriptions and locations of outfalls
80
-------
SAMPLE REQUEST FOR STATION NUMBER
EXHIBIT 30
COMPANY NAME XYZ CORP.
PRIMARY NUMBER
STREET ADDRESS 1938 EAST AVENUE
CITY
DETROIT. MICHIGAN 48881
SECONDARY NUMBER
PRODUCT
ELECTROPLATED PARTS FOR AUTOMOTIVE AND AERONAUTIC TRADE
S.I.C. CODE NO.
MANUFACTURING PROCESS OR PROCESSES
PLATING - BRASS. CADIUM, CHROMIUM, COPPER. NICKEL, ZINC.
DESCRIPTIONS AND LOCATIONS OF OUTFALLS
I OUTFALL NO
I 30-INCH CONCRETE PIPE COOLIKG WATER DISCHARGE TO MILL CREEK LOCATED
1.050 FEET DOWNSTREAM FROM U.S. HIGHWAY BRIDGE ON RIGHT BANK.
2. 24-INCH PVC PIPE. PLATING LINE TO MILL CREEK. LOCATED 2.000 FEET DOWNSTREAM
FROM U.S. 99 HIGHWAY BRIDGE ON RIGHT BANK.
S.
10.
12.
81
-------
1.2 It is very important to know the manufacturing process, the size of
the outfall (e.g., pipe size), and the type of waste water
discharge. (See sample form, Exhibit 30.)
1.3 The primary number will only be known for an existing station where
new outfalls are designated.
1.4 Forward the forms to Central Administrative Control for new station
coding and set-up.
Station Number Control
2.1 After receiving and checking the request form for completeness,
fill out the set-up sheets for the STORET and WISE system, and
process the request. (See Station Number Control, Exhibit 31.)
Procedure 3
SUBJECT:
PURPOSE:
GENERAL:
EXHIBITS:
Station Number Control
To document the procedures for assigning and maintaining
control over new station numbers.
The station number reference file will be maintained in
six-digit station code. The numeric station number refer-
ence will include numbers for the WISE and the STORET
systems.
Reference to company names is derived from the alphabetic
MWRC Station List. This list will not include the STORET
stations. The alphabetic list will be prepared monthly
from the computer. (See Exhibit 35.)
31 Flow Chart
30 Request Form
32 New Station Set-up Sheet
33 User Information and Station Data Form
34 MWRC Station Numbers Sheet
35 MWRC Station List
PROCEDURE:
Station Number Control
1.1 Memos and Request Forms (Exhibit 30) requesting that new stations
be set up are received in the MWRC Lansing office from MWRC dis-
trict offices and from investigations that disclose a need for a
new station.
82
-------
STATION NUMBER CONTROL FLOW CHART
VERIFY THAT/
INPUT WAS I^
PROCESSED/"^
I STATION SET-UP i .
-------
NEW STATION SET-UP SHEET
MONTHLY PERFORMANCE AND ACTION REPORT
MICHIGAN WATER RESOURCES COMMISSION
1 2
1,0
1,1
2,0
2,1
!"*"
60
6 1
7,0
|.
80
8,0
80
8,0
8,0
80
8,0
8,O
8,0
8,0
1 Z
3 .4.3 .6 .7, 6
STA. NO
345678
CORP OR ORG NAME OFFICER RESPONSIBLE
. , :::j.:!K:i!ii: i
STREET ADDRESS CITY-STATE-ZIP
: .
MAILIN3 NAME ATTENTION OF
STREET ADDRESS CITY-STATE-ZIP
> ' tin » . ti&in' ,
...
-
ORDER
NUMBER
9 K) IIIZ 13
PARM
NUMBER
_^^.^_
4 151617 10
M
I|DIS|MAJMIN|TERMIB p| USE ORGAN. __
|REGION(RIVER BASiNJH |TYPE NUMBER ' '
i
"
iiiiliiiftmtuii'iii frnf t*i^' ' ' ' 1 ' ' ' * ' 'ii^iiilfMlntilin
9 20J2 1222324 2526 27 26 2930(3132 333-1 3536 37363940 41
ORG NAME TO APPEAR ON REPORT
MOIYR
DATE
ORG NAME -CONTINUED
OUTFALL NAME
TO APPEAR ON REPORT
nitiiiit H 1 1
f I f I ^
4243 4445464T
PARAMETER
NAME
48495O5I5253545S
R
IE
ORDER LIMITS
AVERAGE
5759596O6I62636/
R
LIMITS
i i i i i i I
!56S67«869707I727S
r .in,a Ht )( | :
I .!::!.» t.
111 ( I -I ..
1 J 1 ... I....I..,
1 1 r...l...l....l...
'4T57S7T7«79ee
-------
FWPCA STORE! SYSTEM
DIVISION OF POLLUTION SURVEILLANCE
USER INFORMATION & STATION DATA
REQUIRED FOR STORAGE AND CHANGES
EXHIBIT 33
AGENCY CARD
AGENCY (USER) CODE
UNLOCKING KEY
USER NAME, LOCATION ,
PROJECT, ETC.
n
/r
BLANK
?-/6
I I I II i I I
DEPTH-FEET (F) OR METERS (M)
STATION TYPE
7J
STORE CODE |~1 | |
UNLOCKING DATE
cn
W 7f
CONTROL CODE 1 1
73 77
go
YEAR
MO.
75"
/fr- 77
STATION CARD
SEQUENCE NUMBER
PRIME STATION, CODE
(1J.SECONDARY STATION
CODE
2):SECONDARY STATION
CODE
(3JSECONDARY STATION
CODE
\\ I I II II i 1 I I J
STATE CODE
COUNTY
?t>
CONTROL CODE
3-7
CITY
BLANK
LEFT JUSTIFY
85
-------
1.2 Fill in the proper information on the set-up sheets (Exhibits 32
and 33) for the WISE and the STORET system.
1.3 Look up the last number in sequence within the county for that
station.
1.4 Assign the next number in sequence to the new station and record
that number on the set-up sheets.
1.5 Prepare a new MWRC Station Number sheet (Exhibit 34) for the
station number index file, and file in proper sequence.
1.6 Look up the last user number from the user number reference list.
Use the next number in sequence as the user number. (If this is a
new firm, the number will be developed by reviewing the reference
list for that alpha name and coding the prefix digits from the user
name.) An example would be: AJAX MANUFACTURING CO. = AM 001.
1.7 Record the user number, user name, location, and station number on
the user number reference list. (Exhibit 35)
1.8 Forward the set-up sheets to data processing.
Data Processing
2.1 Key punch the input cards for the WISE and STORET systems.
2.2 Return the set-up sheets to station number control.
Station Number Control
3.1 Verify that input cards were punched.
3.2 Send the set-up sheets to the File Unit for filing.
Data Processing
4.1 Prepare a monthly listing of organization names in alphabetic
sequence. (Exhibit 35)
Procedure 4
SUBJECT: Station Number Audit
PURPOSE: To provide a method for verifying the manual index file
against the computer print-outs for accurate station
numbers.
86
-------
MWRC STATION NUMBERS
EXHIBIT 34
PRIMARY
SECONDARV
DESCRIPTION
87
STORET STATION SET UP
DOC. I DATE
COMP. CONF
-------
EXHIBIT 35
MWRC - STATION LIST
USER
NUMBER
USER NAME
USER LOCATION
STATION
AM 001
AJAX MFG. CO.
BALDWIN, MICH
280021
AM 002
AJAX MFG. CO.
REED CITY, MICH
280022
AN 001
AN 002
AO 001
AP 001
AQ 001
88
-------
EXHIBITS: 36 Annual Station Number Audit
37 MWRC Station List - Alphabetic Sequence
Data Processing
1.1 Prepare computer listing for an alpha station list and a numeric
station list.
1.2 Forward the computer listing to station number control.
Station Number Control
2.1 Verify the station numbers and station data against the index
files.
2.2 For records in error, fill out a correction sheet and forward to
data processing for key punching.
2.3 The processing will then follow the same steps as for new station
input.
Procedure 5
SUBJECT: Enforcement File Processing
PURPOSE: To document the method for clerical handling and micro-
filming of MWRC Enforcement Files.
POLICY: Microfilm jackets can only be updated or removed by the
authorized file control supervisor.
EXHIBITS: 38 Flow Chart - Microfilm Enforcement Files Maintenance
39 Flow Chart - Microfilm Enforcement Files Data Retrieval
40 Sample Microfilm Jacket
41 Microfilm Batch Control
PROCEDURES:
(
MWRC Department
1.1 Documents, correspondence, blueprints, station action forms, and
industrial operating reports are received daily by the various
sections of the MWRC.
1.2 After departmental processing of each form or document, the paper-
work to be filed is sent to the File Unit to prepare for
microfilming.
89
-------
ANNUAL STATION NUMBER AUDIT
EXHIBIT 36
/STATION NUMBER\
\^ CONTROL J
2.1
(DATA PROCESSING) 1-1
STATION
NUMBER INDEX
VERIFY
STATION
NUMBERS
&DATA
7
STATION LIST
ALPHA
STATION
SET-UP SHEETS
(DATA PROCESSING)
90
-------
MWRC STATION LIST - ALPHABETIC SEQUENCE
DATE 99/99/99
so
H
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
i
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
NAME
ADDRESS
CITY, STATE
P-NO.
SEC. NO.
P NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
P-NO.
SEC. NO.
m
V
H
-------
MICROFILM ENFORCEMENT FILES
FILE MAINTENANCE
EXHIBIT 38
-------
MICROFILM ENFORCEMENT FILES
DATA RETRIEVAL
MWRC -USER DEPARTMENT
-------
vo
MICROFILMJACKET
ROWS
AJAX CHEMICAL CO.
SEQ. NO. 1
B
m
X
I
ro
H
BROWS X 8 IMAGES = 40 IMAGES PER JACKET
-------
EXHIBIT 41
MICROFILM BATCH CONTROL
DATE SENT
BATCH NUMBER
DATE RETURNED
95
-------
File Unit
2.1 Remove all paper clips, staples, and arrange the documents, face up.
2.2 Sort the documents alphabetically by district.
2.3 Place the district media in separate envelopes for handling at the
Record Center.
2.4 Number the batches and record the current date and batch number on
a batch control sheet. (Exhibit 41)
2.5 Forward the batches to the Record Center via interoffice mail.
Record Center
3.1 Microfilm the documents received on separate rolls for each
district.
3.2 Label the rolls with district number, date, batch number.
3.3 Return microfilm rolls and documents to the File Unit.
File Unit
4.1 Check off batch number received back from the Record Center.
Review the monthly batch control sheet to make sure that all
batches have been received.
4.2 Retain the correspondence media in sequence by date for 3 months.
After that, the correspondence should be forwarded to the Record
Center for retention.
4.3 Process the microfilm through the reader-filler, and insert and
update appropriate jackets. Jackets are visually retrieved from
the files.
4.4 Code each new jacket with the name of the industrial company or
municipality, etc., and the sequence.number of that jacket within
its file.
4.5 When all of the daily microfilming insertion has been completed,
duplicate the jackets that have been updated.
4.6 Send the duplicate jackets to the individual districts for their
files.
4.7 Refile the master microfilm jackets in alphabetic sequence,, !
District Office
5.1 Check the dates to establish that all microfilm is received in
batch number sequence.
96
-------
5.2 File the microfilm jackets in alphabetic sequence, removing the
jackets that were replaced.
5.3 Code new jackets with the name of the file and the sequence number
of that jacket within its file.
SUBJECT:
PURPOSE:
GENERAL:
EXHIBITS:
Procedure 6
Operating Report Processing
To document the clerical handling, checking, and routing of
the Monthly Operating Report.
The Monthly Operating Reports are prepared by the computer
and mailed to industrial, commercial, and municipal organi-
zations for recording water quality measurements. The
Certified Operators record the measurements for parameters
that are unique to their plant and return the forms to the
MWRC on a monthly basis.
42 Flow Chart
43 INFORM Correction Form
44 and 45 Monthly Operating Report (INFORM)
46 Certified Operator Letter
PROCEDURES:
Clerical - Mail Processing
1.1 Open the daily mail as received, remove the forms, maps, and corres-
pondence for processing.
1.2 Ensure that station numbers are recorded on maps, correspondence
and accompanying forms. Write station numbers on accompanying
material, if not already recorded.
1.3 Separate all miscellaneous documents from the operating reports and
stack for further processing.
1.4 Set the time stamp to the current date and stamp each report in the
upper left corner. Verify that the sequence number is printing for
each document.
1.5 A separate time stamp without the sequence number feature should be
used to stamp the miscellaneous documents.
1.6 Forward the miscellaneous documents to the MWRC, Supervisor of Data
Processing Unit, for review and further processing.
97
-------
FLOW CHART
OPERATING REPORT PROCESSING
f Mvmc-MireiTN
\DATA PROCESSING/
98
-------
EXHIBIT 42 continued
-------
B
I
EXHIBIT 42 continued
4.4
rFILE
i/HCROFILM
INFORM REPORTS
DISTRICT
MWRC-SUPEfl
DATA PROCESSING
A
G^
REVIEW / 5.1
EXCEPTIONS
& MISC.
^DOCUMENTS/
(
CERTIFIED
OPERATOR
PROGRAM
ORGANIZATION )
100
-------
Clerical - Form Editing
2.1 Verify that month and year are recorded in the space at the top of
the form.
2.2 If changes are indicated in the organization or outfall address,
fill in an INFORM Correction Form and forward the report and the
correction form to the master file control analyst.
2.3 If new water quality parameters are added to the report, fill in
an INFORM Correction Form and forward both documents to the master
file control analyst.
2.4 Where parameters measurements are not recorded for daily overall
or monthly summary, the parameter should be crossed out and the
monthly summary space lined through, to indicate that key punching
is not required for that parameter.
2.5 Verify that unit measurements for UG/L have a minimum value of 10.
2.6 Where flow rate measurements are recorded, the maximum should not
be greater than 50 million gallons daily.
2.7 Verify that the highest and lowest daily readings are recorded
under Month Summary High and Low.
2.8 Verify that a monthly average is recorded under Month Summary
Average.
2.9 Verify that the monthly average is between the high and low for
that parameter.
2.10 Verify that the monthly average is recorded with a decimal point,
e.g., .049, 4.9, 49.
2.11 Verify that the number of determinations is greater than 0 and
equal to or less than 99.
2.12 Verify that a beginning and ending date is recorded with an
elapsed time of 30 days between dates.
2.13 Dates must be recorded as a six-digit field (01 07 71) on the
bottom of INFORM report.
2.14 Where comments from the certified operator are recorded on the
back of the INFORM document, mark an "X" in the upper right hand
corner as an indication to the microfilm operator to microfilm
the back of the document.
2.15 If errors are noted, fill in an INFORM Correction Form (Exhibit 43)
and send the correction form to the certified operator.
101
-------
INFORM CORRECTION FORM
STATE OF MICHIGAN
DEPARTMENT OF NATURAL RESOURCES
EXHIBIT 43
STATION NUMBER XXXXXX
OUTFALL ADDRESS
DEAR SIR:
WE HAVE RECEIVED YOUR MONTHLY OPERATING REPORT FOR THE
MONTH OF AND HAVE NOTED THE FOLLOWING
ERRORS. THE ERRORS HAVE BEEN CORRECTED TO ALLOW PROCESSING
OF YOUR REPORT.
VERY TRULY YOURS
MICHIGAN WATER RESOURCES COMMISSION
INFORM CORRECTIONS
D
D
a
D
D
D
D
D
ADDRESS CHANGE
PARAMETERS CHANGED, ADDED
PARAMETERS NOT REPORTED
UNIT MEASUREMENT ERROR
NO MONTHLY AVERAGE
HIGH 8c LOW NOT RECORDED
MONTHLY AVERAGE, NO DECIMAL
NO DETERMINATIONS. ERROR
D BEGIN-ENDING DATE ERROR
D DATES RECORDED IN ERROR
D FORM RETURNED, NOT DELIVERED,
CHECK ADDRESS & REMAIL
D SPECIAL COMMENTS
D NO CERTIFIED OP. SIGNATURE
MWRC - INTERNAL ACTIONS
a
D
a
a
CERTIFIED OPERATOR PROGRAM
SUPER-DATA PROCESSING UNIT
MASTER FILE CONTROL
ENFORCEMENT SECTION
2 PART
CARBON
102
-------
2.16 For INFORM documents with comments, fill in in INFORM Correction
Form and forward it to the MWRC, Supervisor of Data Processing
Unit.
2.17 Verify that a Certified Operator signature is present and is
recorded on the Certified Operator list. If a signature is not
present or is not recorded on the master list, fill in an INFORM
Correction Form and forward the form to the Certified Operator
Program analyst.
2.18 Process all INFORM documents through batch control as described in
Procedure 9.
2.19 Deliver the INFORM documents on a daily basis to the MS-Data
Processing Unit.
MS-Data Processing
3.1 Check batches received, key punch, and key verify the INFORM
cards. Hold the cards for the monthly processing of the PAR
program.
3.2 Return the INFORM documents to the MWRC, Clerical Unit.
3.3 When the Monthly Performance and Action Report (PAR) is processed,
forward copies to the Enforcement Section and to the MWRC, Super-
visor of Data Processing Unit.
Clerical
4.1 Accept INFORM documents back from the MS-Data Processing Depart-
ment. Hold the documents for monthly microfilming.
4.2 Once a month, sort the INFORM documents into sequence by district
number and county number.
4.3 Send the INFORM documents to the State Record Center for micro-
filming. If any of the documents are late from a previous month,
they should be added to the previous month's microfilm roll.
4.4 When the documents and micrpfilm are returned, send the INFORM
documents to each district office and retain the microfilm in the
file.
MWRC - Supervisor of Data Processing Unit
5.1 Review the INFORM documents with special comments and take appro-
priate actions.
5.2 Review the miscellaneous correspondence, maps, and take appro-
priate actions.
5.3 Review the Monthly Performance and Action Report (PAR). (See
Exhibit 17.) Provide additional information to the Enforcement
Section as requested.
103
-------
["FLY BOO AND REEL CORP.
CHIEF EXECUTIVE OFFICER
HIM. REACH BLVD.
MUSKEGON. MICHIGAN 44444
~1
REEL PLANT NO. 1
JOE LINE
1IIS. REACH BLVD.
(j. MUSKEGON. MICHIGAN 44445 |
MONTHLY OPERATING REPORT FOR _
THIS IS YOUR MONTHLY REPORT FORM FOR
SEE REVERSE SIDE FOR RETURN MAIL
TO: STATE OF MICHIGAN
WATER RESOURCES COMMISSION
PtaM rom|ilM« Mid Mimblt MM coev 0f tflb f Mm
[54IN COOLING WATER OUTFALL |
FLY ROD AND REEL CORP.
REEL PLANT NO. 1
II oni !> (dtecMl one* iblly, enttr Dig v»lu« n DAILY
AVERAGE. If dm H colHKtad man friquBnltv, compuw tlw
DAILY AVERAGE hrhrmwtic) >nd record H. In xldition
Pteue uu units spKifM.' At end ol month compute the
Monthly Avtrtja md ucooj n MONTH SUMMARY.
ORDER NO.
PARAM. NO.
NAME
UNIT!
^^CTO.
1
1
1
1
1
I
IB
IT
IB
1*
2O
21
22
23
24
H
24
27
26
29
30
31
MONTH
SUMMARY
1 «»t 11111
14-18) OQ720
CYANIDE
MG/L
0.05
f 1 1 ' ' 1 f
X
0.1 E
X
MONTH DAV YEAH
(73O6) (77.7B) (7MO)
I 8-13) 11111
«4.iai 01025
CADMIUM
UG/L
6
1 f 1 IJUI 1
X
10
X
OUT PUNCH 7M0
B-I3I 11111
"1« 01040
COPPER
UG/L
IS
i 1 1 i i i i
X
X
X
ouf PUNCH 7&ea
S-131 11111
14.11) 60050
FLOW MGD.
UGD
o.oe
1 1 1 1 * 1 1
X
0.10
X
OVf PUNCH 7S«O
( t-13)
11 4-1 B)
(99-041
1 1 IJ_I 1 1
X
X
OOP PUNCH 7MQ
B-13)
14-101
1 1 1 1 1 | f
X
X
our PUNCH 76-ao
» 131
14 1H
1 1 1 I M 1
X
X
OUP PUNCH 7S4O
BONATURE OF CERTIFIED OFCHATOR _
CERTIFICATION HWKER _
-------
EXHIBIT 45
REVERSE SIDE OF MONTHLY OPERATING REPORT (INFORM)
FOLD HERE THIRD
I PLACE |
I FIRST CLASS |
I STAMP HERE
STATE OF MICHIGAN
WATER RESOURCES COMMISSION
COMPREHENSIVE STUDIES SECTION
STEVENS T. MASON BUILDING
LANSING, MICHIGAN 48926
FOLD HERE SECOND
105
-------
Certified Operator Program
6.1 Review the INFORM Correction Form for signature errors. Verify
that the signature is that of a registered Certified Operator.
6.2 Mail a form letter to the organization to request clarification
of their certified operator personnel status. (Exhibit 46)
Master File Control - Analyst
7.1 Fill in the appropriate new station documents as INFORM documents
are received. New station documents are processed according to
Procedure 3.
7.2 Return the INFORM documents to the clerical unit for processing.
* * * *
Procedure 7
SUBJECT: Control of Manual Files
PURPOSE: To provide a procedure for controlling the retrieval and
removal of individual files from the Central Enforcement
Files.
EXHIBIT: 47 Request For File Form
48 Out-File Card
PROCEDURES:
Control of Manual Files - File Unit
1.1 All inquiries to remove individual files, review documents, or
remove individual documents must be directed to the File Control
Clerk.
1.2 Inquiries for removal of files or documents must be accompanied by
a Request For File Form (Exhibit 47) .
1.3 This form will indicate the following:
File name
Document name
Date requested
Date file due
Length of time file is required
Requestor department
Requestor name
106
-------
EXHIBIT 46
CERTIFIED OPERATOR LETTER
DEPARTMENT OF NATURAL RESOURCES
ORGANIZATION NAME
NAME - ATTENTION OF
ADDRESS
CITY, STATE, ZIP
Dear Sir:
We have received your Monthly Operating Report for the month of
. The certified operator signature is
Q in error according to our registration records
or
Q missing
Please furnish information regarding your certified operators names. Send
this information to:
Michigan Water Resources Commission
Stevens T. Mason Building
Lansing, Michigan 489__
Thank you for your attention.
Very truly yours,
Michigan Water Resources Commission
107
-------
Requestor
2.1 Fill in Request For File Form (Exhibit 47) and give the form to the
File Control Clerk.
2.2 Obtain file or document.
2.3 On or before return due date, return the file to the Central File
Unit.
File Control
3.1 Determine that request forms are received for all files or docu-
ments removed from main file.
3.2 Determine that request forms are properly filled in with date and
requestor department and name.
3.3 Remove files or documents.
3.4 File the request forms in alphabetic sequence in a separate out-
file and file an Out-File Card (Exhibit 48) in place of the missing
file.
REQUEST FOR FILE
EXHIBIT 47
FILENAME.
DOCUMENT NAME.
FILE NEEDED FOR.
DATE REQUESTED.
DATE FILE DUE.
REQUESTOR DEPARTMENT.
REQUESTOR NAME.
108
-------
OUT-FILE CARD
OUT-FILE
o
vo
DATE
FILE NAME
REQUESTOR
DATE
FILE NAME
REQUESTOR
DATE
FILENAME
REQUESTOR
DATE
FILENAME
REQUESTOR
EXHIB
LETTER SIZE FOLDER STOCK
oo
-------
3.5 Weekly, review this out-file for files overdue. Call the
requestor and determine that the file is required for a longer
period or will be returned.
3.6 Destroy the original request forms only when files are returned.
3.7 Refile the material received and remove the Out-File Cards from
the file.
* * * *
Procedure 8
SUBJECT: Microfilm Reader-Filler Processing
PURPOSE: To document the clerical handling involved in inserting
microfilm images into the microfilm jackets.
PROCEDURES:
Reader-Filler Processing - File Unit
1. Microfilm will be returned daily from the Record Center. Insert
the roll of film in the reader-filler. Index to the first image.
2. Read the name of the industrial firm, river, stream, or munici-
pality. This name is the index to the permanent microfiche file.
3. Visually locate and obtain the proper file and the last jacket in
sequence for that file.
4. Place the jacket in the reader-filler.
5. Index to the A row, and if space is available in that row, depress
the button to cut and fill that row. Where more documents are present
for that file, repeat the process through the B, C, D, and E rows.
Procedure 9
SUBJECT: Batch Control of Input Forms
PURPOSE: To provide a procedure for controlling the transmittal of
documents between MWRC and the Data Processing Department.
EXHIBITS: 49 Daily Input Batch Log Form
50 Daily Batch Transmittal Form
110
-------
EXHIBIT 49
DAILY INPUT BATCH LOG
MONTH
May
DATE
5/5
BATCH NO.
2
3
DOC TYPE
1
1
RECEIVED
IN MAIL
505
235
HELD IN
MWRC
DEPT.
3
1
SEND
TO D.P.
502
235
RETURN
FROM D.P.
COMMENTS
111
-------
BATCH NO.
DAILY BATCH TRANSMITTAL EXHIBIT 50
DATE 5/5/71
NUMBER OF DOCUMENTS
INFORM
502
PAR INPUT
NEW STATION
COMMENTS
112
-------
PROCEDURES:
Clerical
1.1 All documents prepared for data processing, either from forms
prepared by MWRC or forms received in the mail, must be date-
stamped and batched for processing.
1.2 As documents are checked, the documents held for other MWRC
processing are removed from the daily count.
1.3 Record number of documents received in the mail on the Daily
Input Batch Log (Exhibit 49).
1.4 Record number of documents held in the department for other
review.
1.5 Record the number of documents sent to the Data Processing
Department on the Daily Input Batch Log Form.
1.6 Fill in a Daily Batch Transmittal Form (Exhibit 50) for each
batch submitted, and record the number of documents sent to
the Data Processing Department.
1.7 As documents are returned from the Data Processing Department,
notation should be made in the Daily Input Batch Log of the number
returned.
113
-------
SECTION VII
SYSTEM CODING STRUCTURES
This section displays the data coding structures and describes their
significance. Information is classified (coded) in anticipation of its
use. The recommended data classification structure is based on current
MWRC and MDPH activities and on the observation of data acquisition and
use in similar organizations. This data coding system covers current
activities and provides for future activities.
In many instances, the codes selected are already in existence. Some of
these codes will provide a bridge of common information used by WISE
computerized information files and STORET information files. Such codes
are presented in a comparison of the different systems in Exhibit 54.
Foremost among the water quality data coding information systems is the
STORET system. An interface to the STORET system is considered vital to
the Michigan system. Where appropriate, STORET codes are referred to as
such.
The STORET system presents several opportunities to code data, as follows:
Primary Station Number (15 digits)
Secondary Station Number 1 (12 digits)
Secondary Station Number 2 (12 digits)
Secondary Station Number 3 (10 digits)
Flexibility is provided, even if new or revised functional responsi-
bilities are assigned to MWRC, and it is relatively easy to change the
codes that have been designed or to utilize the unused codes. In either
event, it is recommended that the interface between the STORET and WISE
systems be considered a vital requirement.
The investigating agency reviewed the Standard Industrial Classification
Code (SIC) published by the Bureau of the Budget, United States Department
of Commerce. This is a commonly accepted code, used by government and
industry. In addition, the SIC Code is used in the STORET system.
Although the SIC Code has some shortcomings insofar as some industries
are coded to specifically and others not specifically enough, its use is
recommended.
The advantages of using the SIC Code are:
Should statistics by business classification ever be required for
publication or comparison, the SIC Code is recognized by most other
government agencies and industries.
The Code system is already developed.
Changes to the Code system are updated by the Federal Government.
Use of the SIC Code will make the WISE and STORET systems consistent
in their classifications of industry.
115
-------
STORE! SYSTEM CODES
PRIMARY STATION NUMBER
This is a six-digit code structured as follows:
X X - X X
-Numeric sequence within county.
-Michigan county number.
A six-digit code has been selected at this time because:
1. It is more than adequate to identify the number of water sampling
stations that MWRC will require for the foreseeable future.
2. It minimizes the data input preparation details associated with
submitting data to STORET.
3. Although the STORET county code requires three positions to provide
for states with more than 99 counties, Michigan has fewer than 99
counties. The available digits generate a potential for 10,000 sampling
stations within each county.
4. Representatives of MWRC, FWPCA, and the staff of the investigating
agency discussed the procedure for changing station number codes in the
STORET system. Such discussion led to the conclusion that a change could
be effected should the need arise.
LATITUDE-LONGITUDE COORDINATES
Latitude
XX - XX - XX.X
Longitude
XXX- XX -XX.X
Seconds
-^-Minutes
3» Degrees
- Seconds
-^Minutes
-^Degrees
RIVER BASIN CODING
I XX I XX I XXXl
-^-Terminal Stream Number
-^^Minor Basin Number
-3^-Major Basin Number
116
-------
The River Basin Coding system has been designed by the FWPCA. Major and
minor basins have already been assigned 2-digit code numbers. (Exhibit
57) The Terminal Stream Number code is a 3-digit number to be assigned
by local agencies. (Exhibit 52)
Most of Michigan drains into the major basin 08, Western Great Lakes,
with a small portion of the southeastern corner of the State draining
into 06, Lake Erie through the Maumee River.
STORET STATION TYPE
This eight-position code is structured as follows:
(1) (2) (3) (4) (5) (6) (7-8)
X X X X X X XX
Position
(1) Always 0
(2) Type of Data
(3) Type of Site
(4) State of Water
(5) Source of Sample
(6) Location C
- 1 - Other
2 - Water Quality
4 - Flow, Tide, Well Level
- 1 - Other
2 - Municipal
4 - Industrial
- 1 - Raw before treatment
2 - Partial (at intermediate point)
4 - Treated (after available treatment)
- 1 - Direct (from stream, well, etc.)
2 - Intake
4 - Outfall
- 1 - Tidal
2 - Other (e.g., land, nontidal)
4 - Vessel
(7-8) Locations A & B AB
AB i
01 - Ocean
02 - Lake
04 - Stream
10 - Well
20 - Land
40 - Unused
117
-------
The above codes are specified by the EPA. They must be presented at
times of storage and retrieval from the STORET system. These codes were
supplied to MWRC on January 9, 1969 by a representative of the FWPCA.
POLITICAL CODE
This ten-digit code is structured as follows:
XX XXX XXXXX
-^^Municipality
County (Exhibit 58)
State (Michigan 26)
The index for this code structure is supplied by the EPA for counties and
municipalities in Michigan. Use of this particular code structure is
recommended because:
1. The source for the code is the Bureau of the Census, United States
Government. Use of this code assures interface of MWRC data and data
generated by the Bureau of the Census. Such an interface could be of
vital significance in analysis of population trends and water resources.
2. The EPA intends to maintain this code structure for all STORET users.
3. The five-digit code represents population centers as defined by the
Bureau of the Census.
POLLUTANT PARAMETER CODE
This is a five-digit code identifying 99,999 potential kinds of water
quality parameters. At this time between five and six hundred have been
identified.
The assignment and significance of these codes are controlled by the EPA
and are published in the STORET system Parameter Code Book. Additional
parameters can be added as needed. (Exhibit 55)
118
-------
WISE SYSTEM CODES
PRIMARY STATION NUMBER
The WISE - Primary Station Number is identical to the Primary Station
Number shown in STORET codes. This common numbering system is vital to
assure a continuing interface of data processing potentials between the
EPA-STORET system and the MWRC-WISE system.
SECONDARY STATION NUMBER
This is a 12-digit code available in the STORET system and the WISE
system.
The code is structured as shown in the following description:
X X XXX XXXXX XX
STAFF EXCEPTION NUMBERI
TYPE OF USER (OWNER)-
TYPE OF USE (FACILITY)-
INTAKE - 01 to 49
OUTFALL - 51 to 99
50 = Plant
1 IDENTIFICATION OF USER
Political Entity
Industrial Organization
Private Owner
A unique number assigned to an
organization
STAFF EXCEPTION NUMBER
This is a one-digit code reserved for
follows:
Code
1
2
3
4
5
File should check
File should check
File should check
File should check
File should check
visits
File should check
due dates.
field staff use. The codes are as
Use
exceptions for all conditions
exceptions for monthly reports only
exceptions for visits only
exceptions for due dates only
exceptions for monthly reports and
exceptions for monthly reports and
119
-------
7 File should check exceptions for visits and due dates
8 File should not check exceptions - inventory only
9 Not used at this time
TYPE OF USER
This is a one-digit code which describes the Type of User and determines
the character of the remaining 10 digits of the 12-digit secondary code.
The Type of User codes are:
1 Municipal - Surface Water
2 Industrial - Surface Water
3 Private - Surface Water
4 Other - Surface Water
5 Municipal - Ground Water
6 Industrial - Ground Water
7 Private - Ground Water
8 Other - Ground Water
9 Other
If Type of User is industrial (2, 6) or commercial (4, 8), use the
Standard Industrial Classification Code (Exhibit 51).
If Type of User is municipal (1, 5), use the MMC Code (Exhibit 53).
TYPE OF USE
Three digits characterize the type of use. At this time, no significance
has been assigned to these three digits where the Type of User is repre-
sented by code:
3 Private - Surface Water
7 Private - Ground Water
8 Other - Ground Water
9 Other
Where the type of user code, however, is:
2 Industrial - Surface Water
4 Other - Surface Water - Commercial
6 Industrial - Ground Water
8 Other - Ground Water - Commercial
the three-digit code is referred to as the Standard Industrial Classifi-
cation Code.
120
-------
Where the type of user code is:
1 Municipal - Surface Water
5 Municipal - Ground Water
the three-digit code is referred to as the Michigan Municipal Classifi-
cation Code (Exhibit 53). The code describes the treatment plant size,
plant type, and collection system.
IDENTIFICATION OF USER
This is a five-digit code to identify the user. Two types of user codes
are recommended: (1) Industrial and (2) Municipal. The codes are:
(1) Industrial. A five-digit alphanumeric number indexing all users
classified as industrial or commercial.
(2) Municipal. The five-digit code supplied by the Bureau of the
Census. When applied to data maintained by MWRC, provision for
file maintenance must be made to assure interface to the STORET
file maintenance procedures.
INTAKE OR OUTFALL
A two-digit code can identify within each organization:
Intakes - 01 to 49
Outfalls - 51 to 99
Plant - 50
LOCATION NUMBER
A ten-digit number is used to identify the enforcement areas and river
and stream codes.
XX XX XX
1. ENFORCEMENT REGION
REGION 1=1
REGION 2=2
2. ENFORCEMENT DISTRICT
5 DISTRICTS CODED FOR MWRC USE
3. MAJOR RIVER BASIN
4. MINOR RIVER BASIN
XXX
5. TERMINAL STREAM NUMBER
The River Basin Coding system has been designed by the EPA. This coding
structure has previously been explained under STORET codes.
121
-------
EXHIBIT 51
STANDARD INDUSTRIAL CLASSIFICATION CODE (PARTIAL LIST)
2600 PULP AND PAPER
2621 Newsprint
2621 Kraft
2611 Sulphite
2611 Groundwood
2611 Neutral Sulphite Semi-chemical
2646 Board (building board, ceiling tile, linerboard, etc.)
2649 Paper Converting (tissue, corrugated boxes, cartons,
laminating, gummed paper)
2642 Fine Paper
2000 FOOD PROCESSING
2033 Canning, Fruit and Vegetable Packing (canned fruit and
vegetables, meat, etc., frozen fruit and vegetables, fresh
vegetable preparation and packing)
2026 Milk Processing (butter, fluid milk, condensed milk, dried
milk, whey powder, milk chemicals, ice cream mix, etc.)
2022 Cheese Making
2021 Meat Packing and Allied Industries (meat, poultry, fish,
animal and pet food)
2042 Grain, Cereals and Cereal Products (elevators, oil seed
mills, starch, milling, prepared cereals, malting)
2085 Brewing, Distilling and Wine Production
2099 Miscellaneous Foods (baking, soft drinks, vegetable oils,
margarine, shortening, candy, sugar refining, specialty
foods, potato products)
122
-------
EXHIBIT 52
TERMINAL STREAM NUMBERS (PARTIAL LIST)
Keweenaw County
465 Tobacco River
470 Winters Creek
475 Big Betsy River
480 Little Betsy River
485 Mendota Canal
490 Montreal River
495 Hoar Creek
500 Lake Lily Outlet
505 Lake Fanny Hooe Outlet
510 Silver River
515 Cedar Creek
520 Eliza Creek
525 Owl Creek
530 Jacobs Creek
535 Garden City Creek
540 Eagle River
545 Sand Hill Creek
550 Silver Creek
555 Seven Mile Creek
560 Gratiot River
555 Hill Creek
570 Brewery Creek
Houghton County
575 Gardeners Creek
580 Muggun Creek
585 Seven Mile Creek (opening of Portage
600 Salmon Trout River Lake ship canal;
615 Graveraet River considered to be
630 Elm River origin of Portage
635 Little Elm River River (08-23- )
Ontonagon County
645 Misery River
650 Black Creek
655 McCarthy Creek
660 Sleeping River
665 Tenmile Creek
670 Firesteel River
675 Flint steel River
123
-------
EXHIBIT 53
MICHIGAN MUNICIPAL CLASSIFICATION (MMC)
PLANT SIZE CODE
A = PLANT 40,000 POPULATION AND OVER
B = PLANT 10,000 TO 40,000
C = PLANT 2,000 TO 10,000
D = PLANT UNDER 2,000
E = NONE
PLANT TREATMENT TYPE
A = PRIMARY
B = TRICKLING FILTER
C = ACTIVATED SLUDGE
D = LAGOONS
E = AERATED LAGOONS
F = SEPTIC TANKS
G = FINE SCREEN
H = SAND FILTER
I = IMHOFF TANK
J = DILUTION
K = CHEMICAL PRECIPITATION
L = NONE
COLLECTION SYSTEM
S = SEPARATE
C = COMBINED
B = BOTH SEPARATE AND COMBINED
N = NONE
124
-------
EXHIBIT 54
COMPARISON OF CODING SYSTEMS
STORET SYSTEM
WISE SYSTEM
PRIMARY STATION NUMBER
County (2)
Numeric Sequence (4)
LATITUDE-LONGITUDE
« Seconds
Minutes
Degrees
RIVER BASIN
Major Basin
* Minor Basin
Terminal Stream
STORET STATION TYPE
Type of Data
Type of Site
State of Water
Source of Sample
Location C
Location A & B
Same
Not Used
See Location Number
Not Used
POLITICAL CODE
State
County
Municipality
SECONDARY (1)
Not Used
Staff
User
Water Use
Organization I. D.
Intake, Outfall
SECONDARY (2)
SECONDARY (3)
POLLUTANT PARAMETER
Kind of Water Quality
Same
Not Used
Not Used
Same
LOCATION NUMBER
Region
o District
Major Basin
e Minor Basin
Terminal Stream
RIVER MILE INDEX
Level
Mileage
Index
Not Used
125
-------
EXHIBIT 55
Parameter
Acetic Acid
Algae - Floating Mats
Algae - Total
Alkalinity - Bicarb.
Alkalinity - Carbonate
Alkalinity - Total
Aluminum - Total - ug/1
Anmonia - Nitrogen
Ammonia - Nitrogen Iba/day
Antimony - Total ug/1
Beta - Net
Beta - Total
Beta - Total - Error
Biomass - Plankton
BOD-5 - mg/1
BOD-5 Ibs/day
BOD-20 day - mg/1
BOD Ultimate First Stage
Cadmium - Dissolved
Cadmium - Total
Calcium
Carbon Dioxide
CCE
Chloride - mg/1
Chloride - Ibs/day
Chlorine - Total RESid.
Chloroform Extractables
(oil-grease)
Chromium - Hexavalent Iba/day
Chromium - Hexavalent
Chromium - Trivalent
Chromium - Total - ug/1
Chromium - Total - Ibs/day
Cloud Cover
COD
COD - Ibs/day
Coliform-Confirmed (Eoughton)
Coliform - Fecal
BOD
Cd
Cd
Ca
C02
Cl
Cl
Cr
Cr
Cr
Cr
Ci
ABBREVIATED STORE! PARAMETER LIST
Units
mg/1
severity*
cells/ml
mg/1
mg/1
mg/1
ug/1
mg/1
Ibs/day
ug/1
pc/1
pc/1
pc/1
ml/1
mg/1
Ibs/day
mg/1
mg/1
ug/1
ug/1
mg/1
mg/1
ug/1
mg/1
Ibs/day
mg/1
mg/1
Ibs/day
ug/1
ug/1
ug/1
Ibs/day
percent
mg/1
Ibs/day
MPN
MF/100 ml
STORE! No.
90006
01325
60050
00425
00430
00410
01107
00610
90009
01097
90005
03501
03502
00570
00310
85001
00324
00320
01025
01027
00915
00405
32005
00940
85011
50060
32270
90003
01032
01033
01034
85007
00032
00335
90007
31505
31616
STORET
Parameter Name
ACETIC-A
ALGAEMAT
ALGAETOT
ALK-BIC
ALK-CAR3
ALK-TOT
ALTOT-UG
NH3-N
NH3-NJ/D
SBTOT-UC
NET-BETA
BETA-TOT
BET-T-ER
BIO-PLTN
BOD-5
BOD-5J/D
BOD-20
BOD-UF
CD-UG/L
CDTOT-UG
CALCIUM
C02
CCE-UG/L
CL
CL J/DAY
CL2-T-RS
CE-MG/L
CR6J/DAY
CR6-UG/L
CR3-UG/L
CRTOT-UG
CRTOTJ/D
CLOUDCOV
COD
CODff/D
COLITMPN
COLI-FEC
*Coding for Severity: 0-Hone, 1-Mild, 2-Moderate, 3-Serious, 4-Extreme (Report as Whole Number) (Revised 4/20/71)
126
-------
EXHIBIT 55
Continued
Parameter
Color
Coliform - Les Agar
Conductivity
Copper - Dissolved Cu
Copper - Total - ug/1 Cu
Copper - Total - Ibs/day Cu
Cyanide - mg/1 CN
Cyanide - Ibs/day CN
Debris - Floating 0-4
Deox. Const. Kl
Depth - Sample From Surf.
DO
DO - Percent Sat.
Fish - Dead 0-4
Flow - Conduit
Flow - Stream
Flourlde F
Hardness - Total CaC03
Ice Cover 0-4
Iron - Total - ug/1 Fe
Iron - Total - Ibs/day Fe
Lab. Number
Lead - Dissolved Pb
Lead - Total Pb
Magnesium Kg
Manganese Mn
Mercury - Total - ug/1 Hg
Mercury - Total - Ibs/day Hg
Methylene Blue Active Substances MBAS
Nickel - Dissolved Mi
Nickel - Total - ug/1 , Ni
Nickel - Total - Ibs/day Ni
Nitrate N
Units
PT-CO
MF/100 nl
mlcrombos-25oC
ug/1
ug/1
Ibs/day
ng/1
Ibe/day
severity*
ft.
mg/1
percent
severity*
MOD
cfs
mg/1
ng/1
severity*
ug/1
Ibs/day
ug/1
ug/1
mg/1
ug/1
ug/1
Ibs/day
ng/1
ug/1
ug/1
Ibs/day
mg/1
STOEEI No.
00080
31504
00095
01040
01042
85009
00720
85008
01345
00325
00003
00300
00301
01340
50050
00060
00950
00900
01355
01045
85012
00008
01049
01051
00925
01055
71900
85013
38260
01065
01067
85010
00620
STORE!
Parameter Name
COLOR
COLI-TMF
CNDUCTVY
CU-UC/L
CUTOT-UG
CUTOT0/D
CYANIDE
CYANJ/D
DEBR-FL
DEOXCON
DEPTH
DO
DO-ZSAT
FSH-DEAD
FLOH-MGD
FIOW-CFS
FLUORIDE
HARD-TOT
ICE COV
FE-UG/L
IRONJ/D
LAB NO.
PB-UG/L
PBTOT -UG
HG
HN-UG/L
HGTOT-UG
HGTOTf/D
NBAS
NI-UG/L
NITOT-UG
NITOTJ/D
N03-N
* Coding for severity: 0-None, 1-Mild, 2-Moderate, 3-Serious, 4-Extreme (Report as Hhole Number) (Revised 4/20/71)
127
-------
Parameter Repo
Nitrate + Nitrite N
Nitrogen - Total - KJeldahl H
Nitrogen - Total H
Odor at Room Temperature 1-20
Oil - Grease, Total Oil
Oil - Grease (visual) 0-4
Organic - Nitrogen "
ORP
pH 0-14
Phenol - ug/1
Phenol - Iba/day
Potassium K
Precipitation - Total
Phosphorous - Total P
Phosphorous - Total - Ibs/day P
Phosphorous - Soluble Ortho P04 P
Phosphorous - Soluble Ortho Ibs/day F
Phosphate Removal
Residue - Total
Residue - Total - Filt.
Residue - Total - Hon. Filt. - ng/1
Residue - Total - Hon. Filt. -
Ibs/day
Residue - Total Filt. - Its/day
Residue - Vol. -Non. Filt.
Residue, Settleable
Radionuclides
Silica - Dissolved si02
Silica - Tot S102
Sodium Na
Sulfate 504
Sulflte S03
Temperature - Air
Temperature - Water
Temperature - Water
Transparency
Units
mg/1
mg/1
mg/1
Intensity
mg/1
severity*
mg/1
SU
ug/1
Ibs/day
mg/1
in/day
mg/1
Ibs/day
mg/1
Ibs/day
percent
mg/1
ng/1
mg/1
Ibs/day
Ibs/day
mg/1
mg/1
mg/1
mg/1
mg/1
mg/1
mg/1
oF
oC
oC
oF
in.
STORET Ho.
00630
00625
00600
00085
00550
01300
00605
00090
00400
32730
85003
00935
00045
00665
85004
00671
85005
90002
00500
00515
00530
85002
90010
00535
00546
90004
00956
00955
00930
00945
00740
90001
00020
00010
00011
00077
EXHIBIT 55
Continued
STORET
Parameter Name
N02N03-N
N-T-KJEL
N-TOT-MG
ODOR
OIL-MG/L
OIL-GRSB
N-ORG
ORP.-MV
PH
PHENOL
PHENOLSD
K
PRECIP-T
P-TOT
P-TOT0/D
SOF04-P
SOP04PJD
TOTPREMX
SOLIDTOT
SOLIDDIS
SOLIDSUS
SOLSUS0D
SOLDIS0D
SOLID-SV
SOLIDSET
RADC/MPC
S102
SI02-TOT
SODIUM
S04
S03
TEMP-F+
TEMPAIRC
TEMPH20C
TEMPH20F
TRANSPAR
* Coding for Severity: 0-None, 1-Mild, 2-Hoderate, 3-Serious, 4-Extreme (Report as Whole Nuaber). (Revised 4/20/71)
128
-------
EXHIBIT 55
Continued
Parameter
Turbidity
Turbidity (Clarity)
Total Oxygen Demand
Width - Stream
Wind - Direction
Wind Velocity
Zinc - Dissolved
Zinc - Total - ug/1
Zinc - Total - Ibs/day
0-4
clockwise
from true H
Zn
Zn
Zn
Units
JCU
severity*
Ibs/day
ft.
degrees
HPH
ug/1
ug/1
Ibs/day
STOREI Ho.
00070
01350
90008
00004
00036
00035
01090
01092
85006
STORET
Parameter Nam
TURB-JCU
TURB-SEV
TOD0/D
WIDTH
WIND DIR
WIND VEL
ZINCUG/t
ztrroT-UG
ZNTOTJ/D
* Coding for Severity: 0-None, 1-Hild, 2-Hoderate, 3-Serlous, 4-Extreme (Report as Whole Nunber). (Revised 4/20/71)
129
-------
MICHIGAN ENFORCEMENT DISTRICTS
EXHIBIT 56
CENTRAL SHARED
TER-LANSING
-REMOTE ACCESS TELEPHONE LINES
REMOTE TERMINAL ACCESS POINTS
130
-------
EXHIBIT 57
MINOR RIVER BASINS IN MICHIGAN
25
26
08 WL - Western Great Lakes
23 Lake Superior
2*4 Green Bay Western Shore
Fox-Wol f
Lake Michigan Western Shore (includes
North Suburbs of Chicago which
drain to Lake)
Lake Michigan
Lake Michigan Northeastern Shore
Muskegon River
Grand River
KaIam* zoo
St. Joseph River
Lake Huron Western Shore
Saginaw River _
Lake St. Clair and
27
28
29
30
3!
32
33
34
35
36
37
49
Lake Erie Western Shore-Detroit River
Lake Huron-North Shore
Calumet-Burns Ditch Complex
LAKE
ERIE
131
-------
STORET SYSTEM
COUNTY CODE NUMBERS
EXHIBIT 58
132
-------
SECTION VIII
WISE INPUT DOCUMENTS AND INPUT SYSTEMS
Input forms and techniques are important aspects of system design because
input processing costs usually represent a large part of the total system
operating cost and time. Consequently, analysis has been made of tech-
niques that would provide improved efficiencies in input processing. Some
techniques described in this Section are optical character reading (OCR),
computer-prepared documents, and key-to-tape. Recommendations are pro-
vided for the future use of one or more of these methods.
Currently, data is entered into the computer system from punched cards,
which have been transcribed from preprinted forms. For ease of punching,
the forms have been designed to reflect punched-card column alignment.
One report, the Monthly Operating Report (INFORM), is computer-printed,
and is used as an input document.
Fifteen documents serve as source media for all information compiled and
entered into the WISE system. The titles of these documents are:
Station Number Request Form (Exhibit 30)
New Station Set-Up Sheet (Exhibit 32)
Monthly Operating Report (INFORM) (Exhibits 44 and 45)
Monthly Report of Field Survey (Exhibit 59)
District Field Visits (Exhibit 60)
Annual Ratings and Tax Exemption Status (Exhibit 61)
Monthly Report of Commission Action (Exhibit 62)
Monthly Report of Judicial Proceedings (Exhibit 63)
Monthly Report of Performance Scheduled (Exhibit 64)
Monthly Report of Performance Completed (Exhibit 65)
Report Titles (Exhibit 66)
Certified Waste Treatment Plant Operators (Exhibit 67)
Organization and Outfall Description Card (Exhibit 68)
Address Correction Card (Exhibit 69)
River Basin and Organization Card (Exhibit 70)
STATION NUMBER REQUEST FORM (EXHIBIT 30)
(
This document is initiated to request a new station number or request a
number for a new outfall. It is sent to Central Administrative Control
by the district engineer.
Section VI, Procedure 3 describes the clerical processing requirements
for this document.
133
-------
NEW STATION SET-UP SHEET (EXHIBIT 32)
This document is initiated for each new station. All of the information
on this source document becomes part of the computer master file. From a
master file so constructed, the computer will print a variety of reports
such as:
Monthly Operating Report, listing parameters to be measured.
Preprinted envelopes or gummed-back address labels for special
mailings in connection with MWRC functions.
RECORD CODE
COLUMN 1-2
10
TITLE
Organization Name
DESCRIPTION
Allows 30 characters each to record the
name of the organization and the person
with whom contact is maintained.
11
20
Outfall Name
Shows address in two 30-character fields.
Allows 30 characters to record name of
outfall and person with whom contact is
maintained.
21
60
61
Organization Name
70
80
Outfall Name
(9-13)
Records address of outfall in two
30-character fields.
Two 34-character records show the name of
the organization as it will appear on the
Monthly Operating Report. Each record
prints one line of description with the
same spacing as recorded. At least one
record is required for each station.
34 characters identify a specific outfall.
This record is optional.
Parameter Codes: Up to ten separate
parameter codes may be established for
each station. In addition, one or more
MWRC orders may be recorded for each
parameter. Each order number and/or
parameter code will print on a separate
line on the report. In no event, however,
may there be more than ten lines of such
information (ten distinct combinations of
order number and/or parameter code).
MWRC Order Number: Five-digit commission
order number. It may or may not be assoc-
iated with a specific commission order.
134
-------
RECORD CODE
COLUMN 1-2
TITLE
(14-18)
(56)
(57-64)
(65)
80 (66-73)
80
(74-80)
DESCRIPTION
Parameter Name: Eight-character abbre-
viated name (parameter code list from
which the parameter number was obtained).
(Blank)
Standard Value-Average: Value assigned
by the MWRC as applicable to this param-
eter. This value may be recorded in
eight positions as follows:
23.64
82,428.1
.369
12345678
Commas and decimals require one character.
Try to position decimals in the same
column for a given organization (outfall).
There are eight positions allotted on the
report to display this information.
(Blank)
Standard Value-Limit: In some instances
the commission order may specify not only
that a certain average reading is to be
maintained over a period, but that no
single reading may be in excess of a
specified figure. In such instances
record the limit in this area.
(Blank)
MONTHLY OPERATING REPORT (EXHIBITS 44 and 45)
This report, printed by the computer and sent to the organization
affected, is used as an input document by the Certified Operator to
record the parameter measurements and to report back to the MWRC staff.
135
-------
Multiple copies of the form are supplied because:
The organizations needs more than one month's supply of forms.
Reporting is required for more than one station number (plant
location, outfall, and intake).
More than seven parameters are reported for a particular station.
The procedure for recording parameter measurements is described in the
following instructions:
1. MONTHLY OPERATING REPORT FOR MAY, 1971
Fill in the month and year covered by this report. The report you submit
the first week in June is the May report.
2. THIS IS YOUR MONTHLY REPORT FORM FOR 48-INCH PIPE TO SWAN CREEK
ZAP MOTORS CORP.
NUT DIVISION, PODUNK
A three-line name will appear in this box which is the name we have
assigned to the outfall. If the first line says "All Outfalls," then the
form and station number apply to the plant location. Any changes in out-
fall name or location can be handwritten in by the operator when he
submits this report.
3. a. ZAP MOTORS CORP.
ANDY CRANK, VICE PRES.
1901 HORSELESS AVE.
WILMINGTON, DELAWARE
b. NUT DIVISION, ZAP MOTORS
I. M. NUT, PLANT MGR.
BOLT & THREAD STREETS
PODUNK, MICHIGAN
This box contains two separate names and mailing addresses.
a. This is the name and address of the parent owner of the outfall
or plant.
b. This is the name and address to which this form and any other
official correspondence will be mailed. This has been estab-
lished through prior correspondence with your company. Not all
companies replied to the initial questionnaire. If you wish to
change either of the two addresses, please request the change by
letter from your management.
STATION R7nn91
NUMBER 870021
(1-8)
This is the six-digit station number assigned to each outfall location
and/or plant site. It represents a physical location. If outfall or
descriptions change, notify MWRC staff.
136
-------
5.
A.
B.
C.
D.
E.
F.
Order No.
Param. No.
NAME
UNITS
^^STD.
DATE\^
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
\23
(9-13) 09432
(14-18) 00400
PH
SU
>
*
6.5
DAILY AVG.
< 9.5
HIGH
LOW
(9-13) 09432
(14-is) 00530
SOLIDSUS
MG/L
<
X
i^
DAILY AVG.
U-
< 30
HIGH
L
LOW
-
(9-13) \
(14-18) \
\
*
DAILY AVG.
.
\
\
\
\
\
\
\
\
\
«^^ -^^^^^
/
\
\
/
A. Order No.; Under formal Michigan Water Resources Commission enforce-
ment actions, the Commission adopts Final Orders of Determination or
Orders of Determination against plants or organizations discharging
wastes. In other instances, a company may enter into a voluntary
stipulation with the Commission to limit their waste discharge. If
the outfall or plant is covered by an existing Order or Stipulation,
the Commission assigned number will appear in this block, preprinted
by the computer. If no order or stipulation is outstanding, this
space will be blank.
B. Parameter No. ; Each parameter has been assigned a five-digit para-
meter number for computer sorting. That number, preprinted by the
computer, will appear in this block, and is for Commission use.
137
-------
C. Name : Each parameter has a standard abbreviated name of eight char-
acters, preprinted by the computer on this line. (See Exhibit 55.)
D. Units : For standardization a parameter must be reported in certain
units. The most common are:
mg/1 - milligrams per liter (a concentration)
ug/1 - micrograms per liter (multiply mg/1 by 1,000
to get micrograms per liter)
Ibs/day - pounds per day (a load) obtained by multiplying
flow (MGD) by concentration (mg/1) by 8.34
MGD - million gallons per day (flow)
The unit for each parameter will be preprinted by the computer on
this line. The parameter readings must be recorded in the units
specified for that column.
E. STD: If an Order or Stipulation has set maximum, minimum, or average
values that your effluent or plant must meet, then these values will
be preprinted by the computer in these blanks .
If you do not have a Stipulation or Order from the Commission, a
number may still be printed in these blanks. This number has been
entered by a staff member of the Commission and is to allow the
computer to evaluate your effluent. This number may be adjusted
upward or downward at a later date .
F. Date: If data is collected once daily, enter the value as a Daily
Average. If data is collected more frequently, compute the Daily
Average (arithmetic) and record it. In addition, record the highest
value and lowest value found each day. Coliform data, if reported,
should be a geometric average. Please use units specified. At end
of month compute the Monthly Average and record as Month Summary .
Note:
Geometric average is found by averaging the logarithms of the
numbers and finding the antilog.
MONTH
SUMMARY
(56-64)
1 I I I I 1 1 1
X
X
Month Day Year
(75-76) (77-78) (79-80)
(56-64) "NX"
1.,.,, , , XV
X
DUP PUNCH 75-80
(56-64)
1,1
\
The value computed should be recorded in this block.
end in the far right space .
The number must
8
THIS
NOT THIS
138
-------
The month (as a number), last day of the month, and year should be
recorded below the summary.
The frequency of reporting may be established in your Order or
Stipulation. If you do not have a pre-established frequency, please
contact the Water Resources Commission Basin Engineer for your area.
6.
SIGNATURE OF CERTIFIED OPERATOR
SAM TREATMENT
Certification Number W6000
R 45159/70
The name of the Certified Operator and his certification number will
appear pre-printed in these blocks. The Certified Operator must sign
this form prior to mailing. If the signature does not match the
Certified Operator's, a written explanation should accompany the
report. Those plants with more than one Certified Operator have
designated one as the "chief" operator, and his name will appear on
this report. Any of the other Certified Operators may sign this form
without written explanation.
7.
FOLD HERE THIRD
. ______..!
'; I PLACE I |
I FIRST CLASS | I
STAMP HERE I ,
_ < | '55
- I ________ I II
I *"
STATE OF MICHIGAN I |
WATER RESOURCES COMMISSION
COMPREHENSIVE STUDIES SECTION
STEVENS T. MASON BUILDING
LANSING, MICHIGAN 48926
_J
FOLD HERE SECOND
Any written comments concerning your report may be recorded on the
back of the form. The form can then be folded and mailed to our
Lansing Office.
139
-------
This form must be mailed by the 2nd calendar day of the month
following the month covered by the report. The report for May
must be mailed by June 2. The only exception to this will be
in cases where there is a lag time between the sampling date
and when results of analysis are available, for example 5-day
BOD. In those cases where a lag is absolutely necessary, the
form must be mailed no later than the 5th calendar day of the
month.
MONTHLY REPORT OF FIELD SURVEY (EXHIBIT 59)
This document is used to report a field survey. The survey will be pre-
sented on the report and on the same line of information indicated by:
RECORD CODE
COLUMN 1-2 TITLE
Record Code
63
73
Station Number
(3-8)
Outfall
83
Parameter
DESCRIPTION
A 3 entered in column (2) indicates to
the computer that the data submitted is
associated with field surveys.
If this is the only number that appears,
the month and year will print on the same
line as the organization name provided a
6 is entered in column (1).
A 7 entered in column (1) will associate
the survey with the data appearing on the
report line on which the outfall name is
printed.
An 8 entered in column (1) will associate
the survey with the data appearing on the
report line on which the parameter is
shown. In this instance, however, the
parameter code number must be shown in
addition to the station number and/or
order number.
MWRC Order
(9-13)
Parameter
(14-18)
Date
(43-46)
This number need not be recorded unless
there is more than one Commission Order
outstanding.
Enter the parameter code to which the
survey is applicable.
Month and year of the survey. Because
this information would be 'identical for
all entries submitted that month, it is
entered only once unless late information
is being submitted.
140
-------
EXHIBIT 59
MONTHLY REPORT OF FIELD SURVEY
PLRFORMANCE AND ACTION REPORT
ncHiGAN HATER RESOURCES COMMISSION
1 6
76 soil? 21 Ise 60
RECORD STATION NUMBER AND INDICATE NATURE OF SURVEY.
SUBMIT PROMPTLY' MONTHLY.
1-
-'2
3
3
3
3
3
1
3
3
3
3
3
3
3
3
3
.1
3
3
3
3
STATION
NUMBER
3 8
ORDER OR
ACTION NUMBER
9 13
._,..!
STORE!
PARAMETER
NAM OR
NUMBER
14 18
STARTS INDUSTRIAL
^ SURVEY
COMPREHENSIVE
STUDIES
OATA UNIT
KEY PUNCH
COMPREHENSIVE
STUDIES
« REPORT LOCATION
SCHEDULE: Submit on 1st day
of month
DATE
MONTH - YR
i*3 46
i
4 DESCRIBE NATURE OF FIELD SURVEY IN COLUMN 1
6 SURVEY OF ORGANIZATION
7 SURVEY OF A SPECIFIC OUTFALL
8 SURVEY IN CONNECTION WITH INDICATED POLLUTANT PARAMETER
DAY
STATION NAME OR REMARKS
PUNCH
DO NOT PUNCH DAY OF
SURVEY INTO CARD
141
-------
DISTRICT FIELD VISITS (EXHIBIT 60)
This document is used by MWRC personnel to report that a field visit was
made to the organization.
As with the field survey, the field visit may be associated with a partic-
ular outfall and/or parameter code number.
Code 2 entered in column 2 of all records indicates to the computer that
the information submitted is associated with a field visit.
RECORD CODE
COLUMN 1-2
TITLE
DESCRIPTION
62 Station Number
(3-8)
72
82
Outfall
Parameter
(14-18)
Order
(9-13)
Parameter
(14-18)
Date
(43-46)
If station number is the only entry to
the line, the month and year of the visit
will print on the same line as the organi-
zation provided that a 6 is entered in
column 1.
If the field visit should be associated
on the report line with the specific
outfall, enter a 7 in column 1.
If the field visit was in connection with
a specific parameter, an 8 entered in
column 1 will associate the month and
year with the report line on which the
indicated parameter number appears.
This number need not be recorded unless
there is more than one Commission Order
outstanding.
If applicable, enter the parameter code
number with which the field visit is to
be associated.
Month and year of the visit. Because
information would be identical for all
entries submitted that month, it is
entered only once unless late informa-
tion is being submitted.
142
-------
EXHIBIT 60
DISTRICT FIELD VISITS
MONTHLY PERFORMANCE REPORT
MICHIGAN WATER RESOURCES COMMISSION
1 e
76 BO
17 2IJC2 6<| | « REPORT LOCATION
RECORD STATION NUMBER AND INDICATE NATURE OF
VISIT SUBMIT TO REGIONAL OFFICE PROMPTLY
AT END OF MONTH
1 '
2
Z
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
PRIMARY
STATION
NUMBER
3 8
MWRC ORDER
Oft ACTION
NUMBER
9 13
STORE T
PARAMETER
NAME OR
NUMBER
14 IB
DATE
MONTH YR
43 46
) DESCRIBE NATURE OF FIELD VISIT IN COLUMN 1.
HAY
Str.Htn:
unuTu ne
COMPANY NAME
OR REMARKS
PUNCH
1
OO NOT PUNCH DAY OF VISIT INTO CARD.
.) - VISIT TO ORGANIZATION
T - VISIT TO A SPECIFIC OUTFALL
3 - VISIT IN CONNECTION WITH INDICATED POLLUTANT PARAMETER.
143
-------
ANNUAL RATINGS AND TAX EXEMPTION STATUS (EXHIBIT 61)
Although this document is exhibited as a manually-prepared document, it is
recommended that a punched-card output be obtained from the computer.
One card would be obtained for each applicable organization, outfall, and
parameter code. The cards prepared (punched-out) by the computer would
be interpreted and submitted to the District Engineer along with a list-
ing of those cards. The annual rating would be a one-character entry
made by the Regional Engineer directly on the card. After punching that
character into the card, the card would be used as input to update the
Monthly Operating Report with the annual rating.
Similarly, the tax exemption status is a one-character entry to the card.
The form, however, may be used during the operating year to record changes
in the organization's tax exemption status.
RECORD CODE
COLUMN 1-2
68-
78
88
TITLE
Record Code
(1)
Record Code
(2)
Station Number
(3-8)
MWRC Order
Number
(9-13)
Parameter
(14-18)
Month-Year
(43-46)
Annual Rating
(47)
Tax Exemption
(48)
DESCRIPTION
A 6, 7, or 8 indicates that the data
presented is to be associated with an
organization, an outfall, or parameter
code, respectively.
An 8 in column 2 indicates the informa-
tion is associated with Annual Ratings
and/or Tax Exemption status of an
organization.
Six-digit station number assigned to the
organization and outfall.
May be shown if there is more than one
order number outstanding for the same
organization (or outfall). Otherwise,
it need not be shown.
Enter the parameter code for which the
information applies.
Although only the year will be displayed
on the annual report, the month is
recorded to maintain continuity with
preparation of other data.
Enter the applicable rating. Ratings for
more than one year may be submitted pro-
vided separate documents are prepared.
i /
The tax exemption status may be shown in
this column. The information may be
submitted any time during the year.
144
-------
EXHIBIT 61
ANNUAL RATINGS AND TAX EXEMPTION STATUS
PERFORMANCE AND ACTION REPORT
MICHIGAN WATER RESOURCES COMMISSION
RECORD STATION NUMBER, ANNUAL RATING AND CURRENT TAX
EXEMPTION STATUS.
I-}
k
6
7
8
8
e
8
f,
8
0
e
8
b
B
a
6
a
e
8
8
8
8
B
fl
3
PRIMARY
STATION
NUMBER
3 8
MWRC ORDER
OR ACTION
NUMBER
9 13
s rongT
PARAMETER
NAME OR
NUMBER
it ^§
1111
DATE
MONTH - YR
43 tft
!*
T
A
17
A
R
lit
PUQII?
DATA UNIT
KEY PUNCH
55SfrlCHEK8IVE
STUDIES
^ REPORT LOCATION
COMPANY NAME
OR REMARKS
^ PUNCH
TAX EXEMPTION STATUS * * ANNUAL RATING
- ORGANIZATION RATING NONE IN EFFECT, ELIGIBILITY - N A,B,C,D, or E
- OUTFALL RATING NOT KNOWN
- PARAMETER RATING ELIGIBLE AND IN EFFECT - - Y
ELIGIBLE BUT RESCINDED R
145
-------
MONTHLY REPORT OF COMMISSION ACTION (EXHIBIT 62)
This form is used to submit the actions of the Commission as they relate
to a particular organization.
RECORD CODE
COLUMN 1-2
64
74
84
TITLE
Record Code
(4)
Station Number
(3-8)
MWRC Order Number
(9-13)
Parameter
(14-18)
Date
(43-46)
Status
(47)
DESCRIPTION
The information may be associated with an
organization, outfall, or parameter by
entry of 6, 7, or 8, respectively to the
first column.
Enter the station number that identifies
the particular organization and outfall.
Enter the order number. If it is a new
file being forwarded to the field for
more information, show the order number
as an alphabetic character followed by
four numbers. This separates one request
for additional information from another.
If the order number is associated with a
particular pollutant, indicate in this
column by showing the applicable STORET
parameter code.
This is a monthly report, so month and
year would be identical for all entries
made in the same month.
Enter R to show a file has been initiated
and additional information has been
requested from field personnel.
Enter C when the file has been given to
the Commission for action, showing the
date of submission. This date will be
constant until a final order is issued
when the date of such an order will be
entered.
146
-------
RECORD CODE
COLUMN 1-2
TITLE
Status
(47)
DESCRIPTION
Enter S when a show-cause hearing is
scheduled.
Enter H when hearing is before commis-
sioner.
Enter D when file has been declared in
default of order or stipulation.
Type
Seven codes are used to indicate the type
of action a particular order is receiving:
S - Routine notice of statutory hearing
has been forwarded to affected parties.
0 - The order has been deemed to be a
matter of public interest, and inter-
ested or affected parties have been
advised of the date of the hearing.
V - The organization has made a volun-
tary stipulation in which they agree to
comply with the order as prepared by
the MWRC.
D - The Commission has issued an Order
of Determination requiring compliance
by the affected organization.
F - When all administrative hearings
have been exhausted, the Commission
issues a Final Order as of a specific
date. The organization may choose to
comply or to seek relief through judi-
cial proceedings.
R - Action has been recessed.
A - A Final Order or stipulation has
been authorized.
147
-------
EXHIBIT 62
MONTHLY REPORT OF COMMISSION ACTION
PERFORMANCE AND ACTION REPORT
MICHIGAN WATER RESOURCES COMMISSION
STARf.
COLS. *"
REC.
CODE
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
! 4
1
[*
A
6
PRIMARY
NUMBER
3 8
76 80
MWRC ORDER
NUMBER
9- 13
17 21
STORET
PARAMETER
NAME OR
NUMBER
14 IS
S\k
^
^
^
^
^
^
^
^
^
^
^
S
^
S
^
^
^
Ri
^
^
^
$
42
82
DA
MO.
43
TE
YR.
74
b
i
A
88
1
E
48
REPORT LOCATION
COMPANY NAME
OR REMARKS
6-ORGANIZATION
7-OUTFALL
8-PARAMETER
HEARING BEFORE HEARING COMMISSIONERS
PRIOR TO ORDER
ACTION HAS BEEN APPROVED BY W.RC'C
A SHOW CAUSE HEARING IS SCHEDULED'S
DECLARED IN DEFAULT OF ORDER OR STIPULATIONS
a STATUTORY HEARING SCHEDULED
tfeAN OPEN PUBLIC HEARING HAS
BEEN SCHEDULED I (
R»ACTION HAS BEEN RECESSED
A*A FINAL ORDER OR STIPULATION
HAS BEEN AUTHORIZED
D--ORDER OF DETERMINATION ADOPTED
^VOLUNTARY STIPULATION SIGNED
FiRNAL ORDER ADOPTED
-------
MONTHLY REPORT OF JUDICIAL PROCEEDINGS (EXHIBIT 63)
This form is used to enter judicial proceedings.
RECORD CODE
COLUMN 1-2
TITLE
DESCRIPTION
65
75
85
Record Code
(1)
Record Code
(2)
Station Number
Order Number
Parameter
Record level of interest to which informa-
tion is applicable by entering 6, 7, or 8
for organization, outfall or parameter,
respectively.
A 5 always appears in this column indi-
cating to the computer that the informa-
tion pertains to legal or judicial
proceedings.
Same as in Exhibit 62 description.
Date
(43-46)
Who
(47)
Type of Action
(48)
Month and year in which the Commission
received notice of the action. (Note
that use of the date differs from that
used in association with Commission
Actions.)
Indicate which legal office is repre-
senting MWRC:
P - Local prosecutor.
A - State Attorney General.
Indicate what kind of action has been
initiated:
P - Petition court for trial date.
T - Date for trial has been estab-
lished by the court.
A - Organization has appealed the
trial verdict.
See Exhibit 63 for additional codes.
149
-------
EXHIBIT 63
MONTHLY REPORT OF JUDICIAL PROCEEDINGS
PERFORMANCE AND ACTION REPORT
MICHIGAN WATER RESOURCES COMMISSION
START.
PUNCH.
COLS. '
REC
CODE
1 2
5
S
3
5
5
3
S
5
5
S
5
5
5
S
s
5
5
S
5
5
1 2
1 6
PRIMARY
STATION
NUMBER
3 8
3 8
76 80
MWRC ORDER
OR ACTION
NUMBER
9 13
9 13
17 21
STORET
PARAMETER -
NAME OR
NUMBER
14 18
>v\>
1
42
^
Vs
^
^
^
s\^
^
S^N
^J
^
^
J^
^
^
^
V
^
^
^s
^
42
124 128
DATE
MO.
43
YR.
46
43 46
ISO
W
H
0
47
47
31
W
H
T
48
48
« REPORT LOCATION
COMPANY NAME
OR REMARKS
PUNCH
A ENTER APPLICABLE SHOW i A
6-ORGANIZATION INFORMATION DATE * £gJJ* jTo"R SwRc" " C°U"T
7-OUTFALL uncT i D-OECISION FOR DEPENDENT
fl-PflRBUPTFR Jeiwr * HtlOLO ACTION
0 rMnnmc 1 tK KtUini 1-fNifUNCTfOM ISSUED
ACTION A N-NESOTIATINC JUDCEUENT
P-PETITION THE COURT FOR A HEARING
MWRC REPRESENTED BY:A "-""""FILED70 *TTO"MEY SCNIH*L
STATE OF MICHIGAN, ATTORNEY GEN.-A T-DATE FOR TRIAL AISIONED tt COURT
LOCAL PROSECUTOR-P W-CASE WITHDRAWN
150
-------
MONTHLY REPORT OF PERFORMANCE SCHEDULED (EXHIBIT 64)
This document is prepared monthly to record construction schedule dates
applicable to an organization, its outfall and/or parameter. Columns 1-18
are completed the same as other monthly reports. The use of column 42 and
manipulation of dates, however, varies.
RECORI? CODE
COLUMN 1-2
66
76
86
TITLE
Type of Action
(42)
Dates
(43-58)
DESCRIPTION
The construction dates are described by
the type of action that generated them:
C - Original Commission Order.
M - Modified Commission Order (modified
by Commission).
J - Commission Order confirmed (or
modified by court order).
Four scheduled dates may be submitted
showing month and year for each:
(1) Construction Plans - Preliminary
(2) Construction Plans - Final
(3) Construction - Start
(4) Construction - Finish
The computer will compare the current
month and year with the scheduled month
and year to print xxx in the actual com-
pletion column of the report unless the
completion date has already been sub-
mitted. (This xxx signifies that a
construction due date occurs in the next
month.)
In the month in which the completion was
to have been recorded, the computer will
print N indicating that the phase indi-
cated has not been completed.
When an actual date is submitted, it will
supplement either the xxx or the N by
showing the month and year of completion.
151
-------
EXHIBIT 64
MONTHLY REPORT OF PERFORMANCE SCHEDULED
PERFORMANCE AND ACTION REPORT
MICHIGAN WATER RESOURCES COMMISSION
STARTS
COMPREHENSIVE
STUDIES
DATA UNIT
KEY PUNCH
COMPREHENSIVE
STUDIES
pu^r-H
COLS. ^
REC.
CODE
6
6
6
6
6
e
6
6
6
e
6
6
6
6
6
e
6
6
6
e
6
6
1 6
PRIMARY
STATION
NUMBER
MWRC ORDER
OR ACTION
NUMBER
17 21
STORET
PARAMETER
NAME OR
NUMBER
fcKJ
0
N
92 94| 1OO IO2II08 IIOIII6 118
SCHEDULED PERFORMANCE DUE DATES
PLANS
PRELIM.
MO
.
YR.
FINAL
MO
1
,
1
, 1 ,
YR.
CONSTRUCTION
START
MO
i
!
,
YR.
,
FINISH
MO | YR.
,
« REPORT LOCATION
COMPANY NAME
OR REMARKS
6-ORGANIZATION
7-OUTFALL
B-PARAMETER
ENTER APPLICABLE DATES
AS THEY BECOME AVAILABLE
C-ORIGINAL MWRC ACTION HAS ESTABLISHED DATES SHOWN,
M-MWRC ACTION HAS MODIFIED ORIGINAL DATES TO THOSE SHOWN.
0-COURT ORDER HAS MODIFIED MWRC DATES TO THOSE SHOWN.
152
-------
MONTHLY REPORT OF PERFORMANCE COMPLETED (EXHIBIT 65)
An MWRC order contains specifications for the quality of water that is
discharged by an organization. To meet the standards, an organization
may be required to construct facilities ranging from modest expansion of
existing operations to major construction. Whatever the extent of the
construction required, provision is made to examine activity in terms of
four dates for submission of:
Preliminary Plans
To ensure that the facilities contemplated will meet MWRC specifications.
Final Plans
A final review by MWRC before construction is started.
Construction Start
The date scheduled for construction to begin should comply with the date
established by order of the MWRC.
Construction Finish
This date matches the completion date established by the MWRC.
COMPUTER PROGRAM ANALYSIS
The computer is programmed to examine each of the four scheduled dates on
the "Monthly Report of Performance Scheduled" and compare them with the
date submitted on the "Monthly Report of Performance Completed." The
following symbols will print and indicate:
xxx - The scheduled date will occur in the following month.
N - Indicates the scheduled dates lapsed, no completion dates
submitted.
129 - (December, 1969) Indicates actual month and year. This
date may or may not comply with the scheduled date.
Performance completed may be submitted on a form identical to the form
used for reporting Performance Scheduled.
The 7 recorded in column (2) identifies construction completed; the 6
identifies construction scheduled.
153
-------
EXHIBIT 65
MONTHLY REPORT OF PERFORMANCE COMPLETED
PERFORMANCE AND ACTION REPORT
MICHIGAN WATER RESOURCES COMMISSION
REC.
CODE
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
i e
PRIMARY
STATION
NUMBER
76 80
MWRC ORDER
OR ACTION
NUMBER
17 21
STORE T
PARAMETER
NAME OR
NUMBER
^
B
A
N
K
^
^
^
^
hs
^
^s
^
^
^
^
. S
^
^
^
^
^
^!
^
96 98llO4 IOill2 II4||2O 122
PERFORMANCE DATES COMPLETED
PLANS
PRELIM.
MO.
YR.
FINAL
MO.
YR.
CONSTRUCTION
START
MO.
YR.
FINISH
MO.
YR.
* REPORT LOCATION
COMPANY NAME
OR REMARKS
6-ORGANIZATION
7-OUTFALL
8-PARAMETER
ENTER APPLICABLE DATES
AS THEY BECOME AVAILABLE
154
-------
REPORT TITLES (EXHIBIT 66)
This document is prepared as often as necessary to update the computer
files with new names of:
Regional MWRC Offices.
District Engineers' Offices.
River Basins.
CERTIFIED WASTE TREATMENT PLANT OPERATORS (EXHIBIT 67)
This document is prepared to update and change the Certified Operator's
file.
COLUMNS
1-6
TITLE
Primary Station
Number
DESCRIPTION
Number assigned to the treatment plant.
7 Code
8-17 Certificate
Number
18-26 Social Security
Number
27-30 Certification
Date
31-66 Certified
Operator Name
67-80 Not used
Registered number for individual
Certified Operator.
Certified Operator's number.
Date that this Operator was accepted
and certified.
Operator's name.
Blank.
MASTER FILE CHANGES (EXHIBITS 68, 69, and 70)
For large numbers of identical changes to the PAR master file, three
input forms are used. The forms duplicate specific lines on the New
Station Set-up Sheet (Exhibit 32). The advantage of using these forms
is the capability of processing many changes with very few forms.
Organization and Outfall Description Card (Exhibit 68) applies
to cards 61 and 70.
Address Correction Card (Exhibit 69) applies to cards 10, 11,
20 and 21.
River Basin and Organization Card (Exhibit 70) applies to card 60.
155
-------
EXHIBIT 66
REPORT TITLES
PERFORMANCE AND ACTION REPORT
MICHIGAN WATER RESOURCES COMMISSION
START ^
COMPREHENSIVE
STUDIES
DATA UNIT
KEY PUNCH
COMPREHENSIVE
STUDIES
REC
CODE
0
0
Q
0
0
0
0
O
0
0
0
0
0
0
0
0
O
O
0
O
O
pi!
M.WR.C.
X
m
o
m
O
(A
H
RIVER
BASIN
REPORT TITLES (34 CHARACTERS)
. 1.1
1£2 _ ' Tgl
INSTRUCTIONS' PRECEDE EACH RIVER BASIN NAME WITH
3-REGION
4-DISTRICT
3-RIVER BASIN
THE APPLICABLE REQION AND DISTRICT
NAME.
156
-------
CERTIFIED WASTE TREATMENT PLANT OPERATORS
PRIMARY
STATION
NUMBEP
1 .2.3.4. 5.8
M ''
_^^...
5
D
CERTIFICATE
NUMBER
.
SOCIAL
SECURITY
NUMBER
18 ,IS#>tl&&ftt>?6
CERT
DATE
Z728.29.30
-.^+-
. J . 1 J
CERTIFIED OPERATOR
NAME
3l.32,33,34,3KK,37.3a39.404l4%43l44.4345474a.49;9Q3l.92S334.33?££7.3e£9,60.6l«2.63.64.6:)C<
'
- " ^^.^.-.-. ... ^__..^^ .... .,^_l_L-....
, . .
NOT USED
676869,70.71.7^7374 7S 76 77.7^7*80
' ' ' - -
_^.^.^^-.^_^J_l_
rt
, . e.
M
03
H
-J
- , , , - !
-------
csg
ORGANIZATION AND OUTFALL DESCRIPTION CARD
*
«.-
1
->.-
1
__f --
__!_
....
_J
_l .
.1* l_ 1 -J L.
_-L- t. _X J -
__» J_l 1 I
__l- JL A-.l Li
_JL.i. a _i -J. _
-J L- J--* 1
_LJ_J_U_
_j.-i _j- ai-
ll i i .
«iii>
iiii^
.11111
3.4,3.8.718
i '
' 1 * » ' -1 * 1 >
-
!i !! »
LiJ J-x j i x.a_i_j-.
.!^Jt.!j_L t- l .L-iJL
i.Ki.I»ffci..lL Jt _l. J L \~
t f 1- | V I 1 t- y
f « ^ * k-4-U ^ JL
.X-H . f-,,,1 ^ ,fc | vt,4i :
. i
ir^- , r ,\, ,
w « l | « y 1 1 I
t i i ity
Jftll^t^s,^, ,5, 18,17,18
iittKit^i. *» F ilu.1. 'I iiln 1- ^ ,," ^.^ » ^ ' " * J 4^ ' ^
1,11
wL L
iiifliiiniiiliiiilnihiiilmifliihii nuiliiiiliiiiiihiiiliriliiihijJii il ill- tl- ' iidi
. i * i i * t. . v .rf t . , ^ v i w t ; i1 ^ i.i
J ₯ 1 1 V I V I ' V 1 l.|*.tk t 1C ^ > K J1
^4^4 4^4V**«4T , 4&44ftBCt5 1 ,3£OV43 B^4#7t945fli0O6 1 £2£3£44H#«4Q7«&AftrOt7 1 ,77 ,T\74/-
,,. ...... ,,..,., , i^.,,^,^J.,^^.,, L^,,
-U,l IJ.,1 1 -* 1 -1_ 1 JL-L -1 _l L..V J K I 1 .. l._l_ 1 I 1 1 I.J.I. »_*_! ^
i-j. i -j- i- J 1 L 1-J I L -I_l__l L_l ill |_1 Jj_.i L.J.i.Li jj i .
^ ^ , ... ,_i_,J^_,.J_J_^l^., _.a.t ,_ ,.,..,.
*M4^«i)«44T*&4a9a3ia»Jd4.»3«na9Ma(i,«243i«4«aiG4«riaa«wo,ri ,T2,r3x»*B
i?iEJ2ffl«
_i.lL....j4
' 1 »
. t J.. 1. 1 _
1 J 1 !,
. ,1 .< II.
J. * l_.l._
_JI-J_JL i-
..r.iufc-fcT,
X 1 X K
i t - ff J
Applies to 61 and 70 card on station set-up sheet.
-------
ADDRESS CORRECTION CARD
"i
-H
-o-
:
i
-j
K -^
VO
1
-|^
h
U
L-
i
£
i . .
i,A.3.S,7,& D,lOJM;SI*,!«!^^!r.''il9,I«2l«V^.MJ!Ur:T.312:>.!XM^^^^^
. L 1 1 I _l
,-
!,,,,.
.^..i-^.-^^.
...I,
-* -I-- t- ' '
.J Lilt
- 1 1 1 1
-i_*_JL-J-J
..'--». J,_,1..J..,
irrr
. l-i-..!_J.-'-.
'
1 1 r 1 i i illl Iliiitll ii l l l l lllil
J 1 f 'fir it*> tliiti ii i. . , . l ti , f ,
irt.iiii«tit « i * t t ii Iti
l!'- ' .- '. '.- L ;
.'.'^' -1 *'V u>--- ;i;'-
iv^irv'.^if^-v'^i^^^
:i::i.-. :;;!"!;;::i:\i:;::B\v'.:;.:r:::ir'.:.V
lilllf ;^s ;:Sipi;;r!*i;:i;:!if
i!Sl!;£i:;i;:'v!:S:iS!ii!Siii!r--liii;j.
|=iv!iS;:;f,:i ::;";o:i'i-i '!j : !' f 1
iliiliiS^iiiii^'-ife!1!^!:1*-!!!!^
sEi'i'ii'.vjjn.-vJj";-.'. i: ili'l
':S!5!.'?i::V' :?|;j "iif '' i"-l
iji|s|ij:ipi|j!.;!:::i!fc!|ii M j
il'^'ivis^i;^::1^!'^. S '
'':/> ;: .-ri; i.'.'i. &\ !
.:!'': 'x :; i::: ":.:!:i b\;& ^
i;!v:'i::,:::!U;viii:ni
?:- :i::ir;::if.tWi a : 1
'.vi.« : 'fvri:-i; [
-------
RIVER BASIN AND ORGANIZATION CARD
jE
6,0
6,O
6,0
6,0
6,O
fi,0
6,0
6,0
6,0
6,0
6,0
6.0
6.0
f>,0
6,0
6,0
6,0
6,O
6,O
6,O
6,0
6,0
6,O
6,0
6,0
6,0
6,0
','
1 REGIOMRIVER BAS1N|A!
immBBjB*Jpl^AJ|MINlTERMl"|
_,....
J,«,B.«,T.»
1 »,HV,I*.« ">..-, I»,IV_^^Z^V»M
*&£*&niMXT*9i**)&
ORGANIZATION NAME TO APPEAR ON REPORT
!»..- 1 1 . . i i
IMW«aiWT,4^ftW«MM^Mtt«TM»«Wli^^ .7Z,rW9
DATE
MOlYR
1 i '
i . i
i i
M
£~~
M
M
H
**J
O
ar j] E
-------
SECTION IX
ACKNOWLEDGMENTS
Mr. Ralph Purdy, Executive Secretary of the Michigan Water Resources
Commission, provided supporting knowledge of the activities of the
Commission, and extended guidance throughout the project.
Members of the staff of the Michigan Water Resources Commission who
participated in the project include Messrs. Francis Frost, William
Turney, Gary Guenther, and Fred Morley.
Mr. Don Sabrosky of the State Record Center provided technical assistance
in the use of microfilm.
Mr. George Stevens and Mr. John Lucia of the Office of the Secretary of
State supplied information on their application of OCR equipment.
Michigan Department of Public Health personnel whose cooperation is
acknowledged include Messrs. Donald Pierce, Thomas Hoogerhyde, and
Paul Blakeslee.
The support of the project by the Federal Water Pollution Control
Administration and the help provided by Mr. Phillip Taylor, the Grant
Project Officer, are acknowledged with sincere thanks.
161 eU.S. GOVERNMENT PRINTING OFFICE: 1973 546-110/66 !--<
-------
SELECTED WATER
RESOURCES ABSTRACTS
INPUT TRANSACTION FORM
w
Michigan Water Resources Enforcement and Information System
Guenther, G., Mincavage, P., and F. Morley
Michigan Water Resources Commission
Lansing, MI 48926
:iorrr,.
Repc Nu.
16090FSR
12. S -isorir- Orgar. .'".ion
Environmental Protection Agency
Environmental Protection Agency report
number, EPA-R5-73-020, July 1973.
The project demonstrated an interactive Federal/State water-pollution control, enforce-
ment, and information system, including interactive computer graphics as a method of
output presentation.
Two systems were interfacedMichigan's Water Information System for Enforcement (WISE)
and EPA's STORET system. The WISE system is used to alert enforcement personnel to
problems through exception reporting, and to provide follow-up information on these
problems. STORET is utilized as a storage and retrieval system for water quality and
inventory information. As information enters WISE, certain inputs are coded for
storage in STORET. The interface mechanism is a common numbering system. Because WISE
is modular in design, it can be used in part or in total by other agencies.
The demonstration indicated that careful consideration should be given to the infor-
mation that will comprise the computer file. Administrative, procedural, and auditing
techniques should be completely set down before proceeding with management's commitment
to the system. Microfilm should be used when feasible, both as Computer Output
Microfilm (COM) and in manual files.
17b
Information retrieval, data storage and retrieval, data processing
water pollution control, monitoring, state jurisdiction.
Water quality enforcement, exception reporting, computer graphics.
COWRR Fi-.ld & C-T
07B,C, 23
GPO
19. Security Class.
fRepo;':j
'I. SL -ityC S.
21. No. of
161
Pi ..
Send To:
WATER RESOURCES SCIENTIFIC INFORMATION CENTER
U.S DEPARTMENT OF THE INTERIOR
WASHINGTON. O C. 2O24O
------- |