Zone_DOV

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

Name	Zone_DOV
Entity Type	ObjectView
Description	Data Object View. The Zone DOV contains general information about a geologic zone within a borehole, such as average permeability, average porosity, and top depth.
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
Average_Permeability	double	Permeability mD	The permeability of the rock	No	NUMBER
Average_Porosity	double	Porosity m3/m3	The porosity of the rock	No	NUMBER
Average_Water_Saturation	double	Standard_Volume_Ratio m3/m3	The average original fractional water saturation in this borehole zone.	No	NUMBER
Base_Depth	double	Standard_Depth_Index m	Measured Depth of the borehole point.	Yes	NUMBER
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)
Borehole_Point_Base_Id	Borehole_Point		READ ONLY: Unique identifier for the Borehole Point base.	No	NUMBER(38)
Borehole_Point_Top_Id	Borehole_Point		READ ONLY: Unique identifier for the Borehole Point top.	No	NUMBER(38)
Geologic_Layer_Id	Stratigraphic_Layer		READ ONLY: Unique identifier for the geologic layer.	No	NUMBER(38)
Id	ID	No_Unit	Unique identifier for this entity.	Yes	NUMBER(38)
Informal_Zone_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)
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)
Net_Pay	double	Length m	The cumulative reservoir rock thickness capable of producing commercial hydrocarbons, excluding non-producing portions, within this borehole zone.	No	NUMBER
Net_Sand	double	Length m	The net thickness of reservoir lithology including only intervals with reservoir quality.	No	NUMBER
Permeability_Height	double	Integrated_Permeability mD.m	The product of the permeability and the length of the permeable section across the zone. This value is often called Kh.	No	NUMBER
Remarks	REMARKS_STR	NA	Any type of remarks added to an entity instance.	No	VARCHAR2(999)
Reservoir_Zone_Pty_Set_Id	Reservoir_Zone_Pty_Set		READ ONLY: Unique identifier for the reservoir zone pty set.	No	NUMBER(38)
Rock_Pty_Set_Id	Rock_Pty_Set		READ ONLY: Unique identifier for the rock pty set.	No	NUMBER(38)
Top_Depth	double	Standard_Depth_Index m	Measured Depth of the borehole point.	Yes	NUMBER
UBHI	WELL_IDENTIFIER	NA	The Unique Identifier assigned to a borehole	Yes	VARCHAR2(64)
Zone_Name	CODE		The standard or formal geologic layer name. For lithostratigraphy this will be the identifier of the formation name. An example is Austin for the Austin Chalk Formation.	Yes	VARCHAR2(64)

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Borehole	Borehole	READ ONLY: Unique identifier for the Borehole.	Cascade	No
Borehole_Point_Top	Borehole_Point	READ ONLY: Unique identifier for the Borehole Point top.	Cascade	No
Rock_Pty_Set	Rock_Pty_Set	READ ONLY: Unique identifier for the rock pty set.	Cascade	No
Geologic_Layer	Stratigraphic_Layer	READ ONLY: Unique identifier for the geologic layer.	Cascade	No
Reservoir_Zone_Pty_Set	Reservoir_Zone_Pty_Set	READ ONLY: Unique identifier for the reservoir zone pty set.	Cascade	No
Borehole_Point_Base	Borehole_Point	READ ONLY: Unique identifier for the Borehole Point base.	Cascade	No

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW Zone_DOV(ID, UBHI, BOREHOLE_NAME, ZONE_NAME, INFORMAL_ZONE_NAME, TOP_DEPTH, BASE_DEPTH, NET_PAY, AVERAGE_WATER_SATURATION, AVERAGE_POROSITY, AVERAGE_PERMEABILITY, PERMEABILITY_HEIGHT, NET_SAND, REMARKS, INSERT_DATE, INSERT_USER, BOREHOLE_ID, BOREHOLE_POINT_TOP_ID, BOREHOLE_POINT_BASE_ID, GEOLOGIC_LAYER_ID, RESERVOIR_ZONE_PTY_SET_ID, ROCK_PTY_SET_ID) AS SELECT
  bhz.Id                         Id,
  bh.UBHI                        UBHI,
  bh.Name                        Borehole_Name,
  strat.Standard_Layer_Name      Zone_Name,
  bhz.Name                       Informal_Zone_Name,
  bhp_top.Md                     Top_Depth,
  bhp_base.Md                    Base_Depth,
  rzps.Net_Pay                   Net_Pay,
  rzps.Avg_Water_Saturation      Average_Water_Saturation,
  rops.Porosity                  Average_Porosity,
  rops.Permeability              Average_Permeability,
  rops.Permeability_Height       Permeability_Height,
  rops.Net_Sand                  
Net_Sand,
  bhz.Remarks                    Remarks,
  bhz.Insert_Date                Insert_Date,
  bhz.Insert_User                Insert_User,
  bh.Id                          Borehole_Id,
  bhp_top.Id                     Borehole_Point_Top_Id,
  bhp_base.Id                    Borehole_Point_Base_Id,
  strat.Id                       Geologic_Layer_Id,
  rzps.Id                        Reservoir_Zone_Pty_Set_Id,
  rops.Id                        Rock_Pty_Set_Id
FROM
  borehole             bh,
  borehole_zone        bhz,
  borehole_point       bhp_base,
  borehole_point       bhp_top,
  stratigraphic_layer  strat,
  reservoir_zone_pty_set rzps,
  rock_pty_set         rops
WHERE
  bh.id = bhp_top.borehole_id AND
  bhp_top.id = bhz.zone_top_id AND
  bh.id = bhp_base.borehole_id AND
  bhp_base.id = bhz.zone_base_id AND
  bhz.id = rzps.reservoir_zone_id(+) AND
  bhz.id = rops.rock_pty_zone_id(+) AND
  bhz.geologic_layer_id = strat.id (+)

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

Zone_DOV

Copyright © 2018 Schlumberger. All rights reserved.