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 |
12 |
Current API |
API_WELL_NUMBER - A unique well identification number consisting of (from left to right) a two digit state code (or pseudo for Offshore), a three digit county code (or pseudo for Offshore), a five digit unique well code, and if applicable, a two digit sidetrack code as defined in API Bulletin D12A. |
| 13 |
3 |
Bh Actv Type Cd |
BH_ACTV_TYPE_CD -Indicates the type of borehole activity that causes a change to the Borehole record in TIMS. |
| 16 |
12 |
Previous API |
PREV_API_NUMBER - A unique well identification number consisting of (from left to right) a two digit state code (or pseudo for Offshore), a three digit county code (or pseudo for Offshore), a five digit unique well code, and if applicable, a two digit sidetrack code as defined in API Bulletin D12A\as applied to the previous API well number for a well whose API well number is changed. |
| 28 |
18 |
Activity Date |
ACTIVITY_DATE -The date that a well activity takes place. |
| 46 |
5 |
Well Name |
WELL_NAME - The name assigned to the well. It may be a special name or the name of the property to which the well belongs. |
| 51 |
8 |
Well Name Suffix |
WELL_NAME_SUFFIX -An extension to the well name that indicates the number of times that a new wellbore has been drilled. |
| 59 |
7 |
Surf Lease Num |
SURF_LEASE_NUM - The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located. |
| 66 |
2 |
Surf Area Code |
SURF_AREA_CODE -The indicator used to identify an area name. |
| 68 |
6 |
Surf Block Num |
SURF_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well. |
| 74 |
18 |
Well Spud Date |
WELL_SPUD_DATE -The date that the drilling rig first begins boring into the earth's surface. |
| 92 |
7 |
Botm Lease Num |
BOTM_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well. |
| 99 |
2 |
Botm Area Code |
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. |
| 101 |
6 |
Botm Block Num |
BOTM_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well. |
| 107 |
40 |
Bh Total Md |
This field is derived from the expression...
decode(public_release_package.borehole_reached_total_depth(bv.api_well_number), 'Y', to_char(BV.bh_total_md), decode(public_release_package.lease_is_expired(l.lease_number), 'Y', to_char(BV.bh_total_md), '*****'))
...and consists of these database columns:
borehole_reached_total_depth - Unknown
api_well_number - A unique well identification number consisting of (from left to right) a two digit state code (or pseudo for Offshore), a three digit county code (or pseudo for Offshore), a five digit unique well code, and if applicable, a two digit sidetrack code as defined in API Bulletin D12A.
bh_total_md - The actual distance measured along the axis of the borehole from the rig kelly bushing to the depth of maximum penetration of the well.
lease_is_expired - Unknown
lease_number - The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located.
bh_total_md - The actual distance measured along the axis of the borehole from the rig kelly bushing to the depth of maximum penetration of the well.
|
