Engineering Survey Database Dictionary (EPA-HQ-OW-2010-0824, DCN CBM00655)

3/14/2013

Purpose: This document defines each field name in each table in the database.

Notes:

FieldName FieldType FieldDescription

RecordID AutoNumber Unique ID given to each operator + project

Basin Text Basin in which project operates

Operator Name Text Name of operator

SCRN ID Text Screener ID

SCR_OID number Text Operator ID in Screener database

SCR_Project ID Text Project ID in Screener database

SCR_Project Name Text Project Name in Screener database

DB_OID Text Operator ID in ENG database

DB_ProjectID Text Project ID in ENG database

DB_Project Name Text Project Name in ENG database

Small business Yes/No Is the operator a small business?

SummProjDischStat Text Discharge status of project and source of discharge status (i.e., screener or DQ data)

SummBasinOpDischStat Text Discharge status(es) of given operator + basin and source of discharge status (i.e., screener or DQ data)

SummOpDischStat Text Discharge status(es) of given operator and source of discharge status (i.e., screener or DQ data)

In SCR db Yes/No Is the project in the screener database?

Rcvd DQ Yes/No Did the operator receive a DQ requesting data for this project?

ENGDB_Include Yes/No Is this project included in the ENG database?

ECONDB_Include Yes/No Is this project included in the ECON database?

DB_# Wells Number How many wells does the project have, according to the ENG database?

DB_Respondent Yes/No Did the operator respond to the DQ for this project?

DB_Partial/Non-Resp Yes/No Did the operator partially respond/not respond to the DQ for this project?

DB_Out of Scope Yes/No Is this project out of scope?

DB_No PW Yes/No Does this project have no produced water, according to the ENG database?

DB_Combined proj Yes/No Was this project combined with another project?

DB_DD Yes/No Does this project direct discharge, according to the ENG database?

DB_ID Yes/No Does this project indirect discharge, according to the ENG database?

DB_ZD Only Yes/No Does this project zero discharge only, according to the ENG database?

DB_New proj Yes/No Is this a new project, according to the ENG database?

SCR_# Wells Number How many wells does the project have, according to the Screener database?

SCR_# Proj Number How many projects are reported with this project in the Screener database?

SCR_Respondent Yes/No Is this project a screener respondent?

SCR_No PW Yes/No Does this project have no produced water, according to the Screener database?

SCR_DD Yes/No Does this project direct discharge, according to the Screener database?

SCR_ID Yes/No Does this project indirect discharge, according to the Screener database?

SCR_ZD Only Yes/No Does this project zero discharge only, according to the Screener database?

Revised_# Wells Number Combined # of wells from the Screener and DQ. Where DQ data was unavailable for a project, screener data was used.

Additional Notes Text Additional notes

FieldName FieldType FieldDescription

CF_ID AutoNumber Sequential Comment/Flag Number

Source Text

Indicates the source of the record (comment or flag). These include operator comments submitted with survey, 

operator comments from follow-up phone calls, and comments made by survey reviewers.

SourceID Double Sequential Source Number

OperatorID Double Unique operator ID autogenerated by database to associate tables

ProjPWMSystemID Double Unique ID for Proj + PWMS combination

TableName Text Name of table which comment/flag refers to

FieldName Text Name of field which comment/flag refers to

FieldType Text Indicates whether the record is an estimated value, flag, issue, comment, or revision

Question Text Question Number which comment/flag refers to

CF_CBI Yes/No Is this comment or flag CBI?

Comment Memo Comment

Issue Memo

This field was populated when an issue could not be resolved and was added to align with Form B, a review form from 

the Quality Assurance Project Plan for the Review and Data Entry of the Engineering Portions of the Coalbed Methane 

Questionnaire (CBM00691)

FlagType Text Categorizes the comments/flags (e.g., Treatment cost, 2008$ Conversion)

Aqua highlight indicates a field that is a manipulation of a Detailed Questionnaire response (e.g., conversion of a Detailed Questionnaire response to a standard year or 

unit).

Where possible, the Detailed Questionnaire question number was included in the field name.

Basin_Op_Proj_05-2012_final

Comments_Flags

Table provides information about projects in the entire CBM industry using data from both the Screener and the DQ.

Table provides information from operator comments in the DQ and ERG reviewer comments/flags during survey data entry into the database.
FieldName FieldType FieldDescription

