Oil_Fluid_Analysis_DOV

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

Name	Oil_Fluid_Analysis_DOV
Entity Type	ObjectView
Description	Data Object View. The Oil Fluid Analysis DOV contains information about a set of laboratory procedures performed to identify the physical properties of oil samples.
Submodel	Data_Object
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations
Specializations

Columns

[Previous] [Next] [Top]

Name	Value Domain	Property / Storage Unit	Description	Required / Default	Type
API_Oil_Gravity	double	API_Oil_Gravity dAPI	API gravity of Oil. The measure of the density of liquid petroleum products; derived from relative density in accordance with the following equation: API Gravity at 60 degrees F = [141.5 /relative density at 60 degrees F] - 131.5. API Gravity is expressed in degrees API, 10 degrees API being equivalent to 1.0, the relative density of water."	No	NUMBER
Analysis_Date	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
Analysis_Lab	STRING64	NA	The lab who performed the analysis.	No	VARCHAR2(64)
Analysis_Lab_Id	Company		READ ONLY: Unique identifier for the Analysis Lab Company.	No	NUMBER(38)
Analysis_Temperature	double	Temperature degC	The temperature that the analysis was performed at.	No	NUMBER
Analyzed_By	STRING64	NA	Business_Associate, or project source that originally provided this entity, e.g. "IHS-EnergyData" or "Finder\Upper Stratton Deeper Pool 15"	No	VARCHAR2(64)
BSW	double	Dimensionless	The fraction of the sample that this material represents calculated on a volumetric basis	No	NUMBER
BSW_Id	Material_Composition		READ ONLY: Material composition identifier.	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)
Completion_Name	ENTITY_NAME	NA	The name given to any object or data item, e.g. Name of Well, Name of Field, etc.	Yes	VARCHAR2(255)
Density	double	Density g/cm3	The density of the sample.	No	NUMBER
Fluid_Non_State_Pty_Set_Id	Fluid_Non_State_Pty_Set		READ ONLY: Unique identifier for the Fluid Non State Property Set.	No	NUMBER(38)
Fluid_Sample_Acquisition_Id	Fluid_Sample_Acquisition		READ ONLY: Unique identifier for the Fluid_Sample Acquisition.	No	NUMBER(38)
Fluid_Sample_Id	Fluid_Sample		READ ONLY: Unique identifier for the Fluid Sample.	No	NUMBER(38)
Fluid_State_Pty_Set_Id	Fluid_State_Pty_Set		READ ONLY: Unique identifier for the Fluid State Property Set.	No	NUMBER(38)
GOR	double	Gas_To_Liquid_Ratio m3/m3	The Gas to Oil Ratio.	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)
Pour_Point_Temperature	double	Temperature degC	The lowest temperature which permits a standard volume of product flow through an orifice in a specified time at atmospheric pressure.	No	NUMBER
Reid_Vapor_Pressure	double	Pressure kPa	The vapor pressure measured at 100 degrees farenheit.	No	NUMBER
Remarks	REMARKS_STR	NA	Any type of remarks added to an entity instance.	No	VARCHAR2(999)
Salt_Content	double	Mass_Per_Volume kg/m3	The concentration of the material in the sample	No	NUMBER
Salt_Content_Id	Material_Composition		READ ONLY: Material composition identifier.	No	NUMBER(38)
Sampling_Date	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
Sulfur_Content	double	Mass_Per_Volume kg/m3	The concentration of the material in the sample	No	NUMBER
Sulfur_Content_Id	Material_Composition		READ ONLY: Material composition identifier.	No	NUMBER(38)
True_Vapor_Pressure	double	Pressure kPa	The pressure of the vapor over a liquid at equilibrium.	No	NUMBER
Tubing_String_Id	Tubing_String		READ ONLY: Unique identifier for the Tubing String.	No	NUMBER(38)
Tubing_String_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)
UBHI	WELL_IDENTIFIER	NA	The Unique Identifier assigned to a borehole	Yes	VARCHAR2(64)
Viscosity	double	Dynamic_Viscosity cP	A measure of the resistance of the sample to flow.	No	NUMBER
Well_Completion_Id	Well_Completion		READ ONLY: Unique identifier for the Well Completion.	No	NUMBER(38)

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Borehole	Borehole	READ ONLY: Unique identifier for the Borehole.	Cascade	No
Well_Completion	Well_Completion	READ ONLY: Unique identifier for the Well Completion.	Cascade	No
Tubing_String	Tubing_String	READ ONLY: Unique identifier for the Tubing String.	Nullify	No
Fluid_Sample	Fluid_Sample	READ ONLY: Unique identifier for the Fluid Sample.	Cascade	No
Fluid_Sample_Acquisition	Fluid_Sample_Acquisition	READ ONLY: Unique identifier for the Fluid_Sample Acquisition.	Cascade	No
BSW	Material_Composition	READ ONLY: Material composition identifier.	Cascade	No
Fluid_State_Pty_Set	Fluid_State_Pty_Set	READ ONLY: Unique identifier for the Fluid State Property Set.	Cascade	No
Analysis_Lab	Company	READ ONLY: Unique identifier for the Analysis Lab Company.	Nullify	No
Sulfur_Content	Material_Composition	READ ONLY: Material composition identifier.	Cascade	No
Salt_Content	Material_Composition	READ ONLY: Material composition identifier.	Cascade	No
Fluid_Non_State_Pty_Set	Fluid_Non_State_Pty_Set	READ ONLY: Unique identifier for the Fluid Non State Property Set.	Cascade	No

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW Oil_Fluid_Analysis_DOV(ID, UBHI, BOREHOLE_NAME, COMPLETION_NAME, TUBING_STRING_NAME, SAMPLING_DATE, ANALYSIS_DATE, ANALYZED_BY, ANALYSIS_LAB, GOR, DENSITY, SULFUR_CONTENT, ANALYSIS_TEMPERATURE, API_OIL_GRAVITY, REID_VAPOR_PRESSURE, TRUE_VAPOR_PRESSURE, BSW, SALT_CONTENT, VISCOSITY, POUR_POINT_TEMPERATURE, REMARKS, INSERT_DATE, INSERT_USER, BOREHOLE_ID, WELL_COMPLETION_ID, TUBING_STRING_ID, FLUID_SAMPLE_ID, FLUID_SAMPLE_ACQUISITION_ID, FLUID_NON_STATE_PTY_SET_ID, FLUID_STATE_PTY_SET_ID, ANALYSIS_LAB_ID, SULFUR_CONTENT_ID, SALT_CONTENT_ID, BSW_ID) AS SELECT
 fa.id                        Id,
 bh.UBHI                      UBHI,
 bh.Name                      Borehole_Name,
 wc.name		      Completion_Name,
 ts.name                      Tubing_String_Name,
 fsa.end_date                 Sampling_Date,
 fa.start_date                Analysis_Date,
 fa.original_source           Analyzed_By,
 co.name                      Analysis_Lab,
 fsps.gor                     
