Field Name Field Description Field Type

Basin Basin in which project operates Text

DB_ProjectID Project ID in ENG database Text

Masked Screener ID Masked unique ID assigned in the screener survey 

database Text

Operator name Name of operator Text

OperatorID Unique operator ID, relates to survey Operators table Long Integer

OperatorIdentifier Unique code assigned by survey reviewer Text

ProjectID Unique Project ID, links to Projects table Long Integer

ProjectIdentifier Unique identifier assigned by survey reviewer, or 

project name from survey Text

ProjPWMSystemID Unique ID for Proj + system combination Long Integer

PWMSystemID Unique system ID, links to Systems table Long Integer

PWMSystemName Unique name assigned by survey reviewer, or taken 

straight from survey Text

Screener ID Unique ID assigned in the screener survey database Text

Field Name Field Description Field Type

C4_1_Pollutant Non-standard pollutant names Text

Standardized Name Standardized pollutant names Text

Field Name Field Description Field Type

02/09 TWF TWF values from Feb 2009 PCS database Text

04/06 TWF TWF values from April 2006 PCS database Double

08/04 TWF TWF values from Aug 2004 database Double

11/07 TWF TWF values from Nov 2007 PCS database Text

12/04 no RSC TWF TWF values from Dec 2004 database without Relative 

Source Contribution Double

12/04 TWF TWF values from Dec 2004 database Double

CASNU CAS registry number Text

CBM TWF value relevant to CBM data is marked with an X Text

Current TWF Toxic weighting factor Double

Pollutant Pollutant name Text

_Reference_Std Pollutant Names

_Reference_TWFs

Table Name

_Reference_Database Crosswalk
Field Name Field Description Field Type

Count

Number of Raw Data Points included in the monthly 

average value Long Integer

Data Type_Raw

Field identifying the sample point as discharge data, 

well, pre- or post-treatment point. As originally 

reported in DMR. 

Text

Data Type_Rev

Field identifying the sample point as discharge data, 

well, pre- or post-treatment point. ERG revised after 

manual inspection of results

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

OperName Operator name Text

Outfall Outfall number Text

Param Reported Parameter in DMR Text

ProjectID Unique identification for each project Long Integer

ProjName Name of project on NPDES Permit Text

ProjPWMSystemID Unique identification for each project/PWMS system Long Integer

Units Units for the reported value Text

Value_Raw Reported measurement. As originally reported in DMR Double

Value_Raw_Qual Indicates whether sample measurement is less than, 

greater than, or equal to the reported value Text

Value_Rev Reported measurement. ERG revised after manual 

inspection of results Double

Value_Rev_Qual Indicates whether sample measurement is less than, 

greater than, or equal to the reported value Text

Year Sampling year Text

AL 2008_DMR
Field Name Field Description Field Type

C4_1_FlowRate Flow rate Single

C4_1_FlowRateUnit Flow rate unit of measure Text

C4_1_Method Analytical method Text

C4_1_PermitLimit Permit limit (mg/L) Single

C4_1_Pollutant Standardized pollutant name Text

C4_1_Pollutant_raw Original pollutant name, prior to any standardization Text

C4_1_SampleType Sample type (grab/composite) Text

C4_1_SamplingDate Sampling date Text

C4_1_Unit Standardized units; raw units appear where record had 

no unit conversion applied Text

C4_1_Unit_raw Original pollutant unit Text

C4_1_Value

Measured value with unit conversion applied where 

applicable; raw values appear where record had no unit 

conversion applied

Double

C4_1_Value_raw Original measured value, prior to any unit conversion Double

Detec Detection limit Double

Exclude_outlier Excluded based on ERG review Yes/No

ND Non-detected Yes/No

ProjPWMSystemID Unique ID for Proj + system combination Long Integer

Qualifier Data flag Text

QualifierDescription Describes data flag Text

SampleID Links to Sample Descriptions table Long Integer

SourceID Identifies source: Detailed Questionnaire, existing data Long Integer

Field Name Field Description Field Type

CBI? Is analytical data claimed CBI? Yes/No

Data Type

Describes where the sample data was collected in the 

