Environmental Protection Agency | •« \
Office of Pesticide Programs \
Detailed Design for an Information
Processing System for the Pesticides
Monitoring Program
V. Functional Module Specifications
December, 1978
Contract No. 68-01-3833
ARTHUR YOUNG & COMPANY
-------
OPP MONITORING SYSTEM
DETAILED DESIGN DOCUMENTATION
The Detailed Design Documentation for the EPA/OPP pesticides
Monitoring System consists of 7 Chapters which are bound in 6
volumes. These chapters are:
Chapter Title
I System Overview BQUnd Together
II Implementation Plan
III Data Base Design
IV Input/Output Specifications
V Functional Module Specifications
71 Operations Manual
VII User's Manual
Each of these chapters is largely self-contained but may refer to
information contained in other chapters as necessary.
-------
TABLE OF CONTENTS
PAGE
FUNCTIONAL MODULE SPECIFICATIONS i
RECORD SPECIFICATIONS
TRANSACTION FILE V-l
WATER-SITE FILE V-10
STATE FILE V-ll
RESIDUE FILE V-12
HOSPITAL FILE V-13
CODE FILE V-l4
SOIL SITE V-9
DATA INPUT EDITING SPECIFICATIONS V-15
DESIGN SPECIFICATIONS V-49
APPENDICES
REFERENCE TABLES A-l
MODULE GENERATOR B-l
REPORT REQUEST PARAMETERS C-l
EXAMPLE OF MODULE GENERATION D-l
CALCULATIONS E-l
-------
V. FUNCTIONAL MODULE SPECIFICATIONS
-------
V. FUNCTIONAL MODULE SPECIFICATIONS
This chapter presents the detailed Functional Specifications for
the Pesticides Monitoring System. The specifications are presented
using HIPOcharts for each of the five system modules. These modules
are as follows:
Conversion and Loading
Edit and Update
Response to Queries
Report Gereration, and
Data Base Unloading/Archival.
An additional module has been identified, but not shown in
detail. The function of this module is data base maintenance.
IDMS utilities exist for performing data base recovery, copying,
restructuring, and other necessary maintenance functions. A
complete description of these utilities may be found in the IDMS
Design and Definition Guide and the Operations Manual.
Preceding the HIPO charts are two sections which provide
record specifications and data input edit specifications for
items referenced in the charts. The edit criteria are listed
in processing order. The specification for the data base itself
may be found in Chapter III, Data Base Design.
Following the HIPO charts are a series of Appendices to be
used as references for the Report Generation HIPOs.
-------
RECORD SPECIFICATIONS
-------
FD UPDATE-TRANS-FILE(ALSO REJECT-FILE-HUMANS,
01 TRANSACTION -RECORD.
05 INPUT-TYPE
05 UPDATE-TYPE
05 PAW-WORKSHEET.
10 PAW-SOURCE
10 PAW-LAB-NUM
10 PAW-SAMP-ACC-NUM
10 PAW-SAMP-DATE
10 PAW-STATE-NUM
10 PAW-COUNTY-NUM
10 PAW-SITE-NUM
10 NON-METEOR-DATA.
15 PAW-SAMP-TYPE
15 PAW-CROP-CYCLE
15 SOILS-DATA.
20 PAW-PH
20 PAW-PCT-SAND
20 PAW-PCT-SILT
20 PAW-PCT-CLAY
20 PAW-PCT-ORGANIC
20 SOILS-FILLER
15 WATER-DATA REDEFINES SOILS-DATA.
20 PAW-TIME OF SAMPLE
20 PAW-WATER-FILLER
REJECT-FILE-OTHER)
PIC X.
PIC X.
PIC X.
PIC XX.
PIC X(6).
PIC X(6).
PIC X(2).
PIC X(3).
PIC X(10).
PIC X(6)L
PIC X.
PIC X(3).
PIC X(3).
PIC X(3).
PIC X(3).
PIC X(3).
PIC X(2).
PIC X(4).
PIC X(13).
V-l
-------
15 ESTUARINE-DATA-FILLER REDEFINES
WATER-DATA PIC X(17).
15 AIR-DATA REDEFINES ESTUARINE-DATA-FILLER
20 PAW-TOT-SAMP-TIME PIC X(4).
20 PAW-PRECIP-IND PIC X.
20 PAW-PREC IP-AMOUNT PIC X(4).
20 PAW-AIR-VOL-SAMP PIC X(4).
20 PAW-AIR-FILLER PIC X(4).
15 PAW-ANAL-DATE PIC X(6).
15 PAW-ANAL-METH PIC XX.
15 PAW-RESIDUE-DATA.
20 PAW-RESIDUE-CODE PIC X(6).
20 PAW-TRACE-IND PIC X.
20 PAW-RESIDUE-AMOUNT PIC X(7).
20 PAW-UNITS PIC X.
20 PAW-CONF-CODE PIC X.
10 METEOROLOGICAL-DATA REDEFINES NON-
METEOR DATA.
15 PAW-MIN-TEMP PIC X(4).
15 PAW-MAX-TEMP PIC X(4).
15 PAW-BEG-WIND VEL PIC X(2).
15 PAW-END-WIND VEL PIC X(2).
15 PAW-BEG-RH PIC X(2).
15 PAW-END-RH PIC X(2).
15 PAW-BEG-WIND-DIR PIC X(3).
15 PAW-END-WIND-DIR PIC X(3).
15 PAW-MET-FILLER PIC X(26).
V-2
-------
05 HUMANS-DATA REDEFINES PAW-WORKSHEET.
10 HUM-HOSP-NUM
10 HUM-PATIENT-NUMBER.
15 HUM-PATIENT-ID
15 HUM-PATIENT-ID SUFF
10 HUM-COLL-DATE
10 HUM-TISSUE-TYPE
10 HUM-FORM-NUM
10 Al-DATA.
15 HUM-PAT-BIRTH
15 HUM-PAT-INIT
15 HUM-PAT-SEX
15 HUM-PAT-RACE
15 HUM-PAT-HEIGHT
15 HUM-PAT-WEIGHT
15 HUM-P-S-IND
15 HUM-OCC-CODE
15 HUM-LNG-STAY-IND
15 HUM-DIAG-CODE OCCURS 6 TIMES
15 HUM-A1-FILLER-1
15 HUM-DES-CODE
15 HUM-A1-FILLER-2
10 Bl-DATA REDEFINES Al-DATA.
15 HUM-GC-MAKE-MOD
15 HUM-DETECTOR
PIC X(3).
PIC X(9).
PIC X.
PIC X(6).
PIC XX.
PIC XX.
PIC X(6).
PIC XX.
PIC X.
PIC X.
PIC X(3).
PIC X(3).
PIC X.
PIC X(3).
PIC X.
PIC X(5).
PIC X.
PIC X.
PIC X.
PIC XX.
PIC X.
V-3
-------
15 HUM-COL-1-CODE
15 HUM-COL-2-CODE
15 HUM-AMOUNT 1
15 HUM-AMOUNT 2
15 HUM-ANAL-METH
15 HUM-ANAL-DATE
15 HUM-LAB
15 HUM-RES-CODE
15 HUM-TRACE-IND
15 HUM-RES-AMOUNT
15 HUM-PPM
15 HUM-PPB
15 HUM-CONF-CODE
15 HUM-OVER-IND
15 HUM-B1-FILLER-2
15 HUM-B1-SEX
15 HUM-B1-AGE
15 HUM-B1-FILLER 2
10 HUM-ORIG-CODE
05 SITE-UPDATE-DATA REDEFINES HUMANS-DATA.
10 XSITE-MODE
10 XSITE-DATA
10 SOIL-SITE-DATA REDEFINES XSITE-DATA.
PIC XX.
PIC XX.
PIC X(5).
PIC X(4).
PIC XX.
PIC X(6).
PIC XX.
PIC XX.
PIC X.
PIC X(6).
PIC X.
PIC X.
PIC X.
PIC X.
PIC X(6).
PIC X.
PIC XX.
PIC X (6).
PIC X.
PIC X.
PIC X (77).
V-4
-------
15 XSITE-SOURCE PIC X.
15 XSITE-STATE-NUM PIC XX.
15 XSITE-CITY-SMSA-NUM PIC X(3).
15 XSITE-SOIL-SITE-NUM PIC X(4).
15 XSITE-SOIL-CROPLAND PIC X.
15 XSITE-SOIL-URB-SUB PIC X.
15 XSITE-SOIL-CROP-REG PIC X.
15 XSITE-CITY-SMSA-NAME PIC X(20).
15 XSITE-SOIL-AUG-TEMP PIC X(3).
15 XSITE-SOIL-AUG-RAIN PIC X(3).
15 XSITE-SOIL-PH PIC X(3).
15 XSITE-SOIL-SAND PIC X(3).
15 XSITE-SOIL-SILT PIC X(3).
15 XSITE-SOIL-CLAY PIC X(3).
15 XSITE-SOIL-ORGANIC PIC X(3).
15 XSITE-SOIL-TYPE PIC X.
15 XSITE-SOIL-FILLER PIC X(22).
10 WATER-SITE-DATA REDEFINES SOIL-SITE-DATA.
15 XSITE-WAT-SOURCE PIC X.
15 XSITE-WAT-STATE PIC XX.
15 XSITE-WAT-SITE-NUM PIC X(8).
15 XSITE-WAT-SITE-NAME PIC X(20).
15 XSITE-WAT-LATITUDE PIC X(7).
15 XSITE-WAT-LONGITUDE PIC X(8).
15 XSITE-WAT-FILLER PIC X(31).
V-5
-------
10 AIR-SITE-DATA REDEFINES WATER-SITE-DATA
15 XSITE-AIR-SOURCE PIC X.
15 XSITE-AIR-STATE PIC XX.
15 XSITE-AIR-COUNTY-NUM PIC X(3).
15 XSITE-AIR-SITE-NUM PIC XX.
15 XSITE-AIR-SITE-NAME PIC X(20).
15 XSITE-AIR-COUNTY-NAME PIC X(20).
15 XSITE-AIR-GRND-HT PIC X(3).
15 XSITE-AIR-AREA-TYPE PIC X.
15 XSITE-AIR-USE-TYPE PIC X.
15 XSITE-AIR-SAMP-ELEV PIC X(3).
15 XSITE-AIR-WIND-DIR PIC X(3).
15 XSITE-AIR-FLD-DIST PIC X(4).
15 XSITE-AIR-PLT-DIST PIC X(4).
15 XSITE-AIR-STG-DIST PIC X(4).
15 XSITE-AIR-FILLER PIC X(6).
10 EST-SITE-DATA REDEFINES AIR-SITE-DATA.
15 XSITE-EST-SOURCE PIC X.
15 XSITE-EST-STATE PIC XX.
15 XSITE-EST-STATION PIC X(12).
15 XSITE-EST-STATION-NAME PIC X(20).
15 XSITE-EST-FILLER PIC X(42).
10 HUM-SITE-DATA REDEFINES EST-SITE-DATA.
15 XSITE-HUM-SOURCE PIC X.
15 XSITE-HUM-STATE-NUM PIC XX.
V-6
-------
15 XSITE-HUM-SITE-NUM PIC X(3).
15 XSITE-HUM-SITE-NAME PIC X(20).
15 XSITE-HUM-SITE-CITY PIC X(20).
15 XSITE-HUM-FILLER PIC X(31).
05 RESIDUE-CODE-UPDATE REDEFINES SITE-UPDATE-DATA.
10 R-SHAUGHNESSY-CODE PIC X(6).
10 R-RESIDUE-CLASS PIC XX.
10 R-RESIDUE-NAME PIC X(18).
10 R-HUMANS-WARNING PIC X(7).
10 R-SOILS-WARNING PIC X(7).
10 R-WATER-WARNING PIC X(7).
10 R-AIR-WARNING PIC X(7).
10 R-EST-WARNING PIC X(7).
10' R-FILLER PIC X (17).
05 APPLICATION-DATA REDEFINES RESIDUE-CODE-UPDATE.
10 P-LAB-NUMBER PIC X(4).
10 P-REC-ACC-NUM PIC X(6).
10 P-DATE-REC-LAB PIC X(6).
10 P-FILLER-2 PIC XX.
10 P-STATE-NUM PIC XX.
10 P-COUNTY-NUM PIC X(3).
10 P-SITE-NUM PIC X(4).
10 P-CROP-CYCLE PIC X.
10 P-DATE-REC-COMP PIC X(6).
10 P-CROP-CODE-2 PIC X(3).
10 P-CROP-ACRES-2 PIC X(2).
V-7
-------
10 P-CROP-CODE-2 PIC X(3).
10 P-CROP-ACRES-2 PIC X(2).
10 P-CROP-CODE-3 PIC X(3).
10 P-CROP-ACRES-3 PIC X(2).
10 P-IRRIGATION PIC X(4).
10 P-PEST-USED-IND PIC X.
10 P-REC-INIT PIC X(4).
10 P-FILLER-2 PIC X(4).
10 P-CODE-FOR-PEST-USED PIC X(6).
10 P-CROP-LETTER PIC X.
10 P-USE-CODE PIC X.
10 P-FORMULATION-CODE PIC X.
10 P-LBS/ACRE PIC X(6).
10 P-APP-METH PIC X.
05 CODE-DATA REDEFINES APPLICATION-DATA.
10 C-TYPE PIC XX.
10 C-MODE PIC X.
10 C-FILLER1 PIC XX.
10 C-CODE PIC XXX.
10 C-NAME PIC X(20)
10 C-FILLER2 PIC X(50).
05 STATE-DATA REDEFINES CODE-DATA.
10 STATE-FIPS-NUMBER PIC XX.
10 STATE-EPA-REGION PIC XX.
10 STATE-CENSUS-REG PIC XX.
10 STATE-ABB . PIC XX.
10 STATE-NAME PIC X(20)
10 STATE-CENSUS DIV PIC XX.
10 STATE-FILLER PIC X(48)
V-8
-------
FD SOIL-SITE-FILE
01 SOIL-SITE-RCD
05 SITE-NBR
05 LOCATION CODE
05 SITE-CROPPING-REGION
05 RAINFALL
05 TEMP
05 PH
05 PCT-ORG
05 PCT-SAND
05 PCT-SILT
05 PCT-CLAY
05 LAND-USE-IND
05 CROPLAND-CODE
05 COUNTY-NAME
PIC 9(4).
PIC 9(3).
PIC X.
PIC 9(3)V9.
PIC 9(3)V9.
PIC 9(2)V9.
PIC 9(2)V9.
PIC 9(2)V9.
PIC 9(2)V9.
PIC 9(2)V9.
PIC 9(2)V9.
PIC X.
PIC X(20).
V-9
-------
FD WATER-SITE FILE
01 WATER-SITE
05 SITE-NBR PIC X(8).
05 SITE-NAME PIC X(20).
05 SITE-LATITUDE PIC 9(7).
05 SITE-LONGITUDE PIC 9(7).
05 LOCATION-CODE PIC 9(3).
05 LOCATION-NAME PIC X(20).
V-10
-------
FD STATE FILE
01 EPA-STATE-RCD
05 EPA-REG PIC 99.
05 EPA-STATE-NR PIC 99.
05'EPA-CENSUS-REG PIC XX.
05 FIPS-STATE-ABBR PIC XX.
05 FIPS-STATE-NO PIC 99.
05 STATE-NAME PIC X(20),
V-ll
-------
FD RESIDUE FILE
01 RESIDUE-CODE-RCD
05 RESIDUE-CODE
05 RESIDUE-NAME
05 RESIDUE-CLASS
05 HUMANS-WRNG-LEVEL
05 SOILS-WRNG-LEVEL
05 ESTUARINE-WRNG-LEVEL
05 AIR-WRNG-LEVEL
05 WATER-WRNG-LEVEL
PIC 99X999.
PIC X(20).
PIC 99.
PIC 9(4)V9(3).
PIC 9(4)V9(3).
PIC 9(4)V9(3).
PIC 9(4)V9(3).
PIC 9(4)V9(3).
V-12
-------
FD HOSP-CODES
01 HOSP-REC.
05 HOSP
05 HOSP-NAME
05 FILLER
05 HOSP-LOCATION
05 HOSP-EPA-REG
05 HOSP-CENSUS-REG
05 HOSP-FIPS-ST-ABB
05 HOSP-FIPS-ST-NO
05 HOSP-FIPS-STATE-NAME
PIC 9C3).
PIC X(20).
PIC XC30).
PIC X(18).
PIC 99.
PIC XX.
PIC XX.
PIC XX.
PIC XC20).
V-13
-------
FD CODE-FILE
01 INPUT-CODE-RCD.
05 TYPE CODE PIC XX.
05 CODE-NBR PIC 9(6).
05 CODE-NAME PIC X(20).
V-14
-------
DATA INPUT EDITIN3 SPECIFICATIONS
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
All
All
Positions
1
2
Data Element Name
Input Type
Update Type
Update
Type
A
R
R
c
R
R
D
R
R
Acceptance Criteria
Equal to A,C,E,H,M,P,R,S,T,
w,x, p
Equal to p, A, C, D
LEGEND
Update Type: A or # - ADD
C - Change
D - Delete
R-The data in the field
must be edited.
O-The edit is to be perfor
only if data is present
JJ-The field must be blank.
Issue a warning message
but do not reject.
Error Type: R - Record to be
rejected.
W - Warning only.
Error
Type
R
R
ied
Error
Message
Invalid Input Type
Invalid Update Type
(Jl
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
s
Positions
52-54
55-56
57-62
63-64
65-70
71
72-78
72
80
Data Element Name
PAW-PCT-ORGANIC
PAW-SOIL-FILLER
PAW- ANAL- DATE
PAW-ANAL-METH
PAW- RES IDUE-CODE
PAW-TRACE- IND
PAW-RESIDUE-AMOUNT
PAW-UNITS
PAW- CONF-CODE
Update
Type
A
O
Y>
R
V
R
Y>
R
-R
V
c
O
y>
O
V
0
V
0
o
n
D
P
y>
V
V
0
V
V
16
V
Acceptance Criteria
a) If present, numeric and
greater than 0
b)If a, PAW-PCT-ORGANIC < :300
Equal to blank
Valid and less than system date
(MMDDYY)
Blank
a) All numeric except 3rd chara-
cter can be "S"
b) Found in database residue
record
Blank
Numeric
Equal to M,B,K, or T
Blank
Error
Type
R
W
W
R
W
R
R
W
R
R
W
Error
Message
% Organic not Valid
% Organic may be Invalid
Data found in columns 55-56
ignored
Analysis date not Valid.
Data found in analysis method
field - ignored
Residue Code not Numeric
Residue Record not found
Date found in trace field-
ignored
Residue Amount not Numeric
Units are Invalid
Data found in confidence code-
Ignored
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
s
Positions
3
4-5
6-11
12-17
18-19
20-22
23-32
33-38
39
40-42
43-45
46-48
49-51
43-51
Data Element Name
PAW-SOURCE
PAW- LAB-MUM
PAW-SAMP-ACC-NUM
PAW-SAMP-DATE
PAW-STATE-NUM
PAW-COUNTY- NUM
PAW-SITE-NUM
PAW-SAMP-TYPE
PAW-CROP-CYCLE
PAW-PH
PAW- PCT- SAND
PAW-PCT-SILT
PAW-PCT-CLAY
PAW-PCT-SAND
PAW-PCT-SILT
PAW-PCT-CLAY
Update
Tvpe
A
R
R
R
R
R
R
R
R
0
O
O
O
O
O
c
R
O
R
O
R
R
R
O
0
O
O
O
O
O
D
R
O
R
V
R
R
R
P
P
V
V
V
V
V
Acceptance Criteria
Equal to A or U
Numeric and not equal zero
Numeric and greater than zero
Valid and less than system date
Numeric and greater than 0
Numeric and greater than 0
Numeric and greater than 0
Numeric and greater than 0
If Source = U (Urban) must be
blank
else must equal 1 , 2 or 3
a) If present, numeric and
greater than 0
b) If a, 2.0 ^ pH £ 11.0
If present, numeric and greater
than 0
If present, numeric and greater
than 0
a) If present, numeric and
greater than zero
a) If all are present, sum
must equal 100%
a) If- at least one but .not all
Error
Type
R
R
R
R
R
R
R
R
W
R
R
W
R
R
R
R
R
Error
Message
Invalid Source of Soils Update
Invalid Lab Number
Sample Accession Number Invalid
Sample Date not valid
State Code not Numeric
County Code not Numeric
Site Number not Numeric
Sample Type Invalid
Data in crop cycle field -
ignored
Crop Cycle must be a 1,2, or 3
pH not Numeric
pH may be in error
% Sand not Numeric
% Silt not Numeric
% Clay not Numeric
Soil texture does not equal
100%
Soil data is missinq
are present.
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
w
Positions
4-5
3
6-11
12-17
18-19
20-22
23-32
33-38
39
40-43
44-56
57-62
63-64
65-70
7,1
72-78
Data Element Name
PAW- LAB- HUM
PAW- SOURCE
PAW-SAMP-ACC-NUM
PAW- SAMP- DATE
PAW-STATE-NUM
PAW-COUNTY-NUM
PAW-SITE-NUM
PAW- SAMP-TYPE
PAW-CROP-CYCLE
PAW-TIME-OF-SAMP
PAW-WATER-FI LTER
PAW-ANAL-DATE
PAW-ANAL-METH
PAW- RES IDUE-CODE
PAW-TRACE- IND
PAW-RESIDUE-AMOUNT
Update
Type
A
R
"
.
R
R
V
R
R
V
R
V
R
V
V
R
c
o
p
R
0
R
V
R
O
V
O
V
0
V
V
0
D
V
V
R
V
R
V
R
V
V
V
V
V
V
v>
V
Acceptance Criteria
Numeric and not equal 0
Blank
Numeric and greater than 0
Valid and less than System Date
Numeric and greater than 0
Blank
Numeric and greater than 0
Numeric and greater than 0
Blank
Numeric and < 2400
Blank
Valid and less than system date
Blank
a) Numeric
b) Found in Residue Record
Blank
Numeric
Error
Type
R
W
R
R
R
W
R
R
W
R
W
R
W
R
R
W
R
Error
Message
Invalid Lab Number
Source not equal blank-ignored
Sample Accession Number Invalid
Sample Date not Valid
State Code not Numeric
Data in County field-ignored
Site Number not Numeric
Sample Type Invalid
Data in Crop Cycle field-
ignored
Time of Sample Invalid
Data found in columns 44 to 56-
ignored
Analysis Date Invalid
Data found in analysis method
field ignored.
Residue Code not Numeric
Residue Record not Found
Data found in tr^ce field -
ignored
Residue Amount not Numeric
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
w
Positions
79
80
Data Element Name
1 Update
| Type
[A
PAW-UNITS R
PAW-CONF-CODE p4
c
o
p
D
P
V
Acceptance Criteria
Equal to B
Blank
Error
Type
R
W
Error
Message
Invalid Units
Data found in Confidence Code-
ignored
M
10
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
E
Positions
3
4-5
6-11
12-17
18-19
20-22
23-32
33-38
39
40-56
57-62
63-64
65-70
71
72-78
79
80
Data Element Name
PAW-SOURCE
PAW-LAB-NUMBER
PAW- SAMP- ACC- NUM
PAW-SAMP-DATE
PAW-STATE-NUM
PAW- REG ION
PAW-SITE-STATION
PAW-SAMP-TYPW
PAW-CROP-CYCLE
PAW-EST-FILLER
PAW-ANAL-DATE
PAW- ANAL- METH
PAW-RESIDUE-CODE
PAW-TRACE- IND
PAW- RESI DUE- AMOUNT
PAW-UNITS
PAW-CONF-CODE
Update
Type
A
v>
R
R
R
R
R
R
R
Y>
V
R
P
R
Y>
R
R
R
c
V
0
R
0
R
R
R
O
J*
V
O
V
O
p
0
O
O
D
V
V
R
P
R
R
R
V
V
V
V
V
O
V
V
V
V
Acceptance Criteria
Blank
Numeric and not equal 0
Numeric and greater than 0
Valid and less than system
Numeric
Alphabetic and not equal Y>
Alphanumeric and not equal p
Numeric and greater than 0
Blank
Blank
Valid and less than system Date
Blank
a) Numeric
b) Found in residue record
Blank
Numeric
Equal to B
Blank
Error
Type
w
R
R
R
R
R
R
R
W
W
R
W
R
R
W
R
R
W
Error
Message
Source not equal blank-ignored
Invalid lab Number
Sample accession Number Invalid
Sample Date not Valid
State Code not Numeric
Region Code not Alphabetic
Site not Valid
Sample Type not Valid
Data in Crop Cycle field-
ignored
Data found in columns 40 to 56-
ignored
Analysis Date Invalid
Data found in Analysis Method
field - ignored
Residue Code not Numeric
Residue Record not found
Data found in trace field -
ignored
Residue Amount not Numeric
Units are Invalid
Data found in Confidence Code -
ignored .
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
A
Positions
3
4-5
6-11
12-17
18-19
20-22
23-32
33-38
39
40-43
44
45-48
49-52
53-56
57-62
63-64
Data Element Name
PAW-SOURCE
PAW-LAB-NUM
PAW-SAMP- ACC-NUMB
PAW-SAMP-DATE
PAW-STATE-NUM
PAW-COUNTY-NUM
PAW-SITE-NUM
PAW-SAMP-TYPE
PAW-CROP-CYCLE
PAW-TOT-SAMP-TIME
PAW-PRECIP-IND
PAW-PRECIP- AMOUNT
PAW-AIR-VOL-SAMP
PAW-AIR-FILLER
PAW- ANAL-DATE
PAW-ANAL-METH
Update
Type
A
V
R
R
R
R
R
R
R
n
R
R
R
R
P
R
R
c
V
0
R
O
R
R
R
0
*
0
O
O
O
P
O
O
D
P
P
R
P
R
R
R
P
»
P
P
P
P
P
P
14
Acceptance Criteria
Blank
Numeric and not equal 0
Numeric and greater than 0
Valid and less than System Date
Numeric and greater than 0
Numeric and greater than 0
Numeric and greater than 0
Numeric and greater than 0
Blank
Numeric and greater than 0
Equal to 1 , 2 , or 3
If PAW-PRECIP-IND = 1, numeric
If PAW-PRECIP-IND = 2 or 3,
blank
Numeric and greater than 0
Blank
Valid and less than System Date
Numeric and greater than 0
Error
Type
w
R
R
R
R
R
R
R
W
R
R
R
R
R
W
R
R
Error
Message
Source not equal blank- ignored
Invalid Lab Number
Sample Accession Number Invalid
Sample Date not Valid
State Code not Numeric
County Code not Numeric
Site Number not Numeric
Sample Type Invalid
Data found in Crop cycle -
ignored
Total sampling time not Numeric
Precip Indicator not Valid
Precip is yes, but amount not
numeric
Precip is no, but data found in
amount field.
Air Volume sampled not numeric
Data found in Cols 53-56 -
ignored
Analysis Date not valid
Analysis Method not Valid
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
A
Positions
65-70
71
72-78
79
80
Data Element Name
PAW- RES I DUE-CODE
PAW-TRACE- I ND
PAW- RESIDUE-AMOUNT
PAW-UNITS
PAW-CONF-CODE
Update
Type
A
R
R
R
R
R
c
0
o
o
o
o
D
0
p
V
1ft
V
Acceptance Criteria
a) Numeric and greater than tf
b) Found in Residue Record
Equal to < or )4
Numeric
Equal to B
Equal to alphabetic
Error
Type
R
R
R
R
R
R
Error
Message
Residue Code not Numeric
Residue Record not found
Trace Indicator Invalid
Residue Amount not Numeric
Units are Invalid
Invalid Confidence Code
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
M
Positions
3
4-5
6-11
12-17
18-19
20-22
23-32
33-36
37-40
41-42
43-44
45-46
46-47
48-50
52-54
55-80
Data Element Name
PAW-SOURCE
PAW-LAB-NUM
PAW-SAMP-ACC-NUM
PAW- SAMP- DATE
PAW- STATE- HUM
PAW-COUNTY-NUM
PAW-SITE-NUM
PAW-MIN-TEMP
PAW-MAX-TEMP
PAW-BEG-WIND-VEL
PAW-END-WIND-VEL
PAW-BEG-RH
PAW-END- RH
Paw- BEG -W IND- DI R
PAW-END-WIND-DIR
PAW-MET-FILLER
Upddte
Type
A
V
R
R
R
R
R
R
R
R
R
R
R
R
R
R
V
c.
V
o
R
O
R
R
R
0
O
0
O
O
O
0
O
V
n
V
V
R
V
R
R
R
V
V
V
V
16
V
16
P
16
Acceptance Criteria
Blank
Numeric and not equal 0
Numeric and g reader than 0
Valid and less than System
Date
Numeric and greater than 0
Numeric and greater than 0
Numeric and greater than 0
Signed Numeric
Signed Numeric
Numeric
Numeric
Numeric
Numeric
Numeric and < 360
Numeric and < 360
Blank
Error
Type
w
R
R
R
R
R
R
R
R
R
R
R
R
R
R
W
Error
Message
Source not equal blank- ignored
Invalid Lab Number
Sample Accession Number Invalid
Sample date not Valid
State Code not Numeric
County Code not Numeric
Site Number not Numeric
Minimum Temperature not a
signed Numeric
Maximum Temperature not a
signed Numeric
Begin Wind Velocity not Numeric
End Wind Velocity not Numeric
Begin RH not Numeric
End RH not Numeric
Begin Wind Dir Not Valid
End Wind Dir Not Valid
Data found in columns 55-80 -
ignored
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or $
Positions
3-5
6-14
15
16-21
22-23
24-25
80
Data Element Name
HUM-HOSP-NUM
HUM-PAT-ID
HUM-PAT-ID-SOF
HUM-COLL-DATE
HUM-TISSUE-TYPE
HUM-FORM-NUM
HUM-ORIG-CODE
Update
Type
A
R
R
R
R
R
R
R
c
R
R
R
0
R
R
0
D
R
R
R
V
R
R
0
Acceptance Criteria
Numeric and greater than 0
Right justified. No Imbedded
spaces. Alphabetic (A-Z)
and Numeric (0-9) only,
leading spaces acceptable
Alphabetic or blank
Valid Date and less than
system Date
01, 02, or 04
Al or Bl
JiJ or H or M
Error
Type
R
R
R
R
R
R
R
Error
Message
Hospital Number Invalid
Invalid Patient ID
Invalid Patient ID Suffix
Invalid Collection Date
Invalid Tissue Type
Invalid Form Number
Invalid Origin Code
<
10
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or Jzi
Form Al
Positions
26-31
32(-33
34
35
36-38
39-41
42
43-45
46
47-51
52-56
57-61
62-66
67-71
71-76
78
Data Element Name
HUM- PAT-BIRTH
HUM- PAT-UNIT
HUM- PAT-SEX
HUM-PAT-RACE
HUM- PAT-HEIGHT
HUM-PAT-WEIGHT
HUM-P-S-IND
HUM-OCC-CODE
HUM-LNG-STAY-IND
HUM-DIAG-CODE(X)
HUM-DES-CODE
Update
Type
A
R
R
R
R
R
R
R
R
R
O
R
C
O
O
O
O
O
O
0
O
0
O
O
D
Y>
V
V
V
V
V
16
V
V
16
V
Acceptance Criteria
Valid Date
fYear y 00
Must be alphabetic and no
spaces
Must be 1, 2
Must be between 0 and 6
If Race 2
Numeric
Numeric
1 or 2
Must match Table
1 or 2
a) 1st char: 'E1,^, or numeric
b) 2nd char: 'E'.'Y'. 'Jrf'bor
numeric
c) 3rd char: 'A'.'R1, Jrf or
numeric
d) 4th char: numeric
e) 5th char: p or numeric
D or S
Error
Type
R
W
R
R
R
W
R
R
R
R
R
R
R
Error
Message
Invalid Birth Date
Manual check - Year of Birth =
00
Initials of Patient not Valid
Invalid Sex
Invalid Race
'Manual Check - Race Code 2'
Invalid Height
Invalid Weight
Invalid Post-Surg Indicator
Invalid Occupation Code
Invalid Length of Stay Indica-
tor
Occupation Code Invalid
Design Code Invalid
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or Y>
Form Bl
Positions
26-27
28
29-30
31-32
44-49
50-51
61
62
Data Element Name
HUM-GC-MAKE-MOD
HUM-DETECTOR
HUM-COL- 1-CODE
HUM-COL-2-CODE
HUM- ANAL-DATE
HUM-LAB
HUM- PPM
HUM-PPB
Updam
Type
A
R
R
R
R
R
*
R
R
c
o
O
0
O
O
o
o
o
D
V
V
V
V
V
%
V
V
Acceptance Criteria
VI
1-6
01-20
01-20
Valid and less than system date
Numeric and less than 11
Equal to V or X
Equal to & or X
Error
Type
R
R
R
R
R
R
R
R
Error
Message
Invalid GC Make
Invalid Detector
Invalid Column 1 Code
Invalid Column 2 Code
Invalid Analysis date
Invalid Lab Number
PPM Invalid
PPB Invalid
I
ro
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or 16
Form =
Bl
Positions
IF TISSUE
33-37
38-41
42-43
Data Element Name
TYPE =01
WET-WEIGHT
AMOUNT 2
HUM-ANAL-METH
Update
Type
A
R
Y>
R
C
0
tf
0
D
V
y>
0
Acceptance Criteria
Numeric and greater than 0
blank
Equal to 01,02,03 or 04
Error
Type
R
W
R
Error
Message
Invalid Tissue Type
Amount 2 - Invalid - Ignored
Invalid Analysis Method
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or tf
Form =
Bl
Positions
IF TISSUE
52-53
55-60
54
64
Data Element Name
TYPE =01, or 02
HUM-RES-CODE
HUM-RES-AMOUNT
HUM-TRACE- IND
HUM-OVER- IND
Updato
Type
A
R
R
R
R
c
O
O
0
O
D
O
tf
y>
y>
Acceptance Criteria
a) Valid Codes are 37-42,
44-52, 85, 86, 87, AR, AE
b) found in Residue Record in
data base
Numeric
Equal to < or jrf
Equal to Y or 0, 1, 2
Error
Type
R
R
R
R
R
Error
Message
Invalid Residue Code
Residue Code not found
Residue Amount not Numeric
Invalid Trace Indicator
Invalid Override Indicator
N)
CO
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or M
Form =
Bl
Positions
IF TISSUE
63
52-53
38-41
Data Element Name
TYPE = 04 AND ANALYSIS
HUM-CONF-CODE
HUM-RES-CODE
HUM-AMOUNT 2
Update
Type
A
R
R
R
C
iBl
O
O
O
•
D
HC]
V
V
V
Acceptance Criteria
3 =21 or 23 (ALKYL PHOSPHATE)
Equal to A or Z
Equal to 88-93
Numeric and Greater than 0
Error
Type
R
R
R
Error
Message
Invalid Confidence Code
Invalid Residue Code for
Tissue Type , and Analysis
Method
Amount 2 must be greater
than zero
I
10
to
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or p
Form =
Bl
Positions
IF TISSUE
METHOD =
63
52-53
38-41
Data Element Name
TYPE = 04 AND ANALYSIS
24 (Malathion Method)
HUM-CONF-CODE
HUM-RES-CODE
HUM-AMOUNT 2
Update
Type
A
R
R
y>
c
0
o
V
D
V
V
V
Acceptance Criteria
Equal to A,B, or Y
Equal to AS, AT
Blank
Error
Type
R
R
W
Error
Message
Invalid Confidence Code
Invalid Residue Code for
Tissue Type and Analysis
Method
Amount 2 must be blank
I
GJ
o
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or )&
Form =
Bl
Positions
IF TISSUE
METHOD =
63
Data Element Name
TYPE = 04 AND (ANALYS1
22 or 25 (Multiphenol c
HUM-CONF-CODE
Update
Type
A
S
r <
R
C
:ai
o
o
be
tf
Acceptance Criteria
mate)
A,B,C,Y, or Z
Error
Type
R
Error
Message
Invalid Confidence Code
<
I
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or V
Form =
Bl
Positions
IF TISSUE
METHOD =
52-53
38-41
•
Data Element Name
TYPE = 04 AND ANALYSIS
22 (Multiphenol)
HUM-RES-CODE
HUM- AMOUNT- 2
Update
Type
A
R
R
C
0
0
D
Y>
V
Acceptance Criteria
Equal to 53,58,59,94,95,
96, AV
Numeric and Greater than 0
Error
Type
R
R
Error
Message
Invalid Residue Code for
Tissue Type and Analysis
method
Amount 2 must be greater
than zero
U)
to
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or V
Form =
Bl
Positions
IF TISSUE
52=53
38-41
Data Element Name
TYPE = 04 AND ANALYSIS
HUM- RES-CODE
HUM-AMOUNT 2
Update
Type
A
ME
R
V>
c
TH
O
V
D
>D'
V
V
Acceptance Criteria
25 (Carbamate)
Equal to 60, AX, AY, AZ,
V
Error
Type
R
W
Error
Messaye
Invalid Residues Code for
Tissue Type and Analysis
method
Amount 2 must be blank -
Ignored
<
I
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or V
Form =
Bl
Positions
IF TISSUE
33-37
54
55-60
52-63
55-60
Data Element Name
TYPE = 04
VOLUME
HUM-TRACE-IND
HUM- RES- AMOUNT
HUM- RES- CODE
HUM- RES-AMOUNT
Update
Type
A
R
R
R
R
R
C
O
O
O
0
0
D
V
V
*
y>
V
Acceptance Criteria
Numeric and greater than
zero
Equal to < or #
Numeric
Found in Data base
IF OVERRIDE NOT = 0,1
Less than humans warning
level and
Error
Type
R
R
R
R
R
Error
Message
Volume not greater than zero
Invalid Trace Indicator
Residue Amount not Numeric.
Residue Code not found in
Data base
1 Residue Amount Exceeds
Limit for Residue Code . '
Set override = 2
U)
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or JzJ
Form =
Bl
Positions
55-60
55-60
63
63
63
A C D
Data Element Name DUE
DAL
IF RESIDUE CODE =40 AND TRAC
HUM-RES-AMOUNT R O tf
IF RESIDUE CODE = 37 ,42, 47, 5C
HUM-RES-AMOUNT R 0 $
IF RESIDUE CODE jf 85 AND Tl
HUM-CONF-CODE R O JJ
IF RESIDUE CODE = 85
HUM-CONF-CODE R O )# .
IF RESIDUE CODE f 85 AND TISS
HUM-CONF-CODE R O Jj
Acceptance Criteria
E INDICATOR = f AND OVERRIDE
Less than Humans Warning
Level in Residue Record of
of data base
,51,AE,87,49, and OVERRIDE INf
Not equal 0
SSUE TYPE = 01
Alphabetic and less than "U"
and not = "O"
V,W,Y,Z,M
LIE TYPE = 02
Alphabetic and (less than T
or equal to Y or Z)
Error
Type
INDICATOF
W
ICATOR7* (
W
R
R
R
Error
Message
4 0,1
Residue amount exceeds limit
for residue code. Set
override = 2
,1
Residue Amount is greater
than zero. Set Override = 2
Confidence Level Invalid
• Confidence Code Invalid
Confidence Code Invalid
I
Ul
en
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
H or V
Form =
Bl
Positions
55-60
A C D
Data Element Name D H E
DAL
IF RESIDUE CODE =85 AND CON
1
HUM-RES-AMOUNT R Q $
Acceptance Criteria
?IDENCE = M
a) Equal to zero
b) 0 < amount < 100
c) 100 < amount < 300
d) Amount > 300
Error
Type
H
W
W
W
Error
Message
'TLC Detected on PCB, PPM
Changed to V. • Set PPM
to V.
'TLC Detected on PCB, PPM
Changed to W. ' Set PPM
to W.
'TLC Detected on PCB, PPM
Changed to Y . ' Set PPM
to Y.
'TLC Detected on PCB, PPM
Changed to Z. ' Set PPM
to Z.
I
U)
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
X
Positions
3
Data Element Name
XSITE-MODE
Update
Type
A
R
c
R
D
R
Acceptance Criteria
Equal to S,W,E,A,H
Error
Type
R
Error
Message
Invalid Transport Mode for
Site Update
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
X
Trans-
port =
S
Positions
4
5-6
7-9
10-13
14
15
16
Data Element Name
XSITE-SOURCE
XSITE-STATE-NUM
XSITE-CITY-SMSA-NUM
XSITE-SOIL-SITE-NUM
XSITE-SOIL-CROPLAND
XSITE-SOIL-URB-SUB
XSITE-SOIL-CROP-REG
Update
Typa
A
R
R
R
R
R
R
R
c
R
R
R
R
0
O
O
D
R
R
R
R
P
O
O
Acceptance Criteria
Equal to A or U
Numeric and greater than 0
Numeric and greater than 0
Numeric and greater than 0
Equal to 0 or 1
Equal to U,S, or p
Numeric
Error
Type
R
R
R
R
R
R
R
Error
Message
Invalid Source
Invalid State Number
County/SMSA not Numeric
Invalid Site Number
Cropland Code not Numeric
SUBURB/URBAN Code Invalid
Cropping Region Invalid
U)
oo
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
X
Transpon
•*S
Positions
17-36
37-39
40-42
43-45
46-48
49-51
52-54
55-57
58
43-45
46-54
55-57
Data Element Name
XSITE-CITY-SMSA-NAME
XSITE-SOIL-AVG-TEMP
XSITE-SOIL-AUG-RAIN
XSITE-SOIL-PH
XSITE-SOIL-SAND
XSITE-SOIL-SILT
XSITE-SOIL-CLAY
XSITE-SOIL-ORGANIC
XSITE-SOIL-TYPE
XSITE-SOIL-pH
XSITE-SOIL-SAND, SILT
CLAY
XSITE-SOIL-ORGANIC
Update
Type
A
R
0
o
o
0
o
0
o
o
o
0
o
c
o
0
o
o
0
o
0
o
o
o
o
o
D
p
V
V
V
V
V
V
P
J*
V
V
V
Acceptance Criteria
Alphanumeric not blank
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
1) If present, between 20
and 110
1) If present, sum = 1000
4=. 300
Error
Type
R
R
R
R
R
R
R
R
R
W
R
W
Error
Message
County/SMSA name not Valid
Temperature not Numeric
Average Rain not Numeric
pH not Numeric
PCT Sand not Numeric
PCT Silt not Numeric
PCT Clay not Numeric
PCT Organic not Numeric
Soil Type Invalid
pH may be invalid - warning
Soil Texture does not equal
1000
PCT Organic may be invalid
I
U)
VO
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
X
Trans-
port
W
Positions
4
5-6
7-14
15-34
35-41
42-48
Data Element Name
XSITE-SOURCE
XSITE-STATE-NUM
XS ITE-WAT-S ITE-NUM
XSITE-WAT-SITE-NAME
XSITE-WAT- LATITUDE
XSITE-WAT- LONGITUDE
Update
Type
A
V
R
R
R
R
R
c
V
R
R
O
O
O
D
V
R
R
V
V
V
Acceptance Criteria
Blank
Numeric and greater than 0
Numeric and greater than 0
Alphanumeric and not )rf
Numeric
Numeric
Error
Type
w
R
R
R
R
R
Error
Message
Data found in source field -
ignored
Invalid State Number
Invalid Site Number
Invalid Site Name
Site Latitude not Numeric
Site Longitude not Numeric
I
*>
O
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
X
Trans-
port
A
Positions
4
5-6
7-9
10-11
12-31
32-51
52-54
55
56
57-60
61-63
64-67
68-71
72-75
Data Element Name
XSITE-SOURCE
XSITE-STATE-NUM
XSITE-AIR-COUNTY-NUM
XSITE-AIR-SITE-NUM
XSITE-AIR-SITE-NAME
XSITE-AIR-COUNTY-NAME
XSITE-AIR-GRND-HT
XSITE-AIR- AREA-TYPE
XSITE-AIR-USE-TYPE
XS ITE-AI R- S AMP-ELEV
XSITE-AIR-WIND-DIR
XSITE-AIR-FLD-DIST
XSITE-AIR- PLT-DIST
XSITE-AIR-STG-DIST
Update
Type
A
Y>
R
R
R
R
R
R
R
R
R
R
R
R
R
c
V
R
R
R
O
O
0
O
O
O
O
O
O
O
D
V
R
R
R
V
V
V
V
V
V
V
V
V
K
Acceptance Criteria
Must be Blank
Numeric and greater than 0
Numeric and greater than 0
Numeric and greater than 0
Alphanumeric and not blank
Alphanumeric and not blank
Numeric and not 0
Numeric and between 1 and 4
inclusive
Numeric and between 1 and 6
inclusive
Numeric and greater than 0
Numeric and less than 360
Numeric
Numeric
Numeric
Error
Type
w
R
R
R
R
R
R
R
R
R
R
R
R
R
Error
Message
Data found in Source field
ignored
Invalid State Number
County not Numeric
Invalid Site Number
Invalid Site Name
Invalid County Name
Ground Height not Numeric
Area Type Invalid
Use Type Invalid
Sample Elevation not Numeric
Prevailing Wind Direction In-
valid
Field Distance not Numeric
Plant Distance not Numeric
Storage Distance not Numeric
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
X
Trans-
port =
E
Positions
4
5-6
7-18
19-28
Data Element Name
X SITE-SOURCE
XSITE-STATE-NUM
XSITE-EST-STATION
XSITE-EST-SITE-NAME
Update
Type
A
V
R
R
R
c
V
R
R
Q
D
J*
R
R
V
Acceptance Criteria
Must be blank
Numeric and greater than 0
Alphanumeric and not blank
Alphanumeric and not blank
Error
Type
w
R
R
R
Error
Message
Data found in Source field -
ignored
Invalid State Number
Invalid Station Number
Invalid Site Name
<
to
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
X
Trans-
port
H
Positions
4
5-6
7-9
10-29
30-49
Data Element Name
XSITE-SOURCE
XSITE-STATE-NUM
XSITE-HUM-SITE-NUM
XSITE-HUM-SITE-NAME
XSITE- HUM-SITE-CITY
Update
Type
A
R
R
R
R
R
c
R
R
R
O
0
D
R
R
R
P
P
Acceptance Criteria
Equal to p or H
Numeric and greater than 0
Numeric and greater than 0
Alphanumeric and not equal Y>
Alphanumeric and not equal ]6
Error
Type
R
R
R
R
R
Error
Message
Invalid Source for Humans Site
Update
Invalid State Number
Invalid Site Number
Invalid Site Name
Invalid City Name
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
R
Positions
5-10
11-12
13-30
31-36
37-42
43-48
49-54
55-60
Data Element Name
R-SHAUGHNESSY-CODE
R- RESIDUE-CLASS
R- RESIDUE-NAME
R-HUMANS-WARNING
R- SOILS-WARNING
R-WATER-WARNING
R-AIR-WARNING
R- ESTUARI NE-WARN ING
Update
Type
A
R
R
R
R
R
R
R
R
c
R
R
O
O
O
0
O
O
D
R
R
1ft
V
V
V
V
V
Acceptance Criteria
Numeric except 3rd character
which can be "S"
Numeric
Alphanumeric and non Blank
Numeric
Numeric
Numeric
Numeric
Numeric
Error
Type
R
R
R
R
R
R
R
R
R
Error
Message
Update type Invalid
Invalid Shaughnessy Code
Invalid Residue Class
Invalid Residue Name
Human Warning not Numeric
Soils Warning not Numeric
Water Warning not Numeric
Air Warning not Numeric
Estuerine Warning not Numeric
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
p
Positions
3-6
7-12
13-18
19-20
21-22
23-25
26-29
30
31-36
37-39
40-41
42-44
45-46
47-49
50-51
52-55
56
Data Element Name
P- LAB-NUMBER
P-REC-ACC-NUM
P-DATE-REC-LAB
P-FILLER-1
P-STATE-NUM
P-COUNTY-NUM
P-S1TE-NUM
P-CROP-CYCLE
P-DATE-REC-COM
P-CROP-CODE-1
P-CROP-ACRES-1
P-CROP-CODE-2
P-CROP-ACRES-2
P-CROP-CODE-3
P-CROP-ACRES-3
P- IRRIGATION
P- PEST-USED- IND
Update
Type
A
R
R
R
V
R
R
R
R
R
R
R
O
0
O
O
R
R
c
R
R
O
V
R
R
R
R
R
0
0
0
0
0
0
0
0
D
p
V
V
V
R
R
R
R
V
0
V
O
V
0
V
V
V
Acceptance Criteria
Numeric
Numeric and greater than zero
Valid and less than system
date
Blank
Numeric
Numeric
Numeric
Equal to 1 , 2 , 3
Valid and less than system
date
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Equal to 1 or 2
Error
Type
R
R
R
W
R
R
R
R
R
R
R
R
R
R
R
R
R
Error
Message
Lab Number not Numeric
Record Accession not Valid
Invalid Date Received
Data found in Cols 19, 20
ignored
State Number not Numeric
County Code not Numeric
Site Code not Numeric
Crop Cycle Invalid
Date Completed Invalid
Crop Code 1 not Numeric
Crop Acres 1 not Numeric
Crop Code 2 not numeric
Crop Acres 2 not Numeric
Crop Code 3 not Numeric
Crop Acres 3 not Numeric
Irrigation not Numeric
Pesticide Used Indicator in-
valid
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
p
Positions
57-60
65-70
71
72
73
74-79
80
Data Element Name
P-REC-INIT
P-CODE-FOR-PES-USED
P-CROP-LETTER
P-USE-CODE
P-FORMULATION-CODE
P-LBS/ACRE
P-APP-METH
Update
Type
A
R
R
R
R
R
R
R
c
O
O
0
O
O
O
0
D
V
O
0
V
V
V
V
Acceptance Criteria
Alphanumeric
•a) Numeric
b) Found in data base residue
record
Equal to A, B, C,
1-6
1-9
Numeric
1-9
Error-
Type
R
R
R
R
R
R
R
R
Error
Message
Invalid Recorder Initials
Pesticides/Fertilizer not
Numeric
Invalid Pesticide/Fertilizer
Invalid Crop Letter
Use Code Invalid
Formulation Code Invalid
Application Amount Invalid
Application Method Invalid
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
c
Positions
3-4
8-10
11-36
37-80
5
Data Element Name
CODE-TYPE
CODE-NUMBER
CODE-TRANSLATION
CODE-FILLER
C-MODE
Update
Tvpe
A
R
R
R
V
O
C
R
R
R
Jzf
O
D
R
R
V
V
0
Acceptance Criteria
Equal to AA,AU,SF,SU,SA,ST,CR,
CR = Census Region
AA = Air - Area Code
AU = Air - Use Code
SF = Soil - Formulation
SA = Soil - Application
SU = Soil - Use
ST = Sample Type
CD = Census Division
Non blank
Non blank
Blank
If Code Type = ST, must be
equal to S,W,E,A,or H
Blank otherwise
Error
Type
CD\ R
R
R
W
R
W
Error
Message
Invalid Code Type
Invalid Code Number
Invalid Code Translation
Data found in Columns 37-80
ignored
Invalid Mode
Data Found in Mode field
ignored
-------
DATA INPUT EDITING SPECIFICATIONS
Input
Type
T
Positions
3-4
5-6
7-8
9-10
11-30
31-32
33-80
Data Element Name
STATE-FIPS-NUM
STATE-EPA-REG
STATE-CENS-REG
STATE-. ABB
STATE- NAME
STATE-CENSUS-DIVISION
STATE-FILLER
Update
Type
A
R
R
R
R
R
R
V
c
R
0
0
O
R
O
Y
D
R
Y
1*
Y
R
y>
v
Acceptance Criteria
Numeric, greater than 0, less
than 56
Numeric, greater than 0, less
than 11
Alphanumeric
Alphabetic
Alphabetic
Alphabetic
Blank
Error
Type
R
R
R
R
R
R
W
Error
Message
Invalid state Number
Invalid EPA Region
Invalid Census Region
Invalid State Abbreviation
Invalid State Name
Invalid Census Division
Data found in Cols 3 -80-
ignored
^
00
-------
DESIGN SPECIFICATIONS
-------
1
S s
£ 1
x 1
(7 C
t
UJ
X
CO
cc
0
5
2
1
i|!!!e
t
j
a
a
£
e
*9
U
C
£
V
It
0.
g
,
|
„
•z
t
J
u
C
u
g, a
19
i 3
I
V
1
z
6
t E
j 1
< o
i i
CoMVJFRSlotJ
Lilld
_| Bpjm i Bf se. .._
irJiTlhLiiA-noW^.,
eccetis
IJihSTEK. •
IP'V^I
• Hbnwlt u«<»u4 1.1.1
• HWofS LbnenJt i.*»
! • (/genii SOILS uenbid
.
uenbidft
LO
REpEftb 1-JiSTTltJ
! foe. ;
•niMJ:
MTU
TRWKXCTlrt
K0>
wm si
UE VTC
Of re
Bf
At TOiJ.
«toe
UP wr R rfo LI
i*
fies'pOOD t>
!-rtbo
. _Jf=o«_i
Rirsitioej 1
PfkNifie
, , rtiis
---In 6«si —
I !
1 U
! j I '
; Cn'i.irics,m«g«r
I: NOT tt FiViEfi IN I i
•oift«Rnw>?,l :>• :
tiiy>
in^ r
; CJDMTROL Fiioij! i I
I ' ! ' : I M
TJ/im
JN
^Kn
11
_lftS
i ourrtcm
V,
OutMl
D
wnn
""•i "if
-------
uPifi HIPO WORKSHEET
GX20-197CMJ U/M 025 '
Prlnnd in U.S.A.
Systsm/Progrim:
. Om:_
. P«gr..
Input
miuinfntK T*>rt) mfiar f/Ld
Pnem
Output
— /
ANQ LOAD
3._ Senenmr 4esfo*sa n /fo Mac.
J-r-
.UNLQ4& wm&*$e~, ..;._;*.
'/ CIO 3VSTTW FtL
/I ff^e-jg ATg t^_
&
/( rf+r-f.
/ \ 'tltJLAAti
«'•/-/•/////•/ A ///
PMS 2kvia*i.
-////-/-///-//v
///-/-///-//•/////-/
Extanctod Dwcripoon
Extmdid Doeription
' The numoer of shmts per pad may vary slightly
V-50
-------
?^T
HIPO WORKSHEET
GX20-197MU/M02S*
MnndlnU&A
(Migrant ID- t Q
M— fatiutTtStatJ Ann iMB/#
.^
. '
.. —
_';£-'
cooe
3 3T»/W
*«U/*AJ
HI
swr ouKT&t foe* .76 ae canueafo
fly amnr AMD sire
^:~r
Netn
1. CutLitlivxe UniiTY EXISTS
FOR JNiTMUZlUC T*F XTO BflSF.
Nt Irmit 'DiXCAH '•' ifiniOED.
UTIUTT WRlTffl 3lKECr«CCCS4
Itoex* IB «wse» •>»«- SP^ct
- - —
.
-
- - - -
Rlf.
m$
OfWwu
MlMU*
...
- —
Netn
- - - -----
*~
L. .
-
Rlf.
-
* The number of shmtl p«r pad miy vary iligntly
V-51
-------
HIPO WORKSHEET
GX20-197CM)U/M02S«
W-ndlnUJA.
Nun,:
AMD LMKIH&
61O fliae
, Pig*: oi.
Input
Output
Ex undid Descnpuon
Exttndad OMcrtptfon
To 1.3
Nom
Er*fRy To THIS 'OlMirftM \&
F«OO> T7>6.S I.I UHMCH IS
HOT PR«1IOgT». TUBte 1.1 F4MWTS
-me- ifltR vsc m uxitwt, iriucr MCBB
a-ous IB -me scawDs.
" -
— — - - - ._
-- - -
R«f.
- -
—
Notn
—
-- - -
•
— _ . . ..
- - ----- - -
i
i
Rif
-
.. -
-
' Thi number of shna par PM miy vary nightly
V-52
-------
HIPO WORKSHEET
QX20-197M U/M 028 •
. SyitMi/Prc
OUonmlO: £j
flesibuF f^eca/t/«
PROM 1.
Input
\5hSX
Output
i *a* eKM /Ki'Oof-Goof #eca*A
flsfiro&i
A ffem
»seo*&
Exnndad Ooscnpaon
Exanded Oaenptfon
Rtf.
R«f.
* Tht number of Kuan per pia may vary jliqntly
V-53
-------
HIPO WORKSHEET
GX20-197MU/M02S*
PrlnndmUJA.
All-1^ sv— /D— -— rVsrir.mes M.rturrapiHC nm, ._. ^
Input
Output
fifts-
diJ J
-------
HIPO WORKSHEET
PNimd In U&A.
MomTap'Ma
DwnpD
_ Dan: Pip: /. of^
JTBTF. SOT A UP Heuiranult
Input
MUW
**•
taw* , _
A ^ --
Pmcta
Output
^
^>
IvutAeJD. AJtiuti) Ju&JU "J
j£6J
~
.3-
^ A
-ox^V*
-J-T^W .A04>0 Wfeu
^>
-RSIEC.I5
Exnndid Oncnpnon
R«f.
Norn
**•
_ &u> UJ
-------
Tl
i^£» HIPO WORKSHEET
Prim) !„ UJA
Author.
Oiapim ID: I -f
?mV S.Tg A..B
uK TWft
FrflHl 1-5 pi
Input
Output
MSJjJ --*&&> tij 4&/J1 ^iJ+uJ
" ~ ' ' " J*J*>*>x '
:>
£.
-i—
Extended Oaenpaon
ExnmMC
To
i (»
NOtM
Rif.
' Ttw rumotr of ihna per pu may vary Sightly
V-56
-------
HIPO WORKSHEET
OX20-1970-OU/M02B'
. Syittm/PnwnK .
.Dm:.
. Pm:-
Input
OulBUt
a>
.-"tff^tjJ g A^ fa} t^J /
^AjfaisJ -4tt-~ffl{f^rf{£f tf(_/
\JK>
E>nndtd Oocupnon
Return
Not«
Rtf.
* Tin numtxr of ihna p«r pao may vary tlighlly
V-57
-------
HIPO WORKSHEET
GX20-197MU/M02S*
. System/Program:.
M&MiT&PiM<.
. Ont:.
/S
MtLlltjJ JiUiJ f)JJ}
, Pigi:-
Input
Output
R.f.
Rlf.
* Thi numoer of slmo par pu may vary iligntly
-------
HIPO WORKSHEET
QX20-197MU/M025'
Prt.imllnU.iA.
„„*„ «„ _„ 7fc*,-PClD*r? MXMITAPIM& n-., . . _.
Nuiur (Vimyi^PSionl f '-flftTMfl*
ti^ d!///'
Frew l £
Input
Output
«u &Jijs$u+c4J
. OMOU ji*Aj- AC&J I*J I, ,
_ . jiOMfAJ AUA+JJ. OMA/ty*t4)M*f*tj,
/••- lAI^J -*'\~l~\' ' _ .' . '
.-/fet 44461.
c>
Ex undid Dacnptian
Rekwv,
Notn
Rtf.
Rif.
* Th» mimbv of ihna per pu nuv v*ry tliqntlv
V-59
-------
HIPO WORKSHEET
MimdlnUSJk.
N«n.:
Output
Rif.
V-60
* The number o< iheeo per pia mey very digtitly
-------
HIPO WORKSHEET
GX20-197MU/M02S*
/£377//>
/«S5» *ae>tnf
~eu» uflirr /teteets
tier #r
Exnndid Dncnpaon
54
Natn
Tins 17>8L£ is f/vretm flffOf.
Seen u>*veD. TWS ijfai.f
Re»K rue Aemtruoe* of TW
PKM n riff AercoK&s o/o rvf .
/?s/rcr *CPO#T SINCE ntf
f!£Co#Za CDVJ> MOT ee
ioW>EJ> 43 sms wuiieeK. of
Sue Muae&t MOT FOUND «*• 3*65
SO*TB> -nucMwecrzK
--
-
Rlf.
Natn
. MODULE. 5-0 "D»n» "Bi«« ONLMA
.JS OECUteD APTCR. UJABIH6,
RjREOSe. OF THG_OULOftT> IS
3(CK TB W« QRlSlUft^PORMAr
AND tr> ewsuRe CORRSCTMS^S
OE U»6 PROtESSlllfi.
-
- - --- ---
Rlf.
.
- ---
• Tin numtxr |