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