OperatorID Long Integer Unique operator ID autogenerated by database to associate tables

C1_1CBI Yes/No Is question C1-1 CBI?

C1_1_ContactName Text Primary contact name

C1_1_ContactTitle Text Primary contact title

C1_1_ContactEmail Text Primary contact email

C1_1_ContactPhone Text Primary contact telephone number

C1_1_ContactFax Text Primary contact fax

C1_1_ContactTime Text Primary contact time to call

FieldName FieldType FieldDescription

DB_OID Text Operator ID in ENG database

Classification Text Classifies the operator responses as Reviewed, NonRespondent, NoPW, or OutofScope

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

HighPressureFilterID AutoNumber Sequential number for each filter within a treatment system

C3_12_CBI Yes/No Is question C3-12 CBI?

C3_12_Design Double Design capacity (bbl/d)

C3_12_Volume Double Volume of produced water entering high-pressure filtration treatment system

C3_12_VolUnits Text Units of volume

C3_12_FilterType Text (fixed width) Type of filter

C3_12_OthFilterType Text Description of other type of filter

C3_12_Vendor Text Vendor/Unit name

C3_12_CleanFreq Double Average cleaning frequency

C3_12_CleanFreqUnits Text Units of average cleaning frequency

C3_12_MemLife Double Membrane life (years)

C3_12_Chemicals Text Chemicals added

C3_12_CapCost Double Capital cost of filtration system (dollars)

C3_12_2008OandM Double 2008 Operating and maintenance cost of treatment system

C3_12_PilotProject Yes/No Pilot project

C3_12_CapCostYear Text Capital cost year

C3_12_VolUnits_raw Text Raw units of volume

C3_12_Volume_raw Double Raw volume of produced water entering high-pressure filtration treatment system

2008_CapCost Long Integer Capital cost of treatment system (dollars) in 2008$

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

HighPressureFilterID Text Unique ID for high pressure filtration treatment system

C3_12_Parameter Text Parameter name

C3_12_RemEff Text Estimated removal efficiency

C3_12_Basis_Comments Memo Comments

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

IonExchangeID AutoNumber Sequential (unique ID) for each ion exchange treatment unit

C3_10_CBI Yes/No Is question C3-10 CBI?

C3_10_Design Long Integer Design capacity (acre-feet)

C3_10_Volume Long Integer Volume of produced water into ion exchange treatment unit

C3_10_VolUnits Text Units of volume

C3_10_VendorName Text Vendor/Unit name

C3_10_Resin Text Resin name/description

C3_10_RegenFreq Long Integer Average regeneration frequency

C3_10_RegenFreqUnits Text Units of average regeneration frequency

C3_10_AvgLife Long Integer Average resin life (years)

C3_10_Chemicals Text Chemicals added

C3_10_CapCost Long Integer Capital cost of ion exchange unit (dollars)

C3_10_CapCostYear Text Capital cost year

C3_10_2008OandM Long Integer 2008 Operating and maintenance cost of ion exchange treatment unit

C3_10_PilotProject Yes/No Pilot project

Table provides information about treatment capability of high pressure filtration treatment units.

Table provides contact information for the CBM operator.

EPA Classification

Table documents the type of response received from each operator.

HighPressureFiltration_Final

IonExchange_Final

HighPressureFiltrationParameters

ContactInfo_FINAL
C3_10_VolUnits_raw Text Raw units of volume

C3_10_Volume_raw Double Raw volume of produced water entering ion exchange treatment system

2008_CapCost Long Integer Capital cost of ion exchange (dollars) in 2008$

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

IonExchangeID Text Unique ID for each ion exchange treatment system

C3_10_Parameter Text Parameter name

C3_10_RemEff Text Estimated removal efficiency

C3_10_Basis_Comments Memo Comments

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

LowPressureFilterID AutoNumber Sequential ID for each filter within a system

C3_11_CBI Yes/No Is question C3-11 CBI?

C3_11_Design Double Design capacity (bbl/d)

C3_11_Volume Double Volume of produced water entering low-pressure filtration system

C3_11_VolUnits Text Units of volume

C3_11_FilterType Text (fixed width) Type of filter

C3_11_OthFilterType Text Description of other type of filter

C3_11_Vendor Text Vendor/Unit name

