| Name | Deviation_Survey_Proc_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. A deviation survey is performed on a borehole to trace exactly where in the earth the borehole is located. The Deviation Survey Proc DOV contains information about a survey whose data has been processed and interpreted. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| 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) |
| Bulk_Array_Id | Bulk_Array |
READ ONLY: Unique identifier for the bulk array. | No |
NUMBER(38) |
| CRS | CODE NA |
The projected or geographic coordinate system code. Many coordinate systems are "local". They combine 2-D map coordinates referenced from this CRS attribute with a depth reference provided by R_Vertical_Reference. | No |
VARCHAR2(64) |
| Coordinate_System_Id | Coordinate_System |
READ ONLY: Unique identifier for the coordinate system. | No |
NUMBER(38) |
| Coordinate_System_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) |
| 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) |
| Preferred_Flag | boolean No_Unit |
A flag indicating if the survey is to be used for MD to TVD calculations for this borehole: A value of 1 denotes that it is a preferred survey and 0 means that it is not. Only one processed survey may be designated as preferred. | No |
NUMBER(1) |
| Processed_Date | DATE NA |
The date on which a survey was processed. | No |
DATE |
| Remarks | REMARKS_STR NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Shape | GEOMETRY NA |
Binary spatial representation of the position. | No |
ST_GEOMETRY |
| Survey_Date | DATE NA |
The date the survey was done. | No |
DATE |
| Survey_Mode | CODE NA |
The type of survey run, such as single shot or multi shot. | No |
VARCHAR2(64) |
| Survey_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) |
| Survey_Quality | CODE NA |
The quality of the survey, such as poor or good. | No |
VARCHAR2(64) |
| Survey_Source | STRING64 NA |
Name of the Business_Associate responsible for this entity"s E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User. | No |
VARCHAR2(64) |
| UBHI | WELL_IDENTIFIER NA |
The Unique Identifier assigned to a borehole | Yes |
VARCHAR2(64) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Borehole | Borehole | READ ONLY: Unique identifier for the Borehole. | Cascade | No |
| Coordinate_System | Coordinate_System | READ ONLY: Unique identifier for the coordinate system. | Cascade | No |
| Bulk_Array | Bulk_Array | READ ONLY: Unique identifier for the bulk array. | Cascade | No |
CREATE OR REPLACE VIEW Deviation_Survey_Proc_DOV(ID, UBHI, BOREHOLE_NAME, SURVEY_SOURCE, SURVEY_NAME, PREFERRED_FLAG, COORDINATE_SYSTEM_NAME, CRS, SURVEY_DATE, PROCESSED_DATE, SURVEY_MODE, SURVEY_QUALITY, REMARKS, SHAPE, INSERT_DATE, INSERT_USER, BOREHOLE_ID, BULK_ARRAY_ID, COORDINATE_SYSTEM_ID) AS select ds.Id Id, bh.UBHI UBHI, bh.name Borehole_Name, ds.source Survey_Source, ds.Name Survey_Name, ds.Preferred_Flag Preferred_Flag, cs.Name Coordinate_System_Name, cs.CRS CRS, ds.Survey_Date Survey_Date, ds.Processed_Date Processed_Date, ds.Survey_Mode Survey_Mode, ds.Survey_Quality Survey_Quality, ds.Remarks Remarks, l.Shape Shape, ds.Insert_Date Insert_Date, ds.Insert_User Insert_User, bh.Id Borehole_Id, ba.Id Bulk_Array_Id, cs.Id Coordinate_System_Id from borehole bh, deviation_survey ds, coordinate_system cs, line l, bulk_array ba where bh.id = ds.borehole_id and ds.coordinate_system_id = cs.id and ds.interpretation_status = 'PROC' and ds.deviation_survey_bulk_data_id = ba.id(+) and ds.survey_trajectory_id = l.id (+) |