| Name | Plug_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. A plug is a rock sample, typically a cylinder, obtained by extraction from an existing rock sample for the purpose of providing a standardized sample for analysis. The Plug DOV provides basic information about plug rock samples such as length, diameter, and orientation. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Acquisition_Date | DATE | NA |
The date and time at which the activity will start or did start. For planned activities, this would be expected start date. | No |
DATE |
| Acquisition_Remarks | REMARKS_STR | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Borehole_Id | Borehole |
|
READ ONLY: Unique identifier for the Borehole. | No |
NUMBER(38) |
| Borehole_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) |
| Core_Acquisition_Id | Conv_Core_Acquisition |
|
READ ONLY: Unique identifier for the Core Acquisition. | No |
NUMBER(38) |
| Core_Base | double | Standard_Depth_Index m |
The depth measurement that represents the base of the rock sample. This is the deepest or last encountered sample depth along the borehole path and is not related to stratigraphic position. | Yes |
NUMBER |
| Core_Id | Core |
|
READ ONLY: Unique identifier for the Core. | No |
NUMBER(38) |
| Core_Inner_Barrel_Type | CODE |
|
A value that represents the type of inner core barrel. | No |
VARCHAR2(64) |
| Core_Top | double | Standard_Depth_Index m |
The depth measurement that represents the top of the rock sample. This is the shallowest or first encountered sample depth along the borehole path and is not related to stratigraphic position. | Yes |
NUMBER |
| Coring_Interval_Base | double | Standard_Depth_Index m |
Measured depth at the end of the activity or proposed depth end of the activity. | No |
NUMBER |
| Coring_Interval_Top | double | Standard_Depth_Index m |
Measured depth at the start of the activity or proposed start depth of the activity. | No |
NUMBER |
| Depth_Adjustment_Id | Rock_Sample_Depth_Adjust |
|
READ ONLY: Unique identifier for the rock sample depth adjustment. | No |
NUMBER(38) |
| Drilling_Fluid | CODE | NA |
The type of fluid that was in the borehole at the time the conventional coring operation. Examples are Water Based, Oil Based, or Gel. | No |
VARCHAR2(64) |
| 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) |
| Plug_Adjusted_Depth_Ref | 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. | No |
VARCHAR2(64) |
| Plug_Adjusted_Top | double | Standard_Depth_Index m |
Adjusted depth of the top of the core interval. | No |
NUMBER |
| Plug_Depth | double | Standard_Depth_Index m |
The depth measurement that represents the top of the rock sample. This is the shallowest or first encountered sample depth along the borehole path and is not related to stratigraphic position. | Yes |
NUMBER |
| Plug_Diameter | double | Cylinder_Diameter mm |
A measurement that represents the diameter of the plug. | No |
NUMBER |
| Plug_Extraction_Date | DATE | NA |
The date that the plug sample was extracted from its parent rock sample. | No |
DATE |
| Plug_Length | double | Length m |
A measurement that represents the length of the longest dimension of the plug.Typically it ranges from one to two inches and cannot be derived from core depth values. | No |
NUMBER |
| Plug_Orientation | CODE |
|
The name of the type of rock sample orientation. A rock sample orientation type describes the direction the sample was extracted with respect to the parent sample. Examples include AXIAL, TRANSVERSE, PERPENDICULAR TO BEDDING, PARALLEL TO BEDDING, NO ORIENTATION, RADIAL and VERTICAL. | No |
VARCHAR2(64) |
| Recovered_Length | double | Length m |
A measurement that represents the length of the core that was recovered from the core acquisition activity. | No |
NUMBER |
| UBHI | WELL_IDENTIFIER | NA |
The Unique Identifier assigned to a borehole | Yes |
VARCHAR2(64) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Borehole | Borehole | READ ONLY: Unique identifier for the Borehole. | Cascade | No |
| Depth_Adjustment | Rock_Sample_Depth_Adjust | READ ONLY: Unique identifier for the rock sample depth adjustment. | Cascade | No |
| Core_Acquisition | Conv_Core_Acquisition | READ ONLY: Unique identifier for the Core Acquisition. | Nullify | No |
| Core | Core | READ ONLY: Unique identifier for the Core. | Nullify | No |
CREATE OR REPLACE FORCE VIEW Plug_DOV(ID, UBHI, BOREHOLE_NAME, CORE_INNER_BARREL_TYPE, ACQUISITION_DATE, CORING_INTERVAL_TOP, CORING_INTERVAL_BASE, RECOVERED_LENGTH, DRILLING_FLUID, CORE_TOP, CORE_BASE, PLUG_DEPTH, PLUG_EXTRACTION_DATE, PLUG_ORIENTATION, PLUG_DIAMETER, PLUG_LENGTH, PLUG_ADJUSTED_DEPTH_REF, PLUG_ADJUSTED_TOP, ACQUISITION_REMARKS, INSERT_DATE, INSERT_USER, BOREHOLE_ID, CORE_ID, CORE_ACQUISITION_ID, DEPTH_ADJUSTMENT_ID) AS SELECT
pl.id Id,
bh.UBHI UBHI,
bh.Name Borehole_Name,
cb.inner_barrel_type Core_Inner_Barrel_Type,
cca.start_date Acquisition_Date,
cca.start_md Coring_Interval_Top,
cca.end_md Coring_Interval_Base,
cca.recovered_length Recovered_Length,
cca.drill_fluid_type Drilling_Fluid,
co.top_depth Core_Top,
co.base_depth Core_Base,
pl.top_depth Plug_Depth,
pl.extraction_date Plug_Extraction_Date,
pl.plug_orient_type Plug_Orientation,
pl.plug_diameter Plug_Diameter,
pl.plug_length Plug_Length,
rsda.adjusted_depth_reference Plug_Adjusted_Depth_Ref,
rsda.adjusted_top_depth Plug_Adjusted_Top,
cca.remarks Acquisition_Remarks,
pl.insert_date Insert_Date,
pl.insert_user Insert_User,
bh.Id Borehole_Id,
co.Id Core_Id,
cca.Id Core_Acquisition_Id,
rsda.Id Depth_Adjustment_Id
from Core co,
Core_Barrel cb,
Borehole bh,
Conv_Core_Acquisition cca,
Plug pl,
Rock_Sample_Depth_Adjust rsda
where bh.Id = co.Borehole_Id
and co.Id = pl.Parent_Rock_Sample_Id
and rsda.Rock_Sample_Id(+) = pl.Id
and co.Conv_Core_Acquisition_Id = cca.Id (+)
and cca.Core_Barrel_Used_Id = cb.Id (+)
|