| Name | Seismic_DS_Processing |
|---|---|
| Entity Type | ObjectView |
| Description | PSS 2013.1 Seismic_DS_Processing DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| CONTRACT_NUMBER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| END_DATE | DATE | NA |
_ | No |
DATE |
| 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) |
| PROCESSING_CENTER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PROCESSING_GROUP | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PRODUCED_BY | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| REMARKS | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| SEISMIC_DATASET_ID | NUMBER2 | NA |
_ | Yes |
NUMBER(2) |
| SEISMIC_PROCESSING_ACT_ID | NUMBER2 | NA |
_ | Yes |
NUMBER(2) |
| SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| START_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| VERSION | STRING255 | NA |
_ | Yes |
VARCHAR2(255) |
CREATE OR REPLACE FORCE VIEW Seismic_DS_Processing(ID, SEISMIC_DATASET_ID, SEISMIC_PROCESSING_ACT_ID, INSERT_DATE, INSERT_USER, PRODUCED_BY, UPDATE_DATE, UPDATE_USER, GUID, NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, VERSION, START_DATE, END_DATE, CONTRACT_NUMBER, PROCESSING_CENTER, PROCESSING_GROUP) AS select ACTIVITY_ENTITY_INVL.ID,
ACTIVITY_ENTITY_INVL.INVOLVED_ENTITY_ID SEISMIC_DATASET_ID,
SEISMIC_PROCESSING_ACT.ID SEISMIC_PROCESSING_ACT_ID,
SEISMIC_PROCESSING_ACT.INSERT_DATE,
SEISMIC_PROCESSING_ACT.INSERT_USER,
SEISMIC_PROCESSING_ACT.PRODUCED_BY,
SEISMIC_PROCESSING_ACT.UPDATE_DATE,
SEISMIC_PROCESSING_ACT.UPDATE_USER,
SEISMIC_PROCESSING_ACT.GUID,
SEISMIC_PROCESSING_ACT.NAME,
SEISMIC_PROCESSING_ACT.ORIGINAL_SOURCE,
SEISMIC_PROCESSING_ACT.REMARKS,
SEISMIC_PROCESSING_ACT.SOURCE,
SEISMIC_PROCESSING_ACT.VERSION,
SEISMIC_PROCESSING_ACT.START_DATE,
SEISMIC_PROCESSING_ACT.END_DATE,
SEISMIC_PROCESSING_ACT.CONTRACT_NUMBER,
SEISMIC_PROCESSING_ACT.PROCESSING_CENTER,
SEISMIC_PROCESSING_ACT.PROCESSING_GROUP
from ACTIVITY_ENTITY_INVL, SEISMIC_PROCESSING_ACT
where ACTIVITY_ENTITY_INVL.INVOLVED_ENTITY_TBL = 'Seismic_Dataset'
and ACTIVITY_ENTITY_INVL.INVOLVED_ACTIVITY_TBL = 'Seismic_Processing_Act'
and SEISMIC_PROCESSING_ACT.ID = ACTIVITY_ENTITY_INVL.INVOLVED_ACTIVITY_ID
|