Well Search

  Click here to print Instruction Manual

  Table of Contents

Overview

Oil & Gas Well Inventory System

Well Search

Well Name

Well API Number

Well Operator

Date Range

Location

Saving Results

View Document Images

Basic

Prev. Oper

Permits

Completions

Production

Plugging

Conclusion

Explanation of Fields

Operator Browse

Back

Overview

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, Prev Oper, 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.

Back

Oil and Gas Well Inventory System

The Well Search , Operator Browse, and Legals Converter are available for Internet use.

Back

Well Search

 

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. 

Search

To initiate a search, enter your search criteria and push the “Search Now” button. Your results will display on the “Results” tab page.

Back

Well Name

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 have an exact match of text entered.

Wells that have a name that begins with the text entered.

Well names that end with the text entered.

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.

Back

Well API Number

The API Number consists of two separate fields on the search tab page, API County Number and API Well Number. The API County 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.

Back

Well Operator

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.

Back

Date Range

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.

Back

Location

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. 

Back

Saving Results

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.         

Back

View all Basic Info

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. 

Back

View all ITDs

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.

Back

View all Production

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.

Back

View all Operators

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.

Back

View Doc

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.

Back

View Well Logs

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.

Back

Save Record

Pushing this button will produce a spreadsheet containing all of the basic information for the selected record. 

 

Back

Basic

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. 

Back

Prev. Oper.

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.

Back

Permits

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.

Back

Completions

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 grey 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.

Back

Production

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.

Back

Plugging

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.

Back

Operator Browse

 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.

Back

 

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

UN

UNKNOWN

 

P

PENDING

ND

NEW DRILL

 

E

EXPIRED

SP

SPUDDED

 

C

CANCELED

EX

EXPIRED

 

 

 

CA

CANCELED

 

 

 

AC

ACTIVE

 

 

 

PA

PLUGGED & ABANDONED

 

 

 

POSSIBLE COMBINATIONS OF OG_STATUS AND PERMIT STATUS

STATUS

PERM_STATUS

 

UN

NULL

No permit, spud, completion or plug date

UN

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

Plugged well with no permit or plug date > permit date

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".

Search by Allowable Number

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.

Back

Conclusion

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 online 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.

Back

Explanation of Fields

 

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

Well Query

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

Basic Well Info.

OG_WELLS.RSLV_API_NUMBER

API Resolved to/From

Displays the API Number that it was resolvd to/from

Number

Basic

Basic Well Info.

OG_WELLS.CURRENT_OPER_EFF

Effective Date

Date the current operator became effective

Date

Basic

Basic Well Info.

OG_WELLS.CALC_LATLONG

Calculated

Was Lat/Long Calculated or were exact Coordinates known

Yes or No

Basic

Basic Well Info.

OG_WELLS.OTC_COUNTY

OTC Prod Unit

Number assigned by Oklahoma Tax Commission

Number

Basic

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

Basic Well Info.

OG_WELLS.ERROR_IND

Source Code

 

 

Basic

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.

Basic

Current Oper. Info.

COM_OPERBRWS.XFR_HIST

Transfer to History

Has this operator been transferred to history?

Yes or No

Basic

Current Oper. Info.

COM_OPERBRWS.PURCHASER_IND

Purchaser

Is this company a purchaser

Yes or No

Basic

Current Oper. Info.

COM_OPERBRWS.SURETY_TYPE

Surety Type

Bond, CD, Financial Statement, Letter of Credit

BND, CC, CD, FS, LC

Basic

Current Oper. Info.

COM_OPERBRWS.AGR_PLUG_FDATE

Agree to Plug

The date the operator has agreed to plug the well

Date

Prev. Oper.

None

OG_PREV_OPERS.EFFECTIVE_DATE

Effective Date

The date the previous operator became effective

Date

Prev. Oper.

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

Permits

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

Permits

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

Back