**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 tableLong Integer OperatorIdentifier Unique code assigned by survey reviewerText 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 databaseText

**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 databaseDouble 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 XText
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 locatedText 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 systemLong Integer Units Units for the reported value Text Value_Raw Reported measurement. As originally reported in DMRDouble
Value_Raw_Qual Indicates whether sample measurement is less than, greater than, or equal to the reported valueText
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 valueText
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 standardizationText 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 conversionDouble
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 dataLong 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 identifierLong Integer SampleIdentifier/Other DescriptionPreviously _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_NMBRPermitID 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 basisText 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_CODEA single-character code in ICIS-NPDES and PCS that indicates the sampling location for each pollutant measurement. 1 – Effluent gross dischargeLong Integer

MONITORING_PERIOD_END_DATEMonitoring 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 calculationsLong 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_NMBRPermit 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 basisText LT_FLOW_ID Unique flow ID Text

MONITORING_LOCATION_CODEA single-character code in ICIS-NPDES and PCS that indicates the sampling location for each pollutant measurement. 1 – Effluent gross dischargeInteger

MONITORING_PERIOD_END_DATEMonitoring period end date Date NMBR_OF_DAYS Days in monitoring period Long Integer NMBR_OF_REPORT Used to quantify annual reports for loading calculationsLong 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_NMBRAverage discharge flow Text CITY City Text CONGRESSIONAL_DIST_NUMCongressional district number Text COUNTY_CODE County code Text COUNTY_NAME County name Text DATA_SOURCE Indicates source of data: PCS or ICIS-NPDES databaseText EPA_REGION_CODE EPA region code Long Integer EXTERNAL_PERMIT_NMBRPermitID Text FACILITY_NAME Facility name Text FACILITY_TYPE_INDICATORFacility 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_FLAGMajor/Minor flag where N = Minor Y= MajorText NAICS_CODE North American Industry Classification System codeText PERMIT_TYPE_CODE Permit type code Text SICCODE Standard Industry Classification code Text SOURCE_FEATURE_ID Unique identifier for point source dischargesText STATE_CODE State code Text STATE_WATER_BODY Water body code Text STATE_WATER_BODY_NAMEWater body name Text TOTAL_DESIGN_FLOW_NMBRDesign flow Text UIN Unique Identification Number from FRS databaseText ZIP Zip code Long Integer **MT DMR - Facilities Crosswalk Field Name**  **Field Description Field Type** 

CHEMICAL_ABSTRACT_SERVICE_NMBRCAS 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_FLAGPercent 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 tableLong Integer ReceivingWaterComment Notes regarding name and location of receiving waterMemo 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 waterText 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**