Marker_Rank_DOV


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

General Information

[Next]
Name Marker_Rank_DOV
Entity Type ObjectView
Description Markers ranked based on interpreter preference
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
Application_Name STRING64 NA
_ No
VARCHAR2(64)
Borehole_Id ID No_Unit
_ No
NUMBER(38)
Borehole_Name STRING255 NA
_ No
VARCHAR2(255)
Conformity_Relationship STRING64 NA
_ No
VARCHAR2(64)
Dip double Plane_Angle
deg
_ No
NUMBER
Dip_Azimuth double Plane_Angle
deg
_ No
NUMBER
Id ID No_Unit
_ Yes
NUMBER(38)
Informal_Surface_Name STRING255 NA
_ No
VARCHAR2(255)
Insert_Date DATE NA
_ No
DATE
Insert_User STRING255 NA
_ No
VARCHAR2(255)
Interpreter STRING255 NA
_ No
VARCHAR2(255)
Interpreter_Rank int NA
_ No
NUMBER(10)
Marker_Rank int NA
_ No
NUMBER(10)
Marker_XYZ_Position_Id ID No_Unit
_ No
NUMBER(38)
Original_Source STRING255 NA
_ No
VARCHAR2(255)
Pick_Depth NUMBER Depth
m
_ Yes
NUMBER
REMARKS STRING2000 NA
_ No
VARCHAR2(2000)
Stratigraphic_Surface_Id ID No_Unit
_ No
NUMBER(38)
Surface_Name STRING255 NA
_ Yes
VARCHAR2(255)
UBHI WELL_IDENTIFIER NA
_ Yes
VARCHAR2(64)
Update_Date DATE NA
_ No
DATE
Well_Id ID No_Unit
_ No
NUMBER(38)
Well_Marker_Surface_Id ID No_Unit
_ No
NUMBER(38)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Marker_Rank_DOV(ID, UBHI, BOREHOLE_NAME, SURFACE_NAME, INFORMAL_SURFACE_NAME, INTERPRETER, ORIGINAL_SOURCE, PICK_DEPTH, APPLICATION_NAME, WELL_MARKER_SURFACE_ID, MARKER_XYZ_POSITION_ID, UPDATE_DATE, CONFORMITY_RELATIONSHIP, DIP_AZIMUTH, DIP, REMARKS, INTERPRETER_RANK, MARKER_RANK, INSERT_DATE, INSERT_USER, BOREHOLE_ID, WELL_ID, STRATIGRAPHIC_SURFACE_ID) AS SELECT
          bp.Id Id,
          bh.UBHI UBHI,
          bh.Name Borehole_Name,
          ss.standard_geologic_surface Surface_Name,
          ss.Name Informal_Surface_Name,
          bp.source Interpreter,
          bp.original_source Original_Source,
          bp.MD Pick_Depth,
          bp.produced_by Application_Name,
          bp.well_marker_surface_id Well_Marker_Surface_Id,
          bp.marker_xyz_position_id Marker_XYZ_Position_Id,
          bp.Update_date Update_Date,
          ss.strat_surface_type Conformity_Relationship,
          bp.dip_azimuth Dip_Azimuth,
          bp.dip_angle Dip,
   
       bp.remarks Remarks,
          col.rank interpreter_rank,
          rank() OVER (partition by bp.borehole_id, bp.well_marker_surface_id order by col.rank) marker_rank,
          bp.insert_date Insert_Date,
          bp.insert_user Insert_User,
          bh.Id Borehole_Id,
          bh.well_Id Well_Id,
          ss.Id Stratigraphic_Surface_Id
          from      borehole bh,
                       borehole_point bp
                       LEFT OUTER JOIN person p  ON  p.name=bp.source AND NVL(p.source,' ')=NVL(bp.original_source,' ')
                       LEFT OUTER JOIN (SELECT c.id, cr.property_id, cr.rank FROM collection_ref cr, collection c WHERE  cr.entity_id=c.id AND  c.collection_type='Well_Top' AND
                        (UPPER(c.source)=user OR (user NOT IN (SELECT UPPER(NVL(c.source,' ')) from collection_ref cr, collection c WHERE  cr.entity_id=c.id AND  c.collection_type='Well_Top'  ) AND c.source is NULL ))) col ON col.property_id=p.id,
                       
stratigraphic_surface ss
          where  bh.id=bp.borehole_id
            AND bp.well_marker_surface_id = ss.id
   


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

Copyright © 2018 Schlumberger. All rights reserved.