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|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|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¶
Seq. |
Name |
Description |
Formatting Rules |
Required |
Key |
---|---|---|---|---|---|
1 |
Sampler-Channel transaction identifier. |
Must = AE |
Always |
||
2 |
Indicator for Insert, Update, or Delete action. |
Must = I, U, or D |
Always |
||
3 |
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 |
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 |
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 |
The user’s unique name or id for the sampler at the site. |
Must exist for Site in database |
Always |
Y |
|
7 |
Number assigned to channel on sampler |
Positive Number; must be <= the channel count for the sampler |
Always |
Y |
|
8 |
Type of filter loaded into this channel in sampler (e.g. Quartz) |
Must exist in AQS FILTER_TYPES table. |
Optional |
||
9 |
Nominal flow rate for channel |
Positive number |
Optional |
||
10 |
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 |
Beginning of date range where the channel has the specified metadata. |
Date in ‘YYYYMMDD’ format |
Always |
Y |
|
12 |
End of date range where the channel has the specified metadata. |
Date in ‘YYYYMMDD’ format |
Never |