You are here
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 |