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-
------- |