Seismic_Survey_Alias_2D


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

General Information

[Next]
Name Seismic_Survey_Alias_2D
Entity Type ObjectView
Description PSS 2013.1 Seismic_Survey_Alias_2D 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
ALIAS_NAME STRING255 NA
_ Yes
VARCHAR2(255)
ALIAS_TYPE STRING64 NA
_ Yes
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)
NAME STRING255 NA
_ No
VARCHAR2(255)
ORIGINAL_SOURCE STRING64 NA
_ No
VARCHAR2(64)
PRODUCED_BY STRING64 NA
_ No
VARCHAR2(64)
REMARKS STRING2000 NA
_ No
VARCHAR2(2000)
SDAT_LABEL NUMBER2 NA
_ No
NUMBER(2)
SOURCE STRING64 NA
_ No
VARCHAR2(64)
SURVEY_2D_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_Survey_Alias_2D(ID, SURVEY_2D_ID, INSERT_DATE, INSERT_USER, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, GUID, NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, ALIAS_NAME, ALIAS_TYPE) AS SELECT
   ssa.ID,
   ssa.SEISMIC_SURVEY_ID,
   ssa.INSERT_DATE,
   ssa.INSERT_USER,
   ssa.PRODUCED_BY,
   ssa.SDAT_LABEL,
   ssa.UPDATE_DATE,
   ssa.UPDATE_USER,
   ssa.GUID,
   ssa.NAME,
   ssa.ORIGINAL_SOURCE,
   ssa.REMARKS,
   ssa.SOURCE,
   ssa.ALIAS_NAME,
   ssa.ALIAS_TYPE
FROM
   SEISMIC_SURVEY_ALIAS ssa
WHERE
   ssa.SEISMIC_SURVEY_TBL = 'SURVEY_2D'
   


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

Copyright © 2018 Schlumberger. All rights reserved.