AD - Site Sampler

This transaction allows information about the sampler to be stored in the database. This data is needed to support flow rate verifications/audits for filter based speciation methods. That is, the transactions for Speciation Flow Rate Verification and Speciation Semi-Annual Flow Rate Audit reference the sampler and channel information defined in this transaction. This data is only needed for samplers that will be reporting those associated QA transactions.

Examples:

AD transaction in default mode
AD|I|17|031|4201|MET-ONE-A|0513|Met One Instruments|SASS||4|20021011|
AD transaction in Tribal mode
AD|I|TT|W44|0901|MET-ONE-A|W44|Met One Instruments|SASS||4|20010815|

Format

AD - Site Sampler transaction format

Seq.

Name

Description

Formatting Rules

Required

Key

1

Transaction Type

Site-Sampler transaction identifier.

Must = AD

Always

2

Action Indicator

Indicator for Insert, Update, or Delete action.

Must = I, U, or D

Always

3

State Code / Tribal Indicator

The FIPS state code of the monitor, or “TT” to indicate that the next field on the transaction is a Tribal code.

Must exist in STATES Reference Table or be ‘TT’ for Tribal Site

Always

Y

4

County Code / Tribal Code

The FIPS County Code of the site. If the previous field on the transaction contains “TT”, then the Tribal Code of the site.

Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table

Always

Y

5

Site Number

Four digit number to uniquely identify site in county and/or tribe.

Must exist in SITES table with {State Code, county Code} or Tribal Code

Always

Y

6

Sampler ID

The user assigned unique name or id for the sampler at the site (e.g. Speciation-1).

The user assigned unique name or id for the sampler at the site (e.g. Speciation-1).

Always

Y

7

Sampler Owner

Agency code of the agency that owns the sampler.

Must exist in AGENCIES reference table.

Always

8

Manufacturer

Equipment manufacturer.

Text String (limited to 80 characters)

Insert

9

Model Number

Manufacturer’s model number.

Text String (limited to 40 characters)

Optional

10

Serial Number

Manufacturer’s serial number.

Text String (limited to 40 characters)

Optional

11

Channel Count

Number of distinct concurrent samples that can be taken by the sampler.

Positive Number

Optional

12

Begin Date

Beginning of date range where the sampler is in use at the site.

Date in ‘YYYYMMDD’ format

Insert

13

End Date

End of date range where the sampler is in use at the site.

Date in ‘YYYYMMDD’ format

Always