Data Completeness Workfile

When user requests a work file, two separate files will be produced:

n  n   Summary level information on a per EPA Region, State, Reporting Organization, Parameter, and Monitor Type basis.

n  n   Monitor level information, which contains month-by-month counts and percentages of samples collected by the monitor.

 

Field

Summary Workfile Format

1

EPA REGION

2

STATE

3

REPORTING ORGANIZATION NAME

4

MONITOR TYPE

5

PARAMETER NAME

6

NUMBER MONITORS EVALUATED

7

AVERAGE COMPLETENESS

8

NUMBER NOT REPORTING

 

Field

Monitor Workfile Format

1

MONITOR TYPE

2

SITE_ID (ST-CNT-SITE)

3

PARAMETER CODE

4

POC

5

REGION

6

REPORTING ORGANIZATION

7

CITY

8

ADDRESS

9

METHOD CODE

10

DURATION CODE

11

NOT REPORTING (TRUE or FALSE)

12

NUMBER OBSERVATIONS JAN

13

PERCENTAGE OF OBSERVATIONS JAN

14

NUMBER OBSERVATIONS FEB

15

PERCENTAGE OF OBSERVATIONS FEB

16

NUMBER OBSERVATIONS MAR

17

PERCENTAGE OF OBSERVATIONS MAR

18

NUMBER OBSERVATIONS APR

19

PERCENTAGE OF OBSERVATIONS APR

20

NUMBER OBSERVATIONS MAY

21

PERCENTAGE OF OBSERVATIONS MAY

22

NUMBER OBSERVATIONS JUN

23

PERCENTAGE OF OBSERVATIONS JUN

24

NUMBER OBSERVATIONS JUL

25

PERCENTAGE OF OBSERVATIONS JUL

26

NUMBER OBSERVATIONS AUG

27

PERCENTAGE OF OBSERVATIONS AUG

28

NUMBER OBSERVATIONS SEP

29

PERCENTAGE OF OBSERVATIONS SEP

30

NUMBER OBSERVATIONS OCT

31

PERCENTAGE OF OBSERVATIONS OCT

32

NUMBER OBSERVATIONS NOV

33

PERCENTAGE OF OBSERVATIONS NOV

34

NUMBER OBSERVATIONS DEC

35

PERCENTAGE OF OBSERVATIONS DEC

36

NUMBER OBSERVATIONS YR

37

PERCENTAGE OF OBSERVATIONS YR