| Name | Deviation_Survey_Point |
|---|---|
| Entity Type | Table |
| Description | Data for a particular point on a borehole. |
| 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 |
|---|---|---|---|---|---|
| Azimuth | double | Plane_Angle deg |
The azimuth in decimal degrees. | No |
NUMBER |
| Calculation_Method | STRING64 | NA |
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 Point | No |
NUMBER(38) |
| Current_Status | R_Survey_Point_Status |
|
The current status of the deviation survey point. This is a denormalization of the information held in the Survey_Point_Status class | No |
VARCHAR2(64) |
| Current_Status_Date | DATE | NA |
The effective date of the current status value for this deviation survey point. | No |
DATE |
| Deviation_Survey_Id | Deviation_Survey |
|
An association to show which deviation survey points belong with which deviation survey | Yes |
NUMBER(38) |
| Deviation_Survey_Position_Id | Position |
|
The position of a Deviation Survey point expressed in Latitude and Longitude | No |
NUMBER(38) |
| East_Offset | double | Depth m |
The total offset from the originating point of the survey in an East direction. Positive if East, negative if West. Although this is a lateral distance its property has been set to Depth to ensure it has the same unit of measure as depth. | No |
NUMBER |
| 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) |
| Inclination | double | Plane_Angle deg |
The inclination of the borehole. | No |
NUMBER |
| 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) |
| MD | double | Depth m |
Measured depth. | 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) |
| North_Offset | double | Depth m |
The total offset from the originating point of the survey in a North South direction. Positive if North and negative is South. Although this is a lateral distance its property has been set to Depth to ensure it has the same unit of measure as depth. | No |
NUMBER |
| 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) |
| Point_Date | DATE | NA |
The date and time that the point was measured | No |
DATE |
| Point_Type | R_Survey_Point |
|
The type of point e.g. Measured, derived etc | No |
VARCHAR2(64) |
| 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) |
| TVD | double | Depth m |
True vertical depth. | No |
NUMBER |
| TWT | double | Time s |
Two way echo travel time. | No |
NUMBER |
| Target_Id | Drill_Target |
|
The drill target associated with the Deviation Survey Point. This is utilized in the planning stages of a borehole | No |
NUMBER(38) |
| Tool_Code | STRING64 | NA |
The code assigned to a survey station, identifying a set of position uncertainty computation parameters for that station, to be used in computing the position uncertainty of the station, using the uncertainty model assigned to the survey set, that the station is a member of. This is a denormalization of the data held at the survey acquisition level. | No |
VARCHAR2(64) |
| 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) |
| Cardinality | Entity |
|---|---|
| One | Covariance_Matrix |
| One | Deviation_Svy_Point_Raw |
| One | Survey_Point_Correction |
| One | Survey_Point_Detail |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Survey_Point_Status | Survey_Point | The identifier of the Deviation Survey Point to which this status applies. | Cascade | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Deviation_Survey | Deviation_Survey | An association to show which deviation survey points belong with which deviation survey | Cascade | Yes |
| Current_Status | R_Survey_Point_Status | The current status of the deviation survey point. This is a denormalization of the information held in the Survey_Point_Status class | Restrict | No |
| Target | Drill_Target | The drill target associated with the Deviation Survey Point. This is utilized in the planning stages of a borehole | Nullify | No |
| Deviation_Survey_Position | Position | The position of a Deviation Survey point expressed in Latitude and Longitude | Control | No |
| Point_Type | R_Survey_Point | The type of point e.g. Measured, derived etc | Restrict | No |
| Coordinate_System | Coordinate_System | An association to define the Coordinate System for a Deviation Survey Point | Restrict | No |