| Name | Rock_Sample_Depth_Adjust |
|---|---|
| Entity Type | Extension of Rock_Sample |
| Description | Rock sample depth adjustment is the activity of making an adjustment to the depth values specified for a rock sample in the ROCK_SAMPLE.TOP_DEPTH and ROCK_SAMPLE.BASE_DEPTH columns. Examples of the type of depth adjustments that can be made are: 1) adjustments to convert from one depth type to another (ex: loggers depth to drillers depth) 2) adjustments to convert from one depth reference to another (ex: from Kelly bushing to sea level) 3) adjustments to handle core shifts. |
| Submodel | Rock_Sample |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | Top_Depth , Base_Depth , Adjusted_Top_Depth , Adjusted_Base_Depth , Existence_Kind , Version |
| Generalizations | IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Adjusted_Base_Depth | double Depth |
Adjusted depth of the base of the core interval. | Yes |
NUMBER |
| Adjusted_Depth_Reference | CODE NA |
The working reference datum associated with the adjusted depth measurements specified in ADJUSTED_BASE_DEPTH and ADJUSTED_TOP_DEPTH. Examples include Kelly Bushing, and Derrick Floor. | Yes |
VARCHAR2(64) |
| Adjusted_Depth_Type | CODE NA |
A value that specifies whether the depth measurements are in terms of loggers depth or drillers depth. Valid values: LOGGERS, DRILLERS, TVD (for True Vertical Depth). | No |
VARCHAR2(64) |
| Adjusted_Top_Depth | double Depth |
Adjusted depth of the top of the core interval. | Yes |
NUMBER |
| Author | OWNER_NAME NA |
The responsible party for the rock sample depth adjustment. (i.e., the person who made the interpretation for this transformation.) | No |
VARCHAR2(255) |
| Base_Depth | double Depth |
Acquisition measured depth of the base of the core interval being adjusted. | Yes |
NUMBER |
| Depth_Adjustment_Date | DATE NA |
The date on which the depth adjustment was made. | No |
DATE |
| Depth_Adjustment_Reason | R_Depth_Adjustment_Reason |
The purpose for the change in acquisition depth measurement system. | No |
VARCHAR2(64) |
| Depth_Adjustment_Remarks | REMARKS_STR NA |
Free form text comments regarding the depth adjustment interpretation. | No |
VARCHAR2(999) |
| 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) |
| Produced_By | STRING64 NA |
ID of the activity that was executing when the entity was created, for data created programmatically. | No |
VARCHAR2(64) |
| Rock_Sample_Id | Rock_Sample |
The rock sample whose depth measurements are being adjusted. | Yes |
NUMBER(38) |
| SDAT_Label | int No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Top_Depth | double Depth |
Acquisition measured depth of the top of the core interval being adjusted. | Yes |
NUMBER |
| 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Plug_DOV | Depth_Adjustment | READ ONLY: Unique identifier for the rock sample depth adjustment. | Cascade | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Depth_Adjustment_Reason | R_Depth_Adjustment_Reason | The purpose for the change in acquisition depth measurement system. | Restrict | No |
| Rock_Sample | Rock_Sample | The rock sample whose depth measurements are being adjusted. | Cascade | Yes |