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|I|17|031|4201|MET-ONE-A|0513|Met One Instruments|SASS||4|20021011|
AD|I|TT|W44|0901|MET-ONE-A|W44|Met One Instruments|SASS||4|20010815|
Format¶
Seq. |
Name |
Description |
Formatting Rules |
Required |
Key |
---|---|---|---|---|---|
1 |
Site-Sampler transaction identifier. |
Must = AD |
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 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 |
Agency code of the agency that owns the sampler. |
Must exist in AGENCIES reference table. |
Always |
||
8 |
Equipment manufacturer. |
Text String (limited to 80 characters) |
Insert |
||
9 |
Manufacturer’s model number. |
Text String (limited to 40 characters) |
Optional |
||
10 |
Manufacturer’s serial number. |
Text String (limited to 40 characters) |
Optional |
||
11 |
Number of distinct concurrent samples that can be taken by the sampler. |
Positive Number |
Optional |
||
12 |
Beginning of date range where the sampler is in use at the site. |
Date in ‘YYYYMMDD’ format |
Insert |
||
13 |
End of date range where the sampler is in use at the site. |
Date in ‘YYYYMMDD’ format |
Always |