GOR,
 fsps.density                 Density,
 mc1.concentration            Sulfur_Content,
 fa.analysis_temperature      Analysis_Temperature,
 fsps.API_Oil_Gravity         API_Oil_Gravity,
 fnsps.reid_vapor_pressure    Reid_Vapor_Pressure,
 fsps.vapor_pressure          True_Vapor_Pressure,
 mc3.volume_fraction          BSW,
 mc2.concentration            Salt_Content,
 fsps.viscosity               Viscosity,
 fnsps.pour_point_temperature Pour_Point_Temperature,
 fa.remarks                   Remarks,
 fa.insert_date               Insert_Date,
 fa.insert_user               Insert_User,
 bh.Id                        Borehole_Id,
 wc.Id                        Well_Completion_Id,
 ts.Id                        Tubing_String_Id,
 fs.Id                        Fluid_Sample_Id,
 fsa.Id                       Fluid_Sample_Acquisition_Id,
 fnsps.Id                     Fluid_Non_State_Pty_Set_Id,
 fsps.Id                      Fluid_State_Pty_Set_Id,
 co.Id                        Analysis_Lab_Id,
 
mc1.Id                       Sulfur_Content_Id,
 mc2.Id                       Salt_Content_Id,
 mc3.Id                       BSW_Id
from fluid_analysis           fa,
     fluid_sample             fs,
     borehole                 bh,
     well_completion          wc,
     tubing_string            ts,
     fluid_state_pty_set      fsps,
     fluid_non_state_pty_set  fnsps,
     fluid_sample_acquisition fsa,
     company                  co,
     material_composition     mc1,
     material_composition     mc2,
     material_composition     mc3
where bh.id = wc.borehole_id
  and wc.tubing_string_id = ts.id (+)
  and wc.id = fsa.acquired_from_facility_id
  and fsa.acquired_from_facility_tbl = 'Well_Completion'
  and fs.fluid_acquisition_id = fsa.id
  and fa.fluid_sample_id = fs.id
  and fsps.fluid_analysis_id(+) = fa.id
  and fnsps.fluid_analysis_id(+) = fa.id
  and fa.analysis_lab_id = co.id(+)
  and fa.analysis_method = 'Oil Analysis'
  and fs.material_type = 'Oil'
  and 
mc1.fluid_analysis_id(+) = fa.id
  and mc1.component_material_type(+) = 'Sulfur'
  and mc2.fluid_analysis_id(+) = fa.id
  and mc2.component_material_type(+) = 'Salt'
  and mc3.fluid_analysis_id(+) = fa.id
  and mc3.component_material_type(+) = 'BSW'

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

Oil_Fluid_Analysis_DOV

Copyright © 2018 Schlumberger. All rights reserved.