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 |
