Trajectory (OpenSpirit v2.9.0 Build 27

Intro

Overview

Model

Table

OpenSpirit v2.9.0 Build 27 - Generic Model

SUMMARY: INHERITED | COLUMNS

DETAIL: COLUMNS

EpiDrilling_Trajectory

Derived From:: EpEntity_Entity

Capabilties:: read

A trajectory is a collection of points, which denote either a planned or a drilled wellbore path. There can be multiple trajectories associated with a single well bore path.

Column Summary

Type Name and Description

Stringro

KeyString

Unique identifier for each table entry.

String
db

Algorithm

The interpolation algorithm (e.

DoubleSeq
db

Azimuth

A sampled list of azimuth values.

String
db

AzimuthUnit

The acronym of the unit that the azimuths are returned in.

String
db

CalculationMethod

The calculation method used to perform the directional survey

String
ro req db

CreationDate

The date when the trajectory was created.

String
db

Creator

The name of the person that created the trajectory.

DoubleSeq
db

EastOffset

A sampled list of East (X) offset values.

String
db

EastOffsetUnit

The acronym of the unit that the EastOffset is returned in.

Double
db

EastRef

The East (X) reference location

String
db

EastRefUnit

The acronym of the unit that the EastRef is returned in.

String
db

EndDate

The date when the directional survey was ended

String
db

ExistanceStatus

A flag indicating if the trajectory is planned or drilled.

String
ro db key

Identifier

The unique identifier of the trajectory

DoubleSeq
db

Inclination

A sampled list of inclination values.

String
db

InclinationUnit

The acronym of the unit that the inclinations are returned in.

Boolean
db

IsDefinitive

A flag indicating if the trajectory is a definitive trajectory for the wellbore it is associated with.

Boolean
db

IsFinal

A flag indicating if the trajectory is a final or intermediate or preliminary trajectory for the wellbore it is associated with.

Boolean
db

IsLegal

A flag indicating if the trajectory is a legal trajectory.

String
ro db

KeyString

The trajectory's data key string

String
ro db

LastModifiedDate

The date the last modification was made to the trajectory.

DoubleSeq
db

Md

A sampled list of MD values.

String
db

MdUnit

The acronym of the unit that the MDs are returned in.

String
db

Modifier

The name of the person that last modified the trajectory.

String
db

Name

The name of the trajectory

DoubleSeq
db

NorthOffset

A sampled list of North (Y) offset values.

String
db

NorthOffsetUnit

The acronym of the unit that the NorthOffset is returned in.

Double
db

NorthRef

The North (Y) reference location.

String
db

NorthRefUnit

The acronym of the unit that the EastRef is returned in.

String
ro db

Project

The data key string of the project that the trajectory is contained in.

String
ro db

ProjectName

The name of the project that the trajectory is contained in.

String
db

StartDate

The date when the directional survey was started

String
ro db

StoreInstallationName

The name of the data store that the trajectory resides in.

String
ro db

StoreType

The type of data store that the trajectory resides in.

String
db

SurveyDataSource

The source of the directional survey

String
db

SurveyMethod

The survey method used to perform the directional survey

String
db

SurveyName

The name of the directional survey.

String
db

TieIn

The trajectory's data key string that this trajectory is tied-in to.

StringSeq
db

TrajectoryStations

The data key strings of the entire trajectory stations that are associated to this trajectory.

DoubleSeq
db

Tvd

A sampled list of TVD (Z) values.

String
db

TvdUnit

The acronym of the unit that the tvd is returned in.

String
ro req db key

WellBore

The data key string of the WellBore that the trajectory is associated with.

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.

NorthOffsetUnit

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

The acronym of the unit that the NorthOffset is returned in.

StoreType

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

The type of data store that the trajectory resides in.

SurveyMethod

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

The survey method used to perform the directional survey

Project

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

The data key string of the project that the trajectory is contained in.

NorthOffset

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

A sampled list of North (Y) offset values.

NorthRefUnit

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

The acronym of the unit that the EastRef is returned in.

StartDate

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

The date when the directional survey was started

IsLegal

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

A flag indicating if the trajectory is a legal trajectory.

NorthRef

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

The North (Y) reference location.

IsFinal

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

A flag indicating if the trajectory is a final or intermediate or preliminary trajectory for the wellbore it is associated with.

Identifier

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

The unique identifier of the trajectory

EndDate

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

The date when the directional survey was ended

SurveyName

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

The name of the directional survey.

SurveyDataSource

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

The source of the directional survey

MdUnit

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

The acronym of the unit that the MDs are returned in.

EastRefUnit

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

The acronym of the unit that the EastRef is returned in.

ExistanceStatus

`Data Type:`	String
`Read only:`	false
`Required for Insert:`	false
`Stored in db:`	true
`Part of natural key:`	false
`Permitted Values:`	Plan \| Actual \| Model

A flag indicating if the trajectory is planned or drilled. True means that the trajectory has been drilled.

Modifier

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

The name of the person that last modified the trajectory.

Md

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

A sampled list of MD values.

EastRef

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

The East (X) reference location

TieIn

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

The trajectory's data key string that this trajectory is tied-in to.

EastOffsetUnit

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

The acronym of the unit that the EastOffset is returned in.

KeyString

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

The trajectory's data key string

EastOffset

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

A sampled list of East (X) offset values.

AzimuthUnit

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

The acronym of the unit that the azimuths are returned in.

Algorithm

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

The interpolation algorithm (e.g. 'Minimum curvature', 'Radius of curvature', 'Average-Angle', 'Tangential') used to render the trajectory.

WellBore

`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

The data key string of the WellBore that the trajectory is associated with.

IsDefinitive

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

A flag indicating if the trajectory is a definitive trajectory for the wellbore it is associated with.

CreationDate

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

The date when the trajectory was created.

LastModifiedDate

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

The date the last modification was made to the trajectory.

Creator

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

The name of the person that created the trajectory.

Azimuth

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

A sampled list of azimuth values.

Name

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

The name of the trajectory

CalculationMethod

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

The calculation method used to perform the directional survey

StoreInstallationName

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

The name of the data store that the trajectory resides in.

TrajectoryStations

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

The data key strings of the entire trajectory stations that are associated to this trajectory.

TvdUnit

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

The acronym of the unit that the tvd is returned in.

InclinationUnit

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

The acronym of the unit that the inclinations are returned in.

ProjectName

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

The name of the project that the trajectory is contained in.

Tvd

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

A sampled list of TVD (Z) values.

Inclination

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