| Name | R_ESP_Cable_Cat |
|---|---|
| Entity Type | Table |
| Description | Catalog data for Main Power Cable and ESP Motor Flat Cable. |
| Submodel | Artificial_Lift |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | |
| Generalizations | 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) |
| Armor_Type | CODE NA |
Armor metal protection of ESP cables, for example "Double Galvanized" | No |
VARCHAR2(64) |
| Cable_Profile | CODE NA |
The profile of the cable. For example is it round or flat. | No |
VARCHAR2(64) |
| Cable_Type | CODE NA |
Type of ESP cable, for example "EER", "ELTB" | Yes |
VARCHAR2(64) |
| 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) |
| Conductor_Size | double No_Unit |
The size of the conductor in the cable. | No |
NUMBER |
| Conductor_Size_Unit | CODE NA |
The unit for the size of the conductor. For example AWG for American Wire Gauge. | No |
VARCHAR2(64) |
| Description | STRING2000 NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Engineering_Code | STRING128 NA |
A code containing concatenated attributes of equipment. The structure will vary with each equipment type. | No |
VARCHAR2(128) |
| Insulation_Description | CODE NA |
Short description of Cable Insulation | No |
VARCHAR2(64) |
| Length | double Length |
Length of ESP Cable | 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) |
| Pigtail_Description | CODE NA |
Short Description of Pigtail | No |
VARCHAR2(64) |
| Pothead_Type | CODE NA |
The type of connector between the motor and the power cable/motor lead. | No |
VARCHAR2(64) |
| Rated_Voltage | double Electric_Potential |
The maximum voltage that this cable can safely hold | No |
NUMBER |
| Ref_Id | ID No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| Series_Name | CODE NA |
The Series Name of the motor lead or the ESP cable | 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) |
| Splice_Count | int No_Unit |
Number of Cable Splices | No |
NUMBER(10) |
| 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) |
| 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| ESP_Cable | ESP_Cable_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 |