TrajectoryStation (OpenSpirit v2.9.0 Build 27

Intro

Overview

Model

Table

OpenSpirit v2.9.0 Build 27 - Generic Model

SUMMARY: INHERITED | COLUMNS

DETAIL: COLUMNS

EpiDrilling_TrajectoryStation

Derived From:: EpEntity_Entity

Capabilties:: read

A planned or actual point along a trajectory.

Column Summary

Type Name and Description

Stringro

KeyString

Unique identifier for each table entry.

Double
db

Azimuth

The measured or calculated azimuth

String
db

AzimuthUnit

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

Double
req db

BuildRate

Build Rate, radius of curvature computation

String
db

BuildRateUnit

The acronym of the unit that the build rate is returned in.

String
ro req db

CreationDate

The time when the station was created

String
db

Creator

The name of the person that created the station

Double
db

Dls

The dog leg severity

String
db

DlsUnit

The acronym of the unit that the dogleg curvature is returned in.

Double
db

EastOffSet

The (measured) east (X) offset

String
db

EastOffSetUnit

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

String
db

ExistanceStatus

A flag indicating if the station is planned or drilled.

String
db key

Identifier

The unique identifier of the station.

Double
db

Inclination

The measured or calculated inclination

String
db

InclinationUnit

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

String
ro db

KeyString

The station's data key string

String
ro db

LastModifiedDate

The date the last modification was made to the station.

Double
db

Md

The (MD) measured depth)

String
db

MdUnit

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

String
db

Modifier

The name of the person that last modified the station

Double
db

NorthOffset

The (measured) north (Y) offset

String
db

NorthOffSetUnit

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

String
ro db

Project

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

String
ro db

ProjectName

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

String
db

ServiceCompany

The company that measured the station.

String
db

StationType

Type of trajectory station, e.

String
db

Status

The status of the station.

String
ro db

StoreInstallationName

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

String
ro db

StoreType

The type of data store that the station resides in.

String
db

ToolType

The type of Tool used to measure this point.

String
ro db key

Trajectory

The data key string of the Trajectory that the station belongs.

Double
db

TurnRate

Turn rate, radius of curvature comp.

String
db

TurnRateUnit

The acronym of the unit that the turn rate is returned in.

Double
db

Tvd

The measured or calculated TVD

String
db

TvdUnit

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

String
db

WellBore

The data key string of the WellBore that the station resides in.

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 station resides in.

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 station is contained in.

NorthOffset

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

The (measured) north (Y) offset

Status

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

The status of the station. For example, Locked, Open, Rejected

BuildRateUnit

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

The acronym of the unit that the build rate is returned in.

BuildRate

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

Build Rate, radius of curvature computation

Identifier

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

The unique identifier of the station.

ServiceCompany

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

The company that measured the station.

TurnRateUnit

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

The acronym of the unit that the turn rate is returned in.

TurnRate

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

Turn rate, radius of curvature comp.

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 MD 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 station is planned or drilled. True means that it 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 station

Md

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

The (MD) measured depth)

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.

ToolType

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

The type of Tool used to measure this point.

KeyString

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

The station's data key string

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 azimuth is returned in.

EastOffSet

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

The (measured) east (X) offset

DlsUnit

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

The acronym of the unit that the dogleg curvature is returned in.

WellBore

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

The data key string of the WellBore that the station resides in.

StationType

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

Type of trajectory station, e.g. TieInPoint, MagneticMwd, GyroMwd

CreationDate

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

The time when the station 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 station.

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 station

Azimuth

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

The measured or calculated azimuth

Dls

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

The dog leg severity

Trajectory

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

The data key string of the Trajectory that the station belongs.

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 station resides 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 inclination is returned in.

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.

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 station is contained in.

Inclination

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

The measured or calculated inclination

Tvd

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