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 / Measurement	Description	Required / Default	Type
API_Oil_Gravity	double API_Oil_Gravity	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	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	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	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	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	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	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	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	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	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 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 © 2009 Schlumberger. All rights reserved.