Plug_Analysis_DOV


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name Plug_Analysis_DOV
Entity Type ObjectView
Description Data Object View. The Plug Analysis DOV provides basic information about the analysis of the properties of a plug rock sample such as porosity and density.
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
Air_Permeability double Permeability
mD
A measure that represents the ability of air to flow through a rock sample when the sample is only saturated with air. No
NUMBER
Analysis_Order_Number int NA
A number that identifies the order that the analysis was performed on the sample. No
NUMBER(10)
Analyst_Names STRING255 NA
Free-form text used to specify the analyst or list of analysts who performed the analysis. No
VARCHAR2(255)
Analyzing_Company CODE NA
The name of the lab who performed the sample analysis. No
VARCHAR2(64)
Basic_Analysis_Result_Set_Id Basic_Analysis_Result_Set
READ ONLY: Unique identifier for the basic analysis result. No
NUMBER(38)
Basic_Core_Analysis_Id Basic_Core_Analysis
READ ONLY: Unique identifier for the basic core analysis. No
NUMBER(38)
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_Id Core
READ ONLY: Unique identifier for the Core. No
NUMBER(38)
Core_Top_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
Date_Of_Analysis DATE NA
The date and time at which the activity will end or did end. For planned activities, this would be expected end date. Yes
DATE
Gas_Saturation_Volume double Volume
m3
A measurement that represents the percent of gas saturation. No
NUMBER
Grain_Density double Density
g/cm3
A measurement that represents the grain density of the core sample. Grain density is the unit volume of minerals with zero porosity. No
NUMBER
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)
Laboratory_File_Number CODE NA
The file number assigned to the analysis by the lab. No
VARCHAR2(64)
Lithology_Description REMARKS_STR NA
The Lithologic Description as revealed via sample analysis by a lab analyst. (As opposed to a lithologic description revealed via a lith log or via sight-analysis at the well site.) No
VARCHAR2(999)
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_Id Plug
READ ONLY: Unique identifier for the plug. No
NUMBER(38)
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)
Plug_Quality REMARKS_STR NA
Text used to describe a lab analysts interpretation of the state of a sample at the time of analysis. For example, whether the oil/salt has been extracted, etc.. No
VARCHAR2(999)
Pore_Volume_Oil double Volume
m3
A measurement that represents the percentage volume of oil saturation in the pore spaces of the core sample (residual oil saturation). No
NUMBER
Pore_Volume_Water double Volume
m3
A measurement that represents the percentage of water in a unit volume. No
NUMBER
Porosity double Porosity
m3/m3
A measurement that represents the percent volume of pore space in a sample with a capacity for storing fluids. No
NUMBER
Rock_Sample_Analysis_Prep_Id Rock_Sample_Analysis_Prep
READ ONLY: Unique identifier for the rock sample analysis preparation. No
NUMBER(38)
Rock_Sample_Preparation_Id Rock_Sample_Preparation
READ ONLY: Unique identifier for the rock sample preparation. No
NUMBER(38)
Sample_Prep_Order_Number int No_Unit
A number that identifies the order that the preparation method was performed on the sample. I.e., if this is the 1st time this preparation method was performed on this sample, the value should be "1". If it is the 2nd time, the value should be "2", etc. The value should start over at "1" for each new preparation method performed on this sample. No
NUMBER(10)
Sample_Preparation_Method CODE
The sample preparation method utilized to prepare this rock sample for analysis. Examples include convection oven drying, flow-through cleaning, and rock sample staining. No
VARCHAR2(64)
UBHI WELL_IDENTIFIER NA
The Unique Identifier assigned to a borehole Yes
VARCHAR2(64)


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Borehole Borehole READ ONLY: Unique identifier for the Borehole. Cascade No
Plug Plug READ ONLY: Unique identifier for the plug. Cascade No
Core Core READ ONLY: Unique identifier for the Core. Nullify No
Basic_Analysis_Result_Set Basic_Analysis_Result_Set READ ONLY: Unique identifier for the basic analysis result. Cascade No
Basic_Core_Analysis Basic_Core_Analysis READ ONLY: Unique identifier for the basic core analysis. Cascade No
Rock_Sample_Analysis_Prep Rock_Sample_Analysis_Prep READ ONLY: Unique identifier for the rock sample analysis preparation. Cascade No
Rock_Sample_Preparation Rock_Sample_Preparation READ ONLY: Unique identifier for the rock sample preparation. Cascade No


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Plug_Analysis_DOV(ID, UBHI, BOREHOLE_NAME, CORE_TOP_DEPTH, PLUG_DEPTH, PLUG_ORIENTATION, SAMPLE_PREPARATION_METHOD, SAMPLE_PREP_ORDER_NUMBER, ANALYSIS_ORDER_NUMBER, ANALYST_NAMES, DATE_OF_ANALYSIS, LABORATORY_FILE_NUMBER, ANALYZING_COMPANY, PLUG_QUALITY, LITHOLOGY_DESCRIPTION, PORE_VOLUME_WATER, GAS_SATURATION_VOLUME, GRAIN_DENSITY, AIR_PERMEABILITY, PORE_VOLUME_OIL, POROSITY, INSERT_DATE, INSERT_USER, BOREHOLE_ID, PLUG_ID, CORE_ID, ROCK_SAMPLE_PREPARATION_ID, BASIC_CORE_ANALYSIS_ID, ROCK_SAMPLE_ANALYSIS_PREP_ID, BASIC_ANALYSIS_RESULT_SET_ID) AS SELECT
 bca.id                       Id,
 bh.UBHI                      UBHI,
 bh.Name                      Borehole_Name,
 co.top_depth                 Core_Top_Depth,
 pl.top_depth			Plug_Depth,
 pl.plug_orient_type		Plug_Orientation,
 rsp.preparation_method       Sample_Preparation_Method,
 rsp.prep_method_order_number Sample_Prep_Order_Number,
 bca.analysis_order_number    Analysis_Order_Number,
 
