| Name | R_ESP_Motor_Cat |
|---|---|
| Entity Type | Table |
| Description | Reference table for ESP Motor |
| Submodel | Artificial_Lift |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | |
| Generalizations | R_ESP_Component_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) |
| 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 |
| Lubrication_Description | CODE | NA |
Short Description of Motor Lubrication | No |
VARCHAR2(64) |
| 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) |
| Motor_Type | CODE | NA |
A classification to identify a major grouping of ESP motors, for example "SK", "SX". | Yes |
VARCHAR2(64) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Outer_Diameter | double | Cylinder_Diameter mm |
Outer Diameter of Motor Unit | No |
NUMBER |
| Pothead_Type | CODE | NA |
The type of connector between the motor and the power cable/motor lead. | No |
VARCHAR2(64) |
| Rated_Current | double | Electric_Current mA |
Current Rating of Motor Unit | No |
NUMBER |
| Rated_Frequency | double | Frequency Hz |
Frequency Rating of Motor Unit | No |
NUMBER |
| Rated_HP | double | NA |
The mechanical horsepower rating of the motor | No |
NUMBER |
| Rated_SHP | double | Power W |
Shaft Horsepower Rating for an ESP Component. | No |
NUMBER |
| Rated_Voltage | double | Electric_Potential V |
Voltage Rating of Motor Unit | No |
NUMBER |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| Rotor_Count | double | No_Unit |
The number of rotors in an ESP Motor. Note: This number can also hold fractions. | No |
NUMBER |
| 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) |
| Stator_Winding_Code | CODE | NA |
The definition of the Stator winding for an ESP Motor, for example "0050", "0070" | 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 |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| ESP_Motor | ESP_Motor_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 |
| Equipment_Symbol | R_Equipment_Symbol | _ | Restrict | No |