**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 PointsNumber 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 nameOperator 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 DescriptionDescribes 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 IndicatorIndicates 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_CODEICIS/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 DateLast 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**  CBMOptionTypeDescripIndicates the type of discharges allowed for each outfallText Facility Name of project on NPDES Permit Text Latitude_OutfallLatitudinal coordinates for outfall Double LimitValue Reported detection limit for analytical method Double Longitude_OutfallLongitudinal 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 ReceivingWaterCommentDescribes the flow path for the outfall Memo Sampling Begining DateFirst day of month in which the sample was taken Text Sampling End DateLast day of month in which the sample was taken Text
StatisticalBaseDescripIdentifies 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