Platform Structures Online Query Field Definitions

Data Center >> Platform >> Platform Structures Online Query >>
Platform Structures Online Query Field Definitions


Field Name
Data Type
Field Length
Definition
AREA_CODE VARCHAR26The designated abbreviation assigned to Outer Continental Shelf (OCS) geographical units for identification purposes and for use on maps and in data bases.
BLOCK_NUMBER VARCHAR218Identifies a subdivision of an Official Protraction Diagram.
FIELD_NAME_CODE VARCHAR224Name of the field in which the well is located.
STRUCTURE_NAME VARCHAR245The name of the structure assigned by the owner.
STRUCTURE_NUMBER NUMBER22A unique number assigned to a specific structure within a complex.
STRUC_TYPE_CODE VARCHAR215An indicator of the type of structure.
BUS_ASC_NAME VARCHAR2300The name of a **business associate**.
COMPLEX_ID_NUM NUMBER22The unique identifier assigned to a single man-made structure or a group of structures connected by a walkway.
MAJ_STRUC_FLAG VARCHAR23An indicator of whether a platform contains at least 6 completions or contains more than 2 pieces of production equipment.
INSTALL_DATE DATE7The date that an platform, pipeline, or piece of safety equipment (eqmt) was installed on the Outer Continental Shelf (OCS).
REMOVAL_DATE DATE7The date a structure, pipeline, or piece of safety equipment was removed from the Outer Continental Shelf (OCS).
DISTRICT_CODE NUMBER22An indicator assigned to a sub-office of an Outer Continental Shelf (OCS) regional office which has delegated authority for field operations activities including: permitting wells, inspections, drilling, and production operations.
HELIPORT_FLAG VARCHAR23An indicator of whether a heliport is present.
LEASE_NUMBER VARCHAR221 The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located.
WATER_DEPTH NUMBER22The depth of the water at a well/platform location from the water level to the mud line.
LATITUDE NUMBER22The angular distance north or south of the equator measured in degrees along a meridian. Maximum length, and decimal length in the business table can be either 12, 8 for all other components or 13, 9 for Lease and Sale components respectively.
LONGITUDE NUMBER22The angular distance on the earth, east or west of the prime meridian at Greenwich, England, to the point on the earth's surface for which the position is being determined. Maximum length, and decimal length in the business table can be either 13, 8 for all other components or 14, 9 for Lease and Sale components respectively.
NAD_YEAR_CD VARCHAR26The indicator of the North American Datum the data was produced under.
PROJ_CODE VARCHAR29An indicator of the projection code used to generate the x and y coordinates.
PTFRM_X_LOCATION NUMBER22The X coordinate used to describe the surface location.
PTFRM_Y_LOCATION NUMBER22The Y coordinate used to describe the surface location.
SURF_N_S_DIST NUMBER22North/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.
SURF_N_S_CODE VARCHAR23North/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.
SURF_E_W_DIST NUMBER22East_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.
SURF_E_W_CODE VARCHAR23East/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.
ATTENDED_8_HR_FL VARCHAR23An indicator of whether a location is manned 8 hours per day.
MANNED_24_HR_FL VARCHAR23An indicator of whether a location has personnel on board 24 hours per day.
STE_CLRNCE_DATE DATE7The date the platform site was reported cleared of excess steel and trash.

Return to the Platform Structures Online Query