OCC Archive Web Application
Well Search Instructions

NOTE: The OCC Oracle Well Browse Web Application is no longer being updated. All information has been migrated to the New Well Browse

  Go here to print Instruction Manual

Table of Contents

Return to Table of Contents

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

Return to Table of Contents

Oil and Gas Well Inventory System

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

Screen shot of Oil and Gas Web Dayabase with buttons for Welln Browse, Operator Browse, Legals Converter and Exit

Return to Table of Contents

Well Search

Screen shot of Well Search Screen

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.

Screen shot of Well Search page from Oil and Gas Web Application

Return to Table of Contents

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

Return to Table of Contents

Well API Number

Well API Search Screen

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.

Return to table of Contents

Well Operator

Screen shot of Well Operator searh screen

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.

Return to Table of Contents

Date Range

Screen shot of Date Range search screen

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.

Return to Table of Contents

Location

Screen shot of Location search page from Oil and Gas Web Application

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

Save Query Button

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.

Return to Table of Contents

View all Basic Info

View All Basic Info screen shot

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.

Return to Table of Contents

View all ITDs

Screen Shot of Create Excel Spreadsheet page

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.

Return to Table of Contents

View all Production

Screen shop of View All Production  Search page

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.

Return to Table of Contents

View all Operators

Screem shot of View all Operators Create Exel Spreadsheet page

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.

Return to Table of Contents

View Doc

image of well search screen with WELL SEARCH tab selected

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.

Return to Table of Contents

View Well Logs

screen shot of Well Log search example

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.

Return to Table of Contents

Save Record

Screen shot example of saving a record search

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

Return to Table of Contents

Basic

screen shot of what page looks line when selecing the Basic tab

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. 

Return to Table of Contents

Previous Operator

screen shot of information displayed on Previous Operator tab

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.

Return to Table of Contents

Permits

image of Permits screen with PERMITS tab selected

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.

Return to Table of Contents

Completions

Screen shot of page from Completions tab

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.


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.


Return to Table of Contents

Plugging

screenshot of Plugging data entry screen

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

screen shot of Operator Browse screen

 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      
PLUGGED & ABANDONED      

POSSIBLE COMBINATIONS OF OG_STATUS AND PERMIT STATUS

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

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


Back

Explanation of Fields

Well Query Basic Basic Basic Basic Basic Basic Basic Basic Basic
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
Previous Operator Permits Permits
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

Back