| 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 |
| Name | Value Domain | Property / Storage Unit | Description | Required / 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 |
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
|