BitRecord (OpenSpirit v2.9.0 Build 27

Intro

Overview

Model

Table

OpenSpirit v2.9.0 Build 27 - Generic Model

SUMMARY: INHERITED | COLUMNS

DETAIL: COLUMNS

EpiDrilling_BitRecord

Derived From:: EpEntity_Entity, EpiDrilling_TubularComponent

Capabilties:: read

A class for tools likes Drill Bit, Core Bit, Reamer.

Column Summary

Type Name and Description

Stringro

KeyString

Unique identifier for each table entry.

Double
db

AreaNozzleFlow

Total area of nozzles

String
db

AreaNozzleFlowUnit

The acronym of the unit that the AreaNozzleFlow column is returned in

String
db

BitClass

N for new, U for used

Double
db

BitCost

Bit cost in local currency

String
db

BitCostUnit

The acronym of the unit that the BitCost column is returned in

Double
db

BitLength

Overall Length of drill bit.

String
db

BitLengthUnit

The acronym of the unit that the BitLength column is returned in

String
db

BitModel

Bit name from manufacturer

String
db

CodeIADC

IADC bit code

Double
db

CondFinalBearing

Condition of bit bearings (0-8)

String
db

CondFinalBearingUnit

The acronym of the unit that the CondFinalBearing column is returned in

String
db

CondFinalDull

Overall dull condition from IADC bit wear 2 character codes (BitDullCode in Standard LISTS).

String
db

CondFinalGauge

Condition of bit gauge in 1/16" I = in gauge, else number of 16ths out of gauge

Double
db

CondFinalInner

Condition of inner tooth rows (inner 2/3 of bit) (0-8)

String
db

CondFinalInnerUnit

The acronym of the unit that the CondFinalInner column is returned in

String
db

CondFinalLocation

Row and cone numbers for items, which need location information (e.

String
db

CondFinalOther

Other comments on bit condition from IADC list (BitDullCode in Standard LISTS).

Double
db

CondFinalOuter

Condition of outer tooth rows (outer 1/3 of bit) (0-8)

String
db

CondFinalOuterUnit

The acronym of the unit that the CondFinalOuter column is returned in

String
db

CondFinalReason

Reason bit was pulled from IADC codes (BitReasonPulled in STANDARD LISTS).

Double
db

CondInitBearing

Condition of bit bearings (0-8)

String
db

CondInitBearingUnit

The acronym of the unit that the CondInitBearing column is returned in

String
db

CondInitDull

Overall dull condition from IADC bit wear 2 character codes (BitDullCode in Standard LISTS).

String
db

CondInitGauge

Condition of bit gauge in 1/16" I = in gauge, else number of 16ths out of gauge.

Double
db

CondInitInner

No description provided.

String
db

CondInitInnerUnit

The acronym of the unit that the CondInitInner column is returned in

String
db

CondInitLocation

Row and cone numbers for items which need location information (e.

String
db

CondInitOther

Other comments on bit condition from IADC list (BitDullCode in Standard LISTS)

Double
db

CondInitOuter

No description provided.

String
db

CondInitOuterUnit

The acronym of the unit that the CondInitOuter column is returned in

String
db

CondInitReason

Reason bit was pulled from IADC codes (BitReasonPulled in STANDARD LISTS)

Double
db

DiaBit

Diameter of drilled hole.

String
db

DiaBitUnit

The acronym of the unit that the DiaBit column is returned in

Double
db

DiaPassThru

Minimum hole or tubing which bit will pass through (for bi-center bits).

String
db

DiaPassThruUnit

The acronym of the unit that the DiaPassThru column is returned in

Double
db

DiaPilot

Diameter of pilot bit (for bi-center bits).

String
db

DiaPilotUnit

The acronym of the unit that the DiaPilot column is returned in

String
db

Drive

Bit drive type (Motor, rotary table etc).

String
db

Manufacturer

Manufacturer or supplier of the item.

DoubleSeq
db

NozzleDiameter

List of nozzle diameters

String
ro db

NozzleDiameterUnit

The acronym of the unit that the nozzle diameters are returned in

ULongSeq
db

NozzleIndex

List of indexes if nozzles are indexed.

DoubleSeq
db

NozzleLen

List of nozzle lengths

String
db

NozzleLenUnit

The acronym of the unit that the nozzle lengths are returned in

DoubleSeq
db

NozzleNumber

List of bit nozzle numbers.

StringSeq
db

NozzleOrientation

List of nozzle orientations.

StringSeq
db

NozzleType

List of nozzle types

String
db

NumBit

Bit number and rerun number e.

String
db

TypeBit

Type of bit

Columns inherited from EpiDrilling_TubularComponent

AxialStiffness, BendStiffness, BurstPressure, BurstPressureUnit, Capacity, CapacityUnit, CfgConn, Classification, CollapsePressure, CollapsePressureUnit, Comment, ConnCriticalCrossSection, ConnCriticalCrossSectionUnit, ConnInnerDiameter, ConnInnerDiameterUnit, ConnLength, ConnLengthUnit, ConnOutsideDiameter, ConnOutsideDiameterUnit, ConnPosition, ConnPresLeak, ConnPresLeakUnit, ConnSizeThread, ConnSizeThreadUnit, ConnTqMakeup, ConnTqMakeupUnit, ConnTqYield, ConnTqYieldUnit, ConnType, ConnTypeThread, ConnYieldStress, ConnYieldStressUnit, Cost, CostUnit, Description, Displacement, DisplacementUnit, DoglegMx, DoglegMxUnit, DriftDiameter, DriftDiameterUnit, FishneckInnerDiameter, FishneckInnerDiameterUnit, FishneckLength, FishneckLengthUnit, FishneckOuterDiameter, FishneckOuterDiameterUnit, Grade, InnerDiameter, InnerDiameterUnit, JointAverageLength, JointAverageLengthUnit, KeyString, Length, LengthUnit, Material, MaxOutsideDiameter, MaxOutsideDiameterUnit, MdBottom, MdBottomUnit, MdTop, MdTopUnit, ModelNumber, Name, NominalInnerDiameter, NominalOuterDiameter, NominalWeightPerlength, NumberJointStand, OuterDiameter, OuterDiameterUnit, PipeClass, Project, ProjectName, SequenceId, SerialNumber, StoreInstallationName, StoreType, StressFatig, StressFatigUnit, TensionYield, TensionYieldUnit, TorsionalStiffness, TourqueYield, TourqueYieldUnit, Tubular, Type, WallThickness, WallThicknessUnit, WearWall, WeightPerLen, WeightPerLenUnit, YieldStress, YieldStressUnit

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.

CondInitOther

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

Other comments on bit condition from IADC list (BitDullCode in Standard LISTS)

CondFinalOther

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

Other comments on bit condition from IADC list (BitDullCode in Standard LISTS).

AreaNozzleFlowUnit

`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 AreaNozzleFlow column is returned in

NozzleIndex

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

List of indexes if nozzles are indexed.

NozzleOrientation

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

List of nozzle orientations.

CondInitReason

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

Reason bit was pulled from IADC codes (BitReasonPulled in STANDARD LISTS)

AreaNozzleFlow

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

Total area of nozzles

TypeBit

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

Type of bit

CondInitOuterUnit

`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 CondInitOuter column is returned in

CondFinalOuterUnit

`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 CondFinalOuter column is returned in

Drive

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

Bit drive type (Motor, rotary table etc).

CondInitOuter

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

No description provided.

CondFinalOuter

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

Condition of outer tooth rows (outer 1/3 of bit) (0-8)

CondInitGauge

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

Condition of bit gauge in 1/16" I = in gauge, else number of 16ths out of gauge.

CondInitLocation

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

Row and cone numbers for items which need location information (e.g. Cracked Cone, Lost Cone etc)

CondFinalGauge

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

Condition of bit gauge in 1/16" I = in gauge, else number of 16ths out of gauge

Manufacturer

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

Manufacturer or supplier of the item.

CondInitInnerUnit

`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 CondInitInner column is returned in

NumBit

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

Bit number and rerun number e.g. "4.1" for the first rerun of bit 4

CondFinalInnerUnit

`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 CondFinalInner column is returned in

CondFinalDull

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

Overall dull condition from IADC bit wear 2 character codes (BitDullCode in Standard LISTS).

CondInitInner

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

No description provided.

NozzleNumber

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

List of bit nozzle numbers. For instance, '3x 16/32em', '1x14/32em', '1x18/32em'. 32em means 1 inch/32.

CondFinalInner

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

Condition of inner tooth rows (inner 2/3 of bit) (0-8)

DiaPilotUnit

`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 DiaPilot column is returned in

NozzleLenUnit

`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 nozzle lengths are returned in

BitCostUnit

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

The acronym of the unit that the BitCost column is returned in

BitModel

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

Bit name from manufacturer

DiaPilot

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

Diameter of pilot bit (for bi-center bits).

NozzleLen

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

List of nozzle lengths

BitCost

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

Bit cost in local currency

CondFinalReason

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

Reason bit was pulled from IADC codes (BitReasonPulled in STANDARD LISTS).

NozzleType

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

List of nozzle types

CondFinalLocation

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

Row and cone numbers for items, which need location information (e.g. Cracked Cone, Lost Cone etc).

DiaPassThruUnit

`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 DiaPassThru column is returned in

DiaPassThru

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

Minimum hole or tubing which bit will pass through (for bi-center bits).

CondInitBearingUnit

`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 CondInitBearing column is returned in

CondFinalBearingUnit

`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 CondFinalBearing column is returned in

CondInitBearing

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

Condition of bit bearings (0-8)

CondFinalBearing

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

Condition of bit bearings (0-8)

BitLengthUnit

`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 BitLength column is returned in

DiaBitUnit

`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 DiaBit column is returned in

BitLength

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

Overall Length of drill bit.

DiaBit

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

Diameter of drilled hole.

NozzleDiameterUnit

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

The acronym of the unit that the nozzle diameters are returned in

BitClass

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

N for new, U for used

NozzleDiameter

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

List of nozzle diameters

CodeIADC

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

IADC bit code

CondInitDull

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