Petra Direct Connect Guide_2011

PETRA Direct Connect Guide_2011
View more...
   EMBED

Share

Preview only show first 6 pages with water mark for full document please download

Transcript

IHS > Decision Support Tool IHS Enerdeq / PETRA ® ® Direct Connect to Well and Production Data June 30, 2011 v.2 ©2011 IHS, All Rights Reserved. All trademarks belong to IHS or its affiliated and subsidiary companies, all rights reserved. www.ihs.com Direct Connect to Well and Production Data June 30, 2011 © 2007-2011, IHS Inc. and its affiliated and subsidiary companies, all rights reserved. All other trademarks are the property of IHS Inc. and its affiliated and subsidiary companies. This product, including software, data and documentation are licensed to the user for its internal business purposes only and may not be disclosed, disseminated, sold, licensed, copied, reproduced, translated or transferred to any third party. IHS Inc. 15 Inverness Way East Englewood, Colorado 80112 303-736-3000 Contents Direct Connect Overview ........................................................................................................................... 1 What is Direct Connect? ........................................................................................................................... 1 Authorization ........................................................................................................................................ 1 Initial Setup ............................................................................................................................................... 1 Import Wells from IHS Direct Connect...................................................................................................... 3 Import Well Data into a New Project ........................................................................................................ 3 Wells and AOI – Option A .................................................................................................................... 4 Import Options ...................................................................................................................................... 8 Queries ............................................................................................................................................... 15 297 Tab .............................................................................................................................................. 16 Report Tab ......................................................................................................................................... 16 Import Well Data to Update Project ........................................................................................................ 18 Wells and AOI .................................................................................................................................... 19 Import Options .................................................................................................................................... 21 Import Production from IHS Direct Connect .......................................................................................... 23 IHS Production Data Types .................................................................................................................... 23 Production Import Scenarios .................................................................................................................. 23 Allocated Production – Texas/Louisiana Only ................................................................................... 24 Unallocated Production – All US States ............................................................................................. 39 Allocated and Unallocated – Texas/Louisiana and Other States....................................................... 43 Best Practices ......................................................................................................................................... 48 Import Options for Prior Versions of PETRA ......................................................................................... 49 Changes for Well Data Imports .............................................................................................................. 49 Changes for Production Data Imports .................................................................................................... 49 Allocated Production – Texas/Louisiana Only ................................................................................... 50 Unallocated Production – Other US States ........................................................................................ 52 Dual Production – Texas/Louisiana and Other States ....................................................................... 53 June 30, 2011 iii Contents Direct Connect to Well and Production Data iv June 30, 2011 Direct Connect Overview What is Direct Connect? Direct Connect is an option in PETRA which provides a quick link to the IHS Enerdeq Browser for importing U.S. Well and Production Data via the Internet directly into your PETRA project. Several import options are available, depending upon whether you are updating an existing PETRA project or importing well data into a new PETRA project. These options include selecting an AOI from a map, using an existing PETRA well list, and selecting from your saved Enerdeq queries, among others. Connection to the Canadian server is also available for access to Canadian Well and Production Data. This document describes the U.S. connections based on PETRA version 3.6.1. Notes related to former versions are included at the end of the document. NOTE: The Direct Connect feature also provides options for linking to IHS Logs, International data, and Landgrid Shape Files via Map; however, these options are not discussed in this guide. Authorization Use of this feature requires subscription to IHS Well/Production data as well as Enerdeq authorization, via a Username and Password. If you currently access the Enerdeq Browser, use that same Username and Password in PETRA. If you need to establish this authorization, contact your IHS Account Manager. If you are unsure of the name of your Account Manager, you may contact one of the Customer Care sources listed below: Customer Care telephone: 1-800-IHS-CARE (1-800-447-2273); select options for Enerdeq or PETRA IHS Enerdeq Customer Care email: [email protected] PETRA Customer Care email: [email protected] Initial Setup You access Direct Connect from the Project menu on the Main module of PETRA.  Project>Direct Connect>IHS US Enerdeq or Canada>Import… This displays the submenu selections for importing well and production data, as shown below. June 30, 2011 1 Direct Connect Overview Direct Connect to Well and Production Data The first time you access the Direct Connect feature, PETRA prompts you for your Username and Password.  Enter the information and then click the OK button. An authorization file is created and placed in the root of the geoplus1 folder for later use. Should your Username or Password change, you can update the information using the Direct Connect option Change UserID and Password, as shown above. 2 June 30, 2011 Import Wells from IHS Direct Connect The Well import option allows you to select your wells from a map-drawn AOI, UWI list, or saved Enerdeq query, among others, depending upon whether you are updating an existing project or importing to a new project. You can also select the data to load and other import options, as well as create reports. TIP: For best results, always import Well data before Production data and set Map Projection before well import when possible. IHS U.S. data locations are referenced to NAD27 datum. Import Well Data into a New Project From the PETRA Main module menu bar, select Project>Direct Connect>IHS US Enerdeq or Canada>Import Wells from IHS Direct Connect… An Enerdeq Database Source screen may display. It provides selection of the U.S. or Canada Well Loader; this depends upon your subscription entitlements.  Select the Database Source, in this case U.S., and click the OK button. The IHS (US) Well Loader dialog displays once the authorization and connection are verified. June 30, 2011 3 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data NOTE: For new projects, the only well selection options available are to select Wells and AOI from a Map or use a saved Enerdeq Query. This dialog screen provides the following options: Wells and AOI: choose method for selecting wells; for new projects, only option A is available Import Options: select the data to load and other import options Queries: select wells from a list of your saved Enerdeq queries; available for new or existing PETRA projects. Report: provides a real time visual of the well data import 297: allows you to save a 297 file from the chosen options Wells and AOI – Option A Clicking this option allows you to select an area of interest (AOI) from a map and select wells for import. 4 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect  Click the OK button to display the map. Use the Zoom functions to locate your area on the map. The following example zooms into the area around Wise County, Texas. Use the Set AOI button to select and set the area of interest. June 30, 2011 5 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data Only the wells falling within the AOI (red rectangle) are imported. Option A1: Accept Current AOI The AOI rectangle covers an area greater than just Wise County. If this is satisfactory, click the Get Count button followed by the Use Wells button. This creates the UWI list, closes the map view, and returns to the IHS (US) Well Loader screen, which shows the current well count (18,186), the AOI rectangle Lat/Lon extents, and additional selection options. 6 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect Option A2: Filter Current AOI To reduce the number of wells to just those within Wise County, you can filter the current well selection by clicking the button, which uses County Codes to filter the data. If the code is unknown, use the Lookup button. Since county codes may be the same from state to state, enter the state code for Texas, TX, click the OK button, and then type in the county name, Wise. Click the OK button on the County screen. Petra processes the information and returns the three digit county code of 497. You can enter multiple counties, and save templates for future use. Select the OK button. On the IHS (US) Well Loader screen, select the to apply the filter. The total well count reduces to 10, 188. button June 30, 2011 7 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data Import Options These options include adding/updating wells, data to load, and selection of formation tops, among others. General Tab This section controls general data loading parameters. Well Update Mode These options determine whether new wells are added to the project and/or if existing wells are updated. Select appropriate options from the dropdown lists. In addition, you can set the number of digits (10, 12, or 14) for API Numbers when adding new wells. The default is 14 digits. CAUTION: If 10 or 12 digit API numbers are used, then data from different completions are merged. Data to Load This section provides a list of data types to import. Choose those of interest to you. 8 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect Misc Options This section contains a list of additional data types and special conditions used during import.  Restrict Wells by Last Update Date Uses the last update date to control which wells are updated  Load Data into Initial Completions Only Only API numbers ending in 0000 are stored in the project. Data from the 0001, 0002, etc. completions are merged with the 0000 well.  Skip IC Numbers (Load API Numbers Only) Does not load Internal Control (IC) numbers (those assigned prior to API number) CAUTION: If you choose to load the IC number, you may later end up with duplication of wells once the API number is assigned and project wells updated, as there will be 2 UWI’s for the same well.  Update BLANK Header Fields Only The following fields are updated when they are blank in the project database: Well Name and Well Number Lease Name and Lease Number Fm at TD TD and TVD Platform, Water Depth, Whipstock Depth Directional Indicator Lat Lon Source Surface and Bottom Hole Lat and Lon Operator and Historical Operator Field Name Producing Formation Elevation Geol Province Spud Date, Completion Date, Permit Date, Rig Release Date Abandoned Date, First Report Date, Last Activity Date  Update Historical Operator if Blank Copies the database value for Operator to the blank Historical Operator field, prior to importing a new Operator value  Use Lease Name as Well Name Stores the Lease Name in the Well Name field  Store Well Name in Well Label Stores the Well Name in the Well Label field  Build Well Labels using Predefined Template When updating wells, you can create a Well Label on import from the current Well Label Template in project.  Load Last Drilling Remark into Zone Item (WELL.DRLLREM) Creates the Zone item DRLLREM and loads the last drilling remark into the WELL Zone June 30, 2011 9 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data  Add Core Remarks to Well Header Remarks Remarks from Core records are added to the well remarks field displayed on the Well tab in the Main module  Do Not Load Fm Bases Disables import of Fm Top bases from Tops selection list  Use Fm Top Repeats (see Fm Tops tab for options) Enables import of Formation Top Repeats  Ignore Fm Tops Source Codes (load w/ blank source) Does not load the IHS Source Code; tops with multiple source codes are loaded into single name in the database  Copy Production Tests into Perfs (Gross) The top and base of each Production test (IP test and others) is used to create a Gross perf record in the database  Copy Treatments into Perfs (Detail) The top and base of each Production test treatment record is used to create a Detail perf record in the database  Set PERF Source from IHS Data Source Create a PERF source code in the database  Load IP and DST Data with Missing Top or Base Allows you to load IP and DST data if no top or base value available  Use Completion Date if Test/Perf Date is Missing Replaces the missing test or perf date with the well Completion date  Compute LatLon from Northeast Footage ref This option only applies to areas in the NE United States that use the North East location criteria; the surface Lat-Lon is computed using NE footage locations  Load Directional Indicator into WELL.DIR_IND Use this flag to store a value such a V, D, or H in the WELL Zone item called DIR_IND  Convert Depth Values from FEET to METERS All depth related data are imported as Meters instead of Feet  Store Untranslated Well Symbol Code in WELL.ORIGSYMCODE Petra translates all symbol codes into a standard set; this option stores the original symbol code in WELL zone item called ORIGSYMCODE  Default Survey Orientation to GRID North instead of TRUE North This option allows the survey orientation to default to GRID north, rather than TRUE north  Load TD Date into Zone Item (WELL.TD_DATE) Stores the TD date in the WELL zone item called TD_DATE 10 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect  Produce Detailed Load Report Displays a detailed report of the import process which can be saved for later review Fm Tops Tab This screen allows you to restrict the formation tops imported into your project. Click the Download Top Selection List to obtain a list from Enerdeq of all formation top names contained within the list of UWI’s. The list shows the number of occurrences for each formation top. NOTE: This request can take several minutes to complete based on the number of UWI’s. By default, all tops are selected. To restrict the selection list, click the None button, and then select the tops of interest: June 30, 2011 11 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data For consecutive selection, hold the Shift key For non-consecutive selection, hold the Control key The Apply Translations button allows you to display the translated top name as established in the Formation Substitution file on the next tab. Fm Subst Tab This screen provides a mechanism to change the names of IHS tops on import, using a name substitution file. A formation substitution file can be used to map several formation top names into a common name. The file has two record types: The “1” record defines the common name loaded into the database The “2” record contains the IHS top name to be renamed to the common name The file format is displayed on the screen. Click the Browse button and path to the file location. Use the Test Translations button to verify that the file works correctly. 12 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect Source Tab This screen allows selection of IHS formation top source codes as well as a user supplied code. User Source Code This field is used to set the source code for perfs and any zone items created during import. Formation Tops Source Code to Load The list provides a method to restrict by source, which IHS tops are imported. Uncheck any source you do not want to import. Higher numbers (3, 4) provide more reliable top picks. 1 = Driller’s Pick 2 = Picked from rock sample 3 = Operator’s Log Top 4 = IHS modified pick June 30, 2011 13 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data Elev Trans Tab An Elevation Translation file can be used to map several elevation codes to one of the standard elevation zone items. The file record has two record types: The “1” record defines the standard name to load to the database The “2” record contains the IHS elevation code that is to be renamed to the standard name: KB, DF, GR, and SEIS The file format is displayed on the screen. Enable the option and use the Browse button to path to the file; an example is shown above. 14 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect Dir Survey Tab This screen controls the selection of the survey type into which directional surveys import. The default is Actual. The Survey Def Maintenance button allows you to create new survey names for import. Queries The Queries button allows you to select wells from a saved Enerdeq query list. Click on the Refresh Query List from Enerdeq button to view your saved queries. Select a Well data query and then click the Run Selected Query to Create UWI list…button. June 30, 2011 15 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data 297 Tab This screen allows you to create a 297 file from the chosen options. Report Tab This screen displays a real time visual of the well data import. Example shows Report before importing wells; note blue background.  Click the Import Wells button to begin the import process. 16 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect Example below shows completed Report; note green background. NOTE: Before exiting the Well Data Loader, you can save your settings and AOI by selecting File>Save Options As… and File>Save AOI File… and load these for future use. June 30, 2011 17 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data View the well import in the Petra Main module. (The number of wells imported is less than the number to import since the option to Skip IC Numbers was selected.) Import Well Data to Update Project These options apply to projects already containing well lists. Launch the Well Data Loader following the same method as described in the previous section:  Project>Direct Connect>IHS US Enerdeq or Canada>Import Wells from IHS Direct Connect NOTE: If this is the first time accessing Direct Connect, the prompt for User ID and Password displays, as shown in previous section, before the Loader screen opens. The IHS (US) Well Loader screen displays with additional Well selection options from those in the previous section. 18 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect Wells and AOI With an existing well list in your Petra project, several well selection update methods are available for creating a UWI list of wells to import. A: Use Map View to Set AOI and Download UWI List You can use this option to redefine your current AOI. (See previous section). B: Make AOI and UWI List from Currently Selected Wells This option uses the wells currently selected in the Main module to create a new AOI and UWI List. C: Make UWI List from Currently Selected Wells Use the currently selected wells in the Main module without modifying the current AOI. D: Search IHS Server for All Wells within Current AOI Limits You can use this option to search for all wells in current AOI, and limit the search to those changed since a specific date. (See example below). E: Use Previous UWI List You can use this option to select a previous UWI list. June 30, 2011 19 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data Option D: Search IHS Server This example uses the well list downloaded in the previous section (for a new project) to search for any wells within the AOI added or modified since the last change date. There are several options available for restricting the selection of last change date, such as in the last 2 weeks, or last 30 days; use the dropdown list for selection. The example below uses the option Since My Last Download. Petra saves the previous download date and uses that to fill in the Last Change Date.  Enter the Change Date parameters and then click option D.  Click the OK button to enable the search. The new UWI list displays showing 58 wells added or modified since the last download. 20 June 30, 2011 Direct Connect to Well and Production Data Import Wells from IHS Direct Connect Import Options The import options are selected as described in the previous section, with the exception of the Well Update Mode. In this case be sure to specify Add New Wells and select the appropriate Update Wells option.  Set the import options or load your saved options file and then click the Import Wells button. June 30, 2011 21 Import Wells from IHS Direct Connect Direct Connect to Well and Production Data The project now reflects 10,180 wells in the project; 1 well added and 57 updated. 22 June 30, 2011 Import Production from IHS Direct Connect The Production import feature provides several methods for selecting wells, including using saved queries, as well as various options for data to load. As with the Well loader, you have the option to save settings for future use. Be aware that Production imports are complete historical replacements for each well. IHS Production Data Types A key point in loading U.S. production data is in understanding the difference between IHS production data types. For reporting purposes, many states often roll up production to the Lease level, rather than the Well level. To circumvent this reporting issue, IHS developed an allocation process which takes all lease level production and applies it to individual wells. This technique facilitates mapping individual well production by formation and study of individual well profiles. The IHS allocation process incorporates well tests, allowables, and monthly status to apply the lease level production to individual wells. Any lease level production with insufficient test data for allocation to an individual well is designated as a Multi-well production ID, and may consist of one or more wells’ production, possibly on adjacent leases. In this case, production is assigned to the primary Multi-well API. This procedure results in two types of production within the IHS database: Allocated Production: These data have undergone the allocation process and are currently available ONLY for Texas Oil and Louisiana Oil and Gas. Unallocated Production: These data are reported “as is” (either lease level or well level) from all states. Both Production Types are available with your IHS Production subscription. Production Import Scenarios There are two main production import cases you might encounter with your PETRA projects, based upon production type and project area: 1. Texas/Louisiana: for these wells you MUST choose either Allocated or Unallocated production. 2. All Other States: for these wells Unallocated Production Only is the default option; no selection is necessary. NOTE: For projects covering multiple states, such as Texas, Louisiana, and Arkansas, you only need to select the Texas/Louisiana production type since all other states default to Unallocated Production. All production loads in one import for v3.6.1 or later. June 30, 2011 23 Import Production from IHS Direct Connect Direct Connect to Well and Production Data Allocated Production – Texas/Louisiana Only This section describes the entire import process for the specific case of loading production data into any project containing wells from Texas and/or Louisiana only. This example shows the project used for the well data import which contains only Texas wells. You launch the Production Loader from the Main module of Petra by selecting:  Project>Direct Connect>IHS US Enerdeq or Canada>Import Production from IHS Direct Connect NOTE: If this is your first time using the Direct Connect feature, you will be prompted for your username and password. See Well Data section for more information. The IHS (US) Prod Loader initial screen displays. Choose a well selection option to determine the UWI list used for importing production data. An option to restrict by a date when updating production is also available. In general, use option 1 or 2 for your initial production import, since they use all or most wells in your project. The last choice, I’ll Decide Later, gives you a chance to think about which wells to select before you actually import the data. Select the Source menu to reactivate this screen. 24 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect The optional date restriction for updates provides the same choices as in the Well Data Loader and works the same way. This example uses the 10180 wells selected in Main. Clicking the OK button generates an immediate Enerdeq request for a list of production ID’s (PID) for the wells in the UWI list, unless you choose the option I’ll Decide Later. CAUTION: This request can take several minutes to complete. You will NOT be able to cancel this request! The Status screen displays the results of the PID search: of the 13,079 production ID’s selected, 10,773 will be used in this Texas Allocated import. This is the sum of Allocated PID’s (Oil) and Well PID’s (Gas). The Unallocated (Lease) PID’s are not used.  At this point you proceed to the General tab and begin selecting parameters for import. June 30, 2011 25 Import Production from IHS Direct Connect Direct Connect to Well and Production Data General Tab This screen provides selection options for production streams and type. Production Streams This section provides choices for which streams are loaded; both options can be selected.  Load Production into Standard Streams (OIL, GAS, WTR, and DAYSON) Check this option when you want to load data into streams called OIL, GAS, WTR, and DAYSON. The cumulative values are stored in the WELL Zone as CUMOIL, CUMGAS, and CUMWTR. Multiple producing formations are summed together.  Load Production into Individual Formation Names Check this option to load data into separate streams by producing formation name. The formation names are selected on the Formations tab. A stream code, such as O, G, W, is appended to the formation name as a prefix or suffix to form the production stream and zone item cumulative (total) names. 26 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect Texas/Louisiana Production Type For projects with wells in Texas and/or Louisiana, you have to choose which production type to load for those wells: Unallocated Only – reported “as is” at well or lease level Allocated Only – assigned to Well level via IHS allocation process Production Stored As This option provides selections for storing production as streams, CUMS, or both. Choices are: Load Monthly Production Streams and CUM Values Load Monthly Production Streams Only Load CUM Values Only Method to Apply Unallocated Lease Production to Individual Wells This option is important when loading unallocated production from leases with multiple wells. It determines how the lease production is applied to each well in the lease. Load Production into First Well Only Listed in Lease – stores all lease production in the first well on the lease; the remaining lease wells receive no production. Load Production into Each Well in Lease (Subdivide) - total lease production is subdivided equally among all wells in the lease (i.e., 6 wells in lease, each receives 1/6th of total production). Load Production into Each Well in Lease (Store Total) – All wells in the lease receive the total lease production. May result in inflated production! NOTE: This option is ignored when importing Allocated Only production. Production Available to Load This section displays the results of the PID query, as shown on the Status screen. Fluid Types (Streams) to Load This section determines which Standard streams are loaded, and which fluid types are loaded for individual producing formations. Only the fluid types selected are loaded; uncheck all but OIL, if you only want oil data loaded. Options: OIL DAYS ON GAS WELLS ON WATER Injection Data June 30, 2011 27 Import Production from IHS Direct Connect Direct Connect to Well and Production Data Options Tab This screen provides a variety of import options, as well as another chance to restrict the import to a particular timeframe, if you did not choose this option on the initial screen. Only Import Production Streams that have been Updated on IHS Server This option is a repeat of that displayed on the initial screen; you can select the update method here, if not chosen previously. Recall that PETRA saves the last import date in memory and uses that when you select an option such as In the Last 2 Weeks. Use the Get Counts button to check how many production ID’s (PID) would be downloaded. MISC OPTIONS This section provides various options for import. Check those of interest to you.  Load Production into INITIAL COMPLETION Wells Only Select this option when you want to load production into “0000” wells only, for all wells in the project. This restriction is accomplished by matching 10 or 12 digits of the API number, as selected at the bottom of the screen. 28 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect  Use INITIAL COMPLETIONS Only from Multi-Well Leases Select this option when you want to load production into “0000” wells for only those leases which contain multiple wells. This restriction is accomplished by matching 10 or 12 digits of the API number, as selected at the bottom of the screen.  Update OPERATOR and Save Current Operator as Historical Operator This option assumes the production data Operator Name is the current operator for the well. When checked, the existing operator name in your PETRA project is copied into the blank Historical Operator field and replaced with the operator name from this import.  Update Well SYMBOL CODE from Primary Product Code Select this option when you want to change the existing symbol code in your PETRA project to the updated symbol based upon current production status.  Load Producing Fm Name into Well Header This option updates the Producing Formation Name field in the Well Header with the value from the production data import.  Store current STATUS in WELL Zone as PDSTATUS This option stores the well status (Active or Inactive) in the WELL Zone as an item called PDSTATUS.  Store GATHERER in WELL Zone as GATHERER This option stores the gas gatherer in the WELL Zone as an item called GATHERER.  Store Production Tests in PdTest Table This option stores all production tests in the PdTest tables in the database and displays under the IP Tests tab.  Display Detail Info in Report This option creates a detailed report of all monthly production values, which can be saved in your project’s REPORTS folder.  Update Non-Blank Lease Number with UNIT WELL SERIAL NUMBER This option replaces the non-blank Lease Number with the value of the Unit Well Serial Number, if it exists. In some states this is a Permit number. If Unit Well Serial Number is blank, it will replace the Lease Number with a null field.  Do not use “A” in prefix/suffix to designate Allocated Production When loading Allocated Production, this option removes the default “A” prefix/suffix stream code appended to the producing formation name on Totals and Formation tabs. Use Digits for Matching Initial Well Completions This option is used only in conjunction with the miscellaneous options for loading initial well completions. It sets the API number of digits used to match with wells in your project. June 30, 2011 29 Import Production from IHS Direct Connect Direct Connect to Well and Production Data Totals Tab This screen controls where the Cumulative values for each producing formation stream are stored, and how they are named. Zone for Storing Formation Totals Choose the Zone in which to store the Producing Formation totals, or use the New button to create a new name. TIP: For best results, always create a new Zone for storing these data rather than placing in the WELL zone. It streamlines data management and project refresh rates. Zone Items This section contains a list of the Zone items and associated names. The first 4 items store the cumulative values for Oil, Gas, Water, and Days. When loading production by producing formation names, each stream has a production code appended to the name as either a prefix or suffix, as selected on the Formations tab. The code relates to the stream and type of production loaded. In this case: AO = Allocated Oil 30 AG = Allocated Gas AW = Allocated Water AD = Allocated Days June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect The next 3 items store additional miscellaneous information: Lease Name: stores the text of the Lease Name in the item PRDLSNAME Lease Well Count: stores the number of wells in the multi-well lease for the current producing stream; relates to how the production data for the lease are subdivided. Prod ID: stores the IHS production entity ID or PID text string. Formations Tab This tab is active whenever you select the option to Load Production into Individual Formation Names on the General tab. It provides a listing of each producing formation name and a count of the number of wells with that name. Buttons The All and None buttons allow you to either select all, or clear, the formation list. You can also select specific names using either the Shift or Control keys. Refresh with Translations button uses the translation operation selected on the Fm Subst tab. Export Fm List button creates a file containing the information listed in the formation list box. June 30, 2011 31 Import Production from IHS Direct Connect Direct Connect to Well and Production Data FM Name From This option allows selection of the format for the producing formation name. Fm Name Code: uses the IHS alphanumeric age and formation code, such as 403BCGM or 354BRNT Fm Name Desc: uses a descriptive code such as BEND CONGL or BARNETT/SH/ Fm Name Code (Age Only): uses the IHS age code only, such as 403 or 354 Reservoir Name: uses the reservoir name, such as BEND CONGLOMERATE GAS or BARNETT SHALE Prod Stream Name Qualifier This option allows you to select the application of the stream code as a Prefix or Suffix. Examples are AO_403BCGM for the prefix option and 403BCGM_AO for the suffix option. CAUTION: Be consistent with selection of the Fm Name and stream qualifier formats. Changing these formats for subsequent updates can result in duplication of production, since producing names are unique to each import. For best results, you can save your import settings and reuse them for updates; see later section for more information. PdCum Tab This screen provides options for storing production cum values in the Prod Cums table of your project. Cumulative values are computed by summing the monthly production streams. PD CUM TABLE UPDATE This option controls how data are stored in the Prod Cums table. DO NOT STORE in PdCum DB: no data are stored STORE PdCum Data using ProdID as FmName: stores PdCum data, but also stores the PID in the FmName field and the producing formation name in the Altname field. This results in 1 Prod Cum entry for each PID. 32 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect STORE PdCum Data using ProdID as Altname: stores PdCum data, but also stores the PID in the Altname field and the producing formation name in the FmName field. This results in 1 Prod Cum entry for each PID. STORE PdCum Data using FmName Only: stores PdCum data, but only the producing formation name is stored in the FmName field; Altname field is blank. Multiple entities for the same producing formation are summed. PdCum Name Qualifier This option allows you to add a qualifier to the producing formation name stored in the Prod Cums table, as either a prefix or suffix. Leases Tab This screen controls which leases are used for the production import. The default is all leases. Use the None button to clear the list. Use Shift or Control to select specific leases. The list displays the lease name along with the well count for that lease. June 30, 2011 33 Import Production from IHS Direct Connect Direct Connect to Well and Production Data P/Z Tab This screen provides options for capturing the P/Z (compressibility) data streams for gas wells. Load P/Z Gas Cum Data Selecting this option activates the import options for loading this data. Load P/Z Decline Data Into This section contains the names for the P/Z data streams. P/Z: creates a stream called PZ for the P over Z pressure Gas Cum: creates a stream called PZGASCUM for the Gas volume from test BHP: creates a stream called PZBHP for the Bottom Hole pressure 34 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect Fm Subst Tab This screen provides a mechanism to change the names of the IHS formations using a name substitution file. This file’s format follows the same rules as those described in the Well section. The formation substitution file can be used to load several producing formation names into a single entry in the project database. An example of the file format is shown above. Browse to the file location so that the complete path appears in the field. Use the Test Your Translations button to verify the file works correctly. This file must be selected to use the Refresh with Translations button on the Formations tab. Query Tab This screen allows you to select a query from a list of your saved Enerdeq queries. You cannot create any queries from this screen. Click on the Retreive IHS Enerdeq Queries button to view your saved queries. Select the query and click the Run Query button to use the query for well selection. June 30, 2011 35 Import Production from IHS Direct Connect Direct Connect to Well and Production Data Save Settings It’s a good idea to save your settings and load them when updating production. This ensures no duplication of production by selecting different formation name formats or stream qualifiers. Select File>Save Settings. Type a name that’s meaningful, such as Production Import Settings. When updating production, select File>Load Settings; this restores current selections. Status Tab Click the Import Production button, click the OK button, and view the import progress on this screen. 36 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect The system processes a batch of PID’s at a time until all production is imported. The time required for import depends upon the number of wells and producing formations selected. The completed import shows that production data imported for 7,700 wells, with total import time about 32 minutes. Save settings and close the IHS (US) Prod Loader screen. View the results in your project. The examples below show results for WSN 18 (UWI = 42497000160000). IHS Production Zone: Individual stream totals with “A” prefix June 30, 2011 37 Import Production from IHS Direct Connect Direct Connect to Well and Production Data Prod Cums: All PID’s display in ALTNAME FIELD, including 1 Multiwell WELL Zone: Cumulative values for Oil, Gas, Water from all producing formation streams 38 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect Unallocated Production – All US States This section describes import options associated with loading Unallocated Production. Only those changes specific to this import are described. See the previous section for discussion of all import options. NOTE: This is the default Production Type for projects with wells in any state(s) other than Texas and Louisiana. It must be selected for Texas/Louisiana wells. Getting Started The example below uses wells from a project in Colorado. Launch the US Production Data Loader from the Main module:  Project>Direct Connect>IHS US Enerdeq or Canada>Import Production from IHS Direct Connect Choose the appropriate well selection method for initial production import. In this case the wells in Main are selected. Click the OK button. View the Status screen for PID results and proceed to the General tab. June 30, 2011 39 Import Production from IHS Direct Connect Direct Connect to Well and Production Data General Tab Choose streams as described in previous section. Note the following parameters: Texas/Louisiana Production Type: Notice that the field is grayed out, since all the wells are in Colorado. This occurs for wells in any states except Texas and Louisiana. The NOTE indicates Unallocated Production as the default. Method to Apply Lease Production to Individual Wells: Recommend Load Production into Each Well in the Lease and subdivide production by number of wells in lease. This option stores an equal share of the total production among all wells in the lease. Production available to Load: The results show 105 PID’s with 25 at the Lease level and 80 at the Well level. This information can help you select the appropriate method for applying lease level production. 40 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect Totals Tab Select parameters as noted in previous section. Select or create new Zone for storing individual streams. Zone Items The item names are similar to those in the Allocated import, except the stream codes are O, G, W, and D in the Unallocated Production import. Remaining Tabs Select all remaining parameters as described in the previous section under Allocated production. June 30, 2011 41 Import Production from IHS Direct Connect Direct Connect to Well and Production Data Save settings for future use and then click the Import Production button. The completed import processed 98 wells with production data in about 14 seconds. A WSN list of updated wells was also created and stored for future use. Close the Production Loader and view the results in the project for WSN 42. IHS Production Zone: Shows individual producing formations and Lease Well Count of 3. This means the production values listed for this well are 1/3 of the total lease level production. 42 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect Allocated and Unallocated – Texas/Louisiana and Other States Use this import method for projects containing wells from multiple states including Texas and/or Louisiana. This example uses a project with wells in an AOI covering Arkansas, Louisiana, and Texas. Since this project contains wells from 3 different states, there are 2 IHS Production Types available for loading: Unallocated Production for the Arkansas wells Allocated Production for the Texas and Louisiana wells (must select) Only those changes specific to this import are described. See the previous sections for discussion of all import options. Getting Started 1. Launch the IHS Production Loader by selecting Project>Direct Connect>IHS US Enerdeq or Canada>Import Production from IHS Direct Connect 2. Choose the well selection option that works best for you. In this case the option Use the 1443 wells in Main module is selected. 3. Click the OK button and view the PID results on the Status screen. Proceed to the General tab for parameter selection. June 30, 2011 43 Import Production from IHS Direct Connect Direct Connect to Well and Production Data General Tab 1. For the Texas/Louisiana Production Type, select Allocated Only. The default of Unallocated applies to the Arkansas wells. (See Note on screen). 2. Select the Method to Apply Unallocated Lease Production for the Arkansas wells. The Subdivide Production among wells in the Lease is recommended. 3. Select other parameters as described in previous sections. 44 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect Options Tab Select the miscellaneous options of interest and skip the Change Date section since this is an initial production import, not an update. In this example the option Do not use “A” in prefix/suffix to designate Allocated production is selected. This selection simplifies the stream names and subsequent bubble mapping, by using consistent stream codes for all wells. Remaining Tabs Select the parameters on the remaining tabs as previously described. Save your settings, if desired, and then click the Import Production button. June 30, 2011 45 Import Production from IHS Direct Connect Direct Connect to Well and Production Data View the results on the Status screen, close the Loader, and view the results in your project. The results indicate that 631 PID’s were processed for 446 wells. Production results for a Louisiana well: WSN 328 (UWI = 17017008130000) IHS PRODUCTION Zone 46 June 30, 2011 Direct Connect to Well and Production Data Import Production from IHS Direct Connect Prod Cums Production results for a Texas well: WSN 1099 (UWI = 42067007580000) IHS PRODUCTION Zone Prod Cums June 30, 2011 47 Import Production from IHS Direct Connect Direct Connect to Well and Production Data The production results for an Arkansas well: WSN 70 (UWI = 03091009630001) IHS PRODUCTION Zone Prod Cum Best Practices 1. Be consistent with selection of producing formation names and stream qualifiers (prefix/suffix) on import updates to avoid duplication of production. Use the Save/Load Settings options. 2. Be consistent on the number of digits in your API numbers on import updates to ensure production is stored with the same well. Again, using the Save/Load Settings options will help for imports in which the Initial Completions only, and number of digits used to match the API number, options were selected. 3. Create a Zone dedicated to storing individual producing formation CUMs and related data. This action improves data management and project performance by not overloading the Well zone. 4. Create a WSN list of all wells with monthly production to streamline viewing and analyzing production data. 48 June 30, 2011 Import Options for Prior Versions of PETRA The current document describes the Well and Production Import options available with PETRA version 3.6.1. Not all these options are available in prior versions of PETRA. If you are currently using version 3.4.x or 3.5.x, check here for sample screen shots and discussion, or better still, update to the current version of PETRA. Changes for Well Data Imports The Well Data Loader has not changed significantly with PETRA version updates. The main differences in the prior versions are: Import Options>General Tab: fewer options available Import Options> No Directional Survey Tab No 297 File button Changes for Production Data Imports The most significant change in the current version (3.6.1) of the Production Data Loader is the revision in selection of Production Data Type. The current version streamlines the import of Allocated and Unallocated Production, especially in multi-state projects which include wells from Texas/Louisiana. In prior versions of PETRA, there were basically 3 Production Import Scenarios based on production type and project area: 1. Single Import – Allocated Production: use this option when your project contains wells from either or both Texas and Louisiana, but no other states. Since Texas Gas is reported at the well level, this option imports all Texas production. 2. Single Import - Unallocated Production: use this option when your project contains wells from 1 or more states, excluding Texas and Louisiana. 3. Dual Imports – Allocated and Unallocated: use this option when your project contains wells from multiple states including Texas and/or Louisiana. For example, a project covering Texas, Louisiana, and Arkansas. Use the Allocated Production type for the Texas/Louisiana wells; then the Unallocated Production type for the Arkansas wells. Sample screen shots and points to note for each of these scenarios, as well as other options, are provided below. June 30, 2011 49 Import Options for Prior Versions of PETRA Direct Connect to Well and Production Data Allocated Production – Texas/Louisiana Only This section describes specific parameters for loading production data for projects containing wells from Texas and/or Louisiana only. Only those parameters that differ significantly from those in the main body of this document are shown. General Tab This screen provides selection options for production streams and type. Production Type Loaded The availability of this option is determined by which data are available. Currently, allocated data are only available in Texas and Louisiana. The options include: Unallocated Only – available for all states Allocated Only – available for Texas and Louisiana ONLY 50 June 30, 2011 Direct Connect to Well and Production Data Import Options for Prior Versions of PETRA Sum of Allocated and Unallocated – this option applied to Texas and Louisiana, but is no longer necessary, as Texas Gas is reported at the Well level and imports via the Allocated option; Oil and Gas are both allocated in Louisiana Method to Apply Lease Production to Individual Wells This option is important when loading unallocated production from leases with multiple wells. It determines how the lease production is applied to each well in the lease. NOTE: The NAME of this option changed in the current version. It always applied to Unallocated Production only, and is ignored when importing Allocated Production. Options Tab This screen provides a variety of import options, as well as another chance to restrict the import to a particular timeframe, if you did not choose this option on the initial screen. Fewer options available! The remaining tabs have no significant changes from current version. June 30, 2011 51 Import Options for Prior Versions of PETRA Direct Connect to Well and Production Data Unallocated Production – Other US States This section describes import options associated with loading Unallocated Production for projects with wells in any state(s) other than Texas and Louisiana. This example uses a project with wells from Colorado. The only major change from the current version is on the General Tab. General Tab Production Type Loaded: Notice that the field is grayed out – Unallocated Only is the only option available, since the wells are in Colorado. This occurs for wells in any states except Texas and Louisiana. Select all remaining parameters as noted in the previous sections. 52 June 30, 2011 Direct Connect to Well and Production Data Import Options for Prior Versions of PETRA Dual Production Imports– Texas/Louisiana and Other States Use this import method for projects containing wells from multiple states including Texas and/or Louisiana. This example uses the same project with wells in Arkansas, Louisiana, and Texas, as described in the previous section. Since this project contains wells from 3 different states, there are 2 IHS Production Types available for loading: Unallocated Production for the Arkansas wells Allocated Production for the Texas and Louisiana wells NOTE: The main change for this import scenario is that it requires 2 separate imports, 1 for each production type. Pre-import Preparation To streamline your workflow before importing production, you should create the following: 1. WSN list containing the wells for the Unallocated Production import. In this case the list contains Arkansas wells only. 2. WSN list containing the wells for the Allocated Production import. In this case the list contains Texas and Louisiana wells only. 3. New zone for storing individual producing formation cumulative values. NOTE: If you prefer to skip these steps, you can use the Search Wells by Data Criteria option for well selection, and create new zone option on the Totals tab. First Import Decide which production type you plan to import first; there is no priority to the order. In this example the Allocated Production is loaded first. 1. Select the WSN list for the Allocated Only import – the Texas/Louisiana wells. This reduces the well list in Main to just those you need for this import. This step is optional, but recommended for efficiency. 2. Launch the IHS Production Loader by selecting Project>Direct Connect>IHS US Enerdeq or Canada>Import Production from IHS Direct Connect 3. Choose the well selection option that works best for you. In this case the WSN list is already selected, so the option Use the 1136 wells in Main module is the best choice. June 30, 2011 53 Import Options for Prior Versions of PETRA Direct Connect to Well and Production Data 4. View the PID results on the Status screen. In this example there are 938 total PID’s; 513 allocated, 307 unallocated, and 118 well. Therefore, 631 PID’s will be imported: allocated + well. 5. On the General tab, for Production Type Loaded, select Allocated Only. Choose other options as applicable. Recall that the Method to Apply Lease Production is ignored when importing Allocated Production. 54 June 30, 2011 Direct Connect to Well and Production Data Import Options for Prior Versions of PETRA 6. On the Options tab, select the miscellaneous options of interest and skip the Change Date section since this is an initial production import, not an update. 7. On the Totals tab, select the zone for storing the individual producing formation stream cumulative values and the items to store. In this example the data are stored in the IHS Production zone. The streams use the AO, AG, AW, etc. codes to indicate allocated production in your database. 8. On the PdCum tab, select STORE PdCum Data using ProdID as Altname and use A as the PdCum Name qualifier. This helps in identifying which PID’s relate to the allocated production import. (The qualifier is optional). 9. Make your selections on the remaining tabs. Save settings, if desired, and then click the Import Production button. June 30, 2011 55 Import Options for Prior Versions of PETRA Direct Connect to Well and Production Data 10. View the results on the Status screen, close the Loader, and view the results in your project. Production results for a Louisiana well: WSN 353 (UWI = 17017008130000) IHS PRODUCTION Zone Prod Cums 56 June 30, 2011 Direct Connect to Well and Production Data Import Options for Prior Versions of PETRA Production results for a Texas well: WSN 4591 (UWI = 42067007580000) IHS PRODUCTION Zone Prod Cums Second Import Once the first import is complete, you launch the importer for the second import, in this example Unallocated Production. 1. Select the WSN list for the Unallocated Production import. In this example the list contains 307 wells from Arkansas. 2. Launch the IHS Production Loader as in step 2 of previous section and select the wells for import. In this example, the 307 wells are already selected in Main, so that’s the option selected. 3. View the PID search results on the Status screen. In this example there are only 54 total PID’s: 0 allocated, 52 unallocated, and 2 well. June 30, 2011 57 Import Options for Prior Versions of PETRA Direct Connect to Well and Production Data 4. On the General tab, select the Method to Apply Lease Production, in this case the Subdivide option, and all other parameters of interest. Production Type Loaded (Unallocated) is grayed out, as there is no other option. 58 June 30, 2011 Direct Connect to Well and Production Data Import Options for Prior Versions of PETRA 5. On the Totals tab select the zone for storing the totals, in this case IHS PRODUCTION. Notice that the stream codes are O, G, W, etc. This differentiates these producing formation streams from the allocated streams. 6. Make selections on the remaining tabs as previously described. Save the unallocated settings, if desired. Click the Import Production button, view the results on the Status screen, and then close the Production Loader. The results show that 54 PID’s were processed for 47 wells. June 30, 2011 59 Import Options for Prior Versions of PETRA Direct Connect to Well and Production Data The production results for an Arkansas well: WSN 70 (UWI = 03091009630001) IHS PRODUCTION Zone Prod Cum – (A qualifier of U for Unallocated was used) Once both production imports are complete, you might want to create another WSN list of all wells with monthly production, to streamline viewing and analyzing production data. 60 June 30, 2011