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

RC - Raw Composite transaction format

Seq.

Name

Description

Formatting Rules

Required

Key

1

Transaction Type

Composite Raw Data transaction identifier.

Must = RC

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

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

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

6

Parameter Code

The AQS parameter code assigned to the monitor in AQS.

Must exist in PARAMETERS reference table.

Always

7

POC

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

Reported Unit Code

The unit of measure of the reported value.

Must exist in UNITS reference table.

Insert

9

Method Code

Identifies a particular method for collecting and analyzing samples.

Must exist in SAMPLING METHODOLOGIES reference table.

Insert

10

Composite Data Year

The calendar year for which the observation is reported.

YYYY.

Always

11

Composite Period Code

Indicates the time period within the year to which the observation applies.

Must exist in COMPOSITE TYPES reference table.

Always

12

Number of Samples

Indicates the number of samples that were combined to yield the composite sample value.

Integer - 10 digit.

Insert

13

Composite Data Type

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

Reported Sample Value

The value of a composite observation.

Decimal.

Insert

15

Monitor Protocol ID

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

Qualifier Code - 1

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

17

Qualifier Code - 2

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

18

Qualifier Code - 3

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

19

Qualifier Code - 4

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

20

Qualifier Code - 5

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

21

Qualifier Code - 6

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

22

Qualifier Code - 7

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

23

Qualifier Code - 8

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

24

Qualifier Code - 9

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

25

Qualifier Code - 10

Qualifications used to describe the composite raw data.

Must exist in QUALIFIERS reference table.

No

26

Alternate Method Detection Limit

User supplied alternate to the federeal method detection limit (MDL).

Decimal.

No

27

Measurement Uncertainty

The value of method uncertainty associated with the sample.

Decimal.

No