-------
Exhibit VIl-1
Page 6 of 6
U S. ENVIRONMENTAL "90TECTION AGENCY
0"iCZ 3F '23~ C r£3 "CGP» 'S
••I**!'*!. =£»VICsS IIVIS.OI >H-]4J>
»;3L3Si£AL MON|TC°'*G aa»NC-*
-*»>.. NC-3^ r : .:*..
INST3tC~IONS CCR MAL
ba»s P'aee '< in ippr
som and inter i-allex arr
f gr. Aoorov-d
OMS Vo /JJ-ftOUO
UBINE a=37]CIOE RESIDUE ANALYSIS REPORT
V-it-irnf/OV 'liTHODl
s ^
oonai: cslu— i 11 -ie-eciable 3u. -irea5_-joi* 1-311.11 ol r:i.i:.e s :-e-
aunt ji AMOUNT caluirn. £VTES ZERO ir NOT SETSCT^BLi
HOSPITAL OR LOCATION IHtaf. Cur «id i<«il>
?«riStrj IDENTIFICATION NO. »»TIENT ] INlTtAkl
QATE C3LLSCTEO rtfenui, Smr, Ytffl ~tlSU£ rvPS
URINE
IC.C. MAKE MOQEL SeTSCTOfl
»»«A«eTSRJ I CILJMM 1 , :3L.MN >
VOLUME
uiL.i-!*a
METHOD OF lo«a-"«»»«»'»««»l'0««"'
A T Ualatttian 0iearfa«irii« 9C>4
AMOUNT »»• »»* «•
19 41 ft 11
1 . . . 1 • 1 . 1
1 , , . I.I .1
, . . ,.,_Lj
I . . . I.I .1
1
1 , . 1 .| | '
| . . l.._^_, ;
1 . . 1 . 1 . 1 I
, .,.,,! ;
i . ,.,_,• :
1 _1_ j | • 1 ! 1 1
1 . 1 . I • 1 t 1
••
>cx Q
•» 1
AOE | | |
omaii* [ |
REMARKS
EPA Ho
4310-40 (2-771
-------
Analysis Method
The specific items to be changed
All other patient-related data (age, sex, collection date,
height, etc.) may be changed by entering the minimum
identifying data plus the individual items to be changed.
(e) To add data, all information on the form must be
provided.
Soils, Water, Estuarine, and Air Monitoring Data
The Pesticide Analysis worksheet found in Exhibit VII-2 is
used for the collection of monitoring data for the soils,
water, estuarine, and air transport modes. Regardless of
the function to be performed, the following information must
be provided:
Transport Mode
Update Type
Source
Sample Accession Number
State
County/Region
Station/Site.
This information provides the minimum identification data
for a particular sample.
(a) To delete all data for a particular sample, the
information above is all that is required. To delete
a particular residue, the user must provide the residue
code in addition to the above data.
(b) In order to change residue related data, all of the
information mentioned above must be provided plus the
following:
Trace Indicator (air only)
Amount
Units
VII-5
-------
EXHIBIT VII-2
SECTION 1. SAMPLE IDENTIFICATION DATA
TRANSPORT MODE
SOURCE
UPDATE TYPE
A-Add
C'Changs
LAB.
NO.
SAMPLE ACCES-
SION NO.
7 3 9 to II
DATE RECEIVED AT LAB
PESTICIDE ANALYSIS WORKSHEET
SECTION 2. SAMPLING DATA (To be completed as sampling time)
SAMPLED BY (Agency and last -::me):
DATE SAMPLED
SITE
STATION/SITE NUMBER
STATE
COUNTY OR REGION
20
23
26
27
29
MATERIAL
CROP NUMBER (If applicable)
33 34 35 35 17 IS
39
PESTICIDES USED (Check or ipecifyl
2.4-0
CHLORDANE
DIELORIN
MALATHION
TRIFLURALIN
ALDRIN
DOT
ENORIN
PARATHIOIM
ATRAZINE
OIAZINON
HEPTACHLOH
TOXAPHENE
SAMPLING REMARKS
SECTION 3. SPECIFIC SAMPLE CHARACTERISTICS
SOIL
PH
42
%SANO
45
KSILT
41
5SCLAY
49
50
51
V, ORGANIC MATTER
52
5J
TIME OF SAMPLE
WATER
40
42
TOTAL SAMPLING TIME
PRECIPITATION
AIR
41
42
I.YES
2. NO 3. UNKNOWN
AMOUNT OF PRECIPITATION AIR VOLUME SAMPLED
- -- 145
47
DATE ANALYSIS COMPLETED
57
51
51
60
87
METHOD OF ANALYSIS
11
•.*V-? •:
SECTION 4. RESIDUES DETECTED
PESTICIDE
CODE
AMOUNT
PESTICIDE
CODE
AMOUNT
85 61 87 81 69 70
72 73 7« 7S 78 77 78
79
80
65 66 67 68 69 70
72 7] 74 75 76 77 78
79
•M " P.P M. (default): B - P P.S. ug/kg whole body, nenograms/cubic meter, wet weight: T » P.P T . K • P P K..
SECTION S. METEROLOGICAL DATA (AIR SYSTEM ONLY)
CARD TYPE
1
M
2-32 duplicate
TEMPERATURE,I°C)
MINIMUM
33 34 35 38
MAXIMUM
37 38 39 '0
WIND VELOCITY (KPH)
BEGINNING
40 41
ENDING
42 43
RELATIVE HUMIDITY (%)
BEGINNING
ENDING
45 46
47 48
WIND DIRECTION (°|
BEGINNING
ENDING
43 SO Si
52 5J 54
REMARKS.
DATE
ANALYST'S
INITIALS
EPA Form 8550-2 I Rev.
-------
CODING INSTRUCTIONS FOR PESTICIDE ANALYSIS WORKSHEET
MODE OF TRANSPORT = SOILS
Responsibility
SAM
SAM
EMB
LAB
SAM
SAM
SAM
SAM
SSB
SAM
SSB
SAM
SAM
LAB
LAB
LAB
LAB
Position
1
2
4-5
6-11
12-17
18-19
20-22
23-28
29-32
33-36
36-38
39
40-42
43-45
46-48
49-51
52-54
Description
Transport Mode, must be the
character "S"
Source, Urban ="U"
Agricultural ="A"
Update Type, default will
be "A".
To change information already
in the system, use the
designation "C".
To delete information use "D".
LAB Number
Sample Accession Number
Sample Date, required for
adds only
12-13 Month
14-15 Day
16-17 Year
State, two digit FIPS State
Numbe r, required
County, three digit FIPS
County number or SMSA
Blank
Site Number, four digit numeric
Blank
Sample Material Code
36-38 Sample Material Number
Crop Cycle, required of
Cropland Sites only
PH
% Sand
% Silt
% Clay
% Organic
sum must equal 100.0
-------
SSB 55-56 Blank
LAB 57-62 Analysis Date
57-58 Month
59-60 Day
61-62 Year
SSB 63-64 Analysis Method, must be
blank
EMB 65-70 Residue Code, 6 digit
Shaughnessy Code or
P#S9—, where — equals 900
code for no residues detected.
SSB 71 Blank
LAB 72-78 Amount
LAB 79 Units
SSB 80 Blank
-------
CODING INSTRUCTIONS FOR PESTICIDE ANALYSIS WORKSHEET
MODE OF TRANSPORT = WATER
Responsibility
SAM
SSB
EMB
LAB
SAM
SAM
SAM
SSB
SSB
SAM
EMB
SSB
Positions
2
3
4-5
6-11
12-17
18-19
20-22
23-24
25-32
33-38
39
Description
TRANSPORT MODE, must be
the character "W"
source, leave blank
Update Type, default will
be "A" = add, all new
samples should be "A".
To change information
already in the system, use
the character, "C".
To delete information, use
the character "D".
Lab Number
Sample Assession #
Sample Date, required for
adds only
12-13 Month
14-15 Day
16-17 Year
State, two digit FIPS State
Number, required
County, leave blank
Leave blank
Site Number
Sample Type
33-3 5 leave blank
36-38 001 mud
002 whole water
leave blank
SAM
SSB
LAB
SSB
EMB
SSB
40-43
44-56
57-62
63-63
65-70
71
Time Sample Taken
leave blank
Analysis date
57-58 Month
59-60 Day
61-62 Year
Analysis Method, leave blank
Residue Code, 6 digit
Shaughnessy Code
Trace Indicator, leave blank
-------
LAB 72-78 Amount
LAB 79 Units
3SB 80 Confidence Code,
leave blank
-------
CODING INSTRUCTIONS FOR PESTICIDE ANALYSIS WORKSHEET
MODE OF TRANSPORT = AIR
SECTIONS 1-4
Responsibility
SAM
SSB
EMB
LAB
SAM
SAM
SAM
SAM
SSB
SAM
SSB
SAM
Position
1
2
3
4-5
6-11
12-17
18-19
20-22
23-30
31-32
33-37
38
Description
Transport Mode, must be the
character "A" source, leave
blank
Update Type, default will
be "A"=add, all new samples
should be "A". To change in-
formation already in the
system, use the designation
"C". To delete information
use "D"
Lab Number, required
Sample Accession Number, required
Sample Date, required for
adds only, must be blank if delete
12-13 Month
14-15 Day
16-17 Year
State, Two digit FIPS State
Number, required
County, Three digit FIPS
County Number, required
Blank
Site Number, Two digit numeric,
required
Blank
Study Type required, 1 digit code
SSB
39
Blank
-------
Responsibility
Position
Description
SAM
SAM
SAM
SAM
SSB
SSB
LAB
LAB
EMB
LAB
LAB
LAB
LAB
40-43
44
45-48
49-52
53-54
55-56
57-62
63-64
65-70
71
•V2-78
79
80
Total Sampling Time
Precipitation Indicator,
1= Yes, 2= No. 3= unknown
Precipitation, if 44= No or
unknown must be blank
Air Volume Sampled ( m3 )
Must be blank
Blank
Analysis Date
57-58 Month
59-60 Day
61-62 Year
Analysis Method
Residue Code, 6 digit
Shaughnessy Code
Trace Indicator, «<=• or )a
Amount, report to 1 decimal
only and pad zeros
Units
Cofidence Code
-------
METEROLOGICAL DATA
Section 5
Responsibility Position Description
SSB 1 Must be M
SSB 2-32 duplicated from top portion
SAM 33-36 Minimum Temperature, if
negative include minus sign
SAM 37-40 Maximum Temperature, if
negative include minus sign
SAM 41-42 Beginning Wind Velocity
SAM 43-44 Ending Wind Velocity
SAM 45-46 Beginning Relative Humidity
SAM 47-48 Ending Relative Humidity
SAM 49-51 Beginning Wind Direction
SAM 52-54 Ending Wind Direction
-------
CODING INSTRUCTIONS FOR PESTICIDE ANALYSIS WORKSHEET
MODE OF TRANSPORT = ESTUARINE
Responsibility Position Description
SAM 1 Transport Mode , must be the
character "E"
SSB 2 Source , leave blank
EMB 3 Update Type , default will be
"A" = add, all new samples should
be "A".
To change information already in
the system, use the character
"C".
To delete information, use the
character "D".
LAB 4-5 Lab number
SAM 6-11 Sample Accession Number
12-17 Sample Date
12-13 Month
14-15 Day
16-17 Year
SAM 18-19 State, two digit FIPS State
Number.
SAM 20-22 Region Code , two character
region.
SAM 23-32 Station Number, ten character
station code
EMB 33-38 Species Code , 3 digit Bureau of
Fisheries Species Code
SSB 39-56 Leave Blank
LAB 57-62 Analysis Date
57-58 Month
59-60 Day
61-62 Year
-------
Position Description
SSB
EMB
SSB
LAB
LAB
SSB
63-64
65-70
71
72-78
79
80
Analysis me1
Residue Cod<
Code
Trace Indie.
Amount
Units
Confidence
-------
Confidence Level (air only)
To change soil sample texture data, in addition to the
minimum required data, the percents of sand, silt, and clay
must be entered. All other information may be changed as
required by providing the minimum identification
information. Analysis method is used only in the air mode
and therefore may not be changed (unless the sample is an
air sample).
(c) In order to add data, all information on the form is
required, except the following:
Analysis Method,
Trace Indicator, and
Confidence,
which are required of air samples only.
Soil Application Data
The data collection form to be used for pesticide and
fertilizer usage on cropland sites may be found in Exhibit
VII-3. Regardless of the function to be performed, the
following information is required:
Update Type
Record Accession Number
State
County
Site
Crop Number
This information provides the minimum identification data
for a particular sample.
(a) To delete all data for a particular sample, the
information above is all that is required. To delete
a particular pesticide or fertilizer, the following
additional data is required:
Crop name
Pesticide or fertilizer used
VII-6
-------
EXHIBIT VII-3
UPDATE
TYPE
P
DATE
'3
LAB
3 |4
1
NO
RECORD ACCESSION NO
' i'
RECEIVES LA=C"A-
l.
*5 1
'"'
i-
"OR"
1 3
1
SITE
STATE
A C
•?
N AME
IRRIGATION
21
2:
37
.0
: i
.2
1
S
US ENVIRONMENTAL PROTECTION AGENCY
WASHINGTON 3 C 2 ;o Laoora;ors. Retain second coov.
'Stare, Count.. Sire \o j
C3UNTV
33
39
(Centimeters)
A
40
C
RES
41
92
23 24
25
29
27
as
29
CROP NO.
31
OATEUSE RECORD COMPLETED
31
22 33
34
35 i 39
CROPS \arne. coda, and acrea lor >?acri irup/
B CRO» NAME
93 3
4
95
REMARKS
43
44
45
«
PESTICIDE USED
I • MO 2 • V £S
C C=OP S-ME '47
t
99
RECORDER'S
INITIALS
49
57
98
50 5 1
99 9C
USE COOES
1 • INSECTICIDE 2 • HERBICIDE 3 • FUNGICIDE
4 • ROOENTICIOE 9 • FERTILIZER 9 • OTHER (Specily in remarks)
FORMULATION CODES
1 • EMULSIFIABLE CONCENTRATE
2 • SOLUBLE SALTC:, J-O Arr.me Salt/
3 • «ETTABLE =OWDER
4 - GRANULAR
5 • 3UST
S TECHNICAL MATERIAL (ulim-IOn
volume)
9 - OTHER fSpecifv in reirarkst
PESTICIDE OR FERTILIZER USED
'Common approved name of eacrO
65
66
67
61
69
1
I
70
' , 1
I
!
° 3
u S
7t
CODE ABOVE
USE
72
FORMU-
LATION
71
METHOD OF APPLICATION
CODES
GROUND APPLICATOR BAND
2 GROUND APPLICATOR
BROADCAST
3 • FIXED «INC AIRCRAFT
4 - HELICOPTER
5 - SEED TREATMENT
i • OTHER (Specily in remarks;
POUNDS PER ACRE OF
ACTIVE INGREDIENTS
WHOLE LBS.
74
79
!
76
77
S.tVs
78
79
"OF
APPLI-
CATION
CCode
above}
to
£F A Form 3550-3 .Rtv I
-------
Crop (A,B,C).
(b) In order to change pesticide or fertilizer related data
enter the data listed above plus the use, formulation,
and method codes, as well as the application amount.
Crop name may not be changed, but all other information
may be changed as required.
(c) To add new data, provide all information on the form.
Updating Other Data Base Information
Other data base data may be updated as required. These data
categories are
Soil Site related data
Water Site related data
Human Site related data
Estuarine Site related data
Air Site related data
Residue Code related data
Other coded data (sample types, study types, formulation
codes, etc.)
State related data
The input form for collection of this data may be found in
Exhibit VII-4. Exhibit VII-5 lists the data required for
each add, change or delete function.
Users must be extremely careful when deleting any of these
important data items. Improper deletion of a record, for
example, can result in drastic changes to the data base.
Deleting a Site will delete all samples for that site.
Deleting a State will delete all sites and samples relating
to the state. Deleting a residue code will delete all residue
related data for all samples where that residue was tested.
Deleting other codes such as a particular sample type will
cause the definition for the code to be lost even though
the code may still exist in the data base.
(4) Correction Procedures
Once the edit/update cycle has been run for a group of
transactions, error lists along with the input forms will be
VII-7
-------
Pesticides Monitoring System
Site, Code, State Update
EXHIBIT VII-4
SECTION 1. SITE UPDATE
SOIL
SITE
WATER
SITE
HUMAN
SITE
ESTUARINE
SITE
AIR
SITE
Type
a
&
z
'x
UfDK.1l
1
Ul
a
a
3S
Type
h-
Z
1X
MI
*•
«t
a
3
2
a
a
3W
SOURCE
4
FIPS
State
5
%
Organic
35
SOURCE
4,
FIPS
State
s
s.
':'•'• -,
Type
3
a,
Z
'x
tu
h-
<
a
a.
3
2
Typs
|
z
'X
IU
h-
t
a
^
a
2
Type
1-
3
'x
IU
2
LU
a
a
3H
Ul
a
a
3E
01
0
JA
SOURCE
4
SOURCE
'»
SOURCE
*••
County
or SMSA
Number
7
o
&
i
38
Site No.
to
•rj
5
-I
u
14
.=
3
c/>
a
w
IS
t
cc
u
16
Avg
Temp °C)
17
Avg
Rain (CM)
20
PH
23
%
Sand
26
COUNTY/SMS A NAME
39
Site No.
7
y, %
Silt Clay
29
" J_
SITE NAME
%
ts
. >i ' ^ - ,-.",
FIPS
State
5
Fl
St
i
PS
ate
FIPS
State
5
Site
No.
7
Reg
7
IU
Site
No.
7
Latitude
35
NAME/CITY
to
30
Station
9
County
No.
9~
Name
Longitude
42
*. *
4 %^ '
SITE NAME/COUNTY NAME ' > ,^ ,- '
% %
12
32
Height
Above
Ground
(Meters)
52
Type
1
ii
a
a
56
Elev.
Above
Sea
(Meters)
57
Prev.
Wind
Oir.
61
~
t
DISTANCE FROM
(Kilometers)
Field
64
Plant Storage
68
72 _L
SECTION 2. RESIDUE CODE UPDATE
Update
i
CODE
2
3»
S
Shaughnessy Code
5
CLASS
11
RESIDUE NAME
13
-
WARNING LEVELS (ppm)
HUMANS
31
!
SECTIONS. OTHER CODES
OTHER
CODE
Type
W-
3
&
=
'c
IU
K
«
2
Code
3
o
^
5
SECTION 4. STATE UPDATE
STATE
Type
a
A.
a
'T
Hvudn
2
FIPS
State
3
^^^
SOILS
38~
WATER
45
AIR
52
ESTUARINE
59
_L_L
CODE NO.
H
K
8
CODE TRANSLATION
11
\ \ v s
«.
EPA
Reg.
5
Census
Reg.
7
FIPS
Abbr.
9
STATE NAME
n
Census
Div.
31
-------
CODING INSTRUCTIONS FOR SITE, CODE, STATE UPDATE
HUMAN SITE UPDATE
POSITIONS DESCRIPTION
1 Input Type, Preprinted 'X1
2 Update Type, Add 'A1, Change 'C', Delete 'D1
3 Transport Mode, Preprinted 'H'
4 Source: 'H1 - HAMES, blank otherwise
5-6 FIPS State Number
7-10 Site or Stand Number
10-29 Site Name
30-49 Site City
ESTUARINE SITE UPDATE
1 Input Type, Preprinted 'X1
2 Update Type, see above
3 Transport Mode, Preprinted '£'
4 Source, leave blank
5-6 FIPS State Number
7-8 Region
9-18 Station Number
19-38 Station Name
AIR SITE UPDATE
1 Input Type, Preprinted 'X1
2 Update Type, see above
3 Transport Mode, Preprinted 'A1
4 Source, leave blank
5-6 FIPS State Number
7-8 Site Number
9-11 County Number
12-31 Site Name
32-51 County Name
52-54 Height of Sampler Above Ground (Meters)
55 Type of Area, one digit code
56 Use of Area, one digit code
57-60 Elevation of site above sea level (Meters)
61-63 Prevailing Wind Direction (degrees)
64-67 Distance from tilled field (kilometers)
68-71 Distance from manufacturing plant (kilometers)
72-75 Distance from pesticide storage (kilometers)
-------
CODING INSTRUCTIONS FOR SITE, CODE, STATE UPDATE
SOIL SITE UPDATE
POSITIONS DESCRIPTION
1 Input Type, Preprinted 'X1
2 Update Type, Add 'A1 ,Change 'C', Delete
3 Transport Mode, Preprinted 'S1
4 Source, Agricultural 'A1, Urban 'U1
5-6 FIPS State Number
7-9 County or SMSA Number
10-13 Site Number
14 Cropland Code
15 Urban Site 'U1,Agricultural Site 'A1
16 Cropping Region
17-19 Average Temperature °C
20-22 Average Rain (cm)
23-25 pH
26-28 Percent Sand
29-31 Percent Silt
32-34 Percent Clay
35-37 Percent Organic
38 Soil Type
39-58 County or SMSA Name
WATER SITE UPDATE
1 Input Type, Preprinted 'X1
2 Update Type, see above
3 Mode, Preprinted 'W
4 Source, leave blank
5-6 FIPS State Number
7-14 Site Number, Right justified
15-34 Site Name
35-41 Latitude
35-37 Degrees
38-39 Minutes
40-41 Seconds
42-48 Site Longitude
42-44 Degrees
45-46 Minutes
47-48 Seconds
-------
CODING INSTRUCTIONS FOR SITE, CODE, STATE UPDATE
RESIDUE CODE UPDATE
POSITIONS DESCRIPTION
1 Input Type, 'R1
2 Update Type, Add 'A1, Change 'C1, Delete 'D1
3-4 leave blank
5-10 Shaughnessy Code
11-12 Residue Class
13-30 Residue Name
31-37 Humans Warning Level for error messages (PPM)
38-44 Soils Warning Level (PPM)
45-51 Water Warning Level (PPM)
52-58 Air Warning Level (PPM)
59-65 Estuarine Warning Level (PPM)
OTHER CODE UPDATE
1 Input Type, Preprinted 'C1
2 Update Type, see above
3-4 Code Type; 'RC1 - Residue Class
'AA1 - Air Area Code
'AU' - Air Use Code
'SF' - Soils Formulation
•SA' - Soils Application
'SU' - Soils Use Code
'ST' - Sample Type
'CR1 - Census Region
'CD1 - Census Division
5 Transport Mode, Used only for Sample Type
Update, leave blank otherwise
6-7 Leave Blank
8-10 Code Number
11-30 Code Translation
-------
CODING INSTRUCTIONS FOR SITE, CODE, STATE UPDATE
STATE UPDATE
POSITIONS
1
2
3-4
5-6
7-8
9-10
11-30
31-32
DESCRIPTION
Input Type, Preprinted 'T1
Update Type, Add 'A1, Change 'C', Delete 'D1
FIPS State Number
EPA Region
Census Region
FIPS State Abbreviation
Official State Name
Census Division
-------
INPUT
TYPE
SOIL SITE
WATER SITE
HUMAN SITE
ESTUARINE SITE
AIR SITE
UPDATE
TYPE
CHANGE
DELETE
ADD
CHANGE
DELETE
ADD
CHANGE
DELETE
ADD
CHANGE
DELETE
ADD
CHANGE
DELETE
DATA REQUIRED FOR
UPDATING OTHER DATABASE INFORMATION
DATA REQUIRED
all data is required (except weather and soil
specific data which is optional)
all data through site required to identify the site,
plus data being changed
all data through site
all data is required
all data through site required, plus data being changed
all data through site
all data is required
all data through site, plus data being changed
all data through site
all data is required
only station name may be changed, therefore all data
is required
all data through station
all data is required
all data through site number, plus data being changed
all data through site number *
o
i-h
to
H-
tr
H-
rt
H
I
U1
-------
INPUT
TYPE
RESIDUE CODE
OTHER CODE
STATE
UPDATE
TYPE
ADD
CHANGE
DELETE
ADD
CHANGE
DELETE
ADD
CHANGE
DELETE
DATA REQUIRED
all data is required
all data through SHAUGHNESSY CODE, plus data being
changed
all data through SHAUGHNESSY CODE
all data is required
all data is required
all data through Code Number is required
all data required
all data through FIPS State, other data as required
all data through FIPS State
10
n>
x
tr
H-
tr
H-
rt
I
Ul
-------
provided to the responsible Project Officer. The error lists
should be examined to determine why the transaction was rejected
and what corrections are necessary. The Project Officer should
then access and correct the rejected transactions (using ALPHA).
The next time the edit/update cycle is run, the transactions will
be re-edited and, if acceptable, the data base will be updated.
Any uncorrected or improperly corrected transactions will again
be rejected.
2. INSTRUCTIONS FOR REPORT GENERATION
This section describes the procedures for generating any of the
standard reports and how to retrieve old data that is no longer stored
in the data base. The reports currently available are as follows:
Soils Geographic
Soil Site by Site
Application Summary
Air Site by Site
Air Geographic
Estuarine State Summary
Estuarine Exception
Water Geographic
Water Site by Site
Water Pesticide
Humans Geographic
Humans Demographic
Individual Patient Summary
The specifications for each of these reports may be found in Exhibit
VII-6.
To generate each of the reports the user signs on to the system
and "calls up" the report generator. The report generator will then
prompt for any required input parameters such as dates, residues wanted,
sample types, etc. The actual format and data required for calling up
the report generator and entering parameters may be obtained from the
system support Branch. An example of how the generation of a report
would work follows.
VII-8
-------
To generate the Humans Demographic Report for all urine samples
(including surplus) collected in 1978, on an age/sex breakdown, the
user would do the following:
Sign on to ALPHA
Call up the report generator
Enter the Report Code for the report with input parameters
enclosed in brackets, individual parameters separated by
commas
The report code for the Humans Demographic report is
HD
The dates are entered in the CSD and CED parameters
The tissue type is entered in the CTT parameter
The basis is entered in the CB parameter (lipid or wet
weight, valid only for Adipose tissues)
The sample design is placed in the CSDN parameter
The summary level goes in the CSL parameter
The demographic category goes in the CDC parameter.
Therefore, to generate the report, the user might enter
HD [CSD(010178),CED(120178),CTT(04),CSDN(S),CSL(N),CDC(AS)].
The system will interpret the individual codes and initiate a batch
job for the generation of the report. The job will be run on a low
priority basis and the output will be available to the user at a later
time.
3. INSTRUCTIONS FOR GENERATING RESPONSE TO AD HOC QUERIES
Three ad hoc queries have been predefined in addition to the
reports available above. These are simple queries and are used as
examples of the types of queries that can be made. The report
variations available should answer a majority of the data needs, but
simple queries can be formed and answered through a request to SSB.
Once the programs have been written they would be available for use
at any future time.
The queries that have been predefined are as follows:
"What are the residues codes, names, and classes that can be
reported?"
VII-9
-------
"What sites are in state xx?"
"What sites are used in the xxxx mode of transport?"
Report specifications for these queries are found in Exhibit VII-
6. The method for generating each of these reports is as follows:
(1) "What are the Residue Codes, Names, and Classes that can be
reported?"
Sign on to ALPHA
Enter the instruction to run the Residue Code Listing
Program.
(2) "What sites are in state XX?"
Sign on to ALPHA.
Create an ALPHA catalogued user file having one entry, namely
the FIPS State Number for the state wanted.
Enter the instruction to run the State-Site Program.
(3) "What Sites are used in xxxx mode of transport?"
Sign on to ALPHA.
Create an ALPHA catalogued user file having one entry, namely
the Transport Mode wanted for selection of sites (A = Air,
W = Water, S = Soils, E = Estuarine, H = Humans).
Enter the instruction to run the Mode-Site Program.
The exact file names and program names to be used will be provided
at the completion of implementation.
4. INSTRUCTIONS FOR FULFILLING OTHER DATA NEEDS
For nonstandard data requests, the Project Officer must contact
the System Support Branch with exact details of what data is needed.
This procedure is to be used for such activities-as:
retrieving data more than three years old
inaugurating new reports
developing new ad hoc queries.
As the Pesticides Monitoring System matures the frequency of such
nonstandard requests is expected to diminish.
VII-10
-------
REPORT SPECIFICATIONS
REPORT NAME
SOILS GEOGRAPHIC
REPORT NUMBER
PURPOSE
To provide geographic summaries of
pesticide residue levels in soils
FREQUENCY
On demand
USERS
National Soils Monitoring System
Project Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Major - Parameter Summary
Intermediate 1 - Sample Type
Intermediate 2 - Residue Class
Code
Minor - Residue Code
RECORD SELECTION CRITERIA
Transport Mode = S
Sample Date >_ Parameter Start
Date
Sample Date <_ Parameter End
Date
DETAILED DESCRIPTION
The report specifications satisfy the requirements for
summaries on 3 levels. These include:
State Summary
EPA Regional Summary
National Summary
Input to the report program generator must include the
following items:
Sample Date selection range, using
Parameter Start Date and Parameter End
Date
Type of Summary wanted, using the
field Parameter Summary (valid values
are State, Region, Nation)
VH-li
-------
REPORT NAME
SOILS GEOGRAPHIC
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
Report breaks occur on the following fields:
Residue Code
Residue Class Code
Sample Type
Parameter Summary
Selected records are to be sorted in Report Sequence Order.
For each break on Residue Code the following data elements
are presented:
a) Residue Name
b) Sample Size = count of samples tested for the residue
in a.
c) Number Positive = count of samples where Residue
Amount > 0 and trace indicator = Jrf.
d) Percent Positive = c/b*100
e) Number Trace = count of samples with trace indicator
f) Percent Trace = e/b*100
g) Minimum = smallest positive Residue Amount.
h) Maximum = largest positive R'esidue Amount.
i) Arithmetic Mean = (I Residue Amount)/b.
j) Geometric Mean=(antilog y)-.oi,where y= ^ log y.
where y.^= 0^+0.01), x^individual residue amount.
k) Median
1) Low end
m) High end
n) Total Amount Detected = z Residue Amount for all
samples with trace indicator = 16.
Vli-12
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
SOILS GEOGRAPHIC
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
FIPS State Number
State Name
EPA Region Number
EPA Region Name
Sample Date
Sample Type
Residue Class Code
Residue Class Name
Residue Code
Residue Name
Residue Amount
Trace Indicator
Parameter Start Date
Parameter End Date
Parameter Summary
VII-13
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME
SOILS GEOGRAPHIC
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
H-3
H-5
H-6
H-7
H-8
H-9
H-10
D-l
D-2
4-125
127-130
52-79
49-65
67-71
73-76
78-82
4-8
10-29
21-40
1-18
2-19
21-24
26-29
31-36
39-42
44-49
51-58
61-68
70-78
80-88
Constant Data
Page Number
Report Title
Parameter Summary
State
Region
Nation
Constant Data
Parameter Start Date
Constant Data
Parameter End Date
Constant Data
Area Name
Parameter Summary
State
Region
Nation
Constant Data
Constant Data
Constant Data
Constant Data
Sample Type Name
Residue Class Name
Residue Name
Sample Size
Number Positive
Percent Positive
Number Trace
Percent Trace
Minimum
Maximum
Arithmetic Mean
Geometric Mean
Report Title
STATE Summary
EPA Regional Summary
NATIONAL Summary
Area Name
State Name
EPA Region Name
NATION
VII-14
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE
REPORT NAME
SOILS GEOGRAPHIC
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
(cont.
90-98
100-108
110-118
120-127
Median
Low End
High End
Total Amount Detected
VII-15
-------
SYSTEM
PES
TICIDES
REPORT NAME
vSoiis GEOGRAPHIC.
REPORT NUMBER:
Arthur Young & Company
-------
REPORT SPECIFICATIONS
REPORT NAME
SOIL SITE BY SITE
REPORT NUMBER
PURPOSE To prOvide details of soil residue and
application of pesticides on a site by site
basis
FREQUENCY
On Demand
USERS
National Soils Monitoring Program Pro-
ject Officer
MAXIMUM TURNAROUND
24 hours
FILha USED
AVERAGE NUMBER PAGES
Pesticides Monitoring System Data Base
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Major - FIPS State Number
Intermediate 1 - County Code
Intermediate 2 - Sample Type
Code
Intermediate 3 - Residue Class*
Code
Minor - Residue Code
RECORD SELECTION CRITERIA
Transport Mode = S
Sample Date > Parameter Start
Date
Sample Date < Parameter End
Date
DETAILED DESCRIPTION
Input to the report program generator must include the
following items:
Sample Date and Application Date Selection range using
Parameter Start Date and Parameter End Date
Report breaks occur on the following:
Site Number
For each break on site number the following information is
listed using the site record for detail data:
a) Site Number
b) County Name
c) State Name
d) Cropping Region
e) Average Rain
f) Average Temperature
g) Irrigation
h) PH
i) Soil Type
j) % organic
VII-17
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 2
REPORT NAME
SOIL SITE BY SITE
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
k) % Sand
1) % Silt
m) % Clay
For each sample record the following data is presented:
a) Sample Type Name
b) Sample Accession #
c) Sample Date
d) Analysis Date
e) Analysis date (residue class name, residue name, trace
indicator, residue amount, units, and confidence code)
For each application record the following data is presented:
a) Sample Type Name
b) Crop Number
c) Crop Area (in hectares = crop acres/2.47 rounded)
d) Pesticide Applied
e) Application Amount in KG/hectare
f) Use Name
g) Formulation name
h) Application Method Name
VII-13
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
SOIL SITE BY SITE
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
FIPS State Number
State Name
County Code
County Name
Site Number
Average Rain
Average Temperature
Irrigation
PH
Soil Type
Percent Organic
Percent Sand
Percent Silt
Percent Clay
Sample Date
Accession Number
Analysis Date
Crop Code, Crop Acres, Crop Number
Residue Class Code
Residue Class Name
Residue Code
Residue Name
Trace Indicator
Residue Amount
Confidence Code
Sample Type
Sample Type Name
Date Use Record Completed
Code for Pesticide Used
Application Amount
Use Code
Use Name
Formulation Code
Formulation Name
Application Code
Application Name
Acreage
VII-19
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME REPORT NUMBER
SOIL SITE BY SITE
OUTPUT DATA ELEMENTS
LINE
H-l
H-2
H-3
H-4
H-5
H-6
H-7
H-8
H-9
H-10
H-ll
COLUMN
1-125
127-130
50-66
68-72
74-77
79-83
4-11
13-20
42-116
4-10
12-25
42-54
58-62
71-73
89-92
103-109
113-116
4-9
12-31
42-53
58-62
71-75
103-109
113-116
4-19
21-40
42-56
58-60
71-88
89-92
103-109
113-116
ELEMENT
Constant Data
Page Number
Constant Data
Constant Data
Parameter Start Date
Constant Data
Parameter End Date
Constant Data
Constant Data
Site Number
Constant Data
Constant Data
County Name
Constant Data
Average Rain
Constant Data
PH
Constant Data
Percent Sand
Constant Data
State Name
Constant Data
Average Temperature
Constant Data
Constant Data
Percent Silt
Constant Data
Cropping Region Name
Constant Data
Irrigation
Constant Data
Percent Organic
Constant Data
Percent Clay
Constant Data
Constant Data
Constant Data
VII-20
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 5
REPORT NAME
SOIL SITE BY SITE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-12
D-l
D-2
D-3
H-13
H-14
H-15
D-4
2-21
24-33
36-43
46-53
56-73
76-93
96
98-105
107
111
76-93
96
98-105
107
111
56-73
76-93
96
98-105
107
111
2-21
25-26
30-31
35-52
56-62
65-75
78-100
105-130
Constant Data
Crop Number
Crop Area
Sample Date
Analysis Date
Residue Class Name
Residue Name
Trace Indicator
Residue Amount
Units
Confidence Code
Residue Name
Trace Indicator
Residue Amount
Units
Confidence Code
Residue Class Name
Residue Name
Trace Indicator
Residue Amount
Units
Confidence Code
5>
Constant Data
Constant Data
Constant Data
Type Name
Residue Name
Application Amount
Use Name
Formulation Name
Application Name
VII-21
-------
SYSTEM
REPORT NAME
SOILS SITE "B.V
REPORT NUMBER:
Arthur Young & Company
r* foil It MI t ai ihilinl line
-------
REPORT SPECIFICATIONS
REPORT NAME
APPLICATIONS SUMMARY
REPORT NUMBER
URPOSE
To provide a summary of compounds
applied to cropland soils.
FREQUENCY
On demand
USERS
National Soils Monitoring Program
Project Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
National Summary - 1 pg.
State Summary - 50 pps.
OUTPUT MEDIA
132 column paper
EQUENCS OF REPORT
If State option chosen:
Major - FIPS State NBR
Minor - Pesticide Code
If National Option Chosen:
Pesticide Code
RECORD SELECTION CRITERIA
Transport = S
Fiscal Year = Parameter Fiscal
Year
FIPS State Nbr - a member of
Parameter State
List.
Pesticide Code - a member of
Parameter
Pesticide List.
DETAILED DESCRIPTION
Input to the report generator must include the Summary Level
for the report using the Parameter Summary Level. Valid values
are Nation or State. If the State option is used the input must
also include a list of FIPS State Codes for those states to be
reported. (Default will be all states.)
Additional input must also include a list of compounds to be
Reported. (Default will be all compounds applied.)
A Reporting option also includes whether to be printed in
internal or publication format. Publication format does not in-
clude the arithmetic mean column (f) as described below.
For each sequence break on Pesticide Code, summary informa-
tion is provided which includes:
a) Pesticide Code
b) Residue Name
c) Number of selected site records using the Pesticide
d) Percent of Sites = c •* total S of selected site records
e) Application Rate Arith Mean = g T c
f) Arithmetic Mean
g) Total Amount Applied in KG/HA = (h X 2.47) T 2.2
h) Total Amount Applied in LBS/A = I Application Amounts
i) For each Formulation: the formulation code, % of sites
j) For each Use: the use code, % of sites
VII-23
-------
ncrun i arcwinv.M i luifo ,uui* i IIYUKUI
PAGE
2
REPORT NAME
Applications Summary
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
k) For each Application Method: the method code, % of sites
For each major sequence break the following data is
presented:
a) If State Option was specified, the Name of the State
and the number of sites within the state
b) If National Option was specified, the total f of
selected site records
-1
VII-24
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
APPLICATIONS SUMMARY
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
Fiscal Year
Parameter Fiscal Year
State Number
Parameter State List
Pesticide Code
Parameter Pesticide List
Residue Name
Application Amount
State Name
Method Code
Use Code
Formulation Code
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME REPORT NUMBER
APPLICATIONS SUMMARY
OUTPUT DATA ELEMENTS
LINE
H-l
H-2
H-3
H-4
Thru
H-8
H-10
H-12
D-l
COLUMN
4-11
45-125
127-130
54-64
66-67
1-20
24-27
29-33
2-7
10-27
30-33
40-45
52-57
60-66
68-74
76-82
84
85
86-88
90
91
92-93
95
96
97-98
101
102
103-105
107
108
109-110
ELEMENT
System Date
Constant Data
Page Number
Constant Data
Constant Data
Fiscal Year
Constant Data
Parameter Summary Title
National National
State State Name
Number Sites
Constant Data
Constant Data
Pesticide Code
Residue Name
Number Sites Using Compound
PCT-?ites
Mean Application Rate
Arithmetic Mean
Total Amount Applied KG/HA
Total Amount Applied LBS/A
Formulation Code
Constant Data
PCT-Formulation
Formulation Code
Constant Data •
PCT-Formulation
Formulation Code
Constant Data
PCT-Formulation
Use Code
Constant Data
PCT-Use
Use Code
Constant Data
PCT-Use
VII-20
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE r
REPORT NAME
APPLICATIONS SUMMARY
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
Dl
(Cont)
D2
112
113
114-115
118
119
120-122
124
125
126-127
129
130
131-132
84-132
Use Code
Constant Data
PCT-Use
Method Code
Constant Data
PCT-Method
Method Code
Constant Data
PCT-Method
Method Code
Constant Data
PCT-Method
Used as necessary, source data fields
as D-l
VII-27
-------
SI ICIDGS MoMlTORlNfi
REPORT MAMF. APPtl CATlOKiS SUMMARY REPORT MIIMRFR
IM4:6l890II)45CI830IM456tt90l2
i :\Jn/n
2
3
6 :: iu * MIIPCOHD 5 ilE • l):
9
10 { ( i i i i i i r E
n
_ 13 j •- -? < :> .J J?
IS
16 "
17
18
19
to
< *! .'.'.'.'.'.'..'.
H 23
H 23
1 24
"J ,5
CO
26
27
28
29
3C
31
3?
33
35
36
37
36
4O
41
42
43
44
45
47 " "
48
49
50 "
t?i4J6IJ3»IP14SS1890l!)456l890l!
1
1 J ! J J J 4 < 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 » \W6 6 « 6 6 6 6 56 6 T 111
l456IJ30l2i4S6l«90IM4i61 MSlO 1 1 M i 8 l|| 9)0 1 ?|l
M i M fi A i ]!HLSittQtylT>R 'i^Si 5JVfe
. . i i s 3 > >«D s . \pjpi tit. S_cicPLLX
fisfcWi n$(5^..f|;!
-F :E?;Uf"j; *hr« iJiu Kiiwrl'i TioVi
i 51 • ;s i i i " , ^fflt i:e*'»» • • • «P
T
1
i i 1 1 a a
61190 1
S'?TT
| C:M))iS jj^HJI |j KK'^HA.iJ-..KjS/JlA >85/A
, | l-ll-'l-Hf •!-•'•;
. . | ijjrj L. .!i i
:. . .I" Y'~-\ '•'
•-• ; % : u i
i ! i 1 J l • '
i I _ i
!
I r
" " r .
J, . 1 ..;.
1 U J
t i ^ !
Q 9.9.1) 9. fe
. i 1 | i
1 ,
| . ' 1
r'-r-^-
;- ! i ' r
J ] 1. .. i
. . i :, .
: | N 1 '-••!!, }
ii.
.1. ,
"*" i
. " '.. ".' "- '.'.'. \
.......
3 SGI1 0 2MSII890I MSKIB9 1 M 4 5 6 M 9 0 1 ?
i
j j
i i 1
j 1
1
4
i i 1 1 » i
(1190
ArthurYoung&(
nun i r n TF
t a a i a 8 88999999999900000000001
! J 1 5 6ll ! 9 0 1 ? J 4 5 6 1 8 9 0 1 ! ) 4 5 S 1 8 3 0
1
. . .1 .
.- U:: -..:..:....,
i M
! iFc.iJMOLiP IAN 1 IE i
; ;P,ERC..eH'i j t| ?:«cpwi
! ij If -H^---1 ;"
Pj'^|Jg;p-| jiiy Hi
T I.
1 ' 1 1
i j i i -
! ! '
':' i.' ," !
•• ' , • H • ' ' '
p-r;- hr
f. 'TD . . r ; . . .
LJU-...LL_.*_.-44...i
, ; . LI .L ... i T
- ! ! i- 1
j44---4i-
W:T t
J 1 J. . .
...
—
1111)115999999999900000000001
2)45SI83CI?)456r890l|? 4561890
1
Zompany K®
' v&'U
i i F i i i i i i i i i i i i i i i i i i
M456I890IM456I890I!
II L ME
PERCE n
1* ='ffJ9 1* = 7 >H '='' *-''
- -- -
•
-
-
i i i i i i i i i i i i i i i i i i i i i i
1 ? 3 4 5 1890 4 5 6 1 » 9 0 1 2
-------
REPORT SPECIFICATIONS
REPORT NAME
AIR SITE BY SITE
REPORT NUMBER
PURPOSE
To provide a detailed listing of
residue analyses of air samples
FREQUENCY
On Demand
USERS
National Air Monitoring Program Pro-
ject Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
AVERAGE NUMBER PAGES
Pesticides Monitoring System Data Base
OUTPUT MEDIA
132 Column Paper
SEQUENCE OF REPORT
Major - Site Number
Intermediate - Sample Date
Minor - Residue Code
RECORD SELECTION CRITERIA
Transport Mode = A
Sample Date > Parameter Start
Date
Sample Date < Parameter End
Date
DETAILED DESCRIPTION
Input to the report program generator must include the
sample date selection range using the input data elements
Parameter Start Date and Parameter End Date.
Selected date is presented in site number and sample Date
sequence.
Report breaks occur on site number and sample date.
For a break in Sample Date the specific sample information
is presented including the sampling parameters and the specific
sample analysis data.
For a break in Site Number, a new page is generated in-
cluding headers and site specific data.
VII-29
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 2
REPORT NAME
AIR SITE BY SITE
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
data.
A new page is generated including headers and site specific
VII-3J
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
EPORT NAME
AIR SITE BY SITE
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
Site Number
Site Name
Station Name
State Name
County Name
FIPS State Number
FIPS County Number
Sampler Latitude
Sampler Longitude
EPA Property Number
Sampler Calibration
Ground Height
Sampler Area Code
Sampler Area Name
Land Use Code
Land Use Name
Elevation
Prevailing Wind Direction
Field Distance
Plant Distance
Storage Distance
Sample Date
Analysis Date
Analysis Method Code
Study Code
Study Name
Precipitation Indicator
Precipitation Amount
Minimum Temperature
Maximum Temperature
Beginning Wind Velocity
Ending Wind Velocity
Beginning Relative Humidity
Ending Relative Humidity
Beginning Wind Direction
Ending Wind Direction
Air Volume Sampled
Total Sampling Time
Residue Code
Residue Name
Trace Indicator
Residue Amount
Confidence Code
VIl-31
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME
AIR SITE BY SITE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
H-3
H-4
H-5
D-l
D-2
D-3
1-125
127-130
50-66
68-72
75-77
79-83
4-11
13-19
4-8
12-31
36-46
47-55
61-65
66-80
91-109
111-115
4-9
12-31
36-46
47-55
61-69
70-83
91-109
111-115
Constant Data
Page Number
Constant Data
Constant Date
Constant Data
Parameter Start Date
Constant Data
Paramenter End Date
Constant Data
Constant Data
Site Number
Constant Data
Site Name
Constant Data
Sampler Latitude
Constant Data
Sampler Area Name
Constant Data
Field Distance
Constant Data
State Name
Constant Data
Sampler Longitude
Constant Data
Land Use Nane
Constant Data
Plant Distance
VII-32
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 5
REPORT NAME
AIR SITE BY SITE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
D-4
D-5
4-10
12-31
36-52
53-55
61-77
79-81
91-111
113-117
36-47
52-55
Constant Data
County Name
Constant Data
Ground Height
Constant Data
Prevailing Wind Direction
Constant Data
Storage Distance
Constant Data
Elevation Above Sea Level
VII-33
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 6
REPORT NAME
AIR SITE BY SITE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-6
H-7
H-8
H-9
H-10
H-ll
D-9
D-10
3-10
13-16
19-26
31-32
36-53
62
67-71
75-78
81-84
88-89
94-95
101-103
108-110
116-118
124-126
129-132
18-35
40
43-48
55
Constant Data
Sample Date
Sampling Time
Analysis Date
Analysis Method Code
Study Name
Precipitation Indicator
Precipitation Amount
Minimum Temperature
Maximum Temperature
Beginning Humidity
Ending Humidity
Beginning Wind Velocity
Ending Wind Velocity
Beginning Wind Direction
Ending Wind Direction
Sample Volume
Residue Name
Trace Indicator
Residue Amount
Confidence Code
VII-34
-------
SYSTEM
REPORT NAME
AlR SlTF BV SlTf
REPORT NUMBER:
Arthur Young & Company
1IIMMIII222!222222S3l3i
1 ! J 4 5 6 1 6 90 1 2 14 5 6 1 8 9 0 1 2 3 4 S 6 1 8 90 1 ! 3 4
1 C f) ' tt>( 1\ REPORT
2
]
4
5
6
7 m E n ) • wwrt
. a . JAke- .. :::::::::: ( .
.» >H ( =1 ' :::::•:••<
10 ' > |} \r )/ : 1 \
n
12
1}
14
IS "
IB SMM>U SAT us ii 0 iisi >
<7 DMC: IMC ;FF£ KTKD
19 SEiii.i m »i
21 I
22 3 J / 5 : / l ! S ! ! e R ! ' \ '. 1 \ \ 1 !
23 I
24 4-
26 j-
27 ft-
28
?9 . . J ! 1 ! S / ! ! i 3 i J ? ! ! ! 3 ? 2 ! 1 ! .
30
.3' - <--:::::::::••
x - • •
j, J ................
34
35
36
37
38
39
<1C
41
42
43
44
45
46
47
48
49
SO
1 1122222222221133!
1 2 3 4 S 8 J 1 3 0 1 ? J 4 5 6 1 8 9 0 1 2 3 4 S t 1 8 9 0 1 2 1 <
333334444444<44i55S5555iS6S686«8SS61III
5 5 T 1 9 0 1 2 S 4 5 8 1 1 9 0 1 2 ) < 5 6il I 3 0 1 ! 3 4 5 8 1 5 3 0 1 2J3 <
1 iT IQJJ i . id RDt, LjT SJRl.Mfi
IbWlPllQR* FlNbLtlS2 2J1^ cpitil |C
S iVd 'BV » ifr'fi 1
i E *»* 1 1 4 ! ejgiaW1-! a!s!/!s!sl ^
1 II Ml «« B « S 8 « U 3 9 9 3 9 9 9 9 9 3 0 0 0 0 0 0 0
Nsl 1 8 9lo 1 2 ) 4 5|6 1 5 D 0 1 ! 1 4 5 6 1 « 9 0 1 2 3 4 5 6
P«0|S f AC . . 1 -
Jljrie KEKLD JEp
i n n T
too: PS /B^ -i .
KA* 1 5 8 a >|s JP'C'B! k^ulai & Xf'nE* L4-I >-L [ .
•] frr , i r • , fir i i '
U..L. ' ^tr.:i ... . i .J-lri-U . --I- -.-
IMi ;= !)S !! JJ . Lggfllfcr.iJ ."J. i , 1 1 > J- 1 -[{-U- . : i J.LM 1 1 5 ^u
lOii !:: 139. 3S '2_. .HMft-pSfiJ^ r a 72 i r i Vi: % --U - "-VUp; .!> !1,LU
wWUWmipbra 1 I p€«.SiM toi'Rf.).--! wfcij Li f UoilMUbHMHi
ELEV SM(»i: WJ? i-l-L ii- 1- II- J-i il ;L-U- -•- - '!'•- -
r r ;i ; ; ; I ^ I
. -i-L-U • -J.I..J--+. j
t r Lii i . ..i_ . . ..i,
p0$i P ' {i
"! I' MflS»T|
jnn li/piE . i itieS.ctp)
. ir',)f\ :»M«^CJ .j. . .1. |
: - - - 1 J- -:
- ------ , - - . - - - .i • s J-
•••:••::•••. . .1 -M-3 J, ,.
' J 1
.... .:!!!!:!:. ..:J<.::..:::::±i£ii4
! >Z ! • < ''-i
.!>>;,:.. N 1
i 5 !i! • I U
-•11!- " - --J- -J-J- -J- - - - -J —
. 39 y&
1 j ! >' . ! i T "*"
ffl - 8 l-aaifil Hts-^H -m-Hr-H-H -^
r.fMf!RAiW,E II l> JPPTIL ^MDly = L|<
; C*CO-|-)| L.iM. J - -SK'H
l»iK|r WA ..ft "Ml. irfr/r
i " T "
: -L; i l-h - * [ - - - -
1 , LJ., ... .....
K*?W ; WBWl .?(?- |?^ . WB .
: - •- i'l!- | i -•••
..^ ^t---H
;: i 1' ' u
tr??K>. }1 IpBaJ-lM-J-l rafJL -|J- r?T"n
IL iL-L.-uL
7r:.:44-4--t- --h
fS .W.1H9^H.1 1 U K ; UJ DJlUUli-I-^-j-. j-j i , ' (4-1-1 LI U-j-L 1 1.|.| 1 1 1 i-u 1 1 U.1J L
i ._ 1 .,_ L i i JJ i.L _i . . _L _ . ..
'""::: t: :::::::!: :
i
.1 j.i.
* i
•j
j
j
i
3 3 1 1 i M (4 » M 1 « » 5 b J5 i 5 S S 551 6 S J 6 6 t 8 1 6 1 1 1 1
56?«90I2!45«I890I 2 3 < 5 5 I « 9 ) 1 2 3 4 5 8 1 1 9 0 IJ}3
I L l-L ' 1-
.LL.l^LLLL
.
]
I
i .
1 1 1 1 1 1 1
MMM88eet8l8l>99999999930I>00000
456I890I2345SI8SOI23456I890I23456
I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
9 0 1 ! 3 4 5 S 1 8 90 1 2 3 4 5 6 1 8 9 0 1 ?
lS«. -Of !
, . _ . -
)• W3.?i .":"
t '. ^ 4
-------
REPORT SPECIFICATIONS
REPORT NAME
AIR GEOGRAPHIC
REPORT NUMBER
PURPOSE
To provide geographic summary
statistics of pesticide residue levels in air
FREQUENCY
On demand
USERS
National Air Monitoring System Data Base
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
1-50
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Major - Parameter Summary
Minor - Residue Code
RECORD SELECTION CRITERIA
Transport Mode = A
Sample Date ± Parameter End
Date
Sample Date L Parameter Start
Date
DETAILED DESCRIPTION
The format described satisfies the specifications for the
generation of three reports. These are:
National Summary
State Summary
EPA Regional Summary
Input to the report program generator must include the
following:
Sample Date range, using the .
Parameter Start Date and Parameter
End Date
Type of summary wanted, valid values
are state, EPA Region, Nation.
VII-30
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE
REPORT NAME
AIR GEOGRAPHIC
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
Selected records are to be presented in the following sequence:
Parameter Summary = NATION
sort sequence = Residue Code
Parameter Summary = STATE
sort sequence = FIPS State Number,
Residue Code
Parameter Summary = EPA Region
sort sequence = EPA Region Number,
Residue Code
Report breaks are on Parameter Summary Level and Residue Code.
For each break in Residue Code the following data is presented:
a) Residue Name
b) Sample Size = total number of samples tested for the
residue
c) Number Positive = total number of samples with non-
zero Residue Amount
d) Percent Positive = C/b*100
e) Number Trace = total number of samples with trace
indicator = <
f) Percent Trace = e/b*100
g) Minimum = lowest non-zero Residue Amount
h) Maximum = largest Residue Amount
i) Arithimetic Mean = (i; Residue Amount)/b, for all
Residue Amounts
j) Positive Mean = (E Residue Amount)/c
For each break in Parameter Summary, a new page in generated
and headings are provided including the current value of
Parameter Summary.
VII-J7
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
AIR GEOGRAPHIC
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
EPA Region Number
EPA Region Name
FIPS State Number
State Name
Residue Code
Residue Name
Trace Indicator
Residue Amount
Sample Date
Parameter Start Date
Parameter End Date
Parameter Summary
Vli-38
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME
AIR GEOGRAPHIC
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-I
H-2
H-3
H-4
H-5
H-6
H-7
H-8
H-9
D-l
4-15
76-79
27-54
25-41
43-47
49-52
54-58
4-8
10-29
2-19
22-25
29-32
35-40
44-47
50-55
59-64
67-72
75-80
83-88
Report Title
NATIONAL SUMMARY
STATE SUMMARY
REGIONAL SUMMARY
Constant Data
Page Number
Constant Data
Report Title
Parameter Summary
. NATIONAL
. STATE
. EPA REGION
Constant Data
Parameter Start Date
Constant Data
Parameter End Date
Constant Data
Constant Data
'Nation1, EPA Region Name, or State Name
dependent upon Parameter Summary
Constant Data
Constant Data
Constant Data
Residue Name
Sample Size
Number Positive
Percent Positive
Number Trace
Percent Trace
Minimum
Maximum
Arithmetic Mean
Geometric Mean
VII-39
-------
SYSTEM-
IC.IDES rMOHITQPlU6
AlR
Arthur Young & Company
1 II 1 1 M 1 1 1 7 7 7 7 ? 7 ? 7 Z 2 1 ) 1
1 7 J 4 b 6 1 1 9 0 1 7 ! 4 b 6 1 1 90 1 2 M b 6 1 ( S 0 1 2
! £J/»^77 H5M(j HUH/
3 S - - - - -
4 . (EECKFH
5 . . . M»T
6 fgW ; < T |
7
9 RJESi DJE H' Z* JiC.
1 1 j
•2 t i ijgj [J2J
'* IF ' • : • : ' : 22?. . . !?''
15 ! ' " | jijjj ' j»«
16
17
IB
1*9
2O
Zl
22
23
24
25
~ 26
27
2B
29 " " "
30
31
32
33
34 "
35
36
37
3fl
39
40
11
42
43
44
"45
46
47
4B
49
5O
II 1 221 2 1 I I 2 i i J 1
1 7 J 4 b 6 7 I 9 0 1 7 J 1 b E 1 S S 0 1 7 J 4 b t 1 19012
J ! 1 J 1 1 1 4 4 4 4 4 4 4 4 4 b 5 b i b S b b b b6 51666 6 6 6 6 6 I / 1 1
4bSla90IZ3(b$IJ90l?I4b6ill90 ljt\M 5 ( l|l 9 1 1 l\'.
. 8h~KCiicRiiiii~.PKC6iw T ' I" i.'Pflit
WDIMS Cf E£S[i;MD>E Ii 63 l lUl i . J_i 1
... ... . _L . K 1 [
;seff 3«.|00 1 pft&'.'O 9999*. 0
?!??.££ .529? -I9fe-ep,\ 232fl-4- 92tS?:-S
iR-Si - Hj! |h:S jtt^ ^j.§
ij , .
-
i i
i . ,
_i 1
•:::- .'l}:!.
.. |j ;
1 i i
1
1 1
4 S
1
i
!
• i
1 1
rli i i (
;*
i
, ARI.TI
; _ . M.EAT
! 999J.'t
^^y&w • f,
i , * t
1 T '
i . 1
i ' ' '
; . i .
'!i i
' j ' ( •
i
1 r i
J ' :
1 .
' ' I . ^
l " i i"V!~!
.... -i-. J . ,
- i iVt^""--' :-
1 1 i * ;i "
; , | i
i- ^!"
i i
lil!il!4444444444bibbbbbbbbSt616656S6MI/
l4bS7S90l?J4b6llSO M4bEI«90IZJ4btl»90l73
: ! i
i ii
!
1
1
11
MM
(119
II i i i i i i i i i
1 t t 1 l|l 1 11999999999900000(000
\.\ t :
i i ; i L
i i ! ! ' i . : ;
i^; L iii
. .PO.SlLMiE 1
!.!:i[ f 7iiH-
31 1 ^v*i joi !
Ma.
:j!i "f
:• ' ! 1 1 [
i . , . a.LL . i [ 1 j
ifrr:rlf " it
''• II o_ 44- 1L
l.JI L..-1 L ...
, • I \ [
Tt'TT i
i ! J
-
--
1 1 1 1 1 Ml
I111MIJ1S999999999000000000
1 ? ! 4 b « 7 1 9 0 1 ? J 4 b B 1 1 9 0 7 ) 4 b E 1 1
^y/u
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 Mill II I2222I22MM1I
0 1 7 ) 4 b 6 1 1 9 0 1 ? 1 4 b 6 I 1 9 0 1 7
I 1
t
-
-
Ill 1 1 l 1 1 II 1 1 1 1 II II 1 II 1 1
9 1 1 1 J J t J 2 1 1 t 1 i 1 I J
9 0 1 ? 1 4 b B 1 1 9 0 1 7 1 4 b 6 1 1 9 0 1 7
r-«- --- Ftilil I ill h dl tliU Ifil l.iu
— I nlil in Dl (him it lnii>
-------
REPORT SPECIFICATIONS
REPORT NAME
ESTUARINE STATE SUMMARY
REPORT NUMBER
PURPOSE
To provide a state summary of pesticide
residue levels in estuaries.
FREQUENCY
On demand
USERS
National Estuarine Monitoring Program
Project Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
OUTPUT MEDIA
132 Column paper
SEQUENCE OF REPORT
Major - Residue Code
Intermediate - FIPS State
Number
Minor - Sample Type
RECORD SELECTION CRITERIA
Transport Mode = E
Sample Date >_ Parameter Start
Date
Sample Date <_ Parameter End
Date
DETAILED DESCRIPTION
Input to the report program generator must include the
Sample Date selection range using the input fields Parameter
Start Date and Parameter End Date.
Report breaks are Residue Code, PIPS State Number, and
Sample Type.
For a break in Sample Type, the following information is
presented:
a) Sample Type Name
b) Sample Size = count of samples tested
c) Number Positive = count of the samples where Residue
Amount > 0.
d) Percent Positive = c/b*100
e) Minimum = smallest Residue Amount (non-zero)
f) Maximum = largest Residue Amount
g) Arithmetic Mean = (E Residue Amount)/b
h)
Geometric Mean-(antilog yV.oi A/here Y- - log y.
where y.=
x^individual residue amount.
VII-41
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 2
REPORT NAME
ESTUARINE STATE SUMMARY
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
For a break in FIPS State Number, the following inform-
information is presented (D-l):
State Name
Column headers for detail (D-3)
information
For a break in Residue Code, a new page is generated with
the new Residue Name presented as part of the page header.
VII-42
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
ESTUARINE STATE SUMMARY
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
FIPS State Number
State Name
Sample Date
Sample Type
Sample Type Name
Residue Code
Residue Name
Residue Amount
Parameter Start Date
Parameter End Date
VII-43
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME
ESTUARINE STATE SUMMARY
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
H-3
H-4
H-5
D-l
H-6
H-7
II-8
D-2
1-125
127-130
49-65
67-71
73-76
78-82
4-18
20-37
4-8
11-29
2-19
22-29
29-33
35-40
44-50
53-59
64-70
75-81
Constant Data
Page Number
Constant Data
Constant Data
Constant Data
Parameter Start Date
Constant Data
Parameter End Date
Constant Data
Residue Name
Constant Data
State Name
Constant Data
Constant Data
Constant Data
Sample Type Name
Sample Size
Number Positive
Percent Positive
Minimum
Maximum
Arithmetic Mean
Geometric Mean
VI1-44
-------
SYSTEM
PESTICIDE?
RFPnnTMAiuiF ESTUftRlhlE SnVTC SummftRV REPORT MIIMRFR. PM^fC
MIIIII iii222i22?i{?JS)
IM44SI890IM446I890IM456IS90I!
- ; »»f'fcf» HF&TJI.
7 ]
! . >SlCLE PI
. .9 jfqciEs :m. ..10.
--r?- T
IZ. ::::::::::::::::!. .!!«....!!!
IS
16
17
IS
19
20
21
24 _ ___.
--
27 "
28
29
3C
31
32
33
34
J5
36
37
38
" 39
40
4J
42
43
44
45 - - -
~ " 46
47 ... .
~~ 48 ...
49 " " "
, , ,,,{11111 til I 1
) i J ) ) i 4 4 4 4 4 4 4 4 1 4 4 4 4 S 4 4 i 4 \>\M 66 6 ft t t G t ? II
44il890IM4S6M890l?J446l 6J9JC JJ2 I|ilS|iljl|t|3jO 12
Irfiisinn ittft/ftiHi jtouiiH
. 1 FLf ] ! F ' " ( t iPlltLs SSI. D^jf EiaT
I". . "' 1
J^a.
in
i'4t,(
but
ipi
l-!r
TOOL
. i '
ll 1 18 6
1 1 8 9JO 1
>. W/ji
Arthur Young & Company ^W
it t
T--
^p
9 :
.' i i
! i
1 »
it
t
I
J ' i '_i ' ' ' 1 . ! '• i
in ye . ..iBiiSiB . iL^MiT*],,!. fie«Mj.
f£,«tHi n4_|l 1 HI; 11, {.ujt^-i^.: : .i^rf
)». :t JH.b^ wv.cofi wJ.ooJ
! 4 l'
i | 1 •
41 i i
i - -| i-|- i.
l J '
& J i ! .
l
L
_. . i ..._._».._-,
.... ,
, WV.'oda
••*
Iff
1 1 L
': i!
1 ' ' i
• ::
i s.*
i
f
I '
1 i ! ' •
.- - .. ... .j.. ..,..;. ,.r
' ! LI ! .
1 I '
1
i La. - -
1
i |
. . _ . . t
. J
1 J J 1 i ) 4 44 4 4 4 4 4 4 4 4 4 4 S 4 5 5 4 5 48 6 t 6 « 6 S 6 6 S 1 1 1
45SIJ90l?1456l«90l?i446le9CIM45Sll90l?
» - • • i
. ! '
... ; |
i
1 i
!
i
i
i i l
J 4 5 S
1
! 1
1 1 1 t 1
1 1 9 0 1
i |
1 I
i
1
ii
r!
-j
i
• 1
1
|
1
t 1
1
1 1 i 1 1 1 1 1 1 1 1
J 8 5 9 9 9 9 9 5 9 9 9 0 0 00 0 00 0 0 0 1
)3I)I?J446I890I?1446!890
-1 - -
1 , )
-H- - L
1 i
!
l !
i
i .....
i
i
j i
i
i
-:-L . :'(!:-:'.
• ! t
_JJ
- L
;-M
i
i
[
ttti
2 I 4
i
i
...LJ
11
4
L
i
6
t
1
i I
- :.
j . . . .
....
•
1 1 1 1 1 1 1 1 1 1 1
i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
I!)446I190I2J456I890I?
Pffct- Z2J3
-• -
i i i i i i i i i i i i i i i i i i i i i i
1 1 1 1 1 1 1 1 1 1 l { { 2 2 2 2 2 2 3 1 1
-------
REPORT SPECIFICATIONS
REPORT NAME
ESTUARINE EXCEPTION
REPORT NUMBER
PURPOSE To provide a listing of sites for
which residue levels for a particular residue
and specie exceeded a specified value.
FREQUENCY
On demand
USERS National Estuarine Monitoring
Program Project Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Major - Residue Code
Intermediate - Site Number
Minor - Sample Type
RECORD SELECTION CRITERIA
Transport Mode = E
Sample Date >_ Parameter Start
Date
Sample Date <_ Parameter End Date
Residue Code = Parameter Residue
Residue Amount > Parameter
Exception
DETAILED DESCRIPTION
Input to the report program generator must include the
Sample Date selection range using the input fields Parameter
Start Date and Parameter End Date.
Additional input includes a table of exception levels for
each pesticide residue using the input arrays Parameter
Residue and Parameter Exception.
Only those sites where a sample was tested for a residue
found in the Parameter Residue array and whose Residue Amount
exceeds the associated Parameter Exception are listed.
VII-4u
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE ~
REPORT NAME
ESTUARINE EXCEPTION
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
Sample Date
Site Number
Site Name
State Abbreviation
Analysis Date
Sample Type
Sample Type Name
Residue Code
Residue Name
Residue Amount
Confidence Code
Parameter Start Date
Parameter End Date
Parameter Residue
Parameter Exception
Vli-47
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
ESTUARINE EXCEPTION
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
H-3
H-4
H-5
H-6
H-7
H-8
H-9
D-l
4-125
127-130
50-66
68-72
74-77
79-83
4-18
20-37
4-19
24-30
4-14
19-39
43-44
47-54
58-65
68-85
87
89-95
99
Constant Data
Page Number
Constant Data
Constant Data
Constant Data
Parameter Start Date
Constant Data
Parameter End Date
Constant Data
Residue Name
Constant Data
Parameter Exception
Constant Data
Constant Data
Constant Data
Site Number
Site Name
State Abbreviation
Sample Date
Analysis Date
Sample Type Name
Trace Indicator
Residue Amount
Confidence Code
VIl-43
-------
SYSTEM
E5.TIC.IPeS
REPORT NAME
EsTOftRlME
Arthur Young & Company
VO
.. !.,4,i;:4i"!iiiiiiiiiiii:
! i i il ' > Jl 1 ....
' Sire i L i f E R s i [E Nfl ' E
10
15 " - . - -
16 ..----.-
17
18
19
20
21
22
24
'J
26
27
28
3(
31
32 --. -
'" 34 '
35 .....
16 " "
J7
38 " "
4C
41
42
43
44
"45 " "
™ " 46 " - -
~" 48 '
49
SO
1 81456 1 690 ! M4 t ! «' 9 1 1 1 4 1 6 1 t I ' ? ' '
J 1 1 1 1 4 444 4 4 4 4 4 4 S S 55 S S S 5 5566 668 6 B 6 6 6 ill 1 II 1 ill II « 8 1C t t 1 41 193999399910001)000001
S 8 1 « J 0 1 U 4 S « 1 8 S 0 1 Z » 4 S t I J 9to IJM 4 SIS l|j|» oil 1? JJ4 5 6 1 1 9 0 1 Z li 4|i 6U1 9 0 } 1 4 S C 1 1 » 0 1 11 4 5 6 1 8 3
f ijcyfti JSnfi^tlE ^Hi|re^iKa iRROjsJEiflWjJ
/R&iWlTi^jrifeK^ . L Ll
-|| -fr- --1 -:[• ••-!••• r: M H ! '; il ' L""
5 1 i • 1 1 JAill 'Ll/S'l^1 i.1 lil, SXC. E'PT I'O'j. \1\fi t k T
•Mil . JMftre .. LintL,.LU"s>.iCl.ES. i. . : ; ~> LjJl C'VEL, L " FoVU
...., jr ir ^L^|';;::::;'-.^" ttJMa "i-^-Mi
^ • 1 r .i r ! ' : • • i ; i i
i - JUUn- ' .' i !i 1 -1--
! 1 ! h . i , : ' : i | j
! \\--M ' •!,!; i ii -- '-!-- --
- -ii ,i ' : ::• - -L- H
.•:. :: : j :,:!•:• 1 - (
1 '•
...... -»li'i ^ 'I i
H T i t •' r ' ' — -i. .. . . -
J ' ',.'•' I , • --•
---- + H- •-.- -• •-, p, .-r-^-r- | - --- -i •
i i ~~i T! ' ' F^r t~i r f '
J_ HI ' • ' 1 1 n i ' r '
' "u" IJ"M'! [ ; i tj_" ' " -- -h-
; I]l .iij . .: , j i , , .
1 1 f .- . JJ-i : i > i , 1 j . T
1 j 1 i I ' > i ! II '
! .' : ! i
i 1 I! i i ; i l i
' J4-L :| '
- - - - !--••{ - - ..,.-..
j.
. . .. _
ll))<444«44441555S55555566666St6S6MIIIMIM1188!!B!l«99999999990000000000
SGM30I 145SI830IM456l890IM4Jtll90PZ)456l89lOIM456l8SOI?JI56l!90l?)456ll9
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 j 1 1 1 1
0 1 Z 14 5 6 1 8 9 0 1 ? J 4 5 6 1 J 9 0 1 ;
_ _
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
MlliMlll??222222223J)
r-4 Fold dark ai dulled Ii
-------
REPORT SPECIFICATIONS
REPORT NAME
WATER GEOGRAPHIC
REPORT NUMBER
PURPOSE
To provide a geographic summary of
pesticide residue levels in water.
FREQUENCY
On demand
USERS
National Water Monitoring Program
Project Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
50
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Major - Parameter Study
Intermediate - Sample Type
Minor - Pesticide
RECORD SELECTION CRITERIA
Transport Mode = W
Sample Date >_ Parameter Start
Date
Sample Date <_ Parameter End
Date
DETAILED DESCRIPTION
The format described satisfies the specif ications^of two
reports.
These are:
STATE summary and
EPA Regional'summary
Input to the report program generator must include the
following:
Sample Date Range, using the Parameter
Start Date and Parameter End Date
Type of Report wanted, using Parameter
Summary, valid values are state and
EPA Region.
For each new occurrence of STATE or EPA Region (dependent
upon input), a new page is generated with the State Name or
EPA Region Name and a Report Name printed as aprt of the 7
header lines.
VII-ji)
-------
REPORT SPECIFICATIONS (CONTINU:
PAGE 2
REPORT NAME
WATER GEOGRAPHIC
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
For each new occurrence of sample type, a detail line (D-5)
is printed with the Sample Type.
For each pesticide, a detail line (D-6) is printed with
the following information:
a) Residue Name
b) Sample Size = count of the samples tested for that
residue
c) Number Positive = count of the samples with a non-
zero Residue Amount
d) Percent Positive = c/b*100
e) Number Trace = count of the samples with the Trace
Indicator equal to <
f) Percent Trace = e/b*100
g) Minimum = lowest positive (Trace Indicator = blank)
Residue Amount
h) Maximum = highest positive (Trace Indicator = blank)
Residue Amount
i) Arithmetic iMean = (E Residue, Amount)/b
Geometric Mean=(antilog y)-, 01,where y= ^
where yi= Cx^O.Ol), x^individual residue amount.
VII-jl
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE i
REPORT NAME
WATER GEOGRAPHIC
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
EPA Region Number
EPA Region Name
FIPS State Number
State Name
Sample Date
Sample Type
Sample Type Name
Residue Code
Residue Name
Residue Amount
Trace Indicator
Parameter Start Date
Parameter End Date
Parameter Summary
VII-52
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME
WATER GEOGRAPHIC
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
H-3
H-4
H-8
H-9
H-10
D-l
D-2
4-125
127-130
58-73
49-65
67-71
73-76
4-8
10-29
2-19
3-20
22-25
31-34
36-41
47-50
53-58
62-68
71-77
80-86
90-96
Constant Data
Page Number
Report Name
Parameter Summary
. STATE
EPA REGION
Constant Data
Parameter Start Data
Parameter End Data
Constant Data
Area Name
Parameter Summary
. STATE
. EPA REGION
Constant Data
Constant Data
Constant Data
Sample Type Name
Residue Name
Sample Size
Number Positive
Percent Positive
Number Trace
Percent Trace
Minimum
Maximum
Arithmetic Mean
Adjusted Geometric Mean
Report Title
'STATE SUMMARY1
'REGIONAL SUMMARY1
Area Name
STATE NAME
EPA REGION NAME
VII-53
-------
SYSTEM
T^STKUTSE
REPORT NAMF WAlER (aEO&RftPrtlP. REPORT MIIMRER-
, , , , , i ii t I 1 1 t t t 1 j
I!M5SIJ901?)456I8901?)456I«90I!
. ! ca/ai/: ; i i :iiu
- - • • -
- 1 - jjji;-k " """ l"
6
8 >A*(Pi.i ITPt PflXilE
- § MSI OiUF itirED 5 |1C " Kt
2 | | j | (,€/ | >
? ::•-:- i .i!«!....li
' s •'.::.: ill ' Ii
- . ' ' ??!!...!
16
17
18 . ti.i ! i ii.!> Nl 1 .
. I9 f T » ?>[_...»?
?° 9 $91 33
<2I 5 » i J ~ " ~>3
M 22 ........
I -- .
2<
LT. *
26
27
is
29 "
3C
31
32 .-.-.-
33
34
35 ' ' '
36
57
18
39 "
40
41
42
43
44 - - - .
45
46 " "
47
"48 - - - •
49
50
11111111112227227222111
* S 1 0 21 16(89 23456189012
S1331il4444444444i3SSi} ilili 516 f i 6 6 i t C 8 S 1 1 II
S 4 S 6 1 8 9 0 1 2 1 4 } t r t 9 0 1 2 3 4 i 6|t I 9 0 IJ2 314 S S lie 9 0 1 2l
1 1
14 i
» ffi 1 0 (J Si ill IJGR.^0 IllTJO «Wfi
. " R E P|0 « T i rtjC Pefe^D'i! _15 /99, ii;M
• -•• frtrt-f1^ lj!:
I"! JjH-'!' '• '
L! 1 1 , •
1 III 88
« 'Iffl'.
"M
1
POSITIVE . . ...!iwc|? f j.!i_J!Atlfte I. ,I.,A
• Piicy! re. peAte;m ^Hifeftu^ ..LOW,. i
J"! i ' 1
j . "I ' •! ! • ] ;
j J ; J^ . ){ !gj; ?!??,• !C»o j S3BJ. JcoLI ?2*
M Jy}- tt ..??5? 9*9.00. _H?pl-we>ft i W
1 1 1 1 1 -i , 1- : :
i i i JJ L .LI. 1
i ' i r I
: ;••• ; ]
i.QPO. 9&f
fc-oo.e, y>
>.-ooo . ttf
'•' i! !
. ! 1 ' 1 :
'« 3 2h • '• '• \l'.' \W-PA 9&&-\odo yy^.fi
*2 ^'|-cc ilto ifi^ ^3' ^^ ^^*
- '-" Iff! i '"'
: . * ~ hjJ"'
T i
r
?.fl
°A ; 9ft
«P !&!?!
! • ! i
- - , > , i V- -
... . . j . ,...,.,,
.[ . .} _L J • :
L 1 iJ
.... _1.|_J .
1 4 !
4- -L J :
- - • i
.... 1 1
i
-
13111 J ) < 4 ( 4 4 1 4 4 1 4 5 5 i S i i 5 5 5566 it t » 6 6 S 1 I III
J 4 S 6 1 8 9 t 214S6ll90li34Sfl8>Oli!4i(l690 2]
i|
. !
: i
i
4 S
i . i j
• ;i i
! '
t
1
ii
1 1 1 1 8 8 1
(189012
Arthur Young & Company &©
Ui 1 1 1 1 1 1 1 1 1 1
Ui:3339S333300 00 0000001
.,. r 9 9 0 1 2 3 4 S B 1 1 9 0 1 2 3 « 5 t I 1 9 0
1
I '
1 • L i 1 . i —
i • iii
te^.^rL in^i^' .
i i i .. 1 : , J 4-
i ii MM
iL.Lll N L " -
\m~ iil:?R ^T
>.bb«5 ?n-So,o
'; Ml i
: ," M ; -
. .. _ ! L: IJL
. U • r i
'• !'-rf . ; - 1
"vi iJii:r;
' ' i
• iil i ! " \~ "".
1 - 4
• i
p|M •
-
.....
• 1 1 1 1 1 1 1 1 1 1
888ie88S99J9999390«OOOOOOOOI
1 4 5 ( 1 8 >0 1 2 1 4 J ( 1 8 90 ?145SI890
1
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 2 2 2 2 i 2 2 2 2 2 1 1 1
I214S(II90I2345(I190I2
•
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
IIIIMM72222222223I1
234S6I890I214SEII90I2
-------
REPORT SPECIFICATIONS
REPORT NAME
WATER SITE BY SITE
REPORT NUMBER
PURPOSE
To provide a site by site detail of water
sample analyses
FREQUENCY
On demand
USERS
National Water Monitoring Program Project
Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticide Monitoring System Data Base
AVERAGE NUMBER PAGES
150
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Major - Site Number
Intermediate 1 - Sample Date
Intermediate 2 - Sample Type
Minor - Residue Name
RECORD SELECTION CRITERIA
Transport Mode = W
Sample Date >_ Parameter Start
Date
Sample Date <_ Parameter End
Date
DETAILED DESCRIPTION
Input to the report program generator includes two para-
meters which represent the dates the sample date must satisfy.
These are the Parameter Start Date and the Parameter End Date.
Each page of the report presents sample analyses data
cor one site.
Page headers include the following site specific
information:
Site Number
Site Name
Site Latitude
Site Longitude
State Name
VII-55
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE
2
REPORT NAME
WATER SITE BY SITE
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
For each new occurrence of Sample Date, a detail line
(D-l) is printed with the following data:
Sample Date
Sample Type Name
Sample Time
Residue Name
Trace Indicator
Residue Amount
Confidence Code
For each new occurrence of Sample Type, a detail line
(D-2) is printed with the following data:
Sample Type Name
Sample Time
Residue Name
Trace Indicator
Residue Amount
Confidence Code
For each new occurrence of Residue Code a detail line
(D-3) is printed with the following information:
Residue Name
trace Indicator
Residue Amount
Confidence Code
VII-J6
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE
REPORT NAME
WATER SITE BY SITE
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Mode of Transport
Site Number
Site Name
Site Latitude
Site Longtitude
FIPS State Number
State Name
Sample Date
Sample Time
Sample Type
Sample Type Name
Residue Code
Residue Name
Trace Indicator
Residue Amount
Confidence Code
VII-J7
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE ,
REPORT NAME REPORT NUMBER
WATER SITE BY SITE
OUTPUT DATA ELEMENTS
LINE
H-l
H-2
H-3
H-4
H-5
H-6
H-7
H-8
H-9
H-10
D-l
D-2
COLUMN
4-126
127-130
49-65
47-71
73-76
78-82
4-11
13-20
4-13
15-34
4-12
15-34
4-13
15-34
4-9
15-34
4-11
20-30
43-46
57-64
83
91-97
106
20-30
43-46
57-64
83
91-97
106
ELEMENT
Constant Data
Page Number
Constant Data
Constant Data
Parameter Start Date
Constant Data
Parameter End Date
Constant Data
Site Number
Constant Data
Site Number
Constant Data
Site tatitude
Constant Data
Site Longitude
Constant Data
State Name
Constant Data
Constant Data
Sample Date
Sample Type Name
Sample Time
Residue Name
Trace Indicator
Residue Amount
Confidence Code
Sample Type Name
Sample Time
Residue Name
Trace Indicator
Residue Amount
Confidence Code
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 5
REPORT NAME
WATER SITE BY SITE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
D-3
57-64
83
91-97
106
Residue Name
Trace Indicator
Residue Amount
Confidence Code
VII-59
-------
REPORT MAMC S 1 TE ~R V SlTC WATER REPORT MIIMRCR.
1 mn
1 1 1 1 1 1 1 1 1 1 2 2 I i II 2 2 22 1 1 1
IMI56I890IM416I890IM456I890I!
I OJ/»l.(77 fEPSRTC)
2
3
f . . 3 1 ! ( t C • ? '
7 IniCirnri .Ml 1 '. 1 3
8 5 T (jjl 6 '
id " ' I
M ilfplt tf it 5 1 pf if [HE
13
15
16
ie
19
20 f?^?1? 1 ? i » '
21 1
22
24
25
?6
28
29
30
11
32
'ij
34
35
" 36
37
38
39 - - - -
41
43
44
45
46
47
48
49
1 1 1 1 2212 It t t tl J 1 1
JI14i(ll90l2)4S(lllOI2)4Stll90II
) 1 1 J J i 4 4 4 4 4 4 4 ( 4 1 S S 5 5 5 5 5 5 5 5I« 6 6 5|t i 6 t 6 6 I ' ' '
t 5 E 1 1 3 0 1 2 J 4 i 6 1 1 9 0 1 2 1 4 5 6 1 1 9 0 1 i M 5 6 1 1 9 0 1 2[i
ftHMMiAi k! l['^. pcut rjoKilil
.....: ""*1141 ''tB^SpK11;
i .... -j — i i:i.
.. .. !-MLi-j" -,
1 i4-iJ-ii-H • '
TIM ;( ;irP|i,i L. '•(*.! rio^ ,TfiiT,CD
1 1 III It
1 S 6 1 IB 90
s SjYlsnE
H-.RO1 ••»%/
• j | •
i
• ' i
. . i l ,
.. ^ , -. !-^~!-iL il^Jl1 .
-UJ3-. ; i -} --U44- .;K :
X* J . J j _ Vj 1 1 A . 1
'3/ 1-fJ- V I"'"1"1 ^ "'
'^'' S)l" ~'T!"!
• - - - i - j 1 1 ' -^~
1 . !- ; i .
...L. ' -LJ 1
-!:" - ;:3:r'.
T
T-!W-j
... , j_. 1. 1 .. .
-- -- ' -V- ' *"! -:
i |j_. _,. 1 .
. .1 ....
t 1
...... j.
... u_ .
• -
45611)0 J 1 4 5 6 1 8 9 0 1 ? < 5 6 1 1 9 0 1 2 1 4 5 6 1 8 9 0 1 ? 1
(\ ,
* •»
-• -i-l j t
• ! i '
1 j ,
• t
i !
;
• »
i
1 1 1 1 1 1 8
4 Si 1 19 0
Arthur Young &
1 1 B t 888 J8!9999999990»0«00000
1214 iJ6ll !9«l?14S6r890IM456ta
«]
«| 1 . . -. .
1 ' 1 -
i . !, i ,
i ,1 • -
ji . j. _j._L.. . . j -
y^cfc ctf E n.r.fij^T i c > .: :>ni
-f1 — H — 1-| h4-J L
_Ljj . L 1 1 1. . . .
ill f T -" ,
K i 3Rn Q^Q . n
X Jp'j loct <
:.."."!
;:,:!-> "ftt--
j " l ' r
- .4'jH_ ni k -
*f : - i- -• - 4i
•;! .
i L .
, . j. .
11 » .
i |||
n; t •
—
....
1 1 1 1 M 1 1 1
11818181899999999990001)1)0000
1 ! M S 6 I 8 90 1 M 4 5 6 1 8 9 0 1 ? 456 1
Company W$7
^.^'LJ
i i i 1 1 1 1 i i i i i i i 1 1 i i 1 1 i i i
IZIIS6I890I2J456I890I?
rCC
ii i i i i i i i i i i i i i i i i i i i i
IIIIIIIIIIIi2222iI?211i
1 ? ) 4 b 6 I90I214SC 19 7
i-^ • ••- Fold lurk 01 i1 MI al i lull PI I line
-------
REPORT SPECIFICATIONS
REPORT NAME
WATER PESTICIDE
REPORT NUMBER
PURPOSE
To provide a detailed report of water
sample analyses for a particular pesticide
FREQUENCY
On demand
USERS
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
20
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Major - FIPS State Number
Intermediate - Site Number
Minor - Sample Date
RECORD SELECTION CRITERIA
Transport Mode = W
Sample Date >_ Parameter Start
Date
Sample Date <_ Parameter End
Date
Residue Amount >_ Parameter
Detail
Residue Code = Parameter
Residue
DETAILED DESCRIPTION
Input to the report program generator includes the
following parameters:
Parameter Start Date
Parameter End Date
Parameter Detail (must be .000, or .001)
Parameter Residue
These parameters are used for sample selection. A Para-
meter Detail value of .000 will print all findings while a
Parameter Detail value of .001 will print only positive
findings.
Page Readers are constant throughout the report.
VII-01
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 2
REPORT NAME
WATER PESTICIDE
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
For each occurrence of a new FIPS State Number a detail
line (D-l) is printed with the following data:
State Name
Site Name
Site Number
Sample Date
Sample Type
Sample Time
Trace Indicator
Residue Amount
Confidence Code
For each proceeding record for that particular site,
a detail line (D-3) is printed with:
Sample Date
Sample Type
Sample Time
Trace Indicator
Residue Amount
Confidence Code
For each occurrence of a new site a detail line (D-2) is
printed with the following data:
Site Name
Site Number
Sample Date
Sample Type
Sample Time
Trace Indicator
Residue Amount
Confidence Code
VIl-u2
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE ,
REPORT NAME
WATER PESTICIDE
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
FIPS State Number
State Number
Site Number
Site Name
Sample Date
Sample Type
Sample Type Name
Sample Time
Trace Indicator
Residue Code
Residue Name
Residue Amount
Confidence Code
Parameter Start Date
Parameter End Date
Parameter Residue
Parameter Detail
VII-o3
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME
WATER PESTICIDE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
H-3
H-4
H-5
H-6
H-7
D-l
D-2
4-126
127-130
59-74
49-65
67-71
73-76
78-82
4-11
13-30
4-10
12-37
3-22
25-44
47-54
60-67
70-81
89-92
103
111-117
126
25-44
47-54
60-67
70-81
89-92
103
111-117
126
Constant Data
Page Number
Constant Data
Constant Data
Parameter Start Data
Constant Data
Parameter End Data
Constant Data
Residue Name
Constant Data
Detail
Parameter Detail
.000
.001
Constant Data
Constant Data
State Name
Site Name
Site Number
Sample Data
Sample Type Name
Sample Time
Trace Indicator
Residue Amount
Confidence Code
Site Name
Site Number
Sample Date
Sample Type Name
Sample Time
Trace Indicator
Residue Amount
Confidence Code
Detail
'Zero and Positive
Findings'
'Positive Findings
Only1
VII-U4
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 5
REPORT NAME
WATER PESTICIDE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
D-3
60-67
70-81
89-92
103
111-117
126
Sample Date
Sample Type Name
Sample Time
Trace Indicator
Residue Amount
Confidence Code
Vll-o5
-------
SYSTEM
REPORT MAIUIC _Wf\T^ R nESTlC.lhC REPORT MIIMRCD.
1 M 4 5 6 1 1 90 1 ? ) 4 i 6 1 t 9 0 1 M 4 5 6 1 » 9 0 1 !
H> ' £2/)£J7'MC Ppfi T ( 1
ijj-..._. ........
M f . Bis 1 DU? • " •---:• .1
H.jrs i ~ r M i : 4- - -•
6
7
U-) 8 i ijui ! lie i \>
V-j 10 ) ) )......
p.j 1,
P-J 12
13 +
»jj 14 • • - i a ::::..
15
16
17
18
19
2O
22
23
24
25
28
29
3O
31
iz
~ 34
35
36
37
38
~ 39
10
11
42
43
14
45
46
17
48 "
49
50
IIIIIIIIIIM2222222IIII
12 4161190 ?)4SCII90jM4ieil90l?
I 1 1 i J 1 4 4 4 4 4 4 4 4 4 4 i 5 55 i 5 5 S S it ! 6 l|t i 1 6 6 i 1 II
4 i 6 1 J 9 0 1 ! 1 4 5 1 1 « 9 0 1 ! J 4 5 6 I 1 30 l|?}j4 5 6 JJl|9lO 1 2J!
"... :?M'°"t |^U^^
. s, P'tnp "fppgfiQif
--- •- - f-t-; 7 -' r j •
.... . . ill ! j ' ' .
i i
1 1 iii
|< 5 «|l
g Y
' t
XL
n
»J4/s
..
.
Arthur Young & Company ^K)
g t »
i i
, !
s i El » ». I |A> tie mrE j isAnp.Le IT.VPJE ; T,
< < ^ " 3 '" ^31/Tt ! b< - ' • " ^
?!^I/JM- !a ,:::.-,,'
< ^ I'^Ji^^'lj-b-^'i1 :
! ' -|M UiJ"
1 I 1 " ' 1 '
-::::: - "^^.i
rr 1 i
i -
j i
•
,
' i ' {
• -\l
' - 1 1 _
i , ,
>
i
,--!'-: r
i ^ r - \
-f-H i j
i 1 t
i i .. ..
• : - jfjjji
_ . . . _ _
.......
j5ji!ii;;;;;j2:;!J?)!4s!!?iiS!!!;ss?S5{:!!
1
j!
i I
i i
4 S i I
:•;-
'. i
. i
i :
1901
i ,
1
I
i
' t
~i
i ,
i
-J
ai ei
2 1 4
|l tjl 829959999)9000000001)01
-•
'
! L L i . 1 .
: ;
i i ;jj
sypjj -j
L L . . 1
1
1
i -. . •
1 i '!
,
1 ! ' ! "
-r\\ - - frt- •
• • • i r
ri i — h ••
!"fft[» JlllL" •
LL 1 . .
• j. [.
i -
-
-
1JI899939S99S90000000000I
ilBlO ? 1 4 5 S 1 S 9 0 1 ! i 4 S 6 ) I 9 0
II 1 1 1 1 1 1 ill 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 2J2 2 1 it I 1 ? 2 J ) S
I214SGM9 Oh 2145(119012
M,,, ,..,
"""
C,C> T Rtt T 1 » J ' SKF 1 1 b jc E
9)1 .pc c '
}2a!'ta» i
....
i i i i i i i i i i i i i i i i i i i i i i
I?)45SII90I2)4SI1I90I2
r^ - - Ffllfl ll II t .11 iktlll fl hrli
-------
REPORT SPECIFICATIONS
REPORT NAME
HUMANS GEOGRAPHICS
REPORT NUMBER
PURPOSE TO provide summary statistics by
geographic summaries of Pesticide Residue
Levels in Humans.
FREQUENCY
On demand
USERS
Nation Humans Monitoring Program Project
Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
AVERAGE NUMBER PAGES
Pesticides Monitoring System Data Base
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Major - Parameter Summary
Level
Minor - Pesticide
RECORD SELECTION CRITERIA
Residue Amount> Parameter Amouni
Transport Mode = H
Source = Parameter Source
Parameter Start Date <_ Sample
Date
Parameter End Date >_ Sample
Date
Sample Type = Parameter Sample
Type
Residue Code = member of Para-
meter Residue List
DETAILED DESCRIPTION
Input to the report program generator must include the
following parameters:
1) Parameter Summary - i.e. summary level wanted (National,
State, Hospital, Region, Census Region , Census Division)
2) Parameter Date Range - i.e. period of sample collection
to be reported
3) Parameter Sample Type - i.e. tissue type to be reported
4) Parameter Source - i.e. HANES samples or regular survey
samples
5) Parameter Basis - valid for Adipose tissues only. i.e.
residue levels to be reported on a % lipid extract or
wet weight basis
6) Parameter Residue - i.e. which residues to be reported.
(Default is all residues tested)
7) Parameter Geography code list - Dependent on Parameter
summary, i.e. a list of which states, Hospitals, Regions,
etc are to be reported
8) Parameter Amount - All samples use JOOO, Positive .001
For a break in Parameter Summary, a new page is generated '
and header information is printed including the current summary
level name (a particular state name, hosptial name, etc.)
VII-o7
-------
REPORT NAME
Humans Geographies
PAGE 2
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
For each break in Residue Code the following information
is oresented:
For other than PCBs
a) Residue name
b) Number of samples tested for that residue
c) Number of samples where residue was detected
d) Percent of samples where residue was detected = c/b*100
e) Number of samples where residue detected but immeasurable
(count of samples of trace flag on)
f) Percent of samples where residue detected, but
immeasurable = e/b*100
g) Maximum = largest residue amount
h) Minimum = smallest residue amount
i) Arithmetic mean = (E residue amount)*b
j) Geometric Mean = {antilog y}-l, where y=/ Q , ,
i=l y Yi
where y.= (x^l), x^individual
k) Standard deviation of log of (x+1)
where y.= (x.+l), x.=individual residue amount.
1) Sixteenth Percentile = actual 16th%ile of ordered amounts
m) Median
n) 84th percentile = actual 84th%ile of ordered amounts
o) Positive Mean=(Eresidue amount)/c
For PCB's
a) Residue name
b) Sample size
c) Number not detected
d) Percent not detected = c/b*100
e) Number where residue amount less than 1 PPM
f) Percent = e/b*100
g) Number where residue amount greater than 1 PPM but less
than or equal to 3 PPM
h) Percent = g/b*100
i) Number where residue amount greater than 3PPM
j) Percent = i/b*100
Residue amounts for those residue info records selected
but having a trace indicator equal to < are treated as zeroes
n the calculations. Those residue info records for adipose
tissue having a confidence code equal tc K are totally bypassed.
-------
REPORT NAME
HUMANS GEOGRAPHICS
REPORT SPECIFICATIONS (CONTINUEDI
PAGE
2a
REPORT NUMBER
DETAILED DESCRIPTION (Continued!
Those having a confidence code equal to I or J are treated as tr
traces above. For blood and urine samples, reocrds having
confidence codes of Y are treated as traces and those having a
confidence code of Z are totally bypassed.
If the report to be generated is the lipid/Design, do
not select those samples where the lipid extract percent is
less than 10. These samples should only be included in
the lipid/All report.
ice
VII-69
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE
REPORT NAME
HUMANS GEOGRAPHICS
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
Source
Parameter Source
Parameter Start Date
Sample Date
Parameter Sample Type
Residue Code
Parameter Residue List
State Number
State Name
Site Number
Site Name
Region Number
Census Region
Residue Name
Design Code
Sample Type Name
% LIPID Extract
Residue Amount
Units
Trace Indicator
Confidence Code
Census Division
Census Division Name
VII-
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE A
REPORT NAME
HUMANS GEOGRAPHICS
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
H-3
4-11
50-115
117-120
44-77
H-4
H-5
H-6
44-60
62-66
68-71
73-77
111-116
119-128
4-8
12-28
System Date
Constant Data
Page Number
Constant Data
Parameter Summary
Level
National
State
Hospital
EPA Region
Census Region
Census Division
Constant Data
Paramete'r Start Date
Constant Data
Parameter End Date
Constant Data
Parameter Basis
Constant Data
Parameter Summary
Level
National
State
Hospital
EPA Region
Census Region
Census Division
Title
National Summary
State Summary
Hospital Summary
EPA Regional Summary
Census Region Summary
Census Division Summary
Name
National
State Name
Hospital Name
EPA Region Name
Census Region Name
Census Division Name
VI1-/1
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 5
REPORT NAME
HUMANS GEOGRAPHICS
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-6
H-7
H-8
Thru
H-ll
D-l
111-115
119-124
111-116
119-129
3-20
23-26
29-32
34-39
43-46
49-54
57-62
64-69
71-77
79-85
88-94
97-103
106-112
115-121
124-130
Constant Data
Parameter Design Title
S Master
D Design
Constant Data
Sample Type Name
Constant Data
Residue Name
Sample Size
No-Positive
PCT Positive
No-Trace
PCX-Trace
High Value
Low Value
Arithmetic Mean
Positive Mean
Adjusted Geometric Mean
Std deviation of log of (x+1)
16th Percentile
Median
84th Percentile
VII-72
-------
SYSTEM
REPORT NAME
REPORT NUMBER:
Arthur Young & Company
1 !) 1 5 6 7 8 9 0 1 2 > 4 5 6 1 8 90 2 > « 5 S 7 1 90 1 2 >
2
1
1 I til- ' y _..-.::::. ij •
7
8 J II II
9 j wSp IE f > >
10 PESM:IDE Siie *o. f
12
'3 > < 2222 JSJS
14 H.......... ...... 1 aiot 1) fl 9 q a
15
16 " "
17
~ 18
19
2O
2?
24
25
26
21
28
29
JO
31
32
33
3
1 2 J 1 5 6 1 8 9 0 1 M 4 5 S 1 8 9 0 1 2 M 5 6 1 8 9 0 1 7 >
4 i 6 1 8 9 » 1 2 1 4 i i 1 8 9 0 1 2 ! 4 S til 1 9 I IJ2 1 i|S ( l|8 Srt IJ2 1
_ ( Of ftf] i fl[>lfl!!oRlK^ SJORVEn
. «E?eEHN(« PI*! igJ^PJAifl
[ ! S > ? 2 5 9 . cje aw. WJ 'fltV-l^. V't
So c n n a a a 7 ?cq r^\ 'QQtat r *i 94 a! ifito! 1 <%<
-i|Uj-i -
- - i \ •
' i
L
i i §
U ' ""
i i
1- ! '••
i I"
! t i
i
. _ . | . _ _.
i
O S 1 I 90 1 2 1 ( S 6 1 S 9 0 1 ? ) « 5 S 1 1 90 1 ! J « i S 1 8 9 0 1 ?
4
F
|
tl
V
1
111
i
1
'
I
1
1
I
J
1
4
56
T>
1-
.
Ml
^1
!
i i
i
1 1
1 •
'
j
•
!
1 1
i
i
i
•
1 1
56
89 0
/H
i • •
• *
p'<
"•f
1
\* »'
I«fAt( j , _*Ey!_ in jx«i) . i
::i_i:::rl:::::::...::
*,' (Art f\ 99 ° i/* n»r\ ^ 9i<3 fl C C J i c?
il i L 1
M
Jiiii i i-^ L" •
ii1! L rF TV
i ! i
; , ' . 1 ""
1 i
. , . • i . . i . . L.
iivrf" ". \ .""".:...
ry r i i :..;...
M'l ' J_ -L i
i ; • i i >
: L L C.
!|i4k' ili"
i
1188888889999999999000000000
! M 5 6 7 8 9 0 1 2 J < 5 6 789017)45618
1 1 1 1 1 1 1 1 1 1 1 I 1 1 1 1 1 1 1 1 1 1 1 1
9012)455189012)456189012
PT6' K*"K
B-ASlS' )--------«
nsSut x- i?
P£ KC E K T 1 L f J
(TH r EDI ftJ BU'
io0£ s?1? ll lull*
-------
REPORT SPECIFICATIONS
REPORT NAME
HUMANS DEMOGRAPHIC REPORT
REPORT NUMBER
PURPOSE
To provide summary statistics of pesti-
cide residue levels in humans by demo grouping
FREQUENCY
On Demand
USERS National Humans Monitoring
Program Project Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
AVERAGE NUMBER ~ .GES
Pesticides Monitoring System Data Base
OUTPUT MEDIA
132 column paper on
microfilm as
specified
SEQUENCE OF REPORT
Major - Parameter Summary Level
Intermediate 1 - Pesticide
Minor - Parameter Patient Demo-
graphy
RECORD SELECTION CRITERIA
Mode = Humans
Residue Amount> Parameter Amoun
Parameter Start Date <_ Sample
Date
Parameter End Date >_ Sample
Date
Tissue Type = Parameter Sample
Type
Basis = Parameter Basis
Sample Design = Parameter
Sample Design
DETAILED DESCRIPTION
The demographic report described below satisfies the re-
quirements for 96 separate reports. Each report provides summary
statistics of pesticide residue levels for samples from four
categories. Each report is based upon one criteria from each
of these categories:
Geographic Summary Level (Major Sequence)
National - EPA Region
EPA Census Region - Census Division
Sampling Basis (all residue levels are to be reported
on one of the following)Valid for Adipose tissues only.
Lipid
Wet Weight
Sample Design (all records must be from one of the
following)
Design Sample
All Samples
Sample Type (all records must be from one of the
following)
Adipose
Blood
Urine
VII-74
-------
REPORT SPECIFICATIONS (CONTINUED!
PAGE 2
REPORT NAME
HUMANS DEMOGRAPHIC REPORT
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
Patient Demography (Minor Sequence)
Age
Sex
Age/Sex
Race
The summary detail information on each page of the reports
depend of the Patient Demography chosen. For each demographic
criteria, the detail categories and sequence is listed below:
Age Categories
00-14
15-49
50-99
Sex Categories
flale
Female
Unknown
Age/Sex Categories
00-14 Male
00-14 Female
00-14 Unknown
15-49 Male
15-49 Female
15-49 Unknown
50-99 Male
50-99 Female
50-99 Unknown
Race Categories
Caucasian
- Negro
Oriental
American Indian
Other - '
Each report will be sequenced as follows:
Geographic (by Nation, by EPA Census Region, or by
Census Division)
Pesticide
Demography
Header information on each page will include the record selectio:
criteria, the current value of the geographic criteria chosen
(either Nation, Census Region or Division), the pesticide, and
the demographic category provided as input.
For each detail category within the demographical criterio.
VII-YIJ
-------
REPORT NAME
HUMAN DEMOGRAPHIC REPORT
REPORT SPECIFICATIONS (CONT1NI
PAGE 3
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
chosen, the following information is presented. If to be reported
on a lipid basis, each individual residue amount is divided by
the decimal equivalent of the % lipid before performing these
calculations, Ir »iirid less than 1^ include in all <=a™iies not n.
a) Detail category name
b) Number of samples tested for the pesticide within the
category
c) Number of samples where residue was detected
d) Percent of samples where residue was detected = c/b*100
e) Number of samples where residue was detected in trace
quantities
f) Percent of samples where residue was detected in trace
quantities e/b*100
g) Maximum = largest residue amount
h) Minimum = smallest residue amount
i) Arithmetic mean = (E residue amount)/b
jj Geometric Mean = {antilog y}-l, where y=9 n ,
where y.= (x.+l), x. individual residue amount.
k) Standard deviation of log of (X+l)
1) 16th Percentile = actual 16th%ile of ordered residue
amounts.
m) Median
n) 84th Percentile = actual 84th%ile of ordered residue
amounts.
Residue amounts for those residue info records selected
but having a trace indicator equal to^- are treated as zeroes
in the calculations. Those residue info records for adipose
tissue having a confidence code equal to K are totally bypassed.
Those having a confidence code equal to I or J are treated as
traces above. For blood and urine samples, records having
confidence codes of Y are treated as traces and those having a
confidence code of Z are totally bypassed.
VII-7G
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 4
REPORT NAME
HUMANS DEMOGRAPHIC REPORT
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Transport Mode
EPA Census Region Number
EPA Census Region Name
Sample Date
Sample Type Code
Sample Type Name
Wet Weight
Lipid Extract Percent
Preferred Analysis Code
Residue Code
Residue Amount
Residue Units
Trace Indicator
Age
Sex
Race
Confidence Code
Census Division
Census Division Name
VII-77
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 5
REPORT NAME
HUMAN DEMOGRAPHIC REPORT
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
H-3
H-4
PH-1
PH-2
4-11
15-21
50-72
111-115
117-120
41-81
44-77
44-60
62-66
68-71
73-77
4-10
12-27
58
59-62
63
111-116
119-128
4-10
12-28
System Date
1PMSHQQ2'
'HUMAN MONITORING SURVEY1
1 PAGE:'
Page Number
Constant Data
Report Title
Parameter Patient
Demography:
Age
Sex
Age/Sex
Race
Report Title;
'SUMMARY STATISTICS BY
AGE1
'SUMMARY STATISTICS BY
SEX1
'SUMMARY STATISTICS BY
AGE/SEX'
'SUMMARY STATISTICS BY
RACE1
Constant Data
Parameter Start Date
Constant Data
Parameter End Date
Constant Data
Report Name
Parameter Summary Level
Census Division
National
EPA Census Region
1 ('
Residue Units
') '
Constant Data
Parameter Basis
Constant Data
Area Name
Report Name
Census Division Sumr|iary
National Summary
Census Summary
VII-78
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE g
REPORT NAME
HUMANS DEMOGRAPHIC REPORT
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
PH-3
PH-4
PH-5
PH-6
PH-7
D-l
111-115
119-124
4-11
12-29
111-117
119-129
3-20
22-131
3-20
23-26
31-34
36-41
47-50
53-58
62-67
71-76
80-85
89-94
98-103
107-112
116-121
125-130
Parameter Summary Level
Census Division
National
EPA Census Region
Constant Data
File Name
Area Name
Census Division Nan
EPA Census Region
Name
Parameter Sample Design File Name
'Design1
'Master1
Design Sample
All Samples
Constant Data
Residue Name
Constant Data
Parameter Sample Type
Constant Data
Parameter Patient Demography
Constant Data
Constant Data
Constant Data
Patient Demography Detail Category (listed
in report description)
Sample Size
No-Positive
Pet-Positive
No-Trace
Pet-Trace
Maximum
Minimum
Arithmetic Mean
Adjusted Geometric Mean
Standard Deviation
16th Percentile
Median
84th Percentile
VII-79
-------
SYSTEM
REPORT MftMF lIuPIAlJS J)t M06RAPHICS REPORT MIIMRFR-
Illllll 1 1122222222221
l!S4}ifl90l2MSil«)OIM4S(IMO
1 \\l\Vn1'
-5 ! f;i 1 • < •••::::! ..
e / 6 £*' '• '
7 i si j oE-S :::::::!.
8
? '. ' ; ? ! 1 Li_.
10 . Kit ID
12
-.-• . . . i ' i < _ _ i i
i . ( i . . ! t
16
I/
IB
19
•to
21
22
23
24
2b
26
27
0
29
3CI
31
32
33
34
IS
3fa
J7
38
39
4C
41
42
43
44
45
46
47
48 " " "
49
SO
j 0 2 i S S 1 J 9 0 5 t ?|l 9 9
» J ) 1 J 1 1 1 4 1 4 4 4 4 4 4 1 4 S 5 4 i S S S sis i't t|C 6 ( till
M 4 5 C 1 1 9 0 1 M 4 S i 1 ( 9 0 1 M 4 5 6 1 1 9 0 IJM 4 |i|(|l
U p t A |i 1 6 M ! l]f IIH&
LAflbZflKlqy P| Ilk i IKS OF (Pie
l| . . . - j- _ . -J-! 0-
R£[om»!s[ f^g ^i A j^/S
CY SSL,
-- i tr ||j
Q5iiiu£ . ifjQf 1|^g
jfRteJi to. pegaeHlT ,fl,i«;it|:
^
J
E E I
190
#
idi
1
1
1 ' '
) 4 i
5^
as. SP:
1 1 1
, 1 1 9
M&
rteaim1
.1": ,,i\:
1
0
JUM ,-,
i 4.4.1 ,/RITM,-, PJ
;t=fiW . HEAK , . i
n • ' r
f p "~ ^tj ' 1 i '
?H tGlra'ra eRpHH m3 rN I •"^•lflN ^
? 953 03 l:S;..n? »> 93*7 "5 2!
l i
j 1 j -
ft'
1
_(-[
i ,;
- - — i
jit
t- -
M4Sill90l2!4Stll90i;l4SCII90l)l4S
2-3
1
^
~i~r
.f
.
I
't
• -
-
-
1 1
i i
i
i i
••i
i
---
.-,
; r
-
90
; " i i '
??!?::«
??,?!. ft
t
i
i
•
T-
!
i
i
• i i
i ;
\ [
* i ' '
i
\ •
Arthur Young &
i i i in i i i i i i
»|j S 4 3 1 « 1 J 5 9 9 9 4 9 9 9 9 9 0 0 0 0 0 0 0 0 0 0
l|2 J|« 5 6 1 ! 9 0 1 2 i 4 5 S 1 J 9 0 1 2 1 4 5 6 1 I 3
1 f:::: . . ~:
i i r
i: LjU .1 .
Uli "'' i ]J
••ri\ ifiir i K]](.-nii!
»^r.(|. Se^ ,pf isa ^r
' ,._ _ j-j-
a!.i»«|2L zg? tepffljc?'. °tM
\\? ^ J. 1
1
. !r-7 rjr
;":'"." i i
• ' ,''"." i i '
' i i : ' ' 1 1 1 ; i
,4 -.j!- r
if • ' *~i t
!_ '
... ;
1 1 1
-
i
j
-
«i
| ; i
1 i
i
1 1 1
14 it
?
i
i 1 1
1 19
0
,j' ' ' |! ; jZ "
][.-f-|tt 1 1 - ;•
III-.- L J
il rL . ' '
1 M '
•f,TT """
. .L . .
- - - - -
i 1 1 1 i i i i i i
I2)4S6!I90I2!4S6I»50I2»456I!9
,
Company f^w
^5'Ll
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
IIIIIIIIII2222222222111
0 1 2 1 ( b ( 1 t 9 0 1 2 1 4 S ( 7 i 1 0 1 2
F, Lf X H
.qit|E----. — .:......_.
I'E!R;EKII it £:
r r f «|f B i >H 1 1. r«
•
ooo ?9? 0£0 J 'f 2 c " C
-
i
-
....
i i i i i i i i i i i i i i i i i i i i i i i
1 1 1 1 1 l 1 1 1 1 2 2 2 2 ! 2 2 2 2 2 1 i 1
0 1 2 M i 6 1 1 9 0 1 2 ! 4 S 6 1 1 ) 0 1 2
r-4 — Fuhlltii k M ihilli >l h
-------
REPORT SPECIFICATIONS
REPORT NAME
INDIVIDUAL PATIENT SUMMARY
REPORT NUMBER
PURPOSE
To provide a detailed listing of Survey
Activity in Humans.
FREQUENCY
On demand
USERS
National Humans Monitoring System Project
Officer
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Site Number
RECORD SELECTION CRITERIA
Transport Mode = H
Source = Parameter Source
Sample Date >^ Parameter Start
Date
Sample Date <_ Parameter End
Date
Site Number = member of Para-
meter Site List
Residue Amount > Parameter Amount
DETAILED DESCRIPTION
Input to the report generator must include the collection
date reporting range using Parameter Start Date and Parameter
End Date. Additional selection criteria can be used to reduce
the sites to be reported by using the following Parameters:
a) Parameter Source - i.e. HANES, or "normal" survey
b) Parameter Site List - list of particular sites to be
reported. (Default is all)
c) Parameter Amount - all samples, use .000, positive only,
For each selected site record, a new page is generated and
heading information is provided including the site name, site
city, and state name.
For each sample record within the selected site, detail
data from the sample record and patient sample records are
printed. Information includes:
a) Patient Initials
b) Accession Number
c) Collection Date
d) Design Indicator
e) Birth Date
f) Sex
g) Age
h) Race
001
VII-Ul
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 2
REPORT NAME
Individual Patient Summary
REPORT NUMBER
DETAILED DESCRIPTION (Continued)
i) Occupation Code
j) Height
k) Weight
1) Post-Surg-Indicator
m) Length of Stay Indicator
n) Diagnoses Codes
For each Analysis Record within the Sample - Analysis Set,
the following information is printed.
a) Lab Number
b) Analysis Date
c) Tissue type
d) Volume
e) Lipid Extract %
f) Wet Weight
g) Osmality
h) GC Make
i) Detector
j) Column 1 Code
k) Column 2 Code
1) Analysis Method
For each Residue Information Record with the Analysis -
Residue Set, the following data is printed:
a) Residue Name
b) Trace Indicator
c) Residue Amount
d) Units
e) Confidence Code
f) Override Indicator
VII-32
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
INDIVIDUAL PATIENT SUMMARY
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Parameter Source
Parameter Start Date
Parameter End Date
Parameter Start List
Transport Mode
Source
Site Name
Site Number
Location Name
State Name
Patient Initials
Sample Accession Number
Sample Date
Design Code
Birth Date
Sex Code
Race Code
Age
Occupation Code
Height
Post-Surg-Indicator
Lng of Stay Indicator
Diagnosis (1-6)
Lab Number
Analysis Date
Sample Type
Volume
LIPID-EXT-PCT
Wet Weight
Osmolality
GC-Make-Code
Detector-Code
Col 1 Code
Col 2 Code
Analysis Method
Residue Code
Residue Name
Trace Indicator
Residue Amount
Units
Confidence Code
Override Indicator
VII-33
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE „
REPORT NAME
INDIVIDUAL PATIENT SUMMARY
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
HI
H2
H3
H4
H5
H6
H7
Thru
H13
4-11
55-125
127-130
4-12
14-33
111-117
120-128
4-8
14-33
46-62
65-68
69-74
75-79
4-9
14-33
System Date
Constant Data
Page Number
Constant Data
Constant Data
Constant Data
Site Name
Constant Data
Source
Constant Data
Location Name
Constant Data
Parameter Start Date
Constant Data
Parameter End Date
Constant Data
State Name
Constant Data
VII-34
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 5
REPORT NAME
INDIVIDUAL PATIENT SUMMARY
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
Dl
D2
4-5
8-18
23-29
33
35-42
45
47-48
51
53-55
59-61
66-68
74
80
85-89
92-96
99-103
105-109
111-115
118-122
11-14
15-16
19-28
29-36
39-5Qg»
51-70
72-79
80-84
86-94
95-99
101-111
112-116
118-126
127-130
Patient Initials
Accession Number
Sample Date
Design Indicator
Birth Date
Sex
Age
Race
Occupation Code
Height
Weight
Postmortem Surgery Indicator
Length of Stay Indicator
Diagnosis Code 1
Diagnosis Code 2
Diagnosis Code 3
Diagnosis Code 4
Diagnosis Code 5
Diagnosis Code 6
Constant Data
Lab Number
Constant Data
Analysis Date
Constant Data
Sample Type Name
Constant Data
Volume
Constant Data
Lipid Extract Percent
Constant Data
Wet Weight
Constant Data
Osmolality
VII-BJ
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE g
REPORT NAME
INDIVIDUAL PATIENT SUMMARY
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
D3
D4
11-19
20-21
24-32
3.4-35
37-41
42-43
45-49
50-51
52-61
63-64
21-38
42
45-50
55
65
75
Constant Data
GC Make
Constant Data
Detector
Constant Data
Col 1 Code
Constant Data
Col 2 Code
Constant Data
Analysis Method
Residue Name
Trace Indicator
Residue Amount
Units
Confidence Code
Override Indicator
VII-J6
-------
SYSTEM
REPORT NAME
REPORT NUMBER:
Arthur Young & Company
- r.iiiii,»ii ii ihiiiiit inn-
-------
REPORT SPECIFICATIONS
Exhibit VII-7
REPORT NAME
RESIDUE LISTING
REPORT NUMBER
PURPOSE
To provide a list of all residues that can
currently be reported
FREQUENCY
On demand
USERS
Office of Pesticides Programs
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
AVERAGE NUMBER PAGES
3 pages
OUTPUT MEDIA
132 column paper-
user terminal
SEQUENCE OF REPORT
Minor - Residue Class
RECORD SELECTION CRITERIA
Residue Records in PMS Data
Base
DETAILED DESCRIPTION
Residue Records in the data base are selected in residue
class order using the SPF. For each record selected the
following data is printed
. Residue Code
. Residue Name
. Residue Class
. Warning levels for editing purposes for each of the
different modes
Vil-v
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 2
REPORT NAME
RESIDUE LISTING
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Residue - Code
Residue - Name
Residue - Class - Name
Humans - Wrng - Ivl
Soils - Wrng - Ivl
Estuarine - Wrng - Ivl
Air - Wrng - Ivl
Water - Wrng - Ivl
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
RESIDUE LISTING
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
D-l
4-11
16-43
1-132
2-7
11-28
31-48
51-58
61-68
71-78
81-88
91-98
System Date
Constant Data
Constant Data
Residue - Code
Residue - Name
Residue - Class - Name
Humans - Wrng - Lvl
Soils - Wrng - Lvl
Estuarine - Wrng - Lvl
Air - Wrng - Lvl
Water - Wrng - Lvl
Vll-yu
-------
SYSTEM
REPORT NAME:
RESITHJg LISTIK36
REPORT NUMBER:
Arthur Young & Company
1 1 II 1 1 1 1 1 1 2 22t 2 2 2 2 22 1 1 >I i 1
1 ? J 4 5 6 1 J 90 1 M4 56 1 1 90 1 M 4 5 6 1 8 90 1 ? I 4 5
1 )ltll(lt tl L RES|l>ii i ) » ; 9 It
2
3 : ;c E \in Ci»ss
4
— 1 S [Mr ' r~ $- "
7 T
a
9
10
II
12
13
14
15
16
17
18
19
21
"22 " ' "
23
24
25
26
27
28
29
30
32
/ 33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
1 1 1 1 2122 t 2 2 i t 1 I J 1 J J 1
1 2 ||4 5 6 1 a 9 0 1 2 3 4 5 C 1 1 9 0 1 2 1 4 5 Sjl 1 9 0 [ 2 i 4 5
1 ) J 1 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 55 56 6 (66 6 1 6 6 6 1 1 1 1 I! 1
Glt90l234Jlia90l2MSCllS90l2]|4S6M90l23
II J H US . . jjfi!i.ts W) rt>«i
t"\\\\'^ \ Jwtoo^" " W?f o"
1 1 1 1 1 1 1 1
III18I8JS81JB939993999300000000
130 I2J4S6I590I2I4SGII90I2KS6I
^ilN'f M^ .. . (<»ie«
4J. " L .-]
oa • *HJ0a\ 'aao\ 3 i <** .'Mart
i J LLLJ '• j L; ; i . 1 1 J 1 4-L L i- . - - -
• -*-•»-•• "-i- I-M-;- i I r1"
• i i 1 i . • i I i i .
i i t '
..... J j-Li- i- • i-J- .L. .......
1 1
' i i 1 ' 1 i i 1 _......
-*- t- r | . ' p
: i_i • ,
T]i 1 1
i L- -I ' i
J
I _|1 I .. i !
.. ... - JJ- j ^ !
J . i ; :.
- ..-- . - .::::::
J !
1 |
i L
1 ! ' i - "
- -}- -- -1 1 '-- -L-
i . " ~ : . ' . ~ . ...::..
. ; • • • 1 h 1
• ' , f"~'~ '!" '
..; .j !j , M . • i LL
i .. i ' i r
• "Hi":;' i.rlTfiT--
L 'J. "JiJ jJl J_
1 ! ' : ' ' 1 1 i 1 ; i j_
I J 1 ; • . J 1 1 ' I . . . .
"Til ""irr 11 '"LT!
r t . :
. . . L. . I 1 ., ! J .1
i . . i 4.4 .
-f-t
' " t '
~! i j
. . - XT -i-
llJ)444444444455i5555555B6tl«666(6IIIMir
6 1 « S 0 1 M 4 5 6 1 8 9 0 1 ? 1 4 5 S 1 l|9]0 i|2|l 4 5 6 M 9jO^ 2 3 4 5 6
. . . : n - - -
, J L
•!|IJ-- I--"
- - - • • - - - -
i
1 1 1 1 1 1 1 1
1 IJ1188118SII999999J99900000000
1 1 9 0 1 2 J 4 5 6 I 8 ||C 1 2 j|« S|i|U»Jl|?LlkLJ ' 5 B '
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
OOM IIIIIIII2222222I22)IS
l90l2J456IISOIiIl90l2
H
H
I
VC
r-4 Fold hack •! dollvcl lino
.. at clutiefl line
-------
REPORT SPECIFICATIONS
REPORT NAME
ALL SITES/ONE MODE
REPORT NUMBER
PURPOSE
To provide a list of all sites for a
particular transport mode.
FREQUENCY
On demand
USERS
Office of Pesticides Programs
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Base
ALPHA User File
AVERAGE NUMBER PAGES
2 pages
OUTPUT MEDIA
132 column paper
user terminal
SEQUENCE OF REPORT
Minor - Site Number Order in
data base
RECORD SELECTION CRITERIA
Transport Mode = Transport Mode
in ALPHA user
File
DETAILED DESCRIPTION
The user will create a one record ALPHA file containing
a one character transport mode indicator to be used in
selecting site records within the data base.
Site Records are read using the SPF. If the transport
mode of the record matches that of the ALPHA file record,
the site record is selected, the owner state record is obtained
and the following data is printed to the output file:
. FIPS State Abbreviation
. Transport Mode
. Site Number
. Site Name
. Location Name
VII-92
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 2
REPORT NAME
ALL SITES/ONE MODE
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Fips - State - Abbr
Transport - Mode
Site - NBR
Site - Name
Location - Name
VII-93
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
ALL SITES/ONE MODE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
D-l
4-11
18-35
1-132
5-6
12
18-27
31-50
53-72
System Date
Constant Dcita
Constant Data
Fips - State - Abbr
Transport - Mode
Site - NBR
Site - Name
Location - Name
VII-94
-------
SYSTEM-
REPORT NAME. ftl.1- SlTES/flllf
REPORT NUMBER.
Arthur Young & Company
--
-
-
_
_-
--
-
1 1 1 1 1 1 1 1 1 1
1 2 H 56 1 I 90 1 2 J 45 f 1 1 3
1 !i / : i I ; ' ' t
* 5 r H E y D £ si
i < i . i i-
IO
i
i
13
14
IS
16
17
ia
19
2O
21
22
23
24
25
26
27
28
29
3C
31
32
33
34
35
36
37
je
39
4O
41
42 "
43
44
45
46
47
4B
49
50
1 1 1 1 1 1 1 1 1 1
I214SCII90I2I4SCM9
2 2 2 2 2 2 2 2 ! 2 1 1 J i J ill i 14 44 <
0 1 2 J 4 5 6 1 1 9 0 1 2 1 4 i|(|l|l 9012.
i < i \i sZas t ia°£
1 : » U3 Ml <
- j 1 -
I 1 -
222222222211111111 114444
OI214S6II90I2J4SCM90I2J
4444
4 i f 1
-
- - -
-
--
-
- --
4444
4551
4 4
1 9
-
-
--
-
-
-
4 4
1 9
i 5 5
t i &
0 1 2
55555556ft
J 4 5 6|1 1 9|0 1 2
»- T
L £ f g i • c J
*. :.:..:.
\---"T±
4-
4
- - -
T :
-
55 5 5 5 S5b6 8
S4 S C I 190 1 2
1C (I t 6 i 1 1 1 1
JJ4 56 1190 1 2 !
1
T *~
U-4i- iy
i i ,
r r
1- ±... 1
It TT !
T ~""
- - - -1- - - - -
.
. — — - .
"T
"t TT
j J
^ i
......... ^ ,
— n
. . " '1
i
i
1 1 f 1 1 1 1 1 1 1
14 SI 1 1 90 1 2
1 1 1
4 56
i
r i
1 4
1 1
11!
i ,
i r
n'- .
Ill
•i-M
i !
II
|
j i
i -
M
i
'!---
Mi
-t— .
•^1"
T ' '
. i
-
4 56
i
J
-
1 1
1 1
1 1
0 1
;
i .
4
1
i
i
i
i
.i
"t
1"
1
i •
i
-
-
i i
0 1
it i
2 1 4
.
1
1
-
i
. 1
1
-;-
1 1 II 19
5S 1990
.
j ! 1
1 r4i -
• , L
- - -
' "I --
i '
i rur
—
i[ " :
i ' r - '
.
1
2 i 4
1. [
1:
.
- - -
1 1 1 1 1 9
5 S I t 90
199999
1 ? 1 4 S (
i
i
....
1
"I"!
.1.L
i
- -^
i
-
--- •
.
-
199999
2 1 4 S t
1 1 1
99000
1 90 1 i
-
•
"
...
r
I
,
:;. -
--
—
199001
1 1 9 0 1 2
1 1 1 1 1 1 1 1 1
00000001 1
1
-------
REPORT SPECIFICATIONS
REPORT NAME
ALL SITES/ONE STATE
REPORT NUMBER
PURPOSE
To provide a listing of all sites in a
particular state
FREQUENCY
On demand
USERS
Office of Pesticides Programs
MAXIMUM TURNAROUND
24 hours
FILES USED
Pesticides Monitoring System Data Ease
ALPHA User File
AVERAGE NUMBER PAGES
2
OUTPUT MEDIA
132 Column paper
User Terminal
SEQUENCE OF REPORT
Minor - State - Site set
order of Data Base
RECORD SELECTION CRITERIA
FIPS-STATE-NBR=State Number in
ALPHA User File
DETAILED DESCRIPTION
The user will provide a two digit FIPS state number for
record selection purposes. For the selected state record,
information about each site within the state is printed.
The data output is as follows
. FIPS State Abbreviation
. Site Number
. Transport Mode
. Source
. Location Name
. Site Name
VII-96
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 2
REPORT NAME
ALL SITES/ONE STATE
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Fips - State - NBR
Fipr - State - Abbr
Site - NBR
Site - Name
Transport - Mode
Location - Name
Source
vii-yv
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
ALL SITES/ONE STATE
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
H-l
H-2
D-l
4-11
16-34
1-132
3-4
11-20
28
45
51-70
73-92
System Date
Constant Data
Constant Data
Fips - State - Abbr
Site - NBR
Transport - Mode
Source
Location - Name
Site - Name
VII-98
-------
SYSTEM.
REPORT NAME.
An.
Smic
REPORT NUMBER.
Arthur Young & Company
i i i i i i i i i i ; zz z z z z z z z i } i J J J i
1 Z J 4 1 6 1 J 90 1 Z 1 4 i S 1 I 9 0 1 2 1 4 S 6 1 1 9 0 1 2 14 S 6
i c3/)7/>( /UL Siris^eue srni
2
3 00000
4
1 |
>: SCLSSE ICeMIB&l ttfljlffi- ' SJT>E ^ Ml -
1 1 1 11 1 R Tl fl 1 R 1 1 1 1 [ 1 H M ^ ' ' ' ' ' ^ ^~I~ — "^ ' ' ' 1 - ' 1 J n | ! 1 1 H M44
. . _ .1. . . i.. 1 !. ! , it ! I i ! •
. . . 4. . _|_L|- J \.. • i , | | j } n
r i" 1 1 ' : ! ' i j H r
j T t T" TT"! • " i ' . '
"" ' X-i !
H.
_ * t T -i-i ! -! - - -
J
j. 1 lL^14_LLLii r-T-
I 1 ! ,
- • - - - - f- -•--)- 1 1
I ,_] . I , . . . . _ .
1 ":. i i ...
i,l 1+.. --. -
---••-- , ,f, ,,f +
. i ' J . •:_;!.:
, . . '. i i I J . ... . J. -L -H
j ] i 1 ' 1 h
' 1 1 ' 1 II 1 ! '
--. , I i 1 1 , . +-
• "• +• •"" ilrf'^T "*" T"
L ! ' ' • • i 1 I L
• • j . ' . 1 ! ' ' 1 T L
L ' J ' ' ' ' i LI
1 • 1 1 J 1 1
.PL;, LL.I •" . . .
• • • • i IT!' ! !
"r j f~ 1
' ' ' ' 1 1
1 T
1 . ......
i M l l i
1l90l!14SBI190l!i456ie90l2145!7lJOI2345S7»90l254567lSOI2)4S6!l90l2!4!
i
i-* Fuldlijck dl ikjilitl IHII.
0 0 0 1 1 1 II 1 1 1 1 1 ? 2 Z ! Z ! 2 Z ! 2 1 J S
- -
.
- - - - . -
ooaoiiiiiiiiiizzzzzzizzzi)
67I90I214567190I214561I90I2
|*^ l-ulj in dl ilulli.il line
-------
REPORT SPECIFICATIONS
EXHIBIT VII-8
REPORT NAME
ERROR LIST
REPORT NUMBER
PURPOSE
To provide details on unacceptable trans-
actions during editing and updating.
FREQUENCY
Each time
Edit/Update run
USERS
Ecological Monitoring Branch Project
Officers
MAXIMUM TURNAROUND
24 hours
FILES USED
Error Message File generated during
Edit/Update Cycle
AVERAGE NUMBER PAGES
OUTPUT MEDIA
132 column paper
SEQUENCE OF REPORT
Input Type Sort Field
RECORD SELECTION CRITERIA
All records are selected
DETAILED DESCRIPTION
During editing and updating of the Pesticides
Monitoring System, card images of regected transactions
along with associated error messages are written to an
intermediate file. At the conclusion of the cycle, the
file is sorted by input type and printed.
For each transaction rejected by the cycle, the
following data is presented.
a) An image of the transaction
b) For each error, an image of the transaction with
asterisks in the field that caused the failure,
a one character severity level, and finally,
a message indicating why the field may or may
not be incorrect.
A new page is generated on a change in the input type
field.
VII-l-JO
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE o
REPORT NAME
Error List
REPORT NUMBER
INPUT DATA ELEMENTS
DATA ELEMENT NO.
DATA ELEMENT NAME
Input Type Sort Field
Error Message
VII-1J1
-------
REPORT SPECIFICATIONS (CONTINUED)
PAGE 3
REPORT NAME
Error List
REPORT NUMBER
OUTPUT DATA ELEMENTS
LINE
COLUMN
ELEMENT
HI
H2
H3
thru
H5
Dl
4-11
53-125
127-130
15-23
61-70
2-132
System Date
Constant Data
Page Number
Input Type
Constant Data
Constant Data
Error Message
VII-102
-------
SYSTEM
REPORT NAIUIF GRRoR LtS,T REPORT NUMBER!
l2)4iCIISOI234SCI(90l214S(ll90l234i
1 J*/»f'i
3 . Cflll.rflSE/
5 ' ' \\t\l ' >; : I ! 1 i °! : i '. \ i 1 i ?> ?; <
6
a
9 (••...••I..XB..I •••! HI
IO
1 1
12
11
|5 | . . . , . .'.'."ill
16
17 ^ . .
IB
20
22
23
24
?6
27
28
3<
31
32
33
31
35
36
17
3ft
40
41
4? " '
43
44 - . - -
45
4G '
47 - • - -
"in
49 ...
5O
1 3 i 6 890123 5E 18901 2345
[ 1 T 1 1 f 1
1 1 9 0 1 M 4 5 1 1 « 9 0 1 M 4 S 6 1 1 9 0 M2 314 5 6 ! J 5 0 1 ?li 4 5 6 1 l|9|o IJ2 ) <
. . .. iEsriciSal^rTbii.Hk, sxsvi
Rnfovi i ;• or \ J i
I 1 1 1 1 1 1 I 1 1 1 1 1 1 1 1 1 1 1 Mill r n rr 1 '• r '1 ' i 1 ' 1 1 1 ' 1 1 ' 1 1
«Roe FlIiBS . . .. . J-J-LJ- -I- 111 ! • ! S
Tnjiitntiiti*&-Mit&s'. vsMi^&st^.\tn?7jn^ £
' ' ' ' ' f H ! ' ' 3 11 { ' ' - TPrrjWfWfi1***?^} v
Arthur Young & Company H>©
yi 1 1 1 1 1 1 1 1 1 1
418999999999900000000001
. M 9 0 1 ? 3 4 5 8 1 « 9 0 1 ? 3 < 5 6 1 » 9 0
..... .....
I t - - • -
I ^ . IJ V>R"-EjS--£
:T! ' f MG£
••'••-•::::• 'T- -vr- IJJ !_i-L.i ---i . ! • "p i-' • • --4 - •
. . ' "Oj-i-jiilfl >,;:!; . y J
- -•- [--I-}- ||iii,_.Jjj JJ1' — ' U- -b
:•:::: •: • : : -^f::4- : :• * ±ri:: ^.' , j.i ' , - . K >
.... |i I..IL, ! pi i :y r
r ! Jm£fn j ;: : jy r
•4'"-tt • ' !iH f
•-• --^tn-^r^jf- ^Y-^jTfl
1i "iJ . • ' ".
T • n ; ; ,
-..-!-•' i :
....... . .
1 ' i ! . ;
l i ' .
• • ' i . i ! ' '
U iJt
rr4 ^r
-U p - . - , 1 1 I . ...........
pj....^ ...j
ilk. :...:.!
. f|r TI — --•£•--••-•••
L .«
i I
.. ~. i. .41. i
•:k! - H- -
' i ' ' ! i ! ' ! || '
... .1 ' i • i * * i.r_
i i i • ! • rl 1
i '1 ' '
•-["!-- ' - !l
i . i
! ' ' ! I ' ' i '
t ij. ^ T '
•f} r t- ' ' ' ' i-^ '
, . ; ! ; i '
4
JIJ.1 J .
;- •
- - - -
'19 ) Sit 0 2 34 J « t 190 1 2 i« 5 6 I 8 90 1 2 J 4 56 1 8 9 0 1 2 J 4
i-- - - i
uiJir 4:il
i
- -
. _
1 1 1 1 1 1 1 1 1 1 1
I8II999999999990000000000I
5 6 f J 9 0 1 M ( 5 ( 1 J 9 0 1 M 4 5 t 1 1 9 0
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 Z 3 4 5 ( 1 1 9 0 J 2 J 4 5 6 1 1 9 0 1 i
P \ g | : ,\\V
-
-
i i i i i i i i i i i i i i i i i i i i i i
IIIIIIIM7222222222333
I234S8I890I214SCI890I
r^ fuNlhKfc at ikiniil li
-------