R_ESP_Component_Cat


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

General Information

[Next]
Name R_ESP_Component_Cat
Entity Type Abstract
Description Common Catalog data for ESP components like ESP_Motor, ESP_Intake etc.
Submodel Artificial_Lift
Entity Scope Reference
Primary Key Ref_Id
Natural Key
Generalizations R_Facility_Cat , Ref_Entity_Surrogate_Key , Reference_Entity_Parent
Specializations R_ESP_Gas_Device_Cat , R_ESP_Intake_Cat , R_ESP_Motor_Cat , R_ESP_Protector_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)
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)
Configuration_Type CODE NA
Configuration code, for example "FL-CT". No
VARCHAR2(64)
Description STRING2000 NA
A textual definition of the reference value. No
VARCHAR2(2000)
Engineering_Code STRING128 NA
Constructed code string for equipment. A code containing concatenated attributes of equipment. The structure will vary with each equipment type. No
VARCHAR2(128)
Equipment_Symbol R_Equipment_Symbol
The display symbol associated with the equipment catalog entry. No
NUMBER(38)
Housing_Metallurgy CODE NA
The metallurgy of the Housing of an ESP component. No
VARCHAR2(64)
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)
Length double Length
m
Length of the ESP Component No
NUMBER
Manufacturer STRING64 NA
Name of the business associate who manufactured the item. No
VARCHAR2(64)
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)
Rated_SHP double Power
W
Shaft Horsepower Rating for an ESP Component. No
NUMBER
Ref_Id ID No_Unit
The surrogate identifier of an instance of reference data. Yes
NUMBER(38)
Series_Name CODE NA
ESP Component Series Number No
VARCHAR2(64)
Shaft_Size double Cylinder_Diameter
mm
Cylinder diameter of a shaft used in ESP components. No
NUMBER
Shaft_Type CODE NA
The type of shaft fitted to the component. Examples would be "Standard" and "High Strength" shaft No
VARCHAR2(64)
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)
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)
Trim_Type CODE NA
The trim code for ESP components. 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)
Weight double Force
N
Weight of an ESP component. No
NUMBER


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Storage_Unit_System R_Unit_System _ Restrict No
Equipment_Symbol R_Equipment_Symbol _ Restrict No


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

Copyright © 2018 Schlumberger. All rights reserved.