NOTE: The OCC Oracle Well Browse Web Application is no longer being updated. All information has been migrated to the New Well Browse
Information accessed through the web forms is query-only. No records can be inserted, updated or removed via the web application.
The API Number Suffix is not shown on the Well Results form, all suffixed records are queried as one record. When a record is queried it will display all of the information that is associated with that well. The suffixed records can be viewed by clicking one of the Permits, Completions, and Plugging Buttons. Suffixes are used when more than one occurrence of an Intent to Drill, Completion, or Plugging exist. This allows storage and display of all of the historical data related to a well. The last or greatest suffix should be the record that is in effect and replaces all earlier (historical) occurrences of that well's information. When one of the buttons in the Save Data section are pushed all of the suffixed records will be incorporated in the resulting .CSV output file.
There are several fields added to this system that will not contain any data until the system is complete. These fields are listed in the Explanation of fields at the end of the manual.
A search for well information will always start on the Well Search form and be displayed on the Results tab page, it is possible to query the database via the results form but not recommended.
If there is more than one record displayed, the current record will be highlighted in light blue and other records may be navigated to by using the scroll bar, the arrow keys, or clicking on the desired record.
After a well has been chosen, pushing one of Basic, Previous Operator, Permits, Completions, Production, or Plugging buttons (at the top of the form) will provide more detailed information. If the button is grayed out there is no data to display. The return button will take you back to the results tab page.
Most of the forms have tabs. When the tabs are clicked, it will bring up a new subset of information.
The Well Search , Operator Browse, and Legals Converter are available for Internet use.
When searching the Well Inventory system try not to include too many search criteria. Doing so might restrict the results, causing too few records to be displayed. It is simple to navigate back to the Search tab page from the Results tab page and add new restrictions to your search and re-query the database, to narrow your results.
To initiate a search, enter your search criteria and push the “Search Now” button. Your results will display on the “Results” tab page.
The Well Inventory System can be searched using Well Name with or without the Well Number. The Search tab page allows the option of searching for well information based on:
Wells that include the text entered in their Well Name.
Including the Well Number in a search is not recommended. The Well Number field may contain characters other than numbers, such as "1-3" which may cause the results to exclude more records than expected.
The API Number consists of two separate fields on the search tab page, API County Number and API Well Number. The APICounty field reflects the county in which the surface of the well is located. The API Number is uniquely assigned to each well. All wells in a county will be returned by entering an API County Number. Push the “Select API County” button to select the API Number by County Name. Note, the API County is not necessarily the same as the Location County. The Location County is either the county containing the Surface Hole or the county containing the Bottom Hole, as specified in the Location section.
Once the results are returned, and one of Basic, Prev_Oper, Permits, Completions, Production, or Plugging tabs are selected, you may find more than one record displayed. This allows storage and display of all of the historical data related to a well’s history. Wells can have more than one life cycle. A well can be permitted, drilled, and completed, then re-entered via a new permit and re-completed, retaining the same Api Number.
To search the Well Inventory system for wells operated by a particular operator enter an Operator Name or Operator Number. If unsure of the exact spelling of an operator’s name, as it exists in the system, push the “Select Operator” button or "double click" the field and select one of the operators from the list provided.
The Well Inventory system will allow searches based upon the date of a Permit to Drill, Spud Date, Completion Date, First Production Date or a Plugging Date. To search the Well Inventory system based on the date a well was permitted to drill, spudded, completed, first produced, or plugged select one of the radio buttons and enter the date the search should be based.
To select a particular day for your search enter that date in both the Begin Date and End Date and select one of the radio buttons.
To search based on a date range enter the Beginning Date and the Ending Date of the period and select one of the radio buttons.
To search for all of the Permits (for example) that have been approved since 1/1/2005 enter that date in the Begin Date field and leave the End Date blank. Select the radio button for “Permit to Drill”. The results will display all of the records of wells that have a permit to drill approved date from 1/1/2005 to today’s date.
If the End Date is used and the Begin Date is left blank the results will display all of the permits to drill approved prior to the date entered, if the “Permit to Drill” radio button is selected.
The Well Inventory System may be searched by well location, according to the Surface Hole or the Bottom Hole. To search by location enter any of the location information known. If the Surface Hole Location radio button is selected, the system will search for wells with a surface location as specified in the Location section. If the Bottom Hole Location radio button is selected, the system will search for wells with a bottom hole location as specified in this section. It should be noted that the Results screen always displays the surface location of the well. If Surface Hole Location is selected, the Results screen will display the legal description for the well surface. If Bottom Hole Location is selected, the Results screen will display the legal description for the well surface that has a bottom hole as specified in this section.
The County may be entered or may be selected by pushing the “Select Location County” button or double clicking the county text box. Note, the county is the county that the Surface Hole or Bottom Hole is located in; it is not necessarily the county specified as the API County. Once the county is selected a button will appear under the Township Field. Pushing this button will provide all possible townships for the county selected. Once the county and township have been selected a “Select Range” button will appear. Pushing this button will provide all range values available for the county and township selected. Once the County, township and range are selected a “Select Section” button will appear. This button will provide all sections available for the County, township and range selected.
It is possible to search the Well Inventory System by entering values in any of the fields directly.
The location section of the search tab page includes three radio buttons, “Indian Meridian”, “Cimarron Meridian” or “Not Used”. Including the Indian Meridian or Cimarron Meridian in your search criteria will speed the search although your search will work fine with the “Not Used” radio button selected.
The results of your search can be viewed and saved to your PC. The “Results” tab page has four buttons located near the bottom center of the page in the “Save Data” section. They are “View all Basic Info”, “View all ITDs”, “View All Production” and “View all Operators”.
If your Internet explorer allows pop-ups you can push one of these buttons to display a spreadsheet of the results of your search. These buttons are dependent upon how your PC opens " .CSV" (Comma Separated Values) files.
If your PC has no application installed to open this type of file, it may open the file as a text file. PCs running with Microsoft’s Excel will open the ".CSV" file as a spreadsheet. To save the file once opened go to "FILE\SAVE AS" and save the file as a spreadsheet, workbook or CSV file on your PC. If not saved as an Excel file you will loose any formatting such as leading zeros or date formats.
This button produces a spreadsheet that includes all of the records related to your search. You will find wells that have more than one record. This allows storage and display of all of the historical data related to a well’s history. Wells can have more than one life cycle. A well can be permitted, drilled, and completed, then re-entered via a new permit and re-completed. The spreadsheet produced will contain general information about the wells returned from your search, including location, status, operator, well class and depth.
This button will produce a spreadsheet that includes all of the Intent to Drill records relating to your search. You will find wells that have more than one record. This allows storage and display of all of the historical data related to a well’s history. Wells can have more than one life cycle. A well can be permitted, drilled, and completed, then re-entered via a new permit and re-completed. The spreadsheet produced will contain location, operator, drilling type, well class, formations and depths.
This button will produce a spreadsheet that includes all of the production records relating to your search. You will find wells that have more than one record. This allows storage and display of all of the historical data related to a well’s history. Wells can have more than one life cycle. A well can be permitted, drilled, and completed, then re-entered via a new permit and re-completed. Also, a well having more than one purchaser or producing formations will have multiple production records. The spreadsheet produced will contain location, operator, purchaser, formation, lease number and Gas volumes per month. Each year will be displayed on one line. Oil production has not been tracked by the Commission for several years, and is not available from our database.
This button will produce a spreadsheet that includes all of the operator records relating to your search. The spreadsheet produced will contain company name, open/closed, phone and address.
What do the buttons do?
Six buttons have been provided, at the top of the Query form. If the buttons are grayed-out, that signifies that there is no information for that record. For instance, if a well has been queried and the Plugging button is gray, there is no plugging information.
This button will take you to the Oklahoma Corporation Commission Oil and Gas Well Records Imaging System. If you select a record from the results tab page, and push this button it will display all of the forms in the Oil and Gas Well Records Imaging System that are related to the API Number of the well. It is simple to clear the API Number and enter location information to initiate another search for images that may relate to the well but do not have the API Number assigned to them.
This button will take you to the Oklahoma Corporation Commission Oil and Gas Well Logs Imaging System. If you select a record from the results tab page, and push this button it will display all of the forms in the Well Logs Imaging System that are related to the API Number of the well. It is simple to clear the API Number and enter location information to initiate another search for log images that may relate to the well but do not have the API Number assigned to them.
Pushing this button will produce a spreadsheet containing all of the basic information for the selected record.
This is the Basic information form. It provides general information regarding a well. All of the wells will have some basic information. The Basic form will always be navigable from any of the other forms, by selecting the Basic tab.
On the API Resolved to fields with the red labels there is a different display if an API number is 'Resolved to' or 'Resolved from'. If an API number has been resolved, the resolved number will show up in the API Resolved field with a label that says 'API Resolved to' and an 'R' in the resolved indicator field. While viewing an API number, which is the result of an API resolve, then the API number that it was resolved from will be in the API Resolved fields, and the label will change to 'API Resolved From'. Also, the Resolved indicator will be blank.
The Effective Date is the date that the current operator became effective. This will help distinguish between previous operators and current operators.
The State Lease item will not have any data until the system is complete.
At this time all but a few records will have calculated Latitude and Longitude.
This form also has a Current Operator Information tab. This will provide more detailed information on the current operator. This is the same information that is provided on the Operator Browse form.
The Previous Operator form provides information about the previous operators of this well. The previous operators are sorted in descending order with the most recent operator first. All previous operators for all suffixed API Numbers will be shown on this form. The effective date, if known, is the date that the corresponding previous operator became the effective operator of the well.
Detailed information is provided about each previous operator listed. There is no need to go to the Operator Browse form to gather this information.
The Permits form will not contain permits to drill which have not yet been approved. Once the permit is approved and receives an API Number it will be displayed.
The Stage Collar Depth and PBTD (Proposed bottom total depth) will not contain any data until the update forms are in place.
The Approval Date is used to display the Permit records in ascending order. The permit with the oldest date will be displayed first.
The Order tab is provided to display all orders. The orders included will be Increased Density, Spacing, Special, and Location Exception.
The records will be in ascending order the earliest completion date will be displayed first. There will be cases when completion information is available and yet there is no Completion Date. In this case, records without completion dates will be displayed first.
One of the things that will be on the Completions form, that will not be on other forms is an * (asterisk) in the S (suffix) field. This signifies that this information has been added to the database from other sources. Also, the Operator Name may be gray text instead of black. This indicates that, although a valid operator number was not available for lookup, the operator name was available as part of the historical completion record. Some of the completion records do not contain a completion date. These records were incorporated in the Well Inventory System from sources other than a form 1002A (Completion Report) from the operator.
The Approved Date and Reject Date, on the Basic Tab page, will not contain any data but will be used when the system is completed. Also, the Measured Total Depth and BHL (bottom hole location) from Lease fields on the Bottom Hole tab page will not contain any data.
The production form has several terms that may require further explanation. The form has three sections, Allowable Unit, Annual Totals, and Monthly Totals.
Wells that have Oil Production information will most likely be historical records. Oil volumes are displayed in barrels. Gas volumes are displayed in MCF (1000 cubic feet).
The first section of the form is the Allowable Unit. An Allowable Unit is the amount of oil or gas, which can be produced in a certain time span for a specific unit as determined by the Corporation Commission. The unit could be a single formation, multiple commingled formations, or multiple wells in a pool. There can be more than one Allowable Unit for a well, if the well has more than one producing formation and the formations are not commingled. Check the status bar at the lower left of the Production form to see how many Allowable Units exist for the selected well. If the status bar displays "Record: 1/1" as it will in most cases, it signifies that only one Allowable Unit exists for the selected well. More than one well can share an allowable, provided they are producing from the same formation. When there are two or more Allowable Units per well, the scroll button next to Allowable Unit can be used to navigate between allowable units. The Allowable Number includes the county number, base number and sub number. The sub number is used to distinguish between separate Allowable Units within the same well.
Next is the Allowable Class. There are Allowable Classes for Gas and Oil Wells. The Allowable Classes for Gas wells are Allocated Gas (AG), Unallocated Gas (UG), Guymon-Hugoton (GH), and Special Allocated Gas (SG). The Allowable Classes for Oil wells are Allocated Oil (AO) and Unallocated Oil (UO).
There are three Allowable Types. They are Individual (I), Shared (S), and Ratable (R). A Shared Allowable is a situation where more than one well shares an allowable. Ratable is the same as shared allowable but the wells do not share equally. Wells that share an allowable will have the same Allowable Number but different API Numbers.
The Pool Number is a five digit number used for special allocated wells. The pool number refers to a common source of supply for the wells that have the same pool number. When a well no longer is producing the Production Terminated field will display a "Y" for yes.
The next section is the Annual Totals. Each allowable unit may have multiple years of production. The most current year is already selected. When the arrow button next to "Select Year" label is pressed all years of production will be shown. For each production year, there may be one or more reporters (purchasers, operators, transporters, etc.) reporting production. The Oil Totals and Gas Totals are based on all of the monthly volumes that has been reported for the selected year. The totals for the selected year for all reporters is calculated and displayed below the individual reporter totals. If a reporter is no longer reporting production, an "N" will appear in the currently reporting field. If there are more than 4 reporters, the scroll bar can be used to view the remaining reporters.
In the Monthly Totals section, volumes that have been reported will be shown by month for the selected year. If nothing was reported, the field will be blank. If there is a "0" in the field, it means that the reporter did report a volume of "0". The Oil Volume and Gas Volume totals are displayed for all the reporters for the selected year for each month. Use the scroll bar to view all twelve months.
The Plugging form has tabs that can be used to view other information. The data will be in ascending order with the oldest plugging date first. A plugging completion date or a 1003D (Affidavit of Old Well Status) approved is required to create a plugging record.
The Reject Date and Approved Date will not contain values until the system is complete with add and update forms.
The Operator Browse button will open the operator application. This application will provide lists of all operators, active operators, out of business operators, operators by county or a list of all, open and out of business purchasers.
What additional information do we have?
Well Status indicators are the OG and ITD columns. These status indicators will help in understand the status of the well. The UIC column indicates that this well may be used as a Underground Injection Well. This table may help explain the options available for the OG and ITD status fields.
|ABREVIATIONS USED IN STATUS FIELD||ABREVIATIONS USED IN PERM_STATUS FIELD|
|PLUGGED & ABANDONED|
|STATUS||PERM_STATUS||NULL||OR has plugging information with no Plugging_Comp_Date|
|UN||P||has plugging information with no Plugging_Comp_Date, permit pending|
|ND||P||No spud, completion or plug date pending permit|
|EX||E||No spud, completion or plug date expired permit|
|CA||C||No spud, completion or plug date canceled permit|
|SP||NULL||Spud date > completion or plug date|
|AC||NULL||Active well with no permit or completion date > permit date|
|AC||P||Active well with pending permit|
|AC||E||Active well with expired permit approved after completion date|
|PA||NULL||PA||P||Plugged well with pending permit|
|PA||E||Plugged well with expired permit approved after plugging date|
There is a rare occasion that a Well has a canceled status. This occurs when an intent to drill is canceled on a new drill (ND). In this case the OG Status will be "CA" and the Permit Status will be "C".
Production information can be search by two ways, either by the Allowable information or basic well information (Api Number, Well Name, etc). A combination of Allowable Number and Well information cannot be used. When querying by Allowable Number use the Search by Allowable Number button to perform the query.
The purpose of this documentation is to provide general instructions, terms, and definitions and to help navigate through the forms and get a general idea concerning the information presented. It is not a detailed explanation. It does not explain and was not intended to explain log types, unitization orders, commingled zones, or any details beyond the scope of simple on-line documentation. In some cases oversimplification can lead to inaccuracies. Therefore, please treat this document in the manner in which it was intended, which is simply to provide a general understanding of the information provided and to help in the retrieval of the information and the navigation of the forms. Any questions regarding some specific area of interest or concern should be directed to some person or persons whose focus or expertise lies in that area.
|Form||Tab||Field Name||Field Prompt||Definition||Allowable Values|
|Well Query||None||OG_WELLS.RSLV_INDICATOR||None||Indicates if Well is Resolved||R|
|Well Query||None||OG_WELLS.WELL_CLASS||Class||Oil, Gas, Injection, Salt Water Disposal||OIL, GAS, INJ, SWD, ETC.|
|Well Query||None||OG_WELLS.STATUS||OG||Status of Well||UN, ND, SP, EX, AC, PA|
|Well Query||None||OG_WELLS.OPERSTATUS||UIC||Active, Plugged, Terminated, Permit||AC, PA, TM, PD|
|None||OG_WELLS.PERM_STATUS||ITD||Status of Permit - Pending or Expired||P, E|
|Basic||Basic Well Info.||OG_WELLS.RSLV_API_COUNTY||API Resolved to/From||Displays the API Number that it was resolvd to/from||Number|
|Basic Well Info.||OG_WELLS.RSLV_API_NUMBER||API Resolved to/From||Displays the API Number that it was resolved to/from||Number|
|Basic Well Info.||OG_WELLS.CURRENT_OPER_EFF||Effective Date||Date the current operator became effective||Date|
|Basic Well Info.||OG_WELLS.CALC_LATLONG||Calculated||Was Lat/Long Calculated or were exact Coordinates known||Yes or No|
|Basic Well Info.||OG_WELLS.OTC_COUNTY||OTC Prod Unit||Number assigned by Oklahoma Tax Commission||Number|
|Basic Well Info.||OG_WELLS.OTC_LEASE_NO||OTC Prod Unit||Number assigned by Oklahoma Tax Commission||Number|
|Basic||Basic Well Info.||OG_WELLS.OTC_SUB_NO||OTC Prod Unit||Number assigned by Oklahoma Tax Commission||Number|
|Basic||Basic Well Info.||OG_WELLS.ELEVATION||Elevation||Ground Elevation||Number|
|Basic||Basic Well Info.||OG_WELLS.STATE_LEASE||State Lease||Is the Well located on State Leased land||Yes or No|
|Basic Well Info.||OG_WELLS.ERROR_IND||Source Code|
|Basic Well Info.||OG_WELLS.FEDERAL_GOV||Federal Gov.||Is the Well located on Federal Leased land||Yes or No|
|Basic||Basic Well Info.||OG_WELLS.TRANS_ID||Transaction ID||Transaction ID from OG_Online||OGEO, OGQV, ETC.|
|Current Operator Info.||COM_OPERBRWS.XFR_HIST||Transfer to History||Has this operator been transferred to history?||Yes or No|
|Basic||Current Operator Info.||COM_OPERBRWS.PURCHASER_IND||Purchaser||Is this company a purchaser||Yes or No|
|Current Operator Info.||COM_OPERBRWS.SURETY_TYPE||Surety Type||Bond, CD, Financial Statement, Letter of Credit||BND, CC, CD, FS, LC|
|Basic||Current Operator Info.||COM_OPERBRWS.AGR_PLUG_FDATE||Agree to Plug||The date the operator has agreed to plug the well||Date|
|Previous Operator||None||OG_PREV_OPERS.EFFECTIVE_DATE||Effective Date||The date the previous operator became effective||Date|
|None||OG_PREV_OPERS.LETTER_SENT||Letter Sent||The date that a ??? Letter was sent||Date|
|Permits||Basic||OG_PERMITS.BATCH_ID_DATE||Batch ID||The assigned date of when the permit was received||Date|
|Basic||OG_PERMITS.BATCH_ID_NUMBER||Batch ID||The assigned number of when the permit was received||Number|
|Permits||Basic||OG_PERMITS.FEET_LEASE||Feet From Nearest Line||Feet From the Nearest lease line.||Number|
|Permits||Basic||OG_PERMITS.AMEND_REASON||Amend Reason||A reason for amending the permit.|
|Permits||Basic||OG_PERMITS.DRLG_TYPE||Drlg Type||Straight Hole, Directional Hole, Horizontal Hole||SH, DH. HH|
|Basic||OG_PERMITS.SURF_CSG_DEPTH||Surf Csg Depth||Surface Casing Depth||Number|
|Permits||Basic||OG_PERMITS.STG_COL_DEPTH||Stage Col Depth||Stage Collar Depth - If two stage cement job.||Number|
|Permits||Basic||OG_PERMITS.DEPTH_BASE||Depth to Base TW||Depth to base of treatable water||Number|
|Permits||Basic||OG_PERMITS.SURFACE_WATER||Surface Water||Will surface water be used?||Yes or No|
|Permits||Basic||OG_PERMITS.WATER_WELL||Water Well||Will a water well be drilled?||Yes or No|
|Permits||Basic||OG_PERMITS.DEEP_SURF_CSG||Deep Surf Csg||Has surface casing waiver been sent in?||Yes or No|
|Permits||Basic||OG_PERMITS.ALT_CSG_DESIGN||Alt Csg Design||Alternate Casing Design||Yes or No|
|Permits||Basic||OG_PERMITS.PBTD||PBTD||Plugged Back Total Depth||Number|
|Permits||Pits/Mud||OG_PERMITS.MUD_TYPE||Mud Type||Type of Drilling Mud Used||Water Based, Oil Based, Gas Based|
|Permits||Pits/Mud||OG_PERMITS.SURFACE_TYPE||Surface Type||Type of Surface||Alluvial, Terrace, Bed Aquifer, Other HSA, Non HSA|
|Completions||Basic||OG_COMPLETIONS.INCR_DENSITY||Incr Density||Increased density order required||Yes or No|
|Completions||Basic||OG_COMPLETIONS.LOCATION_EXCEPTION||Location Exception||Location Exception Required||Yes or No|
|Production||None||OG_PWELLS.ALLOWABLE_CLASS||Allowable Class||Allocated, UnAllocated, Guymon-Hugoton, Special||AG, UG, GH, SG, AO, UO|
|Production||None||OG_PWELLS.ALLOWABLE_TYPE||Allowable Type||Individual, Shared, Ratable||I, R, S|
|Plugging||Basic||OG_PLUGGING.AFFIDAVIT_1003D||Affidavit 1003d||Affidavit of old well status approved?||Yes or No|
|Plugging||Plugs||OG_PLUGGING.SAX||Number of Sacks||Number of sacks of cement used||Number|
|Plugging||Plugs||OG_PLUGGING.SLURRY_PUMPED||Slurry Pumped||Cement slurry volume pumped in cubic feet||Number|