|
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. |
|
BLOCK_NUMBER
| VARCHAR2 | 18 | Identifies a subdivision of an Official Protraction Diagram. |
|
FIELD_NAME_CODE
| VARCHAR2 | 24 | Name of the field in which the well is located. |
|
STRUCTURE_NAME
| VARCHAR2 | 45 | The name of the structure assigned by the owner. |
|
STRUCTURE_NUMBER
| NUMBER | 22 | A unique number assigned to a specific structure within a complex. |
|
STRUC_TYPE_CODE
| VARCHAR2 | 15 | An indicator of the type of structure. |
|
BUS_ASC_NAME
| VARCHAR2 | 300 | The name of a **business associate**. |
|
COMPLEX_ID_NUM
| NUMBER | 22 | The unique identifier assigned to a single man-made structure or a group of structures connected by a walkway. |
|
MAJ_STRUC_FLAG
| VARCHAR2 | 3 | An indicator of whether a platform contains at least 6 completions or contains more than 2 pieces of production equipment. |
|
INSTALL_DATE
| DATE | 7 | The date that an platform, pipeline, or piece of safety equipment (eqmt) was installed on the Outer Continental Shelf (OCS). |
|
REMOVAL_DATE
| DATE | 7 | The date a structure, pipeline, or piece of safety equipment was removed from the Outer Continental Shelf (OCS). |
|
DISTRICT_CODE
| NUMBER | 22 | An 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
| VARCHAR2 | 3 | An indicator of whether a heliport is present. |
|
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. |
|
WATER_DEPTH
| NUMBER | 22 | The depth of the water at a well/platform location from the water level to the mud line. |
|
LATITUDE
| NUMBER | 22 | The 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
| NUMBER | 22 | The 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
| VARCHAR2 | 6 | The indicator of the North American Datum the data was produced under. |
|
PROJ_CODE
| VARCHAR2 | 9 | An indicator of the projection code used to generate the x and y coordinates. |
|
PTFRM_X_LOCATION
| NUMBER | 22 | The X coordinate used to describe the surface location. |
|
PTFRM_Y_LOCATION
| NUMBER | 22 | The Y coordinate used to describe the surface location. |
|
SURF_N_S_DIST
| NUMBER | 22 | 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. |
|
SURF_N_S_CODE
| VARCHAR2 | 3 | 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. |
|
SURF_E_W_DIST
| NUMBER | 22 | 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. |
|
SURF_E_W_CODE
| VARCHAR2 | 3 | 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. |
|
ATTENDED_8_HR_FL
| VARCHAR2 | 3 | An indicator of whether a location is manned 8 hours per day. |
|
MANNED_24_HR_FL
| VARCHAR2 | 3 | An indicator of whether a location has personnel on board 24 hours per day. |
|
STE_CLRNCE_DATE
| DATE | 7 | The date the platform site was reported cleared of excess steel and trash. |
