Column
Alias |
Definition |
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. |
WellTypeCode |
WELL_TYPE_CODE -Indicates the final classification of a borehole denoting the purpose of the drilling. |
Well |
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. |
Company |
BUS_ASC_NAME -The name of a **business associate**. |
StatusDate |
BOREHOLE_STAT_DT -The date the borehole status becomes effective. |
StatusCode |
BOREHOLE_STAT_CD -Indicates the conditions relating to a borehole. |
Field |
BOTM_FLD_NAME_CD -Name of the field in which the bottom of the well is located. |
SurfaceArea |
SURF_AREA_CODE -The indicator used to identify an area name. |
SurfaceBlock |
SURF_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well. |
SurfaceLease |
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. |
BottomArea |
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. |
BottomBlock |
BOTM_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well. |
BottomLease |
BOTM_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well. |
WellSpudDate |
WELL_SPUD_DATE -The date that the drilling rig first begins boring into the earth's surface. |
TotalDepthDate |
TOTAL_DEPTH_DATE -The date drilling on a well reached the final total depth. |
BhTotalMd |
This field is derived from the expression...
decode(sign(add_months(total_depth_date,24) + 1 - sysdate),-1, to_char(bh_total_md),decode(l.lease_expir_date,null, '*****',to_char(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.
|
BlockLookup |
BOTM_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well. |
HWDCScrubDate |
HWDC_SCRUB_DT -Date, on which the borehole data is updated with the historical well data clean up process modified data. |
