DETAILED SYSTEM DESIGN AND

            SPECIFICATION

 FEDERAL WATER SUPPLY DATA SYSTEM


               Prepared for


     THE OFFICE OF WATER SUPPLY

U.S. ENVIRONMENTAL PROTECTION AGENCY

          Contract No. 68-01 -3308
           Task Order 68-01-3910


               Prepared by
            Index Systems, Inc.
              One Broadway
             Cambridge, Mass.
              September 1976
                VOLUME II

-------
DETAILED SYSTEM DESIGN AND SPECIFICATION

    FEDERAL WATER  SUPPLY DATA  SYSTEM
              Prepared For



       THE OFFICE OF WATER SUPPLY

  U.S. ENVIRONMENTAL PROTECTION AGENCY



        Contract No. 68-01-3308

         Task Order  68-01-3910
              Prepared By
           INDEX SYSTEMS, INC,
              One Broadway
            Cambridge, Mass.
            September, 19.76
               VOLUME  II

-------
VI.  DATA ELEMENT  DIRECTORY
                                       index systems inc

-------
             VI.  DATA ELEMENT DIRECTORY
This chapter contains Data Element Description sheets for
each data element used in the system.  The meaning of each
item is explained and a reference is given to its location
within the system files.  Applicable data values or ranges
are indicated in addition to the edit rules which apply
to each element.  An alphabetical cross-reference listing
is included to facilitate use of the Data Element Directory.
                                                   index systems inc

-------
          DATA  ELEMENT  DIRECTORY  CROSS-REFERENCE  LIST
  MNEMONIC

ACCUM-TYPE-SEL

ACTION-DATE

ACTIVITY-IND

ACTUAL-DATE


ADDRESS-SEL

ALT-TREATMENT


ANALYSIS-METHOD


ANALYSIS-RESULT

AREA-CODE

AVAILABILITY


AVG-AIR-TEMP

BASIN-NUMBER

BATCH-NUM

BEGIN-DATE


CAPTIVE-FLAG


CASE-ID


CASE-REFERENCE


CHLORINE


CITY
        NAME

ACCUMULATOR TYPE SELECTION

ACTION DATE

ACTIVITY INDICATOR

DATE MILESTONE
COMPLETED

ADDRESS SELECTION

ALTERNATE TREATMENT
TECHNIQUE CODE

SAMPLE ANALYSIS
METHOD

ANALYSIS RESULT

TELEPHONE AREA CODE

WATER AVAILABILITY
CODE

AVERAGE DAILY AIR TEMP.

RIVER BASIN NUMBER

BATCH NUMBER

DATE PWS BEGAN
OPERATION

CAPTIVE LABORATORY
FLAG

ENFORCEMENT ACTION
CASE IDENTIFICATION

LEGAL CASE
IDENTIFICATION

CHLORINE RESIDUAL
PERCENT OF SAMPLES

CITY
REF #

122

089

021

103


127

084


106


107

009

073


114

074

098

029


045


087


088


051


Oil
                         -152-
                                                    index systems inc

-------
  MNEMONIC

CLOSE-INDICATOR

COMP-CYCLE

CONSECUTIVE


CONSECUTIVE-NUM


CONTAM-CTG-SEL

CONTAMINANT-ID

COUNTY

DEACT-DATE

DEACT-REASON

DESIGN-CAPACITY

DESTINATION

DISTRICT

EFFECTIVE-DATE

EMERGENCY-POWER

END-PERIOD


EXPIRATION-DATE

FROM-SEL

INDIAN-RES


INTERSTATE-CARR


LAB-AUTHORIZE


LAB-CONTROL


LAB-ID
      NAME                        REF  #

CASE  STATUS  INDICATOR            090

COMPLIANCE CYCLE                  025

CONSECUTIVE  PWS                   026
INDICATOR

NUMBER OF CONSECUTIVE            038
PWS'S

CONTAMINANT  CATEGORY  SELECTION    119

CONTAMINANT  IDENTIFICATION        053

COUNTY CODE                       012

DATE  OF DEACTIVATION              022

REASON FOR DEACTIVATION           023

DESIGN CAPACITY                   113

DESTINATION                       129

STATE'S ADMINISTRATIVE DISTRICT   017

EFFECTIVE DATE                    024

EMERGENCY POWER ONLY              040

DATE  OF ENDING
SAMPLING PERIOD

EXPIRATION DATE                   081

FROM VALUE FOR SELECTION          134

INDIAN RESERVATION                013
CODE

INTERSTATE CARRIER                019
FLAG

LABORATORY ANALYSIS               105
AUTHORIZATION CODE

LABORATORY CONTROL                043
INDICATORS

LABORATORY IDENTIFICATION         044
                         -153-
                              index systems inc

-------
  MNEMONIC
        NAME
REP #
LAB-OWNER

LAST-OP-REPORT


LAST-UPDATE

LATITUDE

LEGAL-STATUS

LENGTH-SEL

LONGITUDE

MANUAL-FILE

MAX-PRODUCTION

MCL


METERS-NUM

MILESTONE-CODE

MNEMONIC-SEL

MODIFIED-MCL

MONTHLY


NITRATE-FREQ


NON-COMM-FREQ


NORMAL-CAPACITY


NO-SAMPLING


NUMBER-OF-WELLS

NUM-MILESTONES

OFFSET-SEL
LABORATORY OWNER TYPE             104

DATE OF LAST OPERATING            034
REPORT

DATE OF LAST UPDATE               060

LATITUDE OF WATER SOURCE          075

LEGAL STATUS                      096

LENGTH OF FIELD FOR SELECTION     137

LONGITUDE OF WATER SOURCE         076

REFERENCE TO MANUAL FILES         030

MAXIMUM DAILY PRODUCTION          042

MAXIMUM (MINIMUM)                 061
CONTAMINANT LEVEL

NUMBER OF METERS                  037

MILESTONE CODE                    085

MNEMONIC FOR SELECTION            131

MODIFIED MCL                      082

MONTHLY BACTERIOLOGICAL           046
MONITORING

NITRATE MONITORING                058
FREQUENCY

ALTERNATE SAMPLING                050
FREQUENCY

NORMAL PRODUCTION                 039
CAPACITY

SAMPLING REQUIREMENT              057
WAIVE INDICATOR

NUMBER OF WELLS                   072

NUMBER OF MILESTONES              112

OFFSET FOR SELECTION              136
                          -154-
                              index systems inc

-------
  MNEMONIC
      NAME
REF #
OPERATE-REPORT

OPERATOR-SEL

PARTY-TYP-DEFND


PARTY-TYP-PLAIN


PERCENT-SEL

PER-QUARTER


PHONE-NUMBER

POP-SERVED


PWS-ADDRESS-L1

PWS-ADDRESS-L2

PWS-ID

PWS-NAME

PWS-OWNER-TYPE

PWS-TYPE

RADIOACTIVE-MTR

REASON


REGION

REGION-ADMIN


REGION-SEL

REGULATE

RELATION-SEL

REPORT-BACT-FLG
OPERATING  REPORT FLAG             033

OPERATOR FOR  SELECTION            130

ENFORCEMENT ACTION                091
PARTY TYPE DEFENDANT

ENFORCEMENT ACTION                092
PARTY TYPE PLAINTIFF

PERCENT SELECTION                 128

NUMBER OF  SAMPLES                 047
PER QUARTER

TELEPHONE  NUMBER                  010

SIZE OF POPULATION                035
SERVED

PWS ADDRESS LINE 1                005

PWS ADDRESS LINE 2                006

PWS IDENTIFICATION NUMBER         003

PWS NAME                          004

PWS OWNER  TYPE                    018

PWS TYPE                          020

RADIOACTIVE MONITORING FLAG       059

REASON FOR VARIANCE OR            095
EXEMPTION

EPA REGION                        001

STATE'S ADMINISTRATIVE            016
REGION

EPA REGION SELECTION              117

PWS REGULATORY STATUS             015

RELATION FOR SELECTION            133

BACTERIOLOGICAL SAMPLES           031
REPORTING FLAG
                           -155-
                                                    index systems iroc

-------
  MNEMONIC
        NAME
REF #
 REPORT-NUM-SEL

 REPORT-TURB-FLG


 RESERVE

 RPT-SEL

 SAMPLES-RECVD


 SAMPLES-REQURD


 SAMPLING-FREQ


 SEASON-END

 SEASON-START

 SELLER-ID

 SELLER-WATER

 SERVICE-AREA


 SERVICES-NUM


 SORT-SEL

 SOURCE-CODE

 SOURCE-ID-NUM


 SOURCE-NAME

SOURCE-NUM

SOURCE-TYPE-SEL

START-PERIOD


STATE
REPORT  NUMBER SELECTION

TURBIDITY  SAMPLES
REPORTING  FLAG

RESERVED AREA

REPORT  SELECTION

NUMBER  OF  SAMPLES
RECEIVED

NUMBER  OF  SAMPLES
REQUIRED

MONITORING (SAMPLING)
FREQUENCY

DATE SEASON ENDS

DATE SEASON STARTS

WATER SELLER  PWS ID

WATER TYPE OF  SELLER

SERVICE AREA
CHARACTERISTICS

NUMBER OF  SERVICE
CONNECTIONS

SORT SEQUENCE  SELECTION

WATER SOURCE CODE

SOURCE IDENTIFICATION
NUMBER

NAME OF WATER  SOURCE

WATER SOURCE  NUMBER

SOURCE TYPE SELECTION

DATE OF STARTING
SAMPLING PERIOD

STATE CONTROLLING PWS
115

032


068

126

109


108


054


049

048

027

028

014


036


132

071

101


070

069

121

055


002
                           -156-
                                                    index systems inc

-------
   MNEMONIC
        NAME
REF  #
 STATE-ADR


 STATE-SEL

 STORAGE-CAPACITY


 TARGET-DATE

 TO-SEL

 TOT-TRAN-COUNT

 TOT-VIO-COUNT

 TOTAL-INPUT

 TRAN-CODE

 TRAN-COUNT

 TRAN-NUM

 TREATMENT

 TREATMENTS

 TURBIDITY-UNITS

 TYPE-OF-PWS-SEL

VE-ID


VE-STATUS

VE-TYPE


VIO-CONTAM-TOT


VIO-CONTAM-YTD


VIO-COUNT

VIO-DURATION
 STATE  POSTAL  CODE  FOR
 ADDRESS

 STATE  SELECTION

 DISTRIBUTION  STORAGE
 CAPACITY

 MILESTONE TARGET DATE

 TO VALUE FOR  SELECTION

 TOTAL  TRANSACTION  COUNT

 TOTAL  VIOLATIONS COUNT

 TOTAL  INPUT

 TRANSACTION CODE

 TRANSACTION COUNT

 TRANSACTION NUMBER

 TREATMENT CODE

 APPLIED WATER TREATMENTS

 ALTERNATE TURBIDITY MCL

 TYPE OF PWS SELECTION

 VARIANCE OR EXEMPTION
 IDENTIFICATION

 STATUS OF V & E

 VARIANCE OR EXEMPTION
 INDICATOR

 TOTAL VIOLATIONS OF
 CONTAMINANT LEVEL

VIOLATIONS OF CONTAMINANT
 LEVEL YTD

VIOLATION COUNT

VIOLATION DURATION
 007


 118

 041


 086

 135

 123

 124

 125

 097

 100

 099

 083

 077

 052

 116

 078


 080

 079


 065


 062


102

110
                            -157-
                              index systems irae

-------
  MNEMONIC

VIOLATION-DATE

VIOLATION-ID

VIOLATION-TYPE

VIO-OTHER-TOT

VIO-OTHER-YTD

VIO-SAMP-TOT


VIO-SAMP-YTD


VIO-TYPE-SEL

ZIP
       NAME

VIOLATION DATE

VIOLATION IDENTIFICATION

TYPE OF VIOLATION

TOTAL OTHER VIOLATIONS

OTHER VIOLATIONS YTD

TOTAL VIOLATIONS OF
SAMPLING FREQUENCY

VIOLATIONS OF SAMPLING
FREQUENCY YTD

VIOLATION TYPE SELECTION

ZIP CODE
REF #

093

111

094

067

064

066


063


120

008
                           -158-
                                                    index systems me

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA  ELEMENT


MNEMONIC:    REGION
                                          REF «:
                              001
            EPA REGION
INSCRIPTION
                                          PICTURE:    9(2)
SJ&fE TYPE:  Numeric	            	



tJSAGEs      The EPA region of the state controlling the PWS.
    FIELD  (S):
VALUES;     Regions are 1 to 10.

            See State Postal Code Table
                      INPUT/OUTPUT REFERENCE



           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
                 X
X
                          §
                          B
SDIT REQUIREMENTS:
                                   H
                                  LL.
X
X
                                                        X
COMMENTS:
            'Region is generated internally based on the state

            code,  data element #002,  The region may be entered

            for Indian reservations which span more than one state,
            NONE.
Date:    5/6 /76   Revision Date:    6  /9  / 76   Revision #:1
                                -159-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
STATE
 REF  #:
STATE CONTROLLING PWS
      002
DESCRIPTION

DATE TYPE:  A/N
                             PICTURE:
             X(2)
USAGE:
The postal code of the state controlling the PWS
(may be different from the mailing address state)
SUB FIELD  (S):   007 STATE-ADR
VALUES:     One of the 56 postal codes assigned to states and
            trust territories.  See State Postal Code Table.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                X
         X
                          I/O TO SUBSYSTEMS
                                  H
X
X
                                                  CJ
X
X
EDIT REQUIREMENTS:
            Value must be one of the above 56 codes,
COMMENTS:
            NONE.
Date:    5/6 / 76  Revision  Date:    9/20/ 76   Revision #:   1
                              -160-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:


NAMEs
  PWS - ID
 REF
      003
  PWS IDENTIFICATION #
DESCRIPTION


DATE TYPEs    Numeric
                             PICTURE:    9(7)
9SAGE:      A seven  digit  number  uniquely  identifying a water
            system within  a  state.
SOB FIELD  (S):    NONE


