R_Tubular_Cat


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name R_Tubular_Cat
Entity Type Abstract
Description The catalog properties of commonly used tubulars
Submodel Tubular
Entity Scope Reference
Primary Key Ref_Id
Natural Key
Generalizations R_Facility_Cat , Ref_Entity_Surrogate_Key , Reference_Entity_Parent
Specializations R_Casing_Accessory_Cat , R_Casing_Cat , R_Drill_Pipe_Cat , R_Generic_Tubular_Cat , R_Production_Packer_Cat , R_Slotted_Liner_Cat , R_Tubing_Cat


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
Active_Flag boolean NA
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. Yes
1
NUMBER(1)
Burst_Pressure double Pressure
kPa
The internal pressure that will cause piece of drill pipe to fail. No
NUMBER
Cat_Inside_Diameter double Cylinder_Diameter
mm
The typical inside diameter of a tubular No
NUMBER
Cat_Length double Length
m
The catalog length of the tubular No
NUMBER
Cat_Linear_Weight double Mass_Per_Length
kg/m
The typical linear weight of a tubular No
NUMBER
Cat_Outside_Diameter double Cylinder_Diameter
mm
The typical outside diameter of a tubular No
NUMBER
Cat_Wall_Thickness double Cylinder_Diameter
mm
Wall thickness No
NUMBER
Catalog_Number STRING64 NA
A catalog or part number for a facility. No
VARCHAR2(64)
Code CODE NA
A standard abbreviation, mnemonic, or short code that represents the reference value. No
VARCHAR2(64)
Collapse_Pressure double Pressure
kPa
The minimum differential pressure which a tubular will withstand without permanent deformation No
NUMBER
Compression double Force
N
Compression No
NUMBER
Coupling_Outside_Diameter double Cylinder_Diameter
mm
The outside diameter of the coupling on the tubular No
NUMBER
Coupling_Type String NA
The type of coupling on the tubular No
VARCHAR2(255)
Description STRING2000 NA
A textual definition of the reference value. No
VARCHAR2(2000)
Displacement_Volume double Volume_Per_Length
m3/m
The cross-sectional area of steel (or other material if the tubular is not made of steel) in the tubular expressed in units of volume per unit length. No
NUMBER
Drift_Diameter double Cylinder_Diameter
mm
Largest diameter of a perfect cylinder that can fit into the pipe. Because a pipe is slightly oval the drift diameter is always smaller than the quoted inner diameter. The drift diameter is used to know if a given pipe will run into a pipe. No
NUMBER
Equipment_Symbol R_Equipment_Symbol
The display symbol associated with the equipment catalog entry. No
NUMBER(38)
Fatigue_Endurance_Limit double Stress
kPa
The maximum stress below which the tubular could presumably endure an infinite number of cycles. No
NUMBER
Hydrostatic_Test_Pressure double Pressure
kPa
Hydrostatic Test Pressure No
NUMBER
Insert_Date DATE NA
Date the entity was created in the repository No
DATE
Insert_User STRING64 NA
The name of the user responsible for the creation of this entity in the repository. No
VARCHAR2(64)
Manufacturer STRING64 NA
Name of the business associate who manufactured the item. No
VARCHAR2(64)
Min_Make_Up_Torque double High_Torque
kN.m
The minimum torque required to make up the joint to meet the leak resistance spec. No
NUMBER
Model_Name STRING64 NA
Name of a model or version of some entity; for equipment, it may coincide with the trade name. No
VARCHAR2(64)
Name STRING255 NA
The spelled-out name of the reference value. No
VARCHAR2(255)
Nom_Inside_Diameter double No_Unit
Nominal inside diameter of the tubular body No
NUMBER
Nom_Inside_Diameter_UOM R_Unit
The unit of measure associated with the Nominal Inside Diameter No
VARCHAR2(64)
Nom_Linear_Weight double No_Unit
The nominal linear weight of the tubular Yes
NUMBER
Nom_Linear_Weight_Str STRING64 NA
The string representation of the Nominal Linear Weight of the tubular. For example ""11 lb/ft"" No
VARCHAR2(64)
Nom_Linear_Weight_UOM R_Unit
The unit of measure associated with the Nominal Linear Weight Yes
VARCHAR2(64)
Nom_Outside_Diameter double No_Unit
Nominal Outside diameter of the tubular body Yes
NUMBER
Nom_Outside_Diameter_Str STRING64 NA
The string representation of the Nominal Outside Diameter of the tubular. For example ""8 1/2 inch"" No
VARCHAR2(64)
Nom_Outside_Diameter_UOM R_Unit
The unit of measure associated with the Nominal Outside Diameter Yes
VARCHAR2(64)
Non_Magnetic_Flag boolean NA
A flag indicating whether the tubular is made with non magnetic material No
NUMBER(1)
Ref_Id ID No_Unit
The surrogate identifier of an instance of reference data. Yes
NUMBER(38)
Source CODE NA
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. No
VARCHAR2(64)
Standardization_Name STRING64 NA
Name of the body in charge of standardization of the data such as API, ISO Yes
VARCHAR2(64)
Storage_Unit_System R_Unit_System
The unit system in which the numeric values are stored. It is expected that every numeric value in this table will be of the same unit system e.g Metric, English etc No
VARCHAR2(64)
Tensile_Yield_Strength double Force
N
The tensile yield strength of the tubular No
NUMBER
Tension double Force
N
Tension No
NUMBER
Torsional_Yield_Strength double Force
N
The torsional yield strength of the tubular No
NUMBER
Tubular_Grade R_Tubular_Grade
The grade of the Tubular No
VARCHAR2(64)
Update_Date DATE NA
Date of the most-recent modification to the entity. No
DATE
Update_User STRING64 NA
The name of the user responsible for the last modification to this entity. No
VARCHAR2(64)
Upset_Type String NA
The upset type of the tubular. Examples are IU, EU and IEU No
VARCHAR2(255)


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Nom_Outside_Diameter_UOM R_Unit The unit of measure associated with the Nominal Outside Diameter Restrict Yes
Tubular_Grade R_Tubular_Grade The grade of the Tubular Restrict No
Storage_Unit_System R_Unit_System _ Restrict No
Nom_Linear_Weight_UOM R_Unit The unit of measure associated with the Nominal Linear Weight Restrict Yes
Equipment_Symbol R_Equipment_Symbol _ Restrict No
Nom_Inside_Diameter_UOM R_Unit The unit of measure associated with the Nominal Inside Diameter Restrict No


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.