Raw Data Record Work File Format

A single record, or line, in the file holds a day of data. The Value and Qualifier fields zero through twenty-three correspond to the hours of the day: midnight through 11:00PM. For durations that are longer than hourly, the data appears at the time collected. Empty lines are not provided for skipped or missing days.

Field Number

Field Name

Alpha/ Numeric

Max Size/Scale

1

Transaction Type

A

1

2

State Code

A

2

3

County Code

A

3

4

Site ID

A

4

5

Parameter Code

A

5

6

POC

N

2

7

Sample Duration Code

A

8

8

Sampling Methodology Code

A

8

9

Units Code

A

3

10

Minimum Detection Limit

N

5.5 (Signed)

11

Uncertainty Value

N

4.6

12

Reported Collection Frequency Code

A

8

13

Required Collection Frequency Code

A

8

14

Primary Monitor Type

A

20

15

Reporting Organization Code

A

8

16

Reporting Organization Name

A

120

17

Sample Date

A

8(YYYYMMDD)

18

Sample Value 0

N

5.5 (Signed)

19

Primary Qualifier 0

A

8

20

Sample Value 1

N

5.5 (Signed)

21

Primary Qualifier 1

A

8

22

Sample Value 2

N

5.5 (Signed)

23

Primary Qualifier 2

A

8

24

Sample Value 3

N

5.5 (Signed)

25

Primary Qualifier 3

A

8

26

Sample Value 4

N

5.5 (Signed)

27

Primary Qualifier 4

A

8

28

Sample Value 5

N

5.5 (Signed)

29

Primary Qualifier 5

A

8

30

Sample Value 6

N

5.5 (Signed)

31

Primary Qualifier 6

A

8

32

Sample Value 7

N

5.5 (Signed)

33

Primary Qualifier 7

A

8

34

Sample Value 8

N

5.5 (Signed)

35

Primary Qualifier 8

A

8

36

Sample Value 9

N

5.5 (Signed)

37

Primary Qualifier 9

A

8

38

Sample Value 10

N

5.5 (Signed)

39

Primary Qualifier 10

A

8

40

Sample Value 11

N

5.5 (Signed)

41

Primary Qualifier 11

A

8

42

Sample Value 12

N

5.5 (Signed)

43

Primary Qualifier 12

A

8

44

Sample Value 13

N

5.5 (Signed)

45

Primary Qualifier 13

A

8

46

Sample Value 14

N

5.5 (Signed)

47

Primary Qualifier 14

A

8

48

Sample Value 15

N

5.5 (Signed)

49

Primary Qualifier 15

A

8

50

Sample Value 16

N

5.5 (Signed)

51

Primary Qualifier 16

A

8

52

Sample Value 17

N

5.5 (Signed)

53

Primary Qualifier 17

A

8

54

Sample Value 18

N

5.5 (Signed)

55

Primary Qualifier 18

A

8

56

Sample Value 19

N

5.5 (Signed)

57

Primary Qualifier 19

A

8

58

Sample Value 20

N

5.5 (Signed)

59

Primary Qualifier 20

A

8

60

Sample Value 21

N

5.5 (Signed)

61

Primary Qualifier 21

A

8

62

Sample Value 22

N

5.5 (Signed)

63

Primary Qualifier 22

A

8

64

Sample Value 23

N

5.5 (Signed)

65

Primary Qualifier 23

A

8