### 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 AutoNumberUnique 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 AutoNumberSequential 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 populatedwhen an issue could not be resolved and was added to align with Form B, a review form from theQuality 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 IntegerUnique 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 IntegerUnique ID for Proj + PWMS combination HighPressureFilterID AutoNumberSequential 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 IntegerCapital cost of treatment system (dollars) in 2008$

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique 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 IntegerUnique ID for Proj + PWMS combination IonExchangeID AutoNumberSequential (unique ID) for each ion exchange treatment unit C3_10_CBI Yes/No Is question C3-10 CBI? C3_10_Design Long IntegerDesign capacity (acre-feet) C3_10_Volume Long IntegerVolume 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 IntegerAverage regeneration frequency C3_10_RegenFreqUnits Text Units of average regeneration frequency C3_10_AvgLife Long IntegerAverage resin life (years) C3_10_Chemicals Text Chemicals added C3_10_CapCost Long IntegerCapital cost of ion exchange unit (dollars) C3_10_CapCostYear Text Capital cost year C3_10_2008OandM Long Integer2008 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 IntegerCapital cost of ion exchange (dollars) in 2008$

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique 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 IntegerUnique ID for Proj + PWMS combination LowPressureFilterID AutoNumberSequential 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 IntegerCapital cost of treatment system (dollars) in 2008$

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique 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 AutoNumberUnique 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 Integer2008 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 AutoNumberUnique project ID autogenerated by database to associate tables OperatorID Long IntegerUnique 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 IntegerNumber of wells associated with project

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID AutoNumberUnique ID for Proj + system combination ProjectID Long IntegerUnqiue Project ID, links to Projects table PWMSystemID Long IntegerUnique PWMS system ID OperatorID Long IntegerUnique 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 AutoNumberSequential WellsID Number OperatorID Long IntegerUnique operator ID autogenerated by database to associate tables ProjectID Long IntegerUnique project ID autogenerated by database to associate tables APINumber Text Well API Number PermitNumber Text Permit Number

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique 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_rawText 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 IntegerUnique 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_ProjectWaterPercentDouble 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_ContractorCostQualifierDouble 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_MinCBMWaterQualifierDouble 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 IntegerCapital cost of the PWMS (dollars)

2008_CapCost_PWMS Long IntegerCapital 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 Integer2008 operating and maintenance cost (dollars) for this PWMS C2_7_Revenue Long IntegerAnnual revenue received from operating the PWMS C2_8_CBI Yes/No Is question C2-8 CBI? C2_8_VolPiped Long IntegerTotal 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 IntegerCapital cost of the piped water gathering system between the CBM wells identified in Part A and this PWMS (dollars)

2008_CapCost_Piped Long IntegerCapital 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 Integer2008 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 IntegerTotal 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 IntegerTotal vehicle miles traveled for the truck transport of produced water to this PWMS in 2008 C2_8_DaysTraveled Long IntegerTotal number of days used to truck this produced water to this PWMS in 2008 C2_8_TruckCapacity Long IntegerAverage volume capacity of truck used C2_8_TruckCapacityUnits Text Truck capacity units C2_8_TruckCosts Long IntegerTotal 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_UndevelopedAreaUnitsText 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_CBINoPWMSReasonsMemo 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_rawText 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_rawText Raw truck capacity units, before standardization C2_8_TruckCapacity_raw Long IntegerRaw average volume capacity of truck used, before standardization C2_8_VolPipedUnits_raw Text Raw volume units, before standardization

C2_8_VolPiped_raw Long IntegerRaw 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_rawText Raw volume units, before standardization C2_8_VolTrucked_raw Long IntegerRaw total volume of produced water trucked to this PWMS in 2008, before standardization C2_9_ProjectAreaUnits_rawText 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_rawText Raw total PWMS land area, before standardization C2_9_PWMSArea_raw Double Raw units of total PWMS land area, before standardization C2_9_UndevelopedAreaUnits_rawText Raw total underdeveloped land area, before standardization C2_9_UndevelopedArea_rawDouble Raw units of total underdeveloped land area, before standardization C2_1_ElectronicallyAvailableYes/No Is the C2-1 diagram or description available electronically

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique ID for Proj + PWMS combination LandAppID AutoNumberSequential ID for each land application system C3_6_CBI Yes/No Is question C3-6 CBI? C3_6a_LandAppArea Long IntegerArea 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_FinalC3_6d_Months Text Months that the land application occurred in 2008

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique ID for Proj + PWMS combination
POTWID AutoNumberSequential 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 IntegerIf 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 IntegerUnique ID for Proj + PWMS combination ResidualID AutoNumberSequential 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 IntegerRaw volume of residual generated in 2008, before standardization C3_3_VolumeUnits_raw Text Raw units for volume, before standardization C3_3_Volume Long IntegerVolume 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 IntegerDistance from this PWMS to the final destination for this residual (miles) C3_3_DispCost Long IntegerAnnual 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 IntegerUnique ID for Proj + PWMS combination PWMSystemStudyID AutoNumberUnique identifier for study C2_14_Title Memo Title of the study C2_14_Date Text Date of the study

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique 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_StreamMonFreqUnitsText Units for monitoring frequency C3_4a_EffluentMon Yes/No Is effluent monitoring required? C3_4a_EffMonFreq Long IntegerFrequency 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 IntegerUnique ID for Proj + PWMS combination PWMSystemTreatmentID AutoNumberCode 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 IntegerUnique ID for Proj + PWMS combination SedimentationPondID AutoNumberSequential 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 IntegerCapital cost of sedimentation pond (dollars) in 2008$ 2008_InitCapCost Long IntegerInitial cost of sedimentation pond (dollars) in 2008$ 2008_TotCapCost Long IntegerTotal cost of sedimentation pond (dollars) in 2008$

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique 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 IntegerUnique ID for Proj + PWMS combination TreatNotSpecifiedID AutoNumberSequential 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 IntegerCapital cost of treatment (dollars) in 2008$

**FieldName FieldType**  **FieldDescription** ProjPWMSystemID Long IntegerUnique 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 IntegerEstimated removal efficiency C3_13_Basis_Comments Memo Comments 

### TreatmentNotSpecifiedParameters **Table provides information about treatment capability of various other treatment types.**