MD - Monitor Agency Role

This transaction defines which agencies have which administrative roles associated with a monitor.

Rules

A Reporting Organization assignment cannot be changed, (i.e., updated or deleted), in a manner that would exclude any existing raw, blank, or QA data, up to 2006-12-31.

A Reporting Organization assignment for a production monitor cannot be changed, (i.e., updated or deleted), in a manner that leave any portion of that monitor’s sample periods, up to 2006-12-31, without a Reporting Organization.

A PQAO assignment for a production monitor cannot be changed, (i.e., updated or deleted), in a manner that leave any portion of that monitor’s sample periods since 2007-01-01 without a PQAO. Error Messages:

A PQAO assignment cannot be created for any period preceding 2007-01-01.

Examples:

MD transaction block in default mode
MD|I|06|001|0007|88101|3|COLLECTING|0086|20110101|
MD|I|06|001|0007|88101|3|REPORTING|0086|20110101|
MD|I|06|001|0007|88101|3|CERTIFYING|0086|20110101|
MD|I|06|001|0007|88101|3|PQAO|0086|20110101|
MD|I|06|001|0007|88101|3|ANALYZING|0086|20110101|
MD transaction block in Tribal mode
MD|I|TT|614|7004|81102|1|COLLECTING|614|20020701|
MD|I|TT|614|7004|81102|1|REPORTING|614|20020701|
MD|I|TT|614|7004|81102|1|CERTIFYING|614|20020701|
MD|I|TT|614|7004|81102|1|PQAO|614|20020701|

Format

MD - Monitor Agency Role transaction format

Seq.

Name

Description

Formatting Rules

Required

Key

1

Transaction Type

Monitor Agency Role transaction identifier.

Must = MD

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

Agency Role

Classification of the role of an agency with regard to the monitor.

Must exist in AGENCY ROLES reference table.

Insert

Y

9

Agency Code

Code representing the agency given the role.

Must exist in AGENCIES reference table.

Always

Y

10

Agency Role Begin Date

Date the role took effect.

YYYYMMDD.

Insert

Y

11

Agency Role End Date

Date the role ceased being in effect.

YYYYMMDD.

No