Sucker_Rod

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

Name	Sucker_Rod
Entity Type	Table
Description	A sucker rod is the connecting link between the surface pumping unit and the subsurface pump, which is located at or near the bottom of the oil well.
Submodel	Artificial_Lift
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations	Tubular , Tracked_Facility , Facility , Entity , IT_Object , Tracked_Object
Specializations

Columns

[Previous] [Next] [Top]

Name	Value Domain / Measurement	Description	Required / Default	Type
Absolute_Roughness	double Length	The absolute roughness of the inside wall of the tubular	No	NUMBER
Address_Id	Address	The address of the Tracked Facility	No	NUMBER(38)
Axial_Stiffness	double Spring_Stiffness	A measure of the inflexibility of a tubular in an axial plane	No	NUMBER
Bend_Stiffness	double Spring_Stiffness	A measure of the inflexibility of a tubular in a longitudinal plane	No	NUMBER
Burst_Pressure	double Pressure	Burst Pressure of the tubular	No	NUMBER
Catalog_Cost	double No_Unit	The catalog cost of the piece of equipment or facility expressed in the currency denoted by the attribute Catalog_Currency	No	NUMBER
Catalog_Currency	R_Currency	The currency in which the catalog cost is expressed.	No	VARCHAR2(64)
Catalog_Number	STRING64 NA	A catalog or part number for a facility.	No	VARCHAR2(64)
Coating_Desc	STRING64 NA	A description of the coating applied to the tubular	No	VARCHAR2(64)
Collapse_Pressure	double Pressure	Collapse pressure	No	NUMBER
Compressive_Strength	double Pressure	Compressive Strength of tubular	No	NUMBER
Displacement_Volume	double Volume_Per_Length	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	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
Existence_Kind	REF_EXISTENCE_KIND NA	A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual.	Yes Actual	VARCHAR2(64)
Facility_Equipment_Flag	CODE NA	A flag to denote whether a given facility should be treated as a facility (F), a piece of equipment (E) or both (B). A facility labeled as F represents a role (e.g. ESP) played by physical piece(s) of equipment and would not have attributes like serial number, manufacturer etc. It can be related to the physical pieces(s) of equipment using Facility_Composition. The individual physical pieces can be replaced if they need to be, without changing the facility. A Facility labeled as E represents a physical piece of equipment (e.g. Drill Pipe) which is normally used in the context of an activity and would not be permanently installed. A facility labeled as B represents both a physical piece of equipment as well as the role played by it. If this kind of Facility is connected in the network and stops working and needs to be replaced, then all connections to this Facility are expired and new connections are made to the replacement facility.	No	VARCHAR2(64)
Fatigue_Endurance_Limit	double Stress	The maximum stress below which the tubular could presumably endure an infinite number of cycles.	No	NUMBER
Fishneck_Inside_Diameter	double Cylinder_Diameter	The inside diameter of the fishneck.	No	NUMBER
Fishneck_Length	double Length	Fishing neck length. This is defined as being the distance from the seal face to the location of any section change.	No	NUMBER
Fishneck_Outside_Diameter	double Cylinder_Diameter	The inside diameter of the fishneck.	No	NUMBER
GUID	STRING128 NA	Globally Unique IDentifier for an instance of a class. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers.	No	VARCHAR2(128)
Guide_Description	STRING64 NA	Description of the guides	No	VARCHAR2(64)
Guide_Material	STRING64 NA	Material of which the guide is made of	No	VARCHAR2(64)
Guide_Size	double Cylinder_Diameter	Size of the guides	No	NUMBER
Guides_Per_Rod_Count	int No_Unit	Number of guides in the rod	No	NUMBER(10)
Heavyweight_Flag	boolean NA	A flag to denote whether or not the tubular is classified as a "Heavyweight" tubular or not	No	NUMBER(1)
Hydrostatic_Test_Pressure	double Pressure	The nominal test pressure that a tubular can safely hold	No	NUMBER
Id	ID No_Unit	Unique identifier for this entity.	Yes	NUMBER(38)
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)
Inside_Diameter	double Cylinder_Diameter	Actual Inside diameter of an entity, such as an item of drill string equipment. In the absence of the actual value the catalog value should be used	No	NUMBER
Inventory_Id	STRING64 NA	The formal identification for a piece of equipment, a serial number or inventory ID	No	VARCHAR2(64)
Joint_Count	int No_Unit	The number of joints of tubular goods.	No	NUMBER(10)
Length	double Length	Actual length of the drill string component	No	NUMBER
Linear_Weight	double Mass_Per_Length	Weight of an equipment item per unit length; e.g. Casing weight, pipe weight, cable weight, etc.	No	NUMBER
Manufacture_Date	DATE NA	Date of manufacturing the facility.	No	DATE
Manufacturer	STRING64 NA	Name of the business associate who manufactured the item.	No	VARCHAR2(64)
Material_Type	STRING64 NA	The primary material type of facility.	No	VARCHAR2(64)
Max_Dog_Leg_Severity	double Well_Curvature	The maximum dog leg severity for the tubular.	No	NUMBER
Max_Make_Up_Torque	double High_Torque	The torque above which you have over-torqued (damaged the threads).	No	NUMBER
Max_Outside_Diameter	double Cylinder_Diameter	Maximum external diameter of the tubular. The Outside diameter is the external diameter of the body of the tubular	No	NUMBER
Min_Make_Up_Torque	double High_Torque	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	ENTITY_NAME NA	The name given to any object or data item, e.g. Name of Well, Name of Field, etc.	No	VARCHAR2(255)
Non_Magnetic_Flag	boolean NA	A flag indicating whether the equipment is made with non magnetic material	No	NUMBER(1)
Original_Source	STRING64 NA	The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15"	No	VARCHAR2(64)
Outside_Diameter	double Cylinder_Diameter	Actual Outside diameter of the Equipment. For a tubular, it is the outside diameter of the body. In the absence of the actual value the catalog value should be used	No	NUMBER
Polished_Flag	boolean NA	A flag to denote whether the Sucker Rod is polished or not. A value of 1 means that the rod is a polished rod, 0 means it is not	No	NUMBER(1)
Produced_By	STRING64 NA	ID of the activity that was executing when the entity was created, for data created programmatically.	No	VARCHAR2(64)
Remarks	STRING2000 NA	Any type of remarks added to an entity instance.	No	VARCHAR2(2000)
SDAT_Label	int No_Unit	Label used by the security system for entitlements. SDAT is Secure Data Access Technology.	No	NUMBER(10)
Serial_Number	STRING64 NA	The serial number placed on a piece of equipment.	No	VARCHAR2(64)
Source	STRING64 NA	Name of the person or organization responsible for this entity"s E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User.	No	VARCHAR2(64)
Steel_Grade	STRING64 NA	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.	No	VARCHAR2(64)
Tensile_Strength	double Pressure	Maximum tensile strength of the item	No	NUMBER
Thread_Lock_Flag	boolean NA	A flag to indicate whether or not thread locks have been used	No	NUMBER(1)
Torsional_Stiffness	double Spring_Stiffness	A measure of the inflexibility of a tubular around its longitudinal axis	No	NUMBER
Torsional_Strength	double Torque	Maximum torsional strength of the item	No	NUMBER
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)
Used_Class	STRING64 NA	Used Classification (New, used or reconditioned)	No	VARCHAR2(64)
VME_Rating	double No_Unit	Von Mises Equivalent Stress Rating	No	NUMBER
Vendor_Id	Company	The company from which the facility was purchased.	No	NUMBER(38)
Version	STRING255 NA	The form or variant of the entity.	Yes 1	VARCHAR2(255)
Wall_Thickness	double Cylinder_Diameter	The actual thickness of the wall of the tubular. In the absence of the actual value the catalog value should be used	No	NUMBER
Weight	double Force	The weight of the Tubular	No	NUMBER

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Address	Address	_	Nullify	No
Catalog_Currency	R_Currency	_	Restrict	No
Vendor	Company	_	Nullify	No

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

Sucker_Rod

Copyright © 2009 Schlumberger. All rights reserved.