Data Center

Data Center >>
Field Definitions for BOREHOLE API CHANGE ASCII FORMAT

Field Definitions for BOREHOLE API CHANGE ASCII FORMAT

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