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

 

Top of Page