Well Search Instructions
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
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.
Oil and Gas Well Inventory System
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.
Search
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 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.
The API Number consists of two separate fields on the search tab page, API County Number and API Well Number. The
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 “
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 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.
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
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.
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.
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
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
