| 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 | Property / Storage Unit | 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 deg |
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. USAGE NOTES: There are two cases: 1) GUID is not populated or used; and 2) it is populated with a value that is globally unique. If the GUID is populated there are two means of doing so for a given project: 2a) Seabed automatically generates and populates the GUID when an instance is created (valid only on Oracle based systems); and 2b) the GUID is generated and populated by an application (other than Seabed) on instance creation. Whether Seabed automatically generates GUIDs for a project is determined by the Auto_GUID flag in SDS_Account. Note that techniques 2a and 2b can coexist in the same project. When GUIDs are automatically generated an application can override the automatically generated GUID with its own GUID by simply supplying the GUID value. Applications that generate their own GUIDs and populate the GUID column will function correctly on projects which have automatic GUID generation turned on. | 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) |
| Maximum_Inclination | double | Plane_Angle deg |
The maximum inclination reached in this survey. This is a calculated attribute and is stored here for convenience. | No |
NUMBER |
| Mercury_Method_Tool_Length | double | Length m |
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 |
The name of application role that created the entity, 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 entitys 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 | Proposed_Trajectory |
| One | Tie_In_Point |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Borehole | Preferred_Survey | The identifier of the Preferred Survey for a particular borehole. | Restrict | No |
| Borehole | Legal_Survey | The identifier of the Legal Survey for this 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 | Whole_Survey | The whole survey. That is the survey that is composed of parts of other surveys. | Cascade | Yes |
| Survey_Composition | Part_Survey | The part survey. The component part of a composite survey. | Cascade | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Vertical_Section | Vertical_Section | The vertical section used to display this deviation survey | Nullify | No |
| Survey_Trajectory | Line | The spatial representation of the deviation survey | Control | No |
| Survey_Mode | R_Survey_Mode | The type of survey run, such as single shot or multi shot. | Restrict | No |
| Survey_Acquisition | Deviation_Survey_Acq | The activity that captured the deviation survey | Nullify | 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 |
| 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 |
| Coordinate_System | Coordinate_System | An Association to define the Coordinate System for a Deviation Survey | Restrict | Yes |
| Borehole | Borehole | The borehole to which the Deviation Survey refers | Cascade | Yes |
| Parent_Survey | Deviation_Survey | Relationship to show the parent of a decimated survey | Nullify | No |