| Name | Sucker_Rod_Pump_Condition |
|---|---|
| Entity Type | Extension of Sucker_Rod_Pump |
| Description | Extension class describing the condition of a sucker rod pump and it components |
| Submodel | Artificial_Lift |
| Entity Scope | Project |
| Primary Key | Sucker_Rod_Pump_Id |
| Natural Key | |
| Generalizations | Tracked_Object |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Barrel_Condition | STRING64 NA |
Condition of the barrel | No |
VARCHAR2(64) |
| Condition_Desc | STRING255 NA |
A free form text to describe the condition of the equipment | No |
VARCHAR2(255) |
| Failure_Desc | STRING255 NA |
A free form text to describe the failure of equipment component | No |
VARCHAR2(255) |
| Failure_Reason_Desc | STRING255 NA |
A free form text to describe the reasons for failure of equipment component | No |
VARCHAR2(255) |
| 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) |
| Measuring_Activity_Id | Generic_Wellsite_Activity |
The activity that measured the condition of the sucker rod pump | No |
NUMBER(38) |
| Plug_Condition | STRING64 NA |
Condition of the plug | No |
VARCHAR2(64) |
| Produced_By | STRING64 NA |
ID of the activity that was executing when the entity was created, for data created programmatically. | No |
VARCHAR2(64) |
| SDAT_Label | int No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Start_Date | DATE NA |
Date on which the condition of the pump and/or components are valid. | Yes |
DATE |
| Sucker_Rod_Pump_Id | Sucker_Rod_Pump |
Reference to the pump whose condition is stored. | Yes |
NUMBER(38) |
| 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) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Measuring_Activity | Generic_Wellsite_Activity | The activity that measured the condition of the sucker rod pump | Nullify | No |
| Sucker_Rod_Pump | Sucker_Rod_Pump | Reference to the pump whose condition is stored. | Cascade | Yes |