Seismic_Dataset_3D_N

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

Name	Seismic_Dataset_3D_N
Entity Type	ObjectView
Description	PSS 2013.1 Seismic_Dataset_3D_N DOV
Submodel	Data_Object
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations
Specializations

Columns

[Previous] [Next] [Top]

Name	Value Domain	Property / Storage Unit	Description	Required / Default	Type
APPLICATION_PROJECT_ID	NUMBER2	NA	_	Yes	NUMBER(2)
BINARY_HEADER_TEMPLATE_ID	NUMBER2	NA	_	No	NUMBER(2)
CALCULATED_AREA	NUMBER	Area m2	_	No	NUMBER
COMPRESSION_FACTOR	NUMBER2	NA	_	No	NUMBER(2)
CUBE_LATTICE_ID	NUMBER2	NA	_	Yes	NUMBER(2)
DATASET_PROPERTY_NAME	STRING64	NA	_	No	VARCHAR2(64)
DATASET_RANK	NUMBER2	NA	_	No	NUMBER(2)
DATASET_UNIQUE_LOCATOR	STRING2000	NA	_	No	VARCHAR2(2000)
DATASET_VERSION	STRING128	NA	_	No	VARCHAR2(128)
DATASTORE_NAME	STRING255	NA	_	No	VARCHAR2(255)
DOMAIN_TYPE	STRING64	NA	_	No	VARCHAR2(64)
DOMAIN_UNIT	STRING64	NA	_	No	VARCHAR2(64)
EBCDIC_HEADER_TEMPLATE_ID	NUMBER2	NA	_	No	NUMBER(2)
FIRST_I_LINE	NUMBER2	NA	_	No	NUMBER(2)
FIRST_J_LINE	NUMBER2	NA	_	No	NUMBER(2)
FIRST_SAMPLE_OFFSET	NUMBER2	NA	_	No	NUMBER(2)
FOLD	NUMBER2	NA	_	No	NUMBER(2)
FOREIGN_REPOSITORY_SYSTEM	STRING64	NA	_	No	VARCHAR2(64)
FOREIGN_REP_OBJECT_ID	STRING255	NA	_	No	VARCHAR2(255)
FULL_SURVEY_EXTENT_FLAG	STRING64	NA	_	No	VARCHAR2(64)
GENERATE_LIVE_TRACE_FLAG	NUMBER2	NA	_	No	NUMBER(2)
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)
I_INCREMENT_FACTOR	NUMBER2	NA	_	No	NUMBER(2)
J_INCREMENT_FACTOR	NUMBER2	NA	_	No	NUMBER(2)
LAST_I_LINE	NUMBER2	NA	_	No	NUMBER(2)
LAST_J_LINE	NUMBER2	NA	_	No	NUMBER(2)
LIVE_TRACE_SCAN_DATE	DATE	NA	_	No	DATE
MAXIMUM_AMPLITUDE	NUMBER2	NA	_	No	NUMBER(2)
MINIMUM_AMPLITUDE	NUMBER2	NA	_	No	NUMBER(2)
NAME	STRING255	NA	_	No	VARCHAR2(255)
NAV_IN_TRACE	NUMBER2	NA	_	No	NUMBER(2)
NOMINAL_AREA	NUMBER	Area m2	_	No	NUMBER
NUMBER_OF_SAMPLES	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)
PROJECT_DATASTORE_ID	NUMBER2	NA	_	Yes	NUMBER(2)
PROJECT_NAME	STRING255	NA	_	No	VARCHAR2(255)
REMARKS	STRING2000	NA	_	No	VARCHAR2(2000)
SAMPLE_INTERVAL	NUMBER2	NA	_	No	NUMBER(2)
SCAN_DATE	DATE	NA	_	No	DATE
SEISMIC_DATA_TYPE	STRING64	NA	_	No	VARCHAR2(64)
SEISMIC_FORMAT	STRING64	NA	_	No	VARCHAR2(64)
SEISMIC_REFERENCE_DATUM	NUMBER2	NA	_	No	NUMBER(2)
SEISMIC_SAMPLE_FORMAT	STRING64	NA	_	No	VARCHAR2(64)
SEISMIC_VOLUME_TYPE	STRING64	NA	_	No	VARCHAR2(64)
SLICE_SAMPLE_INDEX	NUMBER2	NA	_	No	NUMBER(2)
SORT_KEY1	STRING64	NA	_	No	VARCHAR2(64)
SORT_KEY2	STRING64	NA	_	No	VARCHAR2(64)
SOURCE	STRING64	NA	_	No	VARCHAR2(64)
SUB_TYPE	STRING32	NA	_	No	VARCHAR2(32)
SURVEY_3D_ID	NUMBER2	NA	_	Yes	NUMBER(2)
SURVEY_NAME	STRING255	NA	_	No	VARCHAR2(255)
TRACES_PER_RECORD	NUMBER2	NA	_	No	NUMBER(2)
TRACE_COUNT	NUMBER2	NA	_	No	NUMBER(2)
TRACE_HEADER_TEMPLATE_ID	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_Dataset_3D_N(ID, CUBE_LATTICE_ID, SURVEY_3D_ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, BINARY_HEADER_TEMPLATE_ID, COMPRESSION_FACTOR, DATASET_PROPERTY_NAME, DATASET_RANK, DATASET_UNIQUE_LOCATOR, DATASET_VERSION, DOMAIN_TYPE, DOMAIN_UNIT, EBCDIC_HEADER_TEMPLATE_ID, FIRST_SAMPLE_OFFSET, FOLD, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, GENERATE_LIVE_TRACE_FLAG, LIVE_TRACE_SCAN_DATE, MAXIMUM_AMPLITUDE, MINIMUM_AMPLITUDE, NAV_IN_TRACE, NUMBER_OF_SAMPLES, PROCESSING_STAGE, SAMPLE_INTERVAL, SCAN_DATE, SEISMIC_DATA_TYPE, SEISMIC_DATA_SUBTYPE, SEISMIC_FORMAT, SEISMIC_REFERENCE_DATUM, SEISMIC_SAMPLE_FORMAT, SLICE_SAMPLE_INDEX, SORT_KEY1, SORT_KEY2, SUB_TYPE, TRACE_COUNT, TRACE_HEADER_TEMPLATE_ID, TRACES_PER_RECORD, FIRST_I_LINE, FIRST_J_LINE, I_INCREMENT_FACTOR, J_INCREMENT_FACTOR, 
LAST_I_LINE, LAST_J_LINE, SEISMIC_VOLUME_TYPE, FULL_SURVEY_EXTENT_FLAG, NOMINAL_AREA, CALCULATED_AREA) AS select SEISMIC_DATASET_3D.ID,
       CUBE_LATTICE.ID,
       SURVEY_3D.ID,
       APPLICATION_PROJECT.ID,
       PROJECT_DATASTORE.ID,
       SEISMIC_DATASET_3D.INSERT_DATE,
       SEISMIC_DATASET_3D.INSERT_USER,
       SEISMIC_DATASET_3D.UPDATE_DATE,
       SEISMIC_DATASET_3D.UPDATE_USER,
       SEISMIC_DATASET_3D.GUID,
       SEISMIC_DATASET_3D.NAME,
       SURVEY_3D.NAME,
       APPLICATION_PROJECT.NAME,
       PROJECT_DATASTORE.NAME,
       SEISMIC_DATASET_3D.ORIGINAL_SOURCE,
       SEISMIC_DATASET_3D.PRODUCED_BY,
       SEISMIC_DATASET_3D.REMARKS,
       SEISMIC_DATASET_3D.SOURCE,
       SEISMIC_DATASET_3D.BINARY_HEADER_TEMPLATE_ID,
       SEISMIC_DATASET_3D.COMPRESSION_FACTOR,
       SEISMIC_DATASET_3D.DATASET_PROPERTY_NAME,
       SEISMIC_DATASET_3D.DATASET_RANK,
       SEISMIC_DATASET_3D.DATASET_UNIQUE_LOCATOR,
       SEISMIC_DATASET_3D.DATASET_VERSION,
       
