RC - Raw Composite¶
Warning
Submission of composite data has been deprecated from AQS. AQS will stop accepting composite data in the near future. The format is left in this document for interpreting composite data output from AQS.
Composite transactions are used to submit concentrations derived from more than one intermittent atmostpheric sample.
Format¶
Seq. |
Name |
Description |
Formatting Rules |
Required |
Key |
---|---|---|---|---|---|
1 |
Composite Raw Data transaction identifier. |
Must = RC |
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 |
||
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 |
||
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 |
||
6 |
The AQS parameter code assigned to the monitor in AQS. |
Must exist in PARAMETERS reference table. |
Always |
||
7 |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Must exist in MONITOR table for non-Insert actions. |
Always |
||
8 |
The unit of measure of the reported value. |
Must exist in UNITS reference table. |
Insert |
||
9 |
Identifies a particular method for collecting and analyzing samples. |
Must exist in SAMPLING METHODOLOGIES reference table. |
Insert |
||
10 |
The calendar year for which the observation is reported. |
YYYY. |
Always |
||
11 |
Indicates the time period within the year to which the observation applies. |
Must exist in COMPOSITE TYPES reference table. |
Always |
||
12 |
Indicates the number of samples that were combined to yield the composite sample value. |
Integer - 10 digit. |
Insert |
||
13 |
Indicates the time period over which samples are composited or the frequency of submitting composite samples. |
Must exist in COMPOSITE TYPES reference table. |
No |
||
14 |
The value of a composite observation. |
Decimal. |
Insert |
||
15 |
The ID used to distinguish combinations of sample duration, unit, method, collection frequency, composite type, and alternate method detectable limit (MDL) for a monitor. |
Must exist in MONITOR PROTOCOLS table for monitor. |
No |
||
16 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
17 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
18 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
19 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
20 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
21 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
22 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
23 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
24 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
25 |
Qualifications used to describe the composite raw data. |
Must exist in QUALIFIERS reference table. |
No |
||
26 |
User supplied alternate to the federeal method detection limit (MDL). |
Decimal. |
No |
||
27 |
The value of method uncertainty associated with the sample. |
Decimal. |
No |