Survey_2D_Dataset_Proc


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

General Information

[Next]
Name Survey_2D_Dataset_Proc
Entity Type ObjectView
Description PSS 2013.1 Survey_2D_Dataset_Proc 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
ACTIVITY_STATE STRING64 NA
_ No
VARCHAR2(64)
ACTIVITY_TEMPLATE_ID NUMBER2 NA
_ No
NUMBER(2)
CONTRACT_NUMBER STRING64 NA
_ No
VARCHAR2(64)
END_DATE DATE NA
_ No
DATE
EXISTENCE_KIND STRING64 NA
_ Yes
VARCHAR2(64)
EXTERNAL_REFERENCE STRING64 NA
_ No
VARCHAR2(64)
GUID STRING128 NA
_ No
VARCHAR2(128)
ID NUMBER2 NA
_ Yes
NUMBER(2)
INSERT_DATE DATE NA
_ No
DATE
INSERT_USER STRING64 NA
_ No
VARCHAR2(64)
INTERNAL_REFERENCE STRING64 NA
_ No
VARCHAR2(64)
NAME STRING255 NA
_ No
VARCHAR2(255)
ORIGINAL_SOURCE STRING64 NA
_ No
VARCHAR2(64)
PROCESSING_CENTER STRING64 NA
_ No
VARCHAR2(64)
PROCESSING_GROUP STRING64 NA
_ No
VARCHAR2(64)
PRODUCED_BY STRING64 NA
_ No
VARCHAR2(64)
PURPOSE STRING255 NA
_ No
VARCHAR2(255)
REMARKS STRING2000 NA
_ No
VARCHAR2(2000)
SDAT_LABEL NUMBER2 NA
_ No
NUMBER(2)
SEISMIC_DATASET_NAME STRING255 NA
_ No
VARCHAR2(255)
SOURCE STRING64 NA
_ No
VARCHAR2(64)
START_DATE DATE NA
_ No
DATE
SURVEY_2D_ID NUMBER2 NA
_ No
NUMBER(2)
TRANSIENT_PERIOD STRING64 NA
_ No
VARCHAR2(64)
TRIGGERING_EVENT_ID NUMBER2 NA
_ No
NUMBER(2)
UPDATE_DATE DATE NA
_ No
DATE
UPDATE_USER STRING64 NA
_ No
VARCHAR2(64)
VERSION STRING255 NA
_ Yes
VARCHAR2(255)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Survey_2D_Dataset_Proc(SURVEY_2D_ID, SEISMIC_DATASET_NAME, INSERT_DATE, INSERT_USER, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, EXISTENCE_KIND, GUID, ID, VERSION, NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, ACTIVITY_STATE, ACTIVITY_TEMPLATE_ID, END_DATE, EXTERNAL_REFERENCE, INTERNAL_REFERENCE, PURPOSE, START_DATE, TRANSIENT_PERIOD, TRIGGERING_EVENT_ID, CONTRACT_NUMBER, PROCESSING_CENTER, PROCESSING_GROUP) AS (SELECT DISTINCT seismic_line.survey_2d_id,
                    seismic_dataset_2d.NAME seismic_dataset_name,
                    seismic_processing_act.INSERT_DATE,
                    seismic_processing_act.INSERT_USER,
                    seismic_processing_act.PRODUCED_BY,
                    seismic_processing_act.SDAT_LABEL,
                    seismic_processing_act.UPDATE_DATE,
                    seismic_processing_act.UPDATE_USER,
                    seismic_processing_act.EXISTENCE_KIND,
                    seismic_processing_act.GUID,
  
                  seismic_processing_act.ID,
                    seismic_processing_act.VERSION,
                    seismic_processing_act.NAME,
                    seismic_processing_act.ORIGINAL_SOURCE,
                    seismic_processing_act.REMARKS,
                    seismic_processing_act.SOURCE,
                    seismic_processing_act.ACTIVITY_STATE,
                    seismic_processing_act.ACTIVITY_TEMPLATE_ID,
                    seismic_processing_act.END_DATE,
                    seismic_processing_act.EXTERNAL_REFERENCE,
                    seismic_processing_act.INTERNAL_REFERENCE,
                    seismic_processing_act.PURPOSE,
                    seismic_processing_act.START_DATE,
                    seismic_processing_act.TRANSIENT_PERIOD,
                    seismic_processing_act.TRIGGERING_EVENT_ID,
                    seismic_processing_act.CONTRACT_NUMBER,
                    seismic_processing_act.PROCESSING_CENTER,
                    
seismic_processing_act.PROCESSING_GROUP
               FROM seismic_processing_act,
                    Seismic_DS_Processing,
                    seismic_dataset_2d,
                    seismic_line
              WHERE seismic_processing_act.ID = Seismic_DS_Processing.seismic_processing_act_id
                AND Seismic_DS_Processing.seismic_dataset_id = seismic_dataset_2d.ID
                AND seismic_dataset_2d.seismic_line_id = seismic_line.ID)
    UNION
    (SELECT DISTINCT seismic_line.survey_2d_id,
                    seismic_dataset_2d.NAME seismic_dataset_name,
                    seismic_processing_act.INSERT_DATE,
                    seismic_processing_act.INSERT_USER,
                    seismic_processing_act.PRODUCED_BY,
                    seismic_processing_act.SDAT_LABEL,
                    seismic_processing_act.UPDATE_DATE,
                    seismic_processing_act.UPDATE_USER,
                    seismic_processing_act.EXISTENCE_KIND,
                    
seismic_processing_act.GUID,
                    seismic_processing_act.ID,
                    seismic_processing_act.VERSION,
                    seismic_processing_act.NAME,
                    seismic_processing_act.ORIGINAL_SOURCE,
                    seismic_processing_act.REMARKS,
                    seismic_processing_act.SOURCE,
                    seismic_processing_act.ACTIVITY_STATE,
                    seismic_processing_act.ACTIVITY_TEMPLATE_ID,
                    seismic_processing_act.END_DATE,
                    seismic_processing_act.EXTERNAL_REFERENCE,
                    seismic_processing_act.INTERNAL_REFERENCE,
                    seismic_processing_act.PURPOSE,
                    seismic_processing_act.START_DATE,
                    seismic_processing_act.TRANSIENT_PERIOD,
                    seismic_processing_act.TRIGGERING_EVENT_ID,
                    seismic_processing_act.CONTRACT_NUMBER,
                    seismic_processing_act.PROCESSING_CENTER,
   
                 seismic_processing_act.PROCESSING_GROUP
               FROM seismic_processing_act,
                    Seismic_DS_Processing,
                    seismic_dataset_2d,
                    alternative_navigation,
                    seismic_line
              WHERE seismic_processing_act.ID = Seismic_DS_Processing.seismic_processing_act_id
                AND Seismic_DS_Processing.seismic_dataset_id = seismic_dataset_2d.ID
                AND seismic_dataset_2d.alternative_navigation_id = alternative_navigation.ID
                AND seismic_line.ID = alternative_navigation.seismic_line_id)
   


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

Copyright © 2018 Schlumberger. All rights reserved.