Proposed UIC Data Model Version 7 - The Exchange Network
UIC Data Model Version 8.0
10/16/2008 (Edited 5/3/10)
[pic]
SYS_TABLES Table
|Entity/Table Name |Number of |Primary Key |Page # |
| |Attributes/ Columns | |(Data Dictionary) |
|1. FACILITY |11 |FACILITY_ID |3 |
|2. CONTACT |7 |CONTACT_ID |5 |
|3. PERMIT |6 |PERMIT_ID |6 |
|4. PERMIT ACTIVITY |4 |ACTIVITY_ID |7 |
|5. WELL |13 |WELL_ID |8 |
|6. WELL STATUS |4 |STATUS_ID |10 |
|7. WELL TYPE |4 |WELL_TYPE_ID |10 |
|8. LOCATION |11 |LOCATION_ID |11 |
|9. VIOLATION |9 |VIOLATION_ID |13 |
|10. RESPONSE |2 |ENFORCEMENT_ID |14 |
| | |VIOLATION_ID | |
|11. ENFORCEMENT |3 |ENFORCEMENT _ID |14 |
|12. INSPECTION |12 |INSPECTION_ID |15 |
|13. CORRECTION |4 |CORRECTION_ID |17 |
|14. MECHANICAL INTEGRITY TEST (MI_TEST) |7 |MIT_ID |17 |
|15. ENGINEERING (Class I & deep well only) |5 |ENGINEERING_ID |18 |
|16. GEOLOGY (Class I & deep well only) |13 |GEOLOGY_ID |19 |
|17. WASTE (Class I only) |4 |WASTE_ID |20 |
|18. CONSTITUENT (Class I only) |5 |CONSTITUENT_ID |21 |
| |124 | | |
|Appendix A -- Definitions and Acceptable Values for Location Table Attributes |23 |
|Appendix B -- Underground Injection Well Class Categories and Codes |26 |
|Appendix C -- Acceptable Values for UIC Data Elements |32 |
|Appendix D -- Primacy Agency Code Used for Database Primary Keys |42 |
Total number of data elements (not including primary and foreign keys): 89;
Total elements for Class I & deep wells: 88 (for DI Programs), 83(for states)
Total elements for Class II (non deep wells): 61(DI Programs), 56(states)
Total elements for Class III & IV (non deep wells):62 (DI Programs), 57(states)
Total elements for Class V (non deep wells):: 56 (DI Programs), 51 (states)
UIC National Database Data Dictionary - version 8.1 (11/06/2007)
|Name |
|Facility ID |Unique identification of Facility table - The |UIC Team |FACILITY_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique facility (e.g. DENR0000197590, …) | | | | | |
|Facility City |The name of the city, town, or village where the |EPA form 7520- 16 & |FAC_CITY | |Character (60) | |
| |facility is located. |Data Standard | | | | |
|Facility Name |The public or commercial name of a facility site |EPA form 7520- 16 |FAC_NAME | |Character (80) | |
| |(i.e., the full name that commonly appears on |& | | | | |
| |invoices, signs, or other business documents, or |Standard Data Elements | | | | |
| |as assigned by the state when the name is |For Facility | | | | |
| |ambiguous). |Identification | | | | |
| | | | | | |
| | |ffacid.pdf | | | | |
|Facility Petition Status |Status of review of no-migration petition (this |Class I UIC Wells- |PETIT_STAT | |Character (2) |See appendix C |
|(class I) |is a technical demonstration required before |User’s Guide (1996) & | | | | |
| |Class I hazardous waste injection facilities may |UIC Team | | | | |
| |begin operating) | | | | | |
|Facility State |The U.S. Postal Service abbreviation that |EPA form 7520-16 |FAC_STATE | |Character (2) |See appendix C |
| |represents the state |& FRS | | | | |
|Facility State ID |Facility identification assigned by DI program or|EPA form 7520-16 or |F_STATE_ID | |Character (50) | |
| |primacy state |alternative state | | | | |
| | |facility ID | | | | |
|Facility Street Address |The address that describes the physical |EPA form 7520- 16 |FAC_STREET | |Character | |
| |(geographic) location of the main entrance of a |& | | |(150) | |
| |facility site, including urban-style street |Standard Data Elements | | | | |
| |address or rural address, well field entrance, |For Facility | | | | |
| |etc |Identification | | | | |
| | | | | | |
| | |ffacid.pdf | | | | |
|Facility Type |Class I well waste is disposed in either of two |Class I UIC Wells- |FAC_TYPE | |Character (1) |See appendix C |
|(Class I only) |types of facilities: (1) Commercial- where the |User’s Guide (1996) & | | | | |
| |waste is generated offsite but transported to the|UIC Team | | | | |
| |disposal facility, or (2) Non-commercial-where | | | | | |
| |the waste is generated onsite and disposed there | | | | | |
| |also. | | | | | |
|North American Industry |The NAICS code that represents a subdivision of |Standard Data Elements |NAICS_CODE | |Character (6) |See appendix C |
|Classification System Code |an industry that accommodates user needs in the |For Facility | | | | |
| |United States (6-digits)-- (Only primary code) |Identification | | | | |
|Standard Industrial |The code that represents the economic activity of|Standard Data Elements |SIC_CODE | |Character (4) |See appendix C |
|Classification Code |a company. (4-digits) -- (only the primary code) |For Facility | | | | |
| | |Identification | | | | |
|Facility Zip Code |The combination of the 5-digit Zone Improvement |Standard Data Elements |FAC_ZIP | |Character (14) | |
| |Plan (ZIP) code and the four-digit extension code|For Facility | | | | |
| |(if available) that represents the geographic |Identification | | | | |
| |segment that is a subunit of the ZIP Code, | | | | | |
| |assigned by the U.S. Postal Service to a | | | | | |
| |geographic location. | | | | | |
| |
|2. Table CONTACT: the contact information for underground injection wells |
|Contact ID |Unique identification of Contact table - The |UIC Team |CONTACT_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique contact for a well. (e.g. | | | | | |
| |NMNR30005003490000) | | | | | |
|Contact Phone |The phone number of a contact for the well |UIC Team |CON_PHONE | |Character (15) | |
|Contact Name |The legal and complete name of a contact person |EPA form 7520-4 & UIC |CON_NAME | |Character (70) | |
| |(including first name, middle name or initial, |Team | | | | |
| |and surname) for the well. | | | | | |
|Contact City |The name of the city, town, or village of the |EPA form 7520-4 & UIC |CON_CITY | |Character (30) | |
| |contact for a well |Team | | | | |
|Contact State |The name of the state where the contact is |EPA form 7520-4 & UIC |CON_STATE | |Character (30) | |
| |located or the name of the country, if outside |Team | | | | |
| |the U.S. | | | | | |
|Contact Street |The street address of the contact for a well. |EPA form 7520-4 & UIC |CON_STREET | |Character (150) | |
| |This can be physical location or a mailing |Team | | | | |
| |address. | | | | | |
|Contact Zip |The combination of the 5-digit Zone Improvement |Standard Data Elements |CON_ZIP | |Character (14) | |
| |Plan (ZIP) code and the four-digit extension code|For Facility | | | | |
| |(if available) that represents the geographic |Identification | | | | |
| |segment that is a subunit of the ZIP Code, | | | | | |
| |assigned by the U.S. Postal Service to a | | | | | |
| |geographic location to facilitate mail delivery; | | | | | |
| |or the postal zone specific to the country, other| | | | | |
| |than the U.S., where the mail is delivered. | | | | | |
|3. Table PERMIT: information for a well with permits, rule authorization, and unauthorized injection |
|Permit ID |Unique identification of Permit table - The first|UIC Team |PERMIT_ID |Primary key |Character (20) | |
| |four characters are the primacy agency code | | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique permit(e.g. 04DI0000000000WDW366, …) | | | | | |
|Number of AOR wells |Number of wells identified in area of review |UIC Team |AOR_WELL | |Number (6) | |
| |(AOR) requiring corrective action | | | | | |
|Authorized Status |Identification of whether well is permitted, rule|EPA Form 7520-1 and UIC|AUT_STATUS | |Character (2) | See appendix C |
| |authorized, or unauthorized. If the well is |Team | | | | |
| |permitted, the acceptable authorization types are| | | | | |
| |individual, area, general, or emergency permits.| | | | | |
|Ownership Type |Type of ownership for a UIC well |EPA form 7520-6 , |OWNERSHIP_TYPE | |Character (2) |See appendix C |
| | |7520-16 & OMB 83-I | | | | |
| | |(revised 7/13/2006) | | | | |
|Permit / Rule Authorized ID |Identification assigned by DI program or primacy |UIC Team |P_STATE_ID | |Character (50) | |
|Assigned |state to permit or rule authorized well | | | | | |
|Submission Date |Date states or DI programs update and submit data|UIC Team |SUBMISSION_DATE | |Date (8) | |
| |to National UIC database system. | | | |Format | |
| | | | | |(yyyy-mm-dd) | |
| |
|4. Table PERMIT ACTIVITY: information on activities related to a permit or rule authorization (e.g. permit issuance, authorized file review, etc.) |
|Activity ID | Unique identification of Permit Activity table -|UIC Team |ACTIVITY_ID |Primary key |Character (20) | |
| |The first four characters are the primacy agency | | | | | |
| |code (appendix D). The rest is DI program or | | | | | |
| |State’s choice (letters and numbers only) | | | | | |
| |identifying the unique permit activity (e.g. | | | | | |
| |TXRC0000000000WDW567, …) | | | | | |
|Permit Action Type |Type of permit action or authorization by rule |EPA form 7520-1 |ACT_TYPE | |Character (2) |See appendix C |
|Permit Action Date |The calendar date corresponding to each |EPA form 7520-1 |ACT_DATE | |Date (8) | |
| |acceptable value of Permit Action Type includes: | | | |Format | |
| | | | | |(yyyy-mm-dd) | |
| |- Application Date for Permit Issuance: Date of | | | | | |
| |receipt of an application by state or DI program | | | | | |
| |for permit issued | | | | | |
| | | | | | | |
| |- Application Date for Major Permit Modification:| | | | | |
| |Date of receipt of an application by the state or| | | | | |
| |DI program for major permit modification | | | | | |
| | | | | | | |
| |- Permit Issued Date: Date of signature | | | | | |
| |(approval) by state/DI official for the | | | | | |
| |issuance/denial/ withdrawal of permit. | | | | | |
| | | | | | | |
| |- Permit Denied/Withdrawn Date: Date of | | | | | |
| |signature by state/DI official for the | | | | | |
| |denial/withdrawal of permit. | | | | | |
| | | | | | | |
| |- Approved Major Permit Modification Date: | | | | | |
| |Approval date of a major permit modification. | | | | | |
| |This is a date where an approved major | | | | | |
| |modification requires a complete technical | | | | | |
| |review, public notification or review, and a | | | | | |
| |final decision document signed by the regulating | | | | | |
| |authority. | | | | | |
| | | | | | | |
| |- File Review Date (Class II only): Date of | | | | | |
| |rule-authorized file review to determine whether | | | | | |
| |the well is in compliance with UIC regulatory | | | | | |
| |requirements | | | | | |
|Permit ID |Unique identification of Permit table |UIC Team |PERMIT_ID |Foreign key |Character (20) | |
|5. Table WELL: information of UIC wells. It is the main table of UIC database and the base for all UIC activities (inspection, violation, enforcement, MIT, etc ) |
|Well ID |Unique identification of Well table - The first |UIC Team |WELL_ID |Primary key |Character (20) | |
| |four characters are the primacy agency code | | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique well (e.g. TXEQWDW366, …) | | | | | |
|Aquifer Exemption |Well injects into exempting aquifer |UIC Team |AQUI_EXEMPT | |Character (1) |See appendix C |
|Total Depth |The vertical depth (in feet) from the surface to |UIC Team |TOTAL_DEPTH | |Number (5) | |
|(Class I & deep wells only) |the bottom of injection well | | | | | |
|High Priority |High priority Class V wells include all active |Measures Reporting |HIGH_PRIORITY | |Character (1) |See appendix C |
|(Class V only) |motor vehicle waste disposal wells (MVWDWs) and |Instructions | | | | |
| |large-capacity cesspools regulated under the 1999| | | | | |
| |Class V Rule, industrial wells, plus all other | | | | | |
| |Class V wells identified as high priority by | | | | | |
| |State Directors. | | | | | |
| Contact ID |Unique identification of Contact table |UIC Team |CONTACT_ID |Foreign key |Character (20) | |
|Facility ID |Unique identification of Facility table |EPA form 7520-16 |FACILITY_ID |Foreign key |Character (20) | |
|Geology ID |Unique identification for Geology record |UIC Team |GEOLOGY_ID |Foreign key |Character (20) | |
|Well Site (Class III, IV, V |Name of the area where many Class III, IV, or V (|UIC Team |WELL_SITE | |Character (50) | |
|-- storm water drainage only) |storm water drainage) injection wells are | | | | | |
| |physically located or conducted | | | | | |
|Permit ID |Unique identification of Permit table |UIC Team |PERMIT_ID |Foreign key |Character (20) | |
|Well State ID |The well identification assigned by primacy state|UIC Team |W_STATE_ID | |Character (50) | |
| |or direct implementation (DI) program | | | | | |
|State / Tribe (DI Region only)|State postal code or tribal code (for American |Data Standard & UIC |STATE_OR_TRIBE | |Character (3) |See appendix C |
| |Indian or Alaska Native) indicating a program |Team | | | | |
| |Directly Implemented by an EPA region (for DI | | | | | |
| |programs) | | | | | |
|Well in Sensitive Ground Water|Well location is within the boundary of a |UIC Measures Guidance |WELL_IN_SWA | |Character (1) |See appendix C |
|Area |sensitive ground water area as defined by the | | | | | |
| |program. Includes, at minimum, source water area| | | | | |
| |for ground water based community water systems | | | | | |
|Well Name |The name that designates the well |Well Information Data |WELL_NAME | |Character (80) | |
| | |Standard Draft | | | | |
| | |( | | | |
| | |content/gener| | | | |
| | |al/detail/711) | | | | |
| |
|6. Table WELL STATUS: information related to current and/or historical operating status of injection wells |
|Status ID |Unique identification of Well Status table - The |UIC Team |STATUS_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only identifying the | | | | | |
| |unique Well Status (e.g. TXEQ WDW369, …) | | | | | |
|Well Status Date |Date that well status is determined |Well Information Data |STATUS_DATE | |Date (8) | |
| | |Standard Draft | | |Format | |
| | |( | |(yyyy-mm-dd) | |
| | |content/gener| | | | |
| | |al/detail/711) | | | | |
|Well Operating Status |The current operating status of well |EPA form 7520-16 |OPER_STATUS | |Character (2) |See appendix C |
|Well ID |Unique identification of Well table- |UIC Team |WELL_ID |Foreign key |Character (20) | |
| |
|7. Table WELL TYPE: information of current and/or historical well type |
|Well Type ID |Unique identification of Well Type table - The |UIC Team |WELL_TYPE_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique well type (e.g. TXEQWDW369, …) | | | | | |
|Well Type |Type of injection wells located at the listed |EPA form 7520-16 |WELL_TYPE | |Character (4) |See Appendix B |
| |facility. |& | | | | |
| | |Federal Register | | | | |
| | |Proposed Rules (Vol. | | | | |
| | |63, No. 145) | | | | |
|Well Type Date |Date that well type is determined. This field |UIC Team |WELL_TYPE_DATE | |Date (8) | |
| |ONLY applies when the well changes from one well | | | |Format | |
| |type to another well type (e.g. converted from | | | |(yyyy-mm-dd) | |
| |injection to production) | | | | | |
|Well ID |Unique identification of Well table- |UIC Team |WELL_ID |Foreign key |Character (20) | |
| |
|8. Table LOCATION (dependent table to WELL): geographic surface location descriptors about wells including required Agency Method, Accuracy, Description (MAD) |
|Location ID |Unique identification of Location table - The |UIC Team |LOCATION_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only identifying | | | | | |
| |unique location (e.g. 03DI0000000000M00905) | | | | | |
|County |The name of the U.S. county or county equivalent |EPA form 7520-16 |WELL_COUNTY | |Character (35) | |
| |in which the regulated well is physically | | | | | |
| |located. | | | | | |
|Accuracy Value & Unit |Quantitative measurement of the amount of |Requirements for |ACC_VALUE | |Number (6) |See Appendix A |
| |deviation from true value in a measurement for |Locational Data in the | | | | |
| |latitude or longitude (estimate of error). It |Safe Drinking Water | | | | |
| |describes the correctness of the |Information | | | | |
| |latitude/longitude measurement, in meters. Only |System (SDWIS) | | | | |
| |the least accurate measurement is recorded, | | | | |
| |regardless whether it is for longitude or |water/sdwisfed/pdf/lat.| | | | |
| |latitude |pdf | | | | |
|Description Category - |Code representing the category of the feature |The same as above |LOC_DESC | |Character (3) |See Appendix A |
| |referenced by the latitude and longitude. | | | | | |
|Horizontal Datum |Code representing the reference standard for |The same as above |HORIZ_DATUM | |Character (3) |See Appendix A |
| |three dimensional and horizontal positioning | | | | | |
| |established by the U.S. National Geodetic Survey | | | | | |
| |(NGS) and other bodies | | | | | |
|Method of Collection |Code representing the method used to determine |The same as above |METHOD | |Character (3) |See Appendix A |
| |the latitude/longitude. This represents the | | | | | |
| |primary source of the data. | | | | | |
|Point-Line-Area |Code representing the value indicating whether |The same as above |POINT_LINE_AREA | |Character (3) |See Appendix A (default value is |
| |the latitude and longitude coordinates represent | | | | |POINT) |
| |a point, multiple points on a line, or an area. | | | | | |
|Source Scale |Code representing the scale of the map used to |The same as above |SOURCE_SCALE | |Character (2) |See Appendix A |
| |determine the latitude and longitude coordinates.| | | | | |
|Well ID |Unique identification of Well table |UIC Team |WELL_ID |Foreign key |Character (20) | |
|Well Latitude |Coordinate representing a location on the surface|SDWIS |WELL_LAT | |Number (10) |See Appendix A |
| |of the earth, using the earth's Equator as the |& | | |Format | |
| |origin, reported in decimal format. If an area |7520-6 | | |(±DD.dddddd) | |
| |permit is being requested, give the latitude and | | | | | |
| |longitude of the approximate center of the area. | | | | | |
|Well Longitude |Coordinate representing a location on the surface|SDWIS |WELL_LONG | |Number (11) |See Appendix A |
| |of the earth, using the Prime Meridian |& | | |Format | |
| |(Greenwich, England) as the origin, reported in |7520-6 | | |(±DDD.dddddd) | |
| |decimal format. If an area permit is being | | | | | |
| |requested, give the latitude and longitude of the| | | | | |
| |approximate center of the area. | | | | | |
| |
|9. Table VIOLATION: data identifying non-compliance with UIC regulation reported for regulated wells |
|Violation ID |Unique identification of Violation table - The |UIC Team |VIOLATION_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique violation (e.g. 08DI000366, …) | | | | | |
|Contamination |Well in noncompliance has allegedly contaminated |EPA Form 7520-2A |CONTAMINATION | |Character (1) |See appendix C |
| |an underground source of drinking water (USDW) | | | | | |
| |this year to date | | | | | |
|Endangering |A violation that results in the well potentially |EPA Form 7520-2B & |ENDANGER | |Character (1) |See appendix C |
| |or actually endangering the USDW. The |UIC Team | | | | |
| |endangering fluid contaminant from the well is in| | | | | |
| |violation of RCRA or SDWA or applicable | | | | | |
| |regulations | | | | | |
|Violation Return to Compliance|The calendar date, determined by the Responsible |EPA form 7520-2B, |RE_ COMP_DATE | |Date (8) | |
|Date |Authority, on which the regulated entity actually|7520-4 | | |Format | |
| |returned to compliance with respect to the legal |& | | |(yyyy-mm-dd) | |
| |obligation that is the subject of the violation |Final | | | | |
| |determined date. |Enforcement/Compliance | | | | |
| | |Data Standard | | | | |
|Violation Significant |The indication whether or not the violation is in|EPA Form 7520-2A |SNC | |Character (1) |See appendix C |
| |Significant Non-Compliance (SNC) . |& UIC Team | | | | |
|Violation Date |The calendar date the Responsible Authority |Final |VIO_DATE | |Date (8) Format | |
| |determines that a regulated entity is in |Enforcement/Compliance | | |(yyyy-mm-dd) | |
| |violation of a legally enforceable obligation. |Data Standard | | | | |
|Violation Type |The type of violation that is the subject of the |EPA form 7520-2B |VIO_TYPE | |Character (2) |See appendix C |
| |Violation Date |& | | | | |
| | |Final | | | | |
| | |Enforcement/Compliance | | | | |
| | |Data Standard | | | | |
|Well ID |Unique identification of Well table - |UIC Team |WELL_ID |Foreign key |Character (20) | |
|Facility ID |Unique identification of Facility table- This |UIC Team |FACILITY_ID |Foreign key |Character (20) | |
| |field ONLY applies for Class V violations at | | | | | |
| |FACILITY level (not to an individual well) | | | | | |
| |
|10. Table RESPONSE: connecting table for the many-to-many relationship between Violation and Enforcement table |
|Enforcement Action ID |Unique identification of Enforcement table - The |UIC Team |ENFORCEMENT_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only identifying | | | | | |
| |unique enforcement action (e.g. 08DI000766, …) | | | | | |
|Violation ID |Unique identification of Violation table - The |UIC Team |VIOLATION_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only identifying | | | | | |
| |unique violation (e.g. 08DI000905, …) | | | | | |
| |
|11. Table ENFORCEMENT: data identifying state and EPA enforcement actions in response to violation / non-compliance |
|Enforcement Action ID |Unique identification of Enforcement table - The |UIC Team |ENFORCEMENT _ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique enforcement action (e.g. 08DI000566, …) | | | | | |
|Enforcement Action Date |The calendar date the enforcement action was |Final |ENF_DATE | |Date (8) | |
| |issued or filed |Enforcement/Compliance | | |Format | |
| | |Data Standard | | |(yyyy-mm-dd) | |
|Enforcement Action Type |The type of enforcement action taken by the EPA |EPA form 7520-4 |ENF_TYPE | |Character (3) |See appendix C |
| |or states |& | | | | |
| | |Final | | | | |
| | |Enforcement/Compliance | | | | |
| | |Data Standard | | | | |
|12. Table INSPECTION: information about on-site inspections conducted by primary states and/or EPA Regions |
|Inspection ID |Unique identification of Inspection table - The |UIC Team |INSPECTION_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique inspection (e.g. WYEQ00 000566, …) | | | | | |
|Assistance |Compliance assistance provided by the inspector |FY 2005 EPA Manual ICDS|ASSISTANCE | |Character (2) |See appendix C |
| |based on national policy: |Form | | | | |
| | | | | | | |
| |-- General Assistance: involves distributing | | | | | |
| |prepared information on regulatory compliance, P2| | | | | |
| |or other written materials/websites | | | | | |
| | | | | | | |
| |-- Site-specific Assistance: involves on-site | | | | | |
| |assistance by the inspector to support actions | | | | | |
| |taken to address deficiencies | | | | | |
|Deficiency |Potential violations found by EPA inspector |FY 2005 EPA Manual ICDS|DEFICIENCY | |Character (2) |See appendix C |
| |during inspection |Form | | | | |
|Inspection Date |The date inspection action was completed |UIC Team |INS_DATE | |Date (8) | |
| | | | | |Format | |
| | | | | |(yyyy-mm-dd) | |
|ICIS Compliance Monitoring |The reason for performing a Compliance Monitoring|ICIS Data Standard |ICIS_REASON | |Character (2) |See appendix C |
|Action Reason |action. | | | | |
|(DI Region only) | |dr/edr_proc_qry.navigat| | | | |
| |-- Agency Priority: The compliance monitoring |e?P_LIST_OPTION_CD=VDDI| | | | |
| |action was performed in furtherance of a priority|S&P_REG_AUTH_IDENTIFIER| | | | |
| |or initiative of the Compliance Monitoring Agency|=1&P_DATA_IDENTIFIER=85| | | | |
| |or a partner agency. |812&P_VERSION=1 | | | | |
| | | | | | | |
| |-- Core Program: The compliance monitoring action| | | | | |
| |was performed as part of the Compliance | | | | | |
| |Monitoring Agency's core programmatic activities | | | | | |
| | | | | | | |
| |-- Selected Monitoring Action: The Compliance | | | | | |
| |Monitoring Agency selected the facility or | | | | | |
| |regulated entity for compliance monitoring in | | | | | |
| |response to a referral from another unit. | | | | | |
|ICIS Compliance Monitoring |Type of Compliance Monitoring taken by a |ICIS |ICIS_TYPE | |Character (3) |See appendix C |
|Type (DI Programs only) |regulatory Agency | | | | | |
|ICIS Compliance Activity Type |Type of compliance activity taken by a regulatory|ICIS |ICIS_ACT_TYPE | |Character (2) |See appendix C |
|(DI Programs only) |agency. | | | | | |
|ICIS MOA Priorities (DI Region|The name of Memorandum of Agreement (MOA) |ICIS |ICIS_MOA_PRIORITY | |Character (50) | |
|only) |associated with the activity | | | | | |
|ICIS Regional Priorities (DI |The name of regional priority associated with the|ICIS |ICIS_REG_PRIORITY | |Character (12) | |
|Region only) |activity | | | | | |
|Inspection Type |The type of inspection action that was conducted |EPA form 7520-2B, form |INS_TYPE | |Character (2) |See appendix C |
| | |7520-2A, UIC FY | | | | |
| | |2005/2006 PAM | | | | |
|Well ID |Unique identification of Well table - |UIC Team |WELL_ID |Foreign key |Character (20) | |
|Facility ID |Unique identification of Facility table- This |UIC Team |FACILITY_ID |Foreign key |Character (20) | |
| |field ONLY applies for Class V “No Well” | | | | | |
| |inspection. | | | | | |
| |
|13. Table CORRECTION: information on corrective actions taken to address deficiencies observed during the inspection. This table only needs when inspectors detect deficiency. |
|Correction ID |Unique identification of Correction table - The |UIC Team |CORRECTION_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only identifying the | | | | | |
| |unique corrective action (e.g. 04DI00000139, …) | | | | | |
|Corrective Action Type |Type of actions taken to correct deficiencies |FY 2005 EPA Manual ICDS|CORACT_TYPE | |Character (2) |See appendix C |
| | |Form | | | | |
|Comment |Narrative description of actions taken by the |ICIS |COMMENTS | |Character (200) | |
| |facility or assistance to help the facility come | | | | | |
| |into compliance | | | | | |
|Inspection ID |The unique identification of Inspection table |UIC Team |INSPECTION_ID |Foreign key |Character (20) | |
| |
|14. Table MECHANICAL INTEGRITY TEST (MI_TEST): Information about mechanical integrity (MI) test of wells |
|Mechanical Integrity Test ID |Unique identification of Mechanical Integrity |UIC Team |MIT_ID |Primary key |Character (20) | |
| |Test table - The first four characters are the | | | | | |
| |primacy agency code (appendix D). The rest is DI | | | | | |
| |program or State’s choice (letters and numbers | | | | | |
| |only) identifying unique MIT (e.g. 03DIVA000235, | | | | | |
| |…) | | | | | |
|Mechanical Integrity Test Date|The date that mechanical integrity test was |EPA Form 7520-3 |MIT_DATE | |Date (8) | |
| |completed | | | |Format | |
| | | | | |(yyyy-mm-dd) | |
|Mechanical Integrity Test |The result of Mechanical Integrity Test on that |State and Federal |MIT_RESULT | |Character (2) |See appendix C |
|Result |date (see above) |Underground Injection | | | | |
| | |Control Programs | | | | |
| | |Program Measures – | | | | |
| | |Final Reporting | | | | |
| | |Guidance | | | | |
|Mechanical Integrity Type |Type of mechanical integrity test |EPA Form 7520-3 |MIT_TYPE | |Character (2) |See appendix C |
|Remedial Action Date |The date (corresponding to Remedial Action Type) |EPA Form 7520-3 |RA_DATE | |Date (8) | (if blank, remedial action is not|
| |when a well that failed an MI test received | | | |Format |done) |
| |successful remedial action | | | |(yyyy-mm-dd) | |
|Remedial Action Type |Type of successful remedial action that well has |EPA Form 7520-3 |RA_TYPE | |Character (2) |See appendix C |
| |received on the remedial action date | | | | | |
|Well ID |Unique identification of Well table |UIC Team |WELL_ID |Foreign key |Character (20) | |
| |
|15. Table ENGINEERING (class I & deep well injection only): Information related to Class I and deep well injection operational parameters that measure volumes of fluid going down a well. See |
|appendix B for Class I and deep well information |
|Engineering ID |Unique identification of Engineering table - The |UIC Team |ENGINEERING_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only identifying | | | | | |
| |unique engineering information (e.g. | | | | | |
| |WYEQ00000543, …) | | | | | |
|Max Flow Rate |Maximum flow rate of injectate in the current |Class I UIC Wells- |MAX_RATE | |Number (7,2) | |
| |quarter measured in gallons per minute. |User’s Guide (1996 | | | | |
|Onsite Injection | Actual on-site injected volume in the current |Class I UIC Wells- |ON_INJECTION | |Number (6,4) | |
| |quarter measured in million gallon |User’s Guide (1996) | | | | |
|Offsite Injection | Actual off-site injected volume in the current |Class I UIC Wells- |OFF_INJECTION | |Number (6,4) | |
| |quarter measured in million gallon |User’s Guide (1996) | | | | |
|Well ID |Unique identification of an injection well |UIC Team |WELL_ID |Foreign key |Character (20) | |
| |
|16. Table GEOLOGY (class I & deep-wells injection only): Information related to basic hydro-geologic parameters and depths for the “key” sub-surface formations penetrated by the Class I injection |
|well and other deep-well injection. Both Class I and other deep well injection are listed in the appendix B. |
|Geology ID |Unique identification of Geology table - The |UIC Team |GEOLOGY_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique geology information (e.g. 04DI0000000000 | | | | | |
| |000566, …) | | | | | |
|Name of Confining Zone |Geologic formation name |Class I UIC Wells- |CZ_NAME | |Character (100) | |
| | |User’s Guide (1996) | | | | |
|Top of Confining Zone |The top of the geologic arresting layer that |Class I UIC Wells- |CZ_TOP | |Number (6) | |
| |keeps injectate confined in the injection zone |User’s Guide (1996) & | | | | |
| |measured in feet below surface |UIC Team | | | | |
|Bottom of Confining Zone / Top|The bottom of the geologic arresting layer that |Class I UIC Wells- |CZ_BOTTOM | |Number (6) | |
|of Injection Zone |keeps injectate confined in the injection zone |User’s Guide (1996) & | | | | |
| |OR: |UIC Team | | | | |
| |The top of the vertical dimension of the zone in | | | | | |
| |which waste is injected. | | | | | |
| |-- measured in feet below surface-- | | | | | |
|Lithology of Confining Zone |Confining zone data in the form of a simple |Class I UIC Wells- |CZ_LITHOLOGY | |Character (100) | |
| |lithologic description of the formation |User’s Guide (1996) & | | | | |
| | |UIC Team | | | | |
|Name of Injection Zone |Geologic formation name for injection zone |Class I UIC Wells- |IZ_NAME | |Character (100) | |
| | |User’s Guide (1996) & | | | | |
| | |UIC Team | | | | |
|Bottom of Injection Zone |The bottom of the vertical dimension of the zone |Class I UIC Wells- |IZ_BOTTOM | |Number (6) | |
| |in which waste is injected, measured in feet |User’s Guide (1996) & | | | | |
| |below surface. |UIC Team | | | | |
|Lithology of Injection Zone |Injection zone data in the form of a simple |Class I UIC Wells- |IZ_LITHOLOGY | |Character (100) | |
| |lithologic description of the formation |User’s Guide (1996) | | | | |
| | |& UIC Team | | | | |
|Top of Injection Interval |The top of the vertical dimension of the specific|Class I UIC Wells- |INT_TOP | |Number (6) | |
| |layer(s) of the Injection |User’s Guide (1996) & | | | | |
| | |UIC Team | | | | |
|Bottom of Injection Interval |The bottom of the vertical dimension of the |Class I UIC Wells- |INT_BOTTOM | |Number (6) | |
| |specific layer(s) of the Injection Zone in which |User’s Guide (1996) & | | | | |
| |waste is authorized to be injected into, measured|UIC Team | | | | |
| |in feet below surface. | | | | | |
|Injection Zone Permeability |The rate of diffusion of fluids (in this case |Class I UIC Team & |IZ_PERMEABILI | |Number (6) | |
| |liquid waste) under pressure through porous |Class I UIC Wells- |TY | | | |
| |material (formation rock) that is measured in |User’s | | | | |
| |millidarcies (md.) |Guide (1996) | | | | |
|Injection Zone Porosity |The percent of pore space the injection zone |Class I UIC Wells- |IZ_POROSITY | |Number (3) | |
| |formation rock contains (measured in %). |User’s Guide (1996) | | | | |
|USDW Depth |The depth (in feet) to the base of the |Class 1 UIC Wells- |USDW_DEPTH | |Number (6) | |
| |underground source of drinking water (USDW) |User’s Guide (1996) | | | | |
| |
|17. Table WASTE (Class I only): the Resource Conservation and Recovery Act (RCRA) waste code and generalized waste source |
|Waste ID |Unique identification of Waste table - The first |UIC Team |WASTE_ID |Primary key |Character (20) | |
| |four characters are the primacy agency code | | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |unique waste information (e.g. WYEQ00000793, …) | | | | | |
|Waste Code |The RCRA waste code for single or multiple |Class I UIC Wells- |WASTE_CODE | |Character (4) | |
| |constituents in the waste stream |User’s Guide (1996) | | | | |
|Waste Stream |A classification of the waste stream that |Class I UIC Wells- |WASTE_STREAM | |Character (100) | |
| |contains various constituents and waste codes in |User’s Guide (1996) | | | | |
| |various concentrations. These are liquids waste | | | | | |
| |approved to go down the well. | | | | | |
|Well ID |Unique identification of an injection well |UIC Team |WELL_ID |Foreign key |Character (20) | |
| |
|18. Table CONSTITUTENT (Class I only): Names of the chemicals in the waste stream and their concentration value in milligrams per liter |
|Constituent ID |Unique identification of Constituent table - The|UIC Team |CONSTITUENT_ID |Primary key |Character (20) | |
| |first four characters are the primacy agency code| | | | | |
| |(appendix D). The rest is DI program or State’s | | | | | |
| |choice (letters and numbers only) identifying | | | | | |
| |constituent information (e.g. WYEQ0000000000 | | | | | |
| |000389, …) | | | | | |
|Concentration Value |The concentration of the individual waste |Class I UIC Wells- |CONCENTRATION | |Number (11,5) | |
| |constituent as reported by EPA Regional staff |User’s Guide (1996) & | | | | |
| |and/or state agency staff (measured in mg/l or |UIC Team | | | | |
| |pCi/l) | | | | | |
|Concentration Unit |Unit of measuring concentration (mg/l or pCi/l) |UIC Team |UNIT | |Character (5) |See appendix C |
|Constituent Name |The chemical name or a description of the waste, |UIC Team |CONS_NAME | |Character (50) | |
| |in accordance with EPA Chemical/Biological | | | | | |
| |Internal Tracking Name ( )| | | | | |
|Waste ID |Unique identification for waste records - |UIC Team |WASTE_ID |Foreign key |Character (20) | |
APPENDIX A
Definitions and Acceptable Values for Locational Table Attributes
Accuracy Value and Unit
Quantitative measurement of the amount of deviation from true value in a measurement for latitude or
longitude (estimate of error). It describes the correctness of the latitude/longitude measurement, in meters.
Only the least accurate measurement is recorded, regardless whether it is for longitude or latitude.
Location Description
Category of the feature referenced by the latitude and longitude.
001 UNKNOWN
102 FACILITY CENTER
026 WELL
101 FACILITY ENTRANCE
103 FACILITY BOUNDARY
108 OTHERS
Horizontal Datum
Reference standard for three dimensional and horizontal positioning established by the U.S. National
Geodetic Survey (NGS) and other bodies. Source: SDWIS/FED Team
001 NAD 27
002 NAD 83
003 WGS 84
004 UNKNOWN
Method of Collection
Method used to determine the latitude/longitude. This represents the primary source of the data. Source:
SDWIS/FED Team
001 ADDRESS MATCHING - HOUSE NUMBER
007 ADDRESS MATCHING - OTHER
011 CENSUS - OTHER
012 GLOBAL POSITIONING SYSTEM (GPS) CARRIER PHASE STATIC RELATIVE
POSITIONING
013 GPS CARRIER PHASE KINEMATIC RELATIVE POSITIONING TECHNIQUE
014 GPS CODE MEASUREMENTS (PSEUDO RANGE) DIFFERENTIALLY
CORRECTED
015 GPS CODE MEASUREMENTS (PSEUDO RANGE) PRECISE POSITIONING
SERVICE
016 GPS CODE MEASUREMENTS (PSEUDO RANGE) STANDARD POSITIONING
SERVICE SA OFF
017 GPS CODE MEASUREMENTS (PSEUDO RANGE) STANDARD POSITIONING
SERVICE SA ON
021 INTERPOLATION - OTHER
022 LORAN C
023 PUBLIC LAND SURVEY - QUARTER SECTION
024 PUBLIC LAND SURVEY - SECTION
025 CLASSICAL SURVEYING TECHNIQUES
026 ZIP CODE - CENTROID
027 UNKNOWN
028 GPS - UNSPECIFIED
Point-Line-Area
Value indicating whether the latitude and longitude coordinates represent a point, multiple points on a line, or
an area. Source: SDWIS/FED Team
001 POINT (DEFAULT)
Source Scale
Scale of the map used to determine the latitude and longitude coordinates. Source: SDWIS/FED Team
NA SCALE NOT APPLICABLE TO COLLECTION METHOD
1 >= 1:500
2 BETWEEN 1:500 AND 1:5,000
3 BETWEEN 1:5,000 AND 1:10,000
A 1:10,000
B 1:12,000
C 1:15,840
D 1:20,000
E 1:24,000
F 1:25,000
G 1:50,000
H 1:62,500
I 1:63,360
J 1:100,000
K 1:125,000
L 1:250,000
M 1:500,000
U UNKNOWN
Well Latitude
Coordinate representation indicating a location on the surface of the earth, using the earth's Equator as the origin, reported in decimal degrees.
Well Longitude
Coordinate representation indicating a location on the surface of the earth, using the Prime Meridian (Greenwich, England) as the origin, reported in decimal degrees.
***************************************************
Source: Adapted for UIC program from Locational Data Requirements in Safe Drinking Water Information System (SDWIS)
APPENDIX B
Underground Injection Well Class Categories and Codes
Well converted from injection to non-injection (production, monitoring, etc.) Code: “CV”
Class I
|Categories |Code |
|Municipal |1M |
|Hazardous Industrial |1H |
|Non-Hazardous Industrial |1I |
|Radioactive Waste Disposal |1R |
|*CO2 Sequestration |1C *** |
|*Drinking Water Treatment Residual |1W *** |
|Other |1X |
Class II
|Categories |Codes |
|Produced Fluid Disposal |2D *** |
|Annular Disposal |2A |
|Enhanced Recovery |2R *** |
|Hydrocarbon Storage |2H *** |
|Coal Bed Methane Hydro-fracturing wells |2M |
|*CO2 Sequestration |2C *** |
|* Drinking Water Treatment Residual |2W *** |
|Other |2X |
Class III
|Categories |Codes |
|Salt Solution Mining |3A*** |
|In Situ Gasification |3G *** |
|Uranium Mining |3U |
|Sulfur Mining |3S |
|Copper Mining |3C |
|Nacholite Mining |3N |
|Other Minerals |3X |
Class IV
|Categories |Codes |
|Authorized as part of RCRA or CERCA cleanup |4A |
|Prohibited activity |4P |
Class V
|Categories |Injection wells in category |Corresponding injection wells in 1987 report to Congress |Codes |
|Beneficial Use | | |5B |
| |Aquifer recharge |5R21 (Aquifer Recharge). |5B1 |
| |Salt water intrusion barrier |5B22 (Saline Water Intrusion Barrier). |5B2 |
| |Subsidence control |5S23 (Subsidence Control). |5B3 *** |
| |Aquifer storage and recovery |Not addressed as separate category |5B4 *** |
| |Subsurface environmental remediation |5X26 (Aquifer Remediation Related). |5B6 |
|Fluid Return | | |5C |
| |Wells used to inject spent brines after the extraction of minerals |5X16 (Spent-brine Return Flow). |5C1*** |
| |from produced fluids | | |
| |Wells used to inject heat pump return fluids |5A7 (Heat Pump/Air Conditioning Return Flow), |5C2 |
| | |5A6 (Direct Heat Return). |5C3 *** |
| |Wells used to inject fluids that have undergone chemical alteration |5A5 (Electric Power Return), |5C4 *** |
| |during the production of geothermal energy for heating, aquaculture, | | |
| |or production of electric power. | | |
| | |5A8 (Ground |5C5 *** |
| | |Water Aquaculture Return Flow). | |
|Sewage Treatment Effluent |Wells used to inject treated effluent from Publicly Owned Treatment |5W12 (Domestic Wastewater Treatment Plant Effluent |5D |
| |Works (POTWs), or privately owned treatment works receiving solely |Disposal). | |
| |sanitary waste. | | |
|Cesspools |Cesspools having the capacity to serve 20 persons or more per day and|5W9 (Untreated Sewage Waste Disposal), |5E |
| |used solely for the subsurface emplacement of sanitary waste. |5W10 (Cesspools). | |
| | | | |
|Septic Systems |Septic tank and subsurface fluid distribution system having the |5W11 (Septic Systems - Undifferentiated Disposal) |5F |
| |capacity to serve 20 persons or more per day and used solely for the |5W32 (Septic Systems –Drainfield Disposal) | |
| |subsurface emplacement of sanitary waste. |5W31 (Septic Systems - Well Disposal). | |
|Experimental Technology |Injection wells used in experimental technologies. | |5G |
| | |5X25 (Other Experimental Technology). |5G1 *** |
| | |* CO2 Sequestration |5G2 *** |
|Drainage |Wells used to drain surface and subsurface fluids, including | |5H |
| |stormwater runoff and agricultural drainage that may have the | | |
| |potential to receive insignificant amounts of waste due to small | | |
| |volume leaks, drips, or spills. | | |
| | |5D2 (Stormwater Drainage), |5H1 |
| | |5F1 (Agricultural Drainage), |5H2 |
| | |Other Drainage |5H3 |
|Mine Backfill and Drainage |Wells used to inject materials into mined out |5X13 (Mining, Sand, or Other Backfill). |5I |
| |portions of subsurface mines, whether what is injected is a | | |
| |radioactive waste or not, including: (1) slurries of sand, gravel, | | |
| |cement, mill tailings/refuse, fly ash, or other solids, and (2) mine | | |
| |drainage. | | |
|Waste Discharge Well | | |5J |
| In Situ and Solution |Wells used to inject fluids for the purpose of producing minerals or | |5L |
|Mining |energy, which are not Class II or III wells. | | |
| | |5X14 (Solution Mining),. |5L1 |
| | |5X15 (In situ Fossil Fuel Recovery) |5L2 *** |
|Motor Vehicle Waste |Wells used to inject fluids from motor vehicle repair or maintenance |5X28 (Automobile Service Station Disposal). |5K |
|Disposal |activities, such as an auto body repair shop, automotive repair shop,| | |
| |car dealership, specialty repair shop (e.g., transmission and muffler| | |
| |repair shop), or any facility that does any vehicular repair work. | | |
|Industrial Well |Wells or septic systems used to inject fluids from: | |5A |
| |Carwashes | |5A1 |
| |Carwashes where no engine or undercarriage washing is performed | |5A2 |
| |Appliance service and repair facilities | |5A3 |
| |Beauty Shops / Barber Shops | |5A4 |
| |Nail salons | |5A5 |
| |Dry cleaners | |5A6 |
| |Laundromats where no on-site dry cleaning is performed | |5A7 |
| |Funeral services | |5A8 |
| |Wood / Furniture finishing facilities | |5A9 |
| |Machine and welding shops | |5A10 |
| |Medical service facilities | |5A11 |
| |Pesticide application service facilities | |5A12 |
| |Photographic processing facilities | |5A13 |
| |Printing facilities | |5A14 |
| |Veterinary, kennel and pet grooming service facilities | |5A15 |
| |Metal plating / fabrication facilities | |5A16 |
| |Equipment manufacturing / repair plants | |5A17 |
| |Cooling water with no additives | |5A18 |
| |Cooling water with additives | |5A19 |
| |Food processing operations | |5A20 |
| |Small engine repair shops | |5A21 |
| |*CO2 Sequestration | |5A22 *** |
| |* Drinking Water Treatment Residual | |5A23 *** |
| |Any other wells used to inject non-hazardous wastewaters generated by| |5A24 |
| |industrial, commercial, and service establishments and that are not | | |
| |included in one of the above categories | | |
|Other | | |5X |
* Depending on well class assigned by the state or DI region (e.g. if state assigned CO2 Sequestration in Class 1, the data provided will be “1C”; Class 2 will be “2C”; Class 5 will be “5G2" [Experimental Technology] or “5A22” [Industrial Well])
*** Wells required geology and engineering data
APPENDIX C
Acceptable Values
1. Table FACILITY:
Facility Petition Status (Facility table):
|Description |Code |
|Approved |AP |
|Disapproved |DA |
|Not Applicable |NA |
Facility Type:
|Description |Code |
|Commercial |C |
|Non-Commercial |N |
|Unknown |U |
Facility State:
|Description |Code |
|Alabama |AL |
|Alaska |AK |
|American Samoa |AS |
|Arizona |AZ |
|Arkansas |AR |
|California |CA |
|Colorado |CO |
|Connecticut |CT |
|Delaware |DE |
|District of Columbia |DC |
|Federated States of Micronesia |FM |
|Florida |FL |
|Georgia |GA |
|Guam |GU |
|Hawaii |HI |
|Idaho |ID |
|Illinois |IL |
|Indiana |IN |
|Iowa |IA |
|Kansas |KS |
|Kentucky |KY |
|Louisiana |LA |
|Maine |ME |
|Marshall Islands |MH |
|Maryland |MD |
|Massachusetts |MA |
|Michigan |MI |
|Minnesota |MN |
|Mississippi |MS |
|Missouri |MO |
|Montana |MT |
|Nebraska |NE |
|Nevada |NV |
|New Hampshire |NH |
|New Jersey |NJ |
|New Mexico |NM |
|New York |NY |
|North Carolina |NC |
|North Dakota |ND |
|Northern Mariana Islands |MP |
|Ohio |OH |
|Oklahoma |OK |
|Oregon |OR |
|Palau |PW |
|Pennsylvania |PA |
|Puerto Rico |PR |
|Rhode Island |RI |
|South Carolina |SC |
|South Dakota |SD |
|Tennessee |TN |
|Texas |TX |
|Utah |UT |
|Vermont |VT |
|Virgin Islands |VI |
|Virginia |VA |
|Washington |WA |
|West Virginia |WV |
|Wisconsin |WI |
|Wyoming |WY |
North American Industry Classification System Code (NAICS Code) and Standard Industrial Classification Code (SIC Code):
3. Table PERMIT:
Authorization Status:
|Description |Code |Comments |
|Individual Permit |IP | |
|Area Permit |AP |May apply to Class V wells that are co-located |
| | |at the same facility |
|General Permit |GP | |
|Emergency Permit |EP | |
|Other Permit |OP |Permit associated with other program (i.e., |
| | |CERCLE, etc.) |
|Rule Authorized |RA | |
|None or Unauthorized |NO |For wells that currently do not have authorized|
| | |status for operation |
Ownership Type:
|Description |Code |
|Private - Business or other for-profits |PB |
|Private - Not-for-profit institutions |PN |
|Private – Farms |PF |
|Private – in general (not fit any “private” items above) |PV |
|Federal government |FG |
|Other - Individual or household |OI |
|Other - State, Local government |OS |
|Other - Tribal government |OT |
|Other – in general (not fit any “other” items above) |OR |
4. Table PERMIT ACTIVITY:
Permit Action Type:
|Description |Code |
|Application for Permit Issuance |AI |
|Application for Major Permit Modification |AM |
|Permit Issued |PI |
|Permit Denied |PD |
|Permit Withdrawn |PN |
|Approved Major Permit Modification |PM |
|File Reviewed |FR |
5. Table WELL:
Aquifer Exemption:
|Description |Code |
|Yes |Y |
|No |N |
|Unknown |U |
High Priority:
|Description |Code |
|Yes |Y |
|No |N |
|Unknown |U |
State/Tribe:
State list: See Facility State under Table Facility
Tribal list: Click the icon below to open the tribal codes list:
[pic]
The tribal list can also be found at EPA’s Environmental Data Registry Web site:
Well in Source Water Area:
|Description |Code |
|Well is in a delineated source water area (subset of sensitive ground water area) |Y |
|Well is in a sensitive ground water area outside of SWA. |S |
|Well is NOT in the sensitive ground water area (including SWA) |N |
|Unknown (considered to default as a sensitive ground water area) |U |
6. Table WELL_STATUS:
Well Operating Status:
|Description |Code |
|Active |AC |
|Under Construction |UC |
|Temporarily Abandoned or Inactive |TA |
|Permanently Abandoned and Approved by State |PA |
|Permanently Abandoned and not Approved by State |AN |
|Proposed Well (associated with permit application only) |PW |
|Post Injection (CO2 Well) |PI |
9. Table VIOLATION:
Contamination:
|Description |Code |
|Yes |Y |
|No |N |
|Unknown |U |
Well Endangering:
|Description |Code |
|Yes |Y |
|No |N |
|Unknown |U |
Violation Significant:
| Description |Code |
|Violation is significant |Y |
|Violation is not significant |N |
|Unknown |U |
Violation Type:
|Description |Code |
|Unauthorized Injection |UI |
|Well Mechanical Integrity |MI |
|Well Mechanical Integrity -- Other (not MI Loss) |MO |
|Injection Pressure |IP |
|Plugging and Abandonment |PA |
|Formal Order |FO |
|Falsification |FA |
|Monitoring and Reporting |MR |
|Failure to Inventory |FI |
|Failure to Respond |FR |
|Operation and Maintenance |OM |
|Other |OT |
11. Table ENFORCEMENT:
Enforcement Action Type:
|Description |Code |
|Notice of Violations |NOV |
|Consent Agreement |CGT |
|Draft Administrative Order |DAO |
|Civil Referral |CIR |
|Criminal Referral |CRR |
|Well Shut-in |SHT |
|Pipeline Severance |PSE |
|Termination of Authority |TOA |
|Final Administrative Order |FAO |
|Other |OTR |
12. Table INSPECTION:
Assistance:
|Description |Code |
|(1) General only |GN |
|(2) Site-specific only |SS |
|Both (1) & (2) |BH |
|No Compliance Assistance |NO |
Deficiency:
|Description |Code |
|Deficiency not Observed |OS |
|Deficiency Observed but not Communicated |CM |
|Deficiency Observed and Communicated |BH |
|No Deficiency |NO |
ICIS Compliance Monitoring Action Reason (DI Programs only):
|Description |Code |
|Agency Priority |AP |
|Core Program |CP |
|Selected Monitoring Action |MA |
ICIS Compliance Monitoring Type (DI Programs only):
|Description |Code |
|Compliance Assistance Inspection |CAI |
|Compliance Evaluation Inspection |CEI |
|Compliance Schedule Evaluation |CSE |
|Industry User Inspection |IUI |
|Compliance Evaluation Inspection Without Sampling |IWS |
|Onsite Corrective Action Inspection |OCA |
|On-Site Visit |OSV |
|Overview Inspection |OVI |
|Primacy Inspection |PRM |
|Voluntary |VLN |
ICIS Compliance Activity Type (DI Program only):
|Description |Code |
|Information Request |IR |
|Compliance Inspection |CS |
|Compliance Investigation |CV |
|Off-site Record Review |OR |
|Voluntary Disclosure |VD |
Inspection Type:
|Description |Code |
|Mechanical Integrity Tests Witnessed |MI |
|Emergency Response | Complaint Response |EC |
|Constructions Witnessed |CO |
|Well Plugging Witnessed |WP |
|Routine | Periodic Inspections |RP |
|No Well (for facilities that have no wells) |NW |
|Other |OT |
|Facility Inspection (temporary) |FI |
13. Table CORRECTION:
Corrective Action Type:
|Description |Code |
|Verified compliance with previously issued enforcement action – part or all conditions |VE |
|Corrected record-keeping deficiencies |RK |
|Corrected monitoring deficiencies |MD |
|Completed a notification or a report |NO |
|Requested a permit application |PA |
|Implemented new or improved management practices or procedures |NM |
|Improved pollutant identification (e. g., labeling, manifesting, storage, etc.) |IP |
|Reduced pollution (e.g., use reduction, industrial process change, emissions or discharge change, etc.) |RP |
|Shut-in well |SI |
|Other (detailed in “Comment” column) |OT |
14. Table MI-TEST:
Mechanical Integrity Test Result:
|Description |Code |
|Pass |PS |
|Fail and unknown if release to the environment |FU |
|Fail and potential release to the environment |FP |
|Fail and actual release to the environment |FA |
Mechanical Integrity Test Type:
|Description |Code |
|Part One Tests—For Significant Leak: (146.8)(a)(1) |
|Annulus Pressure Monitoring Record Evaluation |AP |
|Casing | Tubing Pressure Test |CT |
|Monitoring Record Evaluation |MR |
|Water-Brine Interface |WI |
|Water-In-Annulus |WA |
|“Ada” Pressure Test |AT |
|Single Point Resistivity Test |SR |
|Other Significant Leak Test |OL |
|Part Two Tests—For Fluid Migration: (146.8)(a)(2) |
|Cement Record Evaluation |CR |
|Temperature | Noise Log Test |TN |
|Radioactive Tracer |RC |
|Cement Bond Test |CB |
|Oxygen Activation method |OA |
|Radioactive Tracer Survey |RS |
|Dual Completion Monitoring Test |DC |
|Other Fluid Migration Test |OF |
Remedial Action Type:
|Description |Code |
|Casing Repaired | Squeeze Cement |CS |
|Tubing | Packer |TP |
|Plugging | Abandonment |PA |
|Other |OT |
18. Table CONSTITUENT
Concentration Unit:
|Description |Code |
|Milligram per litter |mg/l |
|Picocurie (pCi) per litter |pCi/l |
APPENDIX D
Primacy Agency Code Used for Database Primary Keys
* The four-character code of UIC primacy agencies created ONLY for use in the National UIC database. So they may not be the abbreviation of primacy agencies used by states
|UIC Primacy Agency | Code |
|For Testing |TEST |
|US EPA Region I | 01DI |
|Connecticut Department of Environmental Protection. | CTEP |
|Connecticut Department of Public Health | CTPH |
|Maine Department of Environmental Protection | MEEP |
|Maine Department of Public Health | MEPH |
|Massachusetts Department of Environmental Protection | MAEP |
|New Hampshire Department of Environmental Services | NHES |
|Rhode Island Department of Environmental Management | RIEM |
|Vermont Department of Environmental Conservation | VTEC |
|USEPA Region 2 | 02DI |
|New Jersey Dept. of Environmental Protection | NJEP |
|Puerto Rico Environmental Quality Board of Water Quality | PREQ |
|USEPA Region 3 | 03DI |
|Delaware Department of Natural Resources and Environmental Control | DENR |
|Maryland Department of the Environment | MDDE |
|West Virginia Division of Environmental Protection | WVEP |
|USEPA Region 4 | 04DI |
|State Oil and Gas Board of Alabama | ALOG |
|Alabama Dept. of Environmental Management | ALEM |
|Florida Department of Environmental Protection | FLEP |
|Georgia Department of Natural Resources | GANR |
|Mississippi Oil and Gas Board | MSOG |
|Mississippi Department of Environmental Quality | MSEQ |
|North Carolina Dept. of Environment and Natural Resources | NCEN |
|South Carolina Department of Health and Environmental Control | SCHE |
|Tennessee Department of Environment and Conservation |TNEC |
|USEPA Region 5 | 05DI |
|Illinois Department of Natural Resources | ILNR |
|Illinois Environmental Agency | ILEA |
|Indiana Department of Natural Resources/Oil and Gas Division | INNR |
|Ohio Department of Natural Resources | OHNR |
|Ohio Environmental Agency | OHEA |
|Wisconsin Department of Natural Resources | WINR |
|USEPA Region 6 | 06DI |
|Arkansas Department of Environmental Quality | AREQ |
|Arkansas Oil and Gas Commission | AROG |
|Louisiana Department of Natural Resources | LANR |
|New Mexico Energy, Minerals, and Natural Resources - Oil Conservation Division | NMNR |
|New Mexico Environment Department | NMED |
|Oklahoma Department of Environmental Quality | OKEQ |
|Oklahoma Corporation Commission | OKCC |
|Texas Railroad Commission | TXRC |
|Texas Commission on Environmental Quality | TXEQ |
|USEPA Region 7 | 07DI |
|Kansas Corporation Commission-Conservation Division | KSCC |
|Kansas Department of Health and Environment | KSHE |
|Missouri Department of Natural Resources | MONR |
|Nebraska Department of Environmental Quality | NEEQ |
|Nebraska Oil and Gas Conservation Commission | NEOG |
|USEPA Region 8 | 08DI |
|Colorado Oil and Gas Conservation Commission | COOG |
|Montana Board of Oil and Gas Conservation | MTOG |
|North Dakota Department of Health | NDOH |
|North Dakota Industrial Commission - Oil and Gas Division | NDOG |
|South Dakota Department of Environmental and Natural Resources | SDEN |
|Utah Department of Natural Resources | UTNR |
|Utah Department of Environmental Quality | UTEQ |
|Wyoming Oil and Gas Conservation Commission | WYOG |
|Wyoming Department of Environmental Quality | WYEQ |
|Fort Peck Tribes |FPT8 |
|USEPA Region 9 | 09DI |
|California Department of Conservation; Division of Oil, Gas and Geothermal Resources | CAOC |
|Guam Environmental Protection Agency | GUEA |
|Commonwealth of Northern Mariana Islands, Division of Environmental Quality | MPEQ |
|Nevada Division of Environmental Protection | NVEP |
|Navajo Nation Environmental Protection Agency |NNUI |
|USEPA Region 10 | 10DI |
|Alaska Oil and Gas Conservation Commission | AKOG |
|Idaho Department of Water Resources | IDWR |
|Oregon Department of Environmental Quality | OREQ |
|Washington Department of Ecology | WADE |
-----------------------
PK: Primary Key
FK: Foreign Key
[pic]: one-to-one relationship
[pic]: one-to-many relationship (min 0)
[pic]: one-to-many relationship (min 1)
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.