PSR_Borehole_Summary_DOV


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name PSR_Borehole_Summary_DOV
Entity Type ObjectView
Description Data Object View. A borehole provides a conduit for operations within a well. The Borehole Summary DOV contains basic information about a borehole such as its name, shape, various depth measurements, spud and completion dates, parent well id, position id, elevation reference, and working coordinate system.
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
BASE_X double No_Unit
Longitude of the point as stored in the internal binary spatial representation. No
NUMBER
BASE_Y double No_Unit
Latitude of the point as stored in the internal binary spatial representation. No
NUMBER
BOREHOLE_NAME ENTITY_NAME NA
The name given to any object or data item, e.g. Name of Well, Name of Field, etc. No
VARCHAR2(255)
BOREHOLE_SHAPE STRING255 NA
Defines a valid instance of a type of wellbore trajectory shape. Common types are: build and hold, S shaped, vertical, horizontal. In the early stages of well planning, this information, along with some key parameters, are used to generate an approximate well profile - without the requirement for detailed trajectory planning. This information is also of value for wells that have already been drilled because it is difficult to categorize wells by their detailed trajectory. No
VARCHAR2(255)
CURRENT_STATUS CODE NA
The Current status of the borehole No
VARCHAR2(64)
DRILLER_PBTD double Length
m
Measured Depth of the current bottom of the borehole as recorded by the drilling contractor. It is the physical bottom of the borehole which is plugged either by a cement or by a mechanical plug. The P.B.T.D. can change in time. It is smaller than the Drilled Total Depth No
NUMBER
DRILLER_TD_MD double Length
m
The total depth of the well borehole as reported by the drilling contractor. No
NUMBER
FORMATION_AT_TD STRING255 NA
The formation at the total depth of the borehole. This is a denormalization of the association between Borehole and Geologic_Feature No
VARCHAR2(255)
ID ID No_Unit
Unique identifier for this entity. Yes
NUMBER(38)
INITIAL_COMPLETION_DATE DATE NA
The date of the initial completion of this borehole. This is a denormalization of the information in the Generic_Borehole_Activity record for the initial completion activity. No
DATE
INSERT_DATE DATE NA
Date the entity was created in the repository No
DATE
INSERT_USER STRING64 NA
The name of the user responsible for the creation of this entity in the repository. No
VARCHAR2(64)
LOGGER_PBTD double Length
m
Measured Depth of the current bottom of the borehole as recorded by the logging contractor. It is the physical bottom of the borehole which is plugged either by a cement or by a mechanical plug. The P.B.T.D. can change in time. It is smaller than the Drilled Total Depth No
NUMBER
LOGGER_TD_MD double Length
m
The total depth of the well borehole as reported by the logging contractor. No
NUMBER
ORIGINAL_BASE_X double No_Unit
X coordinate, or longitude, of the point in the cartographic system of the input dataset. No
NUMBER
ORIGINAL_BASE_Y double No_Unit
Y coordinate, or latitude, of the point in the cartographic system of the input dataset. No
NUMBER
ORIGINAL_COORD_SYSTEM_ID ID NA
Unique identifier for the coordinate system of the incoming (i.e., original) Position data, including cartographic, elevation and azimuth references. No
NUMBER(38)
ORIGINAL_COORD_SYSTEM_NAME ENTITY_NAME NA
READ ONLY: The name of the Original Coordinate System. No
VARCHAR2(255)
ORIGINAL_CRS CODE NA
READ ONLY: The code for the original projected or geographic coordinate system. No
VARCHAR2(64)
POSITION_ID ID NA
READ ONLY: Unique identifier for the Position. No
NUMBER(38)
PRIMARY_SOURCE STRING64 NA
Name of the Business_Associate responsible for this entity"s E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User. No
VARCHAR2(64)
REMARKS REMARKS_STR NA
Any type of remarks added to an entity instance. No
VARCHAR2(999)
RIG_RELEASE_DATE DATE NA
The date that the rig was released after drilling this borehole No
DATE
SPUD_DATE DATE NA
The date and time when activities to drill the borehole begin to create a hole in the earth. For a sidetrack, this is the date kickoff operations began. No
DATE
Shape GEOMETRY NA
Binary spatial representation of the position. No
ST_GEOMETRY
UBHI WELL_IDENTIFIER NA
The Unique Identifier assigned to a borehole Yes
VARCHAR2(64)
UWI WELL_IDENTIFIER NA
Unique Well Identifier Yes
VARCHAR2(64)
WELL_ID ID NA
READ ONLY: Unique identifier for the well. No
NUMBER(38)
WORKING_COORD_SYSTEM_ID ID NA
READ ONLY: Unique identifier for the working coordinate system. No
NUMBER(38)
WORKING_ELEVATION double Length
m
Vertical offset of the current Coordinate System and the From_Coordinate_System. Z offsets are measured as a depth system with values increasing in a downward direction. If the current coordinate system is below the original coordinate system, the offset is positive. If the current coordinate system is above the original coordinate system, the offset is negative. Z_Offset is one of the "six degrees of freedom" for motion, or change in position, and is often referred to as "heave". This attribute is only used with "Local" coordinate systems. No
NUMBER
WORKING_ELEVATION_REF CODE NA
Reference table for all elevation reference types, e.g., KB, DF, etc. The vertical reference provides the zero measurement point for the vertical axis of the coordinate system. For instance a measured depth coordinate system will have a depth equal to zero at it"s KB, the vertical reference. No
VARCHAR2(64)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW PSR_Borehole_Summary_DOV(ID, UBHI, BOREHOLE_NAME, UWI, PRIMARY_SOURCE, SHAPE, BASE_X, BASE_Y, ORIGINAL_COORD_SYSTEM_ID, ORIGINAL_COORD_SYSTEM_NAME, ORIGINAL_CRS, ORIGINAL_BASE_X, ORIGINAL_BASE_Y, WORKING_ELEVATION, WORKING_ELEVATION_REF, DRILLER_TD_MD, LOGGER_TD_MD, DRILLER_PBTD, LOGGER_PBTD, RIG_RELEASE_DATE, INITIAL_COMPLETION_DATE, FORMATION_AT_TD, CURRENT_STATUS, SPUD_DATE, BOREHOLE_SHAPE, REMARKS, INSERT_DATE, INSERT_USER, POSITION_ID, WORKING_COORD_SYSTEM_ID, WELL_ID) AS SELECT bh.ID ID, bh.ubhi ubhi, bh.NAME borehole_name, well.uwi uwi,
          bh.SOURCE primary_source, pos.shape shape,
          DECODE (sds_spatial.sde_enabled (),
                  1, NVL (pos.normal_longitude,
                          SDE.ST_X(pos.shape)
                         ),
                  pos.normal_longitude
                 ) base_x,
          DECODE (sds_spatial.sde_enabled (),
                  1, NVL (pos.normal_latitude,
                          
SDE.ST_Y(pos.shape)
                         ),
                  pos.normal_latitude
                 ) base_y,
          pos.original_coord_system_id original_coord_system_id,
          cs1.NAME original_coord_system_name, cs1.crs original_crs,
          pos.original_x_longitude original_base_x,
          pos.original_y_latitude original_base_y,
          cs.z_offset working_elevation,
          cs.vertical_reference working_elevation_ref,
          bh.driller_td_md driller_td_md, bh.logger_td_md logger_td_md,
          bh.driller_pbtd driller_pbtd, bh.logger_pbtd logger_pbtd,
          bh.final_rig_release_date rig_release_date,
          bh.initial_completion_date initial_completion_date,
          bh.formation_at_td formation_at_td,
          bh.current_status current_status, bh.spud_date spud_date,
          bh.borehole_shape borehole_shape, bh.remarks remarks,
          bh.insert_date insert_date, bh.insert_user insert_user,
          pos.ID position_id, cs.ID 
working_coord_system_id, well.ID well_id
     FROM borehole bh,
          well,
          POSITION pos,
          coordinate_system cs,
          coordinate_system cs1
    WHERE bh.well_id = well.ID
      AND bh.bottom_location_id = pos.ID(+)
      AND pos.original_coord_system_id = cs1.ID(+)
      AND bh.working_coord_system_id = cs.ID(+)
   


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.