Data Center

Data Center >>
Field Definitions for OGORA

Field Definitions for OGORA

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