bca.analyst_list_txt         Analyst_Names,
 bca.start_date               Date_Of_Analysis,
 bca.lab_file_number          Laboratory_File_Number,
 bca.lab_name                 Analyzing_Company,
 bca.sample_state_desc        Plug_Quality,
 bars.analysis_lithology_desc Lithology_Description,
 bars.bulk_volume_water       Pore_Volume_Water,
 bars.gas_sat_vol             Gas_Saturation_Volume,
 bars.grain_density           Grain_Density,
 bars.perm_air                Air_permeability,
 bars.pore_volume_oil         Pore_Volume_Oil,
 bars.porosity                Porosity,
 bca.insert_date              Insert_Date,
 bca.insert_user              Insert_User,
 bh.Id			      Borehole_Id,
 pl.Id			      Plug_Id,
 co.Id                        Core_Id,
 rsp.Id			      Rock_Sample_Preparation_Id,
 bca.Id                       Basic_Core_Analysis_Id,
 rsap.Id                      Rock_Sample_Analysis_Prep_Id,
 bars.Basic_Core_Analysis_Id  Basic_Analysis_Result_Set_Id
from  Core                    
co,
      Basic_Core_Analysis     bca,
      Borehole		      bh,
      Plug		      pl,
      Rock_Sample_Preparation rsp,
      Rock_Sample_Analysis_Prep rsap,
      Basic_Analysis_Result_Set bars
where bh.Id = co.Borehole_Id
  and co.Id = pl.parent_rock_sample_id
  and pl.Id = bca.Rock_Sample_Id
  and bars.basic_core_analysis_id = bca.Id
  and rsap.Rock_Sample_Analysis_Id (+) = bca.Id
  and rsp.Id(+) = rsap.Rock_Sample_Preparation_Id
  and rsap.Rock_Sample_Analysis_Tbl (+) = 'Basic_Core_Analysis'
  and bca.basic_core_analysis_type='Basic Core Plug Analysis'

   


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.