| Name | Deviation_Survey |
|---|---|
| Entity Type | Table |
| Description | A survey performed on a borehole to trace exactly where in the earth the borehole is located. |
| Submodel | Deviation_Survey |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | Entity , IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Borehole_Id | Borehole |
The borehole to which the Deviation Survey refers | Yes |
NUMBER(38) |
| Calculation_Method | R_Survey_Calc_Method |
Method of defining the wellbore trajectory based upon directional survey data; includes curve fitting to the survey points and extrapolating beyond them. | No |
VARCHAR2(64) |
| Coordinate_System_Id | Coordinate_System |
An Association to define the Coordinate System for a Deviation Survey | Yes |
NUMBER(38) |
| Declination_Correction | double Plane_Angle |
The declination correction to be added to the raw azimuth to calculate azimuth referenced to true north if the azimuth reference type = "Magnetic" | No |
NUMBER |
| Deviation_Survey_Bulk_Data_Id | Bulk_Array |
An association to allow the storage of a Deviation Survey as a bulk array of data | No |
NUMBER(38) |
| Error_Model_Method | STRING64 NA |
Survey Error Method assigned to this deviation survey row. Examples are Wolff and deWardt, Shell, Simple Cone, Statoil, Topographic. | No |
VARCHAR2(64) |
| Existence_Kind | REF_EXISTENCE_KIND NA |
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. | Yes Actual |
VARCHAR2(64) |
| GUID | STRING128 NA |
Globally Unique IDentifier for an instance of a class. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers. | No |
VARCHAR2(128) |
| 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) |
| Interpretation_Status | R_Survey_Interp_Status |
The interpretation status of the deviation survey. For example Raw, Processed | No |
VARCHAR2(64) |
| Mercury_Method_Tool_Length | double Length |
The survey tool length used for calculation of the trajectory position when the "Mercury" Calculation_Method is used | No |
NUMBER |
| 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) |
| Original_Source | STRING64 NA |
The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15" | No |
VARCHAR2(64) |
| Parent_Survey_Id | Deviation_Survey |
Relationship to show the parent of a decimated survey | No |
NUMBER(38) |
| Preferred_Flag | boolean NA |
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 |
| Produced_By | STRING64 NA |
ID of the activity that was executing when the entity was created, for data created programmatically. | No |
VARCHAR2(64) |
| Remarks | STRING2000 NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(2000) |
| SDAT_Label | int No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Source | STRING64 NA |
Name of the person or organization 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) |
| Survey_Acquisition_Id | Deviation_Survey_Acq |
The activity that captured the deviation survey | No |
NUMBER(38) |
| Survey_Date | DATE NA |
The date the survey was done. | No |
DATE |
| Survey_Mode | R_Survey_Mode |
The type of survey run, such as single shot or multi shot. | No |
VARCHAR2(64) |
| Survey_Quality | CODE NA |
The quality of the survey, such as poor or good. | No |
VARCHAR2(64) |
| Survey_Trajectory_Id | Line |
The spatial representation of the deviation survey | No |
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) |
| Version | STRING255 NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| Vertical_Section_Id | Vertical_Section |
The vertical section used to display this deviation survey | No |
NUMBER(38) |
| Cardinality | Entity |
|---|---|
| One | Tie_In_Point |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Borehole | Legal_Survey | An association used to define the Legal Survey for a Borehole | Restrict | No |
| Borehole | Preferred_Survey | An association used to define the Preferred Survey for a particular borehole | Restrict | No |
| Checkshot_Survey | Original_Deviation_Survey | The original deviation survey used for processing the checkshot survey. | Nullify | No |
| Deviation_Survey | Parent_Survey | Relationship to show the parent of a decimated survey | Nullify | No |
| Deviation_Survey_Point | Deviation_Survey | An association to show which deviation survey points belong with which deviation survey | Cascade | Yes |
| Deviation_Survey_Raw_DOV | Tie_In_Point | READ ONLY: Unique identifier for the deviation survey. | Cascade | No |
| Log_Channel_Set | Utilized_Survey | The deviation survey that provides the preferred 3-D location positions for properties in this log channel set. | Restrict | No |
| Study_Deviation_Survey | Deviation_Survey | The identifier of a deviation survey that is an element of the study. | Nullify | No |
| Survey_Composition | Part_Survey | The part survey. The component part of a composite survey. | Cascade | Yes |
| Survey_Composition | Whole_Survey | The whole survey. That is the survey that is composed of parts of other surveys. | Cascade | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Survey_Acquisition | Deviation_Survey_Acq | The activity that captured the deviation survey | Nullify | No |
| Parent_Survey | Deviation_Survey | Relationship to show the parent of a decimated survey | Nullify | No |
| Interpretation_Status | R_Survey_Interp_Status | The interpretation status of the deviation survey. For example Raw, Processed | Restrict | No |
| Deviation_Survey_Bulk_Data | Bulk_Array | An association to allow the storage of a Deviation Survey as a bulk array of data | Control | No |
| Survey_Trajectory | Line | The spatial representation of the deviation survey | Control | No |
| Calculation_Method | R_Survey_Calc_Method | Method of defining the wellbore trajectory based upon directional survey data; includes curve fitting to the survey points and extrapolating beyond them. | Restrict | No |
| Borehole | Borehole | The borehole to which the Deviation Survey refers | Cascade | Yes |
| Vertical_Section | Vertical_Section | The vertical section used to display this deviation survey | Nullify | No |
| Survey_Mode | R_Survey_Mode | The type of survey run, such as single shot or multi shot. | Restrict | No |
| Coordinate_System | Coordinate_System | An Association to define the Coordinate System for a Deviation Survey | Restrict | Yes |