process

Text

Notes Additional notes Memo

ProjPWMSystemID Unique ID for Proj + system combination Double

SampleID Unique ID associated with a sampling identifier Long Integer

SampleIdentifier/Other Description

Previously _SampleIdentifier/OtherDescription; 

describes locational info or other identifying 

information for where sample was take

Text

TrxSeqNo Used to pair the influent and effluent data - pairs get 

assigned the same number Long Integer

TrxType

Describes DMR data or type of treatment (IX, RO, Sed, 

LP, Oth) Text

DQ Data - Sample Descriptions

DQ Data - Pollutant Data
Field Name Field Description Field Type

AVG_PH Average pH Text

AVG_TEMP Average Temperature Text

C1_QUAL Concentration 1 Field Qualifier Text

C2_QUAL Concentration 2 Field Qualifier Text

C3_QUAL Concentration 3 Field Qualifier Text

DATA_SOURCE Source database Text

DMR_YEAR DMR year Long Integer

EXTERNAL_PERMIT_NMBR PermitID Text

LC1 Concentration Limit 1 Double

LC2 Concentration Limit 2 Double

LC3 Concentration Limit 3 Double

LIMIT_SEASON_ID Season ID Long Integer

LIMIT_SET_DESIGNATOR A single-character code in ICIS-NDPES and PCS that 

groups limits that are set on a similar basis Text

LOADINGS_ID Unique loading ID Long Integer

LQ1 Quantity Limit 1 Double

LQ2 Quantity Limit 2 Double

LT_DMRS_XTB_ID Unique ID for DMRs in DMR loading tool Text

LT_FLOW_ID Unique flow ID Text

MC1 Concentration 1 Double

MC2 Concentration 2 Double

MC3 Concentration 3 Double

MONITORING_LOCATION_CODE

A single-character code in ICIS-NPDES and PCS that 

indicates the sampling location for each pollutant 

measurement. 1 – Effluent gross discharge

Long Integer

MONITORING_PERIOD_END_DATE Monitoring period end date Date

MQ1 Quantity 1 Double

MQ2 Quantity 2 Double

NMBR_OF_DAYS Days in monitoring period Long Integer

NMBR_OF_REPORT Used to quantify annual reports for loading calculations Long Integer

NODI_CODE No discharge code Text

PARAMETER_CODE Pollutant code Text

PERM_FEATURE_NMBR Outfall number Text

Q1_QUAL Quantity 1 Field Qualifier Text

Q2_QUAL Quantity 1 Field Qualifier Text

STAT5 Statistical base code Text

MT 2008_DMR
Field Name Field Description Field Type

DATA_SOURCE Source database Text

EXTERNAL_PERMIT_NMBR Permit ID Text

FQ1 Flow quantity 1 Double

FQ2 Flow quantity 2 Double

FSTAT5 Flow code corresponding to one measurements in the 

FQ1 and FQ2 fields Text

LIMIT_SEASON_ID Season ID Integer

LIMIT_SET_DESIGNATOR A single-character code in ICIS-NDPES and PCS that 

groups limits that are set on a similar basis Text

LT_FLOW_ID Unique flow ID Text

MONITORING_LOCATION_CODE

A single-character code in ICIS-NPDES and PCS that 

indicates the sampling location for each pollutant 

measurement. 1 – Effluent gross discharge

Integer

MONITORING_PERIOD_END_DATE Monitoring period end date Date

NMBR_OF_DAYS Days in monitoring period Long Integer

NMBR_OF_REPORT Used to quantify annual reports for loading calculations Long Integer

NODI_CODE No discharge code Text

PARAMETER_CODE Pollutant code Text

PERM_FEATURE_NMBR Outfall number Text

MT 2010_DMR
Field Name Field Description Field Type

ACTUAL_AVERAGE_FLOW_NMBR Average discharge flow Text

CITY City Text

CONGRESSIONAL_DIST_NUM Congressional district number Text

COUNTY_CODE County code Text

COUNTY_NAME County name Text

DATA_SOURCE Indicates source of data: PCS or ICIS-NPDES database Text

EPA_REGION_CODE EPA region code Long Integer

