| 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 / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Azimuth | double Plane_Angle |
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 |
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. 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) |
| Inclination | double Plane_Angle |
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 |
Measured depth. | No |
NUMBER |
| 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) |
| North_Offset | double Depth |
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 |
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) |
| TVD | double Depth |
True vertical depth. | No |
NUMBER |
| TWT | double Time |
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 |
| Many | Survey_Point_Status |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Deviation_Survey_Position | Position | The position of a Deviation Survey point expressed in Latitude and Longitude | Control | No |
| 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 |
| Point_Type | R_Survey_Point | The type of point e.g. Measured, derived etc | Restrict | No |
| Deviation_Survey | Deviation_Survey | An association to show which deviation survey points belong with which deviation survey | Cascade | Yes |
| Target | Drill_Target | The drill target associated with the Deviation Survey Point. This is utilized in the planning stages of a borehole | Nullify | No |
| Coordinate_System | Coordinate_System | An association to define the Coordinate System for a Deviation Survey Point | Restrict | No |