| Name | Company_Survey |
|---|---|
| Entity Type | ObjectView |
| Description | PSS 2013.1 Company_Survey DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| ACQUISITION_END_DATE | DATE | NA |
_ | No |
DATE |
| ACQUISITION_START_DATE | DATE | NA |
_ | No |
DATE |
| ALT_SURVEY_NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| COMMENTS | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| CONTRACTOR | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| CONTRACTOR_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| COUNTRY_NAME | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| DTI_SURVEY_REF | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| EPSG_CODE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| ID | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| INSERT_DATE | DATE | NA |
_ | No |
DATE |
| INSERT_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| REASON_UPDATED | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| RECORD_LENGTH | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| SURVEY_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| SURVEY_NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| SURVEY_SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| SURVEY_TYPE | STRING4 | NA |
_ | No |
VARCHAR2(4) |
| UNIQUE_ID | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| UPDATE_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
CREATE OR REPLACE FORCE VIEW Company_Survey(ID, UNIQUE_ID, SURVEY_TYPE, SURVEY_SOURCE, CONTRACTOR, CONTRACTOR_ID, SURVEY_ID, SURVEY_NAME, COUNTRY_NAME, ALT_SURVEY_NAME, COMMENTS, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, ACQUISITION_START_DATE, ACQUISITION_END_DATE, RECORD_LENGTH, EPSG_CODE, DTI_SURVEY_REF, REASON_UPDATED) AS SELECT ba_contractor.ID||'_'||srv.NAME as ID, ba_contractor.ID||'_'||srv.NAME, '2D' survey_type, srv.SOURCE, ba_contractor.NAME contractor,
ba_contractor.ID contractor_id, srv.ID, srv.NAME survey_name,
srv.country_name, srv.survey_project_name alt_survey_name,
srv.remarks comments, srv.insert_date, srv.insert_user,
srv.update_date, srv.update_user,
acq.start_date acquisition_start_date,
acq.end_date acquisition_end_date, acq.record_length,
acq.navigation_system epsg_code,
acq.external_reference dti_survey_ref, acq.remarks reason_updated
FROM survey_2d_ srv,
acquisition_2d_ acq,
(SELECT ab.activity_id, cmp.NAME, cmp.ID
FROM activity_ba_invl_ ab, company cmp
WHERE ab.activity_tbl = 'Acquisition_2D'
AND ab.activity_role = 'Seismic Survey Operator'
AND ab.business_associate_id = cmp.ID) ba_contractor
WHERE acq.survey_2d_id = srv.ID AND ba_contractor.activity_id = acq.ID
UNION
SELECT ba_contractor.ID||'_'||srv.NAME as ID, ba_contractor.ID||'_'||srv.NAME, '3D' survey_type, srv.SOURCE, ba_contractor.NAME contractor,
ba_contractor.ID contractor_id, srv.ID, srv.NAME survey_name,
srv.country_name, srv.survey_project_name alt_survey_name,
srv.remarks comments, srv.insert_date, srv.insert_user,
srv.update_date, srv.update_user,
acq.start_date acquisition_start_date,
acq.end_date acquisition_end_date, acq.record_length,
acq.navigation_system epsg_code,
acq.external_reference dti_survey_ref,
acq.remarks reason_updated
FROM survey_3d_ srv,
acquisition_3d_ acq,
(SELECT ab.activity_id, cmp.NAME, cmp.ID
FROM activity_ba_invl_ ab, company cmp
WHERE ab.activity_tbl = 'Acquisition_3D'
AND ab.activity_role = 'Seismic Survey Operator'
AND ab.business_associate_id = cmp.ID) ba_contractor
WHERE acq.survey_3d_id = srv.ID AND ba_contractor.activity_id = acq.ID
|