|
API_WELL_NUMBER
| VARCHAR2 | 36 | 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_ACTV_TYPE_CD
| VARCHAR2 | 9 | Indicates the type of borehole activity that causes a change to the Borehole record in TIMS. |
|
PREV_API_NUMBER
| VARCHAR2 | 36 | 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. |
|
ACTIVITY_DATE
| DATE | 7 | The date that a well activity takes place. |
|
WELL_NAME
| VARCHAR2 | 15 | The name assigned to the well. It may be a special name or the name of the property to which the well belongs. |
|
WELL_NAME_SUFFIX
| VARCHAR2 | 16 | An extension to the well name that indicates the number of times that a new wellbore has been drilled. |
|
SURF_LEASE_NUMBER
| VARCHAR2 | 21 | The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located. |
|
SURF_AREA_CODE
| VARCHAR2 | 6 | The indicator used to identify an area name. |
|
SURF_BLOCK_NUMBER
| VARCHAR2 | 18 | Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well. |
|
WELL_SPUD_DATE
| DATE | 7 | The date that the drilling rig first begins boring into the earth's surface. |
|
BOTM_LEASE_NUMBER
| VARCHAR2 | 21 | The number assigned to the lease that contains the bottom location of a well. |
|
BOTM_AREA_CODE
| VARCHAR2 | 6 | 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_NUMBER
| VARCHAR2 | 18 | Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well. |
|
BH_TOTAL_MD
| VARCHAR2 | 120 | The actual distance measured along the axis of the borehole from the rig kelly bushing to the depth of maximum penetration of the well. |