SEISMIC_DATASET_3D.DOMAIN_TYPE,
       SEISMIC_DATASET_3D.DOMAIN_UNIT,
       SEISMIC_DATASET_3D.EBCDIC_HEADER_TEMPLATE_ID,
       SEISMIC_DATASET_3D.FIRST_SAMPLE_OFFSET,
       SEISMIC_DATASET_3D.FOLD,
       SEISMIC_DATASET_3D.FOREIGN_REP_OBJECT_ID,
       SEISMIC_DATASET_3D.FOREIGN_REPOSITORY_SYSTEM,
       SEISMIC_DATASET_3D.GENERATE_LIVE_TRACE_FLAG,
       SEISMIC_DATASET_3D.LIVE_TRACE_SCAN_DATE,
       SEISMIC_DATASET_3D.MAXIMUM_AMPLITUDE,
       SEISMIC_DATASET_3D.MINIMUM_AMPLITUDE,
       SEISMIC_DATASET_3D.NAV_IN_TRACE,
       SEISMIC_DATASET_3D.NUMBER_OF_SAMPLES,
       SEISMIC_DATASET_3D.PROCESSING_STAGE,
       SEISMIC_DATASET_3D.SAMPLE_INTERVAL,
       SEISMIC_DATASET_3D.SCAN_DATE,
       SEISMIC_DATASET_3D.SEISMIC_DATA_TYPE,
	   SEISMIC_DATASET_3D.SEISMIC_DATA_SUBTYPE,
       SEISMIC_DATASET_3D.SEISMIC_FORMAT,
       SEISMIC_DATASET_3D.SEISMIC_REFERENCE_DATUM,
       SEISMIC_DATASET_3D.SEISMIC_SAMPLE_FORMAT,
       SEISMIC_DATASET_3D.SLICE_SAMPLE_INDEX,
       