C3_11_CleanFreq Double Average cleaning frequency

C3_11_CleanFreqUnits Text Units of average cleaning frequency

C3_11_Chemicals Text Chemicals added

C3_11_CapCost Double Capital cost of filtration system (dollars)

C3_11_2008OandM Double 2008 Operating and maintenance cost of low-pressure filtration system

C3_11_PilotProject Yes/No Pilot project

C3_11_CapCostYear Text Capital cost year

C3_11_VolUnits_raw Text Raw units of volume

C3_11_Volume_raw Double Raw volume of produced water entering low-pressure filtration system

2008_CapCost Long Integer Capital cost of treatment system (dollars) in 2008$

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

LowPressureFilterID Text Unique ID for each low-pressure treatment system

C3_11_Parameter Text Parameter name

C3_11_RemEff Text Estimated removal efficiency

C3_11_Basis_Comments Memo Comments

FieldName FieldType FieldDescription

OperatorID AutoNumber Unique operator ID autogenerated by database to associate tables

OperatorIdentifier Text Operator ID in ENG database; unique operator code assigned when survey was sent

Name Text Company name

allCBI Yes/No Indicates whether or not entire survey is CBI

A1_1_CBM_screener Yes/No Did operator respond to EPA’s screener questionnaire on CBM projects?

Address Text Company address

CertDate Text Date of Certification

CertName Text Certifying Official's Name

CertTitle Text Certifying Official's Title

CertFacility Text Facility Name

CertPhone Text Certifying Official's Telephone Number

SmallBusiness Yes/No Indicates whether or not operator is a small business

Screener Yes/No Indicates whether or not operator received a screener

SID Text Contains screener ID if Screener = yes in above field

FieldName FieldType FieldDescription

ProjPWMSystemID Number Unique ID for Proj + PWMS combination

C4_1_CBI Yes/No Is question C4-1 CBI?

C4_1DataSubmitted Yes/No Was own data submitted as attachment to Detailed Quesionnaire?

Operators

Table provides information about the CBM operator.

PollutantData_Final

Table provides information about whether or not there is pollutant data associated with each project. Due to the quantity of hardcopy data received with the Detailed Questionnaire responses, survey 

reviewers only converted hardcopy data into electronic data for discharging projects.

Table provides information about treatment capability of low pressure filtration units.

IonExchangeParameters

Table provides information about treatment capability of ion exchange treatment units.

LowPressureFiltrationParameters

LowPressureFiltration_Final
C4_2_CBI Yes/No Is question C4-2 CBI?

C4_2a_WET Yes/No Indicates performance of whole effluent toxicity testing for this PWMS

C4_2b_WETInfo Memo Information on the WET testing conducted

C4_2c_ToxExceeded Yes/No Has toxicity ever exceeded permit limits?

C4_2d_Study Yes/No Was a TIE, TRE or other study performed to determine the cause, treatability, or efective management of toxicity?

C4_2d_StudyCost Long Integer 2008 Annual Costs for TIE and TRI ($)

C4_2e_ToxIssue Memo Description of the cause of the toxicity and the final resolution of the toxicity issue

C4_2e_ToxAttached Yes/No Is a copy of the study attached?

FieldName FieldType FieldDescription

ProjectID AutoNumber Unique project ID autogenerated by database to associate tables

OperatorID Long Integer Unique operator ID autogenerated by database to associate tables

ProjectIdentifier Text Unique name assigned by survey reviewer, or taken straight from survey for the project

NumberOfWells Long Integer Number of wells associated with project

FieldName FieldType FieldDescription

ProjPWMSystemID AutoNumber Unique ID for Proj + system combination

ProjectID Long Integer Unqiue Project ID, links to Projects table

PWMSystemID Long Integer Unique PWMS system ID

OperatorID Long Integer Unique operator ID, links to Operators table

NoDataFound Yes/No Indicates whether or not there was data for the given PWMS.

TablesFound Text Indicates which tables in the database contain information about the given PWMS

FieldName FieldType FieldDescription

ProjectWellsID AutoNumber Sequential WellsID Number

OperatorID Long Integer Unique operator ID autogenerated by database to associate tables

ProjectID Long Integer Unique project ID autogenerated by database to associate tables

APINumber Text Well API Number

PermitNumber Text Permit Number

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

