The Minnesota County Well Index


Database Dictionary

Table: PROGRAM
Code indicating the program associated with the agency providing the information.

PROGRAM Table Description   Program Codes
 Column Name   Format
 Agency   CHAR 5 - Primary key  
 Program_ID   CHAR 7
 Program_desc   CHAR 50 NULL
 
Relationships
program.program_id c5wl.program
  c5id.program
program.agency agency.code
 
Agency   Program_ID   Program_desc
C19    EM   ENVIRONMENTAL MANAGEMENT (DAKOTA COUNTY)
C20    EH   ENVIRONMENTAL HEALTH
CITY    PERMIT2   CITY PERMIT
CNTY    ESN   EMERGENCY SERVICES NUMBER (CNTY)
CNTY    PERMIT   PERMITTING PROGRAM (CNTY)
CNTY    PID   PROPERTY/PARCEL ID (CNTY)
CNTY    ULID   UNKNOWN LOCAL IDENTIFIER (CNTY)
CNTY    UNICP   UNIDENTIFIED COUNTY PROGRAM
MDA    AGR   AGRONOMY SERVICES (MDA)
MDA    SITE   SITE_ID (BWSR)
MDH    DM   DUMP MONITORING (MDH)
MDH    MNUNIQ   MINNESOTA UNIQUE WELL NUMBER (DUPLICATE)
MDH    PWS   PUBLIC WATER SUPPLY (MDH)
MDH    RAD   RADIATION CONTROL (MDH)
MDH    SAC   SITE ASSESSMENT & CONSULTATION (MDH)
MDH    SP   SPECIAL PROJECTS (MDH)
MDH    SWP   SOURCE WATER PROTECTION (MDH)
MDH    WHP   WELLHEAD PROTECTION (MDH)
MDH    WM   WELL MANAGEMENT (MDH)
MDH    WMCDC   WELL MANAGEMENT(CDC REGIONAL SAMP) (MDH)
MDH    WMWSR   WELL MANAGEMENT WELL SEALING RECORD
MGS    CUTTING   CUTTINGS SAMPLES (MGS)
MGS    CWI   COUNTY WELL INDEX
MGS    DHNO   COMPANY DRILL HOLE#(MGS)
MGS    NRRIID   NRRI DATA ID# (MGS)
MGS    NURE   NATIONAL URANIUM RESOURCE EVALUATION (MGS)
MGS    QSERIES   QDI UNIQUE NUMBER
MGS    WSERIES   W-(1B-)SERIES UNIQUE WELL NUMBER
MJD    BNS   BROWN-NICOLET COUNTIES, WATER QUALITY MONITORING
MJD    ZRJP   ZUMBRO-ROOT JOINT POWERS BOARD
MNDNR    COAT   RESOURCES COUNTY ATLAS (MNDNR)
MNDNR    DOW   DIVISION OF WATERS (MNDNR)
MNDNR    EWR   DIVISION OF ECOLOGICAL AND WATER RESOURCES (MNDNR)
MNDNR    MIN   MINERALS INVENTORY NUMBER (MNDNR)
MNDNR    OBWELL   DNR OBERSERVATION WELL NETWORK
MNDNR    PA   PERMIT APPLICATION NUMBER (MNDNR)
MNDNR    RA   REGIONAL ASSESSMENT (MNDNR)
MNDOT    ECA   ENVIRONMENTAL COMPLIANCE & ASSESS. (MNDOT)
MNPCA    CWP   CLEAN WATER PARTNERSHIP (MNPCA)
MNPCA    GWM   PCA GROUNDWATER MONITIRING & ASSESSMENT
MNPCA    NPDES   POINT SOURCE (MNPCA)
MNPCA    NPS   NON-POINT SOURCE (MNPCA)
MNPCA    PRP   PETROLEUM REMEDIATION PROGRAM
MNPCA    RCRA   HAZARDOUS WASTE (MNPCA)
MNPCA    SF   SUPERFUND (MNPCA)
MNPCA    SRR   SITE REMEDIATION & REDEVELOPMENT
MNPCA    SW   SOLID WASTE (MNPCA)
MNPCA    T&S   TANKS AND SPILLS (MNPCA)
MNPCA    UNK   UNKNOWN PROGRAM
MNPCA    VIC   VOLUNTARY INVESTIGATION & CLEAN UP (MNPCA)
SEJPB    VNM   VOLUNTEER NITRATE MONITORING
USEPA    SDWA   SAFE DRINKING WATER ACT (USEPA)
USEPA    STORET   NATIONAL CHEMISTRY DATA BASE (USEPA)
USGS    WR   WATER RESOURCES (USGS)
 
 Close