AE - Sampler Channel

This transaction is used to store information for each channel associated with a sampler, including filter type associated with each channel and date ranges. 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:

AE transaction block in default mode
AE|I|17|031|4201|MET-ONE-A|1|TEFLON|6.7|118|20021011|
AE|I|17|031|4201|MET-ONE-A|2|NYLON|6.7|118|20021011|
AE|I|17|031|4201|MET-ONE-A|3|QUARTZ|6.7|118|20021011|
AE transaction block in Tribal mode
AE|I|TT|W44|0901|MET-ONE-A|1|TEFLON|6.7|118|20010815|
AE|I|TT|W44|0901|MET-ONE-A|2|NYLON|6.7|118|20010815|
AE|I|TT|W44|0901|MET-ONE-A|3|QUARTZ|6.7|118|20010815|

Format

AE - Sampler Channel transaction format

Seq.

Name

Description

Formatting Rules

Required

Key

1

Transaction Type

Sampler-Channel transaction identifier.

Must = AE

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’s unique name or id for the sampler at the site.

Must exist for Site in database

Always

Y

7

Channel Number

Number assigned to channel on sampler

Positive Number; must be <= the channel count for the sampler

Always

Y

8

Filter Type

Type of filter loaded into this channel in sampler (e.g. Quartz)

Must exist in AQS FILTER_TYPES table.

Optional

9

Target Flow Rate

Nominal flow rate for channel

Positive number

Optional

10

Flow Units

Units code of target flow rate

Must exist in AQS Units table with unit type of “FLOW”

Required if Target Flow Rate not null

11

Begin Date

Beginning of date range where the channel has the specified metadata.

Date in ‘YYYYMMDD’ format

Always

Y

12

End Date

End of date range where the channel has the specified metadata.

Date in ‘YYYYMMDD’ format

Never