EXTERNAL_PERMIT_NMBR PermitID Text

FACILITY_NAME Facility name Text

FACILITY_TYPE_INDICATOR Facility type Text

GEOCODE_LATITUDE Latitude Text

GEOCODE_LONGITUDE Longitude Text

HUC_CODE Hydrologic unit code (watershed) Text

HUC12 12 digit hydrologic unit code Text

MAJOR_MINOR_STATUS_FLAG Major/Minor flag where N = Minor Y= Major Text

NAICS_CODE North American Industry Classification System code Text

PERMIT_TYPE_CODE Permit type code Text

SICCODE Standard Industry Classification code Text

SOURCE_FEATURE_ID Unique identifier for point source discharges Text

STATE_CODE State code Text

STATE_WATER_BODY Water body code Text

STATE_WATER_BODY_NAME Water body name Text

TOTAL_DESIGN_FLOW_NMBR Design flow Text

UIN Unique Identification Number from FRS database Text

ZIP Zip code Long Integer

MT DMR - Facilities Crosswalk
Field Name Field Description Field Type

CHEMICAL_ABSTRACT_SERVICE_NMBR CAS number Text

CREATED_DATE Created date Text

DELETE_FROM_LOADINGS Parameters marked for deletion Text

GROUP_CODE Group code Text

IS_PATHOGEN Flag to indicate parameter as pathogen Text

PARAMETER_DESC Parameter name Text

PCS_PARAMETER_CODE Parameter code from PCS database Text

PERCENT_EXCEEDENCE_FLAG Percent exceedence flag Text

PERCENT_REMOVAL_FLAG Percent removal flag Text

POLLUTANT_CODE Pollutant code Text

POLLUTANT_DESC Pollutant name Text

SNC_FLAG Significant Noncompliance flag Text

SRS_ID Substance Registry Service ID Text

STATUS_FLAG A= Active or I = inactive Text

TWF Toxic weighting factor Text

UNIT_GROUP_CODE Unique unit group code Long Integer

UPDATED_DATE Updated date Text

MT DMR - Parameter Crosswalk
Field Name Field Description Field Type

Analyte Pollutant name Text

Analyte_raw Original pollutant name Text

CBMOptionTypeDescrip Discharge type ( 2_DD, 1A_HWR, 1A_OFCP, 1B_HWR, 

1B_PLAYA, 2_OCR) Text

COMPANY Company name Text

FacilityName Project name Text

Latitude_Outfall Latitude of outfall Double

LimitValue Permit limit Double

Longitude_Outfall Longitude of outfall Double

OutfallID Unique Outfall ID Double

OutfallNumber Outfall number Text

PermitID Permit number assigned by state Text

PermitType Permit type (CBM) Text

ProjectID Unique Project ID, refers to Projects table Long Integer

ReceivingWaterComment Notes regarding name and location of receiving water Memo

Sampling Begining Date Monitoring period start date Text

Sampling End Date Monitoring period end date Text

StatisticalBaseDescrip Daily maximum or average monthly Text

Unit Unit of measure Text

Units_raw Original unit of measure Text

Value Measured value Double

Value_raw Original measured value Double

WY 2008_DMR
Field Name Field Description Field Type

CBMOptionTypeDescrip Discharge type ( 2_DD, 1A_HWR, 1A_OFCP, 1B_HWR, 

1B_PLAYA, 2_OCR) Text

Company Company name Text

FacilityName Project name Text

LimitValue Permit limit Double

MeasurementValue Measured value Text

OutfallID Unique Outfall ID Double

OutfallNumber Outfall number Text

ParameterName Pollutant name Text

PermitID Unique permit identifier Double

PermitType Permit type (CBM) Text

PermitVersion State version indicator Double

ReceivingWaterComment Notes regarding name and location of receiving water Text

ReportingPeriodBeginDate Monitoring period start date Text

ReportingPeriodEndDate Monitoring period end date Text

StatisticalBaseDescrip Daily max or average monthly Text

Units Unit of measure Text

WYPermitNumber Permit number assigned by state Text

WY 2010_DMR_Flows Only