Help File - SAMPLE

Top  Previous  Next

Name

Sample Collection

Short Name

SAMPLE

AFCEE Supplied

No

Number of Fields

Prime 8 / Lab 9

Total Record Length

Prime 66 / Lab 301

Child Tables

TEST

Environmental Sampling Information.

This table contains information pertinent to environmental sampling events and the samples collected.  Each record represents data concerning a sample taken in the field.  A separate record must be entered for every combination of location, log date, log time, sample type, matrix, sample beginning depth, and sample ending depth.  For all Field QC samples and Field blanks, enter the date and time that the QC sample was created in the LOGDATE and LOGTIME fields. Records from the SAMPLES table will only be included in data submissions if related TESTS and RESULTS records are included. The format for the ABLOT, EBLOT, and TBLOT field entries is [DDMMYYNN] where DD is the numeric date of the month, MM is the number for the month, YY is the last two digits of the calendar year, and NN is the sequentially assigned number for the lot.

 

When normal groundwater samples are taken, groundwater data (GWD) is required.  The data submission will not be considered complete without the GWD data, and may be rejected.

 

Static groundwater level records (for GWD) are normally expected to have a LOGDATE and LOGTIME on the same day as a normal environmental sample (with a matrix of “WG”) taken from monitoring wells.  Field tests (performed in the field and not by the lab) done on groundwater samples such as temperature, pH, specific conductivity, and turbidity should be performed on the same date as the groundwater sampling date.  Only the final result of those parameters is to be reported once they are stabilized.

 

AFCEC scientists have requested a way of discriminating groundwater samples that have been captured using low-flow or slow purge groundwater sampling (primarily looking for metals).  AFCEC has a requirement that they be able to distinguish low-flow samplings of groundwater versus traditional sampling methods (e.g., bailer, submersible pump).  A Sampling Method Code (SMCODE) of “LF” is available for identifying these types of samples. When using a low-flow sampling process, the monitoring wells are not emptied or purged multiple times prior to sampling.  Field tests, if applicable, are to be performed prior to sampling.

 


Prime Format File

Short Field Name

Required?

Start

End

AFIID

Yes

1

5

LOCID

Yes

7

21

LOGDATE

Yes

23

33

LOGTIME

Yes

35

38

MATRIX

Yes

40

41

SBD

Yes

43

50

SED

Yes

52

59

SACODE

Yes

61

62

SAMPNO

Yes

64

65

LOGCODE

No

67

70

SMCODE

No

72

73

FLDSAMPID

No

75

104

COCID

No

106

117

COOLER

No

119

120

ABLOT

No

122

129

EBLOT

No

131

138

TBLOT

No

140

147

REMARKS

No

149

388

SDG

No

390

409

 


Lab Format File

Short Field Name

Required?

Start

End

LABSAMPID

Yes

1

20

MATRIX

Yes

22

23

LOGDATE

No

25

35

LOGTIME

No

37

40

SACODE

No

42

43

SAMPNO

No

45

46

LOGCODE

No

48

51

FLDSAMPID

No

53

82

COCID

No

84

95

PARENTFLDID

No

97

126

PARENTLABID

No

128

147

REMARKS

No

149

388

SDG

No

390

409

 




All photos contained in this online document are linked to full sided images of the imbedded image.  Simply click on the image to have a browser view the image in its full size.


For questions or concerns on any information on this page please Email ERPIMS Help Desk.
This page last updated 2/28/2013
© 2014 United States Government, as represented by the Secretary of the Air Force.  All rights reserved.