C3_1_Destination Text Code associated with selected destination

C3_1_CBI Yes/No Is question C3-1 CBI?

C3_1_OtherDesc Text Description of other destination (if applicable)

C3_2_CBI Yes/No Is question C3-2 CBI?

C3_2_Volume Double 2008 volume of produced water from this PWMS to this destination

C3_2_VolumeUnits Text Units for volume

C3_2_MaxDayCap Double Maximum daily capacity of produced water from this PWMS capable of going to this destination

C3_2_MaxDayCapUnits Text Units for maximum daily capacity

C3_2_CapCostPercent Double Percent of total capital cost for this destination

C3_2_Tanks Yes/No Are tanks included in the capital costs?

C3_2_Pumps Yes/No Are pumps included in the capital costs?

C3_2_Piping Yes/No Are piping/hoses included in the capital costs?

C3_2_Outfall Yes/No Is outfall structure included in the capital costs?

C3_2_InjWell Yes/No Are injection wells included in the capital costs?

C3_2_Pond Yes/No Are ponds included in the capital costs?

C3_2_TrtUnit Yes/No Are treatment units included in the capital costs?

C3_2_Liner Yes/No Are liners included in the capital costs?

C3_2_LandAcq Yes/No Is land acquisition included in the capital costs?

C3_2_MonEquip Yes/No Is monitoring equipment included in the capital costs?

C3_2_AerEquip Yes/No Is aeration equipment included in the capital costs?

C3_2_LandApp Yes/No Is land application equipment included in the capital costs?

C3_2_Other1 Yes/No Is another component included in the capital costs?

C3_2_Other1Desc Text Description of other1

C3_2_Other2 Yes/No Is another component included in the capital costs?

C3_2_Other2Desc Text Description of other2

C3_2_OandMCostPercent Double Percent of total operation and maintenance cost

C3_2_Chemicals Yes/No Are chemicals included in the O and M costs?

C3_2_EElec Yes/No Is electric energy included in the O and M costs?

C3_2_EGas Yes/No Is gas energy included in the O and M costs?

Projects_PWMSystems_Final

Projects_Final

ProjectWells_Final

Table provides information the number of wells in each CBM project.

PWMSystemDestination_Final

Table provides detailed information about project wells.

Table provides flow, cost, and other data regarding the final destination of the CBM wastewater.
C3_2_EOil Yes/No Is oil energy included in the O and M costs?

C3_2_Materials Yes/No Are materials included in the O and M costs?

C3_2_Labor Yes/No Is labor included in the O and M costs?

C3_2_OtherOandM Yes/No Is another component included in the O and M costs?

C3_2_OtherOandMDesc Text Description of other O and M component

C3_2_MaxDayCapUnits_raw Text Raw units for maximum daily capacity, before standardization

C3_2_MaxDayCap_raw Double

Raw maximum daily capacity of produced water from this PWMS capable of going to this destination, before 

standardization

C3_2_VolumeUnits_raw Text Raw units for volume, before standardization

C3_2_Volume_raw Double Raw 2008 volume of produced water from this PWMS to this destination, before standardization

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

C2_1_CBI Yes/No Is question C2-1 CBI?

C2_1_Diagram Yes/No Is a block diagram attached?

C2_1_Desc Yes/No Is a narrative description attached?

C2-1_Narrative Memo Contains the narrative description, if above field is "Yes"

C2_2_CBI Yes/No Is question C2-2 CBI?

C2_2_YearBegan Text In what year did this PWMS begin operating?

C2_2_365Days Yes/No Did the PWMS operate 365 days in 2008?

C2_2_NumDays Integer If the PWMS did not operate for 365 days in 2008, how many days did it operate?

C2_3_CBI Yes/No Is question C2-3 CBI?

C2_3_WellsFlowType Text Type of flow data provided (AvgDaily or TotalVol)

C2_3_WellsFlow Double Flowrate or volume generated by wells

C2_3_WellsFlowQualifier Text Qualifier that may be associated with flowrate or volume generated by wells

C2_3_WellsFlowUnits Text Units of flowrate or volume

C2_3_PWMSFlowType Text Type of flow data provided (AvgDaily or TotalVol)

C2_3_PWMSFlow Double Flowrate or volume managed by PWMS

