| Name | Seismic_Survey_2D_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. A survey, performed on land or on sea in 2D mode is an exploration activity of acquiring, processing, and/or interpreting seismic data. The Seismic Survey 2D DOV provides basic information about a seismic survey such as the owner of the data and the area where the survey took place. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Application_Project_Id | Application_Project |
READ ONLY: Unique identifier for the Application Project. | No |
NUMBER(38) |
| Application_Project_Name | ENTITY_NAME NA |
The name given to any object or data item, e.g. Name of Well, Name of Field, etc. | No |
VARCHAR2(255) |
| Id | ID No_Unit |
Unique identifier for this entity. | Yes |
NUMBER(38) |
| Insert_Date | DATE NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| License_Holder_Id | Company |
READ ONLY: Unique identifier for the License Holder Company. | No |
NUMBER(38) |
| License_Holder_Name | ENTITY_NAME NA |
The name of the owner (i.e., the license holder) of the survey. | No |
VARCHAR2(255) |
| Project_Datastore_Id | Project_Datastore |
READ ONLY: Unique identifier for the Project Datastore. | No |
NUMBER(38) |
| Project_Datastore_Name | ENTITY_NAME NA |
The name of a database of the seismic data belonging to the interpretation project. | No |
VARCHAR2(255) |
| Remarks | REMARKS_STR NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Survey_Area_Name | STRING255 NA |
Area where the survey has been conducted. Examples: "Gulf of MEXICO", "North Sea" , "Western Australia" etc. | No |
VARCHAR2(255) |
| Survey_CRS | CODE |
READ ONLY: The projected or geographic CRS code of the Coordinate System for this survey | No |
VARCHAR2(64) |
| Survey_CRS_Id | Coordinate_System |
Unique identifier for the coordinate system | No |
NUMBER(38) |
| Survey_CRS_Name | ENTITY_NAME NA |
READ ONLY: The spelled-out name for the projected or geographic CRS code of the Coordinate System for this survey | No |
VARCHAR2(255) |
| Survey_Name | ENTITY_NAME NA |
The name given to any object or data item, e.g. Name of Well, Name of Field, etc. | Yes |
VARCHAR2(255) |
| Survey_Project_Name | STRING255 NA |
Project name given for the seismic survey at the time of acquisition. | No |
VARCHAR2(255) |
| Survey_Prospect_Name | STRING255 NA |
Prospect name for the survey. This further identifies the survey region. | No |
VARCHAR2(255) |
| Survey_Unique_Locator | FILE_NAME_STR NA |
Unique identifier to locate interpretation application project 3D survey. | No |
VARCHAR2(999) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Survey_CRS | Coordinate_System | Unique identifier for the coordinate system | Nullify | No |
| Application_Project | Application_Project | READ ONLY: Unique identifier for the Application Project. | Nullify | No |
| Project_Datastore | Project_Datastore | READ ONLY: Unique identifier for the Project Datastore. | Nullify | No |
| License_Holder | Company | READ ONLY: Unique identifier for the License Holder Company. | Nullify | No |
CREATE OR REPLACE VIEW Seismic_Survey_2D_DOV(ID, SURVEY_NAME, SURVEY_AREA_NAME, SURVEY_CRS_ID, SURVEY_CRS, SURVEY_CRS_NAME, SURVEY_PROJECT_NAME, SURVEY_PROSPECT_NAME, SURVEY_UNIQUE_LOCATOR, LICENSE_HOLDER_NAME, PROJECT_DATASTORE_NAME, APPLICATION_PROJECT_NAME, REMARKS, INSERT_DATE, INSERT_USER, LICENSE_HOLDER_ID, PROJECT_DATASTORE_ID, APPLICATION_PROJECT_ID) AS select s2.id Id,
s2.Name Survey_Name,
s2.Survey_Area_Name Survey_Area_Name,
s2.Survey_CRS_Id Survey_CRS_Id,
cs.CRS Survey_CRS,
crs.Name Survey_CRS_Name,
s2.Survey_Project_Name Survey_Project_Name,
s2.Survey_Prospect_Name Survey_Prospect_Name,
s2.Survey_Unique_Locator Survey_Unique_Locator,
co.Name License_Holder_Name,
pds.Name Project_Datastore_Name,
ap.Name
Application_Project_Name,
s2.Remarks Remarks,
s2.Insert_Date Insert_Date,
s2.Insert_User Insert_User,
co.Id License_Holder_Id,
pds.Id Project_Datastore_Id,
ap.Id Application_Project_Id
from Survey_2D s2,
Company co,
Application_Project ap,
Project_Datastore pds,
Coordinate_System cs,
R_Coordinate_Ref_System crs
where s2.License_Holder_Id = co.id (+)
and s2.Survey_CRS_Id = cs.Id (+)
and cs.CRS = crs.code (+)
and s2.Application_Project_Id = ap.Id(+)
and ap.Project_Datastore_Id = pds.Id (+)
|