Help File - SAMPLE

<< Click to Display Table of Contents >>

Navigation:  Table Descriptions > Group 3 >

Help File - SAMPLE

Previous pageReturn to chapter overviewNext page

Name

Sample Collection

Short Name

SAMPLE

ERPIMS Supplied

No

Number of Fields

Prime 19 / Lab 13

Total Record Length

Prime 409 / Lab 409

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

Import Required?

Delivery Required

Start

End

AFIID

Yes

C

1

5

LOCID

Yes

Y

7

21

LOGDATE

Yes

Y

23

33

LOGTIME

Yes

Y

35

38

MATRIX

Yes

V

40

41

SBD

Yes

Y

43

50

SED

Yes

Y

52

59

SACODE

Yes

V

61

62

SAMPNO

Yes

Y

64

65

LOGCODE

No

V

67

70

SMCODE

No

V

72

73

FLDSAMPID

No

C

75

104

COCID

No

C

106

117

COOLER

No

C

119

120

ABLOT

No

C

122

129

EBLOT

No

C

131

138

TBLOT

No

C

140

147

REMARKS

No

N

149

388

SDG

No

C

390

409

 

 


Lab Format File

Short Field Name

Import Required?

Delivery Required

Start

End

LABSAMPID

Yes

Y

1

20

MATRIX

Yes

V

22

23

LOGDATE

No

Y

25

35

LOGTIME

No

Y

37

40

SACODE

No

V

42

43

SAMPNO

No

Y

45

46

LOGCODE

No

V

48

51

FLDSAMPID

No

C

53

82

COCID

No

C

84

95

PARENTFLDID

No

C

97

126

PARENTLABID

No

C

128

147

REMARKS

Yes

[****]

149

388

SDG

No

C

390

409