C2_3_PWMSFlowQualifier Text Qualifier that may be associated with flowrate or volume managed by PWMS

C2_3_PWMSFlowUnits Text Units of flowrate or volume

C2_4_CBI Yes/No Is question C2-4 CBI?

C2_4_ProjectWaterPercent Double What percentage of water treated by this PWMS is from the project from Part A listed at the top of the page?

C2_4_ProjectGasPercent Double

What percentage of gas production from the project from Part A listed at the top of the page is associated with wells for 

this PWMS?

C2_5_CBI Yes/No Is question C2-5 CBI?

C2_5_OwnerDesign Yes/No Was the PWMS designed with input from the surface owner?

C2_5_ContractorDesign Yes/No Was the PWMS designed by working with an outside contractor?

C2_5_OtherDesign Yes/No Was the PWMS designed in some other way?

C2_5_OthDesignDesc Text Description of the other design process

C2_5_Operator Yes/No Does the operator manage the day-to-day operations for the produced water management?

C2_5_Landowner Yes/No Does the landowner manage the day-to-day operations for the produced water management?

C2_5_Contractor Yes/No Does a contractor or third party manage the day-to-day operations for the produced water management?

C2_5_ContractorCompany Text Contractor/third party company name (if applicable)

C2_5_ContractorCost Double 2008 annual operating and maintenance costs (dollars)

C2_5_ContractorCostQualifier Double Qualifier that may be associated with 2008 annual operating and maintenance costs (dollars)

C2_5_MinCBMWater Double Minimum quantity of CBM produced water required for contract (bbl)

C2_5_MinCBMWaterQualifier Double Qualifier that may be associated with minimum quantity of CBM produced water required for contract (bbl)

C2_6_CBI Yes/No Is question C2-6 CBI?

C2_6_CapCostPWMS Long Integer Capital cost of the PWMS (dollars)

2008_CapCost_PWMS Long Integer Capital cost of the PWMS (dollars) converted to 2008$. Standardization of costs required prior to use in analyses.

C2_6_PurchasedPWMS Yes/No Did your company purchase this PWMS from another company so that this capital cost information is unavailable?

C2_6_CostYearPWMS Text Year cost of PWMS was incurred

C2_7_CBI Yes/No Is question C2-7 CBI?

C2_7_2008OMCostPWMS Long Integer 2008 operating and maintenance cost (dollars) for this PWMS

C2_7_Revenue Long Integer Annual revenue received from operating the PWMS

C2_8_CBI Yes/No Is question C2-8 CBI?

C2_8_VolPiped Long Integer Total 2008 volume of water generated from the CBM wells identified in Part A that is piped to this PWMS

C2_8_VolPipedUnits Text Volume units

C2_8_CapCostPiped Long Integer Capital cost of the piped water gathering system between the CBM wells identified in Part A and this PWMS (dollars)

2008_CapCost_Piped Long Integer

Capital cost of the piped water gathering system between the CBM wells identified in Part A and this PWMS (dollars) 

converted to 2008$. Standardization of costs required prior to use in analyses.

C2_8_PurchasedPiped Yes/No

Did your company purchase this piped produced water gathering system from another company so that this capital cost 

information is unavailable?

C2_8_2008OMCostPiped Long Integer

2008 operating and maintenance cost of the piped water gathering system between the CBM wells identified in Part A 

and this PWMS (dollars)

C2_8_CostYearPiped Text Year cost incurred

C2_8_VolTrucked Long Integer Total volume of produced water trucked to this PWMS in 2008

PWMSystemGeneral_Final

Table provides information about the project's waste management system (PWMS).
C2_8_VolTruckedUnits Text Volume units

C2_8_MilesTraveled Long Integer Total vehicle miles traveled for the truck transport of produced water to this PWMS in 2008

C2_8_DaysTraveled Long Integer Total number of days used to truck this produced water to this PWMS in 2008

C2_8_TruckCapacity Long Integer Average volume capacity of truck used

C2_8_TruckCapacityUnits Text Truck capacity units

C2_8_TruckCosts Long Integer Total 2008 costs incurred to truck produced water to this PWMS

C2_9_CBI Yes/No Is question C2-9 CBI?

C2_9_ProjectArea Double Total project land area (Part A Project)

C2_9_ProjectAreaUnits Text Units of total project land area

C2_9_PWMSArea Double Total PWMS land area

