| Name | Well_Completion_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. The Well Completion DOV describes an assembly of equipment that enables production from reservoirs into a production string. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Base_Interval_MD | double | Standard_Depth_Index m |
The current measured depth from the surface to the base of the completion. | No |
NUMBER |
| Borehole_Id | Borehole |
|
READ ONLY: Unique identifier for the Borehole. | No |
NUMBER(38) |
| Borehole_Name | ENTITY_NAME | NA |
The name given to any object or data item, e.g. Name of Well, Name of Field, etc. | No |
VARCHAR2(255) |
| Completion_Name | ENTITY_NAME | NA |
The name given to any object or data item, e.g. Name of Well, Name of Field, etc. | Yes |
VARCHAR2(255) |
| Driller_Reference_MD | double | Standard_Depth_Index m |
The reference depth entered by the driller for this completion. | No |
NUMBER |
| Id | ID | No_Unit |
Unique identifier for this entity. | Yes |
NUMBER(38) |
| 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) |
| Isolation_Location | CODE | NA |
When a completion is isolated from the rest of the borehole, this value specifies whether the isolation is above the completion, below the completion, or both. Valid values are above, below, or both. | No |
VARCHAR2(64) |
| Production_Entity_Id | Production_Entity |
|
READ ONLY: Unique identifier for the production entity. | No |
NUMBER(38) |
| Remarks | REMARKS_STR | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Top_Interval_MD | double | Standard_Depth_Index m |
The current measured depth from the surface to the top of the completion. | No |
NUMBER |
| Tubing_String_Id | Tubing_String |
|
READ ONLY: Unique identifier for the Tubing String. | No |
NUMBER(38) |
| Tubing_String_Name | ENTITY_NAME | NA |
The name given to any object or data item, e.g. Name of Well, Name of Field, etc. | No |
VARCHAR2(255) |
| UBHI | WELL_IDENTIFIER | NA |
The Unique Identifier assigned to a borehole | Yes |
VARCHAR2(64) |
| Well_Completion_Type | CODE |
|
A value that describes a type of well completion. Example values are: Open Hole, Gravel packed, etc. | No |
VARCHAR2(64) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Borehole | Borehole | READ ONLY: Unique identifier for the Borehole. | Cascade | No |
| Production_Entity | Production_Entity | READ ONLY: Unique identifier for the production entity. | Cascade | No |
| Tubing_String | Tubing_String | READ ONLY: Unique identifier for the Tubing String. | Nullify | No |
CREATE OR REPLACE FORCE VIEW Well_Completion_DOV(ID, UBHI, BOREHOLE_NAME, COMPLETION_NAME, TOP_INTERVAL_MD, BASE_INTERVAL_MD, TUBING_STRING_NAME, WELL_COMPLETION_TYPE, DRILLER_REFERENCE_MD, ISOLATION_LOCATION, REMARKS, INSERT_DATE, INSERT_USER, BOREHOLE_ID, TUBING_STRING_ID, PRODUCTION_ENTITY_ID) AS SELECT wc.Id Id, bh.UBHI UBHI, bh.Name Borehole_Name, wc.name Completion_Name, wc.Top_Interval_MD Top_Interval_MD, wc.Base_Interval_MD Base_Interval_MD, ts.name Tubing_String_Name, wc.Well_Completion_Type Well_Completion_Type, wc.Driller_Reference_MD Driller_Reference_MD, wc.Isolation_Location Isolation_Location, wc.Remarks Remarks, wc.Insert_Date Insert_Date, wc.Insert_User Insert_User, bh.Id Borehole_Id, ts.Id Tubing_String_Id, pe.Id Production_Entity_Id FROM borehole bh, well_completion wc, production_entity pe, tubing_string ts WHERE bh.id = wc.borehole_id AND wc.tubing_string_id = ts.id (+) AND wc.id = pe.well_completion_id(+) AND 'Well_Completion' = Production_Entity_Subtype(+) |