SEISMIC_DATASET_3D.SORT_KEY1,
       SEISMIC_DATASET_3D.SORT_KEY2,
       SEISMIC_DATASET_3D.SUB_TYPE,
       SEISMIC_DATASET_3D.TRACE_COUNT,
       SEISMIC_DATASET_3D.TRACE_HEADER_TEMPLATE_ID,
       SEISMIC_DATASET_3D.TRACES_PER_RECORD,
       SEISMIC_DATASET_3D.FIRST_I_LINE,
       SEISMIC_DATASET_3D.FIRST_J_LINE,
       SEISMIC_DATASET_3D.I_INCREMENT_FACTOR,
       SEISMIC_DATASET_3D.J_INCREMENT_FACTOR,
       SEISMIC_DATASET_3D.LAST_I_LINE,
       SEISMIC_DATASET_3D.LAST_J_LINE,
       SEISMIC_DATASET_3D.SEISMIC_VOLUME_TYPE,
       DECODE (SEISMIC_DATASET_3D.full_survey_extent_flag, 1, 1, 0, NULL),
       SEISMIC_DATASET_3D.NOMINAL_AREA,
       SEISMIC_DATASET_3D.CALCULATED_AREA
from PROJECT_DATASTORE, APPLICATION_PROJECT, SURVEY_3D, CUBE_LATTICE, SEISMIC_DATASET_3D
where PROJECT_DATASTORE.ID = APPLICATION_PROJECT.PROJECT_DATASTORE_ID
  and APPLICATION_PROJECT.ID = SURVEY_3D.APPLICATION_PROJECT_ID
  and SURVEY_3D.ID = CUBE_LATTICE.SURVEY_3D_ID
  and CUBE_LATTICE.ID = 
SEISMIC_DATASET_3D.CUBE_LATTICE_ID

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

Seismic_Dataset_3D_N

Copyright © 2018 Schlumberger. All rights reserved.