| Name | R_ESP_Protector_Cat |
|---|---|
| Entity Type | Table |
| Description | Catalog data of ESP Protector |
| 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 / 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) |
| Catalog_Number | STRING64 NA |
A catalog or part number for a facility. | No |
VARCHAR2(64) |
| Chamber_Count | int No_Unit |
Number of chambers in an ESP protector | No |
NUMBER(10) |
| 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) |
| Elastomer_Material | CODE NA |
Polymers used in ESP devices to provide elasticity, for example: "AFLAS", "HSN" | No |
VARCHAR2(64) |
| 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) |
| Housing_Metallurgy | CODE NA |
The metallurgy of the Housing of an ESP component. | No |
VARCHAR2(64) |
| Length | double Length |
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 | CODE NA |
The spelled-out name of the reference value. | No |
VARCHAR2(64) |
| Protector_Type | CODE NA |
A classification to identify a major grouping of ESP protectors, for example "BSBSL" | Yes |
VARCHAR2(64) |
| Rated_SHP | double Power |
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 |
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) |
| Thrust_Bearing_Type | CODE NA |
The code for thrust bearing type of ESP protectors, for example "HL", "STB", "KTB", "NTB" | 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 |
Weight of an ESP component. | No |
NUMBER |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| ESP_Protector | ESP_Protector_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 |