|
The GOMR.BOEMRE.GOV website is no longer being updated. In its place, BOEM.GOV and BSEE.GOV have been launched. Over the next several weeks, the appropriate content from the GOMR.BOEMRE.GOV website will be moved to the new sites.
Field Definitions for OGOR FOR 2008
Click on hyperlinked Column Aliases to show possible values.
The Start Position Column is used for fixed dumps only. Click on the column alias for a valid list of values or codes associated with the element selected.
Start
Position |
Item
Length |
Column
Alias |
Definition |
| 1 |
7 |
Lease Number |
LEASE_NUMBER -Unknown |
| 8 |
6 |
Completion Name |
COMPLETION_NAME -Unknown |
| 14 |
6 |
Production Date |
PRODUCTION_DATE -Unknown |
| 20 |
2 |
Days On Prod |
DAYS_ON_PROD -Unknown |
| 22 |
1 |
Product Code |
PRODUCT_CODE -Unknown |
| 23 |
9 |
Monthly Oil Volume |
MON_O_PROD_VOL -Unknown |
| 32 |
9 |
Monthly Gas Volume |
MON_G_PROD_VOL -Unknown |
| 41 |
9 |
Monthly Water Volume |
MON_WTR_PROD_VOL -Unknown |
| 50 |
12 |
Api Well Number |
API_WELL_NUMBER -Unknown |
| 62 |
2 |
Well Status Code |
WELL_STAT_CD -Unknown |
| 64 |
8 |
Area/Block/Bottom Area/Bottom Block |
This field is derived from the expression...
NVL(WCV.AREA_CODE||WCV.BLOCK_NUMBER,BV.BOTM_AREA_CODE||BV.BOTM_BLOCK_NUM)
...and consists of these database columns:
AREA_CODE - The designated abbreviation assigned to Outer Continental Shelf (OCS) geographical units for identification purposes and for use on maps and in data bases.
BLOCK_NUMBER - Identifies a subdivision of an Official Protraction Diagram.
BOTM_AREA_CODE - The designated abbreviation assigned to Outer Continental Shelf (OCS) geographical units for identification purposes and for use on maps and in data bases as applied to the bottomhole location of a well.
BOTM_BLOCK_NUM - Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
|
| 72 |
5 |
Operator Num |
OPERATOR_NUM -Unknown |
| 77 |
45 |
Operator Name |
SORT_NAME -The name of the business entity doing business on the OCS used for sorting purposes. For example, The Louisana Land and Exploration Company would have a short name of LOUISIANA LAND AND EXPLORATION COMPANY, THE and therefore sort with business entities whose name begins with "L." |
| 122 |
8 |
Field Name Code |
FIELD_NAME_CODE -Unknown |
| 130 |
9 |
Injection Volume |
INJECTION_VOLUME -Unknown |
| 139 |
3 |
Production Interval Code |
PROD_INTERVAL_CD -Unknown |
| 142 |
8 |
First Production Date |
FIRST_PROD_DATE -The date a lease is first placed on continuous extraction of solid minerals or flow of fluid minerals that is primarily for sales rather than for testing. |
| 150 |
10 |
Unit Agreement Number |
UNIT_AGT_NUMBER -Unknown |
| 160 |
2 |
Unit Aloc Suffix |
UNIT_ALOC_SUFFIX -Unknown |
|
