| 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 / Measurement | 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 |
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) |
| Flow_Capacity | double Flowrate |
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 |
Hydraulic power (Flow rate x pressure) that the pump can sustain over a long period of time. | No |
NUMBER |
| Length | double Length |
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 |
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 | CODE NA |
The spelled-out name of the reference value. | No |
VARCHAR2(64) |
| Optimum_Oper_Pressure | double Pressure |
The optimum operating pressure of the pump. | No |
NUMBER |
| Optimum_Oper_Temp | double Temperature |
The optimum operating temperature of the pump. | No |
NUMBER |
| Outer_Diameter | double Cylinder_Diameter |
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 |
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 |
The rated speed of the pump. | No |
NUMBER |
| Rated_Volume | double Volume |
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 |
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 |
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 |
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 |
|---|---|---|---|---|
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |
| Pump_Curve | R_Pump_Curve_Cat | _ | Restrict | No |