Seismic_File


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

General Information

[Next]
Name Seismic_File
Entity Type ObjectView
Description PSS 2013.1 Seismic_File DOV
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key SEISMIC_DATASET_ID
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
ACQUISITION_2D_ID NUMBER2 NA
_ No
NUMBER(2)
ACQUISITION_3D_ID NUMBER2 NA
_ No
NUMBER(2)
AUTHOR STRING255 NA
_ No
VARCHAR2(255)
BARCODE STRING255 NA
_ No
VARCHAR2(255)
BULK_ARRAY_ID NUMBER2 NA
_ No
NUMBER(2)
DATASET_NAME STRING255 NA
_ No
VARCHAR2(255)
DATASET_VERSION STRING128 NA
_ No
VARCHAR2(128)
DOMAIN_UNIT STRING64 NA
_ No
VARCHAR2(64)
FILE_TYPE STRING64 NA
_ No
VARCHAR2(64)
FIRST_CDP NUMBER2 NA
_ No
NUMBER(2)
FIRST_FIELD_FILE NUMBER2 NA
_ No
NUMBER(2)
FIRST_I_LINE NUMBER2 NA
_ No
NUMBER(2)
FIRST_J_LINE NUMBER2 NA
_ No
NUMBER(2)
FIRST_SHOTPOINT NUMBER2 NA
_ No
NUMBER(2)
FOREIGN_REPOSITORY_SYSTEM STRING64 NA
_ No
VARCHAR2(64)
FOREIGN_REP_OBJECT_ID STRING255 NA
_ No
VARCHAR2(255)
FULL_PATH_FILENAME STRING2000 NA
_ No
VARCHAR2(2000)
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)
INVENTORY_ITEM_RANK NUMBER2 NA
_ No
NUMBER(2)
INVENTORY_TYPE STRING64 NA
_ Yes
VARCHAR2(64)
LAST_CDP NUMBER2 NA
_ No
NUMBER(2)
LAST_FIELD_FILE NUMBER2 NA
_ No
NUMBER(2)
LAST_I_LINE NUMBER2 NA
_ No
NUMBER(2)
LAST_J_LINE NUMBER2 NA
_ No
NUMBER(2)
LAST_SHOTPOINT NUMBER2 NA
_ No
NUMBER(2)
MEDIA_TYPE STRING64 NA
_ No
VARCHAR2(64)
MMS_TAPE STRING255 NA
_ No
VARCHAR2(255)
NAME STRING255 NA
_ No
VARCHAR2(255)
ONLINE_FLAG NUMBER2 NA
_ No
NUMBER(2)
ORIGINAL_SOURCE STRING64 NA
_ No
VARCHAR2(64)
PROCESSING_STAGE STRING64 NA
_ No
VARCHAR2(64)
PRODUCED_BY STRING64 NA
_ No
VARCHAR2(64)
REMARKS STRING2000 NA
_ No
VARCHAR2(2000)
SAMPLE_INTERVAL NUMBER2 NA
_ No
NUMBER(2)
SEISMIC_DATASET_ID NUMBER2 NA
_ No
NUMBER(2)
SEISMIC_DATA_TYPE STRING64 NA
_ No
VARCHAR2(64)
SEISMIC_FORMAT STRING64 NA
_ No
VARCHAR2(64)
SOURCE STRING64 NA
_ No
VARCHAR2(64)
TAPE_CREATION_DATE DATE NA
_ No
DATE
TRACE_COUNT NUMBER2 NA
_ No
NUMBER(2)
UPDATE_DATE DATE NA
_ No
DATE
UPDATE_USER STRING64 NA
_ No
VARCHAR2(64)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Seismic_File(ID, SEISMIC_DATASET_ID, DATASET_NAME, DATASET_VERSION, SEISMIC_DATA_TYPE, SEISMIC_DATA_SUBTYPE, SEISMIC_FORMAT, PROCESSING_STAGE, SAMPLE_INTERVAL, DOMAIN_UNIT, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, ACQUISITION_2D_ID, ACQUISITION_3D_ID, AUTHOR, BARCODE, BULK_ARRAY_ID, FILE_TYPE, FIRST_CDP, FIRST_FIELD_FILE, FIRST_I_LINE, FIRST_J_LINE, FIRST_SHOTPOINT, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, FULL_PATH_FILENAME, INVENTORY_ITEM_RANK, INVENTORY_TYPE, LAST_CDP, LAST_FIELD_FILE, LAST_I_LINE, LAST_J_LINE, LAST_SHOTPOINT, MMS_TAPE, MEDIA_TYPE, ONLINE_FLAG, TAPE_CREATION_DATE, TRACE_COUNT) AS SELECT
   GI.ID,
   DIX.SEISMIC_DATASET_ID,
   D.NAME AS DATASET_NAME,
   D.DATASET_VERSION,
   D.SEISMIC_DATA_TYPE,
   D.SEISMIC_DATA_SUBTYPE,
   D.SEISMIC_FORMAT,
   D.PROCESSING_STAGE,
   D.SAMPLE_INTERVAL,
   D.DOMAIN_UNIT,
   GI.INSERT_DATE,
   GI.INSERT_USER,
   
GI.UPDATE_DATE,
   GI.UPDATE_USER,
   GI.GUID,
   GI.NAME,
   GI.ORIGINAL_SOURCE,
   GI.PRODUCED_BY,
   GI.REMARKS,
   GI.SOURCE,
   GI.ACQUISITION_2D_ID,
   GI.ACQUISITION_3D_ID,
   GI.AUTHOR,
   GI.BARCODE,
   GI.BULK_ARRAY_ID,
   GI.FILE_TYPE,
   GI.FIRST_CDP,
   GI.FIRST_FIELD_FILE,
   GI.FIRST_I_LINE,
   GI.FIRST_J_LINE,
   GI.FIRST_SHOTPOINT,
   GI.FOREIGN_REP_OBJECT_ID,
   GI.FOREIGN_REPOSITORY_SYSTEM,
   GI.FULL_PATH_FILENAME,
   GI.INVENTORY_ITEM_RANK,
   GI.INVENTORY_TYPE,
   GI.LAST_CDP,
   GI.LAST_FIELD_FILE,
   GI.LAST_I_LINE,
   GI.LAST_J_LINE,
   GI.LAST_SHOTPOINT,
   GI.MMS_TAPE,
   GI.MEDIA_TYPE,
   GI.ONLINE_FLAG,
   GI.TAPE_CREATION_DATE,
   GI.TRACE_COUNT
FROM
   GEOPHYSICAL_INVENTORY GI,
   DATASET_INVENTORY_X DIX,
   SEISMIC_DATASET D
WHERE
   GI.ID = DIX.GEOPHYSICAL_INVENTORY_ID AND
   DIX.SEISMIC_DATASET_ID = D.ID AND
   GI.INVENTORY_TYPE = 'File'
   


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

Copyright © 2018 Schlumberger. All rights reserved.