| Name | R_ESP_Pump_Cat |
|---|---|
| Entity Type | Table |
| Description | Catalog data for ESP pumps |
| Submodel | Artificial_Lift |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | |
| Generalizations | R_Pump_Cat , R_Facility_Cat , Ref_Entity_Surrogate_Key , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / 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) |
| Actual_Stage_Count | int | No_Unit |
Number of Stages actually installed in the ESP Pump | No |
NUMBER(10) |
| 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) |
| Diameter | double | Cylinder_Diameter mm |
The diameter of the pump. | No |
NUMBER |
| Engineering_Code | STRING128 | NA |
Constructed code string for equipment. A code containing concatenated attributes of equipment. The structure will vary with each equipment type. For example: "A1200 FL-CT 29 STG 338/338 20 CS BTHD, .62 MON, S-TRM, HSN". | No |
VARCHAR2(128) |
| Equipment_Symbol | R_Equipment_Symbol |
|
The display symbol associated with the equipment catalog entry. | No |
NUMBER(38) |
| Flow_Capacity | double | Flowrate m3/h |
The flow rate capacity of the pump. | No |
NUMBER |
| Housing_Metallurgy | CODE | NA |
The metallurgy of the Housing of an ESP Pump. | No |
VARCHAR2(64) |
| Housing_Type | CODE | NA |
Short Description of Pump Housing | No |
VARCHAR2(64) |
| Hydraulic_Power | double | Power W |
Hydraulic power (Flow rate x pressure) that the pump can sustain over a long period of time. | 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) |
| Length | double | Length m |
Length of ESP Pump | No |
NUMBER |
| Manufacturer | STRING64 | NA |
Name of the business associate who manufactured the item. | No |
VARCHAR2(64) |
| Max_Stage_Count | int | No_Unit |
The maximum number of Stages in ESP Pump Housing | No |
NUMBER(10) |
| Max_Stroke_Rate | double | Frequency Hz |
Maximum allowable strokes per unit time of the pump. | No |
NUMBER |
| Min_Stage_Count | int | No_Unit |
The minimum number of Stages in ESP Pump Housing | No |
NUMBER(10) |
| 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) |
| Optimum_Oper_Pressure | double | Pressure kPa |
The optimum operating pressure of the pump. | No |
NUMBER |
| Optimum_Oper_Temp | double | Temperature degC |
The optimum operating temperature of the pump. | No |
NUMBER |
| Outer_Diameter | double | Cylinder_Diameter mm |
Outside Diameter of ESP pump | No |
NUMBER |
| Pump_Curve | R_Pump_Curve_Cat |
|
The nominal pump performance curve associated with this type of pump. | No |
NUMBER(38) |
| Pump_Type | CODE | NA |
A classification to identify a major grouping of ESP pumps, for example "DC2600", "W-18". | No |
VARCHAR2(64) |
| Rated_Efficiency | double | Percent % |
The ratio of the useful energy delivered by a dynamic system to the energy supplied to it. | No |
NUMBER |
| Rated_Pressure | double | Pressure kPa |
The pressure rating of the pump. | No |
NUMBER |
| Rated_SHP | CODE | NA |
Shaft Horsepower Rating for an ESP Pump. | No |
VARCHAR2(64) |
| Rated_Speed | double | Rotary_Speed c/min |
The rated speed of the pump. | No |
NUMBER |
| Rated_Volume | double | Volume m3 |
Volume Rating / Designed Volumetric Rating of ESP Pump | No |
NUMBER |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| Series_Name | CODE | NA |
Name or Number to identify the ESP Pump Series, for example "A-338", "D387" | No |
VARCHAR2(64) |
| Shaft_Size | double | Cylinder_Diameter mm |
The size of the shaft | No |
NUMBER |
| Shaft_Type | CODE | NA |
The type of shaft fitted to the ESP Pump. 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) |
| Stage_Design | CODE | NA |
Configuration of stages used in an ESP Pump. | 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) |
| Stroke_Length | double | Length m |
Traveling length of the piston of the pump. | No |
NUMBER |
| Trim_Type | CODE | NA |
The trim code for ESP Pump. | 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 |
The weight of the ESP Pump. | No |
NUMBER |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| ESP_Pump | ESP_Pump_Cat | Reference to the catalog entry for this device | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Equipment_Symbol | R_Equipment_Symbol | _ | Restrict | No |
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |
| Pump_Curve | R_Pump_Curve_Cat | _ | Restrict | No |