RB - Raw Blanks

Blanks data provides an audit of background concentrations of parameters in the un-exposed filters.

Examples:

AC transaction in default mode
RB|I|06|067|0002|81102|1|7|131|063|FIELD|20200213|16:05|0.0013|||||||||||||
AC transaction in Tribal mode
RB|I|TT|615|7020|88101|1|7|077|143|FIELD|20200113|00:00|-0.5|||||||||||||

Format

RB - Raw Blanks transaction format

Seq.

Name

Description

Formatting Rules

Required

Key

1

Transaction Type

Blanks Data transaction identifier.

Must = RB

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

Parameter Code

The AQS parameter code assigned to the monitor in AQS.

Must exist in PARAMETERS reference table.

Always

Y

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

Y

8

Sample Duration Code

The period of time during which the blank sample value was collected.

Must exist in SAMPLE DURATIONS reference table.

Insert

9

Reported Unit

The unit of measure of the reported value.

Must exist in UNITS reference table.

Insert

10

Method Code

Identifies a particular method for collecting and analyzing samples.

Must exist in SAMPLING METHODOLOGIES reference table.

Insert

11

Blank Type

Describes how the un-exposed filter was handled.

Must = FIELD, TRIP, or LOT

Always

Y

12

Blank Date

Date the blank was cycled into the sampler.

YYYYMMDD.

Always

Y

13

Blank Time

The begin time of blank cycling.

HH:MM.

Always

14

Blank Value

The measured value of the parameter in the un-exposed filter.

Decimal.

Sample value or null data code required

15

Null Data Code

This is a code to explain why no blank value was reported.

Must exist in QUALIFIERS reference table.

Sample value or null data code required

16

Qualifier Code - 1

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

17

Qualifier Code - 2

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

18

Qualifier Code - 3

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

19

Qualifier Code - 4

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

20

Qualifier Code - 5

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

21

Qualifier Code - 6

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

22

Qualifier Code - 7

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

23

Qualifier Code - 8

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

24

Qualifier Code - 9

Qualifications used to describe the blank data.

Must exist in QUALIFIERS reference table.

No

25

Qualifier Code - 10

Qualifications used to describe the blank 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