NPDES eRule Dashboard Download Help
The "Download Text" column of this table shows the text as it appears in the header row of the Excel download and in the ICIS-NPDES database. The "Text Description" column shows the text as it appears in the Dashboard when possible and into a simpler column name when not.
| Column | Download Text | Text Description |
|---|---|---|
| A | EXTERNAL_PERMIT_NMBR | NPDES Permit Number |
| B | PERMIT_NAME | Permit Name |
| C | FACILITY_NAME | Facility Name |
| D | CITY | City |
| E | STATE_CODE | State |
| F | ZIP | ZIP Code |
| G | COUNTY_NAME | County |
| H | EPA_REGION_CODE | EPA Region |
| I | FACILITY_TYPE_INDICATOR | Facility Type |
| J | TRIBAL_LAND_FLAG | Tribal Land Flag |
| K | EXPIRATION_DATE | Permit Expiration Date |
| L | ISSUING_AGENCY_TYPE | Issuing Agency |
| M | MAJOR_MINOR_STATUS_FLAG | Major/Minor Code |
| N | MAJOR_MINOR_DESC | Major/Minor Text |
| O | PERMIT_COMP_STATUS_FLAG | Permit Component Status Flag |
| P | DMR_NON_RECEIPT_FLAG | DMR non-Receipt Flag |
| Q | PERMIT_TYPE_CODE | Permit Type Code |
| R | MASTER_EXTERNAL_PERMIT_NMBR | Null |
| S | PERMIT_TYPE_DESC | Permit Type Text |
| T | PERMIT_STATUS_CODE | Permit Status Code |
| U | PERMIT_STATUS_DESC | Permit Status Text |
| V | COMP_TRACKING | Compliance Tracking Flag |
| W | RNC_STATUS | RNC Status Code |
| X | RNC_STATUS_DESC | RNC Status Text |
| Y | EDMR_AUTHORIZATION_FLAG | Electronic DMR Authorization Flag |
| Z | SIC_CODES | SIC Codes |
| AA | NAICS_CODES | NAICS Codes |
| AB | FAC_LATITUDE | Latitude |
| AC | FAC_LONGITUDE | Longitude |
| AD | FAC_LATLONG_FLAG | Facility Lat./Long. Flag |
| AE | OUTFALL_LATLONG_FLAG | Outfall Lat./Long. Flag |
| AF | LIMITS_PRESENT | Limits Present Flag |
| AG | UNRES_DMR_COUNT | Unresolved DMR Count |
| AH | CATEGORIES | Unused |
| AI | CAT_TEXT | Evaluation Category |
| AJ | ALT_CATEGORIES | Unused |
| AK | ALT_CAT_TEXT | Unused |
| AL | PERM_COMPONENTS | Components |