C2_9_PWMSAreaUnits Text Units of total PWMS land area

C2_9_UndevelopedArea Double Total underdeveloped land area

C2_9_UndevelopedAreaUnits Text Units of total underdeveloped land area

C2_9_Suitable Yes/No Is the undeveloped area suitable for construction of new or additional wastewater treatment systems?

C2_9_Explanation Memo Explanation of suitability of undeveloped area

C2_10_CBI Yes/No Is question C2-10 CBI?

C2_10_OtherPWMS Yes/No Have you ever operated or considered operating a PWMS other than what is described in this section for the project?

C2_11_CBI Yes/No Is question C2-11 CBI?

C2_11_PWMSConsidered Memo Type of management system considered

C2_12_CBI Yes/No Is question C2-12 CBI?

C2_12_CBINoPWMSReasons Memo Reasons for not implementing or for stopping the operation of the management system

C2_13_CBI Yes/No Is question C2-13 CBI?

C2_13_Studies Yes/No Have any monitoring or other studies been conducted to assess the potential impacts of produced water for this PWMS?

C2_14_CBI Yes/No Is question C2-14 CBI?

C3_7_CBI Yes/No Is question C3-7 CBI?

C3_7_Treat Yes/No Do you treat produced water to remove pollutants prior to discharge to surface water or POTW/third party?

C3_4_NoData Yes/No Yes indicates that survey contained no data for this question

C3_5_NoData Yes/No Yes indicates that survey contained no data for this question

C3_6_NoData Yes/No Yes indicates that survey contained no data for this question

C3_8_NoData Yes/No Yes indicates that survey contained no data for this question

C3_9_NoData Yes/No Yes indicates that survey contained no data for this question

C3_10_NoData Yes/No Yes indicates that survey contained no data for this question

C3_11_NoData Yes/No Yes indicates that survey contained no data for this question

C3_12_NoData Yes/No Yes indicates that survey contained no data for this question

C3_13_NoData Yes/No Yes indicates that survey contained no data for this question

C2_3_PWMSFlowUnits_raw Text Raw units of flowrate or volume, before standardization

C2_3_PWMSFlow_raw Double Raw flowrate or volume managed by PWMS, before standardization

C2_3_WellsFlowUnits_raw Text Raw units of flowrate or volume, before standardization

C2_3_WellsFlow_raw Double Raw flowrate or volume generated by wells, before standardization

C2_8_TruckCapacityUnits_raw Text Raw truck capacity units, before standardization

C2_8_TruckCapacity_raw Long Integer Raw average volume capacity of truck used, before standardization

C2_8_VolPipedUnits_raw Text Raw volume units, before standardization

C2_8_VolPiped_raw Long Integer

Raw total 2008 volume of water generated from the CBM wells identified in Part A that is piped to this PWMS, before 

standardization

C2_8_VolTruckedUnits_raw Text Raw volume units, before standardization

C2_8_VolTrucked_raw Long Integer Raw total volume of produced water trucked to this PWMS in 2008, before standardization

C2_9_ProjectAreaUnits_raw Text Raw total project land area (Part A Project), before standardization

C2_9_ProjectArea_raw Double Raw units of total project land area, before standardization

C2_9_PWMSAreaUnits_raw Text Raw total PWMS land area, before standardization

C2_9_PWMSArea_raw Double Raw units of total PWMS land area, before standardization

C2_9_UndevelopedAreaUnits_raw Text Raw total underdeveloped land area, before standardization

C2_9_UndevelopedArea_raw Double Raw units of total underdeveloped land area, before standardization

C2_1_ElectronicallyAvailable Yes/No Is the C2-1 diagram or description available electronically

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

LandAppID AutoNumber Sequential ID for each land application system

C3_6_CBI Yes/No Is question C3-6 CBI?

C3_6a_LandAppArea Long Integer Area of land used for land application (acres)

C3_6b_Criteria Text Criteria on the produced water for this land application

C3_6c_AboveGround Yes/No Is the land application/irrigation above-ground?

C3_6c_SDI Yes/No Is the land application/irrigation sub-surface drip (SDI)?

C3_6c_Other Yes/No Is the land application/irrigation another type?

C3_6c_OtherDesc Text Description of other

C3_6d_Frequency Text Frequency of application

