Field Definitions for BOREHOLE API CHANGES (ACCESS)

Field Definitions for BOREHOLE API CHANGES (ACCESS)

Click on hyperlinked Column Aliases to show possible values.

Column
Alias
Definition
CurrentAPI 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.
BhActvTypeCd BH_ACTV_TYPE_CD -Indicates the type of borehole activity that causes a change to the Borehole record in TIMS.
PreviousAPI 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.
ActivityDate ACTIVITY_DATE -The date that a well activity takes place.
WellName 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.
WellNameSuffix WELL_NAME_SUFFIX -An extension to the well name that indicates the number of times that a new wellbore has been drilled.
SurfLeaseNum 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.
SurfAreaCode SURF_AREA_CODE -The indicator used to identify an area name.
SurfBlockNum SURF_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well.
WellSpudDate WELL_SPUD_DATE -The date that the drilling rig first begins boring into the earth's surface.
BotmLeaseNum BOTM_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well.
BotmAreaCode 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.
BotmBlockNum BOTM_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
BhTotalMd This field is derived from the expression... decode(sign(add_months(total_depth_date,24) + 1 - sysdate),-1, to_char(BV.bh_total_md),decode(l.lease_expir_date,null, '*****',to_char(BV.bh_total_md))) ...and consists of these database columns:
total_depth_date - The date drilling on a well reached the final total depth.
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_expir_date - The date a lease expires, is relinquished or terminated.
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.