Borehole_Summary_DOV

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

Name	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		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_CRS	CODE	NA	READ ONLY: The code for the original projected or geographic coordinate system.	No	VARCHAR2(64)
Original_Coord_System_Id	Coordinate_System		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)
Position_Id	Position		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
Shape	GEOMETRY	NA	Binary spatial representation of the position.	No	ST_GEOMETRY
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
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	Well		READ ONLY: Unique identifier for the well.	No	NUMBER(38)
Working_Coord_System_Id	Coordinate_System		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		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)

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Position	Position	READ ONLY: Unique identifier for the Position.	Control	No
Original_Coord_System	Coordinate_System	Unique identifier for the coordinate system of the incoming (i.e., original) Position data, including cartographic, elevation and azimuth references.	Cascade	No
Well	Well	READ ONLY: Unique identifier for the well.	Cascade	No
Working_Coord_System	Coordinate_System	READ ONLY: Unique identifier for the working coordinate system.	Cascade	No

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW 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(+)
   and bh.version = '1'
   and bh.existence_kind = 'Actual'

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

Borehole_Summary_DOV

Copyright © 2018 Schlumberger. All rights reserved.