C3_6d_NumDays Text Number of days applied in 2008

Table provides information about land application.

PWMSystemLandApp_Final
C3_6d_Months Text Months that the land application occurred in 2008

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

POTWID AutoNumber Sequential ID for POTW discharge within a system

C3_5_CBI Yes/No Is question C3-5 CBI?

C3_5a_DischDest Text Third party destination of discharge water

DischDest Text

Categorizes the discharge destinations as Commercial, Operator, POTW, PrOTW, or Unknown to more clearly identify 

the final destination.

TRSFR_ProjPWMSystemID Long Integer If system transfers to another Project's PWMS, identifies the PWMSystemID

DischDestType Text Characterizes the type of discharge destination (i.e., crop, surface water, injection, POTW, pond, unknown)

C3_5a_FacName Text Facility name (POTW, PrOTW, or other facility)

C3_5a_Address Text Facility address

C3_5a_City Text Facility city

C3_5a_State Text Facility state

C3_5a_ZIP Text Facility ZIP

C3_5a_PrimaryContact Text Primary contact name

C3_5a_Phone Text Telephone number

C3_5b_AgreementAtt Yes/No Is a copy of the current permit or discharge agreement attached?

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

ResidualID AutoNumber Sequential ID for residual mgmt info within a system

C3_3_CBI Yes/No Is question C3-3 CBI?

C3_3_ResidDesc Text Description of residual generated and its source

ResidType Text Characterizes the type of treatment from which residual was generated (e.g., sediment pond, ion exchange)

C3_3_Volume_raw Long Integer Raw volume of residual generated in 2008, before standardization

C3_3_VolumeUnits_raw Text Raw units for volume, before standardization

C3_3_Volume Long Integer Volume of residual generated in 2008

C3_3_VolumeUnits Text Units for volume

C3_3_ResidFreq_raw Text Raw frequency of residuals removal from this PWMS in 2008, before standardization

C3_3_ResidFreqUnits_raw Text Raw units for frequency, before standardization

C3_3_ResidFreq Text Frequency of residuals removal from this PWMS in 2008

C3_3_ResidFreqUnits Text Units for frequency

C3_3_FinalDest Text Name of final destination for this residual

C3_3_DestDist Long Integer Distance from this PWMS to the final destination for this residual (miles)

C3_3_DispCost Long Integer Annual 2008 cost of disposal for this residual (dollars)

C3_3_Piped Yes/No Is transportation: piped included in the residual disposal cost?

C3_3_Trucked Yes/No Is transportation: trucked included in the residual disposal cost?

C3_3_Fees Yes/No Are disposal fees included in the residual disposal cost?

C3_3_Other1 Yes/No Is something else included in the residual disposal cost?

C3_3_Other1Desc Text Description of other1

C3_3_Other2 Yes/No Is something else included in the residual disposal cost?

C3_3_Other2Desc Text Description of other2

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

PWMSystemStudyID AutoNumber Unique identifier for study

C2_14_Title Memo Title of the study

C2_14_Date Text Date of the study

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

C3_4a_NPDES Text NPDES permit number

C3_4_CBI Yes/No Is question C3-4 CBI?

C3_4a_PermitType Text Permit Type (General or Individual)

C3_4a_ExpDate Date/Time Expiration Date (MM-DD-YYYY)

C3_4a_StreamMon Yes/No Is stream monitoring required?

C3_4a_StreamMonFreq Text Frequency of stream monitoring

C3_4a_StreamMonFreqUnits Text Units for monitoring frequency

C3_4a_EffluentMon Yes/No Is effluent monitoring required?

C3_4a_EffMonFreq Long Integer Frequency of effluent monitoring

PWMSystemPOTW_Final

PWMSystemResidual_Final

Table provides information about environmental assessment studies.

Table provides information about wastewater discharged to surface water.

PWMSystemSurfaceWater_Final

PWMSystemStudies_Final

Table provides information about wastewater sent to POTWs.

Table provides information about residuals generated from treatment.
C3_4a_EffMonFreqUnits Text Units for monitoring frequency

C3_4a_RevorMod Yes/No Is the permit currently being reviewed of modified?

C3_4c_PermitAtt Yes/No Is a copy of the current surface water discharge NPDES permit attached?

C3_4_NoData Yes/No Indicates whether or not data was submitted for this question

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

