PSR_Borehole_Summary_DOV

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

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]

Name	Value Domain	Property / Storage Unit	Description	Required / 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]

PSR_Borehole_Summary_DOV

Copyright © 2018 Schlumberger. All rights reserved.