Data Center

Data Center >>
Field Definitions for PLANSITESVIEW

Field Definitions for PLANSITESVIEW

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	1	Plan Ctrl Cd	PLAN_CTRL_CD -An indicator of the status of the plan application.
2	7	Plan Ctrl Num	PLAN_CTRL_NUM -A number identifying the plan being submitted. This number is assigned by the Plans Unit.
9	9	Plan Site Type	PLAN_SITE_TYPE -Identifies the site as either a well or a structure site.
18	8	Plan Site Name	PLAN_SITE_NAME -Name of Plan Site
26	18	Site Cancel Dt	SITE_CANCEL_DT -The date approval to use a structure or well site designated in a plan is cancelled.
44	1	Plan Fnl Actn Cd	PLAN_FNL_ACTN_CD -Indicates the final action was taken on a plan submittal.
45	18	Plan Fnl Actn Dt	PLAN_FNL_ACTN_DT -Date that final action was taken on a plan submittal.
63	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.
69	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.
70	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.
76	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.
77	2	Surf Area Code	SURF_AREA_CODE -The indicator used to identify an area name.
79	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.
85	7	Surf Prot Num	SURF_PROT_NUM -Unknown
92	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.
99	3	Surf Proj Zone	SURF_PROJ_ZONE -Indicates the map projection system zone code for the surface X, Y coordinate location of the proposed well descibed in an Application for Permit to Drill (APD).
102	19	Surf X Coord Loc	SURF_X_COORD_LOC -X coordinate for a surface location (east-west measurement).
121	19	Surf Y Coord Loc	SURF_Y_COORD_LOC -Y coordinate for a surface location (north-south measurement).
140	14	Surf Latitude	SURF_LATITUDE -The latitude value of a location in the borehole. A positive value denotes north. Angle subtended with equatorial plane by a perpendicular from a point on the surface of a spheriod.
154	16	Surf Longitude	SURF_LONGITUDE -The longitude value of a location in a borehole. A positive value denotes east. Angle measured about the spheroid axis from a local prime meridian to the meridian through the point.
170	7	Botm Lease Num	BOTM_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well.
177	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.
179	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.
185	6	Water Depth	WATER_DEPTH -The depth of the water at a well/platform location from the water level to the mud line.
191	4	Plan Type Code	PLAN_TYPE_CODE -Indicates the type of plan.
195	18	Plan Sub Recv Dt	PLAN_SUB_RECV_DT -Date the plan submittal was received.