PWMSystemTreatmentID AutoNumber Code of treatment units for each destination within a system

C3_8_CBI Yes/No Is question C3-8 CBI?

C3_8_TreatType Text Treatment type

C3_8_QualData Yes/No Is there water quality data for the produced water entering and/or leaving this treatment unit?

C3_8_OtherDesc Text Description of other treatment

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

SedimentationPondID AutoNumber Sequential ID for each pond within the treatment system

C3_9_CBI Yes/No Is question C3-9 CBI?

C3_9_Design Double Design capacity (acre-feet)

C3_9_Volume Double Volume of produced water into sediment pond

C3_9_VolUnits Text Units of volume

C3_9_SurfaceArea Double Surface area (acres)

C3_9_Liner Yes/No Is a liner used?

C3_9_LinerType Text Type of liner

C3_9_Thickness Double Thickness of the liner

C3_9_ThicknessUnits Text Units of thickness

C3_9_Chemicals Text Chemicals added

C3_9_CapCost Double Capital cost of sedimentation pond (dollars)

C3_9_CapCostYear Text Year of capital costs

C3_9_InitialCost Double Initial bonding costs (dollars)

C3_9_InitialCostYear Text Year of initial costs

C3_9_2008OandM Double 2008 Operating and maintenance cost of sedimentation pond

C3_9_ThicknessUnits_raw Text Raw units of thickness

C3_9_Thickness_raw Double Raw thickness of the liner

C3_9_VolUnits_raw Text Raw units of volume

C3_9_Volume_raw Double Raw volume of produced water into sediment pond

2008_CapCost Long Integer Capital cost of sedimentation pond (dollars) in 2008$

2008_InitCapCost Long Integer Initial cost of sedimentation pond (dollars) in 2008$

2008_TotCapCost Long Integer Total cost of sedimentation pond (dollars) in 2008$

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

SedimentationPondID Text Unique ID for each sedimentation pond

C3_9_Parameter Text Parameter name

C3_9_RemEff Text Estimated removal efficiency

C3_9_Basis_Comments Memo Comments

FieldName FieldType FieldDescription

Operator_ID Text Operator ID in ENG database

Project_ID Text Project ID in ENG database

Project_Name Text Project Name

Basin_raw Text Basin in which project operates

FINWGT0 Double Full sample final survey weight (i.e., survey weights used in analyses)

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

TreatNotSpecifiedID AutoNumber Sequential ID for each treatment type and system

C3_13_CBI Yes/No Is question C3-13 CBI?

C3_13_Design Double Design capacity (bbl/d)

C3_13_Volume Double Volume of produced water entering treatment unit in 2008

C3_13_VolUnits Text Units of volume

C3_13_TrtDesc Memo Description of treatment system

Survey Weights_Final

Table showing the final survey weights for each project.

SedimentationPond_Final

PWMSystemTreatment_Final

SedimentPondParameters

Table provides information about treatment capability of sediment ponds.

TreatmentNotSpecified_Final

Table provides information about types of wastewater treatment.
C3_13_Vendor Text Vendor/Unit name

C3_13_RegenFreq Double Average regeneration/cleaning frequency

C3_13_RegenFreqUnits Text Units of average regeneration/cleaning frequency

C3_13_Chemicals Text Types of chemicals used with this system in 2008

C3_13_ChemAmts Text Amounts of chemicals used with this system in 2008

C3_13_CapCost Double Capital cost of filtration system (dollars)

C3_13_2008OandM Double 2008 Operating and maintenance cost of system

C3_13_PilotProject Yes/No Pilot project

C3_13_CapCostYear Text Capital cost year

C3_13_VolUnits_raw Text Raw units of volume

C3_13_Volume_raw Double Raw volume of produced water entering treatment unit in 2008

2008_CapCost Long Integer Capital cost of treatment (dollars) in 2008$

FieldName FieldType FieldDescription

ProjPWMSystemID Long Integer Unique ID for Proj + PWMS combination

TreatNotSpecifiedID Text Unique ID for each treatment type and system

C3_13_Parameter Text Parameter name

C3_13_Removal_Eff Long Integer Estimated removal efficiency

C3_13_Basis_Comments Memo Comments

TreatmentNotSpecifiedParameters

Table provides information about treatment capability of various other treatment types.