OpenSpirit v2.9.0 Build 27 - Generic Model

EpiDrilling_TubularComponent


Derived From:
EpEntity_Entity
Derivatives:
EpiDrilling_Bend, EpiDrilling_BitRecord, EpiDrilling_DrillCollar, EpiDrilling_HWDP, EpiDrilling_HoleOpener, EpiDrilling_Jar, EpiDrilling_Motor, EpiDrilling_MwdTool, EpiDrilling_Stabilizer
Capabilties:
read
A tubular component defines a component (e.g. drill pipe) that is part of a tubular.

Column Summary
Type Name and Description
String

ro

Unique identifier for each table entry.
Double

db

Axial stiffness of tubular.
Double

db

Bending stiffness of tubular.
Double

db

Burst Pressure of the tubular
String

db

The acronym of the unit that the burst pressure is returned in
Double

db

The total volume
String

db

The acronym of the unit that Capacity is returned in
String

db

Box and Pin configuration, e.
String

db

The classification of the tubular (e.
Double

db

Collapse Pressure of the tubular
String

db

The acronym of the unit that the collapse pressure is returned in
String

db

The comment of the tubular
Double

db

Connection's bending stiffness ratio
String

db

The acronym of the unit that the ConnCriticalCrossSection column is returned in
Double

db

Connection's internal diameter.
String

db

The acronym of the unit that the ConnInnerDiameter column value is returned in
Double

db

Connection length.
String

db

The acronym of the unit that the ConnLength column value is returned in
Double

db

Connection's outside diameter.
String

db

The acronym of the unit that the ConnOutsideDiameter column value is returned in
Double

db

Connection position (i.
Double

db

Connection's leak pressure rating
String

db

The acronym of the unit that the ConnPresLeak column is returned in
Double

db

Connection's thread size.
String

db

The acronym of the unit that the ConnSizeThread column value is returned in
Double

db

Connection's make up torque
String

db

The acronym of the unit that the ConnTqMakeup column is returned in
Double

db

Connection's torque yield stress
String

db

The acronym of the unit that the ConnTqYield column is returned in
String

db

Connection type, for instance, '5 1/2 FH' or 'HT 50'.
String

db

Connection thread type (e.
Double

db

Connection's yield stress of steel - worn stress
String

db

The acronym of the unit that the ConnTensYield column is returned in
Double

db

The cost of the tubular
String

db

The acronym of the unit that the cost is returned in
String

db

The description of the tubular component
Double

db

Closed End Displacement.
String

db

The acronym of the unit that Closed End Displacement is returned in
Double

db

Maximum dogleg severity.
String

db

The acronym of the unit that the DoglegMx is returned in
Double

db

The maximum diameter that can pass through (e.
String

db

The acronym of the unit that the MaxDriftDiameter is returned in
Double

db

Fishing neck inside diameter
String

db

The acronym of the unit that FishneckInnerDiameter is returned in
Double

db

Fishing neck length
String

db

The acronym of the unit that fishing neck length is returned in
Double

db

Fishing neck outer diameter
String

db

The acronym of the unit that FishneckOuterDiameter is returned in
String

db

Grade used to qualify the characteristics of the steel.
Double

req db

The inside diameter of the tubular component
String

db

The acronym of the unit that the InnerDiameter is returned in
Double

db

Average length of joint for tubular components
String

db

The acronym of the unit that the JointAverageLength is returned in
String

ro db

The data key string of the TubularComponent.
Double

req db

The length of the tubular component
String

db

The acronym of the unit that the length is returned in
String

db

The material the tubular is made of.
Double

db

Maximum external diameter of the tubular component.
String

db

The acronym of the unit that the MaxOutsideDiameter is returned in
Double

db

The MD at bottom of the tubular
String

db

The acronym of the unit that the MD at bottom of the tubular is returned in
Double

db

The MD at top of the tubular
String

db

The acronym of the unit that the MD at top of the tubular is returned in
String

db

The model number of the tubular
String

db

The name of the tubular component
String

db

The nominal inside diameter is a reference of the tubular component (connection objects not included)
String

db

The nominal inside diameter is a reference of the tubular component (connection objects not included)
String

db

The nominal weight is a reference of the tubular component (connection objects not included)
ULong

db

The number of joints or stands of tubular goods.
Double

req db

The outer diameter of the tubular component
String

db

The acronym of the unit that the OuterDiameter is returned in
String

db

Pipe class.
String

ro db

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

ro db

The name of the project that the tubular component is contained in.
ULong

ro db

The position of the tubular component in the tubular.
String

db

The serial number of the tubular
String

ro db

The name of the data store that the tubular component is associated with.
String

ro db

The type of data store that the tubular component is associated with.
Double

db

Fatigue endurance limit
String

db

The acronym of the unit that the StressFatig column is returned in
Double

db

Tension yield - maximum tension (e.
String

db

The acronym of the unit that the TensionYield is returned in
Double

db

Torsional stiffness of tubular.
Double

db

Torque yield stress - maximum torsion maximum torque (N m)
String

db

The acronym of the unit that maximum torque is returned in
String

ro req db

The data key string of the tubular that the tubular component is contained in.
String

req db

Component type e.
Double

db

Wall thickness
String

db

The acronym of the unit that the WallThickness is returned in
Double

db

Percent of Wall thickness wear.
Double

db

The linear weight for the tubular component
String

db

The acronym of the unit that the weight is returned in
Double

db

Yield stress of steel - worn stress - Pressure unit (e.
String

db

The acronym of the unit that the YieldStress is returned 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.

TensionYieldUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Strength
The acronym of the unit that the TensionYield is returned in

JointAverageLengthUnit

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 JointAverageLength is returned in

DoglegMx

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

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 tubular component is associated with.

TensionYield

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Strength
Tension yield - maximum tension (e.g N, lbf)

ConnSizeThreadUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:ShortLength
The acronym of the unit that the ConnSizeThread column value is returned 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 tubular is contained in.

JointAverageLength

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Length
Average length of joint for tubular components

ConnSizeThread

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:ShortLength
Connection's thread size.

CollapsePressureUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
The acronym of the unit that the collapse pressure is returned in

ConnTqMakeupUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Torque
The acronym of the unit that the ConnTqMakeup column is returned in

ConnCriticalCrossSectionUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:SmallArea
The acronym of the unit that the ConnCriticalCrossSection column is returned in

CollapsePressure

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
Collapse Pressure of the tubular

ConnTqMakeup

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Torque
Connection's make up torque

FishneckInnerDiameterUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The acronym of the unit that FishneckInnerDiameter is returned in

CfgConn

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Box and Pin configuration, e.g., PinPin, BoxBox, PinBox, BoxPin.

ConnTypeThread

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Connection thread type (e.g. from API RP7G,5CT)

ConnCriticalCrossSection

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:SmallArea
Connection's bending stiffness ratio

NominalWeightPerlength

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The nominal weight is a reference of the tubular component (connection objects not included)

OuterDiameterUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The acronym of the unit that the OuterDiameter is returned in

FishneckInnerDiameter

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
Fishing neck inside diameter

LengthUnit

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 length is returned in

PipeClass

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Pipe class. For example, class 'I', or class 'Premium' or class 'II' which corresponds to new, used or very used pipes. There is also a class 'III' indicating pipes to be removed.

ConnOutsideDiameterUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The acronym of the unit that the ConnOutsideDiameter column value is returned in

Tubular

Data Type:String
Content Type:Key
Read only:true
Required for Insert:true
Stored in db:true
Part of natural key:false
Referenced Table:EpiDrilling_Tubular
The data key string of the tubular that the tubular component is contained in.

OuterDiameter

Data Type:Double
Read only:false
Required for Insert:true
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The outer diameter of the tubular component

TorsionalStiffness

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Torsional stiffness of tubular.

ConnTqYieldUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Torque
The acronym of the unit that the ConnTqYield column is returned in

Length

Data Type:Double
Read only:false
Required for Insert:true
Stored in db:true
Part of natural key:false
Unit Measure:Length
The length of the tubular component

Classification

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The classification of the tubular (e.g. new, used)

ConnType

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Connection type, for instance, '5 1/2 FH' or 'HT 50'.

ConnOutsideDiameter

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
Connection's outside diameter.

YieldStressUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
The acronym of the unit that the YieldStress is returned in

ConnTqYield

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Torque
Connection's torque yield stress

YieldStress

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
Yield stress of steel - worn stress - Pressure unit (e.g. Psi, Bar, Pa)

FishneckLengthUnit

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 fishing neck length is returned in

FishneckLength

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

Description

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The description of the tubular component

ConnPosition

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Connection position (i.e. place where it connected, Top, Bottom or Both.)

WeightPerLenUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:MassPerLength
The acronym of the unit that the weight is returned in

MaxOutsideDiameterUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The acronym of the unit that the MaxOutsideDiameter is returned in

CostUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The acronym of the unit that the cost is returned in

WeightPerLen

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:MassPerLength
The linear weight for the tubular component

MaxOutsideDiameter

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
Maximum external diameter of the tubular component. The Outside diameter is the external diameter of the body of the tubular component

WallThicknessUnit

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 WallThickness is returned in

Cost

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The cost of the tubular

WallThickness

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

BurstPressureUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
The acronym of the unit that the burst pressure is returned in

WearWall

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Percent of Wall thickness wear.

TourqueYieldUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Torque
The acronym of the unit that maximum torque is returned in

InnerDiameterUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The acronym of the unit that the InnerDiameter is returned in

BurstPressure

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
Burst Pressure of the tubular

TourqueYield

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Torque
Torque yield stress - maximum torsion maximum torque (N m)

InnerDiameter

Data Type:Double
Read only:false
Required for Insert:true
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The inside diameter of the tubular component

ConnPresLeakUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
The acronym of the unit that the ConnPresLeak column is returned in

MdTopUnit

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 at top of the tubular is returned in

Comment

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The comment of the tubular

ConnPresLeak

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
Connection's leak pressure rating

CapacityUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The acronym of the unit that Capacity is returned in

MdTop

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:StandardDepthIndex
The MD at top of the tubular

SerialNumber

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The serial number of the tubular

Type

Data Type:String
Read only:false
Required for Insert:true
Stored in db:true
Part of natural key:false
RVS Set:TubularComponentType
Component type e.g. Bit, MWD, HWDP, SWDP, REAM etc

Capacity

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Volume
The total volume

ConnYieldStressUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
The acronym of the unit that the ConnTensYield column is returned in

Grade

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Grade used to qualify the characteristics of the steel. For tubular, grade determines the minimum yield strength and thus the burst and collapse pressures. The grade can be either defined by the supplier or defined by the API.

ConnYieldStress

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Pressure
Connection's yield stress of steel - worn stress

NominalOuterDiameter

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The nominal inside diameter is a reference of the tubular component (connection objects not included)

StressFatigUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Strength
The acronym of the unit that the StressFatig column is returned in

Material

Data Type:String
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The material the tubular is made of.

StressFatig

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Strength
Fatigue endurance limit

AxialStiffness

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Axial stiffness of tubular.

SequenceId

Data Type:ULong
Read only:true
Required for Insert:false
Stored in db:true
Part of natural key:false
The position of the tubular component in the tubular. The tubular component will be appended at the end of the tubular if the SequenceId column is not included when inserting a new tubular component.

DisplacementUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
The acronym of the unit that Closed End Displacement is returned in

ConnInnerDiameterUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The acronym of the unit that the ConnInnerDiameter column value is returned in

DriftDiameterUnit

Data Type:String
Content Type:UnitAcronym
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The acronym of the unit that the MaxDriftDiameter is returned in

Displacement

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:Volume
Closed End Displacement.

ConnInnerDiameter

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
Connection's internal diameter.

DriftDiameter

Data Type:Double
Read only:false
Required for Insert:false
Stored in db:true
Part of natural key:false
Unit Measure:CylinderDiameter
The maximum diameter that can pass through (e.g. the largest diameter of a perfect cylinder that can fit into pipe)

ConnLengthUnit

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 ConnLength column value is returned in

NumberJointStand