WellBore (OpenSpirit v2.9.0 Build 27

Intro

Overview

Model

Table

OpenSpirit v2.9.0 Build 27 - Generic Model

SUMMARY: INHERITED | COLUMNS

DETAIL: COLUMNS

EpiWell_WellBore

Derived From:: EpEntity_Entity

Capabilties:: read

The WellBore table provides descriptive information about a wellbore and the geometry information of the wellbore path. WellBore contains logs, picks, and well velocities.

Column Summary

Type Name and Description

Stringro

KeyString

Unique identifier for each table entry.

String
db

AzimuthNorthType

The azimuth north reference type of the survey.

StringSeq
db

BoreAliases

Collection of various identifiers by which this wellbore is known.

StringSeq
db

BoreAliasTypes

Collection of various types of identifiers by which this wellbore is known.

String
db

BoreStatus

The operational state of the wellbore.

Point
db

BottomLocation

The bottom location of the well in the specified coordinate system.

String
db

CalcMethod

Method used to compute the wellpath geometry.

String
db

Comment

Contains any relevant user comments about the bore.

String
db

CompletionDate

The date the activities that created the well completed.

String
db

DefaultWellVelocity

The well velocity used by default to compute the bore's path.

String
ro db

DefaultWellVelocityName

The name of the well velocity used by default to compute the bore's path.

Float
db

Elevation

Distance from the regional vertical datum (positive upward).

String
db

ElevationDatum

The datum from which depth measurements are taken.

String
ro db

ElevationUnit

Elevation unit.

String
db

FlowDirection

Indicates the flowing mode of the wellbore.

String
db

FluidType

Type of fluid flowing into or out of the wellbore.

String
db

FormationAtTD

The name of the formation encountered at total depth.

String
ro req db key

Identifier

Primary wellbore identifier assigned to a well by the API, ERCB, or any government agency.

String
db

IdentifierType

The type of identifier provided for the wellbore.

StringSeq
ro db

LoggingPasses

The logging passes derived from this bore.

StringSeq
ro db

LogTraces

The log traces derived from this bore.

PointSeq
ro db

Path

The X, Y, and Z coordinates of the well path.

String
ro db

PathAngleUnit

The unit of the angle values of the well path.

FloatSeq
db

PathAzimuth

The well path azimuth values.

String
ro db

PathDepthUnit

Path unit.

FloatSeq
db

PathDip

The well path dip values.

FloatSeq
db

PathMD

The measured depth values of the well path positive downward from the well datum (ElevationDatum).

String
ro db

PathOffsetUnit

The unit for the X and Y offsets.

String
ro db

PathTimeUnit

The unit of the two way time values of the well path.

FloatSeq
db

PathTVD

The true vertical depth values of the well path positive downward from the well datum (ElevationDatum).

FloatSeq
db

PathTWT

The two way time values of the well path.

FloatSeq
db

PathXOffset

The X offset values of the well path.

FloatSeq
db

PathYOffset

The Y offset values of the well path.

StringSeq
ro db

Picks

The picks interpreted from the bore's data.

Float
db

PlugBackTotalDepth

The distance measured along the well path from the elevationDatum to the deepest reachable point of the well bore.

String
ro db

PlugBackTotalDepthUnit

PlugBackTotalDepth unit.

String
db

ShowType

Type of hydrocarbon show from the wellbore.

String
db

SpudDate

Date when drilling bit penetrates surface utilizing a drilling rig capable of drilling the well to the authorized depth.

Float
db

TotalDepth

The deepest depth drilled in this wellbore from elevationDatum to bottom hole.

String
db

TotalDepthType

TotalDepth type (eg.

String
ro db

TotalDepthUnit

TotalDepth unit.

String
ro req db key

Well

Data key string representing the well that contains this wellbore.

StringSeq
ro db

WellVelocities

The acoustic velocity functions for this bore.

Columns inherited from EpEntity_Entity

LastModifiedDate, Name, Project, ProjectName, StoreInstallationName, StoreType

Column Detail

KeyString

`Data Type:`	String
`Read only:`	true

Unique identifier for each table entry.

TotalDepth

`Data Type:`	Float
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

The deepest depth drilled in this wellbore from elevationDatum to bottom hole.

Comment

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Contains any relevant user comments about the bore.

LoggingPasses

`Data Type:`	StringSeq
`Content Type:`	KeySeq
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Referenced Table:`	EpiWell_LoggingPass

The logging passes derived from this bore.

Elevation

`Data Type:`	Float
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

Distance from the regional vertical datum (positive upward).

PathTVD

`Data Type:`	FloatSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

The true vertical depth values of the well path positive downward from the well datum (ElevationDatum). When inserting/updating a well path, the PathXOffset, PathYOffset, PathMD, PathDip, PathAzimuth, and PathTVD or PathTWT columns should be supplied.

PathMD

`Data Type:`	FloatSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

The measured depth values of the well path positive downward from the well datum (ElevationDatum). When inserting/updating a well path, the PathXOffset, PathYOffset, PathMD, PathDip, PathAzimuth, and PathTVD or PathTWT columns should be supplied.

PathOffsetUnit

`Data Type:`	String
`Content Type:`	UnitAcronym
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	HorizontalDistance

The unit for the X and Y offsets.

TotalDepthType

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Permitted Values:`	TOTAL_DEPTH \| DRILLERS_TOTAL_DEPTH \| LOGGERS_TOTAL_DEPTH \| UNKNOWN_TOTAL_DEPTH_REFERENCE

TotalDepth type (eg. drillers total depth, loggers total depth).

PlugBackTotalDepthUnit

`Data Type:`	String
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

PlugBackTotalDepth unit.

ShowType

`Data Type:`	String
`Content Type:`	RVString
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`RVS Set:`	GenericFluidComponent

Type of hydrocarbon show from the wellbore.

CalcMethod

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Permitted Values:`	RADIUS_OF_CURVATURE \| MINIMUM_CURVATURE \| BALANCED_TANGENTIAL \| AVERAGE_ANGLE \| TANGENTIAL \| UNKNOWN_CALCULATION_METHOD

Method used to compute the wellpath geometry.

PathTimeUnit

`Data Type:`	String
`Content Type:`	UnitAcronym
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	Time

The unit of the two way time values of the well path.

PlugBackTotalDepth

`Data Type:`	Float
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

The distance measured along the well path from the elevationDatum to the deepest reachable point of the well bore. If the well has been plugged back, it is the point to which the well is plugged back.

FormationAtTD

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The name of the formation encountered at total depth.

ElevationDatum

`Data Type:`	String
`Content Type:`	RVString
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`RVS Set:`	WellDepthDatum

The datum from which depth measurements are taken.

BoreStatus

`Data Type:`	String
`Content Type:`	RVString
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`RVS Set:`	WellboreStatus

The operational state of the wellbore.

LogTraces

`Data Type:`	StringSeq
`Content Type:`	KeySeq
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Referenced Table:`	EpiWell_WellLogTrace

The log traces derived from this bore.

PathAngleUnit

`Data Type:`	String
`Content Type:`	UnitAcronym
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	Angle

The unit of the angle values of the well path.

FlowDirection

`Data Type:`	String
`Content Type:`	RVString
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`RVS Set:`	FlowDirection

Indicates the flowing mode of the wellbore.

PathTWT

`Data Type:`	FloatSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	Time

The two way time values of the well path. When inserting/updating a well path, the PathXOffset, PathYOffset, PathMD, PathDip, PathAzimuth, and PathTVD or PathTWT columns should be supplied.

Identifier

`Data Type:`	String
`Read only:`	true
`Required for Insert:`	true
`Stored in db:`	true
`Part of natural key:`	true

Primary wellbore identifier assigned to a well by the API, ERCB, or any government agency.

BoreAliasTypes

`Data Type:`	StringSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Collection of various types of identifiers by which this wellbore is known.

PathYOffset

`Data Type:`	FloatSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	HorizontalDistance

The Y offset values of the well path. This is the Y coordinate offset from the well surface location. The Y offset values are always returned in the project's map display coordinate system. When inserting/updating a well path, the PathXOffset, PathYOffset, PathMD, PathDip, PathAzimuth, and PathTVD or PathTWT columns should be supplied.

PathXOffset

`Data Type:`	FloatSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	HorizontalDistance

The X offset values of the well path. This is the X coordinate offset from the well surface location. The X offset values are always returned in the project's map display coordinate system. When inserting/updating a well path, the PathXOffset, PathYOffset, PathMD, PathDip, PathAzimuth, and PathTVD or PathTWT columns should be supplied.

PathDip

`Data Type:`	FloatSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	Angle

The well path dip values. When inserting/updating a well path, the PathXOffset, PathYOffset, PathMD, PathDip, PathAzimuth, and PathTVD or PathTWT columns should be supplied.

Path

`Data Type:`	PointSeq
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The X, Y, and Z coordinates of the well path. The Z is TVDSS (negative down).

FluidType

`Data Type:`	String
`Content Type:`	RVString
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`RVS Set:`	GenericFluidComponent

Type of fluid flowing into or out of the wellbore.

IdentifierType

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The type of identifier provided for the wellbore.

PathDepthUnit

`Data Type:`	String
`Content Type:`	UnitAcronym
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

Path unit.

BottomLocation

`Data Type:`	Point
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The bottom location of the well in the specified coordinate system.

BoreAliases

`Data Type:`	StringSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Collection of various identifiers by which this wellbore is known. The identifiers are represented by an array of name and value pairs where the name is well identifier type and the value is the identifier value. Examples of identifier types are API and Common Name.

SpudDate

`Data Type:`	String
`Content Type:`	Date
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

Date when drilling bit penetrates surface utilizing a drilling rig capable of drilling the well to the authorized depth.

DefaultWellVelocityName

`Data Type:`	String
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The name of the well velocity used by default to compute the bore's path.

AzimuthNorthType

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Permitted Values:`	TRUE \| GRID \| MAGNETIC \| ASTRONOMICAL

The azimuth north reference type of the survey. When inserting/updating AzimuthNorthType, PathAzimuth should be inserted/updated also.

Picks

`Data Type:`	StringSeq
`Content Type:`	KeySeq
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Referenced Table:`	EpiWell_WellPick

The picks interpreted from the bore's data.

Well

`Data Type:`	String
`Content Type:`	Key
`Read only:`	true
`Required for Insert:`	true
`Stored in db:`	true
`Part of natural key:`	true
`Referenced Table:`	EpiWell_Well

Data key string representing the well that contains this wellbore.

DefaultWellVelocity

`Data Type:`	String
`Content Type:`	Key
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Referenced Table:`	EpiWell_WellVelocity

The well velocity used by default to compute the bore's path.

CompletionDate

`Data Type:`	String
`Content Type:`	Date
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false

The date the activities that created the well completed.

WellVelocities

`Data Type:`	StringSeq
`Content Type:`	KeySeq
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Referenced Table:`	EpiWell_WellVelocity

The acoustic velocity functions for this bore.

PathAzimuth

`Data Type:`	FloatSeq
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	Angle

The well path azimuth values. The azimuth values are always returned in the project's map display coordinate system. When inserting/updating a well path, the PathXOffset, PathYOffset, PathMD, PathDip, PathAzimuth, and PathTVD or PathTWT columns should be supplied. When inserting/updating PathAzimuth, AzimuthNorthType should be inserted/updated also.

TotalDepthUnit

`Data Type:`	String
`Content Type:`	UnitAcronym
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance

TotalDepth unit.

ElevationUnit

`Data Type:`	String
`Content Type:`	UnitAcronym
`Read only:`	true
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Unit Measure:`	VerticalDistance