| Name | Survey_2D_Dataset_Proc |
|---|---|
| Entity Type | ObjectView |
| Description | PSS 2013.1 Survey_2D_Dataset_Proc DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| ACTIVITY_STATE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| ACTIVITY_TEMPLATE_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| CONTRACT_NUMBER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| END_DATE | DATE | NA |
_ | No |
DATE |
| EXISTENCE_KIND | STRING64 | NA |
_ | Yes |
VARCHAR2(64) |
| EXTERNAL_REFERENCE | STRING64 | NA |
_ | No |
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) |
| INTERNAL_REFERENCE | 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) |
| PURPOSE | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| REMARKS | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| SDAT_LABEL | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| SEISMIC_DATASET_NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| START_DATE | DATE | NA |
_ | No |
DATE |
| SURVEY_2D_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| TRANSIENT_PERIOD | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| TRIGGERING_EVENT_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| UPDATE_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| VERSION | STRING255 | NA |
_ | Yes |
VARCHAR2(255) |
CREATE OR REPLACE FORCE VIEW Survey_2D_Dataset_Proc(SURVEY_2D_ID, SEISMIC_DATASET_NAME, INSERT_DATE, INSERT_USER, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, EXISTENCE_KIND, GUID, ID, VERSION, NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, ACTIVITY_STATE, ACTIVITY_TEMPLATE_ID, END_DATE, EXTERNAL_REFERENCE, INTERNAL_REFERENCE, PURPOSE, START_DATE, TRANSIENT_PERIOD, TRIGGERING_EVENT_ID, CONTRACT_NUMBER, PROCESSING_CENTER, PROCESSING_GROUP) AS (SELECT DISTINCT seismic_line.survey_2d_id,
seismic_dataset_2d.NAME seismic_dataset_name,
seismic_processing_act.INSERT_DATE,
seismic_processing_act.INSERT_USER,
seismic_processing_act.PRODUCED_BY,
seismic_processing_act.SDAT_LABEL,
seismic_processing_act.UPDATE_DATE,
seismic_processing_act.UPDATE_USER,
seismic_processing_act.EXISTENCE_KIND,
seismic_processing_act.GUID,
seismic_processing_act.ID,
seismic_processing_act.VERSION,
seismic_processing_act.NAME,
seismic_processing_act.ORIGINAL_SOURCE,
seismic_processing_act.REMARKS,
seismic_processing_act.SOURCE,
seismic_processing_act.ACTIVITY_STATE,
seismic_processing_act.ACTIVITY_TEMPLATE_ID,
seismic_processing_act.END_DATE,
seismic_processing_act.EXTERNAL_REFERENCE,
seismic_processing_act.INTERNAL_REFERENCE,
seismic_processing_act.PURPOSE,
seismic_processing_act.START_DATE,
seismic_processing_act.TRANSIENT_PERIOD,
seismic_processing_act.TRIGGERING_EVENT_ID,
seismic_processing_act.CONTRACT_NUMBER,
seismic_processing_act.PROCESSING_CENTER,
seismic_processing_act.PROCESSING_GROUP
FROM seismic_processing_act,
Seismic_DS_Processing,
seismic_dataset_2d,
seismic_line
WHERE seismic_processing_act.ID = Seismic_DS_Processing.seismic_processing_act_id
AND Seismic_DS_Processing.seismic_dataset_id = seismic_dataset_2d.ID
AND seismic_dataset_2d.seismic_line_id = seismic_line.ID)
UNION
(SELECT DISTINCT seismic_line.survey_2d_id,
seismic_dataset_2d.NAME seismic_dataset_name,
seismic_processing_act.INSERT_DATE,
seismic_processing_act.INSERT_USER,
seismic_processing_act.PRODUCED_BY,
seismic_processing_act.SDAT_LABEL,
seismic_processing_act.UPDATE_DATE,
seismic_processing_act.UPDATE_USER,
seismic_processing_act.EXISTENCE_KIND,
seismic_processing_act.GUID,
seismic_processing_act.ID,
seismic_processing_act.VERSION,
seismic_processing_act.NAME,
seismic_processing_act.ORIGINAL_SOURCE,
seismic_processing_act.REMARKS,
seismic_processing_act.SOURCE,
seismic_processing_act.ACTIVITY_STATE,
seismic_processing_act.ACTIVITY_TEMPLATE_ID,
seismic_processing_act.END_DATE,
seismic_processing_act.EXTERNAL_REFERENCE,
seismic_processing_act.INTERNAL_REFERENCE,
seismic_processing_act.PURPOSE,
seismic_processing_act.START_DATE,
seismic_processing_act.TRANSIENT_PERIOD,
seismic_processing_act.TRIGGERING_EVENT_ID,
seismic_processing_act.CONTRACT_NUMBER,
seismic_processing_act.PROCESSING_CENTER,
seismic_processing_act.PROCESSING_GROUP
FROM seismic_processing_act,
Seismic_DS_Processing,
seismic_dataset_2d,
alternative_navigation,
seismic_line
WHERE seismic_processing_act.ID = Seismic_DS_Processing.seismic_processing_act_id
AND Seismic_DS_Processing.seismic_dataset_id = seismic_dataset_2d.ID
AND seismic_dataset_2d.alternative_navigation_id = alternative_navigation.ID
AND seismic_line.ID = alternative_navigation.seismic_line_id)
|