VALUES:
0000000 to 9999999
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                           I/O TO SUBSYSTEMS
            X
          X
                                  H
X
X
                                                 85
                                                 81
X
X
EDIT REQUIREMENTS:
            1.  Must be numeric.
            2.  On  addition to  Inventory file, number must be unique,
COMMENTS:
           NONE
Date:   5/6 /  76  Revision Date
                                      Revision #,
                               -161-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   PWS - NAME




NAME:       PWS NAME
                              REF  I:
      004
DESCRIPTION



DATE TYPE:  A/N



USAGE:
                              PICTURE:    x(30)
 Official name of a public water system
SUB FIELD  (S):
        NONE
VALUES:     Any character string
                      INPUT/OUTPUT.REFERENCE
FILE/TABLE LOCATION
            X
EDIT REQUIREMENTS:
            NONE .
COMMENTS:
            NONE.

                                  H
                                      I/O TO SUBSYSTEMS
                             X
                                            £
X
                                                  a
                                                        3
X
Date:    5 /  6/76   Revision Date:
                                       Revision #
                               -162-

-------
                   EPA WATER SUPPLY DATA SYSTEM

                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:

USAGE:
PWS-ADDRESS-L1
REF f:
          005
PWS ADDRESS LINE 1
PICTURE:
                                         X(30)
Used for the street name of the PWS mailing address
or plant address
SUB FIELD  (S) :   NONE

VALUES:
Any character string, should contain street address
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS:
            NONE .
TI
                                  tJ
                                       X
UPDATE
                                 X
IC
OD
RT
         X
              X
COMMENTS:
            NONE,
Date:   5 /  6/ 76  Revision  Date
                                      Revision #
                                -163-

-------
                   EPA.WATER SI  »PLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   PWS-ADDRESS-L2

NAME:       PWS ADDRESS LINE 2
                             REF  #:
      006
DESCRIPTION

DATE TYPE:  A/N

USAGE:
                             PICTURE:    X(30)
Used for the city name of the mailing address or
plant address.
SUB FIELD  (S) :   NONE
VALUES:     Any character string.  Should contain city name,
            left justified.
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
RY
            X
EDIT REQUIREMENTS:
            NONE.
COMMENTS:
            NONE.
TI
                            X
UPDATE
X
ODIC
RTIN
P
X
X
Date:    5/6 / 76  Revision  Date
                                      Revision #:
                                -164-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

KAMEs




DESCRIPTION

DATE TYPE:  A/N
STATE-ADR
 REF
                                                   007
            STATE POSTAL CODE FOR
            ADDRESS
 PICTURE:
                                                     X(2)
USAGE:      Used as the state in the mailing address or plant
            address.
SUB FIELD  (S):      NONE	

VALUES:     One of the 56 postal codes assigned to states and
            trust territories.  See State Postal Code Table.
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            x
x
                                             X
                                      X
X
EDIT REQUIREMENTS:
            Value must be one of the above 56  codes,
COMMENTS:
            NONE.
Date:    5/6 / 76  Revision  Date:    9 / 20 / 76   Revision #
                                -165-

-------
                  EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   ZIP
NAME:
                                         REF #:    008
            ZIP CODE
DESCRIPTION
DATE TYPE: Numeric
USAGE:
                                         PICTURE:    9(5)
            Zip code as part of the mailing address or plant  address.
SOB FIELD  (S):   NONE	
VALUES:    ^^ valid 5-digit zip code
                      INPUT/OUTPUT  REFERENCE
FILE/TABLE LOCATION I/O TO SUBSYSTEMS









£
PH
o
§ g
H
M
X
«*

pj f^|
5 H
a |1
2 s
g §


1
^r
H en
K O
£ H
M 2


fi
H
B
9 ^
g 3
S H










§
H

i
g
u





^
g
§
X




1
a
P*
X
EDIT REQUIREMENTS:

