| Name | Deviation_Survey_Raw_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 Raw DOV contains information about the uninterpreted (i.e., interpretation status = "RAW") survey data. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Azimuth_Reference_Id | Azimuth_Reference |
READ ONLY: Unique identifier for the azimuth reference. | No |
NUMBER(38) |
| Azimuth_Reference_Type | AZIMUTH_REF_TYPE NA |
READ ONLY: Azimuth Reference Type defines the type of North reference against which all deviation survey azimuths are measured. Typical values for azimuth reference type are "True", "Magnetic", "Grid" and "Plant". | No |
VARCHAR2(64) |
| 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 |
Unique identifier for the bulk array. | No |
NUMBER(38) |
| CRS | CODE NA |
READ ONLY: 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 |
Unique identifier for the coordinate system. | Yes |
NUMBER(38) |
| Coordinate_System_Name | ENTITY_NAME NA |
READ ONLY: The name given to any object or data item, e.g. Name of Well, Name of Field, etc | No |
VARCHAR2(255) |
| Declination_Correction | double Plane_Angle |
The declination correction to be added to the raw azimuth to calculate azimuth referenced to true north if NORTH_REFERENCE = "M" | 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) |
| Remarks | REMARKS_STR NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| 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) |
| Tie_In_Azimuth | double Plane_Angle |
The azimuth of the tie in point. | No |
NUMBER |
| Tie_In_East_Offset | double Standard_Depth_Index |
The offset from the origin of the co-ordinate system to the tie-in point in an East-West direction | No |
NUMBER |
| Tie_In_Inclination | double Plane_Angle |
The deviation angle of the tie in point. | No |
NUMBER |
| Tie_In_MD | double Standard_Depth_Index |
The measured depth of the tie in point of the survey from the top-hole location. | No |
NUMBER |
| Tie_In_North_Offset | double Standard_Depth_Index |
The offset from the origin of the co-ordinate system to the tie-in point in an North-South direction | No |
NUMBER |
| Tie_In_Point_Id | Deviation_Survey |
READ ONLY: Unique identifier for the deviation survey. | No |
NUMBER(38) |
| Tie_In_TVD | double Standard_Depth_Index |
True vertical depth. | No |
NUMBER |
| 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 |
| Bulk_Array | Bulk_Array | Unique identifier for the bulk array. | Cascade | No |
| Tie_In_Point | Deviation_Survey | READ ONLY: Unique identifier for the deviation survey. | Cascade | No |
| Azimuth_Reference | Azimuth_Reference | READ ONLY: Unique identifier for the azimuth reference. | Cascade | No |
| Coordinate_System | Coordinate_System | Unique identifier for the coordinate system. | Cascade | Yes |
CREATE OR REPLACE VIEW Deviation_Survey_Raw_DOV(ID, UBHI, BOREHOLE_NAME, SURVEY_SOURCE, SURVEY_NAME, COORDINATE_SYSTEM_ID, COORDINATE_SYSTEM_NAME, CRS, AZIMUTH_REFERENCE_TYPE, DECLINATION_CORRECTION, SURVEY_DATE, SURVEY_MODE, SURVEY_QUALITY, TIE_IN_MD, TIE_IN_AZIMUTH, TIE_IN_INCLINATION, TIE_IN_TVD, TIE_IN_EAST_OFFSET, TIE_IN_NORTH_OFFSET, REMARKS, INSERT_DATE, INSERT_USER, BOREHOLE_ID, BULK_ARRAY_ID, AZIMUTH_REFERENCE_ID, TIE_IN_POINT_ID) AS SELECT ds.Id Id, bh.UBHI UBHI, bh.name Borehole_Name, ds.source Survey_Source, ds.Name Survey_Name, cs.Id Coordinate_System_Id, cs.Name Coordinate_System_Name, cs.CRS CRS, ar.Type Azimuth_Reference_Type, ds.Declination_Correction Declination_Correction, ds.Survey_Date Survey_Date, ds.Survey_Mode Survey_Mode, ds.Survey_Quality Survey_Quality, tip.Tie_In_MD Tie_In_MD, tip.Tie_In_Azimuth Tie_In_Azimuth, tip.Tie_In_Inclination Tie_In_Inclination, tip.Tie_In_TVD Tie_In_TVD, tip.Tie_In_East_Offset Tie_In_East_Offset, tip.Tie_In_North_Offset Tie_In_North_Offset, ds.Remarks Remarks, ds.Insert_Date Insert_Date, ds.Insert_User Insert_User, bh.Id Borehole_Id, ba.Id Bulk_Array_Id, ar.Id Azimuth_Reference_Id, tip.Deviation_Survey_Id Tie_In_Point_Id FROM Borehole bh, Deviation_Survey ds, Coordinate_System cs, Azimuth_Reference ar, Tie_In_Point tip, Bulk_array ba WHERE bh.Id = ds.Borehole_Id and ds.Coordinate_System_Id = cs.Id and cs.Azimuth_Reference_Id = ar.Id (+) and ds.Id = Tip.Deviation_Survey_Id (+) and ds.Interpretation_Status = 'RAW' and ds.Deviation_Survey_Bulk_Data_Id = ba.Id(+) |