EXP_GAE_RAW_TRACE_DOV


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

General Information

[Next]
Name EXP_GAE_RAW_TRACE_DOV
Entity Type ObjectView
Description Custom Exporters - EXP_GAE_RAW_TRACE_DOV
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
DEPTH NUMBER NA
_ No
NUMBER
GRADIENT NUMBER NA
_ No
NUMBER
Id ID No_Unit
Unique identifier Yes
NUMBER(38)
PRESSURE NUMBER NA
_ No
NUMBER
REMARKS STRING2000 NA
_ No
VARCHAR2(2000)
START_DATE DATE NA
_ No
DATE
TEMPERATURE NUMBER NA
_ No
NUMBER
TIME_OFFSET NUMBER NA
_ No
NUMBER


View Definition

[Previous] [Top]
CREATE OR REPLACE FORCE VIEW EXP_GAE_RAW_TRACE_DOV(ID, START_DATE, TIME_OFFSET, PRESSURE, TEMPERATURE, DEPTH, GRADIENT, REMARKS) AS SELECT Wtt.id,
            nvl(WTS.START_DATE,WTT.START_DATE) + WTTD.TIME_OFFSET/86400 Start_Date,
            WTTD.TIME_OFFSET Time_Offset,
            WTTD.PRESSURE Pressure,
            WTTD.TEMPERATURE Temperature,
            WTTD.MD DEPTH,
            WTTD.PRESSURE_POINT_GRADIENT Gradient,
            WTTD.REMARKS
       FROM well_test_trace_data wttd, well_test_stage wts, well_test_trace wtt
      WHERE WTT.ID = WTTD.WELL_TEST_TRACE_ID
            AND WTT.WELL_TEST_STAGE_ID = WTS.ID
   ORDER BY Time_Offset
   


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

Copyright © 2018 Schlumberger. All rights reserved.