Database Table Name Field Name Field Description Field Type

Data Type Identifies the reported value as a maximum or average Text

DMRID

An identification number assigned by ADEM that is unique to a permit 

and outfall. Long Integer

Location County location in which the outfall is located Text

Month Sampling month Text

NPDES# State NPDES permit number Text

Number of Data Points

Number of points that were evaluated to determine the average and 

maximum value Long Integer

OperName Operator name Text

Outfall Outfall number Text

Pollutant_std Standardized pollutant name Text

ProjName Name of project on NPDES Permit Text

Qualifier

Indicates whether sample measurement is less than, greater than, or 

equal to the reported value Text

Units Units for the reported value Text

Value Reported measurement Double

Year Sampling year Long Integer

Alabama 2008 DMR_Clean
Database Table Name Field Name Field Description Field Type

Basin Basin location for sample Text

Data Type

Field identifying the sample point as discharge data, well, pre- or posttreatment point. Non-CBI effluent pollutant database contains only 

discharge data type. Text

ID

Autogenerated number that provides unique identification for each 

project/PWMS systems to mask the CBI deducibility of CBM project 

and treatment system information identified in the Detailed 

Questionnaire. Long Integer

Non-Detect

Indicates whether the sample measurement was not detected within 

the limits of the analytical method used Yes/No

Operator name Operator name Text

Pollutant_Std Standardized pollutant name Text

Qualifier

Indicates whether sample measurement is less than, greater than, or 

equal to the reported value Text

Sample Description

Describes sample point. For discharge data, permit and outfall 

location. Text

Sample Type

Identifies type of sample that was taken (e.g., grab, instantaneous, 

calculated) Text

Sampling Date Date sample was taken Text

Unit Units for the reported value Text

Value Reported measurement Double

DQ 2008 DMR_Appalachian and Raton_Clean
Database Table Name Field Name Field Description Field Type

AvgpH Average pH of sample Text

AvgTemp Average temperature of sample Text

Conc1Qual

Indicates whether sample measurement is less than, greater than, or 

equal to the reported value in the MeasConc1 field Text

Conc2Qual

Indicates whether sample measurement is less than, greater than, or 

equal to the reported value in the MeasConc2 field Text

Conc3Qual

Indicates whether sample measurement is less than, greater than, or 

equal to the reported value in the MeasConc3 field Text

DataSource

Identifies which reporting program the discharge data came from 

(Integrated Compliance Information System -National Pollutant 

Discharge Elimination System (ICIS-NPDES) or Permit Compliance 

System (PCS) Text

Facility Name of operator and project on NPDES Permit Text

LimitConc1 Permit Limit for measured concentration 1 Double

LimitConc2 Permit Limit for measured concentration 2 Double

LimitConc3 Permit Limit for measured concentration 3 Double

LimitQuan1 Permit Limit for measured quantity 1 Double

LimitQuan2 Permit Limit for measured quantity 2 Double

MeasConc1 Measured concentration 1 Double

MeasConc2 Measured concentration 2 Double

MeasConc3 Measured concentration 3 Double

MeasQuan1 Measured quantity 1 Double

MeasQuan2 Measured quantity 2 Double

No Data Indicator

Indicates that there is no data for the record (C= No discharge, 9= 

Conditional monitoring, etc.) Text

NPDES # State NPDES permit number Text

Outfall Outfall number Text

PARAMETER_CODE ICIS/NPDES program code to identify the pollutant Text

Pollutant_std Standardized pollutant name Text

Quan1Qual

Indicates whether sample measurement is less than, greater than, or 

equal to the reported value in the Limit Quan1 field Text

Quan2Qual

Indicates whether sample measurement is less than, greater than, or 

equal to the reported value in the Limit Quan2 field Text

Sample End Date Last day of month in which the sample was taken Date

STAT5

5-digit code to decipher the measured concentration and quantity 

values and determine whether each one is a null field, or minimum, 

maximum, or average Text

Montana_Illinois 2008 DMR_Clean
Database Table Name Field Name Field Description Field Type

CBMOptionTypeDescrip Indicates the type of discharges allowed for each outfall Text

Facility Name of project on NPDES Permit Text

Latitude_Outfall Latitudinal coordinates for outfall Double

LimitValue Reported detection limit for analytical method Double

Longitude_Outfall Longitudinal coordinates for outfall Double

NPDES # State NPDES permit number Text

Operator Operator name Text

Outfall Outfall number Text

PermitType

Indicates the type of state permit that was issued. All permits in this 

data source are "CBM Permits" Text

Pollutant_std Standardized pollutant name Text

ReceivingWaterComment Describes the flow path for the outfall Memo

Sampling Begining Date First day of month in which the sample was taken Text

Sampling End Date Last day of month in which the sample was taken Text

StatisticalBaseDescrip

Identifies the reported value as a daily or instantaneous 

maximum/minimum or daily average Text

Unit Units for the reported value Text

Value Reported measurement Double

Wyoming 2008 DMR_clean