Composite Data Record Work File Format

Field Number

Field Name

Alpha/ Numeric

Max Size/Scale

1

Transaction Type

A

A1

2

State Code

A

A2

3

County Code

A

A3

4

Site ID

A

A4

5

Parameter Code

A

A5

6

POC

N

N2

7

Sampling Methodology Code

A

A8

8

Units Code

A

A3

9

Minimum Detection Limit

N

N5.5 (Signed)

10

Uncertainty Value

N

N4.6

11

Composite Type

A

A20

12

Primary Monitor Type

A

A20

13

Reporting Organization Code

A

A8

14

Reporting Organization Name

A

A120

15

Year

N

N4

16

Sample Value 1

N

N5.5 (Signed)

17

Sample Count 1

N

N3

18

Primary Qualifier 1

A

A8

19

Sample Value 2

N

N5.5 (Signed)

20

Sample Count 2

N

N3

21

Primary Qualifier 2

A

A8

22

Sample Value 3

N

N5.5 (Signed)

23

Sample Count 3

N

N3

24

Primary Qualifier 3

A

A8

25

Sample Value 4

N

N5.5 (Signed)

26

Sample Count 4

N

N3

27

Primary Qualifier 4

A

A8

28

Sample Value 5

N

N5.5 (Signed)

29

Sample Count 5

N

N3

30

Primary Qualifier 5

A

A8

31

Sample Value 6

N

N5.5 (Signed)

32

Sample Count 6

N

N3

33

Primary Qualifier 6

A

A8

34

Sample Value 7

N

N5.5 (Signed)

35

Sample Count 7

N

N3

36

Primary Qualifier 7

A

A8

37

Sample Value 8

N

N5.5 (Signed)

38

Sample Count 8

N

N3

39

Primary Qualifier 8

A

A8

40

Sample Value 9

N

N5.5 (Signed)

41

Sample Count 9

N

N3

42

Primary Qualifier 9

A

A8

43

Sample Value 10

N

N5.5 (Signed)

44

Sample Count 10

N

N3

45

Primary Qualifier 10

A

A8

46

Sample Value 11

N

N5.5 (Signed)

47

Sample Count 11

N

N3

48

Primary Qualifier 11

A

A8

49

Sample Value 12

N

N5.5 (Signed)

50

Sample Count 12

N

N3

51

Primary Qualifier 12

A

A8

52

Sample Value 13

N

N5.5 (Signed)

53

Sample Count 13

N

N3

54

Primary Qualifier 13

A

A8

55

Sample Value 14

N

N5.5 (Signed)

56

Sample Count 14

N

N3

57

Primary Qualifier 14

A

A8

58

Sample Value 15

N

N5.5 (Signed)

59

Sample Count 15

N

N3

60

Primary Qualifier 15

A

A8

61

Sample Value 16

N

N5.5 (Signed)

62

Sample Count 16

N

N3

63

Primary Qualifier 16

A

A8

64

Sample Value 17

N

N5.5 (Signed)

65

Sample Count 17

N

N3

66

Primary Qualifier 17

A

A8

67

Sample Value 18

N

N5.5 (Signed)

68

Sample Count 18

N

N3

69

Primary Qualifier 18

A

A8

70

Sample Value 19

N

N5.5 (Signed)

71

Sample Count 19

N

N3

72

Primary Qualifier 19

A

A8

73

Sample Value 20

N

N5.5 (Signed)

74

Sample Count 20

N

N3

75

Primary Qualifier 20

A

A8

76

Sample Value 21

N

N5.5 (Signed)

77

Sample Count 21

N

N3

78

Primary Qualifier 21

A

A8

79

Sample Value 22

N

N5.5 (Signed)

80

Sample Count 22

N

N3

81

Primary Qualifier 22

A

A8

82

Sample Value 23

N

N5.5 (Signed)

83

Sample Count 23

N

N3

84

Primary Qualifier 23

A

A8

85

Sample Value 24

N

N5.5 (Signed)

86