o
U 2
t~[ 1 i
BS

s s
X


o
PJ»
R
^ s
1 2
Si s
X

1. Must be numeric.
COMMENTS :
Date:   5/6 /76   Revision Date:
                                       /   /
Revision #
                              -166-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  AREArQODE
NAME:
                              REF f:   009
TELEPHONE AREA CODE
DESCRIPTION
DATE TYPE: Numeric
USAGE:
                              PICTURE:
Area code of telephone number
SUB FIELD  (S):  NONE
VALUES:
            Any valid area code
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
                 H
                      H
                                  H
EDIT REQUIREMENTS:
            1.  Must be numeric,
COMMENTS:
                                        X

                                                  Cu
                                            X
            NONE.
Date:    5/6 /76   Revision Date:
                            /	/     Revision  #
                                 -167

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   PHONE-NUMBER_




HAMEs
TELEPHONE NUMBER
DESCRIPTION



DATE TYPE:  Numeric



USAGE:
7-digit phone number
                             REP f:    010
                                         PICTURE
                                         9(7)
SUB FIELD  (S) :  NONE




VALUES:
            Any 7-digit number
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                          I/O TO SUBSYSTEMS
            X
                                  H
                            X
                                            1
                                             X
X
X
EDIT REQUIREMENTS:
            Must be numeric with a non-zero leading value.
COMMENTS:
            NONE.
Date:    5 /  6 /  76  Revision Date:
                           /   /
                                                  Revision #
                                 -168-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
            CITY
            CITY
MNEMONIC:

NAMEs      	



DESCRIPTION

SATE TYPE: _A/N
                             REF
      Oil
                                         PICTURE:    X(15)
USAGE:
Name of the city or community which is the primary
area serviced by a PWS
SUB FIELD  (S) :    NONE	

VALUES:     Any character string
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
EDIT REQUIREMENTS:
            NONE.
COMMENTS:
            NONE.
Date:   5 /  6/76  Revision Date
                            X
X
                                                 81
                                                  X
X
                                     Revision  #
                               -169-

-------
                  EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:  COUNTY

NAME:
                                         REF #:   012
           COUNTY CODE
DESCRIPTION

DATE TYPE: Numeric
                                         PICTURE:   9(3)
0SAGE:     Code of the county in which the service area of
           a PWS is located.
SUB FIELD  (S):   NONE

VALUES.
           As defined in STORET county code table
                      INPUT/OUTPUT REFERENCE
FILE/TABLE
EDIT REQU:
!!
X
c8

CREMENTS :
LOCATION I/O TO SUBSYSTEMS
P H

REGULATION
TABLE



H

|
X

UPDATE
'
X

PERIODIC
REPORTING
X

ANNUAL
REPORTING
X

Must be numeric.
COMMENTS ;
           NONE.
Date:  5  /  6/76   Revision Date
                                       /   /
Revision #
                              -170-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAMES
INDIAN-RES
REF #:    013
INDIAN RESERVATION CODE
DESCRIPTION

DATE TYPE:  Numeric
                             PICTURE:   9(3)
USAGE:
Code identifying that a PWS is located on an
Indian Reservation and therefore monitored by the
EPA and not the state.
SUB FIELD  (S) :  NONE

VALUES:
            See Indian Reservation Code Table.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                          I/O TO SUBSYSTEMS
            X

                                 X
         X
EDIT REQUIREMENTS:
            Must be zero or included in the table.
COMMENTS:
            NONE,
X
Date:    5 /  6 / 76  Revision Date
                                      Revision #
                            -171-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

KAMBs



DESCRIPTION
       SERVICE-AREA
REF f:
014
       SERVICE AREA
      CHARACTERISTICS
TYPE: Numeric
                                         PICTURE:    9(19)
            A 19-character string where each element indicates
            one service area characteristic.  Information is
            used to retrieve PWS's by service area characteristic,
VALUES:
    FIELD  (S) s   Each position indicates' a characteristic
                (See list in comments).
            for each position:   0 = No
                                1 = Yes
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                        X
                                       X
         X
      X
EDIT REQUIREMENTS:
            Each position must be a '0'  or '!'.
COMMENTS:   List of characteristics  in positioned  order:
"Residential,  company town, recreation  area, mobile  home
            park,  institution,  school  or college,  motel,  restaurant,
            service station,  campground,  picnic  area,  lodge, marina,
            ski  resort, bathing area,  visitor  center,  highway safety,
            rest area,  airport,  other.
Date:    5/6 /76   Revision Date:      /   /      Revision #:
                               -172-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
            REGULATE
REF f:   015
            PWS  REGULATORY STATUS
DESCRIPTION

DATE TYPE:
                                         PICTURE:   x(l)
USAGE:
            This indicator describes the authority under which the
            particular PWS is regulated.
SUB FIELD  (S):

VALUES:     1.
            2.
            3.
                  NONE
                Regulated by state regulations only.
                Regulated by federal regulations only.
                Regulated by both of the above.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
           X
                      H
                                      I/O TO SUBSYSTEMS
                                        X
                                            1
   X
X
EDIT REQUIREMENTS:
            Must have a '1',  '2',  or '3'  only
COMMENTS:
            NONE.
Date:    5/6 / 76  Revision Date:
                                                  Revision #
                                -173-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   REGION-ADMIN

NAME:
                               REF #:    Q16
 STATE'S ADMINISTRATIVE  REGION
DESCRIPTION

DATE TYPE:   A/N

USAGE:
                               PICTURE:   X(2)
 A code  identifying  the administrative region of  the
 state.
SUB FIELD  (S) :     NQNF.
VALUES:     Determined by the state.  If the state does not control
            water quality by regions, the field is blank.
                      INPUT/OUTPUT REFERENCE
FILE/TABLE LOCATION
            X
                      w
                          H
                                       I/O TO SUBSYSTEMS
                             X
                                             I
                                                  U
X
X
EDIT REQUIREMENTS:
            NONE.
COMMENTS:
            NONE.
Date:   5 / 6 / 76  Revision  Date:      /   /     Revision #
                             -174-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   DISTRICT

NAME:
                              REF #:   017
STATE'S ADMINISTRATIVE DISTRICT
DESCRIPTION

DATE TYPE: A/N

USAGE:
                              PICTURE:    X(3)
A code identifying the administrative district of
the state.
SUB FIELD  (S):   NONE,
VALUES:     Determined by  the  state.   Can  contain  a  county  code,
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
           X
EDIT REQUIREMENTS:
           NONE.
COMMENTS:
           NONE.
                                  H
                                  rj
                            X
                                            1
X
                                                  8%
X
Date:   5/6 /76   Revision Date
                                      Revision #
                               -175-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   PWS-OWNER-TYPE

NAME:       PWS OWNER TYPE
                             REF I:   018
DESCRIPTION

DATE TYPE:  A/N

USAGE:
                             PICTURE:   X(l)
A code describing the type of a PWS owner.
SUB FIELD  (S):

VALUES:
       NONE
1 = municipality
2 = investor
3 = federal
4 = state
5 = other
          INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                          I/O TO SUBSYSTEMS
            X
                                  H
                            X
EDIT REQUIREMENTS:
COMMENTS:
            Must be in the range 1-5.
            NONE.
X
                                                  X
X
Date: 	5 /  6 /76   Revision Date:
                                      Revision #
                                -176-

-------
                  EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   INTERSTATE-CARR	

NAME:       INTERSTATE  CARRIER FLAG
REF #:  019
DESCRIPTION

DATE TYPE: Numeric
PICTURE:  9(D
USAGE:      A flag indicating  if a PWS is an interstate carrier
            of drinking  water.
SOB FIELD  (S):    NONE

VALUES:     0 = No
            1 = Yes
                      INPUT/OUTPUT REFERENCE
FILE/TABLE

EDIT REQU:

gj
X
M>
|

CREMENTS :
Must be
LOCATION
S
ENFORCEMI
ACTIONS

%
REGUIATIC
TABLE

a 0 or 1.

I
I/O TO SUBSYSTEMS

M


|
X

UPDATE
X


1
X


j|
X

COMMENTS :
            NONE.
Date:   5/6/76  Revision Date:     /   /     Revision
                                 -177-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   PWS-TYPE

NAME:
                             REP  f:   020
PWS TYPE
DESCRIPTION

DATE TYPE:  A/N
                             PICTURE:    X(l)
USAGE:
A flag indicating if this PWS is a community or
non-community PWS as defined in the regulations,
SUB FIELD  (S):    NONE
VALUES:     C = Community
            N = Non-community
                      INPUT/OUTPUT REFERENCE
           PILE/TABLE LOCATION
                           I/O TO SUBSYSTEMS
            X
                                  H
EDIT REQUIREMENTS:
            Must be either 'C'  or 'N
COMMENTS:
            NONE.
                            X
                                            1
X
X
Date:    5/  6/76  Revision Date
                                      Revision #
                             -178-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   ACTIVITY-IND
                                          REF f:    021
            ACTIVITY  INDICATOR
DESCRIPTION
     <£ypE«  Numeric
                                         PICTURE
USAGE
            A flag to indicate whether the PWS record  is
            active or not.
    FIELD  (S):

VALUESs
                  NONE
            0 = Active
            1 = Inactive
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
            X
                                       I/O TO SUBSYSTEMS
                                  H
                                        X
                                                  U
                                                  H
x
x
EDIT REQUIREMENTS:
COMMENTS:
            Must be  '0' or  '1'.
            When value is  '!'  in the input transaction, deactiva-
            tion date and reason must be oresent.
            NONE.
Date:   5 / 6 / 76  Revision  Date:
                                                  Revision #
                              -179-

-------
                   EPA WATER  SUPPLY DATA SYSTEM
                      DATA ELEMENT DESCRIPTION
 DATA ELEMENT
            DEACT-DATE
MNEMONIC:

HAME:



DESCRIPTION

DATS TYPE:  Numeric
                                          REF #:   022
             DATE  OF DEACTIVATION
                                          PICTURE:   9(5). 9
USAGE:
            Date of day the activity flag is set inactive,
            Used for documentation and audit trails.
     FIELD (S);  On files as Julian YYDDD, on input/reports MMDDYY,

VALUES:     Date  in Julian.
                      INPUT/OUTPUT  REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                  H
                                        X
                                             X
                                                  X
X
 EDIT REQUIREMENTS:
.COMMENTS :
            If activity indicator is a  'I1 the field must contain
            a valid date not later than updating date.  Otherwise
            may be blank.
            NONE.

Date:   5 /  6/76  Revision  Date:
                                        /   /
                                                  Revision #:
                                 -180-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   DE ACT-REASON

NAME:
            REASON FOR DEACTIVATION
                                         REF  #:   Q23
DESCRIPTION

DATE TYPE:

USAGE:
                                         PICTURE:    X(l)
            A code describing the reason for deactivating the
            PWS record.
SOB FIELD  (S):   NOHE

VALUES:
           See Deactivation Reason Table.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                                        X
                                             X
X
X
EDIT REQUIREMENTS:
            Must be contained in Deactivation Reason Table.
COMMENTS:
            NONE.
Date:    5 /  6/76   Revision  Date:      /   /     Revision #
                               -181-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  EFFECTIVE-DATE

NAME:      EFFECTIVE DATE
                              REF f:  Q24
DESCRIPTION

DATE TYPE: Numeric
                              PICTURE:  9(5) , 9(6)
USAGE:
For PWS Inventory File, the date on which the applicable
regulations become effective.  On Variance and Exemption
file, the effective date of the variance or exemption.
SOB FIELD  (S) :  On  files as Julian YYDDD, on  input/reports MMDDYY

VALUES:    Any Valid Date.
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS

              I
                                  H
                                  CJ
                                             X
                                                  O
                                                  iT
EDIT REQUIREMENTS;

           Must be a valid date or blanks.
COMMENTS:
           When effective date is not input it will be set to
           June 1, 1977.
Date: 	5/6 / 76  Revision Date:
                                      Revision  #:
                               -182-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
COMP-CYCLE
REF f:  025
COMPLIANCE CYCLE
DESCRIPTION

DATE TYPE:  Numeric

USAGE:
                             PICTURE:   9(2)
Describes the compliance cycle for the PWS.
SUB FIELD  (S):
      NONE
VALUES:     Any number in the range 1-99.
            For a PWS that is monitored monthly,  the compliance
            cycle is the day on which the  compliance month starts,
            For example:  compliance cycle 20 means that the re-
            porting period starts at the 20th.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                          I/O TO SUBSYSTEMS
                                       X

                                                 81
                                            X
EDIT REQUIREMENTS:
            Must be numeric  and greater  than zero.
COMMENTS:
            NONE.
Date:    5/6 / 76  Revision Date:
                                      Revision #:
                             -183-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC
            CONSECUTIVE
REF
026
            CONSECUTIVE PWS INDICATOR
DESCRIPTION
     TYPEs  Numeric
                                         PICTURE:   9(1)
            A flag indicating whether a PWS is  consecutive,  i.e.,
            purchases all  of its  water from another PWS  where the
            water is treated.   A  state may exempt a consecutive
            PWS from monitoring.
SUB FIELD  (S):
                   NONE
VALUES:     0  =  not  consecutive
            1  =  consecutive,  not  monitored
            2  =  consecutive,  monitored
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                       X
                                             a
                                             X
                                                  a
         X
EDIT REQUIREMENTS:
COMMENTS:
           Must be  '0',  '1' or  '2
           NONE.
Date:    5/ 6 / 76   Revision  Date
                                                  Revision #
                            -184-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:  SELLER-ID

NAME:
DESCRIPTION

DATE TYPE: Numeric
                              REP #:   027
WATER SELLER PWS ID
                              PICTURE:  9(7)
USAGE:
PWS-ID of the seller to a consecutive PWS.
If more than one, the largest PWS is used.
SOB FIELD  (S):   NONE

VALUES:    Nume r ic.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
EDIT REQUIREMENTS:
                           I/O TO SUBSYSTEM
COMMENTS:
           Must  be  numeric  and  non-zero.
           NONE.
                                            1
                                            X
                                            X
Date:    5/6 / 76  Revision Date:
                                      Revision  #
                             -185-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
SELLER-WATER
WATER TYPE OF SELLER
                                         REF f:  Q28
DESCRIPTION

DATE TYPE:
               A/N
                            PICTURE:
USAGE:     A flag showing,  for a consecutive PWS,  whether the
           water it is purchasing is ground, surface or purchased,
SUB FIELD  (S):    NONE	

VALUES:    S = Surface
           G = Ground
           P = Purchased
       Blank = PWS not consecutive

                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
                                            I
                               X
                                                  X
                                                        X
EDIT REQUIREMENTS:
COMMENTS:
          Must be  S, G or P  if the PWS  is consecutive; otherwise,
          must be  blank.
          NONE.
Date:    5 / 6/76  Revision Date:
                                     Revision #:
                                -186-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:    BEGIN-DATE


NAME:
                                         REF  f:    029
             DATE PWS BEGAN OPERATION
DESCRIPTION
                                         PICTURE:   9(4)
DATE TYPE:   Numeric	            	


USAGE:     Date on which PWS began  (or will begin) operation.
SOB FIELD  (S):  Month and year MMYY


VALUES:
           A valid month and year.
                      INPUT/OUTPUT REFERENCE


           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                      H
EDIT REQUIREMENTS:
           A valid month and year.
COMMENTS:
           NONE.
                                            X
                                                   x
X
Date:    5/ 6 / 76  Revision  Date:      /   /     Revision #
                              -187-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   MANUAL-FILE

NAME:
                                         REF  #:   030
            REFERENCE TO MANUAL FILES
DESCRIPTION

DATE TYPE: A/N

USAGE:
                                         PICTURE:    X(12)
            A reference to a manual file document  such as the
            correspondence file or the permit file.
SUB FIELD  (S):

VALUES:

           Any.
                   NONE
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
EDIT REQUIREMENTS:
           NONE .
COMMENTS:
           NONE .
                      CO
                          H
                                      I/O TO SUBSYSTEMS
                                  H
                                  C)
                                        X
                                            X
                                                  U
X
X
Date:    5/ 6 / 76  Revision  Date:
                                                  Revision #
                                -188-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:  A/N

USAGE:
            REPORT-BACT-FLGL
REP I:   031
            BACTERIOLOGICAL SAMPLES
            REPORTING FLAG
                                         PICTURE:   X(l)
            A flag describing reporting made for bacteriological
            monitoring.
SUB FIELD  (S)
                  NONE
VALUES:     L = Reporting single samples on a list
            S = Reporting monthly summary
            I = Reporting individual sample form

            Blank if no value.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
EDIT REQUIREMENTS:
COMMENTS:
            Must be L,  S,  I or blank.
            NONE.
                                             X
                                                  81
                                                   x
              X
Date:
         5_/_Ji / 76  Revision Date:
        Revision  #:
                              -189-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:  REPORT-TURB-FLG _

NAME:      TURBIDITY SAMPLES  REPORTING
                                               :  032
           FLAG
DESCRIPTION
DATE TYPE:

USAGE:
               A/N
                                         PICTURE:
           A flag describing reporting made for turbidity
           monitoring.
SUB FIELD  (S):
                   NONE
VALUES:    L = Reporting single samples on a list
           S = Reporting monthly summary
                      INPUT/OUTPUT REFERENCE


           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                      H
EDIT REQUIREMENTS:
           Must be L, S or blank,
COMMENTS:
           NONE.
                                       X
                                             X
                                                   X
X
Date: 	5/6 / 76  Revision  Date:
                                                  Revision #
                              -190-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   OPERATE-REPORT	

NAME:       OPERATING REPORT FLAG
                             REF  #:   033
DESCRIPTION

DATE TYPE:  Numeric

USAGE:
                             PICTURE:    9(1)
A flag indicating whether a PWS must submit a
monthly operation report.
SUB FIELD  (S):   NONE

VALUES:
            1
            0
    Yes, PWS must report
    NO
                      INPUT/OUTPUT REFERENCE

           PILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
EDIT REQUIREMENTS:
            Must  be  1  or  0
COMMENTS:
            NONE.
                                  H
                           X
                                            1
                                                 SB
                                                  x
Date:    5/6 / 76  Revision Date:
                                      Revision #
                               -191-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   LAST-OP-REPORT	   REF  #J     034

NAME:       DATE OF LAST OPERATING REPORT
DESCRIPTION

DATE TYPE:    Numeric

USAGE:
                              PICTURE:    9(4)
Date  for which the last operation report was
submitted.
SOB FIELD  (S):     MMYY

VALUES:
            A valid month and year.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                           I/O TO SUBSYSTEMS
                      w

                      H
                                  CJ_
                                I
                                                   X
EDIT REQUIREMENTS:
            A valid month  and year no  later than  current  date,
COMMENTS:
           NONE.
Date:    5/6 / 76  Revision Date:      /    /     Revision #:
                                -192-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   POP-SERVED



NAME:
                                         REP f-:
                                                   035
            SIZE  OF POPULATION  SERVED
DESCRIPTION



DATE TYPE: Numeric



USAGE:
                                         PICTURE:   9(9)
            Total population  obtaining water  from this PWS,

            not including  population  of  any consecutive PWS.
SOB FIELD  (S):   NONE
VALUES:     Any number greater  than  0.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                                  rj
                                       X
                                            I
                                            I
                                            X
EDIT REQUIREMENTS:
            Must  be numeric and greater than 0
COMMENTS:
           NONE.
                                                 as
                                                 81
                                                       x
Date:    5 / 6  / 76  Revision Date:
                                       /   /
                                                 Revision  #:
                             -193-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   SERVICES-NUM
                             REF  §:    036
            NUMBER OF SERVICE CONNECTIONS
DESCRIPTION

MTS TYPEs  Numeric
                             PICTURE
OS&GE:
The number of service connections, not counting the
consecutive water systems which utilize water from
this PWS.
    FIELD  (S):     NONE	

VALUES:     Any number greater than 0.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                  H
                                  rj
                          I/O TO SUBSYSTEMS
                                       X

                                 X
                                                  81
X
EDIT REQUIREMENTS:
            Must  be  numeric  and  greater  than  zero.
COMMENTS:
           NONE.
Date;    5/ 6 / 76  Revision Date:
                                      Revision #:
                               -194-

-------
                  EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   METERS-NUM


NAME:
                             REF #:    037
NUMBER OF METERS
DESCRIPTION


DATE TYPE:  Numeric


USAGE:
                             PICTURE:    9(7)
The number of service connections equipped

with water meters.
SUB FIELD  (S) :   NONE	'_


VALUES:     Any number greater than zero.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                  H
EDIT REQUIREMENTS:
                          I/O TO SUBSYSTEMS
                                       X
                                            1
                                X
                                     HS
                                     8%
X
            Must be numeric and greater than zero,
COMMENTS:
            NONE.
Date:    5/6 / 76  Revision Date
                                     Revision  #
                              -195-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION







DATA ELEMENT



MNEMONIC:  CONSECUTIVE-NUM	   REP f:     038




NAME:      NUMBER OF CONSECUTIVE PWS's
DESCRIPTION
                                         PICTURE:    9(7)
DATE TYPE:   Numeric	



USAGE:     Number of consecutive systems buying water for resale,
SOB FIELD  (S) :    NONE
VALUES:    Any numeric value.
                      INPUT/OUTPUT REFERENCE




           FILE/TART.?: LOCATION           I/O TO SUBSYSTEMS
                      H
EDIT REQUIREMENTS:
           Must be numeric.
COMMENTS:
           NONE.

                                             x
                                                   X
                                                        X
Date:    5 / 6 / 76  Revision Date:
                                        /   /
                                                  Revision #
                               -196-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  NORMAL-CAPACITY	

NAME!      NORMAL PRODUCTION  CAPACITY



DESCRIPTION

DATE TYPE: Numeric	

USAGE:
                                         REF  |:     039
                                         PICTURE:     9(10)
            Average  annual  production  in  gallons  per  day  during
            the most recent year.
SOB FIELD  (S):   NONE
VALUES:     Any number  greater  than  zero.
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                      H
                                       x
                                            1
                                             X
X
EDIT REQUIREMENTS:
COMMENTS:
           Must be numeric  and  greater than  zero.
           NONE.
X
Date:    5/6 / 76  Revision Date:      /   /
                                                  Revision #
                           -197-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   EMERGENCY-POWER	

NAME S       EMERGENCY POWER ONLY
DESCRIPTION

DATE TYPE:  Numeric
REF #:
                                       040
                             PICTURE:   9(10)
USAGE:
The amount of water in gallons per day that can
be produced with power generation equipment con-
trolled by the PWS.
      NONE
SUB FIELD  (S) :                          _

VALUES:     Any number greater than zero.
                      INPUT/OUTPUT REFERENCE

           PILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS:
                                            I
                                            &
                                            X
                                                  CJ
                                       X
            Must be numeric and greater than zero.
COMMENTS:
            NONE.
Date:    5/6 / 76  Revision Date:
                                      Revision #
                            -198-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   STORAGE -CAP ACTY _   REF  #:

NAME:       DISTRIBUTION STORAGE CAPACITY
DESCRIPTION

DATE TYPE:  Numeric
                                                   Q41
                                         PICTURE:   Q
USAGE:
            Storage capacity, in gallons, or water that is
            ready to go with the distribution system.
SUB FIELD  (S):   NONE

VALUES:
            Any number greater than zero.


                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS:
                                            1
                                            1
                                            X
                                                   X
X
COMMENTS:
           Must  be  numeric  and  greater  than  zero.
           NONE.
Date:    5/6 / 76  Revision Date
                                                  Revision #
                           -199-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   MAX-PRODUCTION	

NAME:       MAXIMUM DAILY PRODUCTION
                                         REF  f:
042
DESCRIPTION

DATE TYPE: Numeric


USAGE:
                                         PICTURE:     9(10)
            Maximum daily production,  in gallons per day.
SUB FIELD  (S):
                  NONE
VALUES:     Any number greater than zero.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                          H
                          H
                                  H
                                  CJ
                                            1
                                            X
                                                   X
EDIT REQUIREMENTS:
            Must  be  numeric  and greater  than  zero,
COMMENTS:
           NONE.
Date:    5/6 / 76  Revision Date:  _ /    /
                                                  Revision #:
                             -200-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC s   LAB-CONTROL
REF
043
            LABORATORY CONTROL INDICATORS
DESCRIPTION
     TYPE'.  Numeric^
PICTURE:
            Flag to indicate if PWS water source is controlled
            by   laboratory.
                  Chemical,  bacteriological,  physical,  radiological
    FIELD  (S)s    in that order.	

VALUES:     For each type:

            0 = Not Controlled
            1 = Controlled

                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
                      w

                      H
                          H
                                  H
   I
                                                  u
                                                   X
EDIT REQUIREMENTS:
            Must be  a 0  or 1
COMMENTS:
            NONE.
Date:    5/6 / 76  Revision Date:
        Revision  #
                            -201-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:  LAB-ID
                                         REF  f:    044
NAME:
           LABORATORY IDENTIFICATION
DESCRIPTION
DATE TYPE: Numeric	

USAGE:     A number identifying a laboratory.
                                         PICTURE:    9(5)
SUB FIELD  (S) :     NONE
VALUES:    Any non-zero number.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                                            I
                                             X
EDIT REQUIREMENTS:
COMMENTS:
           Must be numeric and non-zero.
           Occurs 5 times  (bacteriological, inorganic, organic,
           radiological, physical)
Date:    5/6 / 76  Revision Date:  	/    /     Revision #:
                          -202-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   CAPTIVE-FLAG




NAME:
                              REF 'f:   045
CAPTIVE LABORATORY FLAG
DESCRIPTION



DATE TYPE:   Numeric




USAGE:
                              PICTURE:   9(D
A flag indicating if a laboratory used by a PWS

is a captive laboratory.
SUB FIELD  (S):   NONE



VALUES:    0 = No

           1 = Yes
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
EDIT REQUIREMENTS:
           Must be 0 or 1,
COMMENTS:
                                  M_
           See data element # 044,
                           I/O TO SUBSYSTEMS

                                            X
                                                  a
                                                  a
                                       X
Date:    5/6 / 76  Revision Date:
                                      Revision #:
                          -203-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   MONTHLY

NAME:
                              REF f:  046
MONTHLY BACTERIOLOGICAL

MONITORING
DESCRIPTION

DATE TYPE: Numeric

USAGE:
                              PICTURE:
  9(1)
A state may require a non-community PWS to sample
and analyze monthly for bacteriological contaminants,
although federal and state regulations require only
quarterly monitoring.
SDB FIELD  (S):   NONE

VALUES:
0 = No
1 = Yes, monthly required
                      INPUT/OUTPUT REFERENCE

           PILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
EDIT REQUIREMENTS:
           Must be 0 or 1,
COMMENTS:
                                             13
                                            S
                                 X
                                                  Oi
X
                                                        X
           NONE.
Date:    5/6 / 76  Revision Date
                                      Revision #
                           -204-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   PER-QUARTER

NAMEs
                                REP  §:
   NUMBER OF SAMPLES
            PER QUARTER
DESCRIPTION

BATE TYPE:
USAGE:
 047
                                PICTURE:   9(3)
   Number of samples per quarter that a small community
   PWS may perform for bacteriological analysis in lieu
   of monthly monitoring.
SUB FIELD  (S):

VALUES:     000
        001-099
          NONE
         quarterly monitoring not permitted
         quarterly monitoring permitted,  and the value is
         the number of required samples per quarter
                      INPUT/OUTPUT REFERENCE

           PILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                            X
                                          X
      X
EDIT REQUIREMENTS:
COMMENTS:
           Must be numeric or zero.
           A small community PWS is defined by the federal
           regulations as serving a population of less than 1000
           The water source must be a solely protected ground
           source.
Date:
5/6 / 76   Revision Date:
Revision #:
                          -205-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
            SEASON- START
                                REF  f:
            DATE SEASON STARTS
                                                   048
DESCRIPTION

DATE TYPE: Numeric
USAGE:
                                         PICTURE:
                                             9(4)
   Beginning date for bacteriological monitoring at a
   non-community PWS which is operating seasonally.
SUB FIELD  (S) :  MMDD  for  month  and  day."

VALUES:     Zero =  same  as January 1st
       Non  Zero =  a valid month, day
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
            X
                              I/O TO SUBSYSTEMS
                                                  X
EDIT REQUIREMENTS:
COMMENTS:
           1.  Must be numeric
           2.  Must be zero if PWS is community type
           3.  Must be a valid month and day if non-community PWS
           NONE.
Date:
5/6 / 76  Revision Date
                                                  Revision #
                           -206-

-------
                  EPA WATER SUPPLY DATA SYSTEM

                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   SEASON-END
REF
                               049
            DATE SEASON ENDS
DESCRIPTION
D&TB TYPE?  Numeric
                      PICTURE
            Ending date  for  bacteriological monitoring at a
            non-community  PWS which  operates seasonally.
SUB FIELD  (S) :
MMDD
VM.UES:     Zero
        Non Zero
same as December 31st
a valid month, day
                      INPUT/OUTPUT REFERENCE
EDIT REQU
FffiE/TAELE LOCATION I/O TO SUBSYSTEMS
1
X
VARIANCES &
EXEMPTIONS

w w
p H

REGULATION
TABLE


H

|
X
UPDATE
X
EREMENTS :
PERIODIC
REPORTING
X

ANNUAL
REPORTING
X

            1.  Must be numeric
            2.  Must be zero if the PWS is community type
            3.  Must be zero or valid month and day if non-community PWS
COMMENTS'   ^*  I^ not zero' must be later than SEASON-START, data
•	*      element #048
           NONE.
Date:    5/6 / 76  Revision Date
                               Revision #
                           -207-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  NQN-COMM-FREO

NAME:
ALTERNATE  SAMPLING
           FREQUENCY
DESCRIPTION

DATE TYPE:  Numeric

USAGE:
                               REF #:
                               PICTURE:     9(3)
Alternate  sampling  for bacteriological  analysis.
Applies to non-community PWS  in  lieu of quarterly
or monthly sampling.
SUB FIELD  (S)
VALUES:    Number of days between samples.
                      INPUT/OUTPUT REFERENCE
FILE/TABLE LOCATION
TI
                                  H
EDIT REQUIREMENTS:
           Must be numeric or zero.
COMMENTS:
           NONE.
                                      I/O TO SUBSYSTEMS
UPDA
                                             X
IC
OD
RT
                                        X
RT
X
Date:    5/6 / 76  Revision  Date
                                       Revision #
                            -208-

-------
                   EPA WATER SUPPLY DATA SYSTEM

                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
            CHLORINE
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE: Numeric
            CHLORINE RESIDUAL PERCENT
            OF SAMPLES
                              REF S:   Q51
                                         PICTURE:
                                          9(2)
USAGE:
Percent of samples for bacteriological analysis
that may be replaced by chlorine residual sampling.
SUB FIELD  (S):      NONE

VALUES:     Zero to 75.
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
EDIT REQUIREMENTS:
           1.  Must be numeric.
COMMENTS:
           NONE.
                            X
Date:    5/ 6 / 76  Revision  Date
                                      Revision #
                           -209-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:      	



DESCRIPTION

DATE TYPE: Numeric

USAGE:
            TURBIDITY-UNITS
            ALTERNATE TURBIDITY MCL
      052
                                         PICTURE:    9(1)V9(1)
            State  may increase  the  MCL for turbidity up  to
            5  turbidity  units.
SUB FIELD  (S):   NONE
VALUES:     zero  to  5.
                      INPUT/OUTPUT REFERENCE

           PILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                  H
                                        X
                                             I
X
EDIT REQUIREMENTS:
           1.  Must be numeric
           2.  Must be between the values 0 to 5,
COMMENTS:
           NONE.
Date:    5/6 / 76  Revision  Date
     Revision #
                           -210-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   CONTAMINANT-ID	

NAME:       CONTAMINANT-IDENTIFICATION
                                 REF #:   053
DESCRIPTION

Bi&TE TYPE: Numeric

0S&GE:
                                 PICTURE:
                          9(4)
   A 4-digit number identifying a  contaminant.
SUB FIELD  (S) :   position  1  -  contaminant  group	
                 position  2-4  individual contaminant
VALUES:
           See Contaminant  Table


                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION          I/O TO SUBSYSTEMS
            X
             X
X
                                  H
X
                                                  y
                                                   X
EDIT REQUIREMENTS:
                                               X
COMMENTS:
           1.  Must be numeric
           2.  Must be in table
           This code does not comply with STORET parameters table,
           STORET identifies a pair - contaminant and analysis
           method as a single parameter up to 100,000 different
           parameters.
Date:
5/6 / 76  Revision Date:
                       Revision  #:
                           -211-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
SAMPLING-FREQ
REF f:  Q54
MONITORINO (SAMPLING) FREQUENCY
DESCRIPTION

DATE TYPE:  Numeric
                              PICTURE:   9(3)
USAGE:
Define the elapsed time (in days) between samples,
Used in conjunction with follow-up monitoring of
chemical contaminants.
SUB FIELD  (S):  	NONE

VALUES:     zero to 999
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                           X
                           I/O TO SUBSYSTEMS
                            X

   X
                                                  81
X
                                                        X
EDIT REQUIREMENTS;

            1.   Must be numeric.
            2.   On PWS inventory File,  must be greater than zero
                if there is a corresponding CONTAMINANT-ID, data
COMMENTS:       element #053, for follow-up.
            NONE.
Date:    5/6 / 76  Revision Date
                                      Revision #:
                           -212-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   START-PERIOD

NAME:
                              REF f:
DATE OF STARTING SAMPLING
            PERIOD
DESCRIPTION

DATE TYPE: Numeric
055
                              PICTURE:

USAGE:
A state may specify a period within which a yearly
(or multi-yearly) sampling for organic chemicals and
pesticides is to be done.
SUB FIELD  (S):   MMDD
VALUES:     Zero  -  same  as  January  1st, which  is  the  default  value,
       Non  Zero  -  any valid  month  and day.
                      INPUT/OUTPUT REFERENCE

           FILE/EftBLE LOCATION           I/O TO SUBSYSTEMS
                                       x

                                 X
X
EDIT REQUIREMENTS:
COMMENTS:
           1.  Must be numeric.
           2.  May be zero or a valid month and day.
           NONE.
Date:    5 /_6_ / 76  Revision  Date
                                      Revision #
                           -213-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:  END-PERIOD

NAME:
                              REF #:   056
DATE OF ENDING SAMPLING
            PERIOD


DESCRIPTION

DATE TYPE:  Numeric

USAGE:
                              PICTURE:
9(4)
Date of the end of sampling period for organic chemicals,
SUB FIELD  (S):   MMDD	

VALUES:

            Zero =  same  as December  31st which is the default value,
       Non  Zero =  any valid month and day.

                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                      to
UPDATE
                                            X
IC
OD
RT
                                       X
EDIT REQUIREMENTS:
COMMENTS:
           1.  Must be numeric.
           2.  Must be zero or a valid month and day.
           3.  If START-PERIOD, data element #055 is present,
               END-PERIOD must be later.
           NONE.
Date:    5/6 / 76  Revision Date
                                      Revision #:
                           -214-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
            NO-SAMPLING
MNEMONIC:

NAME;



DESCRIPTION

DATE TYPE:  Numeric
REF f:
057
            SAMPLING REQUIREMENT WAIVE
            INDICATOR
                                         PICTURE:   9(1)
USAGE:      Indicates whether the state waived the requirement
            for sampling organic chemical analysis.
SUB FIELD  (S):    NONE

VALUES:
            0 = Requirement not waived
            1 = Requirement waived

                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                                             x
                                                   X
              X
EDIT REQUIREMENTS:
            1.   Must be 0 or 1.
            2.   May not be 1 if  PWS has any surface water source
COMMENTS:
            NONE.
Date:    5/ 6 / 76   Revision Date
                                                  Revision #
                           -215-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  NITRATE-FREQ

NAME:
                                      Q58
NITRATE MONITORING FREQUENCY
DESCRIPTION

DATE TYPE: Numeric

USAGE:
                              PICTURE:  9(3)
Frequency of monitoring nitrate for a non-community
PWS, as determined by the state.
SOB FIELD  (S) :   NONE
VALUES:    A numeric value expressing the maximum number
           of days that may elapse between consecutive samples.
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                 H
                      H
                                  H
                                            a
                                            s
                                            X
EDIT REQUIREMENTS:
           I.  Must be numeric.
           2.  If PWS is non-community, must be greater than zero.
COMMENTS:
           NONE.
Date:    5/6 / 76  Revision Date
                                      Revision  #
                           -216-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   RADIQACTIVE-MTR	   REF  #'  059

NAME :       RADIOACTIVE  MONITORING  FLAG
DESCRIPTION

DATE TYPE: Numeric
                                         PICTURE:
                                            9(1)
USAGE:
   A flag indicating if a PWS must be monitored continuously
   for radioactive contaminants.
SUB FIELD  (S)
           NONE
VALUES:     0  = No
            1  = Yes,  but  only  for natural  radioactive  contaminants
            2  = Yes,  but  only  for man-made radioactive contaminants
            3  = Yes,  all  radioactive  contaminants

                      INPUT/OUTPUT REFERENCE

           FILE/TABLE  LOCATION           I/O TO SUBSYSTEMS
                                       X

                                    X
                                                  X
X
EDIT REQUIREMENTS:
COMMENTS:
            Must  be  0,  1,  2,  or  3.
            A PWS  must  be  continously monitored  for  radioactive
            contaminants if  the  initial  sample violates  the MCL.
            Also,  the state  may  require  monitoring if  a  PWS is
            located  below  an atomic  power  station etc.
Date:
5/6 / 76   Revision Date:
                                                  Revision #:
                           -217-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  LAST-UPDATE

MME:
DESCRIPTION

DATE TYPE:   Numeric
                                         REF f:
           DATE OF LAST UPDATE
060
                                         PICTURE:    9(5),.9(6)
0S&GE:     Date on which the record was last updated.  Used to
           establish an audit trail.
S0B FIELD  (S): On giles as Julian YYDDD, on reports MMDDYY

VALUES:    A  date.
                      INPUT/OUTPUT REFERENCE
FILE/TABLE





B
& I
§
R
X
il
||
§ H
s S
X
LOCATION I/O TO SUBSYSTEMS
I
S §
Q H
H §

g
g M
W §
S §






H
1
g
8


^
g
H
X
EDIT REQUIREMENTS:

g
^
fe
X

CJ g
as

g s
X

8
^ s
§ 2
H a
X

NONE.
COMMENTS :
NONE.
Date:    5/6 / 76  Revision Date
                                                 Revision #:
                           -218-

-------
                   EPA WATER SUPPLY DATA SYSTEM
DATA ELEMENT
            MCL
MNEMONIC:

BSAMEs




DESCRIPTION

DATS TYPE:  Numeric
                     DATA ELEMENT DESCRIPTION
REF I:
 061
            MAXIMUM (MINIMUM) CONTAMINANT

            LEVEL
                                          PICTURE:
                                                     Q (fi\
            The maximum or minimum level defined by state or
            federal regulations for each contaminant, or as
            determined by a variance or an exemption.
    FIELD  (S):   NONE

VALUES:
            A numeric value




                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION            I/O TO SUBSYSTEMS
                 X
S
TI
                           X
                                   H
                                  t)
                                        H
DA
   X
IC
OD
RT
P
X
RT
EDIT REQUIREMENTS:
            Must be numeric.
COMMENTS:
           NONE,
Dates    5/6  / 76   Revision Date
                                                  Revision #
                           -219-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:  VIQ-CQNTAM-YTD

HAMEs      VIOLATIONS OF
DESCRIPTION

DATE TYPES COMPUTATIONAL-3
REF
           CONTAMINANT LEVEL YTD
PICTURE: S9(3)
USAGE:     This is an accumulator of the number of violations
           of contaminant levels occurring year to date.
    FIELD  (S)s  	

VALUES:    o to 999
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
                                  H
   X
                                                  81
X
                                                        X
EDIT REQUIREMENTS:
           Must be numeric.

COMMENTS:  There is one accumulator for each contaminant group:
           physical, inorganic chemicals, pesticides and organic
           chemicals, microbiological, radioactive and treatment,
Date:    5 / 6/76  Revision Date:
        Revision  #
                          -220-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  VIO-SAMP-YTD

NAME:
                              REF $:   063
VIOLATIONS OF SAMPLING
           FREQUENCY YTD
DESCRIPTION

DATE TYPE: COMPUTATIONAL-3
                              PICTURE:   59(3)
?JSAGE:     This is an accumulator of the number of violations
           of sampling frequency occurring year to date.
SUB FIELD  (S) :   Occurs six times - see*comments.

VALUES:

           0 to 999
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            X
EDIT REQUIREMENTS:
COMMENTS:
                                  H
                            X

x
           Must be numeric.
           There is one accumulator for each contaminant group:
           physical, inorganic chemicals, pesticides and organic
           chemicals, microbiological, radioactive and treatment,
Date:    5/6 / 76  Revision Date
                                      Revision  #
                           -221-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   VIO-OTHER-YTD
REF
064
            OTHER VIOLATIONS
            YTD
DESCRIPTION

DATE TYPE;  COMPUTATIONAL-3
PICTURE:  S9(3)
OSAGEs      This  is an  accumulator of the  number of other
            violations  occurring year to date.
SUB FIELD  (S) :    Occurs six times -  see  comments

VALUES:
            0  to 999
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                      w

                      H
                           EH
                                  H
                                       X
EDIT REQUIREMENTS;


           Must be numeric.


COMMENTS;  There  is one  accumulator  for each contaminant group:
           physical,  inorganic  chemicals, pesticides and organic
           chemicals, microbiological, radioactive and treatment,
Date:    5/6 / 76  Revision Date
        Revision  #
                           -222-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  VIO-CONTAM-TQT	

NAME:      TOTAL VIOLATIONS OF
           CONTAMINANT LEVEL
DESCRIPTION

DATS TYPE: COMPUTATIONAL-3

USAGE:
                                  f:  Q65
                              PICTURE:   S9(3)
This is an accumulator of the total number of
contaminant level violations.
SUB FIELD  (S) :    Occurs six times - see comments.

VALUES:

           0 to 999
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                      I
EDIT REQUIREMENTS:
                                  H
                           I/O TO SUBSYSTEMS
                                       X
                                 1

                                 I
                                 X
U 2
m
 X
COMMENTS:
           Must be numeric.
           There is one accumulator for each contaminant group:
           physical, inorganic chemicals, pesticides and organic
           chemicals, microbiological, radioactive and treatment,
Date:    5/6 / 76  Revision  Date
                                      Revision #
                           -223-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
            VI0-SAMP-TOT
            TOTAL VIOLATIONS
            OF SAMPLING FREQUENCY
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:  COMPUTATIONAL-3

USAGE:
REF f
066
                                         PICTURE:  S9(3)
            This is an accumulator of the total number of
            sampling frequency violations.
SUB FIELD  (S) :   Occurs six times - see comments.

VALUES:
            0 to 999
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS:
                                  H
                                            1
                                            X
                                                   X
              X
            Must be numeric.
COMMENTS;   There is one accumulator for each contaminant group:
            physical, inorganic chemicals, pesticides and organic
            chemicals, microbiological, radioactive and treatment,
Date:    5/ 6 / 76  Revision  Date
                                                  Revision #:
                           -224-

-------
                  EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
               VIO-OTHER-TOT
                                         REF f:   067
               TOTAL OTHER VIOLATIONS
DESCRIPTION

D&TE TYPE:
               COMPUTATIONAL-3
                                         PICTURE: S9(3)
0SAGE:     This is an accumulator  of  the total number of other
           violations.
SUB FIELD  (S) :  Occurs six times  -  see  comments.

VALUES:

           0 to 999
                      INPUT/OUTPUT REFERENCE
FILE/TABLE
EDIT REQU:
ll
X
U9

[REMENTS :
LOCATION I/O TO SUBSYSTEMS
P H

REGULATION
TABLE



H

g
X
UPDATE
X
PERIODIC
REPORTING
X
ANNUAL
REPORTING
X

Must be numeric.
COMMENTS: There is one accumulator for each contaminant qr
           physical,  inorganic chemicals,  pesticides and organic
           chemicals,  microbiological,  radioactive  and treatment.
Dates    5/6  / 76  Revision Date:
                                       /   /
                                                 Revision #
                          -225-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:      	



DESCRIPTION

DATE TYPE: A/N

USAGE:
RESERVE
                                         REF  #:
            RESERVED AREA
                                         PICTURE:  varies in length
            Area reserved in a record for accommodating future
            requirements for additional data elements.
SUB FIELD  (S) :

VALUES :

           N/A
                  N/A
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
EDIT REQUIREMENTS:
           N/A
COMMENTS:
                                      I/O TO SUBSYSTEMS
                                        X
                                            x

                                                  CU
                                            X
Date:
         5/6 / 76  Revision Date
                                      Revision #
                           -226-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
 SOURCES-NUM
REF #
 WATER SOURCES NUMBER
DESCRIPTION

DATE TYPE: Numeric
                              PICTURE:
USAGE:
Number of water sources attached to a PWS record in
the PWSIF.  Needed by COBOL to control variable
length PWS records.
SUB FIELD  (S):

VALUES:
            00  to  15
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                           I/O TO SUBSYSTEMS
                 H
                                  H
                                            X

                                       x
EDIT REQUIREMENTS:
COMMENTS:
           NONE  (internally generated)
           A maximum of 15 sources is allowed per PWS,
Date:    5 / 6/76  Revision Date
                                      Revision #
                           -227-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   SOURCE-NAME

NAME:
NAME OF WATER SOURCE
                              &EF I
DESCRIPTION
DATE TYPE:  A/N

USAGE:
                              PICTURE:   x(15)
Used for reporting.
name.
Identifies a water source by its
SUB FIELD  (S):   NONE

VALUES:
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
EDIT REQUIREMENTS
           NONE
COMMENTS:
                                  H
                                  CJ
                           I/O TO SUBSYSTEMS
                                            g
                                            X
                                       X
           NONE.
Date:    5/6 y 76  Revision Date
                                      Revision #
                            -228-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   SOURCE-CODE

mm-.
                              REF  f:   071
WATER SOURCE CODE
DESCRIPTION

DATE TYPE; A/N

USAGE:
                             PICTURE:   X(l)
Identifies the type of water source,
SOB FIELD  (S):    NONE
VAL0ES:     s =
            G =
            P =
    Surface Water
    Ground Water
    Purchased Water (treated water)
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS:
                                            X
            Must have the values S,  G,  or P.
COMMENTS:
                                       X
X
            NONE.
Date:    5/6 / 76  Revision Date:
                                      Revision #
                           -229-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

E4NEMONIC:   NUMBER-OF-WELLS

            NUMBER OF WELLS
                                         REF f:
072
DESCRIPTION

DATE TYPE: Numeric
                                         PICTURE:
  9(2)
USAGE:
            If  a  number  of  wells  are  treated  in  one  treatment
            plant,  they  are considered  as  one water  source.
            This  data  element  specifies the number of wells
            per source.
SUB FIELD  (S):
                          NOME
VALUES:
           Numeric  value,  0  to  99.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
            x
                 H
                                      I/O TO SUBSYSTEMS

                                            X
                                                  a
                                                  a
     X
EDIT REQUIREMENTS:
COMMENTS:
           1.  Must be numeric.
           2.  Must be between 0 and 99,
           NONE.
Date:    5/6/76  Revision Date;
                                                  Revision #
                          -230-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
AVAILABILITY
                               REF
                                                   073
           WATER AVAILABILITY CODE
DESCRIPTION

DATE TYPE:   A/N
                               PICTURE:   X(l)
           A code describing the availability of a water  source
SUB FIELD  (S) s   NONE

VALUES:
 Space  or  P  =  Permanent  source
          S  =  Seasonal source
          R  =  Reserve source
          E  =  Emergency  source

           INPUT/OUTPUT REFERENCE

FILE/TABLE  LOCATION          I/O TO SUBSYSTEMS
                                  H
                                       X
                                  X
EDIT REQUIREMENTS:
               Must be P, S, R, E or blank.
COMMENTS:
           NONE.
                                                  O
                                                   x
X
Date: 	5/6 / 76  Revision  Date
                                       Revision #
                          -231-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:  BASIN-NUMBER

NAME:
                                         REF t:   Q74
           RIVER BASIN NUMBER
DESCRIPTION

DATE TYPE: Numeric
                                         PICTURE:
    9(7)
USAGE:
           This data element applies to surface water sources,
           indicating the river  (or lake) from which water is taken,
           The main use of the information is to identify PWS's
           that draw water from a certain river in a case of
           major contamination.
SUB FIELD  (S) : 	NONE	
VALUES:
           A numeric value.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                                            I
                                            1
                                            X
                                                  x
      X
EDIT REQUIREMENTS:
           Must be numeric or zero,
COMMENTS:
           NONE.
Date:
         5/6 / 76  Revision Date:
Revision #:
                           -232-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
             LATITUDE
MNEMONIC:

NAME:      	




DESCRIPTION

DATE TYPE:   Numeric
         (
USAGE:
             LATITUDE OF WATER SOURCE
             Latitude of water source.
REF f
075
                                         PICTURE:
            9(7)
SUB FIELD  (S):

VALUES:
                  Degrees - 3 positions
                  Minutes - 2 positions
                  Seconds - 2 positions
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                 H
                      w

                      H
                                  H
                                       X
                                            X
         X
     X
EDIT REQUIREMENTS;
           1.   Must  be  numeric.
           2.   The first  position  of  the  degrees must  be  zero,
           3.   Minutes  and seconds maximum value is  60.

COMMENTS:
          NONE.


Date:    5/6 / 76  Revision Date:
                                                  Revision #
                           -233-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   LONGITUDE	

NAME:       LONGITUDE _OF WATER SOURCE
                                         REF #:  076
DESCRIPTION

DATE TYPE:  Numeric

USAGE:
           Longitude of water source.
                                         PICTURE:  9(7)
SUB FIELD  (S):  Degrees -  3 positions
VALUES:
                Degrees - 2 positions
                Degrees - 2 positions
                      INPUT/OUTPUT REFERENCE
           PILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                 H
                                            I
                                            X
                                                  8
                                                  X
                                                        i
EDIT REQUIREMENTS:
           1.  Must be numeric.
           2.  Minutes and seconds maximum value is 60,
COMMENTS:
           NONE.
Date:    5/J> / 76  Revision Date:
                                                  Revision #
                          -234-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
TREATMENTS
                              REF f:
 APPLIED WATER TREATMENTS
          077
DESCRIPTION
DATE TYPE:

USAGE:
  Numeric
PICTURE:  9(16)
Indication of water treatment techniques which are
applied to a water source.
SUB FIELD  (S):

VALUES:
      13 subfields.  The 13th is for "other".
      12 applied to particular techniques.  See comments
      below.
           For each technique:
           0 = not applied
           1 = applied
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                           I/O TO SUBSYSTEMS
                                       X
                                 x
         X
EDIT REQUIREMENTS:
           Must be 0 or 1 for every technique.

COMMENTS; Providing for techniques:

          Aeration, Prechlorination, Coagulation, Sedimentation,
          Filtration, Corrosion Control, Softening, Taste and
          Odor Control, Iron Removal, Ammoniation, Fluoride
          Adjustment, Disinfection, Other.
Date:    5/6 / 76  Revision Date:      /    /      Revision #:
                           -235-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   VE-ID
NAME:
            VARIANCE OR EXEMPTION
                                         REF  #:   078
            IDENTIFICATION
DESCRIPTION
DATE TYPE:   Numeric
                                         PICTURE:
9(5)
USAGE: Number identifying a variance or exemption within a state,
SUB FIELD  (S) :   NONE
VALUES:
             A non-zero number.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                X
                          I
EDIT REQUIREMENTS:
            Must be numeric and non-zero.
COMMENTS:
            NONE.

                                                  X
 X
Date:    5/6 /7fi   Revision  Date
                                                  Revision #
                           -236-

-------
                   EPA WATER SUPPLY DATA  SYSTEM

                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   VE-TYPE

NAMES
                                         REP  §:   Q79
            VARIANCE OR EXEMPTION
            INDICATOR
DESCRIPTION

DATE TYPE:    A/N
                                         PICTURE: X(l)
USAGE:      A flag indicating if the V &  E  record  is a variance
            or an exemption.
SUB FIELD  (S)

VALUES:
                   NONE
            V = Variance
            E = Exemption
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                   H
                                      I/O TO SUBSYSTEMS
                                            X
                                                  8
                                                  X
X
EDIT  REQUIREMENTS:
            Must be ' V '  or ' E '
COMMENTS:
            NONE.
Date:
          /  fi  /7fi    Revision Date: _ /   /     Revision #
                           -237-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:




DESCRIPTION

DATE TYPE:  A/N
VE-STATUS
                             REF t
STATUS OF V & E
                             PICTURE:  X(l)
USAGE:   .   A flag indicating the legal status  of  a  variance
            or an exemption.
SOB FIELD  (S) :     NONE	:	

VALUES:     See Variance/Exemption Status  Table
                      INPUT/OUTPUT REFERENCE
FILE/TABLE LOCATION I/O TO SUBSYSTEMS







P5
o
£|
R
X
•«
fiy ^^
£) t— {
||
§ S

1
!«r
H W
^§
O H
S S

g
H
H

S H







H
H

1
H




B
R




I
5
X
EDIT REQUIREMENTS:

C J if-*
rH R
11
P (^
X


rf
pj
S K
§ ^C
X

            Mus.t be .contained in Variance/Exemption
            Status Table
COMMENTS:
            NONE.
Date:   5/6 /7fi   Revision .Date:
                                     Revision #
                          -238-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   EXPIRATION-DATE

88AME?       EXPIRATION DATE
                                          REF f:  081
DESCRIPTION
                                          PICTURE:  9 (5) ,  9 (6)
SATE TYPE:    Numeric	            	

USAGE:      Date on which a variance  or exemption  expires.
SUB FIELD  (S):  On file YYDDD Julian,  on input/reports MMDDYY.

VALUES:     A valid date.
                      INPUT/OUTPUT  REFERENCE
           FILE/TABLE LOCATION
                                       I/O TO SUBSYSTEMS
                X
                      §
                                   t_L

                                             x
                                                   X
EDIT  REQUIREMENTS:
X
COMMENTS:
            1.   Must be a valid  date  or  all  "9".
            2.   If not all "9",  the date must be  later than
                the corresponding  EFFECTIVE  DATE, data element  #024.
            A date containing  all  "9"  implies that no expiration date
            was set.
Date:    5 /  fi /7fi    Revision Date:
                                        /   /
                                                  Revision  #:
                          -239-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   MODIFIED-MCL
                                          REP 8:    082
            MODIFIED MCL
DESCRIPTION

DATE TYPE:   Numeric
                                          PICTURE:
   9(6)
USAGE:
            Indicates a modified MCL  if  the variance or exemption
            modified the MCL for a contaminant.  Used in deter-
            mining compliance.
SUB FIELD  (S):    MCL	

VALUES:     A numeric value.
                      INPUT/OUTPUT REFERENCE

           7XLB/TKELE LOCATION            I/O TO SUBSYSTEMS
                X
                      H
                          B
                                             X
                                                  d,
X
X
EDIT REQUIREMENTS:
            Must  be  numeric.
COMMENTS:
Date:
         5 /  fi /7fi    Revision Date
Revision #
                          -240-

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:



DESCRIPTION
             TREATMENT
REP f:
083
             TREATMENT CODE
DATE TYPE:

USAGE:
              Numeric
PICTURE:
  9(3)
           Indicates a treatment that a PWS is exempt from,
           or a special treatment that is allowed.
SUB FIELD  (S):    NONE	

VALUES:       See Treatments Table.
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                X
                          5 H
EDIT REQUIREMENTS:

   x
    X
           1.  Must be numeric.
           2.  May be zero.
           3.  If non-zero,  must be in  treatments  table.
COMMENTS:
           NONE.
Date:    5 /  fi /7fi    Revision .Date
         Revision #,
                          -241-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT



MNEMONIC:   ALT-TREATMENT




KANE:
            ALTERNATE TREATMENT




            TECHNIQUE CODE	
DESCRIPTION



DATE TYPE:    Numeric



USAGE:
                                         REF f:
                                          PICTURE:   9(3)
            A code describing an alternate treatment technique

            that a PWS may use instead of an  approved treatment

            technique.
8DB FIELD  (S) :



VALUES:
                  NONE
            See Treatments Table.
                      INPUT/OUTPUT REFERENCE
           PILE/TABLE LOCATION
                                       I/O TO SUBSYSTEMS
            S
                 X
                      o
                      H
                                  C)
                                             X
                                                  8§
                                                  el
P
                                                  X
EDIT REQUIREMENTS:
COMMENTS:
            1.  Value must be numeric.

            2.  If not  zero, then it must be present in the table,
           NONE.
Date:
          /
                     Revision Date:    9 /20 /76   Revision ft:  i
                          -242-

-------
                   EPA WATER SUPPLY DATA SYSTEM


                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT
MNEMONIC:   MILESTONE-CODE

            MILESTONE CODE
REF #
                                                     085
DESCRIPTION
                A/N
PICTURE:
DATE TYPE: 	

USAGE:      Code describing the milestone to be reached.
SUB FIELD  (S):   NONE


VALUES:
            See Milestone Code Table.
                      INPUT/OUTPUT REFERENCE


           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                 M
                      H
                                   H
EDIT  REQUIREMENTS:
COMMENTS:
            Must be included in the table
            NONE.
                                             3
                                             ii
                                              X
                                                  O
         X
                                                       X
Date:    g  /  fi  /7fi   Revision Date:     /   /     Revision  #
                           -243-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   TARGET-DATE

NAME:
                                         REP
                                                   086
            MILESTONE TARGET  DATE
DESCRIPTION

DATE TYPE:

USAGE:
               Numeric
                                         PICTURE:   9 (5),fr
            Date on which a completion of one milestone is to
            be completed.
SUB FIELD  (S):  On file  YYDDD  Julian,  on input/reports 
-------
                   EPA WATER SUPPLY DATA SYSTEM
DATA ELEMENT
MNEMONIC:   CASE-ID
NAME:
                     DATA ELEMENT  DESCRIPTION
                                          &EF f:
            ENFORCEMENT ACTION CASE
            IDENTIFICATION
DESCRIPTION
DATE TYPE:    Numeric
USAGE:  Enforcement action identification.
                                                    087
                                          PICTURE:  9(5)
SUB FIELD  (S):    NONE
VALUES:
            A non-zero number.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                       I/O TO SUBSYSTEMS
                      X
                                  LL.
EDIT REQUIREMENTS:
           Must  be numeric and non-zero.
COMMENTS:
           NONE.
                                            i

                                                       X
Date:    5/6 /if,    Revision Date
                                                  Revision #
                           -245-

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT
MNEMONIC:   CASE-REFERENCE	

HAME:       LEGAL CASE IDENTIFICATION
                                          REF §:
DESCRIPTION

DATE TYPE:
088
              a/N
                                          PICTURE:
   n 9
USAGE:
            Legal identification  of  an  enforcement action case
            letter number and date,  file number, etc.  Used to
            identify an enforcement  action.
SOB FIELD  (S) :    NONE	

VALUES:     No predetermined values.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                       I/O TO SUBSYSTEMS
EDIT REQUIREMENTS:
            NONE
COMMENTS:
           NONE
                      X
                                                        X
Date:    5/6 /7fi    Revision .Date
                                                  Revision #
                           -246-

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   ACTION-DATE

HAME :       ACT ION DATE
                                         REP f:
DESCRIPTION

DATE TYPE:  Numeric

USAGE:
  089
                                         PICTURE:   9(5) , 9(6)
            Date on which the enforcement action was initiated.
SUB FIELD  (S):  On file YYDDD Julian,  on input/reports MMDDYY.

VALUES:     A date not  earlier  than  1977•.
                      INPUT/OUTPUT  REFERENCE

           PILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                     X
                                   H
EDIT REQUIREMENTS:
COMMENTS:
            1.  Must be numeric.
            2.  Must be a valid date.
            3.  Must not be earlier than 1977,
           NONE.
                                                        X
Date:
          /  K  /?fi    Revision Date
Revision #
                           -247-

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT
MNEMONIC:   CLOSE-INDICATOR	

NAME:       CASE STATUS INDICATOR
                                          REP f:    Q9Q
DESCRIPTION

DATE TYPE:  Numeric

USAGE:
                                          PICTURE:   9(1)
            A flag indicating whether the case is open (active)
            or closed (inactive).
SUB FIELD  (S):   NONE

VALUES:
            0 = Case Open
            1 = Case Closed
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                      X
                                   H
EDIT REQUIREMENTS:
            1.  Must be numeric.
            2.  Must have the value '0' or 'I1
COMMENTS:
            NONE.
                                                        X
Date:    5 /... 6 /7fi    Revision Date:
                                        /   /
Revision #
                          -248-

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT
MNEMONIC:   PARTY-TYP-DEFND

NAME:       ENFORCEMENT ACTION
                                          REF §:
            PARTY TYPE DEFENDANT
DESCRIPTION

DATE TYPE:
              A/N
                                         PICTURE:   X(l)
USAGE:      Code describing the type of party in an enforcement
            detail case.
SUB FIELD  (S) :   NONE	;	

VALUES:     See Enforcement Party Type Table.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                       I/O TO SUBSYSTEMS
                      l
                      x
                                                        X
EDIT REQUIREMENTS:
            Must be contained in Enforcement Party Type table.
COMMENTS:
            NONE.
Date:    5/6 /7fi   Revision .Date
                                        /   /
                                                  Revision f
                           -249-

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT
MNEMONIC:   PARTY-TYP-PLAIN


NAME:       ENFORCEMENT ACTION
DESCRIPTION

DATE TYPE:    A/N

USAGE:
                              REF f:
092
            PARTY TYPE PLAINTIFF
                              PICTURE:  X(l)
Code describing the type of party in  an  enforcement
action case.
SUB FIELD  (S):
       NQNR
VALUES:     see Enforcement Party Type Table
                      INPUT/OUTPUT REFERENCE
           PILE/TABLE LOCATION
                           I/O TO SUBSYSTEMS
                                                        X
EDIT  REQUIREMENTS:
             Must be contained in Enforcement Party  Type  table
COMMENTS:
           NONE.
Date:    5/6 /76    Revision Date:
                                      Revision  #
                          -250-

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT
MNEMONIC:   VIPLATION-DATE

SAME;       VIOLATION DATE
                              REF f:
093
DESCRIPTION

DATE TYPE:  Numeric

USAGE:
                              PICTURE:  9(6),  9(5)
Date on which a violation occurred.
SUB FIELD  (S):  On  files YYDDD Julian, on input/reports MMDDYY.

VALUES:     A valid date
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                          H
                                   H
                                   CJ
                                                  P
                                                  a§
EDIT REQUIREMENTS:

            When entered on an input  transaction  form:
            1.   Must be numeric
            2.   Must be a valid date
COMMENTS:   3.   Must be earlier than  processing date
            NONE.
                                                       X
Date:    5 /  s /if,    Revision Date
                                      Revision f
                              -2.51-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
DATA ELEMENT
MNEMONIC:   VIOLATION-TYPE

SAME:       TYPE OF VIOLATION
                             REF f:
DESCRIPTION

DATE TYPE:  A/N

USAGE:
                             PICTURE:    X(l)
A code describing the violation by associating  it with
one of several types.
                   NONE
SUB FIELD  (S):

VALUES:     See Violation Type Table.
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                      X
EDIT REQUIREMENTS:
            Value must be included in  Violation  Type Table.
COMMENTS:
Date:    5 /  s /7fi    Revision .Date:
                                      Revision #
                               -252-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   REASON



NAME:
                                         REF  f:
            REASON FOR VARTANPK OR



            EXEMPTION	
DESCRIPTION
DATE TYPE:  A/N



USAGE:
                                         PICTURE:
            Reason for establishing a variance or exemption.
SUB FIELD  (S):
VALUES:     See Variance/Exemption Reason Table.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                 X
                      H
                                  H
                                             X
                                                  a
                                                  8
                                        X
EDIT REQUIREMENTS:
           Must be  in Variance/Exemption Reason Table,
COMMENTS:
Date:
           NONE.
/1R / 7fi  Revision Date:
                                        /    /
                                                  Revision #:
                              -253-

-------
                   EPA WATER SUPPLY  DATA SYSTEM

                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   LEGAL-STATUS

•NAME:       LEGAL STATUS
                                          REF #:
DESCRIPTION
                                          PICTURE:   X(l)
DATE TYPE:    A/N	            	

USAGE:      Indicates legal status  of  an  enforcement action.
SOB FIELD (S):  	

VALUES:     Sge Legal Status Table.
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                                       I/O TO SUBSYSTEMS
RY
                      H
                      X
TI
                                   H
EDIT  REQUIREMENTS:
COMMENTS:
            Must be in  Legal  Status Table.
            NONE.
UPDATE
IC
OD
RT
RT
Date:
          /  & /-if,   Revision Date:
                                        /   /
Revision #
                               -254-

-------
                   EPA WATER SUPPLY DATA SYSTEM

                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:

NAME:




DESCRIPTION
              TRAN-CQDE
                                         REF
                                                     Qq7
              TRANSACTION
              CODE
              A/N
                                         PICTURE:   X(2)
DATE TYPE: 	

USAGE:        Code to indicate  type  of transaction
SUB FIELD  (S):
VALUES:
           BE,BV,BP,BS  = Batch header record
           00  = Add  new record
           01-13 = Change existing  record
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                 H
                                       X
                                            x
EDIT REQUIREMENTS;   Must be  BE,BV,BP,BS  or 00-13
COMMENTS:
Date:   5 / 19 / 76   Revision pate:
                                        /    /
                                                  Revision #:
                               -255-

-------
                  EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
              BATCH-NUM
              BATCH
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:   Numeric
REP #:
098
              NUMBER
                                         PICTURE:  9(4)
USAGE:    Number  assigned externally to a batch of transaction
          documents  for control purposes.
SUB FIELD  (S)
VALUES:   Q  -  9999
                      INPUT/OUTPUT REFERENCE
EDIT REQU:
FILE/TABLE LOCATION
,|

1

EREMENTS :
ll

REGULATION
TABLE



I/O TO SUBSYSTEMS
H

,
X

UPDATE
X

PERIODIC
REPORTING


ANNUAL
REPORTING


Must be numeric
COMMENTS :
Date:   5 / 19 / 76   Revision Date:
                                                 Revision #
                              -256-

-------
                   EPA WATER SUPPLY DATA SYSTEM

                            RECORD LAYOUT
DATA ELEMENT
             THAN - NUM
             TRANSACTION
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:   Numeric
REF f:   099
             NUMBER
                                         PICTURE:  9(2)
USAGE: Number assigned sequentially to each transaction within a
       batch for control and identification purposes.
SUB FIELD  (S):

VALUES:  0-99
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
            B
                «*
EDIT REQUIREMENTS:
         N/A
COMMENTS:
                                  rj
Date:   5 /19 /76   Revision Date:
                                                  Revision #
                               -257-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:

USAGE:
             TRAN-COUNT
             TRANSACTION
             COUNT
Computational - 3
                            REF f:  100
                                         PICTURE:  $9(5)
             The total number of transactions being input for
             a state.
SUB FIELD  (S) :  	

VALUES:     1-99999
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                          B
EDIT REQUIREMENTS:
                 N/A
COMMENTS:
                         I/O TO SUBSYSTEMS
                                        X

                                X
                                    a
                                                  8%
Date:   5 /19 / 76  Revision Date:
                          /	L
                                                  Revision #
                                -258-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:    SOURCE-ID-NUM	

HAMEs        SOURCE IDENTIFICATION
                                         REF  ft:     101
             NUMBER
DESCRIPTION

DATE TYPE:   Numeric
                                         PICTURE:   9(2)
USAGE:       To identify which source is being referenced on
             the PWS Inventory record
SUB FIELD  (S):
VALUES:     01-15
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                 H
                      w

                      H
                          H
                                  H
                                        X
                                             X
                                                  q
                                                  Cu
EDIT REQUIREMENTS:
              Must be 01-15
COMMENTS:
Date:   5/19 / 76  Revision Date:
                                                  Revision #
                              -259-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
             YIO - COUNT
             VIOLATION
             COUNT
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:   Computational - 3

USAGE:
REF I
1Q2
                                         PICTURE:   g9(7)
             The total number of violations being input for a
             state.
SUB FIELD  (S): 	

VALUES:       1-9999999
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
TI
EDIT REQUIREMENTS:
                 N/A
COMMENTS:
                                      I/O TO SUBSYSTEMS
                                        X
UPDATE
                                             X
IC
OD
RT
P
Date:  5  /19 /76   Revision Date
                                                  Revision #
                              -260-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:



NAME:








DESCRIPTION



DATE TYPE:



USAGE:
              ACTUAL - DATE
              DATE MILESTONE
              COMPLETED
              Numeric
                                         REP f:  103
                                         PICTURE:  9(5)t9(6)
SUB FIELD  (S) : On file YYDDD Julian, on input/reports MMDDYY.




VALUES:
                      INPUT/OUTPUT REFERENCE




           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                 M
EDIT REQUIREMENTS:
            Must be a valid date.
COMMENTS:

                                                       x
Date:  5  /24 /76   Revision Date:
                                       /   /
                                                  Revision #
                                -261-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
             LAB-OWNER
             LABORATORY
             OWNER TYPE
MNEMONIC:

NAME:




DESCRIPTION

DATE TYPE:   Numeric

USAGE:
          REF t:  104
                                         PICTURE:
            A code describing the type of laboratory owner,
SUB FIELD  (S)
VALUES:
           1 = PWS
           2 = State
           3 = Private
           4 = University
5 = Hospital
6 = Other
                      INPUT/OUTPUT REFERENCE


           HIE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                  H
EDIT REQUIREMENTS:
                 Must be in range 1-6
COMMENTS:
                                            i
Date:   5 / 24/76   Revision Date:
                                                  Revision #
                               -262-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:


NAME:




DESCRIPTION

DATE TYPE:

USAGE:
              LAB-AUTHORIZE
REF #:   105
              LABORATORY ANALYSIS
              AUTHORIZATION CODE
              A/N
PICTURE:  X(l)
              A flag to indicate if a laboratory  is  authorized
              to perform analysis a contaminant type.
SUB FIELD  (S):
VALUES:
              Y = authorized
              N = not authorized
                      INPUT/OUTPUT REFERENCE
           TILE/TABLE LOCATION
EDIT REQUIREMENTS:
              Must be Y or N
COMMENTS:
                                      I/O TO SUBSYSTEMS
                                       X
                                            g
                                                 yg
                                                 8g
                                                        8
Date:
         5/24/76  Revision Date:
        Revision  #
                               -263-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:    ANALYSIS-METHOD
NAME:        SAMPLE ANALYSIS
                            REF  #:    106
             METHOD
DESCRIPTION
DATE TYPE:   Numeric
USAGE:
                            PICTURE:  9(3)
A code describing an authorized analysis method.
SUB FIELD  (S):  	
VALUES:     See Analysis Methods Table,
                      INPUT/OUTPUT REFERENCE
           riLE/TABLE LOCATION
                         I/O TO SUBSYSTEMS
                                        x
                                            1
EDIT REQUIREMENTS;
            Must be contained in Analysis Methods Table.

COMMENTS:
Date:   5 /24 / 76  Revision  Date:      /   /     Revision #
                                 -264-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:
NAME:      	

DESCRIPTION
DATE TYPE:  Numeric
USAGE:
 ANALYSIS-RESULT
REF f:    107
 ANALYSIS RESULT
                             PICTURE:  9(6)
Results of sample analysis
SUB FIELD  (S)
VALUES:
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS

EDIT REQUIREMENTS:
             Must be numeric.
COMMENTS:
                                        _X
                                            i
Date:   5 / 24/ 76  Revision Date:
                                      Revision #
                               -265-

-------
                   EPA WATER SUPPLY DATA SYSTEM

                            RECORD LAYOUT
DATA ELEMENT
             S AMPLE S-REOtmn
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:   Numeric

USAGE:
             NUMBER OF SAMPLES
             REQUIRED
REP f:    108
                                         PICTURE:  9(5)
             The number of samples that a PWS was required
             to make during a sampling period.
SUB FIELD  (S):

VALUES:
                      INPUT/OUTPUT REFERENCE
           .- ILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
                                            I
EDIT REQUIREMENTS:
             Must be numeric.
COMMENTS;    To allow for bacteriological summary records for
             several analysis methods during the same sampling
             period.
Date:  5	/ 24/ 76  Revision  Date:
                                                  Revision #:
                                -266-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:

NAME:




DESCRIPTION

DATE TYPE:

USAGE:
                SAMPLES  - RECVD
NUMBER OF SAMPLES
RECEIVED
Numeric
                          REF ft:   109
PICTURE:  9(5)
The number of samples received during a
sampling period.
SUB FIELD  (S):

VALUES:
                      INPUT/OUTPUT REFERENCE
           rTLE/TABLE LOCATION
                 H
EDIT REQUIREMENTS:
             Must be numeric.
COMMENTS:
                       I/O TO SUBSYSTEMS
                                        X
                                            1
Date:   5 /24 / 76  Revision Date:
                                  Revision  #
                                -267-

-------
                   EPA WATER SUPPLY DATA SYSTEM

                            RECORD LAYOUT
DATA ELEMENT
MNEMONIC:

NAME:




DESCRIPTION

DATE TYPE:

USAGE:
VIO - DURATION
VIOLATION
DURATION
Numeric
REF f:
.110
PICTURE:  9(3)
                 The duration of a violation of drinking water
                 regulations expressed in days.
SUB FIELD  (S):

VALUES:
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS;

             Must be numeric.



COMMENTS:
                                        X
Date:   5 / 24 / 76  Revision Date:
                                 Revision #:
                               -268-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
             VIOLATION  -  ID
             VIOLATION
              IDENTIFICATION
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:   Numeric

USAGE:
                                         REF
111
                                         PICTURE:   9(5)
             A five digit number identifying a violation
             record within a state.
SUB FIELD  (S):

VALUES:
                      INPUT/OUTPUT REFERENCE
           I" HE/TART ,K LOCATION
                      H
EDIT REQUIREMENTS:
            Must be numeric
COMMENTS:
                                  H
                                      I/O TO SUBSYSTEMS
                                            iL
                                                  O
Date:   5 / 24/76   Revision  Date
                                                  Revision #•
                          -269-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                            RECORD LAYOUT
DATA ELEMENT
              NUMBER OF
              MILESTONES
MNEMONIC:

NAME:




DESCRIPTION

DATE TYPE:    Numeric

USAGE:
              NUM - MILESTONES
REF I:  112
                                         PICTURE:  9(2)
              The number of milestones on an Enforcement
              Actions record.
SUB FIELD  (S):  	

VALUES:       0 to 15
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
IONS
                      X
TI
EDIT REQUIREMENTS:
                                      I/O TO SUBSYSTEMS
                                  H
             Must be in range 0-15.
COMMENTS:
UPDA
IC
OD
RT
                                                        X
Date:   5 / 24 /76   Revision Date:
                                                  Revision #
                               -270-

-------
                  EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:



NAME:








DESCRIPTION



DATE TYPE:
              DESIGN-CAPACITY
              DESIGN CAPACITY
             NUMERIC
REF f:   113
PICTURE:   9(10)
USAGE:    Design capacity of PWS in gallons.
SUB FIELD  (S):



VALUES:
                      INPUT/OUTPUT REFERENCE
i-xLE/TABLE

EDIT REQU:
1
K!
X
ll
ii

[REMENTS :
Must be numeric.
COMMENTS :
None.
LOCATION
i»
p H

§
H
p




I/O TO SUBSYSTEMS
§
1


|



1
X

CJ g
II
X

1
||
X


Date:  6  / 9/76  Revision Date:
                                -271-
        Revision #

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:

NAME;
AVG-AIR-TEMP
REF f:
                                       114
AVERAGE DAILY AIR TEMPERATURE
DESCRIPTION
BATE TYPE:

USAGE:
 NUMERIC
PICTURE:  9(3)V9
           Average maximum daily air  temperature  in  degrees
           Fahrenheit.
SUB FIELD  (S):

VALUES:
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
            X
                          I/O TO SUBSYSTEMS
                                             X
                                                  U g
                                                  81
                                     X
              X
EDIT REQUIREMENTS;

    Must be numeric,
COMMENTS:  None.
Date:    6/9 / 76  Revision Date:
                                     Revision #
                              -272-

-------
                   EPA WATER SUPPLY DATA SYSTEM

                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

BtftME:
              REPORT-NUM-SEL
                                         REF f:   H5
             REPORT NUMBER
              SELECTION
DESCRIPTION

DATE TYPE:   A/N	

USAGE:    The report number of the report being requested.
                                         PICTURE:   X(10)
SUB FIELD  (S):  	

VALUES:       see Edit Requirements.
                      INPUT/OUTPUT REFERENCE

           PILE/TABLE LOCATION           I/O TO SUBSYSTEMS
 EDIT REQUIREMENTS:
 COMMENTS:
                                                  81
                                                        X
                     Positions 1-4 must be ANRP.   Positions 5-7
                     must be 020,  030,  040, 050 or 060.   Positions
                     8-10 must be  as follows:   Rl, R2  or  M5 for
                     020; R1-R25 for 030;  Rl or R2 for 040,  050
                     and 060.
                     For ANRP020,  A means print both reports.
 Date:    6 /18 /76   Revision Date:
                                                  Revision #
                               -273-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   TYPE-OF-PWS-SEL

SAME:       TYPE OF PWS
                              REP f:  116
            SELECTION
DESCRIPTION

DATE TYPE:    A/N
                             PICTURE:  X(l)
USAGE:     Type of PWS to be included  on  an  annual  report.
SUB FIELD  (S):
VALUES:
C = Community
N = Non-community
A = All
                      INPUT/OUTPUT REFERENCE

           jfjiE/TABLE LOCATION           I/O TO SUBSYSTEMS
                      H
                          I
                       H
                                                 81
                                                       X
EDIT REQUIREMENTS:
    Must be C, N or A.
COMMENTS:
    A means include both community and non-community.
Date:   6 /18 /76   Revision Date:     /   /      Revision #:
                              -274-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:    REGION-SEL

NAME:
                                         REP  f:   117
             EPA REGION
             SELECTION
DESCRIPTION

DATE TYPE:   A/N
                                         PICTURE:  X(2)
USAGE:    EPA region being selected for compliance profiles
          ANRP020R1, R2.
SOB FIELD  (S):  	

VALUES:        01-10 or J*6 for all.
                      INPUT/OUTPUT REFERENCE

            jLLE/TAHLE LOCATION           I/O TO SUBSYSTEMS
                                  H
EDIT REQUIREMENTS;

     Must be 01-10 or A* for ANRP020R1, R2
     Must be blank for other reports.

COMMENTS:
                                                       X
Date:
         6/ 18/ 76  Revision  Date:
Revision #
                               -275-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
             STATE-SEL
             STATE
             SELECTION
DESCRIPTION
             A/N
                                         PICTURE:' X(2)
DATE TYPE: 	            	

USAGE:    State being selected for compliance  profiles ANRP020R1, R2,
SUB FIELD  (S):
VALUES:   One of the 56 postal codes assigned to  states and  trust
          territories.  See State Postal  Code Table.  Maybe  A-6 for all,
                      INPUT/OUTPUT REFERENCE
FILE/TABLE LOCATION I/O TO SUBSYSTEMS






K
C5
1

* to
w s
V-3 H
||

g
g
E3 c/5
EMFORC
ACTION


M
EH
REGUIA
TABLE







M
^A
u




B
H

EDIT REQUIREMENTS:



UPDATE



O 2
M M
PERIOD
REPORT



§
PJ
||
X

     Must be in State Postal  Code  Table or
     Must be blank for other  reports.
COMMENTS :
                                              for ANRP020R1, R2,
Date:    6/ 18/ 76  Revision Date:   9 /20 / 76  Revision  #:   i
                               -276-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:



DESCRIPTION
            CONTAM-CTG-SEL
REP f:  119
            CONTAMINANT
            CATEGORY SELECTION
DATE TYPE:

USAGE:
            A/N
PICTURE:
X(4)
          Contaminant category being  selected for compliance
          profiles ANRP020R1, R2.
SUB FIELD  (S):
VALUES:
             PHYS = physical,  INOR = inorganic chemicals,
             PSOR = pesticides and organic chemicals, MICR
             microbiological,  RADI = radioactive, TREA =
             treatment, 2*&&6 = all
                      INPUT/OUTPUT REFERENCE

           jrlLE/TABLE LOCATION            I/O TO SUBSYSTEMS
                                             1
                                                       X
EDIT REQUIREMENTS:

     Must be  PHYS,  INOR, PSOR, MICR, RADI, TREA or M566 for
     ANRP020R1, R2.
     Must be  blank  for other reports.
COMMENTS:
Date:    6 /18 /76   Revision  Date:
                                                  Revision #
                               -277-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT

MNEMONIC:   VIO-TYPE-SEL

NAME:
                                REF #:  120
   VIOLATION TYPE
            SELECTION
DESCRIPTION

DATE TYPE:  A/N
                                PICTURE
USAGE*   Violation type being selected for compliance profiles
         ANRP020R1, R2.
SUB FIELD  (S):

VALUES:
         CONT = contaminant violation
         SAMP = sampling violation
         OTHR = other violation
         K&&6 = all violations
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                  rj
                                                  a
                                                         §
                                                        X
EDIT REQUIREMENTS;

     Must be CONT, SAMP, OTHR or AJ5f$6 for ANRP020R1, R2.
     Must be blank for other reports.

COMMENTS:
Date:
6/18 /76   Revision Date:
Revision #:
                               -278-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:



DESCRIPTION
    SOURCE-TYPE-SEL
REF I
    SOURCE TYPE
    SELECTION
DATE TYPE:

USAGE:
    A/N
121
PICTURE:  X(l)
 Water  source  type  being  selected for compliance profiles
 ANRP020R1,  R2.
SUB FIELD  (S):

VALUES:
                    S  = surface
                    G  = ground
                    P  = purchased
                    A  = all

                      INPUT/OUTPUT REFERENCE

           riLE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                            1
EDIT REQUIREMENTS;

    Must be S, G, P or A for ANRP020R1, R2.
    Must be blank for other reports.

COMMENTS:
                                                 81
Date:
6/18 / 76  Revision Date:
        Revision  #
                               -279-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   ACCUM-TYPE-SEL

NAME:       ACCUMULATOR
REP
                                         122
            TYPE SELECTION
DESCRIPTION

DATE TYPE:
     A/N
PICTURE:
USAGE:    Accumulator type being selected for compliance profiles
          ANRP020R1, R2.
SUB FIELD  (S):

VALUES:
                    YTD = year-to-date
                    TOT = total-to-date
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
                             I/O TO SUBSYSTEMS
                 H
                                            1
EDIT REQUIREMENTS;

     Must be YTD or TOT for ANRP020R1, R2.
     Must be blank for other reports.

COMMENTS:
Date:
6/ 18/76   Revision Date:
         Revision #
                               -280-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:   TOT-TRAN-COUNT

NAME:       TOTAL TRANSACTION
                             REP f:   123
            COUNT
DESCRIPTION

DATE TYPE:  Computational-3

USAGE:
                             PICTURE:  59(7)
Total number of transactions per state on input
from MSIS.
SUB FIELD  (S) :   NONE

VALUES:
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
&
I
TI
EDIT REQUIREMENTS;


   Must be numeric

COMMENTS:
                                  H
                                        X
IC
OD
RT
P
R
Date:   6 / 18/76   Revision  Date:
                                      Revision #
                              -281-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:    TOT-VIO-COUNT



SAME:        TOTAL VIOLATIONS
REP
                                     124
            COUNT
DESCRIPTION


DATE TYPE:   Computational-3



USAGE:
                            PICTURE:   59(11)
Total number of violations per state on input

from MSIS.
SUB FIELD  (S):   NONE



VALUES:
                      INPUT/OUTPUT REFERENCE



           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS;





   Must be numeric



COMMENTS:
                                        X

                                                  a
                                                  8
Date:    (5/18/76   Revision Date:
                                    Revision #
                               -282-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

SAME:
             TOTAL-INPUT
                             REF f:  125
             TOTAL INPUT
DESCRIPTION         '/

DATE  TYPE:   Computational-3
                             PICTURE:  59(5)
USAGE:
Total number of transaction records being  input  on
an MSIS transaction file.
SOB FIELD (S):   NONE

VALUES:
                      INPUT/OUTPUT REFERENCE
           FILE/TABLE LOCATION
 EDIT REQUIREMENTS:



    Must be numeric

 COMMENTS:
                          I/O TO SUBSYSTEMS
                                        X
                                            1
                                 X
Date:    6 /IB /76   Revision Date:
                                     Revision #:
                                 -283-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
 DATA ELEMENT

MNEMONIC:   __

NAME:
  RPT-SEL
  REPORT SELECTION
REF #:  126
DESCRIPTION

DATE TYPE:
   A/N
PICTURE:
USAGE:
To select a report to be printed by the periodic
reporting subsystem.
SUB FIELD  (S)

VALUES:
      NONE
                      INPUT/OUTPUT REFERENCE
           i'JLLE/TABLE LOCATION
                           I/O TO SUBSYSTEMS

                                                  81
EDIT REQUIREMENTS;


   Must  be  PRRP02.0R1-PRRP020R6  for PWS  Inventory reports.
   Must  be  PRRP040R1  for Variance and Exemption Review List,

COMMENTS:
Date:    6 /18 /76   Revision Date
                                      Revision #
                              -284-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
            ADDRESS-SEL
MNEMONIC:

NAME:      	



DESCRIPTION

DATE TYPE:   Numeric
            ADDRESS SELECTION
                                         REF  f:   127
                                         PICTURE
USAGE:       TO select which address,  plant or  mailing,  is  to
             be printed on the periodic  reports.
SOB FIELD  (S) :
                  NONE
VALUES:
              0 = Mailing
              1 = Plant Location
                      INPUT/OUTPUT REFERENCE

           *ILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS;

    Must be 0 or 1


COMMENTS:
                                                   X
Date:
         6/18/ 76  Revision Date:
                                                  Revision #
                               -285-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
   PERCENT-SEL
   PERCENT SELECTION
DESCRIPTION

DATE TYPE:   Numeric
REF S:  128
                                PICTURE:
USAGE:
    To indicate what percentage  of  the  selected  variance
    and exemption records are to be printed  on the
    Variance and Exemption Review List.
SUB FIELD  (S)

VALUES:
        NONE
        Between 0 and 100
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS:
   Must be in range  0 to 100
COMMENTS:
                                             1

                                             I
Date:
6/18/76   Revision Date:
        Revision  #
                                -286-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC :

KANE:
            DESTINATION
REF #:   129
            DESTINATION
DESCRIPTION

DATE TYPE:
              A/N
PICTURE:  X(9)
USAGE:
              To indicate the program number  into  which  Edited
              Report Selection Cards should be  entered.
SUB FIELD  (S):
                 NONE
VALUES:
              PRRP020 for PWS Inventory reports
              PRRP040 for Variance and Exemption  Review List
                      INPUT/OUTPUT REFERENCE
           SALE/TABLE LOCATION
RY
&
EDIT REQUIREMENTS;



   N/A

COMMENTS:
TION
                                      I/O TO SUBSYSTEMS

UPDA
IC
OD
RT
                                                   X
Date:    6/ 18/ 76  Revision Date:
                                                  Revision #
                              -287-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:

USAGE:
  OPERATOR-SEL
REP f:  130
  OPERATOR FOR
  SELECTION
    A/N
PICTURE:  X(3)
Indicates whether each report selection on criterion
is mandator (AND) or optional (OR).
SUB FIELD  (S):    NONE

VALUES:
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                          1
EDIT REQUIREMENTS:
  Must  be  AND  or  OR.   If  blank, default  to OR.
COMMENTS:
Date:   6  / 18 /76   Revision Date:
                                       Revision #
                                -288-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:

USAGE:
MNEMONIC-SEL
REF #:   131
MNEMONIC FOR
SELECTION
 A/N
PICTURE:  X(15)
 Indicates what field is being used as a selection
 criterion.
SUB FIELD  (5);  NONE

VALUES:
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS

                                                 II
                                                  X
EDIT REQUIREMENTS;

  For PRRP010, must be  in Inventory Selection Table.
  For PRRP030, must be  in Variance and Exemption Selection Table


COMMENTS:
Date:    6/18 /  76  Revision Date:
                                     Revision #:
                               -289-

-------
                   EPA WATER SUPPLY  DATA SYSTEM
                     DATA ELEMENT  DESCRIPTION
 DATA ELEMENT
             SORT-SEL
             SORT SEQUENCE
             SELECTION
MNEMONIC:

NAME:



DESCRIPTION

DATE TYPE:   Numeric

USAGE:
REF f:   132
                                          PICTURE:
           9(2)
             To indicate the position in the sort hierarchy.
SUB  FIELD (S):

VALUES:
             0-10
                      INPUT/OUTPUT REFERENCE

           PILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                                  II
                                                   X
 EDIT REQUIREMENTS;

  Must be in range 0-10.  Each one must be unique within a
  group of selection cards.

.COMMENTS:
Date:   6  / 18 / 76  Revision Date
                                                  Revision #
                            -290-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:




DESCRIPTION
            RELATION-SEL
                            REF #:  133
            RELATION FOR
            SELECTION
DATE TYPE!
   A/N
                                         PICTURE:  X(2)
USAGE:   Indicates the relation between what is in the files
         and what is in the FROM-SEL and TO-SEL (Data Elements
         #134,  135)  fields.
SUB FIELD  (S):
                NONE
VALUES:
LT (less than)
EQ (equal)
GT (greater than)
NL (not less than)
                                         NG  (not greater  than)
                                         NX  (not exist, i.e.,  blank)
                                         RG  (range  from-to)
                      INPUT/OUTPUT REFERENCE

           *TLE/TABLE LOCATION            I/O TO SUBSYSTEMS
                                                   X
EDIT REQUIREMENTS;



       Must  be LT,  EQ,  GT,  NL,  NG,  NX  or  RG

COMMENTS:
Date:    6 /  18/76   Revision  Date:
                                    Revision  #
                              -291-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:




DESCRIPTION

DATE TYPE:  A/N

USAGE:
   FROM-SEL
REF f: 134
   FROM VALUE
   FOR SELECTION
                                PICTURE:  X(10)
Indicates the "from" value for comparing to a file
on report selection.
SUB FIELD  (S) :  NONE

VALUES:
                      INPUT/OUTPUT REFERENCE

           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
                                             I
                                                  X
EDIT REQUIREMENTS;
 Must be within the from/to value range for the mnemonic on the
 Inventory Selection Table for PRRP010 or the Variance and
 Exemption Selection Table for PRRP030.  If RELATION-SEL, #133,
 is 'NX1, then FROM-SEL must be blank.
COMMENTS:
Date:   6 / 18/ 76  Revision  Date:
                                        Revision  #:
                              -292-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
  TO-SEL
REF Is
  TO VALUE FOR SELECTION
135
DESCRIPTION
DATE TYPE:

USAGE:
   A/N
PICTURE: X(10)
Indicates the "to" value for comparing to a file on
report selection.
SUB FIELD  (S):    NONE

VALUES:
                      INPUT/OUTPUT REFERENCE

           rTXE/TABLE LOCATION           I/O TO SUBSYSTEMS

                                                  a
                                                  8
                                                  X
EDIT REQUIREMENTS;
  If  RELATION-SEL,  #133,  is  'RG1,  then TO-SEL must meet same
  requirements  as FROM-SEL,  #134.   If RELATION-SEL is other
  than  'RG1,  then TO-SEL  must  be blank.

COMMENTS:
Date:    6 /18 /76   Revision Date:
                                       Revision #:
                             -293-

-------
                   EPA WATER SUPPLY DATA  SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:
             OFFSET-SEL
REF f:   136
             OFFSET FOR SELECTION
DESCRIPTION
DATE TYPE:
              Numeric
PICTURE:
           9(4)
USAGE:    To  indicate the  offset  from  the  beginning of a  file
          where a  field  begins  that  is being  used  for report
          selection.
SUB FIELD  (S):   NONE

VALUES:
                      INPUT/OUTPUT REFERENCE
           PILE/TABLE LOCATION
                                      I/O TO SUBSYSTEMS
EDIT REQUIREMENTS!
 N/A
COMMENTS:
                                                  X
Date:    6/18 /76   Revision  Date:
                                                  Revision #
                             -294-

-------
                   EPA WATER SUPPLY DATA SYSTEM
                     DATA ELEMENT DESCRIPTION
DATA ELEMENT
MNEMONIC:

NAME:




DESCRIPTION

DATE TYPE:

USAGE:
LENGTH-SEL
REF #:   137
LENGTH OF FIELD FOR
SELECTION
Numeric
PICTURE:  9(3)
To indicate the field length of a field that
is being used for report selection.
SUB FIELD  (S):

VALUES:
                  NONE
                      INPUT/OUTPUT REFERENCE


           FILE/TABLE LOCATION           I/O TO SUBSYSTEMS
EDIT REQUIREMENTS



 N/A

COMMENTS:
                                  H

                                                  X
Date:   6 /18 / 76  Revision Date:
                                    Revision #
                               -295-

-------