WellPick (OpenSpirit v2.9.0 Build 27

Intro

Overview

Model

Table

OpenSpirit v2.9.0 Build 27 - Generic Model

SUMMARY: INHERITED | COLUMNS

DETAIL: COLUMNS

EpiWell_WellPick

Derived From:: EpEntity_Entity

Derivatives:: EpiWell_FaultPick

Capabilties:: read

The WellPick table defines a pick, which is an identified feature found in a wellbore.

Column Summary

Type Name and Description

Stringro

KeyString

Unique identifier for each table entry.

String
ro req db key

Bore

Data key string representing the bore for which the pick was made.

String
db

Comment

Contains any relevant user comments about the pick.

String
db

ConfFactor

The level of confidence in the pick.

Float
db

DipAngle

The angle the stratigraphic formation makes with horizontal at the pick's location.

String
ro db

DipAngleUnit

DipAngle unit.

Float
db

DipAzimuth

The angle indicating the direction in which the surface is dipping.

String
ro db

DipAzimuthUnit

DipAzimuth unit.

String
db

Interpreter

The name of the interpreter that created the pick.

Point
ro db

Location

The X, Y, Z coordinate of the pick.

Long
db

Occurrence

Observation number assigned to make the pick unique if there are multiple cuts for the same surface.

ULong
db

PickColor

The rgb representation of the pick color.

String
db

PickColorName

The pick color.

String
db

PickDate

The creation date of the pick.

String
db key

PickName

The name of the pick.

String
db

PickSource

The source of the pick.

String
db

PickType

The type of the pick.

String
ro db

PickValueDepthUnit

The pick value's depth unit.

Float
req db

PickValueMD

The measured depth value of the pick.

String
ro db

PickValueMDUnit

The pick's measured depth unit.

String
ro db

PickValueTimeUnit

The pick value's time unit.

Float
db

PickValueTVD

The true vertical depth value of the pick.

Float
db

PickValueTVDSS

The subsea vertical depth value of the pick.

Float
db

PickValueTWT

The two way time value of the pick.

String
db

Qualifier

The qualifier of the pick.

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.

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 pick.

PickSource

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

The source of the pick.

Location

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

The X, Y, Z coordinate of the pick.

ConfFactor

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

The level of confidence in the pick.

PickValueTVD

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

The true vertical depth value of the pick.

DipAngleUnit

`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

DipAngle unit.

PickName

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

The name of the pick.

PickValueMDUnit

`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

The pick's measured depth unit.

DipAngle

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

The angle the stratigraphic formation makes with horizontal at the pick's location.

PickValueMD

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

The measured depth value of the pick.

PickValueTWT

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

The two way time value of the pick.

PickValueTimeUnit

`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 pick value's time unit.

PickType

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

The type of the pick. Can be Strat_Marker, Fault_Marker, or Fluid_Marker.

Interpreter

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

The name of the interpreter that created the pick.

PickValueDepthUnit

`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

The pick value's depth unit.

PickValueTVDSS

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

The subsea vertical depth value of the pick.

Occurrence

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

Observation number assigned to make the pick unique if there are multiple cuts for the same surface.

PickDate

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

The creation date of the pick.

PickColorName

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

The pick color.

Qualifier

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

The qualifier of the pick.

DipAzimuthUnit

`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

DipAzimuth unit.

PickColor

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

The rgb representation of the pick color.

DipAzimuth

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

The angle indicating the direction in which the surface is dipping.

Bore

`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_WellBore