Sample Count 24

N

N3

87

Primary Qualifier 24

A

A8

88

Sample Value 25

N

N5.5 (Signed)

89

Sample Count 25

N

N3

90

Primary Qualifier 25

A

A8

91

Sample Value 26

N

N5.5 (Signed)

92

Sample Count 26

N

N3

93

Primary Qualifier 26

A

A8

94

Sample Value 27

N

N5.5 (Signed)

95

Sample Count 27

N

N3

96

Primary Qualifier 27

A

A8

97

Sample Value 28

N

N5.5 (Signed)

98

Sample Count 28

N

N3

99

Primary Qualifier 28

A

A8

100

Sample Value 29

N

5.5 (Signed)

101

Sample Count 29

N

3

102

Primary Qualifier 29

A

8

103

Sample Value 30

N

5.5 (Signed)

104

Sample Count 30

N

3

105

Primary Qualifier 30

A

8

106

Sample Value 31

N

5.5 (Signed)

107

Sample Count 31

N

3

108

Primary Qualifier 31

A

8

109

Sample Value 32

N

5.5 (Signed)

110

Sample Count 32

N

3

111

Primary Qualifier 32

A

8

112

Sample Value 33

N

5.5 (Signed)

113

Sample Count 33

N

3

114

Primary Qualifier 33

A

8

115

Sample Value 34

N

5.5 (Signed)

116

Sample Count 34

N

3

117

Primary Qualifier 34

A

8

118

Sample Value 35

N

5.5 (Signed)

119

Sample Count 35

N

3

120

Primary Qualifier 35

A

8

121

Sample Value 36

N

5.5 (Signed)

122

Sample Count 36

N

3

123

Primary Qualifier 36

A

8

124

Sample Value 37

N

5.5 (Signed)

125

Sample Count 37

N

3

126

Primary Qualifier 37

A

8

127

Sample Value 38

N

5.5 (Signed)

128

Sample Count 38

N

3

129

Primary Qualifier 38

A

8

130

Sample Value 39

N

5.5 (Signed)

131

Sample Count 39

N

3

132

Primary Qualifier 39

A

8

133

Sample Value 40

N

5.5 (Signed)

134

Sample Count 40

N

3

135

Primary Qualifier 40

A

8

136

Sample Value 41

N

5.5 (Signed)

137

Sample Count 41

N

3

138

Primary Qualifier 41

A

8

139

Sample Value 42

N

5.5 (Signed)

140

Sample Count 42

N

3

141

Primary Qualifier 42

A

8

142

Sample Value 43

N

5.5 (Signed)

143

Sample Count 43

N

3

144

Primary Qualifier 43

A

8

145

Sample Value 44

N

5.5 (Signed)

146

Sample Count 44

N

3

147

Primary Qualifier 44

A

8

148

Sample Value 45

N

5.5 (Signed)

149

Sample Count 45

N

3

150

Primary Qualifier 45

A

8

151

Sample Value 46

N

5.5 (Signed)

152

Sample Count 46

N

3

153

Primary Qualifier 46

A

8

154

Sample Value 47

N

5.5 (Signed)

155

Sample Count 47

N

3

156

Primary Qualifier 47

A

8

157

Sample Value 48

N

5.5 (Signed)

158

Sample Count 48

N

3

159

Primary Qualifier 48

A

8

160

Sample Value 49

N

5.5 (Signed)

161

Sample Count 49

N

3

162

Primary Qualifier 49

A

8

163

Sample Value 50

N

5.5 (Signed)

164

Sample Count 50

N

3

165

Primary Qualifier 50

A

8

166

Sample Value 51

N

5.5 (Signed)

167

Sample Count 51

N

3

168

Primary Qualifier 51

A

8

169

Sample Value 52

N

5.5 (Signed)

170

Sample Count 52

N

3

171

Primary Qualifier 52

A

8

172

Sample Value 53

N

5.5 (Signed)

173

Sample Count 53

N

3

174

Primary Qualifier 53

A

8