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|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|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¶
Seq. |
Name |
Description |
Formatting Rules |
Required |
Key |
---|---|---|---|---|---|
1 |
Monitor Agency Role transaction identifier. |
Must = MD |
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 AQS parameter code assigned to the monitor in AQS. |
Must exist in PARAMETERS reference table. |
Always |
Y |
|
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 |
Y |
|
8 |
Classification of the role of an agency with regard to the monitor. |
Must exist in AGENCY ROLES reference table. |
Insert |
Y |
|
9 |
Code representing the agency given the role. |
Must exist in AGENCIES reference table. |
Always |
Y |
|
10 |
Date the role took effect. |
YYYYMMDD. |
Insert |
Y |
|
11 |
Date the role ceased being in effect. |
YYYYMMDD. |
No |