Gas_Fluid_Analysis_DOV


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

General Information

[Next]
Name Gas_Fluid_Analysis_DOV
Entity Type ObjectView
Description Data Object View. The Gas Fluid Analysis DOV contains information about a set of laboratory procedures performed to identify the physical properties of gas samples. For example, a fluid analysis might be performed to determine the concentration of carbon dioxide in a gas sample.
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
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 ENTITY_NAME NA
The name given to any object or data item, e.g. Name of Well, Name of Field, etc. No
VARCHAR2(255)
Analysis_Lab_Id Company
READ ONLY: Unique identifier for the Analysis Lab Company. No
NUMBER(38)
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)
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)
C1 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
C1_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
C2 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
C2_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
C3 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
C3_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
C6plus double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
C6plus_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
CO2 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
CO2_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
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)
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)
Gas_Specific_Gravity double Dimensionless
The ratio of the weight of a given volume of the material at a given temperature to the weight of an equal volume of a standard substance at the same temperature. In determining the specific gravity of gases, the comparison is made with the standard of air or hydrogen. No
NUMBER
H2S double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
H2S_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
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)
Molecular_Weight double Dimensionless
The sum of all the atomic weights of the constituent atoms of a molecule of the fluid. No
NUMBER
N2 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
N2_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
O2 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
O2_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
Remarks REMARKS_STR NA
Any type of remarks added to an entity instance. No
VARCHAR2(999)
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
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)
Well_Completion_Id Well_Completion
READ ONLY: Unique identifier for the Well Completion. No
NUMBER(38)
iC4 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
iC4_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
iC5 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
iC5_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
nC4 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
nC4_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)
nC5 double Dimensionless
The fraction of the sample that this material represents calculated on a mole basis No
NUMBER
nC5_Id Material_Composition
READ ONLY: Material composition identifier. No
NUMBER(38)


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Borehole Borehole READ ONLY: Unique identifier for the Borehole. Cascade No
C6plus Material_Composition READ ONLY: Material composition identifier. Cascade No
Fluid_Sample Fluid_Sample READ ONLY: Unique identifier for the Fluid Sample. Cascade No
Fluid_State_Pty_Set Fluid_State_Pty_Set READ ONLY: Unique identifier for the Fluid State Property Set. 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
Fluid_Sample_Acquisition Fluid_Sample_Acquisition READ ONLY: Unique identifier for the Fluid_Sample Acquisition. Cascade No
Analysis_Lab Company READ ONLY: Unique identifier for the Analysis Lab Company. Nullify No
C1 Material_Composition READ ONLY: Material composition identifier. Cascade No
C2 Material_Composition READ ONLY: Material composition identifier. Cascade No
C3 Material_Composition READ ONLY: Material composition identifier. Cascade No
iC4 Material_Composition READ ONLY: Material composition identifier. Cascade No
nC4 Material_Composition READ ONLY: Material composition identifier. Cascade No
iC5 Material_Composition READ ONLY: Material composition identifier. Cascade No
nC5 Material_Composition READ ONLY: Material composition identifier. Cascade No
CO2 Material_Composition READ ONLY: Material composition identifier. Cascade No
O2 Material_Composition READ ONLY: Material composition identifier. Cascade No
N2 Material_Composition READ ONLY: Material composition identifier. Cascade No
H2S Material_Composition READ ONLY: Material composition identifier. Cascade No
Well_Completion Well_Completion READ ONLY: Unique identifier for the Well Completion. Cascade No


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Gas_Fluid_Analysis_DOV(ID, UBHI, BOREHOLE_NAME, COMPLETION_NAME, TUBING_STRING_NAME, SAMPLING_DATE, ANALYSIS_DATE, ANALYZED_BY, ANALYSIS_LAB, C1, C2, C3, IC4, NC4, IC5, NC5, C6PLUS, CO2, O2, N2, H2S, GAS_SPECIFIC_GRAVITY, MOLECULAR_WEIGHT, REMARKS, INSERT_DATE, INSERT_USER, BOREHOLE_ID, WELL_COMPLETION_ID, FLUID_SAMPLE_ID, FLUID_STATE_PTY_SET_ID, FLUID_NON_STATE_PTY_SET_ID, FLUID_SAMPLE_ACQUISITION_ID, ANALYSIS_LAB_ID, C1_ID, C2_ID, C3_ID, IC4_ID, NC4_ID, IC5_ID, NC5_ID, CO2_ID, O2_ID, N2_ID, H2S_ID, C6PLUS_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,
  mc1.mole_fraction            C1,
  mc2.mole_fraction     
       C2,
  mc3.mole_fraction            C3,
  mc4.mole_fraction            iC4,
  mc5.mole_fraction            nC4,
  mc6.mole_fraction            iC5,
  mc7.mole_fraction            nC5,
  mc12.mole_fraction           C6plus,
  mc8.mole_fraction            CO2,
  mc9.mole_fraction            O2,
  mc10.mole_fraction           N2,
  mc11.mole_fraction           H2S,
  fsps.specific_gravity        Gas_Specific_Gravity,
  fnsps.molecular_weight       Molecular_weight,
  fa.remarks                   Remarks,
  fa.insert_date               Insert_Date,
  fa.insert_user               Insert_User,
  bh.Id                        Borehole_Id,
  wc.Id                        Well_Completion_Id,
  fs.id                        Fluid_Sample_Id,
  fsps.id                      Fluid_State_Pty_Set_Id,
  fnsps.id                     Fluid_Non_State_Pty_Set_Id,
  fsa.id                       Fluid_Sample_Acquisition_Id,
  co.id                        Analysis_Lab_Id,
  mc1.id                       
C1_Id,
  mc2.id                       C2_Id,
  mc3.id                       C3_Id,
  mc4.id                       iC4_Id,
  mc5.id                       nC4_Id,
  mc6.id                       iC5_Id,
  mc7.id                       nC5_Id,
  mc8.id                       CO2_Id,
  mc9.id                       O2_Id,
  mc10.id                      N2_Id,
  mc11.id                      H2S_Id,
  mc12.id                      C6plus_Id
 from
      borehole                     bh,
      well_completion              wc,
      tubing_string                ts,
      fluid_sample_acquisition     fsa,
      fluid_sample                 fs,
      fluid_analysis               fa,
      company                      co,
      fluid_state_pty_set          fsps,
      fluid_non_state_pty_set      fnsps,
      material_composition         mc1,
      material_composition         mc2,
      material_composition         mc3,
      material_composition         mc4,
      material_composition         mc5,
   
   material_composition         mc6,
      material_composition         mc7,
      material_composition         mc8,
      material_composition         mc9,
      material_composition         mc10,
      material_composition         mc11,
      material_composition         mc12
  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 fsa.id = fs.fluid_acquisition_id
   and fs.material_type = 'Gas'
   and fs.id = fa.fluid_sample_id
   and fa.analysis_method = 'Gas Analysis'
   and fa.Analysis_Lab_Id = co.id(+)
   and fa.id = fsps.fluid_analysis_id (+)
   and fa.id = fnsps.fluid_analysis_id (+)
   and fa.id = mc1.fluid_analysis_id (+)
   and mc1.component_material_type(+) = 'C1'
   and fa.id = mc2.fluid_analysis_id (+)
   and mc2.component_material_type(+) = 'C2'
   and fa.id = mc3.fluid_analysis_id (+)
   and mc3.component_material_type(+) = 'C3'
   and fa.id = 
mc4.fluid_analysis_id (+)
   and mc4.component_material_type(+) = 'iC4'
   and fa.id = mc5.fluid_analysis_id (+)
   and mc5.component_material_type(+) = 'nC4'
   and fa.id = mc6.fluid_analysis_id (+)
   and mc6.component_material_type(+) = 'iC5'
   and fa.id = mc7.fluid_analysis_id (+)
   and mc7.component_material_type(+) = 'nC5'
   and fa.id = mc8.fluid_analysis_id (+)
   and mc8.component_material_type(+) = 'CO2'
   and fa.id = mc9.fluid_analysis_id (+)
   and mc9.component_material_type(+) = 'O2'
   and fa.id = mc10.fluid_analysis_id (+)
   and mc10.component_material_type(+) = 'N2'
   and fa.id = mc11.fluid_analysis_id (+)
   and mc11.component_material_type(+) = 'H2S'
   and fa.id = mc12.fluid_analysis_id (+)
   and mc12.component_material_type(+) = 'C6plus'

   


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

Copyright © 2018 Schlumberger. All rights reserved.