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 |
8 |
Botm Fld Name Cd |
BOTM_FLD_NAME_CD -Name of the field in which the bottom of the well is located. |
| 9 |
5 |
Mms Company Num |
MMS_COMPANY_NUM -The number assigned by the Minerals Management Service to a business entity, individual, or agency with whom MMS does business or exchanges information. |
| 14 |
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. |
| 20 |
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. |
| 27 |
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. |
| 33 |
7 |
Botm Lease Num |
BOTM_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well. |
| 40 |
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. |
| 45 |
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. |
| 53 |
12 |
Api Well Number |
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. |
| 65 |
10 |
Total Depth Date |
TOTAL_DEPTH_DATE -The date drilling on a well reached the final total depth. |
| 75 |
1 |
Botm E W Code |
BOTM_E_W_CODE -Indicates whether the borehole bottom location is measured from the east (E) or west (W) block boundary. |
| 76 |
6 |
Botm E W Dist |
BOTM_E_W_DIST -The distance from the location of the borehole bottom to either the east or west block boundary. |
| 82 |
1 |
Botm N S Code |
BOTM_N_S_CODE -Indicates whether the borehole bottom location is measured from the north (N) or south (S) block boundary. |
| 83 |
6 |
Botm N S Dist |
BOTM_N_S_DIST -The distance from the borehole bottom location to either the north or south block boundary. |
| 89 |
1 |
Surf E W Code |
SURF_E_W_CODE -East/West descriptor that indicates the direction of a measurement from an identifiable line./Indicates whether the surface borehole location is measured from either the east (E) or west (W) block boundary. |
| 90 |
6 |
Surf E W Dist |
SURF_E_W_DIST -East_West footage or distance that represents the length of a measurement from an identifiable line./The distance from the borehole surface location to either the east or west block boundary. |
| 96 |
1 |
Surf N S Code |
SURF_N_S_CODE -North/South descriptor that indicates the direction of a measurement from an identifiable line. /Indicates whether the surface borehole location is measured from the north (N) or south (S) block boundary. |
| 97 |
6 |
Surf N S Dist |
SURF_N_S_DIST -North/South footage or distance that represents the length of a measurement from an identifiable line. /The distance from the borehole surface location to either the north or south block boundary. |
| 103 |
18 |
Hwdc Scrub Dt |
HWDC_SCRUB_DT -Date, on which the borehole data is updated with the historical well data clean up process modified data. |
